Aurum
Download

Financial Modelling Tests

Timed modelling tests practised until they hold up on the day: paper LBOs in your head, one-hour and three-hour builds on a bare laptop, take-home cases with a one-page recommendation, and clean output a reviewer trusts.

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

Then open the Marketplace in the app, search for Financial Modelling Tests, 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

🎓 Finance & Business Certifications

Financial Modelling Tests

Practising the timed modelling tests used in finance hiring: the paper LBO, a two-to-three-hour model build, a case study with an investment recommendation and clean output.

  1. Modelling test map for your target firms
  2. Cold baseline attempt at each test format
  3. Bare Excel test laptop set-up
  4. Blank-sheet LBO layout you can rebuild in ten minutes
  5. In-person test kit and room checklist
  6. Practice case library from public sources
  7. Test calendar linked to your recruiting pipeline
  8. Ground rules for take-home tests and outside help
  9. Weekly timed paper LBO drill
  10. Monthly three-hour mock case build
  11. Mistake log from every practice test
  12. Five-minute mental maths warm-up
  13. Keyboard-only modelling drill
  14. Monthly peer marking swap
  15. Time-split tracker across mock tests
  16. Weekly deal announcement turned into a paper LBO
  17. Quarterly test readiness review
  18. Paper LBO from first principles
  19. IRR and multiple shortcuts without a calculator
  20. One-hour LBO build in Excel
  21. Three-hour LBO from a case pack
  22. Three-statement model from a blank sheet
  23. DCF valuation under a clock
  24. Merger model and accretion test
  25. Twenty-minute case pack triage
  26. Returns sensitivities and value creation bridge
  27. Finding a balance sheet error in ten minutes
  28. Choosing test prep materials and courses
  29. Scope rules for when the clock is short
  30. Output page standard for submitted tests
  31. One-page investment recommendation memo
  32. Walking an interviewer through your model
  33. Cutting your build time by a third
  34. Interest calculation and circularity decision
  35. Final fifteen-minute review before submission
  36. Take-home case study delivered on time
  37. In-person timed test at the firm
  38. Online timed test on a remote platform
  39. Paper LBO in a live interview
  40. Full dress rehearsal two weeks before a test
  41. Post-test debrief and feedback request
  42. First modelling test as an undergraduate
  43. Buy-side test practice around deal hours
  44. Accountant moving into transaction roles
  45. Remote tests across time zones and regional settings
  46. MBA associate modelling refresher
  47. Real estate acquisition model test
  48. Credit fund downside case test
  49. Growth equity and minority investment case
  50. Designing a modelling test for interns

Where it starts.

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

Modelling test map for your target firms

Banks, private equity funds and corporate development teams test modelling in very different ways: a paper LBO in a first-round interview, a one-hour LBO on a firm laptop, a three-hour build from a case pack, or a take-home case due in a few days. Knowing which format each firm on your list uses tells you what to practise first and stops you spending a month on merger models for funds that only ask for a paper LBO.

First tasks

  • List every firm and role you are applying to in one sheet
  • Ask two alumni or analysts which modelling test each firm used last season
  • Mark each firm as paper LBO, timed build, take-home case or unknown
  • Choose the format that covers the most live processes and practise it first

Cold baseline attempt at each test format

Before building a plan, sit one practice version of each format cold, under the real clock: a paper LBO in fifteen minutes, a simple LBO in an hour and a short case in three hours. The scores and the points where you stalled are more useful than any self-assessment, and they give you a starting line to measure every later mock against.

First tasks

  • Book three free evenings in the next fortnight for the baseline attempts
  • Sit a paper LBO with a fifteen-minute timer and a pen only
  • Build a one-hour LBO from a short prompt without any saved template
  • Score accuracy, speed and presentation for each attempt in a skills matrix

Bare Excel test laptop set-up

In-office tests are usually sat on a firm laptop with default Excel settings, a different keyboard and no add-ins, so the shortcuts and macros you rely on at home may not exist. Practising on a clean profile with the same defaults removes the shock on the day and shows which habits depend on your own set-up.

First tasks

  • Create a second user profile on your computer with Excel at default settings
  • Remove add-ins, custom ribbons and personal macros from that profile
  • Write down the settings you change in the first two minutes of a test
  • Do your next two practice builds only on the clean profile

Make it yours.

Install Financial Modelling Tests, 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.0 · 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.