This course aims to give participants an opportunity to have hands-on experience of financial modeling by blending accounting, corporate finance and excel skills. Financial models are one of the most widely used techniques to calculate, forecast or estimate various financial situations and scenarios. Building a robust financial model helps professionals in gaining deeper understanding of various financial outcomes of their business and hence making better and informed decisions.
Duration:
3 days
For Whom:
Management and finance professionals, accountants and analysts.
- Introduction to advanced features of Excel
- Profit and loss forecast and projections
- Cash flow forecast and projections
- Balance Sheet construction and forecast
- Break-even analysis
- Data validation and protection of your model
- Capital budgeting formulas and functions
- Banking models and loan calculators
- What-if-analysis
- Performing macros to automate a financial model
