$.$

AutoSave Off v Assignment 2 new wos 23 (2).xlsx v Search File Home Insert Draw Page Layout Formulas Data Review View Help Macabacus P17 fx A B C D E F G H 10 11 INSTRUCTIONS: Andre Calugaroiu AC K L M N P 12 You are considering a real estate investment with the following parameters and a five 13 year holding period. 14 Calculate the unlevered and levered NPV and IRR and develop a Mortgage Debt schedule based on the Amortization Period. 15 Please make your calculations to the "right of the data" on this worksheet. 16 Based solely on these calculations, would you proceed with the investment and why? 17 18 19 20 21 22 Purchase price 20,300,000 23 24 Anticipated NOI Year 1 1,500,000 25 Tear 2 1,600,000 26 Year 3 1,650,000 27 Year 4 1,800,000 28 Year 5 1,900,000 29 Year 6 (stabilized) 2,000,000 30 31 Financing 32 LTV 65.0% 33 Payment frequency Monthly 34 Mortgage rate 6.5% 35 Mortgage rate per month 0.5345% 36 Term (years) 5 37 Amortization (years) 25 38 39 Anticipated cap rate on sale 40 Required Equity Return 41 Required WACC 42 43 44 Ready Sheet1 1 11C Accessibility: Good to go Cloudy + 9.0% 15.0% 10.0% Grade (out of 10): Comments Share R + 100% ENG 9:17 PM Q Search US 10/18/2023