In today's world of extensive data where decisions are highly quantitative based financial modeling has become an indispensable tool. It is the most sought after skill required in the field of investment banking, equity research, project management, commercial banks and mostly all other sectors in the financial services industry. Financial modeling is the art of building a model using excel to depict financial statements and investment analysis. It builds a structure that integrates various statements and schedules to enable decision making. A financial model represents the performance of a business, a project or any other investment.
This Financial & Valuation modeling programme involves the fundamental theories and practices of valuation analysis, strategy analysis, prospective analysis, DCF modeling, trading comparables and transaction comparables. Modeling through Excel will build enough confidence in the participants so that they are able to create their own financial model right from scratch, and use it for solving their business problems. The programme is designed to offer students the intensive instruction and training needed to successfully compete in rapidly developing global financial markets.
After completing this course, the participants will be able to:
Build a financial model from scratch as done at financial institutions
Work on Excel and use formatting best practices, efficient formula construction, and appropriate driver selections
Use Advanced Excel functions to present various sensitivities to projected financial metrics
Fix circularity problems, iteration, and other common modeling troubleshooting
Cross check the Balance Sheet/ Cash Flow Statement
Understand and describe valuation and how historical valuation is done
Understand and explain the techniques, elements and approaches of forecasting
Provide an overview of Discounted Cash Flow
Explain the Dividend Discount Model
Calculate the Free Cash Flow to Firm (FCFF) & Free Cash Flow to Equity (FCFE)
Calculate the Discount Rate (Cost of Debt, Cost of Equity & Cost of Capital)