EIGHT Problems in the attached file.Assignment #4-Chapter 4&5.pdf Submit your work in an Excel sheet. Try to explain and discuss your work as much as you can. Next Transform the cash flows on the left-hand side of the accompanying diagram to their equivalent 1. amount, F, shown on the right-hand side. The interest rate is 8% per year. 100 100 TIILI. 100 100 100 100 4 7 4 5 6 3 End of Year End of Year 2. Determine the value of PO, as a function of H, for these two investment alternatives to be equivalent at an interest rate of i =15 % per year. 2 P 1.7H 10 15 5 10 P End of Year End of Year 10 3. Suppose that annual income from a rental property is expected to start at $1,300 per year and decrease at a uniform amount of $50 each year after the first year for the 15-year expected life of the property. The investment cost is $8,000, and i is 9 % per year. Is this a good investment? Assume that the investment occurs at time zero (now) and that the annual income is first received at EOY one