A piece of lakefront real estate is currently valued at $$150,000.$ You don$$t have the money to purchase the real estate now but the owner has committed to sell it to you in $5$ years for the $$100,000$ PLUS $4\%$ appreciation in price each year. A$)$ How much are you going to have to pay for the property in $5$ years time if you agree to pay the owner her $$150,000$ PLUS the $4\%$ appreciation per year? B$)$ Let$$s say you currently have $$90,000$ in savings and you hope to be able to contribute $$7,000$ annually to your purchase funds. What type of return are you going to have to achieve over the $5$ year period in order to reach your required amount calculated in Part A$?$

$***$Please show excel formulas and answers