Attainable Cash Flow Proforma for a 5 Mile Platte Valley Circulator |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Franchise
funded Privately $88,400,000 |
|
|
|
How calculated |
Construct |
year 1 |
year 2 |
year 3 |
year 4 |
year 5 |
year 6 |
year 7 |
year 8 |
year 9 |
year 10 |
year 11 |
year 12 |
year 13 |
year 14 |
year 15 |
year 16 |
year 17 |
year 18 |
year 19 |
year 20 |
year 21 |
year 22 |
year 23 |
year 24 |
year 25 |
Totals |
Category |
|
|
|
|
|
|
|
|
|
|
|
Revenues:
($ for ave dailey pass) |
|
$1.00 |
$1.035 |
$1.07 |
$1.11 |
$1.15 |
$1.19 |
$1.23 |
$1.27 |
$1.32 |
$1.36 |
$1.41 |
$1.46 |
$1.51 |
$1.56 |
$1.62 |
$1.68 |
$1.73 |
$1.79 |
$1.86 |
$1.92 |
$1.99 |
$2.06 |
$2.13 |
$2.21 |
$2.28 |
|
Revenues: ($ for ave dailey pass) |
|
CBD
Subscriptions Riders |
12,000 x $1 x 300 days |
|
3,600 |
3,744 |
3,931 |
4,128 |
4,334 |
4,551 |
4,778 |
5,017 |
5,268 |
5,532 |
5,808 |
6,099 |
6,404 |
6,724 |
7,060 |
7,413 |
7,784 |
8,173 |
8,581 |
9,010 |
9,461 |
9,934 |
10,431 |
10,952 |
11,500 |
|
Day
Workers that drive |
|
$1
share of parking revenues |
12,000 x $1 x 300days |
|
3,600 |
3,744 |
3,931 |
4,128 |
4,334 |
4,551 |
4,778 |
5,017 |
5,268 |
5,532 |
5,808 |
6,099 |
6,404 |
6,724 |
7,060 |
7,413 |
7,784 |
8,173 |
8,581 |
9,010 |
9,461 |
9,934 |
10,431 |
10,952 |
11,500 |
|
Parking for Day Workers |
|
Riders from
RTD |
5,000 x .50c x 300days |
|
750 |
780 |
819 |
860 |
903 |
948 |
995 |
1,045 |
1,098 |
1,152 |
1,210 |
1,271 |
1,334 |
1,401 |
1,471 |
1,544 |
1,622 |
1,703 |
1,788 |
1,877 |
1,971 |
2,070 |
2,173 |
2,282 |
2,396 |
|
Commuters
RTD |
|
Event
visitors |
3,000 x $2 x 100
days |
|
|
600 |
624 |
655 |
688 |
722 |
758 |
796 |
836 |
878 |
922 |
968 |
1,016 |
1,067 |
1,121 |
1,177 |
1,235 |
1,297 |
1,362 |
1,430 |
1,502 |
1,577 |
1,656 |
1,738 |
1,825 |
1,917 |
|
Event Visitors Nights |
|
$1.50 share
of event parkg |
2,000 x $5 x 100 days |
|
1,000 |
1,040 |
1,092 |
1,147 |
1,204 |
1,264 |
1,327 |
1,394 |
1,463 |
1,537 |
1,613 |
1,694 |
1,779 |
1,868 |
1,961 |
2,059 |
2,162 |
2,270 |
2,384 |
2,503 |
2,628 |
2,759 |
2,897 |
3,042 |
3,194 |
|
Parking for Events |
|
Hotel tourists |
1,000 x $3 x
300 days |
900 |
936 |
992 |
1,052 |
1,115 |
1,182 |
1,253 |
1,328 |
1,407 |
1,492 |
1,581 |
1,676 |
1,777 |
1,883 |
1,996 |
2,116 |
2,243 |
2,378 |
2,520 |
2,672 |
2,832 |
3,002 |
3,182 |
3,373 |
3,575 |
|
Hotel
tourists |
|
Business Visitors |
2,000 x $3 x 300 days |
|
1,800 |
1,872 |
1,966 |
2,064 |
2,167 |
2,275 |
2,389 |
2,509 |
2,634 |
2,766 |
2,904 |
3,049 |
3,202 |
3,362 |
3,530 |
3,706 |
3,892 |
4,086 |
4,291 |
4,505 |
4,730 |
4,967 |
5,215 |
5,476 |
5,750 |
|
Business
Visitors |
|
$1 Parking for Business Visitors |
1500 x $3 x 300 days |
|
450 |
468 |
487 |
506 |
526 |
547 |
569 |
592 |
616 |
640 |
666 |
693 |
720 |
749 |
779 |
810 |
843 |
877 |
912 |
948 |
986 |
1,025 |
1,066 |
1,109 |
1,153 |
|
|
Cargo and
Advertising |
|
|
|
300 |
315 |
331 |
347 |
365 |
383 |
402 |
422 |
443 |
465 |
489 |
513 |
539 |
566 |
594 |
624 |
655 |
688 |
722 |
758 |
796 |
836 |
878 |
921 |
968 |
|
Cargo Packages |
|
Residential Subscriptions |
500 x $1 x 300 days |
|
150 |
158 |
165 |
174 |
182 |
191 |
201 |
211 |
222 |
233 |
244 |
257 |
269 |
283 |
297 |
312 |
327 |
344 |
361 |
379 |
398 |
418 |
439 |
461 |
484 |
|
Residents |
|
Total
Revenues from Weekdays (6) Traffic |
|
13,150 |
13,681 |
14,369 |
15,093 |
15,853 |
16,651 |
17,490 |
18,372 |
19,298 |
20,270 |
21,292 |
22,366 |
23,494 |
24,680 |
25,925 |
27,233 |
28,608 |
30,052 |
31,570 |
33,165 |
34,840 |
36,601 |
38,450 |
40,394 |
42,436 |
|
Total Weekday traffic |
|
Other Revenues - Sunday
traffic at 5% |
658 |
684 |
718 |
755 |
793 |
833 |
875 |
919 |
965 |
1,014 |
1,065 |
1,118 |
1,175 |
1,234 |
1,296 |
1,362 |
1,430 |
1,503 |
1,579 |
1,658 |
1,742 |
1,830 |
1,923 |
2,020 |
2,122 |
|
Weekend traffic at 12.5% |
|
Total
Revenues |
|
|
|
13,808 |
14,365 |
15,088 |
15,847 |
16,645 |
17,484 |
18,365 |
19,290 |
20,262 |
21,284 |
22,357 |
23,484 |
24,669 |
25,914 |
27,221 |
28,595 |
30,038 |
31,555 |
33,149 |
34,823 |
36,582 |
38,431 |
40,373 |
42,414 |
44,558 |
656,599 |
Total Revenues (000) |
|
|
|
|
|
|
|
|
|
|
|
Costs
and expenses: |
|
|
|
|
|
|
|
|
Costs and expenses: |
|
Admin, Operating
& Maint Costs @ 25% |
3,452 |
3,591 |
3,772 |
3,962 |
4,161 |
4,371 |
4,591 |
4,823 |
5,066 |
5,321 |
5,589 |
5,871 |
6,167 |
6,478 |
6,805 |
7,149 |
7,510 |
7,889 |
8,287 |
8,706 |
9,146 |
9,608 |
10,093 |
10,603 |
11,140 |
164,150 |
Operating Costs @ 25% |
|
less Upgrade & Replacement @ 3% |
|
|
414 |
431 |
453 |
475 |
499 |
525 |
551 |
579 |
608 |
639 |
671 |
705 |
740 |
777 |
817 |
858 |
901 |
947 |
994 |
1,045 |
1,097 |
1,153 |
1,211 |
1,272 |
1,337 |
19,698 |
less upgrades & replacement reserves |
|
Franchize
and Royalty @ 4% |
%x |
$0.0 |
552 |
575 |
604 |
634 |
666 |
699 |
735 |
772 |
810 |
851 |
894 |
939 |
987 |
1,037 |
1,089 |
1,144 |
1,202 |
1,262 |
1,326 |
1,393 |
1,463 |
1,537 |
1,615 |
1,697 |
1,782 |
26,264 |
Franchize royalty @ 4% |
|
|
Total Costs and Expenses |
|
$0.00 |
4,418 |
4,597 |
4,828 |
5,071 |
5,327 |
5,595 |
5,877 |
6,173 |
6,484 |
6,811 |
7,154 |
7,515 |
7,894 |
8,292 |
8,711 |
9,150 |
9,612 |
10,098 |
10,608 |
11,143 |
11,706 |
12,298 |
12,919 |
13,572 |
14,259 |
210,112 |
Total Costs and Expenses |
|
Net
Cash Flow (Before Taxes) |
|
$0.0 |
9,389 |
9,768 |
10,260 |
10,776 |
11,319 |
11,889 |
12,488 |
13,117 |
13,778 |
14,473 |
15,203 |
15,969 |
16,775 |
17,621 |
18,510 |
19,445 |
20,426 |
21,457 |
22,541 |
23,680 |
24,876 |
26,133 |
27,454 |
28,841 |
30,300 |
446,488 |
Net Income (Before taxes) |
|
Cumulative |
|
|
|
9,389 |
19,157 |
29,417 |
40,193 |
51,512 |
63,401 |
75,889 |
89,006 |
102,785 |
117,258 |
132,460 |
148,430 |
165,205 |
182,826 |
201,336 |
220,781 |
241,207 |
262,664 |
285,205 |
308,885 |
333,760 |
359,893 |
387,347 |
416,188 |
446,488 |
|
Costs |
$88,400 |
See Construction Tab |
|
17.1 |
|
|
|
|
505% |
20.2% |
ave py over 25 yrs |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|