A good financial model facilitates and improves the reliability and quality of our business decision-making.
The financial modeling and valuation course aims to equip the delegates with knowledge and tools to develop a financial model through a case study approach. This will involve forecasting financial statements and deriving business value using advanced Excel tools.
Professionals and graduate students working or aspiring to work in the field of investment banking, private equity, corporate finance, asset valuation and equity research. Finance managers and finance controllers in all types of business enterprise.
Overview of Financial Modeling
Excel tools used in Financial Modeling including Data Tables, Nested Ifs, Index, Time Value of Money Applications
FAST standards for financial modeling
Structuring input sheet and structuring time sheet using timing flags
Modeling for assumptions and inputs
Business Structure & revenue modeling
Modeling for and projecting operating expenses
Projecting key schedules including debt/interest, depreciation, working capital and equity
Stepwise projection of income statement, balance sheet and cash flows