FMVA study plan

Journalize 40 adjusting and closing entries from a raw trial balance with zero sign errors

Reconcile a deferred revenue schedule and a bank statement back to the general ledger

Build a three-statement link (income statement, balance sheet, cash flow) where every line is a formula, not a hardcode

Drill 12 core Excel functions (INDEX/MATCH, SUMIFS, XLOOKUP, IFERROR, CHOOSE, OFFSET) on a single practice sheet

Structure a model into Inputs / Calculations / Outputs tabs with a consistent color-coding convention documented on a cover sheet

Build a monthly revenue engine driven by volume, price, and churn inputs with no hardcoded growth rates

Construct a debt schedule with a cash sweep and avoid circular references by calculating interest on average balance

Wire a single-cell scenario switch (Base / Upside / Downside) driving all assumptions

Insert a balance-check row and an error trap covering the entire workbook

Compute unlevered free cash flow from the week-2 model and reconcile it to NOPAT + D&A - capex - change in net working capital

Build a DCF with mid-year convention and two terminal value methods (perpetuity growth and exit multiple) side by side

Calculate WACC from comparable betas, relever for target capital structure, and apply the after-tax cost of debt

Assemble a trading comps set with six multiples and benchmark the DCF output against it

Solve 15 NPV / IRR / payback problems by hand and cross-check each with XNPV and XIRR

Derive a company's cost of capital from its capital structure and defend every assumption in writing

Run a lease-versus-buy and a project-financing decision through the capital budgeting framework

Rank three competing projects by NPV under a capital constraint

Build a 12-month departmental budget driven by headcount and cost-per-head assumptions

Decompose budget-versus-actual variance into price, volume, and mix components

Forecast a 13-week direct cash flow and identify the liquidity trough week

Document every assumption on a single assumptions register page

Run Porter's Five Forces and a SWOT on a real company, then translate the output into three quantified strategic options

Model unit economics (CAC, LTV, payback period) and stress-test the growth thesis

Evaluate an all-stock acquisition for accretion or dilution to EPS and flag the breakeven synergy figure

Assess build-versus-buy against the options already modelled

Redesign five existing charts into the correct form for the data: waterfall, football field, tornado, bridge, and mekko

Apply one formatting standard across all slides: single accent color, no gridlines, direct data labels

Rewrite every slide title as a full-sentence takeaway and cut words per slide by half

Build an executive summary page carrying the three key messages

Sit two timed full-length practice exams and log every miss by domain

Re-solve unaided the ten questions you got wrong most often

Rebuild the DCF from a blank workbook in under 60 minutes

Review the error log to confirm no domain remains below 70 percent