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