Please answer #3 using excel.

2. An investor plans on buying a $1 million property with 5% down and annual financing of 4% for 12 years. The property will be sold five years after its purchase for $1.25 million, Determine the monthly payment on the loan. What is the monthly growth rate for the value of the property over the 5 years? At the end of year 3 the investor pays an additional $20,000 on the principal. What percentage of the equity after 5 years comes from paying down the principal? What will be the annual rate of return on this investment after five years based on the above projections? 3. What annual rate of return would the investor earn in the above problem if the borrowing costs were lowered to 2%? (Easiest thing to do would be to copy the work into another tab and then just change the financing rate.) 2. An investor plans on buying a $1 million property with 5% down and annual financing of 4% for 12 years. The property will be sold five years after its purchase for $1.25 million, Determine the monthly payment on the loan. What is the monthly growth rate for the value of the property over the 5 years? At the end of year 3 the investor pays an additional $20,000 on the principal. What percentage of the equity after 5 years comes from paying down the principal? What will be the annual rate of return on this investment after five years based on the above projections? 3. What annual rate of return would the investor earn in the above problem if the borrowing costs were lowered to 2%? (Easiest thing to do would be to copy the work into another tab and then just change the financing rate.)