The course will be beneficial for new and experienced practitioners.
Participants will enhance their ability to navigate Microsoft Excel, refresh / enhance their accounting and finance knowledge and gain an understanding of key drivers for the construction of financial models.
The financial modeling course allows participants to construct a circular 3‐statement financial model of a public company. Participants will gain exposure to shortcuts and efficiencies to enhance their ability to navigate in Microsoft Excel. Further, participants will learn how to leverage an annual report of a publicly traded company to construct a financial model and discounted cash flows analysis.
Construction of a 3‐Statement Financial Model including the following topics and schedules: Excel shortcuts, efficiencies and best practices
Analyzing a 10‐K
Normalizing income statement
Analyzing and modeling the balance sheet (historical and projected)
Developing cash flow statement projections
Analyzing working capital and discussing cash conversion cycles
Analyzing the relationship between depreciation, capital expenditures and PP&E projections
Projecting definite-life intangibles
Discussing the concept of cash flow neutrality