I-70 Cash Flow
Proforma |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Category |
|
CONSTRUCTION |
|
OPERATION |
OPERATION |
OPERATION |
25 YEAR SUMMARY |
|
|
|
|
|
|
|
|
|
REVENUES |
|
|
fund/constr |
constr/test |
yr-1 |
yr-2 |
yr-3 |
yr-4 |
yr-5 |
yr-6 |
yr-7 |
yr-8 |
yr-9 |
yr-10 |
yr-11 |
yr-12 |
yr-13 |
yr-14 |
yr-15 |
yr-16 |
yr-17 |
yr-18 |
yr-19 |
yr-20 |
yr-21 |
yr-22 |
yr-23 |
yr-24 |
yr-25 |
Totals |
Revenues: |
|
|
50% |
tourist ridership (7,000 p/dx4%p/y inc)[1] |
|
|
|
2.56 |
2.66 |
2.76 |
2.87 |
2.99 |
3.11 |
3.23 |
3.36 |
3.50 |
3.64 |
3.78 |
3.93 |
4.09 |
4.25 |
4.42 |
4.60 |
4.79 |
4.98 |
5.18 |
5.38 |
5.60 |
5.82 |
6.06 |
6.30 |
6.55 |
|
16,547 riders in 25th yr |
|
|
|
|
|
|
|
rountrip fare ace $29 x 2%p/y inc |
|
|
|
$74.10 |
$78.60 |
$81.74 |
$85.01 |
$88.41 |
$91.95 |
$95.63 |
$99.45 |
$103.43 |
$107.57 |
$111.87 |
$116.35 |
$121.00 |
$125.84 |
$130.87 |
$136.11 |
$141.55 |
$147.22 |
$153.10 |
$156.11 |
$162.35 |
$168.85 |
$175.60 |
$182.62 |
$189.93 |
$3,125.28 |
Revenues from tourists |
|
|
|
|
|
|
50% |
Local ridership ,000p/d x 4%p/y inc) |
|
|
|
2.56 |
2.66 |
2.76 |
2.87 |
2.99 |
3.11 |
3.23 |
3.36 |
3.50 |
3.64 |
3.78 |
3.93 |
4.09 |
4.25 |
4.42 |
4.60 |
4.79 |
4.98 |
5.18 |
5.38 |
5.60 |
5.82 |
6.06 |
6.30 |
6.55 |
|
16,547 riders in 25th yr |
|
|
|
|
|
|
|
ave rountrip fare
$20 x 4%p/y Inc |
|
|
|
51.10 |
54.21 |
56.38 |
58.63 |
60.98 |
63.41 |
65.95 |
68.59 |
71.33 |
74.19 |
77.15 |
80.24 |
83.45 |
86.79 |
90.26 |
93.87 |
97.62 |
101.53 |
105.59 |
109.81 |
114.21 |
118.77 |
123.52 |
128.47 |
133.60 |
$2,169.65 |
revenues from Locals |
|
|
|
|
|
|
|
Cargo at 1/4 Local ridership |
|
|
|
$13.55 |
$14.09 |
$14.66 |
$15.24 |
$15.85 |
$16.49 |
$17.15 |
$17.83 |
$18.55 |
$19.29 |
$20.06 |
$20.86 |
$21.70 |
$22.56 |
$23.47 |
$24.41 |
$25.38 |
$26.40 |
$27.45 |
$28.55 |
$29.69 |
$30.88 |
$32.12 |
$33.40 |
$58.02 |
$587.66 |
Revenues from cargo |
|
|
|
|
|
|
|
Advertising at 1/4 local ridership[2] |
|
|
|
$13.55 |
$14.09 |
$14.66 |
$15.24 |
$15.85 |
$16.49 |
$17.15 |
$17.83 |
$18.55 |
$19.29 |
$20.06 |
$20.86 |
$21.70 |
$22.56 |
$23.47 |
$24.41 |
$25.38 |
$26.40 |
$27.45 |
$28.55 |
$29.69 |
$30.88 |
$32.12 |
$33.40 |
$58.02 |
$587.66 |
Revenue from ads, vending, souvenirs, parking, air rights, copyrights,
interest |
|
|
|
|
|
|
GROSS REVENUES |
|
|
|
|
$155.4 |
$163.2 |
$169.7 |
$176.5 |
$183.5 |
$190.9 |
$198.5 |
$206.5 |
$214.7 |
$223.3 |
$232.2 |
$241.5 |
$251.2 |
$261.2 |
$271.7 |
$282.5 |
$293.85 |
$305.60 |
$317.82 |
$327.42 |
$340.51 |
$354.13 |
$368.30 |
$383.03 |
$439.57 |
$6,470.24 |
Total Revenues |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Costs and Expenses: |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Costs and expenses: |
|
|
|
|
|
|
|
|
|
|
|
|
|
Operating Costs at 30% |
|
|
46.62 |
48.95 |
50.91 |
52.94 |
55.06 |
57.26 |
59.55 |
61.94 |
64.41 |
66.99 |
69.67 |
72.46 |
75.35 |
78.37 |
81.50 |
84.76 |
88.15 |
91.68 |
95.35 |
98.22 |
102.15 |
106.24 |
110.49 |
114.91 |
131.87 |
1,965.82 |
Operating Costs |
|
|
|
|
|
|
|
|
|
|
|
|
Franchise and Royalty @ 3% gross[3] |
|
|
$0.0
|
#REF! |
4.66 |
4.89 |
5.09 |
5.29 |
5.51 |
5.73 |
5.96 |
6.19 |
6.44 |
6.70 |
6.97 |
7.25 |
7.54 |
7.84 |
8.15 |
8.48 |
8.82 |
9.17 |
9.53 |
9.82 |
10.22 |
10.62 |
11.05 |
11.49 |
13.19 |
196.58 |
franchise and royalty[4] |
|
|
|
|
|
|
|
|
|
|
|
|
Replacement reserve at 5% gross |
|
|
7.77 |
8.16 |
8.48 |
8.82 |
9.18 |
9.54 |
9.93 |
10.32 |
10.74 |
11.16 |
11.61 |
12.08 |
12.56 |
13.06 |
13.58 |
14.13 |
14.69 |
15.28 |
15.89 |
16.37 |
17.03 |
17.71 |
18.41 |
19.15 |
21.98 |
327.64 |
Replacement Reserves |
|
|
|
|
|
|
|
|
|
|
|
|
Total Costs & Expenses |
|
|
$0.0
|
#REF! |
59.05 |
62.00 |
64.48 |
67.06 |
69.74 |
72.53 |
75.43 |
78.45 |
81.59 |
84.85 |
88.25 |
91.78 |
95.45 |
99.27 |
103.24 |
107.37 |
111.66 |
116.13 |
120.77 |
124.42 |
129.39 |
134.57 |
139.95 |
145.55 |
167.04 |
2,490.04 |
Total Costs & Expenses |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Net Income |
|
|
$158.0 |
$368.6 |
96.35 |
101.16 |
105.21 |
109.42 |
113.79 |
118.34 |
123.08 |
128.00 |
133.12 |
138.45 |
143.98 |
149.74 |
155.73 |
161.96 |
168.44 |
175.18 |
182.19 |
189.47 |
197.05 |
203.00 |
211.12 |
219.56 |
228.34 |
237.48 |
272.53 |
4,062.70 |
Net Income |
|
|
|
|
|
|
|
|
|
|
|
|
Amortized $1.5 B loan/25years/5%[5] |
|
|
104.78 |
104.78 |
104.78 |
104.78 |
104.78 |
104.78 |
104.78 |
104.78 |
104.78 |
104.78 |
104.78 |
104.78 |
104.78 |
104.78 |
104.78 |
104.78 |
104.78 |
104.78 |
104.78 |
104.78 |
104.78 |
104.78 |
104.78 |
104.78 |
104.78 |
$2,514.72 |
Amortized Debt |
|
|
|
|
|
|
|
|
|
|
|
|
Cash Flow |
|
|
-8.43 |
-3.62 |
0.43 |
4.64 |
9.01 |
13.56 |
18.30 |
23.22 |
28.34 |
33.67 |
39.20 |
44.96 |
50.95 |
57.18 |
63.66 |
70.40 |
77.41 |
84.69 |
92.27 |
98.22 |
106.34 |
114.78 |
123.56 |
132.70 |
167.75 |
$1,547.98 |
Cash Flow |
|
|
|
|
|
|
|
|
|
|
|
|
Return On $1.5 B Invested w/o bonds |
(before taxes) |
|
0.06 |
0.07 |
0.07 |
0.07 |
0.08 |
0.08 |
0.08 |
0.09 |
0.09 |
0.09 |
0.10 |
0.10 |
0.10 |
0.11 |
0.11 |
0.12 |
0.12 |
0.13 |
0.13 |
0.14 |
0.14 |
0.15 |
0.15 |
0.16 |
0.18 |
10.83% |
Ave annual Return on $ 1.5 Bil Investment |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|