Basic Financial Modeling & forecasting
May 15, 2019
A financial model is simply a tool that’s built in Excel to forecast a business’ financial performance into the future. The forecast is typically based on the company’s historical performance, assumptions about the future, and requires preparing an income statement, balance sheet, cash flow statement and supporting schedules (known as a 3 statement model). From there, more advanced types of models can be built such as discounted cash flow analysis (DCF model), leveraged-buyout (LBO), mergers and acquisitions (M&A), and sensitivity analysis.
You will learn:
- Raising capital (debt and/or equity)
- Making acquisitions (businesses and/or assets)
- Growing the business organically (i.e. opening new stores, entering new markets, etc.)
- Selling or divesting assets and business units
- Budgeting and forecasting (planning for the years ahead)
- Capital allocation (priority of which projects to invest in)
Let our experts show you how to get the best from your responsibilities; we have helped over 2,000 professionals achieve the Mastery.