Overview and introduction to financial modeling
Modeling Best Practices:
- Basic Excel setup including macro security, iterations & calculations settings
- Financial modeling essentials including appropriate color schemes
- Page setup functions
- Customizing toolbars in Excel (including adding icons to your toolbar)
- Excel best practices, including common “shortcut” keys and other efficiency tips
- Navigating in Excel
- Shortcuts including autosum, advanced paste special functions, fill functionality, go to cells, repeat function, naming cells & effectively navigating between worksheets
- Excel foundations & efficiencies in formulating projections
- Fundamentals of formats including alignments & custom number formats including “text” with custom formatting
- Anchoring cells
- Understanding how to efficiently design historical inputs & forecast financial projections
Designing a Model for Finance Professionals and Consultants:
- What is a model? What question is the model meant to answer?
- Introduce the business case modeling case study
- Output-first design methodology
- Build a model design tree showing inputs, calculations and outputs
Construction and Application of:
- Core statements
- Working capital schedule
- Depreciation schedule
- Amortization schedule