This module focuses on the operational expenditure elements that influence profitability within a financial model. Learners will explore techniques to project SG&A expenses using rational, defensible assumptions and link those expenses with revenue in a structured income statement. The module also covers key asset components such as Gross PPE and capital expenditures, introducing the logic of depreciation and segment-wise Capex forecasting. By the end of this module, learners will be able to structure interconnected expense and asset flows within a cohesive financial framework.

This module builds on capital expenditure modeling by introducing learners to the concepts and calculations behind depreciation and amortization in financial forecasting. It begins with deriving capital expenditures from PPE values and walks through asset-specific depreciation schedules, including machinery and automobiles. The module then transitions into amortization of intangible assets and explains how these non-cash expenses are linked into financial statements. By the end, learners will understand how to generate, validate, and integrate depreciation and amortization schedules into a comprehensive financial model.

This module introduces learners to the process of constructing the cash flow statement and managing working capital within a financial model. It begins by guiding learners through the indirect method of building the cash flow statement using data from the income statement and balance sheet. The module then transitions into the fundamentals of working capital — including its components, historical linkage, and forecasting logic — culminating in the understanding of the cash conversion cycle and the impact of changes in current assets and liabilities on overall cash flow. By the end of the module, learners will be equipped to analyze, project, and integrate working capital effectively in dynamic financial models.

This module focuses on modeling equity and debt-related components of a financial model, particularly the capital structure. Learners begin by forecasting share repurchase activities and understanding their effect on treasury stock and shares outstanding. The module then transitions into handling other assets and liabilities, projecting debt balances, and computing interest income and expense. It concludes with integrating these elements into the income statement, balance sheet, and cash flow statement. By the end of the module, learners will be able to structure and link equity and financing assumptions across financial reports to ensure consistency and accuracy.

This module introduces learners to valuation fundamentals with a focus on the Discounted Cash Flow (DCF) method. It begins by ensuring the model is structurally sound using a dashboard review, then transitions into DCF mechanics—covering Free Cash Flow to the Firm (FCFF), backward calculation methods, and Free Cash Flow to Equity (FCFE). The module emphasizes the significance of forecasting cash flows, understanding capital structure adjustments, and interpreting Net Operating Profit After Tax (NOPAT) to derive firm and equity value. Learners complete the module with a foundational ability to apply and evaluate a DCF valuation in practical financial models.

This module builds upon foundational valuation techniques and introduces advanced applications critical for equity valuation. It focuses on completing the DCF (Discounted Cash Flow) model by aligning enterprise value with equity value and interpreting capital structure implications. Learners explore the derivation and interpretation of Beta, risk-free rate, cost of capital, and WACC (Weighted Average Cost of Capital), enabling them to assess investment risk and accurately estimate the value of a business. Through hands-on integration of market-based inputs and theoretical principles, this module reinforces precision in financial model assumptions and valuation outputs.

This module provides a comprehensive understanding of final valuation outputs and their practical interpretations. Learners explore how to derive enterprise value and share price from DCF models and apply comparative valuation techniques using market multiples such as EV/Revenue and EV/EBITDA. The module emphasizes how to bridge intrinsic valuation with relative benchmarks and equips learners with the tools to evaluate company value through both forecast-driven and market-driven approaches. This dual approach strengthens analytical skills necessary for real-world valuation scenarios.