| A | B | C | D | E | F | G | H | I | J | L | M | N | O | R | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | |||||||||||||||
2 | |||||||||||||||
3 | |||||||||||||||
4 | Budget | ||||||||||||||
5 | Actual Results | ||||||||||||||
6 | |||||||||||||||
7 | Revenues | FY 2006 | FY 2006 By Qtr | ||||||||||||
8 | January | February | March | April | May | June | July | August | September | Q1 | Q2 | Q3 | |||
9 | Operating Plan | $5,000 | $25,000 | $50,000 | $100,000 | $150,000 | $200,000 | $250,000 | $325,000 | $400,000 | $80,000 | $450,000 | $975,000 | ||
10 | January | $3,750 | $25,000 | $51,250 | $100,000 | $150,000 | $200,000 | $250,000 | $325,000 | $400,000 | $80,000 | $450,000 | $975,000 | ||
11 | February | $17,000 | $60,000 | $77,275 | $100,000 | $240,000 | $250,000 | $325,000 | $400,000 | $80,750 | $417,275 | $975,000 | |||
12 | March | $22,000 | $25,000 | $40,000 | $50,000 | $75,000 | $125,000 | $200,000 | $42,750 | $115,000 | $400,000 | ||||
13 | April | $32,000 | $40,000 | $50,000 | $75,000 | $125,000 | $200,000 | $122,000 | $400,000 | ||||||
14 | May | $45,660 | $60,000 | $75,000 | $125,000 | $200,000 | $137,660 | $400,000 | |||||||
15 | June | $75,000 | $100,000 | $150,000 | $275,000 | $152,660 | $525,000 | ||||||||
16 | July | $115,000 | $175,000 | $275,000 | $565,000 | ||||||||||
17 | August | $167,000 | $275,000 | $557,000 | |||||||||||
18 | September | $245,000 | $527,000 | ||||||||||||
19 | |||||||||||||||
20 | |||||||||||||||
21 | Gross Margin | FY 2006 | FY 2006 By Qtr | ||||||||||||
22 | January | February | March | April | May | June | July | August | September | Q1 | Q2 | Q3 | |||
23 | Operating Plan | $2,500 | $12,500 | $25,000 | $50,000 | $75,000 | $100,000 | $125,000 | $162,500 | $200,000 | $40,000 | $225,000 | $487,500 | ||
24 | January | $1,875 | $12,500 | $25,625 | $50,000 | $75,000 | $100,000 | $125,000 | $162,500 | $200,000 | $40,000 | $225,000 | $487,500 | ||
25 | February | $8,500 | $30,000 | $38,638 | $50,000 | $120,000 | $125,000 | $162,500 | $200,000 | $40,375 | $208,638 | $487,500 | |||
26 | March | $11,000 | $12,500 | $20,000 | $25,000 | $37,500 | $62,500 | $100,000 | $21,375 | $57,500 | $200,000 | ||||
27 | April | $16,000 | $20,000 | $25,000 | $37,500 | $62,500 | $100,000 | $61,000 | $200,000 | ||||||
28 | May | $22,830 | $30,000 | $37,500 | $62,500 | $100,000 | $68,830 | $200,000 | |||||||
29 | June | $37,500 | $50,000 | $75,000 | $137,500 | $76,330 | $262,500 | ||||||||
30 | July | $57,500 | $75,000 | $137,500 | $270,000 | ||||||||||
31 | August | $70,000 | $125,000 | $252,500 | |||||||||||
32 | September | $122,500 | $250,000 | ||||||||||||
33 | |||||||||||||||
34 | |||||||||||||||
35 | Operating Expenses | FY 2006 | FY 2006 By Qtr | ||||||||||||
36 | January | February | March | April | May | June | July | August | September | Q1 | Q2 | Q3 | |||
37 | Operating Plan | $100,000 | $100,000 | $100,000 | $120,000 | $140,000 | $180,000 | $180,000 | $235,000 | $250,000 | $300,000 | $440,000 | $665,000 | ||
38 | January | $65,000 | $100,000 | $100,000 | $120,000 | $140,000 | $180,000 | $180,000 | $235,000 | $250,000 | $265,000 | $440,000 | $665,000 | ||
39 | February | $80,000 | $110,000 | $120,000 | $140,000 | $180,000 | $180,000 | $235,000 | $250,000 | $255,000 | $440,000 | $665,000 | |||
40 | March | $80,000 | $80,000 | $100,000 | $150,000 | $200,000 | $200,000 | $250,000 | $225,000 | $330,000 | $650,000 | ||||
41 | April | $85,000 | $100,000 | $150,000 | $250,000 | $250,000 | $250,000 | $335,000 | $750,000 | ||||||
42 | May | $110,000 | $170,000 | $180,000 | $235,000 | $250,000 | $365,000 | $665,000 | |||||||
43 | June | $150,000 | $180,000 | $235,000 | $275,000 | $345,000 | $690,000 | ||||||||
44 | July | $173,000 | $235,000 | $250,000 | $658,000 | ||||||||||
45 | August | $200,000 | $225,000 | $598,000 | |||||||||||
46 | September | $225,000 | $598,000 | ||||||||||||
47 | |||||||||||||||
48 | |||||||||||||||
49 | Cash Balance | FY 2006 | FY 2006 By Qtr | ||||||||||||
50 | January | February | March | April | May | June | July | August | September | Q1 | Q2 | Q3 | |||
51 | Operating Plan | $652,500 | $565,000 | $490,000 | $420,000 | $355,000 | $275,000 | $220,000 | $147,500 | $97,500 | $490,000 | $275,000 | $97,500 | ||
52 | January | $686,875 | $599,375 | $540,375 | $470,375 | $405,375 | $325,375 | $270,375 | $197,875 | $147,875 | $540,375 | $325,375 | $147,875 | ||
53 | February | $615,375 | $535,375 | $454,013 | $364,013 | $304,013 | $249,013 | $176,513 | $126,513 | $535,375 | $304,013 | $126,513 | |||
54 | March | $546,375 | $478,875 | $398,875 | $273,875 | $111,375 | ($26,125) | ($176,125) | $546,375 | $273,875 | ($176,125) | ||||
55 | April | $477,375 | $397,375 | $272,375 | $59,875 | ($127,625) | ($277,625) | $272,375 | ($277,625) | ||||||
56 | May | $390,205 | $250,205 | $107,705 | ($64,795) | ($214,795) | $250,205 | ($214,795) | |||||||
57 | June | $277,705 | $147,705 | ($12,295) | ($149,795) | $277,705 | ($149,795) | ||||||||
58 | July | $162,205 | $27,205 | ($85,295) | ($85,295) | ||||||||||
59 | August | $59,205 | ($15,795) | ($15,795) | |||||||||||
60 | September | ($43,295) | ($43,295) | ||||||||||||
61 | |||||||||||||||
62 | |||||||||||||||
63 | This waterfall template created by Josh Kopelman of First Round Capital. Feel free to distribute freely with attribution. | ||||||||||||||
64 | http://www.firstround.com | ||||||||||||||