Complete/answer each of the following problems providing an Excel spreadsheet with the solution to receive full credit. Do not provide just numbers but the formulas in Excel with the right answer. It is required to calculate the cash flows period per period (monthly), the loan amortization schedule payment per payment for the entire term of the loan even if canceled early, etc. Explain with your own word the calculations you have done step by step; do not just copy a solution you can find online because without formulas or explanation you will not receive any credit. Calculation without formulas and functions in Excel will receive zero points. A message saying calculations were done in a financial calculator are not accepted.

You are considering the purchase of a property today for $400,000. You plan to finance it with an 80 percent loan. The appreciation rate on the property value is expected to be 5 percent annually for the next three years.

a) Approximate the expected annual average rate of appreciation on home equity for the next three years.

b) What if you now think that a $400,000 purchase price may be somewhat high and that if you pay this price, the expected appreciation rates in your house price will be as follows: year 1 = 0%, year 2 = 2%, and year 3 = 3%.

How will your answer to part (a) change?

Expectations:

a) Put together a table with the value of the house year by year. The value of the house in each year should be as a formula considering the previous price and the appreciation.

b) Compute the equity in the house year by year as a formula.

c) Compute the appreciation of the equity year by year as a formula.

d) Compute the average appreciation rate (simple average) for the equity with the formula or function in Excel.

e) Compute the average compounding rate of appreciation (also called geometric average or simple the RATE in time value of money) for the equity with the formula or function in Excel.