AVL Mini Model of Cash Flow Analysis
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJ
1
Beg Balance
2
Key AssumptionsActualsActualsActualsActualsForecastForecastForecastForecastForecastForecastForecast
3
PeriodHistoryFcst012345678910
Total Change
4
Income Stmt
5
Revenue176,283182,839190,403198,019205,940214,177220,603227,221234,038241,059
6
Rev Growth %3.7%4.1%4.0%4.0%4.0%3.0%3.0%3.0%3.0%
7
COGS93,02995,989101,211104,950109,148113,514116,919119,745123,338127,038
8
Gross Profit83,25486,85089,19293,06996,792100,663103,683107,475110,700114,02124,829
9
Gross Margin47.2%47.2%47.5%46.8%47.0%47.0%47.0%47.0%47.3%47.3%47.3%
10
11
Operating Exp
12
People34,87835,12235,22335,00035,00035,00042,00042,00042,00042,000
13
Marketing6.4%6.6%11,63414,3009,24813,06913,59214,13614,56014,99715,44615,910
14
R&D / Svc4,50010,00010,00010,00010,00010,00010,00012,00012,00012,000
15
G&A6,5006,5006,5006,5006,5006,5006,5006,5006,5006,500
16
Depreciation556556556556556556556556556556
17
Interest Exp10,0009,9679,9309,8899,8459,7969,7429,6839,6189,546
18
Total OpEx68,06876,44471,45675,01475,49275,98783,35785,73586,12086,511
19
20
Net Income15,18610,40617,73618,05521,29924,67620,32621,74124,58027,509
21
8.6%5.7%9.3%9.1%10.3%11.5%9.2%9.6%10.5%11.4%
22
23
Balance Sheet
24
Cash89,50021,41955,45995,28654,16355,23258,81862,64470,35377,33686,654
25
A/R54.055280,000315,834334,333338,439363,035377,556392,659404,438416,572429,069441,941(103,502)
26
Inventory76.975223,398275,438247,444221,500262,375272,870283,785292,299299,364308,344317,595(96,095)
27
Prepaids21,00020,00020,00020,00020,00020,00020,00020,00020,00020,00020,000
28
Fixed Assets, net20,00019,44418,88918,33317,77817,22216,66716,11115,55615,00014,444
29
Assets633,898652,135676,125693,558717,351742,881771,929795,492821,844849,749880,634
30
31
A/P111,898114,283127,235128,337134,519139,240144,150147,979153,242157,284161,44833,111
32
Accruals29,00030,00031,00030,00030,00030,00030,00030,00030,00030,00030,0000
33
Debt100,00099,66699,29898,89398,44897,95997,42196,82896,17795,46094,672
34
Equity393,000408,186418,592436,328454,383475,682500,358520,684542,425567,005594,514
35
L & E633,898652,135676,125693,558717,351742,881771,929795,492821,844849,749880,634
36
37
Cash Flow
38
Net Income15,18610,40617,73618,05521,29924,67620,32621,74124,58027,509158,186
39
Chg Debt(334)(368)(405)(445)(489)(538)(592)(651)(717)(788)(4,221)
40
Chg A/R(35,834)(18,499)(4,106)(24,596)(14,521)(15,102)(11,780)(12,133)(12,497)(12,872)(103,502)
41
Chg Inv(52,040)27,99425,944(40,875)(10,495)(10,915)(8,514)(7,065)(8,981)(9,250)(96,095)
42
Chg Ppd1,0000000000000
43
Chg F.A.5565565565565565565565565565563,889
44
Chg Accruals1,0001,000(1,000)00000000
45
Chg A/P2,38512,9521,1026,1824,7214,9103,8295,2634,0424,16433,111
46
47
Net Chg Cash(68,081)34,04139,827(41,124)1,0703,5863,8257,7096,9839,318(8,632)
48
Beginning Cash89,50021,41955,45995,28654,16355,23258,81862,64470,35377,336
49
Ending Cash21,41955,45995,28654,16355,23258,81862,64470,35377,33686,654
50
Check0000000000
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
Loading...