A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | ||||||||||||||||||||||||
2 | ||||||||||||||||||||||||
3 | Key | October | November | December | January | February | March | April | ||||||||||||||||
4 | Inputs | Calculated | ||||||||||||||||||||||
5 | Directions: Fill in input cells on Financial Model to project runway + long-term business outlook. All current data is included for example purposes only | Inputs | Total Income | $ 1,575,000 | $ 1,949,000 | $ 2,416,750 | $ 3,001,688 | $ 3,733,109 | $ 4,647,637 | $ 5,791,046 | ||||||||||||||
6 | Monthly Revenue Growth Rate | 25% | Monhtly Revenue | $ 1,500,000 | $ 1,875,000 | $ 2,343,750 | $ 2,929,688 | $ 3,662,109 | $ 4,577,637 | $ 5,722,046 | ||||||||||||||
7 | Treasury Yield | $ 75,000 | $ 74,000 | $ 73,000 | $ 72,000 | $ 71,000 | $ 70,000 | $ 69,000 | ||||||||||||||||
8 | Expenses | $ (900,000) | $ (907,500) | $ (907,500) | $ (907,500) | $ (907,500) | $ (907,500) | $ (907,500) | ||||||||||||||||
9 | Vendor Expense Growth Rate | 5% | Payroll | $ 750,000 | $ 750,000 | $ 750,000 | $ 750,000 | $ 750,000 | $ 750,000 | $ 750,000 | ||||||||||||||
10 | + New Hire #1 | $ - | $ - | $ 16,000 | $ 16,000 | $ 16,000 | $ 16,000 | $ 16,000 | ||||||||||||||||
11 | New Hire #1 Salary | $ 160,000 | + New Hire #2 | $ - | $ - | $ - | $ 19,000 | $ 19,000 | $ 19,000 | $ 19,000 | ||||||||||||||
12 | New Hire #2 Salary | $ 190,000 | + New Hire #3 | $ - | $ - | $ - | $ - | $ 21,000 | $ 21,000 | $ 21,000 | ||||||||||||||
13 | New Hire #3 Salary | $ 210,000 | + New Hire #4 | $ - | $ - | $ 18,500 | $ 18,500 | $ 18,500 | $ 18,500 | $ 18,500 | ||||||||||||||
14 | New Hire #4 Salary | $ 185,000 | + New Hire #5 | $ - | $ - | $ - | $ - | $ - | $ - | $ - | ||||||||||||||
15 | New Hire #5 Salary | $ - | ||||||||||||||||||||||
16 | Vendors | $ 150,000 | $ 157,500 | $ 157,500 | $ 157,500 | $ 157,500 | $ 157,500 | $ 157,500 | ||||||||||||||||
17 | Net Burn | $ 675,000 | $ 1,041,500 | $ 1,509,250 | $ 2,094,188 | $ 2,825,609 | $ 3,740,137 | $ 4,883,546 | ||||||||||||||||
18 | Monthly Vendor Cost | $ 150,000 | ||||||||||||||||||||||
19 | Cash Balance in Bank | $ 50,000,000 | $ 51,041,500 | $ 52,550,750 | $ 54,644,938 | $ 57,470,547 | $ 61,210,684 | $ 66,094,229 | ||||||||||||||||
20 | Runway | Indefinite | Indefinite | Indefinite | Indefinite | Indefinite | Indefinite | Indefinite | ||||||||||||||||
21 |