Please show formula in excel for problem.

3. You are looking to buy a rental property. After doing some analysis, you figure that this opportunity presents the following cash flows: Up-front cost = $3,500,000 Yearly cash flows (growing at 3%/year forever) = $475,000 Your opportunity cost of capital for this investment is 6.5%. a. What are the NPV and IRR? b. Should you buy it? BU X & fx A B D E F G Rental Property 6.5% 3.0% Answer part 3b in the box below: 2 Discount rate 3 Growth rate 4 NPV 5 IRR 6 Cash flows: 7 Start 8 Year 1 9 Year 2 10 Year 3 11 Year 4 12 Year 5 and on $3,500,000.00 13