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:

Year 1-5: 8%

Year 6-10: 10%

Year 11-20: 12%

Required: What is the maximum amount the Claussens should pay John Duggan for the hardware store?

Can someone please help me with the excel spreadsheet? Thank you.

CLAUSSEN PURCHASE Estimated Cash Flows "Facto PVA PV Yearly Time Interest Cash Flow Period Rate Years 1-5 5 T0.000 5 Years 6-10 70.000 5 Years 11-20 70.000 10 5 5 End of Year 20 400,000 10 Maximum Purchase Price * Use the Present and Futute Value Tables in the text or enter the proper formula rounded to decimal places