Financial Modeling with Excel

Excel1This 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.

Content

  • 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