Fundraising Financial Model

An investor-grade model built from clean actuals: driver-based revenue, a hire-by-hire cost plan, runway and use of funds, scenarios, and the checks and monthly refresh that keep it credible in diligence.

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

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

203

Starter tasks

💰 Fundraising & Investor Relations

Fundraising Financial Model

Building the projections and use-of-funds model investors expect, with assumptions that hold up under scrutiny in diligence.

  1. Model brief on questions, audience and horizon
  2. Clean monthly actuals from the books
  3. Inputs, calculations and outputs tab layout
  4. Choosing the modelling tool and sharing format
  5. KPI definitions that match the deck and data room
  6. Revenue drivers that mirror how you sell
  7. Hire-by-hire headcount plan
  8. Operating cost build beyond payroll
  9. Burn, runway and zero-cash date
  10. Use of funds tied to milestones
  11. Monthly actuals versus forecast refresh
  12. Assumption change log
  13. Investor version control and file naming
  14. Thirteen-week cash forecast during a raise
  15. Quarterly rolling reforecast
  16. Sales pipeline to bookings reconciliation
  17. Hiring plan versus actual hires
  18. Model integrity checks tab
  19. Investor model question log
  20. Three-statement linking fundamentals
  21. Investor metrics computed from your own model
  22. Customer cohort retention tables
  23. Contribution margin by customer segment
  24. Cash timing and working capital
  25. Market share sanity check on the forecast
  26. Benchmark sources for key assumptions
  27. Spreadsheet modelling technique practice
  28. Base, upside and downside scenarios
  29. Sensitivity table on the drivers that matter
  30. Sales capacity and rep ramp model
  31. Gross margin build and target path
  32. Price change impact model
  33. Default-alive and breakeven analysis
  34. Simplifying an overbuilt model
  35. Raise amount range from the model
  36. Bookings, billings, revenue and cash separation
  37. Investor-ready model release
  38. Model walkthrough with an investor's analyst
  39. Financial diligence on the model
  40. Board approval of the post-round operating plan
  41. Independent model review before launch
  42. Pre-revenue model for a first raise
  43. Hardware and inventory business model
  44. Marketplace model with GMV and take rate
  45. Inheriting a founder-built model
  46. Multi-currency model for cross-border companies
  47. Runway extension plan modelled in advance
  48. Exit value implied by the plan
  49. Probabilistic ranges on key drivers
  50. Department budget owners feeding the model

Where it starts.

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

Model brief on questions, audience and horizon

Before a single formula, decide what the model has to answer: how much to raise, how long it lasts, and which milestones the money buys. A pre-seed angel wants a believable 18 to 24 months of monthly detail, while a Series A analyst will rebuild your revenue engine from its drivers, so the brief fixes horizon, granularity and audience before you build the wrong thing.

First tasks

  • Write the three questions investors will use the model to answer
  • Pick a forecast horizon and granularity for the model
  • Ask one investor or adviser what they expect to see at your stage
  • Name who owns the model and who reviews it before it leaves the company

Clean monthly actuals from the books

Projections are judged first by the history they start from, and a model whose opening numbers do not match the accounts loses credibility in the first diligence call. Pulling 12 to 24 months of monthly profit and loss and cash from the bookkeeping system, reconciled to the bank and mapped to the model's categories, gives every forecast line a real starting point.

First tasks

  • Ask your bookkeeper which month was last fully closed
  • Export monthly profit and loss and balance sheet for the last 24 months
  • Build a mapping table from ledger accounts to model categories
  • Tie each month's closing cash to the bank statement
  • Flag one-off income and costs in a notes column

Inputs, calculations and outputs tab layout

Models that mix typed numbers into formulas are the ones that break during a diligence walkthrough. Separating one inputs tab, calculation tabs that hold only formulas, and output tabs for the summary and charts means anyone can change an assumption in one place and trust what flows through.

First tasks

  • Sketch the tab map on one page before building
  • Create a cover tab with the colour convention and version number
  • Build a single timeline row that every calculation tab references
  • Move every typed assumption onto the inputs tab
  • Add a one-screen summary tab by year

Make it yours.

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