| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
1 | ||||||
2 | Objective: | A basic P&L usually doesn't tell the whole story of what is happening with your company. For example, if you missed your revenue target, you will want to investigate whether the miss was due to churn, lower average order value, and/or new customer acquisition issues. This P&L template enables us to track our business at a level higher than what a basic P&L would allow. It also helps us answer common questions that many venture investors will ask such as: | ||||
3 | ||||||
4 | Question 1 | How many people are you hiring and when? | ||||
5 | Question 2 | When do you first get paying customers? (or should we assume nobody will pay for the next 12-18 months)? | ||||
6 | Question 3 | How much are you budgeting for sales and marketing tests, knowing that we can be unsure of their performance? | ||||
7 | Question 4 | How many months of runway does this imply? | ||||
8 | ||||||
9 | Additional Context | https://blog.blingcap.com/financial-model/ | ||||
10 | ||||||
11 | ||||||
12 | Steps To Build Your P&L | |||||
13 | Step 0: Fill out Inputs Below | |||||
14 | Model Start Date* | 3/1/2025 | ||||
15 | Current Cash Balance | $320,000 | ||||
16 | Date of Equity Financing Raise* | 4/1/2025 | ||||
17 | Target Equity Financing Amount | $1,200,000 | ||||
18 | ||||||
19 | Step 1: Build The Hiring Plan | Fill out hiring plan tab, only cells highlighted in yellow | ||||
20 | ||||||
21 | Step 2: Build The Revenue Plan | Fill out revenue and COGS section of the P&L tab, only cells highlighted in yellow | ||||
22 | ||||||
23 | Step 3: Budget in Operating Expenses | Fill out operating expenses section of the P&L tab, only cells highlighted in yellow | ||||
24 | ||||||
25 | ||||||
26 | ||||||
27 | Outputs | |||||
28 | ||||||
29 | Question 1 | Hiring Plan | ||||
30 | Question 2 | #N/A | ||||
31 | Question 3 | We will be spending an average of $2000 per month on sales and marketing over 24 months. | ||||
32 | Question 4 | Check Inputs | ||||
33 | ||||||
34 | ||||||
35 | Month 6 | Month 12 | Month 18 | Month 24 | ||
36 | Month | 8/1/2025 | 2/1/2026 | 8/1/2026 | 2/1/2027 | |
37 | Paying Customers | 5 | 20 | 40 | 65 | |
38 | Projected ARR | $30.0K | $192.0K | $384.0K | $624.0K | |
39 | Monthly Burn (Net of Revenues) | $74.4K | $71.0K | $56.0K | $37.8K | |
40 | Cash on Hand | $1.3M | $811.0K | $434.8K | $152.3K | |
41 | Runway | 17 | 11 | 8 | 4 | |
42 | Cumulative Cash Consumed | $263.7K | $769.3K | $1.3M | $1.8M | |
43 | ||||||
44 | ||||||
45 | ||||||
46 | ||||||
47 | ||||||
48 | ||||||
49 | ||||||
50 | ||||||
51 | ||||||
52 | ||||||
53 | ||||||
54 | ||||||
55 | ||||||
56 | ||||||
57 | ||||||
58 | ||||||
59 | ||||||
60 | ||||||
61 | ||||||
62 | ||||||
63 | ||||||
64 | ||||||
65 | ||||||
66 | ||||||
67 | ||||||
68 | ||||||
69 | ||||||
70 | ||||||
71 | ||||||
72 | ||||||
73 | ||||||
74 | ||||||
75 | ||||||
76 | ||||||
77 | ||||||
78 | ||||||
79 | ||||||
80 | ||||||
81 | ||||||
82 | ||||||
83 | ||||||
84 | ||||||
85 | ||||||
86 | ||||||
87 | ||||||
88 | ||||||
89 | ||||||
90 | ||||||
91 | ||||||
92 | ||||||
93 | ||||||
94 | ||||||
95 | ||||||
96 | ||||||
97 | ||||||
98 | ||||||
99 | ||||||
100 | ||||||