Cash Flow for T-Hangars
Inputs  
# of T-Hangars              20
Project Costs $1,378,075
Issuance Fees $75,000
Bond Costs $1,453,075
(see "costs revenues" tab for details)
Interest Rate 4.21%
Cost/Revenue Escalation 2.0%
Targeted Rental Rate $255
Additional Costs
Period Year Interest Principal Total Utilities Insurance Maintenance Total Costs Occupancy Rate Base Rental Rate (per Month) Rent Revenues Fuel Flowage Fee Sales Tax on Fuel Sales City Property Taxes on New Aircraft Other Hangar Revenues Total Revenues Profit (Loss) Net Cash Flow
1 2012 $61,220 $95,000 $156,220 $2,400 $2,400 $0 $161,020 80% $255.00 $48,960 $460 $705 $5,360 $17,100 $72,585 ($88,435) ($88,435)
2 2013 $58,418 $100,000 $158,418 $2,448 $2,448 $0 $163,314 90% $255.00 $55,080 $518 $793 $6,090 $17,442 $79,923 ($83,391) ($171,827)
3 2014 $55,258 $105,000 $160,258 $2,497 $2,497 $1,000 $166,252 95% $257.55 $58,721 $546 $846 $6,493 $17,791 $84,397 ($81,855) ($253,681)
4 2015 $51,497 $110,000 $161,497 $2,547 $2,547 $1,000 $167,590 95% $260.13 $59,309 $546 $854 $6,558 $18,147 $85,413 ($82,177) ($335,858)
5 2016 $47,557 $115,000 $162,557 $2,598 $2,598 $2,000 $169,752 95% $262.73 $59,902 $546 $863 $6,623 $18,510 $86,443 ($83,309) ($419,167)
6 2017 $42,953 $115,000 $157,953 $2,650 $2,650 $2,000 $165,252 95% $265.35 $60,501 $546 $871 $6,690 $17,621 $86,229 ($79,023) ($498,191)
7 2018 $38,349 $120,000 $158,349 $2,703 $2,703 $3,000 $166,755 95% $268.01 $61,106 $546 $880 $6,756 $17,974 $87,262 ($79,493) ($577,683)
8 2019 $33,039 $130,000 $163,039 $2,757 $2,757 $3,000 $171,553 95% $270.69 $61,717 $546 $660 $6,824 $18,333 $88,080 ($83,473) ($661,156)
9 2020 $27,287 $135,000 $162,287 $2,812 $2,812 $4,000 $171,911 95% $273.39 $62,334 $546 $667 $6,892 $68,894 $139,333 ($32,578) ($693,734)
10 2021 $20,745 $140,000 $160,745 $2,868 $2,868 $4,000 $170,481 95% $276.13 $62,957 $546 $674 $6,961 $70,271 $141,410 ($29,072) ($722,806)
11 2022 $13,960 $145,000 $158,960 $2,926 $2,926 $5,000 $169,812 95% $278.89 $63,587 $546 $680 $7,031 $70,287 $142,131 ($27,680) ($750,486)
12 2023 $6,934 $143,075 $150,009 $2,984 $2,984 $5,000 $160,977 95% $281.68 $64,223 $546 $687 $7,101 $71,693 $144,250 ($16,727) ($767,212)
13 2024 $0 $3,044 $3,044 $6,000 $12,088 95% $284.50 $64,865 $546 $694 $7,172 $66,735 $140,012 $127,925 ($639,288)
14 2025 $0 $3,105 $3,105 $6,000 $12,209 95% $287.34 $65,514 $546 $701 $7,244 $68,070 $142,074 $129,865 ($509,423)
15 2026 $0 $3,167 $3,167 $7,000 $13,333 95% $290.21 $66,169 $546 $708 $7,316 $69,431 $144,170 $130,837 ($378,586)
16 2027 $0 $3,230 $3,230 $7,000 $13,460 95% $293.12 $66,830 $546 $715 $7,389 $69,285 $144,766 $131,306 ($247,280)
17 2028 $0 $3,295 $3,295 $8,000 $14,589 95% $296.05 $67,499 $546 $722 $7,463 $70,671 $146,901 $132,312 ($114,968)
18 2029 $0 $3,361 $3,361 $8,000 $14,721 95% $299.01 $68,174 $546 $729 $7,538 $68,556 $145,543 $130,822 $15,854
19 2030 $0 $3,428 $3,428 $9,000 $15,856 95% $302.00 $68,855 $546 $737 $7,613 $69,927 $147,679 $131,823 $147,677
20 2031 $0 $3,496 $3,496 $9,000 $15,993 95% $305.02 $69,544 $546 $744 $7,689 $71,325 $149,849 $133,857 $281,534
21 2032 $0 $3,566 $3,566 $10,000 $17,133 95% $308.07 $70,239 $546 $752 $7,766 $71,058 $150,362 $133,229 $414,763
22 2033 $0 $3,638 $3,638 $10,000 $17,275 95% $311.15 $70,942 $546 $759 $7,844 $72,479 $152,570 $135,295 $550,058
23 2034 $0 $3,710 $3,710 $11,000 $18,421 95% $314.26 $71,651 $546 $767 $7,922 $70,033 $150,919 $132,499 $682,557
24 2035 $0 $3,785 $3,785 $11,000 $18,569 95% $317.40 $72,368 $546 $774 $8,002 $71,434 $153,124 $134,554 $817,111
25 2036 $0 $3,860 $3,860 $12,000 $19,720 95% $320.58 $73,091 $546 $782 $8,082 $72,862 $155,364 $135,643 $952,754
26 2037 $0 $3,937 $3,937 $12,000 $19,875 95% $323.78 $73,822 $546 $790 $8,162 $72,449 $155,770 $135,895 $1,088,650
27 2038 $0 $4,016 $4,016 $13,000 $21,032 95% $327.02 $74,561 $546 $798 $8,244 $73,898 $158,047 $137,014 $1,225,664
28 2039 $0 $4,097 $4,097 $13,000 $21,193 95% $330.29 $75,306 $546 $806 $8,327 $71,075 $156,060 $134,866 $1,360,531
29 2040 $0 $4,178 $4,178 $14,000 $22,357 95% $333.59 $76,059 $546 $814 $8,410 $72,496 $158,325 $135,968 $1,496,499
30 2041 $0 $4,262 $4,262 $14,000 $22,524 95% $336.93 $76,820 $546 $822 $8,494 $73,946 $160,628 $138,104 $1,634,603
Total $457,216 $1,453,075 $1,910,291 $97,363 $97,363 $210,000 $2,315,018 $1,990,706 $16,273 $22,794 $220,057 $1,699,792 $3,949,621 $1,634,603
Rental Rate assumes a 2 year contract, half of all contracts renew each year $2,249,829 $2,315,018