Part 1: Time Value of Money Solve the following questions using TVM functions in Excel. You will receive no credit if you type in numbers instead of using equations/functions/references in cells other than inputs. 10. How much would you pay to participate in a real estate project that pays nothing for the next 10 years and $3,000 for the following 10 years if you can earn 12% return on other investments of similar risk? Assume the annual revenue is generated at the end of the year. 1 RATE NPER PV PMT FY 2 RATE NPER PV PMT FV 3 RATE NPER PV PMT FV 0 1 N 3 4 5 4 Year CF RATE NPV 5 RATE NPER PV PMT FV 0 1 2 3 4 5 6 Year Project 1CF Project 2 CF RATE Project 1NPV Project 2 NPV 7 RATE NPER PV PMT FV 0 1 2 3 4 5 8 Year Project 1CF RATE NPV IRR 9 10