I need help completing this assignments. Specifically in tab 3 of the excel sheet

[Type your Serial Number HERE] HA321 CASE #3 "The G continues..." "THE Beta" Statement of Income-Single Column Format 2014 Forecasted in August 2014 Actual REVENUES: ROOMS FOOD BEVERAGE TELECOMMUNICATIONS RENTALS & OTHER INCOME $19,814,213 $7,476,149 $2,932,485 $711,787 $596,833 $18,974,436 $8,018,354 $3,245,766 $860,434 $851,760 $31,531,467 $31,950,750 $7,089,765 $5,863,831 $1,994,300 $743,651 $0 $15,691,547 $15,839,920 $6,700,856 $6,398,844 $1,818,668 $971,970 $0 $15,890,338 $16,060,412 $2,432,567 $2,499,991 $2,593,668 $2,337,526 $1,655,644 $2,579,114 $1,581,888 $2,968,694 $9,167,316 $9,481,776 $6,672,604 $6,578,636 $2,734,247 $2,620,244 INCOME BEFORE INTEREST, DEPRECIATION AND AMORTIZATION,AND INCOME TAXES (EBITDA) INTEREST EXPENSE $3,938,357 $1,945,230 $3,958,392 $1,819,764 INCOME BEFORE DEPRECIATION AMORTIZATION AND INCOME TAXES DEPRECIATION AND AMORTIZATION GAIN (LOSS) ON SALE OF PROPERTY $1,993,127 $2,500,854 ($1,098) $2,138,628 $2,206,000 $0 ($508,825) ($67,372) $0 $0 TOTAL REVENUES DEPARTMENTAL COSTS AND EXPENSES: ROOMS FOOD BEVERAGE TELECOMMUNICATIONS RENTALS & OTHER INCOME TOTAL COSTS AND EXPENSES TOTAL OPERATED DEPARTMENTAL INCOME UNDISTRIBUTED OPERATING EXPENSES ADMINISTRATIVE & GENERAL MARKETING PROPERTY OPERATION AND MAINTENANCE UTILITY COSTS TOTAL UNDISTRIBUTED OPERATING EXPENSES INCOME AFTER UNDISTIBUTED OPERATING EXPENSES RENT, PROPERTY TAXES AND INSURANCE INCOME BEFORE INCOME TAXES INCOME TAXES Sheet 1 (Use "page setup" to fit sheet 1 in one page, check it with print-preview Professor A. Neal to make Geller it look SHAprofessional) Cornell University [Type your Serial Number HERE] HA321 CASE #3 "The G continues..." NET INCOME (LOSS) ($508,825) *********************** ($67,372) Q1-1 What could be the vaule of property using VT1: Band of Investment Using "2014 Actual" as One Stabilized Year? Mortgage Finance Terms: 1.Mortgage Interest Rate: 0.0775 2.Mortgate Amortization (in year) 25 3.Mortgate Constant 0.090639 4.Loan to Vaue Ratio: 70% 5.Equity dividend rate (before tax) 0.122 The net cash flow (=EBITDA-Capital Ex. Reserve) is divided by the capitalization rate to calculate the capitalized value $ 1,993,127 divide by WACC= (*Estimate CapEx as the same amount as Int Ex) Q1-2 What could be the vaule of property using VT1: Band of Investment Using "2015 Actual" as One Stabilized Year? 1.Mortgage Interest Rate: 0.0775 2.Mortgage Amortization (in year) 25 3.Mortgage Constant 0.090639 4.Loan to Vaue Ratio: 70% 5.Equity dividend rate (before tax) 0.122 (You may assume all the other variables being equal) The net cash flow (=EBITDA-Capital Ex. Reserve) is divided by the capitalization rate to calculate the capitalized value $ 4,237,761 divide by WACC= (*Estimate CapEx as the same amount as Int Ex) 0 . 4 p o i n t Sheet 1 (Use "page setup" to fit sheet 1 in one page, check it with print-preview Professor A. Neal to make Geller it look SHAprofessional) Cornell University [Type your Serial Number HERE] HA321 CASE #3 "The G continues..." Sheet # 1 2015 Actual 2016 relative variance % $19,933,436 $9,225,911 $3,090,613 $875,442 $750,886 0.60% 23.40% 5.39% 22.99% 25.81% $33,876,288 7.44% $6,984,048 $6,534,047 $1,865,734 $885,320 $0 $16,269,149 $17,607,139 35.04% 70.82% 60.37% 101.13% $2,357,752 $2,329,862 6.96% 6.88% $1,573,002 $2,398,258 4.64% 7.08% $8,658,874 25.56% $8,948,265 26.41% $2,765,116 8.16% $6,183,149 $1,945,388 18.25% 5.74% $4,237,761 $2,307,645 $4,296 12.51% 6.81% $1,934,412 5.71% 48.03% 51.97% $773,765 Sheet 1 (Use "page setup" to fit sheet 1 in one page, check it with print-preview Professor A. Neal to make Geller it look SHAprofessional) Cornell University [Type your Serial Number HERE] HA321 CASE #3 "The G continues..." $1,160,647 3.43% ing "2014 Actual" as One Stabilized Year? Weighted Average cost of capital calculation % of Value Rate pf return WA Mortgate Equity 0 0 Sum = 0 rate to calculate the capitalized value #DIV/0! This sheet 10/70 points ing "2015 Actual" as One Stabilized Year? Weighted Average cost of capital calculation % of Value Rate pf return Mortgate Equity WA 0.00000 0.00000 Sum = 0 rate to calculate the capitalized value #DIV/0! Sheet 1 (Use "page setup" to fit sheet 1 in one page, check it with print-preview Professor A. Neal to make Geller it look SHAprofessional) Cornell University HA321 Case #3 "The G continues..." [Type Your Serial Number HERE] Sheet # 2 "THE BETA" Table 2-1 10 Year Feasibility Study Actual Sheet 2 Base Silumation 1 REVENUES: ROOMS FOOD BEVERAGE TELECOMMUNICATIONS RENTALS & OTHER INCOME TOTAL REVENUES DEPARTMENTAL COSTS AND EXPENSES: ROOMS FOOD BEVERAGE TELECOMMUNICATIONS RENTALS & OTHER INCOME 2013 relative variance % 2014 2015 2016 2017 2018 19,933,436 9,225,911 3,090,613 875,442 750,886 33,876,288 -23.52% -24.24% -4.12% 4.18% 3.80% -20.50% 19,933,436 9,225,911 3,090,613 875,442 750,886 33,876,288 19,933,436 9,225,911 3,090,613 875,442 750,886 33,876,288 19,933,436 9,225,911 3,090,613 875,442 750,886 33,876,288 19,933,436 9,225,911 3,090,613 875,442 750,886 33,876,288 19,933,436 9,225,911 3,090,613 875,442 750,886 33,876,288 6,984,048 6,534,047 1,865,734 885,320 0 35.04% 70.82% 60.37% 101.13% 6,984,048 6,534,047 1,865,734 885,320 0 6,984,048 6,534,047 1,865,734 885,320 0 6,984,048 6,534,047 1,865,734 885,320 0 6,984,048 6,534,047 1,865,734 885,320 0 6,984,048 6,534,047 1,865,734 885,320 0 16,269,149 48.03% 16,269,149 16,269,149 16,269,149 16,269,149 16,269,149 TOTAL OPERATED DEPARTMENTAL INCOME 17,607,139 51.97% 17,607,139 17,607,139 17,607,139 17,607,139 17,607,139 UNDISTRIBUTED OPERATING EXPENSES ADMINISTRATIVE & GENERAL MARKETING 2,357,752 2,329,862 6.96% 6.88% 2,357,752 2,329,862 2,357,752 2,329,862 2,357,752 2,329,862 2,357,752 2,329,862 2,357,752 2,329,862 PROPERTY OPERATION AND MAINTENANCE 1,573,002 4.64% 1,573,002 1,573,002 1,573,002 1,573,002 1,573,002 UTILITY COSTS 2,398,258 7.08% 2,398,258 2,398,258 2,398,258 2,398,258 2,398,258 TOTAL UNDISTRIBUTED OPERATING EXPENSES 8,658,874 25.56% 8,658,874 8,658,874 8,658,874 8,658,874 8,658,874 TOTAL COSTS AND EXPENSES Sheet 2 (Use "Page Set-up" under "File" menu to fit this sheet in 3 pages. Always utilize "Print-preview" function to make it look professional) HA321 Case #3 "The G continues..." INCOME AFTER UNDISTIBUTED OPERATING EXPENSES RENT, PROPERTY TAXES AND INSURANCE INCOME BEFORE INTEREST, DEPRECIATION AND AMORTIZATION,AND INCOME TAXES (EBITDA) INTEREST EXPENSE INCOME BEFORE DEPRECIATION AMORTIZATION AND INCOME TAXES DEPRECIATION AND AMORTIZATION GAIN (LOSS) ON SALE OF PROPERTY INCOME BEFORE INCOME TAXES INCOME TAXES NET INCOME (LOSS) [Type Your Serial Number HERE] 8,948,265 26.41% 8,948,265 8,948,265 8,948,265 8,948,265 8,948,265 2,765,116 8.16% 2,765,116 2,765,116 2,765,116 2,765,116 2,765,116 6,183,149 18.25% 6,183,149 6,183,149 6,183,149 6,183,149 6,183,149 1,945,388 5.74% 1,840,000 1,799,792 1,756,367 1,709,469 1,658,818 4,237,761 2,307,645 0 1,930,116 0 1,930,116 12.51% 6.81% 4,343,149 2,307,645 0 2,035,504 0 2,035,504 4,383,357 2,307,645 0 2,075,712 0 2,075,712 4,426,781 2,307,645 0 2,119,136 0 2,119,136 4,473,680 2,307,645 0 2,166,035 0 2,166,035 4,524,331 2,307,645 0 2,216,686 0 2,216,686 0 0 0 0 0 Table 2-2 Year NI (=EBITDA-CapEx) Discount factor at 1 6,183,149 2 6,183,149 3 6,183,149 4 6,183,149 5 6,183,149 1 1 1 1 1 Discounted Cas Flow 6,183,149 6,183,149 6,183,149 6,183,149 6,183,149 NI (=EBITDA-CapEx) 6,183,149 6,183,149 6,183,149 6,183,149 6,183,149 5.70% FA2016 You do NOT have t tab. Please proceed from sh 3. (Ref: Capital Expenditure Reserve) Discount Cash Flow Analysis Total Property Yield DCF Total Property Yield (TPY) Simulation 1 5.70% Sheet 2 (Use "Page Set-up" under "File" menu to fit this sheet in 3 pages. Always utilize "Print-preview" function to make it look professional) HA321 Case #3 "The G continues..." DCF Total Property Yield (TPY) Simulation Discount 2 factor at Discounted Cas Flow [Type Your Serial Number HERE] 1 6,183,149 1 6,183,149 1 6,183,149 1 6,183,149 1 6,183,149 NI (=EBITDA-CapEx) DCF Total Property Yield (TPY) Simulation Discount 3 factor at Discounted Cas Flow 6,183,149 6,183,149 6,183,149 6,183,149 6,183,149 1 6,183,149 1 6,183,149 1 6,183,149 1 6,183,149 1 6,183,149 NI (=EBITDA-CapEx) 6,183,149 6,183,149 6,183,149 6,183,149 6,183,149 DCF Total Property Yield (TPY) Simulation Discount 4 factor at Discounted Cas Flow 1 6,183,149 Discount Cash Flow Analysis Equity Component Yield DCF Equity Component Yield(ECY) Simulation 1 DCF Equity Component Yield(ECY) Simulation 2 (Base for Sensitivity Analysis) DCF Equity Component Yield(ECY) Simulation 3 1 1 1 1 6,183,149 6,183,149 6,183,149 6,183,149 *When you estimate capitalized value (using 11th year cash flow divided Year (EBITDA - CApEx) -DS Discount factor at Discounted Cas Flow 1 3,840,548 2 3,840,548 3 3,840,548 4 3,840,548 5 3,840,548 1 3,840,548 1 3,840,548 1 3,840,548 1 3,840,548 1 3,840,548 (EBITDA - CApEx) -DS Discount factor at Discounted Cas Flow 3,840,548 3,840,548 3,840,548 3,840,548 3,840,548 1 3,840,548 1 3,840,548 1 3,840,548 1 3,840,548 1 3,840,548 (EBITDA - CApEx) -DS Discount factor at Discounted Cas Flow 3,840,548 3,840,548 3,840,548 3,840,548 3,840,548 1 3,840,548 1 3,840,548 1 3,840,548 1 3,840,548 1 3,840,548 Sheet 2 (Use "Page Set-up" under "File" menu to fit this sheet in 3 pages. Always utilize "Print-preview" function to make it look professional) HA321 Case #3 "The G continues..." DCF Equity Component Yield(ECY) Simulation 4 (EBITDA - CApEx) -DS Discount factor at Discounted Cas Flow [Type Your Serial Number HERE] 3,840,548 3,840,548 3,840,548 3,840,548 3,840,548 1 3,840,548 1 3,840,548 1 3,840,548 1 3,840,548 1 3,840,548 Task 2-1 First, complete all the tables. Task 2-2 which model's Estimated Market Value is more sensitive to a change in discount factors? TPY or ECY? Why do you think so? Type in one sentence. ---> type answer in one sentence. Do not write more than space between Sheet 2 (Use "Page Set-up" under "File" menu to fit this sheet in 3 pages. Always utilize "Print-preview" function to make it look professional) HA321 Case #3 "The G continues..." Fall 2014 2014 [Type Your Serial Number HERE] 2-3 Assumptions on parameters ADR Growth Expenses Growth 2019 2020 2021 2022 2023 2024 19,933,436 9,225,911 3,090,613 875,442 750,886 33,876,288 19,933,436 9,225,911 3,090,613 875,442 750,886 33,876,288 19,933,436 9,225,911 3,090,613 875,442 750,886 33,876,288 19,933,436 9,225,911 3,090,613 875,442 750,886 33,876,288 19,933,436 9,225,911 3,090,613 875,442 750,886 33,876,288 19,933,436 9,225,911 3,090,613 875,442 750,886 33,876,288 6,984,048 6,534,047 1,865,734 885,320 0 6,984,048 6,534,047 1,865,734 885,320 0 6,984,048 6,534,047 1,865,734 885,320 0 6,984,048 6,534,047 1,865,734 885,320 0 6,984,048 6,534,047 1,865,734 885,320 0 6,984,048 6,534,047 1,865,734 885,320 0 16,269,149 16,269,149 16,269,149 16,269,149 16,269,149 16,269,149 17,607,139 17,607,139 17,607,139 17,607,139 17,607,139 17,607,139 2,357,752 2,329,862 2,357,752 2,329,862 2,357,752 2,329,862 2,357,752 2,329,862 2,357,752 2,329,862 2,357,752 2,329,862 1,573,002 1,573,002 1,573,002 1,573,002 1,573,002 1,573,002 2,398,258 2,398,258 2,398,258 2,398,258 2,398,258 2,398,258 8,658,874 8,658,874 8,658,874 8,658,874 8,658,874 8,658,874 Difference (ADR-Ex) CapEx Reserve(%) Interest Rate Income Tax rate Terminal Cap rate Brokerage & Legal fee Loan Original Amount Annual Debt Service Total Number of payments Sheet 2 (Use "Page Set-up" under "File" menu to fit this sheet in 3 pages. Always utilize "Print-preview" function to make it look professional) HA321 Case #3 "The G continues..." 8,948,265 8,948,265 8,948,265 8,948,265 8,948,265 8,948,265 2,765,116 2,765,116 2,765,116 2,765,116 2,765,116 2,765,116 6,183,149 6,183,149 6,183,149 6,183,149 6,183,149 6,183,149 1,604,115 1,545,036 1,481,231 1,412,322 1,337,899 1,257,523 4,579,033 2,307,645 0 2,271,388 0 2,271,388 4,638,112 2,307,645 0 2,330,467 0 2,330,467 4,701,917 2,307,645 0 2,394,272 0 2,394,272 4,770,827 2,307,645 0 2,463,182 0 2,463,182 4,845,249 2,307,645 0 2,537,604 0 2,537,604 4,925,625 2,307,645 0 2,617,980 0 2,617,980 0 0 0 0 0 0 6 6,183,149 7 6,183,149 8 6,183,149 9 6,183,149 1 1 1 1 1 6,183,149 6,183,149 6,183,149 6,183,149 6,183,149 6,183,149 6,183,149 6,183,149 6,183,149 6,183,149 have to work on this om sheet 1 to sheet [Type Your Serial Number HERE] This entire sheet has 0/ Estimated 10 Market Value (PV) 6,183,149 #DIV/0! 61,831,486 0.00% Sheet 2 (Use "Page Set-up" under "File" menu to fit this sheet in 3 pages. Always utilize "Print-preview" function to make it look professional) HA321 Case #3 "The G continues..." 1 6,183,149 1 6,183,149 1 6,183,149 1 6,183,149 1 6,183,149 6,183,149 6,183,149 6,183,149 6,183,149 6,183,149 1 6,183,149 1 6,183,149 1 6,183,149 1 6,183,149 1 6,183,149 6,183,149 6,183,149 6,183,149 6,183,149 6,183,149 1 1 1 1 1 6,183,149 6,183,149 6,183,149 6,183,149 6,183,149 1th year cash flow divided by the cap rate), do not subtract CapEx reserves from EBITDA [Type Your Serial Number HERE] 61,831,486 61,831,486 61,831,486 6 3,840,548 7 3,840,548 8 3,840,548 9 3,840,548 Estimated 10 Market Value (PV) 3,840,548 #DIV/0! 1 3,840,548 1 3,840,548 1 3,840,548 1 3,840,548 1 3,840,548 3,840,548 3,840,548 3,840,548 3,840,548 3,840,548 1 3,840,548 1 3,840,548 1 3,840,548 1 3,840,548 1 3,840,548 3,840,548 3,840,548 3,840,548 3,840,548 3,840,548 1 3,840,548 1 3,840,548 1 3,840,548 1 3,840,548 1 3,840,548 38,405,478 0.00% 38,405,478 38,405,478 Sheet 2 (Use "Page Set-up" under "File" menu to fit this sheet in 3 pages. Always utilize "Print-preview" function to make it look professional) HA321 Case #3 "The G continues..." 3,840,548 3,840,548 3,840,548 3,840,548 3,840,548 1 3,840,548 1 3,840,548 1 3,840,548 1 3,840,548 1 3,840,548 [Type Your Serial Number HERE] 38,405,478 is more sensitive. more than space between lines. Sheet 2 (Use "Page Set-up" under "File" menu to fit this sheet in 3 pages. Always utilize "Print-preview" function to make it look professional) HA321 Case #3 "The G continues..." "(!) "(2) 0 "(1) - (2)=(3) 0.08 0.03 23000000 $2,342,600.80 20 Year [Type Your Serial Number HERE] Table 2-4 Loan Amortization Table Principal Repaymen Debt Service Interest t 0 0 0 0 Principal Outstanding 23,000,000 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 2,342,601 2,342,601 2,342,601 2,342,601 2,342,601 2,342,601 2,342,601 2,342,601 2,342,601 2,342,601 2,342,601 2,342,601 2,342,601 2,342,601 2,342,601 2,342,601 2,342,601 1,840,000 1,799,792 1,756,367 1,709,469 1,658,818 1,604,115 1,545,036 1,481,231 1,412,322 1,337,899 1,257,523 1,170,717 1,076,966 975,716 866,365 748,266 620,719 502,601 542,809 586,234 633,132 683,783 738,485 797,564 861,369 930,279 1,004,701 1,085,077 1,171,884 1,265,634 1,366,885 1,476,236 1,594,335 1,721,882 22,497,399 21,954,590 21,368,357 20,735,224 20,051,442 19,312,956 18,515,392 17,654,022 16,723,743 15,719,042 14,633,965 13,462,081 12,196,447 10,829,562 9,353,326 7,758,991 6,037,109 18 19 20 2,342,601 2,342,601 2,342,601 482,969 334,198 173,526 1,859,632 2,008,403 2,169,075 4,177,477 2,169,075 0 Sheet 2 (Use "Page Set-up" under "File" menu to fit this sheet in 3 pages. Always utilize "Print-preview" function to make it look professional) HA321 Case #3 "The G continues..." [Type Your Serial Number HERE] is entire sheet has 0/100 points Sheet 2 (Use "Page Set-up" under "File" menu to fit this sheet in 3 pages. Always utilize "Print-preview" function to make it look professional) HA321 Case #3 "The G continues..." [Type Your Serial Number HERE] Sheet 2 (Use "Page Set-up" under "File" menu to fit this sheet in 3 pages. Always utilize "Print-preview" function to make it look professional) HA321 Case #3 "The G continues..." [Type Your Serial Number HERE] Sheet 2 (Use "Page Set-up" under "File" menu to fit this sheet in 3 pages. Always utilize "Print-preview" function to make it look professional) [Make sure to type your Serial # Here] HA321 CASE # 3 The "G" continues... Sheet # 3 "THE G" Table: 3-1 10 Year Feasibility Study Actual Sheet 2 Base Simulation REVENUES: ROOMS FOOD BEVERAGE TELECOMMUNICATIONS RENTALS & OTHER INCOME TOTAL REVENUES DEPARTMENTAL COSTS AND EXPENSES: ROOMS FOOD BEVERAGE TELECOMMUNICATIONS RENTALS & OTHER INCOME relative 2015 variance % 2016 2017 2018 2019 2020 19,933 9,226 3,091 875 751 33,876 -23.52% -24.24% -4.12% 4.18% 3.80% -20.50% 21,428 9,918 3,322 941 807 36,417 23,036 10,662 3,572 1,012 868 39,148 24,763 11,461 3,839 1,088 933 42,084 26,001 12,034 4,031 1,142 979 44,189 27,301 12,636 4,233 1,199 1,028 46,398 6,984 6,534 1,866 885 0 35.04% 70.82% 60.37% 101.13% 7,263 6,795 1,940 921 0 7,554 7,067 2,018 958 0 7,856 7,350 2,099 996 0 8,170 7,644 2,183 1,036 0 8,497 7,950 2,270 1,077 0 16,269 48.03% 16,920 17,597 18,301 19,033 19,794 17,607 51.97% 19,497 21,552 23,784 25,156 26,604 2,358 6.96% 2,330 6.88% 2,452 1,179 2,423 2,550 1,267 2,520 2,652 1,362 2,621 2,758 1,430 2,726 2,869 1,502 2,835 PROPERTY OPERATION AND MAINTENANCE 1,573 4.64% 1,636 1,701 1,769 1,840 1,914 UTILITY COSTS 2,398 7.08% 2,494 2,594 2,698 2,806 2,918 TOTAL COSTS AND EXPENSES TOTAL OPERATED DEPARTMENTAL INCOME UNDISTRIBUTED OPERATING EXPENSES ADMINISTRATIVE & GENERAL Franchise Fee incl mkting fees MARKETING Sheet 3 Mgt Fee: (You are required to hand in only one page from sheet 3. Use "page-set up" to print one page showing at least table 3-6 and Professor A. Neal Geller SHA Cornell University task 3. [Make sure to type your Serial # Here] HA321 CASE # 3 The "G" continues... TOTAL UNDISTRIBUTED OPERATING EXPENSES INCOME AFTER UNDISTIBUTED OPERATING EXPENSES 8,659 25.56% 10,184 10,632 11,102 11,560 12,036 8,948 26.41% 9,313 10,919 12,682 13,596 14,568 Management Fees (Base) 0 0 0 0 0 0 Management Fees (incentive) 0 0 0 0 0 0 RENT, PROPERTY TAXES AND INSURANCE AND AMORTIZATION,AND DEPRECIATION INCOME TAXES (EBITDA) INTEREST EXPENSE 2,765 6,183 8.16% 18.25% 2,876 6,438 2,991 7,928 3,110 9,571 3,235 10,361 3,364 11,204 1,945 5.74% 1,840 1,766 1,685 1,598 1,505 Nothing to work on Tab INCOME BEFORE DEPRECIATION AMORTIZATION AND INCOME TAXES DEPRECIATION AND AMORTIZATION GAIN (LOSS) ON SALE OF PROPERTY INCOME BEFORE INCOME TAXES INCOME TAXES NET INCOME (LOSS) (Ref: Capital Expenditure Reserve) 4,238 12.51% 4,598 6,163 7,886 8,763 9,699 2,308 0 6.81% 2,400 0 2,496 0 2,596 0 2,700 0 2,808 0 1,930 5.70% 2,198 3,667 5,290 6,063 6,891 579.03468 1,351 3.99% 659 1,538 1,100 2,567 1,587 3,703 1,819 4,244 2,067 4,824 1,093 1,174 1,263 1,326 1,392 Table 3-2 Discount Cash Flow Analysis: Total Property Yield (discounted at DJIA + 200bp) Sheet 3 Mgt Fee: (You are required to hand in only one page from sheet 3. Use "page-set up" to print one page showing at least table 3-6 and Professor A. Neal Geller SHA Cornell University task 3. [Make sure to type your Serial # Here] HA321 CASE # 3 The "G" continues... Discount Cash Flow Analysis Year Total Property Yield NI (=EBITDA-CapEx) DCF Total Property Yield (TPY) Simulation Discount 1 factor at 0.175761306 Discounted Cas Flow Discount Factor (DJIA ) 0.15376131 10/100 points in this sheet 0.153761306