DETAILED STEPS PLEASE. I NEED THE TABLE BELOW FILLED OUT. THANKS IN ADVANCE!

John and Sally Claussen are contemplating the purchase of a hardware store from John Duggan. The Claussens anticipate that the store will generate cash flows of $85,000 per year for 20 years. At the end of 20 years, they intend to sell the store for an estimated $550,000. The Claussens will finance the investment with a variable rate mortgage. Interest rates will increase twice during the 20-year life of the mortgage. Accordingly, the Claussens desired rate of return on this investment varies as follows: (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) (Use appropriate factor(s) from the tables provided.) Years 15 7 % Years 610 9 % Years 1120 11 % Required: What is the maximum amount the Claussens should pay John Duggan for the hardware store? (Assume that all cash flows occur at the end of the year.) ReferenceseBook & Resources

Required: What is the maximum amount the Claussens should pay John Duggan for the hardware store? (Assume that all cash flows occur at the end of the year.) PV of annual PV of selling Maximum paid cash flow for store price 348,517 Years 1-5 Years 6-10 Years 11-20 Year 20 Total 348,517 348,517