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

View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACAD
1
2
B/S Finance Analysis
3
Exp Yearly Revenue
Cash Flow Projection (by Month)
4
TV All Property
TV Est Increase
YearFiscal Year2.9616July AugustSeptemberOctober
November
DecemberJanuaryFebruaryMarchAprilMayJuneTotal
5
*114,112,5461.01512019-20337,956$30,344$78,361$188,869$7,803$5,919$2,379$1,703$2,362$3,825$0$0$16,391$337,957
6
115,824,2341.01522020-21343,025$30,799$79,536$191,702$7,920$6,008$2,415$1,728$2,398$3,883$0$0$16,637$343,026
7
117,561,5981.01532021-22348,170$31,261$80,730$194,578$8,039$6,098$2,451$1,754$2,434$3,941$0$0$16,887$348,171
8
119,325,0221.01542022-23353,393$31,730$81,940$197,496$8,159$6,189$2,488$1,780$2,470$4,000$0$0$17,140$353,394
9
121,114,8971.01552023-24358,694$32,206$83,170$200,459$8,282$6,282$2,525$1,807$2,507$4,060$0$0$17,397$358,695
10
122,931,6201.01562024-25364,074$32,689$84,417$203,466$8,406$6,376$2,563$1,834$2,545$4,121$0$0$17,658$364,075
11
124,775,5951.01572025-26369,535$33,179$85,683$206,518$8,532$6,472$2,601$1,862$2,583$4,183$0$0$17,923$369,536
12
126,647,2291.01582026-27375,078$33,677$86,969$209,616$8,660$6,569$2,640$1,890$2,622$4,245$0$0$18,192$375,079
13
128,546,9371.01592027-28380,705$34,182$88,273$212,760$8,790$6,668$2,680$1,918$2,661$4,309$0$0$18,465$380,706
14
130,475,1411.015102028-29386,415$34,695$89,597$215,951$8,922$6,768$2,720$1,947$2,701$4,374$0$0$18,742$386,407
15
3,617,046$324,761$838,677$2,021,415$83,513$63,348$25,461$18,223$25,284$40,940$0$0$175,433$3,617,046
16
Average17/1816/17$3,617,046
17
Month% Allocated
% Allocated
% Allocated
18
July8.979%7%11%
19
August23.187%33%14%
20
September 55.886%50%62%
21
October2.309%2%3%
22
November1.751%2%2%
23
December0.704%1%1%
24
January0.504%0%1%
25
February0.699%0%1%
26
March1.132%1%1%
27
April 0.000%0%0%
28
May0.000%0%0%
29
June4.850%5%5%
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
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...