do not really give me the answer,just tell me how to solve it
K 0 Q B C D E F G H M N P S 20,000,000 Add X-Change 88,187 2.44 78,436,743 11,402,262 500,000 66,534,481 24,750,876 24,750,876 2.69 46,534,481 13,479,381 -93,781,076 21,783,605 14 93,000 2.50 84,785,307 11,972,376 500,000 72,312,932 24.750,876 2,653,900 27,404,776 2.64 72,312,932 19,042,255 -74,738,821 44,908,155 15 96,720 2.56 90,381,137 12,570,994 500,000 77,310,143 24,750,876 2,653,900 27,404,776 2.82 77,310,143 18,507,434 -56,231,387 49,905,367 16 100,589 2.62 96,346,292 13,199,544 500,000 82,646,748 24,750,876 2,653,900 27,404,776 3.02 82,646,748 17,986,340 -38,245,047 55,241,972 104,612 2.69 102,705,148 13,859,521 500.000 88.345,626 24,750,876 2,653,900 27,404,776 3.22 88,345,626 17,478,711 -20,766,336 60,940,850 17 18 108,797 2.76 109,483,687 14,552,497 500,000 94,431,190 24,750,876 2,653,900 27,404,776 3.45 94,431, 190 16,984,280 -3,782,056 67,026,414 113,149 2.83 116,709,611 15,280,122 500.000 100,929,489 24,750,876 2,653,900 27,404,776 3.68 100,929,489 16,502,778 12,720,722 73,524,712 19 20 117,675 2.90 124,412,445 16,044,128 500,000 107,868,317 24,750,876 2,653,900 27,404,776 3.94 107,868,317 16,033,938 28,754,660 80,463,540 21 122,382 2.97 132,623,666 16,846,335 500.000 115,277,332 24,750,876 2.653,900 27,404,776 4.21 115,277,332 15,577,492 44,332, 151 87,872,555 127,277 3.04 141,376,828 17,688,651 500,000 123, 188,177 24,750,876 2,653,900 27,404,776 4.50 123, 188, 177 15, 133,172 59,465,323 95,783,401 22 23 40,000,000 Add Capacity 132,400 3.12 150,744,134 18,573,084 500,000 131,671,050 24,750,876 2,653,900 27,404,776 4.80 91,671,050 10,237,654 69,702,977 64,266,274 24 132,400 3.20 154,512,738 19,501,738 500,000 134,511,000 24,750,876 2,653,900 5,307,801 32,712,577 4.11 134,511,000 13,656,310 83,359,287 101,798,423 25 132,400 3.28 158,375,556 20,476,825 500.000 137,398,731 24.750,876 2,653,900 5,307,801 32,712,577 4.20 137,398,731 12,681,353 96,040,640 104,686,154 26 132,400 3.3 162,334,945 21,500,666 500,000 140,334,279 24,750,876 5,307,801 30,058,677 4.67 140,334,279 11,774,811 107,815,451 110,275,602 132,400 3.44 166,393,319 22,575,700 500.000 143,317,619 24,750 5,307,801 30,058,677 4.77 143,317,619 10,931,936 118,747,387 113,258,942 27 28 132,400 3.53 170,553, 152 23,704,485 500,000 146,348,667 24,750,876 5,307,801 30,058,677 4.87 146,348,667 10,148,307 128,895,694 116,289,990 29 132,400 3.62 174,816,980 24,889,709 500,000 149,427,272 24,750,876 5,307,801 30,058,677 4.97 149,427,272 9,419,807 138,315,501 119,368,595 30 132,400 3.71 179,187,405 26,134,194 500,000 152,553,211 24,750,876 5,307,801 30,058,677 5.08 152,553,211 8,742,604 147,058,104 122.494.534 31 132,400 3.80 3,667,090 27,440,904 500.000 155,726,186 ,750,876 5,307,801 30,058,677 5.18 155,726,186 8,113,129 155,171,234 125.667.509 32 132,400 3.90 188,258,767 28,812,949 500,000 158,945,818 24,750,876 5,307,801 30,058,677 5.29 158,945,818 7,528,062 162,699,296 128,887,141 33 132,400 3.99 192,965,237 30,253,597 500,000 162,211,640 5,307,801 5,307,801 30.56 162,211,640 6,984,308 169,683,604 156,903,839 34 132,400 4.09 197,789,367 31,766,276 500,000 165,523,091 5,307,801 5,307,801 31.18 165,523,091 6,478,990 176,162,594 160,215,290 35 132,400 4.20 202,734,102 33,354,590 500,000 168,879,511 5,307.801 5,307,801 31.82 168,879,511 6,009,426 182, 172,020 163,571,711 36 132,400 4.30 207,802,454 35,022,320 500,000 172,280,134 Infinite 172,280, 134 5,573,122 187,745,142 172,280,134 37 132,400 4.41 212,997,516 36,773,436 500,000 175,724,080 Infinite 175,724,080 5,167,755 192,912,897 175,724,080 132,400 1.52 218,322,453 38,612,108 500.000 179,210,346 Infinite 179,210,346 4,791,164 197,704,061 179,210,346 38 39 132,400 4.63 223,780,515 40,542,713 500,000 182,737,802 Infinite 182,737,802 4,441,336 202,145,397 182,737,802 40 132,400 4.75 229,375,028 42,569,849 500.000 186,305,179 Infinite 186,305,179 4,116,400 206,261,797 186,305,179 132,400 4.87 235,109,403 44,698,341 500,000 189,911,062 Infinite 189,911,062 3,814,610 210,076,407 189,911,062 41 132,400 4.99 240,987,138 46,933,258 500,000 193,553,880 Infinite 193,553,880 3,534,346 213,610,753 193,553,880 42 43 132,400 5.11 247,011,817 49,279,92 500,000 197,231,896 Infinite 197,231,896 3,274,098 216,884,851 197,231,896 Totals 318,000,000 5,606,745,457 894,878,341 20,500,000 4,691,367,116 742,526,281 31,846,804 63,693,608 838,066,694 4,335,367,116 Average 114,423,588Dulles Greenway Investment Analysis Variables/Parameters C6 = Toll C7 = TollGr $ Tolls/veh (Yrs . 3-6) 2 C8 = TraffGr3_22 Rate of Increase Tolliveh (Yrs. 7-43) 0.025 C9 = TraffGr23_31 Annual Traffic growth % (Yrs 3-22) 10 C10 = OMGr Annual Traffic growth % (Yrs 23-31) C11 = Constint Annual Rate of O&M Growth (%) C12 = DR Construction Loan Interest 8% C13 = StartTraff Assumed Discount Rate 10% IRR on Project NPV Project IRR on Equity 34,000 14% 216,884,851 21% Starting Traffic Volume Intermed. Traffic @ 1st Improvement 93,000 Gross NET Revenues Debt Service Debt Coverage Max. Traffic @ 2nd Improvement 132,400 0&M Annual Ratio: Alt. NPV Project Calculation Costs - Police Lease Paid Net Revenues 30 Yr Fixed 12 Yr Fixed 12 Yr Fixed Net Revenues Net Annual 216,884,851 Toll Gross Toll Resurfacing Metrop. Wash. After O&M and Payment on Payment on Payment on Total Debt Divided by Project Free Year/Index Capital Cost Equity Traffic/day Rate Revenues Toll Collection Airpt. Auth. Lease Paymts Debt First Imprvt. 2nd Improvt. Service Debt Service Cash Flow Pres Val Cum NPV Equity 38,000,000 -38,000,00 -38,000,000 -38,000,000 -38,000,000 129,000,000 Interest During 6,880,000 129,000,000 -117,272,727 -155,272,727 129,000,000 Construction 13,760,000 -129,000,000 -106,611,570 -261,884,298 0 34,000 2.00 24,820,000 7,000,000 500,000 17,320,000 24,750,876 24,750,876 0.70 17,320,000 13,012,772 -248,87 1,525 -7,430,876 37,400 2.00 27,302,000 7,350,000 500,000 19,452,000 24,750,876 24,750,876 0.79 19,452,000 13,285,978 -235,585,547 -5,298,876 41,140 2.00 30,032,200 7,717,500 500,000 21,814,700 24,750,876 24,750,876 0.88 21,814,700 13,545,212 -222,040,335 -2,936,176 45.254 2.05 33,861,306 8,103,375 500,000 25,257,931 24,750,876 24,750,876 1.02 25,257,931 14,257,443 -207,782,892 507,054 49,779 2.10 38,178,622 8,508,544 500.000 29, 170,078 24,750,876 24,750,876 1.18 29,170,078 14,968,862 -192,814,029 4,419,202 54,757 2.15 43,046,396 8,933,971 500,000 33,612,425 24,750,876 24,750,876 1.36 33,612,425 15,680,444 -177,133,585 8,861,549 60,233 2.21 48,534,812 9,380,669 500,000 38,654,142 24,750,876 24,750,876 1.56 38,654,142 16,393,130 -160,740,455 13,903,266 66,256 2.26 54,723,000 9,849,703 500.000 44,373,297 24,750,876 24,750,876 1.79 44,373,297 17,107,827 -143,632,628 19,622,421 72,882 2.32 61,700,183 10,342,188 500,000 50,857,995 24,750,876 24,750,876 2.05 50,857,995 17,825,417 -125,807,211 26,107,119 80,170 2.38 69,566,956 10,859,298 500,000 58,207,659 24,750,876 24,750,876 2.35 58,207,659 18,546,754 -107,260,457 33,456,783 20,000,000 Add X-Change 88,187 2.44 78,436,743 11,402,262 500,000 66,534,481 24,750,876 24,750,876 2.69 46,534,481 13,479,381 93,781,076 21,783,605 93,000 2.50 84,785,307 11,972,376 500,000 72,312,932 24,750,876 2,653,900 27,404,776 2.64 72,312,932 19,042,255 74,738,821 44,908,155 96,720 2.56 90,381,137 12,570,994 500,000 77,310,143 24,750,876 2,653,900 27,404,776 2.82 77,310,143 18,507,434 56,231,387 49,905,367 100,589 2.62 96,346,292 13,199,544 500,000 82,646,748 24,750,876 2,653,900 27,404,776 3.02 82,646,748 17,986,340 -38,245,047 55,241,972 104,612 2.69 102,705,148 13,859,521 500,000 88,345,626 24,750,876 2.653,900 27,404,776 3.22 88.345,626 17,478,711 -20,766,336 60,940,850 108,797 2.76 109,483,687 14,552,497 500,000 94,431, 190 24,750,876 2,653,900 27,404,776 3.45 94,431, 190 16,984,280 -3,782,056 67,026,414 19 113,149 2.83 116,709,611 15,280, 122 500,000 100,929,489 24,750,876 2,653,900 27,404,776 3.68 100,929,489 16,502,778 12,720,722 73,524,712 20 117,675 2.90 124,412,445 16,044,128 500,000 107,868,317 24,750,876 2,653,900 27,404,776 3.94 107,868,317 16,033,938 28,754,660 80,463,540 21 122,382 2.97 132,623,666 16,846,335 500,000 115,277,332 24,750,876 2,653,900 27,404,776 4.21 115,277,332 15,577,492 44,332,151 87,872,555 59,465,323 95,783,401 22 127,277 3.04 141,376,828 17,688,651 500,000 123,188,177 24,750,876 2,653,900 27,404,776 4.50 123, 188, 177 15,133,172 23 40,000,000 Add Capacity 132,400 3.12 150,744,134 18,573,084 500,000 131,671,050 24,750,876 2,653,900 27,404,776 4.80 91,671,050 10,237,654 69,702,977 64,266,274 24 132,400 3.20 154,512,738 19,501,738 500,000 134,511,000 24,750,876 2,653,900 5,307,801 32,712,577 4.11 134,511,000 13,656,310 83,359,287 101,798,423 25 132,400 3.2 158,375,556 20,476,825 500.000 137,398,731 24,750,876 2,653,900 5,307,801 32,712,577 4.20 137,398,731 12,681,353 96.040,640 104,686,154 26 132,400 3.36 162,334,945 21,500,666 500,000 140,334,279 24,750,876 5,307,801 30,058,677 4.67 140,334,279 11,774,811 107,815,451 110,275,602 27 132,400 3.44 166,393,319 22,575,700 500,000 143,317,619 24,750,876 5,307,801 30,058,677 4.77 143,317,619 10,931,936 118,747,387 113,258,942 28 132,400 3.53 170,553,152 23,704,485 500,000 146,348,667 24,750,876 5,307,801 30,058,677 4.87 146,348,667 10,148,307 128,895,694 116,289,990 29 132,400 3.62 174,816,980 24,889,709 500,000 149,427,272 24,750,876 5,307,801 30,058,677 4.97 149,427,272 9,419,807 138,315,501 119,368,595 30 132,400 3.71 179,187,405 26,134,194 500,000 152,553,211 24,750,876 5,307,801 30,058,677 5.08 152,553,211 8,742,604 147,058,104 122,494,534 31 132,400 3.80 183,667,090 27,440,904 500,000 155,726,186 24,750,876 5,307,801 30,058,677 5.18 155,726,186 8.113,129 155,171,234 125,667,509QIIBESIIUII A: (fl-U70) 1. Looking at the spreadsheet how much will it cost to develop the Dulles gm 2. How are the values in cells 021 to 061 determined? (DO NOT ANSWER: \"They are determined by the formula F21-B21-G21-H21.\") 3. What is the difference between the values calculated in cells 021 to 061 and the values in cells R21 to R61? 4. How does the Project NPV (Net Present Values) change if the discount rate is 6%, 8%, 10%, 12%, 14%, and 16%? 5. Find the project's IRR (Internal Rate of Return) by using the command \"=IRR\" in the cell value bar
