Financial Modeling: Statements, Costs & Forecasts

Coursera via Coursera

Go to class Write review

Overview

Coursera Flash Sale

40% Off Coursera Plus for 3 Months!

Grab it

Build financial models, analyze statements, calculate capital costs, and forecast revenue with scenario analysis. In this course, you’ll develop the core modeling skills used by financial analysts in corporate finance and investment settings. You’ll start by interpreting income statements, balance sheets, and cash flow statements to assess liquidity and performance. Then, you’ll calculate Weighted Average Cost of Capital (WACC), analyze cost variances, and connect financial statements into integrated three-statement models. You’ll also apply top-down and bottom-up forecasting techniques and build discounted cash flow (DCF) models with sensitivity analysis. What makes this course unique is its practical focus. You won’t just learn formulas—you’ll apply them in structured modeling exercises that mirror real analyst tasks. By the end, you’ll be able to build, test, and evaluate robust financial models with confidence.

Syllabus

Financial Statements for Liquidity Insights: Why Liquidity Matters in Financial Health

You will examine the three primary financial statements—the income statement, balance sheet, and cash flow statement—and explore how each contributes to understanding liquidity. You’ll connect key performance ratios to short-term financial stability and interpret how liquidity signals operational health.

Financial Statements for Liquidity Insights: How to Apply Liquidity Ratios to Real Data

You will calculate and interpret liquidity ratios using structured datasets to assess short-term financial health. You’ll benchmark results, evaluate performance trends, and translate numerical findings into clear business insights.

Calculate WACC: Capital Costs: Understanding the Cost of Capital

You will explore the definition and components of the weighted average cost of capital (WACC), including debt, equity, and capital structure. You’ll examine how each component influences risk, return expectations, and funding strategy.

Calculate WACC: Capital Costs: Applying WACC to Real Data

You will apply the WACC formula step by step using capital structure data. You’ll verify calculations and interpret results to evaluate investment decisions and value creation potential.

Unravel Financial Statements: Modeling Concepts: Modeling Frameworks and Their Purpose

You will compare the three-statement model and the discounted-cash-flow model to understand how each supports different financial decisions. You’ll identify when to use each framework based on operational analysis or valuation needs.

Unravel Financial Statements: Modeling Concepts: Linking Financial Statements and Forecasting Cash Flow

You will apply accounting principles to link the income statement, balance sheet, and cash flow statement within an integrated model. You’ll test how changes in assumptions affect cash flow and financial projections

Analyze and Highlight Cost Variances Effectively: Decode and Interpret Cost Variances

You will break down price, quantity, and mix variances to understand how cost deviations occur. You’ll interpret variance outcomes and determine which differences require management attention.

Analyze and Highlight Cost Variances Effectively: Apply and Communicate Material Cost Variances

You will apply standard cost formulas to calculate material cost variances using real-world templates. You’ll highlight unfavorable variances and communicate their implications for cost control and forecasting.

Forecast Revenue: Scenario Analysis: Forecasting Foundations: Top-Down vs. Bottom-Up

You will compare top-down and bottom-up forecasting methods to understand how projections are built from market-level versus operational data. You’ll evaluate when each approach is most appropriate for strategic planning.

Forecast Revenue: Scenario Analysis: Scenario Analysis in Action

You will apply scenario analysis to build optimistic, base, and pessimistic revenue forecasts. You’ll create a three-case model and summarize findings in a visual chart to communicate risk and opportunity clearly.

Build and Evaluate Robust Financial Models: Building the Core: Constructing a Dynamic DCF Model

You will construct a dynamic discounted cash flow model that incorporates sensitivity tables for WACC, growth rates, and terminal value. You’ll test how changes in assumptions influence enterprise value and model outputs

Build and Evaluate Robust Financial Models: Evaluating Model Integrity: Model Audit and Best Practices

You will evaluate a financial model for technical accuracy, logical consistency, and adherence to modeling standards. You’ll trace formulas, audit linkages, and identify risks that affect credibility and decision-readiness.