Financial Modeling for Corporates

Explore the spectrum of financial models—from valuation to strategy and variance, to reporting and budget and cash models—with yearly to daily time frames and applications for investors, boards, and banks.

This training builds models from the bottom up, linking price and volume to revenue, and layering debt, depreciation, and tax into a full valuation and reporting framework.

Understand the components of a corporate finance model, from inputs and timing to operations, accounting, and financing. Learn how depreciation, tax, and actuals integrate into financial statements and valuation.

Build a complete model from scratch, apply the 80/20 rule to value drivers, and develop higher-level skills for rapid, effective financial modeling for corporates.

Define the model type and timeframe, optimize for one or two outcomes, stay simple, test relentlessly, and focus on value drivers per the 80/20 rule.

Balance depth and breadth to control model complexity, apply the least granular periodicity (annual if possible), and manage multiple business units, geographies, and integrating actuals.

Learn to recognize and fix worst practices in financial models, and apply best practice infrastructure, clear inputs, consistent timelines, and purposeful styling for transparent, flexible corporate models.

Learn the financial model infrastructure by examining the start template and the ready modules, mastering tools such as named ranges and data validation, and reviewing the inputs page in detail.

Explore the start model's cover page, tabs, and underlying infrastructure. Review the cash flow waterfall, statements, and key metrics including revenue, costs, capex, working capital, taxes, depreciation, and valuation.

Explore the inputs page, configuring timing, North America operations, and revenue drivers; use data validation and named ranges to manage price escalations, scenarios, capex, debt, tax, and valuation.

Learn to build a financial model with a setup page of fixed inputs including millions and thousands, named ranges, and template infrastructure using cell styles for consistency and transparency.

Explore the timing module to learn the typical timing infrastructure and key month and year functions, plus shortcuts to speed up modelling. Develop escalation and create a timing template.

Build timing page with end-of-month logic and twelve months from the model start, linking actuals_start to forecast_start. Name model_start, actuals_start, forecast_start, and use F5 and Alt M M D shortcuts.

Master how to design a timing strip that switches between actuals and forecast, advance dates quarterly, and build robust model infrastructure using anchoring, flags, and conditional formatting.

Learn to freeze panes to lock views, then build counters for lookups for the call up formula using a calendar year framework and adjust end dates for quarterly periods.

Explore how to model price escalation from real to nominal using four profiles, base indexes, and CPI references, with a lookup-based method to spread annual rates.

Master creating a sheet template by copying sheets, grouping ranges, and linking formulas to the timing sheet to reduce errors and ensure consistent timing data.

Model revenue by category, volume, and price using lookup formulas, then calculate cost of sales, OpEx, CapEx, and working capital, converting accruals to cash flow.

Break down revenue into volume and price, apply a flex to price, and model cost of sales, lead time, fixed and variable costs, plus staff, rent, and 8% marketing.

Calculate revenue by linking forecasted volume across footwear, apparel, and equipment, apply price escalation with CPI via look up or index match, and convert units to USD revenue.

Compute cost of sales by pairing volume with price and use a two-quarter look-forward for production. Apply a simple formula, convert thousands to millions, and compare to revenue.

Explore selling and administrative costs as fixed and variable overhead, with rent as a fixed cost and CPI-based escalation. Use look-up methods and anchoring to forecast costs over time.

Learn how variable costs respond to drivers like revenue or staff, compute per-driver costs, and derive total op ex by multiplying inputs and using the nominal value.

Explore capital expenditure concepts, distinguishing capex from opex, explaining capitalization and depreciation, with a footwear business example and transparency in modeling cash flows, timing, and escalation.

Model working capital in a corporate setting by comparing the days delay, offset with flags, and a sum product approach to timing cash receipts with accrual revenue.

Convert accruals to cash for working capital by valuing inventory, comparing cost of production to cost of sales, and tracking opening and closing balances with the corkscrew account.

Model debtors with the days delay method, using 45-day wholesaler terms and immediate retailer payments, and optionally split revenue by customer type for margins and valuation.

Modeling working capital adjustments for creditors and net working capital in cash flow statements. Link payment terms, OpEx, and production costs to reconcile revenue on a cash basis.

Explore cash flow statement and cash flow waterfall, define net cash flow and closing cash balance, and connect operating, investing, and financing activities to the income statement and balance sheet.

Link revenue to the cash flow model by connecting revenue and cost of sales to the operating cash flow, applying sign conventions, and incorporating capex and debt considerations.

Model debt and equity financing in a combined financing tab, covering senior and subordinated debt, interest and principal repayments, debt ratios, equity distributions, and repayment methods like bullet and annuity.

Learn how to model financing inputs by configuring debt and equity, choosing repayment styles (bullet or annuity), locking fixed rates, and using scenario manager for rate flex.

Convert the annual interest rate to a period rate using pro rating and day-count conventions (360 or 365). Demonstrate with a 5 billion debt and 50 million quarterly interest.

Examine bullet repayment and debt service by refinancing to an interest-only loan, and implement an applied structure with annuity vs applied options using data validation, choose, and index for matching.

Learn to calculate debt metrics—interest coverage, debt service coverage, and gearing—using cash flow, balance sheet data, and build all three ratios into the model.

Calculate the interest coverage ratio and DSCR from cash flow available for debt service using the cash flow waterfall, while applying a text fallback for zero actuals.

Model equity cash flows by building cash flow waterfall for share capital and distributions, linking debt service to free cash flow to equity, and applying max logic to avoid negatives.

Link the cash flow statement by driving it from revenue through operating activities, investing and financing activities, using the indirect method and tax linkage to reconcile net cash flow.

Analyze the function and key line items of the profit and loss statement, including revenue, opex, depreciation and amortization, capex treatment, ebitda, ebit, and net profit after tax.

Model the p&l by linking revenue and cost of sales to derive gross profit, EBITDA, and net profit after tax, then trace retained earnings and equity on the balance sheet.

Explore depreciation concepts, including accounting and tax depreciation, cash effects, and how to model straight-line and accelerated methods, depreciation bases, and CapEx impacts.

Explore depreciation inputs and capex additions within a corporate financial model, comparing reporting asset categories and tax depreciation effects on cash flow and valuation, including straight-line and reducing balance methods.

Explore straight line depreciation using a dynamic depreciation base that tracks asset additions and depreciates over the usable life in quarterly steps.

Set up tax depreciation with a 10 percent reducing-balance method, link additions, and apply a write-off at the full cost end date; compare with accounting depreciation for valuation.