ModelWaterfall
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
Still loading...
ABCDEFGHIJLMNOR
1
2
ASHLOOOOGLE.COM WATERFALL FORECAST
3
4
Budget
5
Actual Results
6
7
RevenuesFY 2006FY 2006 By Qtr
8
JanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberQ1Q2Q3
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 MarginFY 2006FY 2006 By Qtr
22
JanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberQ1Q2Q3
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 ExpensesFY 2006FY 2006 By Qtr
36
JanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberQ1Q2Q3
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 BalanceFY 2006FY 2006 By Qtr
50
JanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberQ1Q2Q3
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
Loading...
 
 
 
Sheet1
Sheet2
Sheet3