Three-Statement Financial Modelling

A linked profit and loss, balance sheet and cash flow model built from history and drivers, kept current with monthly actuals and checks, and used for funding, valuation and board decisions.

Free · Mac (Apple silicon) and Windows · v1.0.5 · Other platforms

Then open the Marketplace in the app, search for Three-Statement Financial Modelling, and click Install. It goes into your own files, and works offline from then on.

Before you start: this plan is general information to help you organise decisions about money. It is not financial, investment, tax or legal advice, and it does not recommend any product, investment or deal. Rules differ between countries, so check decisions that matter with a qualified, licensed adviser in yours. Investing and trading can lose money, and raising or managing other people's money is regulated in most countries.

What it installs.

1

Pillar

1

Area

50

Projects

204

Starter tasks

🧾 Finance & Accounting

Three-Statement Financial Modelling

Building linked profit and loss, balance sheet and cash flow models for planning, valuation and decisions, for founders, analysts and finance leads.

  1. Model purpose and decision brief
  2. Three years of historical statements tied to the accounts
  3. Model layout, timeline and formatting standard
  4. Historical ratio analysis to anchor assumptions
  5. Assumptions sheet with sources and owners
  6. Driver-based revenue build
  7. Cost of sales and overhead build
  8. Balance and integrity check dashboard
  9. Working capital schedule from debtor, stock and creditor days
  10. Fixed asset roll-forward and depreciation schedule
  11. Debt schedule with interest and repayments
  12. Tax schedule with losses carried forward
  13. Equity and retained earnings roll-forward
  14. Indirect cash flow statement from balance sheet movements
  15. Scenario switch for base, downside and upside cases
  16. Monthly actuals roll-in
  17. Model version control and change log
  18. Quarterly assumptions review with input owners
  19. Pre-send model check routine
  20. Forecast back-testing of model drivers
  21. Independent peer review of the model
  22. Quarterly scenario refresh
  23. Model user guide and documentation
  24. Annual model refresh before planning season
  25. How the three statements link together
  26. Lookup and aggregation formulas for modellers
  27. Financial modelling standards study
  28. Formula auditing and keyboard fluency
  29. Discounted cash flow valuation basics
  30. Sensitivity and data tables
  31. Rebuilding a listed company's statements from its annual report
  32. Refactoring an inherited spreadsheet model
  33. Spreadsheet or planning software decision
  34. Peak funding requirement and minimum cash point
  35. Debt versus equity funding comparison
  36. Converting an annual model to monthly for the first two years
  37. New product line impact on the three statements
  38. One-page model output summary and charts
  39. Fundraising model for investor due diligence
  40. Bank facility application model with covenant tests
  41. Five-year strategic plan model for a board away day
  42. Small acquisition target model
  43. Valuation pack for a shareholder buy-in or exit
  44. Pre-revenue startup three-statement model
  45. First model for a newly appointed budget holder
  46. Financial modelling test preparation for analyst roles
  47. Handing over a model when changing roles
  48. Buyout returns model with acquisition debt
  49. Monte Carlo simulation on key drivers
  50. Reverse stress test of the business model

Where it starts.

Each project arrives with its purpose, milestones and first tasks written out. Here is how the first three read.

Model purpose and decision brief

Most broken models were built without anyone writing down the question they had to answer. A one-page brief naming the decision, the audience, the forecast horizon, the time granularity and the date the answer is needed stops a fundraising model turning into a budgeting tool halfway through. It also tells you what to leave out.

First tasks

  • Write the single decision the model must inform in one sentence
  • List who will read the outputs and what each of them needs to see
  • Choose the forecast horizon and where monthly columns give way to annual
  • List what the model will deliberately not cover
  • Agree the brief with the decision maker before building anything

Three years of historical statements tied to the accounts

Forecasts are anchored on history, so the historical profit and loss, balance sheet and cash flow need to agree to the signed or filed accounts exactly. Loading three years, mapped to the lines the model will forecast, gives you trends to test assumptions against and an opening balance sheet that genuinely balances.

First tasks

  • Collect the last three sets of signed or filed accounts
  • Build a mapping table from source account lines to model lines
  • Enter the historical figures with a zero-difference check for each year
  • Flag one-off items so they stay out of the trend ratios
  • Load and tie the new year once the latest accounts are signed @recurring(yearly)

Model layout, timeline and formatting standard

Separating inputs, calculations and outputs, and running one consistent timeline across every sheet, is what makes a model readable by someone other than its builder. Fixing the conventions before the first formula costs an hour and saves days of untangling later: inputs in one colour, one formula per row copied across, and no typed numbers inside calculations.

First tasks

  • Create the sheet structure from the cover through to checks and outputs
  • Build one timeline row with dates, fiscal year and actual or forecast flags
  • Write the colour code and formula rules on the cover sheet
  • Align period columns so every sheet uses the same column for each month

Make it yours.

Install Three-Statement Financial Modelling, then tell Aurum the date you're aiming for. It checks whether the plan fits the weeks you actually have.

Free · Mac (Apple silicon) and Windows · v1.0.5 · Other platforms

Blueprints are general information to help you organise your own work. They are not medical, financial, legal or other professional advice. See the Terms.