A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | FI Financial Model Template | ||||||||||||||||||||||||||||
2 | Change values in blue. | ||||||||||||||||||||||||||||
3 | Assumptions | Assumptions | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | Assumptions | Month 13 | Month 14 | Month 15 | Month 16 | Month 17 | Month 18 | Month 19 | Month 20 | Month 21 | Month 22 | Month 23 | Month 24 | ||
4 | Growth Rate | 10% | 10% | 10% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 15% | 20% | 20% | 20% | 20% | 20% | 20% | 20% | 20% | 20% | 20% | 20% | 20% | |||||
5 | Key Driver 1 (i.e. Users) | 500 | 550 | 605 | 666 | 765 | 880 | 1,012 | 1,164 | 1,339 | 1,539 | 1,770 | 2,036 | 2,443 | 2,932 | 3,518 | 4,221 | 5,066 | 6,079 | 7,295 | 8,753 | 10,504 | 12,605 | 15,126 | 18,151 | ||||
6 | Key Driver 2 (i.e. Visits/Month) | 2 | 1,000 | 1,100 | 1,210 | 1,331 | 1,531 | 1,760 | 2,024 | 2,328 | 2,677 | 3,079 | 3,540 | 4,072 | 2 | 4,886 | 5,863 | 7,036 | 8,443 | 10,131 | 12,158 | 14,589 | 17,507 | 21,008 | 25,210 | 30,252 | 36,302 | ||
7 | Key Driver 3 (i.e. Page Views/Visit) | 10 | 10,000 | 11,000 | 12,100 | 13,310 | 15,307 | 17,602 | 20,243 | 23,279 | 26,771 | 30,787 | 35,405 | 40,716 | 10 | 48,859 | 58,630 | 70,357 | 84,428 | 101,313 | 121,576 | 145,891 | 175,070 | 210,084 | 252,100 | 302,520 | 363,024 | ||
8 | Key Driver 4 | ||||||||||||||||||||||||||||
9 | |||||||||||||||||||||||||||||
10 | Revenue | Assumptions | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | Year 1 Total | Assumptions | Month 13 | Month 14 | Month 15 | Month 16 | Month 17 | Month 18 | Month 19 | Month 20 | Month 21 | Month 22 | Month 23 | Month 24 | Year 2 Total |
11 | Advertising (CPM) | $2.00 | $200 | $220 | $242 | $266 | $306 | $352 | $405 | $466 | $535 | $616 | $708 | $814 | $5,130 | $2.00 | $977 | $1,173 | $1,407 | $1,689 | $2,026 | $2,432 | $2,918 | $3,501 | $4,202 | $5,042 | $6,050 | $7,260 | $38,677 |
12 | |||||||||||||||||||||||||||||
13 | Sub-Total | $200 | $220 | $242 | $266 | $306 | $352 | $405 | $466 | $535 | $616 | $708 | $814 | $5,130 | $977 | $1,173 | $1,407 | $1,689 | $2,026 | $2,432 | $2,918 | $3,501 | $4,202 | $5,042 | $6,050 | $7,260 | $38,677 | ||
14 | |||||||||||||||||||||||||||||
15 | Costs of Goods Sold | Assumptions | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | Year 1 Total | Assumptions | Month 13 | Month 14 | Month 15 | Month 16 | Month 17 | Month 18 | Month 19 | Month 20 | Month 21 | Month 22 | Month 23 | Month 24 | Year 2 Total |
16 | Cost of Customer Acquisition | $0.50 | $250 | $275 | $303 | $333 | $383 | $440 | $506 | $582 | $669 | $770 | $885 | $1,018 | $6,413 | $0.25 | $611 | $733 | $879 | $1,055 | $1,266 | $1,520 | $1,824 | $2,188 | $2,626 | $3,151 | $3,782 | $4,538 | $24,173 |
17 | |||||||||||||||||||||||||||||
18 | Sub-Total | $250 | $275 | $303 | $333 | $383 | $440 | $506 | $582 | $669 | $770 | $885 | $1,018 | $6,413 | $611 | $733 | $879 | $1,055 | $1,266 | $1,520 | $1,824 | $2,188 | $2,626 | $3,151 | $3,782 | $4,538 | $24,173 | ||
19 | |||||||||||||||||||||||||||||
20 | Expenses | Assumptions | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | Year 1 Total | Assumptions | Month 13 | Month 14 | Month 15 | Month 16 | Month 17 | Month 18 | Month 19 | Month 20 | Month 21 | Month 22 | Month 23 | Month 24 | Year 2 Total |
21 | Headcount | ||||||||||||||||||||||||||||
22 | Co-Founder (per year) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $24,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $24,000 |
23 | Co-Founder (per year) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $24,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $24,000 |
24 | Engineer (per year) | $35,000 | $2,917 | $2,917 | $2,917 | $2,917 | $2,917 | $2,917 | $2,917 | $2,917 | $2,917 | $2,917 | $29,167 | $45,000 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $45,000 | ||
25 | Engineer (per year) | $35,000 | $2,917 | $2,917 | $2,917 | $2,917 | $2,917 | $2,917 | $2,917 | $2,917 | $23,333 | $45,000 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $3,750 | $45,000 | ||||
26 | Intern (per year) | $15,000 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $15,000 | $15,000 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $15,000 |
27 | Operating Expenses | ||||||||||||||||||||||||||||
28 | Rent (per month) | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $4,500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $6,000 | |||
29 | Marketing (per month) | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $2,250 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $6,000 | |||
30 | Legal (per month) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $1,800 | |||
31 | Hosting (per month) | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $1,350 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $1,800 | |||
32 | Travel & Entertainment (per month) | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $1,800 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $1,800 |
33 | Miscellaneous (per month) | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $6,000 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $6,000 |
34 | |||||||||||||||||||||||||||||
35 | Sub-Total | $1,900 | $1,900 | $4,817 | $5,717 | $8,633 | $8,633 | $8,633 | $8,633 | $8,633 | $8,633 | $8,633 | $8,633 | $83,400 | $14,700 | $14,700 | $14,700 | $14,700 | $14,700 | $14,700 | $14,700 | $14,700 | $14,700 | $14,700 | $14,700 | $14,700 | $176,400 | ||
36 | |||||||||||||||||||||||||||||
37 | Assumptions | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | Year 1 Total | Assumptions | Month 13 | Month 14 | Month 15 | Month 16 | Month 17 | Month 18 | Month 19 | Month 20 | Month 21 | Month 22 | Month 23 | Month 24 | Year 2 Total | |
38 | Gross Profit | -$50 | -$55 | -$61 | -$67 | -$77 | -$88 | -$101 | -$116 | -$134 | -$154 | -$177 | -$204 | -$1,283 | $366 | $440 | $528 | $633 | $760 | $912 | $1,094 | $1,313 | $1,576 | $1,891 | $2,269 | $2,723 | $14,504 | ||
39 | EBIT | -$1,950 | -$1,955 | -$4,877 | -$5,783 | -$8,710 | -$8,721 | -$8,735 | -$8,750 | -$8,767 | -$8,787 | -$8,810 | -$8,837 | -$84,683 | -$14,334 | -$14,260 | -$14,172 | -$14,067 | -$13,940 | -$13,788 | -$13,606 | -$13,387 | -$13,124 | -$12,809 | -$12,431 | -$11,977 | -$161,896 | ||
40 | |||||||||||||||||||||||||||||
41 |