Financial Model Checking

A model review routine you trust: balance and cash checks, link and hard-code audits, sign conventions, scenario sweeps, an error log and the specialist checks for LBO, merger and diligence models.

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

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

What it installs.

1

Pillar

1

Area

50

Projects

200

Starter tasks

🏦 Investment Banking & Advisory

Financial Model Checking

Checking models before they go to seniors: balance checks, links, hard-codes, sign conventions, scenario switches and a review routine you trust.

  1. Personal model review checklist, first version
  2. Balance check and error flag build
  3. Cash flow statement to balance sheet cash tie-out
  4. Hard-code and colour code audit
  5. Sign convention rule sheet for your group
  6. Mapping a model before reviewing it
  7. Historical figures tie-out to source documents
  8. Master check tab with one summary cell
  9. Circular reference and iteration switch check
  10. Pre-send review routine for every model
  11. Personal error log and monthly pattern review
  12. Scenario and case switch sweep
  13. Peer check swap with another analyst
  14. Version comparison between model turns
  15. Quarterly refresh of the review checklist
  16. Monthly hygiene sweep of live models
  17. Model to output page tie-out
  18. Review time blocked into every deliverable
  19. Reading an unfamiliar model quickly
  20. Debugging a balance sheet that does not balance
  21. Checking debt schedules and interest
  22. Checking working capital and days calculations
  23. Checking tax, losses and deferred tax lines
  24. Ratio and reasonableness sanity sheet
  25. Checking per share and dilution maths
  26. Checking period alignment and timing flags
  27. Checking units, scaling and currency
  28. Choosing a model auditing add-in
  29. Proposing a reusable check block for the firm template
  30. Extreme input stress test
  31. Review tiers for different deliverables
  32. Error categories for the error log
  33. Automated checks versus manual review
  34. First model sent with zero flagged errors
  35. Pre-signing model freeze and final check
  36. Client board deck number check the night before
  37. Checking routine for timed modelling tests
  38. Handing over a model with a check record
  39. Checking routine for your first month as an analyst
  40. Model checking as a summer intern
  41. Associate review of analyst models
  42. Checking work from an offshore support team
  43. Late-night checking protocol when tired
  44. From audit to banking model review
  45. LBO model returns check
  46. Merger model accretion dilution check
  47. Shadow calculation of the headline outputs
  48. Checking macros and copy-paste loops in a model
  49. Checking data tables and sensitivity grids
  50. Reviewing a management or counterparty model

Where it starts.

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

Personal model review checklist, first version

Most errors seniors catch are the same dozen mistakes repeated: a broken balance check, a hard-coded growth rate, a sign flipped on capex, a case switch left on downside. Writing your own checklist of those dozen, in the order you will actually check them, turns review from a vague scroll into a routine you can run in twenty minutes at 1am.

First tasks

  • List the last five errors anyone flagged in your models
  • Ask your associate which three checks they always run first
  • Draft the checklist as yes or no questions grouped by section
  • Run it on a practice three-statement model and note the time taken

Balance check and error flag build

A balance check that rounds to zero while hiding a 0.4 difference, or one that sits on a tab nobody looks at, is worse than none. Building a check row that tests assets less liabilities and equity for every period, flags anything above a tight tolerance and shows the result on the cover sheet means an imbalance announces itself the moment it appears.

First tasks

  • Add a row subtracting liabilities and equity from total assets for every period
  • Wrap the check in an absolute value and compare it with a tight tolerance
  • Link one summary flag cell to the cover page
  • Introduce a deliberate error and confirm the flag fires

Cash flow statement to balance sheet cash tie-out

Plugs can make a model balance while the cash flow statement says something different from the balance sheet. Tying ending cash on the cash flow statement to cash on the balance sheet, and the change in each working capital line to its balance sheet movement, proves the three statements are genuinely linked rather than forced.

First tasks

  • Compare ending cash on the cash flow with balance sheet cash for each period
  • Tie the change in receivables, inventory and payables to the cash flow lines
  • Search the balance sheet for any line labelled plug or other balancing
  • Add the tie-out rows to the check tab

Make it yours.

Install Financial Model Checking, 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.