Objective
This Financial Modeling course will teach participants the basic of MS Excel all the way to creating successful Financial Models. It will expose participants to how to construct an integrated financial model – from scratch! They will soon be building models that are robust, provide the organization with dynamic projections that can be used to thoroughly analyze a company from multiple standpoints: operations, investment, financing and valuation.
Modules
Some of the modules we will cover include:
- Income statement, balance sheet and cash flow statement relationships
- Working capital, depreciation and capital expenditure schedules
- Intangibles amortization schedule
- Shareholders’ equity schedule with a share repurchase table
- Debt and interest schedule with a “cash sweep”
- Understanding and controlling circular references
- Strategies for balancing a model·
- Sensitivity analysis to match expected financial performance
- How to build a quick discounted cash flow analysis (DCF)
There are no reviews yet.