Financial Statements & Ratio Analysis
Read an income statement and balance sheet, then calculate the ratios analysts use, on a live spreadsheet.
Corporate Finance & Valuation · 12 courses
Corporate finance, valuation and financial modeling courses
These financial modeling and corporate finance courses are for people who want to build the models themselves rather than read about them. Each course works through one consistent case in a spreadsheet that checks every formula, so you learn the mechanics that interviews and analyst jobs test: how the three statements link, where free cash flow comes from, why a model balances and what drives the valuation.
Financial Statement & Ratio Analysis teaches you to read the statements, and the Three-Statement Financial Model builds one from historicals to a balancing balance sheet. Financial Modeling & DCF Valuation adds free cash flow, WACC and terminal value, and Investment Banking Modeling covers comps, precedents, LBOs and accretion/dilution. Corporate Finance covers NPV, IRR and the time value of money, Budgeting & FP&A covers master budgets and 13-week cash forecasts, and the specialist courses cover credit analysis, treasury and FX, fixed income, banking and insurance, mortgage underwriting and private equity and venture capital maths. The courses suit finance students, analysts, accountants moving into FP&A and anyone preparing for a modeling test.
Courses in Corporate Finance & Valuation
Financial Modeling & DCF Valuation
Build a forecast, free cash flows, WACC, terminal value and a full DCF with sensitivity table, every cell checked live.
Budgeting & Cash-Flow Forecasting (FP&A)
Build a full master budget, a cash budget and a 13-week forecast, then explain the variances, every cell checked as you go.
Corporate Finance & Time Value of Money
Price loans, bonds and projects yourself: FV, PV, PMT, effective rates, NPV, IRR, payback, WACC and incremental cash flows, every cell checked live.
Investment Banking Modeling: LBO & M&A
Value a company with trading comps and precedents, build an LBO from sources & uses to IRR, and test M&A accretion and synergies, every cell checked live.
Credit & Risk Analysis
Score a borrower, calculate leverage, DSCR and debt capacity, test covenants, build a borrowing base and price the risk, on live auto-graded spreadsheets.
Banking & Insurance Math
Calculate net interest margin, price a loan, run a rate-shock gap analysis, compare APYs, weight assets for capital, price insurance risk and reserve claims with the chain ladder, on live auto-graded spreadsheets.
Fixed Income & Bond Analytics
Price bonds from their cash flows, solve yields, accrued interest, spot and forward rates, duration, convexity and immunisation in a live spreadsheet, every cell checked. Educational only, not investment advice.
Three-Statement Financial Model in Excel
Build one company model from historicals to drivers, schedules, income statement, balance sheet and cash flow, with a scenario switch, every cell checked live.
Private Equity & Venture Capital Math
Value start-ups with the VC method, model dilution, liquidation preferences, notes and SAFEs, then fund fees, carry, DPI/TVPI, XIRR and the J-curve, every cell checked live.
Treasury, Cash & FX Risk Management
Cash positions, short-term forecasts, working capital, cash pooling, FX exposure, forwards, options and interest-rate swaps, practised in graded labs.
Mortgage & Loan Underwriting Math
Work through one home loan file: payment and amortization, PITI, LTV, mortgage insurance, qualifying income, DTI, APR and points, and a refinance check, with every cell checked as you go. Educational only, not financial advice.
Guides with worked examples
How to Calculate WACC in Excel: Formula & Example
Calculate WACC in Excel step by step: CAPM cost of equity, after-tax cost of debt and market-value weights, with a worked example (8.95%).
How to Build a DCF Model in Excel: Step-by-Step Example
Build a DCF model in Excel: forecast free cash flow, discount it at the WACC, add a terminal value and bridge to value per share. Worked example.
Loan Amortization Schedule in Excel: PMT, IPMT & PPMT
Build a loan amortization schedule in Excel with PMT, IPMT and PPMT: payment, interest, principal and balance per month, with a worked example.
Cash Conversion Cycle Formula: DSO, DIO & DPO Example
The cash conversion cycle formula (DSO + DIO − DPO) explained with a two-year worked example in Excel, what the days cost in cash, and how to read it.
How to Calculate IRR in Excel: IRR, XIRR and MIRR
Calculate IRR in Excel with IRR, XIRR and MIRR. Worked example with real cash flows, an NPV check and the mistakes that give wrong answers.
Current Ratio vs Quick Ratio: Formulas and Example
Current ratio vs quick ratio: both formulas, an Excel example of two firms with the same current ratio but very different liquidity, and how to read them.
Frequently asked questions
Do I need an accounting background for financial modeling?
It helps to know how the income statement, balance sheet and cash flow statement fit together. If you do not, take Bookkeeping Fundamentals or Financial Statement & Ratio Analysis first.
Will these courses prepare me for a financial modeling test?
They teach the mechanics that modeling tests check. For timed-style practice, the Career category has Financial Modeling Test Prep with a quick three-statement build, a 15-minute DCF and a paper LBO.
Are the models built in real Excel?
They are built in an Excel-like spreadsheet in your browser with the same functions and syntax, such as NPV, IRR, XNPV, PMT and INDEX/MATCH, so you can rebuild every model in Excel afterwards.
More categories
Open your first lab in under a minute
Free lessons work without an account. Sign up to save your progress.