- Home
- Excel Models
Excel Models
Work with the numbers instead of reading them.
Every case includes an Excel workbook. Change an input and the schedule, the journal entries and the summary update.
- 01
Inputs you can change
Yellow cells with blue text. Try a different rate, term or amount.
- 02
Formulas you can read
No macros and no hidden sheets. Rates are calculated with RATE, IRR and PV.
- 03
Entries that balance
Every journal entry sheet has totals and a balance check.
- 04
Key results in green
The amounts each case asks you to find.
WORKBOOKSHEETS
- FREE · IFRS 16The Coffee Shop LeaseInputs · Schedule · ROU Asset · Journal Entries · Summary
- #001 · IFRS 16“It’s Just Rent,” Said the CEO.Inputs · 60-month schedule · ROU Asset · Journal Entries · Summary
- #002 · IFRS 15The Customer Paid. Can We Recognise Revenue Yet?Contract · Allocation · Revenue schedule · Journal Entries · Summary
- #003 · IFRS 9The Loan That Wasn’t as Cheap as It Looked.Inputs · EIR · Amortised cost · Journal Entries · Reconciliation
- #004 · IAS 12The Tax Expense That Came From the Future.Temporary differences · Movement · Journal Entries · Recovery
- #005 · IAS 36The Factory Everyone Pretended Was Fine.CGU · Recoverable amount · Impairment · Reversal · Journal Entries
- #006 · IAS 37“We Probably Won’t Lose the Lawsuit.”Assessment · Provision · Scenarios · Reimbursement · Journal Entries