Corporate Finance & ValuationFinancial Statements & Ratio Analysis
Read an income statement and balance sheet, then calculate the ratios analysts use, on a live spreadsheet.
IntermediateCertificate$9.99
Corporate Finance & Valuation
Corporate finance and valuation, built by you
Financial models earn trust when every line can be traced. In these courses you construct them line by line: ratios from real statements, a linked three-statement model, a discounted cash-flow valuation, a leveraged buyout. Each formula is checked as you enter it, and the checker recalculates with changed inputs, so a model that only works for one set of numbers does not pass.
Beyond the modelling core, 46 courses cover budgeting and 13-week cash forecasts, fixed income and swaps, credit risk and scorecards, bank capital and ALM, treasury and FX, project finance, private equity and venture capital, restructuring waterfalls and sustainable finance. They suit analysts, students preparing for finance roles and founders who want to understand the numbers investors will ask about.
Courses in Corporate Finance & Valuation
Corporate Finance & Valuation
Corporate Finance & ValuationFinancial Modeling & DCF Valuation
Build a forecast, free cash flows, WACC, terminal value and a full DCF with sensitivity table, every cell checked live.
IntermediateCertificate$9.99
Corporate Finance & ValuationBudgeting & 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.
IntermediateCertificate$9.99
Corporate Finance & ValuationCorporate 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.
IntermediateCertificate$9.99
Corporate Finance & ValuationInvestment 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.
AdvancedCertificate$9.99
Corporate Finance & ValuationCredit & 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.
IntermediateCertificate$9.99
Corporate Finance & ValuationBanking & 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.
IntermediateCertificate$9.99
Corporate Finance & ValuationFixed 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.
IntermediateCertificate$9.99
Corporate Finance & ValuationThree-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.
IntermediateCertificate$9.99
Corporate Finance & ValuationPrivate 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.
IntermediateCertificate$9.99
Corporate Finance & ValuationTreasury, 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.
IntermediateCertificate$9.99
Corporate Finance & ValuationIslamic Finance Math: Murabaha, Ijara, Musharaka & Sukuk
Calculate how murabaha, ijara, diminishing musharaka, mudaraba, sukuk, takaful and zakat work in numbers, and compare offers by their effective annual cost, every cell checked live.
IntermediateCertificate$9.99
Corporate Finance & ValuationProject Finance Modeling: Cash Flow Waterfall, DSCR & Debt Sculpting
Model a 48 MW wind farm the way lenders do: sources and uses, CFADS, debt sizing from a target DSCR, sculpted repayment, DSCR and LLCR, the cash flow waterfall with DSRA and lock-up, equity IRR and sensitivities, every cell checked live.
AdvancedCertificate$9.99
Corporate Finance & ValuationCredit Risk Modeling: PD, LGD, EAD & Expected Credit Loss
Expected loss on a loan book, EAD with conversion factors, LGD from collateral and recoveries, migration matrices to cumulative PD, 12-month vs lifetime ECL with scenarios, IFRS 9 staging, a logistic scorecard with PDO scaling and portfolio coverage: 8 labs on one bank's book.
AdvancedCertificate$9.99
Corporate Finance & ValuationBank ALM: Interest Rate Risk, Gap Analysis & Liquidity Ratios
NII and NIM with a rate/volume split, repricing gaps by time bucket, ±200 bp NII sensitivity with deposit betas, duration gap, EVE under rate shocks, LCR, NSFR and funds transfer pricing: 8 hands-on labs on one fictional bank's balance sheet.
AdvancedCertificate$9.99
Corporate Finance & ValuationInsurance Claims Reserving: Chain Ladder, Loss Ratios & IBNR
Loss, expense and combined ratios by line, cumulative triangles from incremental data, age-to-age factors, CDFs and ultimates, IBNR and case reserves, Bornhuetter-Ferguson, paid vs incurred chain ladder, tail sensitivity and discounting: 8 labs on one fictional insurer's motor book.
AdvancedCertificate$9.99
Corporate Finance & ValuationMicrofinance & Small-Loan Math: Flat vs Declining Rates, APR & Portfolio Quality
Price small loans the honest way, flat vs declining balance, APR and EIR with fees and compulsory savings, then measure repayment, PAR30/PAR90, provisions, self-sufficiency and the yield an MFI needs, every cell checked live.
IntermediateCertificate$9.99
Corporate Finance & ValuationTrade Finance: Letters of Credit, Factoring & Supply Chain Finance
Work through an export deal in numbers: Incoterms cost split, LC fees and document checks, bill discounting and forfaiting, factoring, supply chain finance, the cash conversion cycle and a weighted choice of payment method, every cell checked live.
IntermediateCertificate$9.99
Corporate Finance & ValuationPension Fund Math: DB Obligations, Funding Ratios & Liability Hedging
The DB benefit formula and projected unit credit, benefit cash flows, the liability as a present value, funding ratios and stress tests, duration vs full revaluation, recovery-plan contributions, asset return vs liability growth and an LDI hedge ratio: 8 hands-on labs on one fictional pension plan.
IntermediateCertificate$9.99
Corporate Finance & ValuationPublic Finance: Government Budgets, Deficits & Debt Sustainability
Revenue and spending as % of GDP, primary vs overall balance, debt dynamics with r and g, the debt-stabilising primary surplus, progressive tax brackets, tax elasticity forecasts, social NPV and a fiscal rules check: 8 hands-on labs on one fictional country.
IntermediateCertificate$9.99
Corporate Finance & ValuationConsumer Credit Math: Credit Cards, APR, Minimum Payments & BNPL
Turn APR into daily interest on the average daily balance, test grace periods, build minimum-payment schedules, compare avalanche vs snowball, balance transfers, BNPL late fees, personal loans and utilisation – every cell checked as you go. Educational, illustrative rates, not financial advice.
IntermediateCertificate$9.99
Corporate Finance & ValuationPayments & Fintech Economics: Interchange, MDR, Take Rates & Chargebacks
Split the merchant discount rate, compare blended and interchange-plus pricing, cost a payment mix, measure take rates in bps, price chargebacks and fraud thresholds, FX markups and a payments startup's break-even TPV – every cell checked as you go. Illustrative fees, no affiliation with any card scheme.
IntermediateCertificate$9.99
Corporate Finance & ValuationCredit Spreads & CDS Basics: Hazard Rates, Spreads & Default Probabilities
Yield spreads and the Z-spread, the credit triangle, hazard rates and survival curves, the CDS premium and protection legs, fair spreads and upfronts, mark-to-market and the CDS-bond basis: 8 labs on fictional issuers. Educational and simplified, not affiliated with ISDA.
AdvancedCertificate$9.99
Corporate Finance & ValuationInsurance Ratemaking: Pure Premium, Loss Trends & Rate Indications
Exposures and earned premium, frequency × severity, loss trend factors, development to ultimate, on-level premium, the loss ratio method, expense and profit loads and rating relativities: 8 labs pricing a fictional auto insurer. Educational, not affiliated with the CAS.
AdvancedCertificate$9.99
Corporate Finance & ValuationRevenue-Based Financing & Venture Debt: Caps, Repayment Rates and True Cost
Model RBF caps and revenue shares, build a repayment schedule, find the true annual cost with IRR, test growth sensitivity, structure venture debt with warrants, compare with equity dilution and merchant cash advances, then score the options, every cell checked.
IntermediateCertificate$9.99
Corporate Finance & ValuationBank Loan Pricing: Funding Cost, Expected Loss, Capital & RAROC
Build a loan rate from funding, operating cost, expected loss, capital and margin, model expected loss year by year, size economic capital, calculate RAROC, solve for the minimum rate, price the whole relationship, fill a rating × tenor grid and run a credit committee, every cell checked.
AdvancedCertificate$9.99
Corporate Finance & ValuationGreen Bonds & Sustainable Finance: Use of Proceeds, Greenium & Impact Metrics
Price a green bond against its conventional twin, measure the greenium in basis points, track use of proceeds, attribute impact per USD million, model a sustainability-linked coupon step-up, compute WACI and an illustrative alignment score, and chart a bank's green lending, every cell checked live. Fictional issuers, educational only, not investment advice.
IntermediateCertificate$9.99
Corporate Finance & ValuationCorporate Treasury: Cash Pooling, Intercompany Netting & Liquidity Forecasting
Run the in-house bank of a fictional group with five subsidiaries in USD, EUR and GBP: stand-alone vs notional pool interest, zero-balancing sweeps and IC loans, a multilateral netting matrix with FX at the netting rate, the savings, a 13-week cash forecast and revolver headroom, every cell checked as you go. Illustrative rates, educational only.
AdvancedCertificate$9.99
Corporate Finance & ValuationRestructuring & Bankruptcy Math: Recovery Waterfalls, Absolute Priority & Plan Value
Work through a fictional retailer's Chapter 11 case in numbers: liquidation value, the claims stack, an absolute priority waterfall, recoveries by class, deficiency claims, reorganisation value vs liquidation, plan distributions and the fulcrum security, every cell checked as you go. Simplified and educational, not legal or investment advice.
AdvancedCertificate$9.99
Corporate Finance & ValuationEquipment Leasing & Finance: Lessor Yield, Residual Value & Lease-vs-Loan
Price equipment leases like a lessor: payments with residuals in advance, implicit yield with fees, residual risk, after-tax lease vs loan vs cash, credit loss and margin, portfolio concentration, payoff quotes and end-of-term options, on live auto-graded spreadsheets.
IntermediateCertificate$9.99
Corporate Finance & ValuationMunicipal Bonds: Tax-Equivalent Yield, Credit & Call Risk
Tax-equivalent yield with federal and state rates, the break-even tax bracket, yield to maturity, yield to call and yield to worst with RATE, GO vs revenue bond coverage, credit spreads by rating, the de minimis rule and an after-tax muni vs corporate vs Treasury chart, every cell checked live. Fictional issuers, illustrative tax rates, educational only, not investment or tax advice.
IntermediateCertificate$9.99
Corporate Finance & ValuationStudent Loan Repayment Math: Standard, Graduated & Income-Based Plans
Accrue interest while studying and capitalise it, price the standard 10-year plan with PMT, solve a graduated plan, model income-driven payments and forgiveness, test extra payments with NPER, weigh refinancing against lost protections and chart the total cost of every plan, every cell checked. Illustrative rules, check your servicer. Not financial advice.
IntermediateCertificate$9.99
Corporate Finance & ValuationBank Capital Ratios: Risk-Weighted Assets, CET1, Buffers & Leverage
Look up risk weights and build RWA, convert off-balance items with CCFs, assemble CET1, Tier 1 and total capital with deductions, test the ratios against the minimums and buffers, find the distance to the MDA trigger, compute the leverage ratio, plan capital for three years and run a stress scenario, every cell checked. Simplified Basel III-style teaching model.
AdvancedCertificate$9.99
Corporate Finance & ValuationDividends & Share Buybacks: Payout Policy, Yields & EPS Effects
Sit in the CFO's chair of a fictional manufacturer: payout and retention, dividend and FCF cover, sustainable growth, buyback EPS accretion, buyback vs dividend, buyback price vs value, Lintner smoothing and a payout capacity dashboard, every cell checked live. Educational only, not investment advice.
IntermediateCertificate$9.99
Corporate Finance & ValuationESG Ratings Methodology: Indicators, Normalisation, Weights & Scores
Build an ESG rating the way analysts do: check data coverage, normalise raw indicators (min-max, z-score, percentile rank), flip lower-is-better metrics, roll them up into E, S and G pillars with sector materiality weights, deduct controversies, map scores to letter grades and test how weights and a second method change the result. Fictional companies, educational only, not investment advice; no affiliation with any rating provider.
IntermediateCertificate$9.99
Corporate Finance & ValuationConvertible Bonds: Conversion Value, Premium, Bond Floor & Dilution
Conversion ratio and parity, conversion premium and payback, the bond floor with PV and PRICE, the investment premium and payoff chart, bond + Black-Scholes call valuation, the issuer’s cost and IFRS-style liability/equity split, dilution and if-converted EPS, calls, puts and forced conversion: 8 labs on one fictional issuer (educational, not investment advice).
AdvancedCertificate$9.99
Corporate Finance & ValuationInterest Rate Swaps: Pricing, Valuation, DV01 & Hedging
Swap cash flows and day counts, bootstrapping discount factors, forward rates, the par swap rate, mark-to-market, DV01 and hedging a floating-rate loan with a swap or a cap: 8 hands-on labs on an illustrative single curve. Educational only, not investment advice.
AdvancedCertificate$9.99
Corporate Finance & Valuation13-Week Cash Flow Forecast: Receipts, Disbursements, Liquidity & Variance
Week calendar and opening cash, receipts from the AR ageing, other receipts, payroll, rent and suppliers, the revolver with MAX/MIN, covenant headroom, weekly variances and scenario levers: 8 labs on one wholesaler under pressure.
IntermediateCertificate$9.99
Corporate Finance & ValuationReal Options Valuation: Binomial Trees for Expand, Delay & Abandon Decisions
Value managerial flexibility like a corporate-finance pro: static vs expanded NPV, CRR binomial parameters, the underlying value tree, and the options to delay, expand, abandon and invest in stages, with a volatility sensitivity and summary charts, in 8 graded labs on one fictional copper mine.
AdvancedCertificate$9.99
Corporate Finance & ValuationComparable Company Analysis: Trading Comps, Multiples & Precedent Transactions
Value a company like an equity analyst: screen a peer set, bridge equity value to EV with the treasury stock method, calendarise LTM figures, summarise multiples without outliers, apply them to the target, add precedent deals and control premiums, draw the football field and sanity-check with a growth regression, in 8 graded labs.
AdvancedCertificate$9.99
Corporate Finance & ValuationCredit Card Issuer Economics: Interchange, Revolve Rates, Losses & Rewards Cost
Run the P&L of a fictional card issuer: active rate and spend per account, interchange by category, revolving balances and net interest margin, fees, charge-offs and provisions, rewards cost with breakage, profit of transactors vs revolvers and the lifetime value of a new account – every cell checked as you go.
IntermediateCertificate$9.99
Corporate Finance & ValuationWealth Advisory Practice Economics: AUM Fees, Client Profitability & Practice Value
Run the numbers of a fictional advisory firm: tiered AUM fee schedules, revenue from market growth and net flows, client segments and minimum fees, advisor capacity, profit per client, fee compression, the practice P&L and what the firm is worth – every cell checked as you go.
IntermediateCertificate$9.99
Corporate Finance & ValuationInvoice Factoring & Supply Chain Finance: Advance Rates, Fees & Effective Cost
Invoice ageing and eligible receivables, concentration limits, advance and reserve, discount fees per 30 days and service fees, the effective annual cost with a chart, recourse vs non-recourse expected loss, reverse factoring at the buyer’s credit rate, dynamic discounting returns and an all-in comparison of overdraft, factoring and SCF: 8 graded labs on one fictional packaging SME.
IntermediateCertificate$9.99
Corporate Finance & ValuationVenture Debt: Term Sheets, Warrant Coverage, Runway & Effective Cost
Turn a venture debt term sheet into payments and runway, size warrants, find the all-in cost with IRR and XIRR, compare dilution with equity, test covenants and model a default: 8 hands-on labs with a fictional startup and lender. Educational only, not financial advice.
IntermediateCertificate$9.99
Corporate Finance & ValuationCredit Scorecards: Weight of Evidence, Information Value & Points Scaling
Coarse classing, WoE, Information Value, monotonic bins, points with factor/offset and PDO, scoring applicants, cut-off strategy and population stability: 8 hands-on labs on one fictional lender's synthetic applications.
AdvancedCertificate$9.99
Corporate Finance & Valuation
Variance Bridges for FP&A: Price, Volume, Mix, FX & Cost Effects from Budget to Actual
Explain the gap between budget and actual: price, volume, mix, currency and cost effects that add up exactly, plus the bridge chart, with every cell checked as you go.
IntermediateCertificate$9.99
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
Which order should I take the modelling courses in?
Financial statements and ratio analysis first, then the three-statement model, then DCF valuation. LBO and M&A modelling, comparable companies and real options build on all three.
Are the examples real companies?
The figures are realistic but fictional, which lets each lab isolate one idea. The methods are the ones used on real companies.
How much does a course cost?
Each course is a single purchase of $9.99. That covers every lesson and lab, the final exam and the certificate, with no subscription and nothing that renews.
More categories
Ready to learn by doing?
Start with the recommended course and build your first result in the lab today.