hi i need help worh this problem. can you show your work in excel please

BSE2310-Kamienski-TVM ... Search File Home Insert Formulas Data Review View Help Open in Desktop App Tell me what Calibri 11 BAY. 2b General A1 f A B D E F G H I 3 1 2 3 4 11. Present Values. You can buy property today for $3 million and sell it in 5 years for S4 million. (You can no rental income on the property.) (LOS-2) a. If the interest rate is 8%, what is the present value of the sales price? b. Is the property investment attractive to you? c. Would your answer to part (b) change if you also could earn $200,000 per year rent on the property? The rent is paid at the end of each year. 5 6 7 8 9 10 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 23 0707 0708 0709 VM5 TVM 4 TVM- TV11 TVMV TVM-14 TVM 18 Calculation Mode Auto MacBook Air o 888 35