Financial Modeling and forecasting Financial Statements Course

Lesson 1 • Spreadsheet Architecture and Layout

Covers workbook structure, tab organization, and navigation design for multi-sheet models. Proper architecture reduces errors and makes models auditable by third parties.

Lesson 2 • Formatting and Presentation Standards

Defines professional formatting conventions for numbers, fonts, and color schemes that make models readable and client-ready. Consistent formatting is applied in every subsequent chapter.

Lesson 3 • Model Auditing and Error Checking

Teaches systematic techniques to identify formula errors, broken links, and logical inconsistencies before a model is used for decisions. Directly supports model reliability throughout the course.

Lesson 4 • Essential Spreadsheet Functions for Modeling

Introduces the core formula toolkit required to build dynamic, flexible financial models. Mastery of these functions eliminates manual recalculation and supports scenario analysis.

Lesson 1 • Linkages Among the Three Statements

Maps the exact data flows connecting income statement, balance sheet, and cash flow statement. These linkages are the mechanical backbone of every integrated financial model built in this course.

Lesson 2 • Income Statement Structure and Logic

Breaks down revenue, cost, and profit line items from top-line sales to net income. Understanding income statement flow is prerequisite to forecasting every revenue and expense driver.

Lesson 3 • Analyzing Historical Financial Data

Applies ratio analysis and trend review to historical statements to extract drivers for forecasting. Structured historical analysis directly feeds the assumption-setting process in the next chapter.

Lesson 4 • Cash Flow Statement Structure and Logic

Covers the three sections of the cash flow statement and the indirect method of reconciling net income to operating cash flow. Cash flow literacy is critical for valuation and liquidity forecasting.

Lesson 1 • Working Capital Assumption Setting

Derives days-based assumptions for receivables, inventory, and payables from historical data and industry benchmarks. Working capital assumptions directly drive cash flow accuracy in the integrated model.

Lesson 2 • Cost and Expense Driver Assumptions

Distinguishes fixed, variable, and semi-variable cost behaviors and links each to the appropriate revenue or operational driver. Accurate cost modeling prevents margin distortion in multi-year forecasts.

Lesson 3 • Revenue Forecasting Methodologies

Covers top-down, bottom-up, and driver-based approaches to projecting revenue across different business models. Choosing the right method determines the credibility of the entire forecast.

Lesson 4 • Documenting and Stress-Testing Assumptions

Establishes a structured assumption log and introduces sensitivity testing to validate that key drivers produce reasonable output ranges. Documented assumptions make models auditable and defensible.

Lesson 1 • Circular References and the Revolver

Introduces the interest-debt circularity inherent in integrated models and resolves it using a revolving credit facility as the cash plug. Proper circularity handling is essential for model stability.

Lesson 2 • Model Integrity Checks and Balancing

Implements a comprehensive set of balance checks, cash reconciliations, and error flags to confirm the integrated model is mechanically correct. A model that does not balance must not be used for analysis.

Lesson 3 • Projecting the Balance Sheet

Builds asset, liability, and equity schedules driven by income statement outputs and working capital assumptions. The balance sheet must balance at every period before the model is considered complete.

Lesson 4 • Projecting the Income Statement

Applies revenue and cost assumptions from Chapter 3 to build a multi-year projected income statement with dynamic margin calculations. This is the first output sheet of the integrated model.

Lesson 1 • Monte Carlo Simulation Concepts

Introduces probabilistic forecasting by assigning distributions to key assumptions and simulating thousands of outcome paths. Monte Carlo output provides a probability-weighted view of forecast risk.

Lesson 2 • Scenario Analysis Framework

Defines base, upside, and downside scenarios and builds a toggle mechanism that switches the model between them instantly. Scenario analysis transforms a point estimate into a decision-support tool.

Lesson 3 • Presenting Scenario Results to Stakeholders

Structures scenario output into a concise executive summary that communicates range, probability, and key risks without exposing model mechanics. Effective presentation converts analysis into actionable insight.

Lesson 4 • One-Way and Two-Way Sensitivity Tables

Builds data tables that show how a single output metric changes across a range of one or two input assumptions. Sensitivity tables reveal which drivers have the greatest impact on model outputs.

Lesson 1 • Revolving Credit Facility Modeling

Models the revolver as a dynamic cash management tool that draws and repays based on minimum cash balance logic. Revolver mechanics resolve the cash plug requirement in the integrated model.

Lesson 2 • Equity Issuance and Buyback Modeling

Incorporates share issuances, buybacks, and stock-based compensation into the equity roll-forward and earnings per share calculation. Equity transactions affect both the balance sheet and shareholder return metrics.

Lesson 3 • Dividend and Distribution Modeling

Models dividend payments, payout ratios, and special distributions as a function of net income and cash availability. Dividend policy assumptions directly affect retained earnings and the equity balance.

Lesson 4 • Credit Metrics and Covenant Modeling

Calculates leverage, coverage, and liquidity ratios over the forecast period and flags covenant breaches automatically. Covenant modeling is essential for lender presentations and credit risk assessment.

Lesson 1 • Free Cash Flow Derivation for Valuation

Extracts unlevered free cash flow from the integrated model and reconciles it to the cash flow statement. Accurate free cash flow is the direct input to the DCF and determines valuation reliability.

Lesson 2 • Weighted Average Cost of Capital

Builds a WACC calculation from cost of equity, cost of debt, and target capital structure weights. WACC is the discount rate applied to free cash flows in the DCF and must be defensible to stakeholders.

Lesson 3 • Football Field Valuation Summary

Consolidates DCF, comps, and precedent transaction ranges into a football field chart for executive presentation. The football field communicates valuation uncertainty and supports negotiation positioning.

Lesson 4 • DCF Model Construction

Discounts projected free cash flows and a terminal value to derive enterprise value using the WACC. The DCF model is built directly from the integrated model outputs established in Chapter 4.

Lesson 1 • Model Automation and Dynamic Outputs

Introduces macros, dynamic named ranges, and automated chart updates to reduce manual effort in recurring model maintenance. Automation increases model scalability and reduces the risk of update errors.

Lesson 2 • Budget vs. Actual Variance Analysis

Builds a variance reporting framework that compares forecast to actual results and explains deviations by driver. Variance analysis closes the loop between forecasting and operational performance management.

Lesson 3 • Long-Range Strategic Forecasting

Extends the model horizon to five to ten years using macro-driven assumptions and mean-reversion logic for margins and growth. Long-range models support strategic planning and capital allocation decisions.

Lesson 4 • Merger and Acquisition Accretion Analysis

Builds a merger model that combines two income statements and calculates earnings per share accretion or dilution. Accretion analysis is a standard deliverable in corporate development and investment banking.