I NEED HELP WITH THIS QUESTION USING EXCEL CALCULATIONS AND FILLING OUT THE TABLE PROPERLY. PLEASE SHOW WORK

Student Name: Class: Problem 05-05 Maximum Purchase Price * Use the Present and Future Value Tables in the text or enter the proper formula rounded to 5 decimal places P 5-5 Investment decision; varying rates - LO5-3, LO5-8 John and Sally Claussen are considering the purchase of a hardware store from John Duggan. The Claussens anticipate that the store will generate cash flows of $70,000 per year for 20 years. At the end of 20 years, they intend to sell the store for an estimated $400,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: 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.) Student Name: Class: Problem 05-05 Maximum Purchase Price * Use the Present and Future Value Tables in the text or enter the proper formula rounded to 5 decimal places P 5-5 Investment decision; varying rates - LO5-3, LO5-8 John and Sally Claussen are considering the purchase of a hardware store from John Duggan. The Claussens anticipate that the store will generate cash flows of $70,000 per year for 20 years. At the end of 20 years, they intend to sell the store for an estimated $400,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: 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.)