Free Excel models

How the models work

Every workbook opens filled in with the worked example from its guide, so you can see the calculation before you replace the figures with your own. Cells you type in are blue on yellow, formulas are visible, there are no macros and nothing to install. They are free to use for your own work; see the terms for reuse. If a model opens oddly or needs a feature, email us with the file name.

Accounting standards

IFRS and US GAAP: 21 workbooks, from the IFRS 18 statement mapper to the lease calculator and the difference reconciler.

• IFRS 18 income statement mapperExcel downloadList your income and expense lines, pick a category for each, and get the IFRS 18 statement with its required subtotals.Used in IFRS 18 explained: what changes and when and IFRS 18 vs IAS 1: the differences that matter.
• MPM reconciliation templateExcel downloadReconcile an adjusted profit measure to operating profit, with the tax and non-controlling interest effect of each adjustment.Used in Management-defined performance measures (MPMs) under IFRS 18 and IFRS 18 implementation checklist: what to do and in what order.
• Comparatives restatement workbookExcel downloadRestate the comparative year from IAS 1 to IFRS 18 and produce the line-by-line transition reconciliation.Used in IFRS 18 vs IAS 1: the differences that matter and IFRS 18 transition: dates, restated comparatives and the reconciliation.
• Cash flow statement templateExcel downloadAn indirect-method cash flow statement that starts from operating profit, with a working capital sheet and interest and dividends in their new sections.Used in ASC 230 cash flows explained and IAS 7 statement of cash flows explained.
• Revenue allocation calculatorExcel downloadAllocate a contract price across obligations, estimate variable consideration, measure progress on long contracts and build the monthly revenue schedule. IFRS 15 and ASC 606.Used in ASC 606 revenue recognition explained and The ASC 606 five-step model with examples.
• Effective interest calculatorExcel downloadThe effective interest rate from a loan's cash flows, the amortised cost schedule, and the 10% test for modifications. IFRS 9.Used in Debt modifications and extinguishments under ASC 470 and Amortised cost and the effective interest method under IFRS 9.
• ECL provision matrixExcel downloadExpected credit losses: loss rates from history, a provision matrix for receivables, and a three-stage calculator with weighted scenarios. IFRS 9.Used in CECL for trade receivables and IFRS 9 ECL vs CECL: credit loss differences.
• Deferred tax calculatorExcel downloadTemporary differences, deferred tax assets and liabilities with the recoverability test, accelerated tax depreciation, and the tax rate reconciliation. IAS 12.Used in ASC 740 income taxes explained and Deferred taxes under ASC 740.
• Impairment test modelExcel downloadValue in use with a terminal value, the IAS 36 impairment test with goodwill allocated first, a sensitivity grid, and the US GAAP goodwill and ASC 360 tests.Used in The goodwill impairment test under ASC 350 and Impairment of long-lived assets under ASC 360.
• Depreciation and revaluation scheduleExcel downloadStraight-line, reducing balance and units of production side by side, component depreciation, the revaluation model, and decommissioning provisions. IAS 16.Used in IAS 16 property, plant and equipment explained and Depreciation methods, useful life and residual value.
• Inventory costing comparisonExcel downloadFIFO, weighted average and LIFO side by side from your purchase lots, with the lower of cost and net realisable value test. IAS 2 and ASC 330.Used in ASC 330 inventory explained and Lower of cost and net realizable value.
• Purchase price allocation modelExcel downloadConsideration, fair value adjustments with deferred tax, goodwill, and the non-controlling interest under both methods, with a bargain purchase check. IFRS 3.Used in ASC 805 business combinations explained and IFRS 3 vs ASC 805: business combination differences.
• Consolidation worksheetExcel downloadParent and subsidiary combined: goodwill, non-controlling interest, intragroup balances and unrealised profit, with balance checks. IFRS 10.Used in IFRS 10 consolidation explained and Intragroup transactions and eliminations.
• Lease calculatorExcel downloadIFRS 16 and ASC 842: lease liability, right-of-use asset, schedules, journal entries, modifications, and the ASC 842 operating lease cost and amortization.Used in ASC 842 leases explained and Operating vs finance leases for lessees.
• Journal entries practice workbookExcel downloadTen entries from across the standards: choose the accounts, type the amount and get an instant tick or cross, with a running score.Used in Debits and credits for standards students: the entries behind each standard.
• Foreign currency translation modelExcel downloadTranslate a foreign operation, explain the translation reserve by source, remeasure monetary items, and compare IFRS with US GAAP in hyperinflation. IAS 21 and ASC 830.Used in IAS 21 vs ASC 830: foreign currency and IAS 21 foreign currency: transactions and translation.
• Share-based payment scheduleExcel downloadThe cost of an award year by year under the graded and straight-line methods, with forfeitures and the tax at vesting. IFRS 2 and ASC 718.Used in ASC 718 stock-based compensation and IFRS 2 vs ASC 718: share-based payment.
• EPS calculatorExcel downloadBasic and diluted EPS with the treasury stock and if-converted methods, tested in order of dilution, and year-to-date EPS under both frameworks. IAS 33 and ASC 260.Used in ASC 260 earnings per share and IAS 33 vs ASC 260: earnings per share.
• Defined benefit roll-forwardExcel downloadThe pension obligation and plan assets from start to end, the cost in profit or loss and OCI, and the ASC 715 cost alongside. IAS 19.Used in IAS 19 vs ASC 715: employee benefits and IAS 19 employee benefits and defined benefit plans.
• Borrowing cost capitalisationExcel downloadThe capitalisation rate and the interest capitalised on a qualifying asset, under IAS 23 and ASC 835-20 side by side.Used in IAS 23 vs ASC 835-20: borrowing costs and IAS 23 borrowing costs: what to capitalise.
• IFRS and US GAAP difference reconcilerExcel downloadBridge net income and equity from US GAAP to IFRS, difference by difference, with deferred tax and a closing check.Used in Converting from US GAAP to IFRS and IFRS vs US GAAP cheat sheet.

Expected credit losses

10 workbooks for IFRS 9 and CECL: staging, PD, LGD, EAD, loss rates, scenarios and the allowance roll-forward.

• ECL staging and lifetime calculatorExcel download12-month and lifetime ECL from marginal PDs, LGD, EAD and discounting, with the SICR test that sets each loan's stage.Used in How to calculate ECL, step by step and ECL stages 1, 2 and 3 explained.
• PD term structure modelExcel downloadMarginal, cumulative and conditional PDs, a point-in-time adjustment for the economy, and illustrative curves by rating grade.Used in Probability of default (PD) and Lifetime PD and the PD term structure.
• LGD calculatorExcel downloadLoss given default from collateral value, haircuts, costs and time to recover, plus workout LGD from past defaults.Used in Loss given default (LGD) and ECL on lease receivables.
• EAD and CCF calculatorExcel downloadExposure at default for amortising loans with prepayments, and for revolving facilities using credit conversion factors from history.Used in Exposure at default (EAD) and Credit conversion factors for undrawn commitments.
• Loss rate builderExcel downloadProvision matrix loss rates from eight quarters of history, a forward-looking adjustment, and the effect of segmenting customers.Used in Calculating historical loss rates and Forward-looking adjustments to a provision matrix.
• Scenario weighting modelExcel downloadPD and LGD under base, downside and upside scenarios, the probability-weighted ECL, the non-linearity effect and sensitivities.Used in Forward-looking information in ECL and Macroeconomic scenarios for ECL.
• Roll rate modelExcel downloadRoll rates from monthly delinquency data, cumulative loss rates and the allowance, plus a rating migration matrix with multi-year PDs.Used in Roll rate analysis for ECL and Migration matrices and transition rates.
• Intercompany loan ECL calculatorExcel downloadECL on intercompany term loans and loans repayable on demand, financial guarantees, and cash and bank balances.Used in ECL on intercompany loans and ECL on financial guarantee contracts.
• CECL calculatorExcel downloadLifetime CECL on a loan pool with forecasts and reversion, unfunded commitments, and credit losses on available-for-sale securities. US GAAP.Used in CECL forecasts and reversion and CECL for off-balance-sheet exposures.
• IFRS 7 loss allowance roll-forwardExcel downloadThe loss allowance reconciled by stage from opening to closing, with transfers, the profit or loss charge and coverage ratios.Used in ECL disclosures under IFRS 7.

Sustainability reporting

5 workbooks for the GHG Protocol, ESRS double materiality and climate effects in the financial statements.

• Scope 1 and 2 calculatorExcel downloadDirect emissions by source and purchased electricity both location-based and market-based, with intensity per unit of revenue. GHG Protocol.Used in Calculating scope 1 and 2 emissions and Scope 2: location-based and market-based methods.
• Scope 3 spend-based calculatorExcel downloadSpend by category times a factor, restated for inflation, with supplier data used where you have it. GHG Protocol scope 3.Used in Scope 3: the spend-based method and Scope 3: using supplier-specific data.
• Materiality matrixExcel downloadScore impacts and financial effects, apply the threshold and place every topic on the matrix. ESRS double materiality.Used in Double materiality explained and Running a double materiality assessment.
• Carbon price impact modelExcel downloadCarbon prices in a value in use test with sensitivities, scenario-weighted impairment, emissions obligations and useful lives. IAS 36 and IAS 37.Used in Climate risk in the financial statements and Climate risk in impairment testing.
• ESG KPI dashboardExcel downloadKPIs against targets with a red, amber and green status, and common ESG KPIs worked out from raw data.Used in ESG KPIs explained and Workforce metrics: pay gap, turnover and safety.