Hi tutor, can you please explain to me the requirement of the excel spread sheet that i post below. It is a spread sheet of runway project for Brisbane Airport.

Here is the question: Students to discuss amount of investment, IRR, description of distribution profile and include a chart of distributions for each option

what should i talk about amount of investment, IRR and what is distribution profile?

Carpark Construction Cost $195,000,000 Establishment Costs $15,000,000 Debt to Equity Ratio 40.00% Interest Rate 4.25% Project Metrics Project Year Operations Year Construction Flag Operations Flag Inflation Bank Account Opening Balance Construction Costs Establishment Fee Debt Drawdown Equity Investment Operating Costs Lifecycle Costs Revenue - Car Park Revenue - Vending Machine Revenue - Coffee Cart Debt Payments Equity Distributions Closing Balance Debt Opening Balance Drawdown capitalised interest Principal Repayment Closing Balance Interest Equity Investment Distributions Net Cashflow IRR DSCR Cashflow Available for Debt Service Debt Service DSCR 29% 71% Lifecycle - Year 10 $9,000,000 Lifecycle - Year 20 $2,500,000 Carpark Capacity 1,250 Days available per year 365 Carpark Turnover per day 2.95 Average Car par Fare $13.50 Inflation 2.50% Carpark Lifespan (yrs) 30 Vending Machine Revenue per day $250.00 Coffee Cart Revenue per day $350.00 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 1.00 1.03 1.05 1.08 1.10 1.13 1.16 1.19 1.22 1.25 1.28 1.31 1.34 1.38 1.41 1.45 $0 -$195,000,000 -$15,000,000 $62,550,000 $150,000,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 -$2,550,000 $0 29% 4.25% $30 Construction Period 1 year Operational Costs ($ pa) $3,500,000 $0 $60,000,000 $2,550,000 $62,550,000 4.25% -$3,500,000 -$3,500,000 -$3,500,000 -$3,500,000 -$3,500,000 -$3,500,000 -$3,500,000 -$3,500,000 -$3,500,000 -$3,500,000 -$3,500,000 -$3,500,000 -$3,500,000 $19,090,020 $95,870 $134,217 -$3,727,870 -$12,092,237 $0 $19,567,271 $98,266 $137,573 -$3,727,870 -$12,575,240 $0 $20,056,453 $100,723 $141,012 -$3,727,870 -$13,070,317 $0 $20,557,864 $103,241 $144,537 -$3,727,870 -$13,577,772 $0 $21,071,811 $105,822 $148,151 -$3,727,870 -$14,097,913 $0 $21,598,606 $108,468 $151,855 -$3,727,870 -$14,631,058 $0 $22,138,571 $111,179 $155,651 -$3,727,870 -$15,177,531 $0 $22,692,035 $113,959 $159,542 -$3,727,870 -$15,737,666 $0 -$3,500,000 -$9,000,000 $23,259,336 $116,808 $163,531 -$3,727,870 -$7,311,804 $0 -$3,500,000 $18,624,410 $93,531 $130,944 -$3,727,870 -$11,621,015 $0 $23,840,820 $119,728 $167,619 -$3,727,870 -$16,900,296 $0 $24,436,840 $122,721 $171,810 -$3,727,870 -$17,503,500 $0 $25,047,761 $125,789 $176,105 -$3,727,870 -$18,121,785 $0 $25,673,955 $128,934 $180,507 -$3,727,870 -$18,755,526 $0 $26,315,804 $132,157 $185,020 -$3,727,870 -$19,405,111 $0 $62,550,000 $61,480,505 $60,365,556 $59,203,222 $57,991,488 $56,728,256 $55,411,337 $54,038,448 $52,607,212 $51,115,148 $49,559,672 $47,938,087 $46,247,586 $44,485,238 $42,647,990 -$1,069,495 $61,480,505 -$1,114,949 $60,365,556 -$1,162,334 $59,203,222 -$1,211,733 $57,991,488 -$1,263,232 $56,728,256 -$1,316,919 $55,411,337 -$1,372,889 $54,038,448 -$1,431,236 $52,607,212 -$1,492,064 $51,115,148 -$1,555,477 $49,559,672 -$1,621,584 $47,938,087 -$1,690,502 $46,247,586 -$1,762,348 $44,485,238 -$1,837,248 $42,647,990 -$1,915,331 $40,732,659 -$2,658,375 -$2,612,921 -$2,565,536 -$2,516,137 -$2,464,638 -$2,410,951 -$2,354,982 -$2,296,634 -$2,235,807 -$2,172,394 -$2,106,286 -$2,037,369 -$1,965,522 -$1,890,623 -$1,812,540 $11,621,015 $11,621,015 $12,092,237 $12,092,237 $12,575,240 $12,575,240 $13,070,317 $13,070,317 $13,577,772 $13,577,772 $14,097,913 $14,097,913 $14,631,058 $14,631,058 $15,177,531 $15,177,531 $15,737,666 $15,737,666 $7,311,804 $7,311,804 $16,900,296 $16,900,296 $17,503,500 $17,503,500 $18,121,785 $18,121,785 $18,755,526 $18,755,526 $19,405,111 $19,405,111 $15,348,885 $3,727,870 4.12 $15,820,107 $3,727,870 4.24 $16,303,110 $3,727,870 4.37 $16,798,188 $3,727,870 4.51 $17,305,642 $3,727,870 4.64 $17,825,783 $3,727,870 4.78 $18,358,928 $3,727,870 4.92 $18,905,401 $3,727,870 5.07 $19,465,536 $3,727,870 5.22 $11,039,675 $3,727,870 2.96 $20,628,167 $3,727,870 5.53 $21,231,371 $3,727,870 5.70 $21,849,655 $3,727,870 5.86 $22,483,396 $3,727,870 6.03 $23,132,981 $3,727,870 6.21 -$150,000,000 $599,180,901 $449,180,901 9.94% $711,017,010 $111,836,109 -$150,000,000 Runway Construction Cost (spread evenly over the construction period) $1,200,000,000 Establishment Costs $85,000,000 Project Metrics Project Year Operations Year Construction Flag Operations Flag Inflation Bank Account Opening Balance Construction Costs Establishment Fee Debt Drawdown Equity Investment Operating Costs Lifecycle Costs Revenue Debt Payments Equity Distributions Closing Balance Debt Opening Balance Drawdown Capitalised Interest Principal Repayment (term) Closing Balance Interest Equity Investment Distributions Net Cashflow IRR DSCR Cashflow Available for Debt Service Debt Service DSCR Debt to Equity Ratio 80.00% Interest Rate 4.25% Construction Period 3 Years Operational Costs ($ pa) $65,000,000 0 -2 3 1 -1 2 2 0 1 1.00 1.03 $1,200,000,000 $85,000,000 44% 56% $3,250,000,000 $125,000,000 $14,560,723,406 $1,469,864,318.48 $9,990,131,309.24 $0 -$400,000,000 -$85,000,000 $224,716,667 $269,444,444 $0 $0 $0 -$9,161,111 $0 $0 44% 4.25% 50 $0 $215,555,556 $9,161,111 $0 $224,716,667 4.25% Lifecycle - Year 10 $75,000,000 Lifecycle - Year 20 $50,000,000 Planes Per Day 400 Days available per year 365 Revenue Per Plane $950 Runway Lifespan (yrs) 50 Inflation 2.50% 3 1 4 2 5 3 6 4 7 5 8 6 9 7 10 8 11 9 12 10 13 11 14 12 15 13 1.05 50 1.08 49 1.10 48 1.13 47 1.16 46 1.19 45 1.22 44 1.25 43 1.28 42 1.31 41 1.34 40 1.38 39 1.41 38 1.45 $0 -$400,000,000 $0 $185,333,333 $222,222,222 $0 $0 $0 -$7,555,556 $0 $0 $0 -$400,000,000 $0 $185,333,333 $222,222,222 $0 $0 $0 -$7,555,556 $0 $0 $0 $0 $0 $0 $0 -$65,000,000 $0 $149,364,730 -$28,911,842 -$55,452,888 $0 $0 $0 $0 $0 $0 -$65,000,000 $0 $153,098,848 -$28,911,842 -$59,187,006 $0 $0 $0 $0 $0 $0 -$65,000,000 $0 $156,926,319 -$28,911,842 -$63,014,477 $0 $0 $0 $0 $0 $0 -$65,000,000 $0 $160,849,477 -$28,911,842 -$66,937,635 $0 $0 $0 $0 $0 $0 -$65,000,000 $0 $164,870,714 -$28,911,842 -$70,958,872 $0 $0 $0 $0 $0 $0 -$65,000,000 $0 $168,992,482 -$28,911,842 -$75,080,640 $0 $0 $0 $0 $0 $0 -$65,000,000 $0 $173,217,294 -$28,911,842 -$79,305,452 $0 $0 $0 $0 $0 $0 -$65,000,000 $0 $177,547,726 -$28,911,842 -$83,635,884 $0 $0 $0 $0 $0 $0 -$65,000,000 $0 $181,986,419 -$28,911,842 -$88,074,578 $0 $0 $0 $0 $0 $0 -$65,000,000 $75,000,000 $186,536,080 -$28,911,842 -$167,624,238 $0 $0 $0 $0 $0 $0 -$65,000,000 $0 $191,199,482 -$28,911,842 -$97,287,640 $0 $0 $0 $0 $0 $0 -$65,000,000 $0 $195,979,469 -$28,911,842 -$102,067,627 $0 $0 $0 $0 $0 $0 -$65,000,000 $0 $200,878,956 -$28,911,842 -$106,967,114 $0 $224,716,667 $177,777,778 $7,555,556 $0 $410,050,000 $410,050,000 $177,777,778 $7,555,556 $0 $595,383,333 $595,383,333 $0 $0 -$3,608,050 $591,775,283 $591,775,283 $0 $0 -$3,761,392 $588,013,891 $588,013,891 $0 $0 -$3,921,252 $584,092,639 $584,092,639 $0 $0 -$4,087,905 $580,004,734 $580,004,734 $0 $0 -$4,261,641 $575,743,094 $575,743,094 $0 $0 -$4,442,760 $571,300,333 $571,300,333 $0 $0 -$4,631,578 $566,668,755 $566,668,755 $0 $0 -$4,828,420 $561,840,336 $561,840,336 $0 $0 -$5,033,628 $556,806,708 $556,806,708 $0 $0 -$5,247,557 $551,559,151 $551,559,151 $0 $0 -$5,470,578 $546,088,573 $546,088,573 $0 $0 -$5,703,078 $540,385,496 $540,385,496 $0 $0 -$5,945,458 $534,440,037 -$7,555,556 -$7,555,556 -$25,303,792 -$25,150,450 -$24,990,590 -$24,823,937 -$24,650,201 -$24,469,081 -$24,280,264 -$24,083,422 -$23,878,214 -$23,664,285 -$23,441,264 -$23,208,764 -$22,966,384 $713,888,889 $9,990,131,309 $406,949,441 11.94% -$269,444,444 $0 -$269,444,444 -$222,222,222 $0 -$222,222,222 -$222,222,222 $0 -$222,222,222 $0 $55,452,888 $55,452,888 $0 $59,187,006 $59,187,006 $0 $63,014,477 $63,014,477 $0 $66,937,635 $66,937,635 $0 $70,958,872 $70,958,872 $0 $75,080,640 $75,080,640 $0 $79,305,452 $79,305,452 $0 $83,635,884 $83,635,884 $0 $88,074,578 $88,074,578 $0 $167,624,238 $167,624,238 $0 $97,287,640 $97,287,640 $0 $102,067,627 $102,067,627 $0 $106,967,114 $106,967,114 $11,435,723,406 $1,445,592,096 $0 $0 0.00 $0 $0 0.00 $0 $0 0.00 $84,364,730 $28,911,842 2.92 $88,098,848 $28,911,842 3.05 $91,926,319 $28,911,842 3.18 $95,849,477 $28,911,842 3.32 $99,870,714 $28,911,842 3.45 $103,992,482 $28,911,842 3.60 $108,217,294 $28,911,842 3.74 $112,547,726 $28,911,842 3.89 $116,986,419 $28,911,842 4.05 $196,536,080 $28,911,842 6.80 $126,199,482 $28,911,842 4.36 $130,979,469 $28,911,842 4.53 $135,878,956 $28,911,842 4.70 Executive Summary Sources & Uses of Funds Graph 1 - Equity Distribution Profile (column chart) Carpark Construction Operations Total Runway Construction Operations $595,383,333 $0 $713,888,889 $0 $0 $14,560,723,406 $1,309,272,222 $14,560,723,406 Total $1,200,000,000 $85,000,000 $0 $0 $24,272,222 $0 $1,309,272,222 $0 $0 $3,250,000,000 $125,000,000 $1,445,592,096 $9,990,131,309 $14,810,723,406 Sources Debt Equity Revenue - Total Uses Construction Costs Establishment Fee Operating Costs Lifecycle Costs Debt Payments Equity Distributions $450,000,000 $400,000,000 $350,000,000 $300,000,000 $250,000,000 $200,000,000 $150,000,000 $100,000,000 Key Debt Metrics Debt to Equity Ratio DSCR - Minimun DSCR - Average % Ratio Ratio % Ratio Ratio 80% 2.92 7.91 Key Equity Metrics IRR % % 11.94% Carpark Revenue Attribution Carpark Revenue Vending Machine Revenue Coffee Cart Revenue equity Distribution of runway Total $'s % $50,000,000 $0