Fundraising
Monthly investor update
This template keeps a monthly KPI history for cash, net burn, runway, MRR, growth, customers, churn and headcount with fixed definitions.
The Update Draft reads those cells into a reviewable monthly update with highlights, lowlights, KPIs and asks.
Reads from
Stripe
QuickBooks
Mercury- Last month's sheet
Sheets
- KPI History
- Keeps monthly actuals, plan values and changes for the update's core KPIs.
- KPI Definitions
- Records the definition and source used for each KPI.
- Plan
- Holds the monthly targets compared with actual results.
- Update Draft
- Builds the subject, KPI table and update sections from linked cells.
- Sources
- Records the fictional KPI input file, coverage, derived formulas and connection status.
Formulas
'KPI History'!Q13
=IF(COUNT(O5:Q5)=3,AVERAGE(O5:Q5),"")Averages the latest three months of net burn.
'KPI History'!Q14
=IF(AND(ISNUMBER(Q13),ISNUMBER(Q4)),IF(Q13>0,Q4/Q13,""),"")Calculates runway from cash and trailing net burn.
'Update Draft'!B1
="Acme Analytics (fictional) investor update: "&TEXT(Plan!$B$1,"mmmm yyyy")&" — "&TEXT('KPI History'!S6,"$#,##0")&" MRR"Builds the update subject from the reporting month and linked MRR.
Questions
Which KPIs are included?
The KPI History includes cash, net burn, runway, MRR, growth, customers, churn and headcount, with definitions kept in a separate sheet.
Where can the numbers come from?
The workbook can read revenue from Stripe, accounting data from QuickBooks, cash from Mercury, or values from last month's sheet and a bank CSV.
Does the template send the update?
No. It drafts the update in the workbook for review. Nothing is sent from the template.