. An investor bought a $1,400,000 property, 5 years ago by putting 10% down (10% of the value of the property) and financing the rest using a 15 year loan with a rate of 3.6%.

Determine the monthly payment.

Today the property is worth $1,544,000.

How much equity is in the property today?

What percent of the equity today is due to the rise in the value of the property and what percent is due to the paying down of the loan?

If the property is sold today, what would be the rate of return on this investment? (think IRR, inflows and outflows, when and how much)

How much would the property need to be sold for today in order to have a return of 10% a year?

2. A property is bought 7 years ago for $350,000 putting 10% down and financing the rest for 30 years with a fixed rate loan of 5% a year.

What is the monthly payment on the loan?

The property has appreciated at a rate of 0.2% a month.

What is the amount of equity today? What percent of the equity today is due to the increase in the value of the property?

Due to the low down payment, PMI of 1.2% a year is charged based on the initial amount borrowed.

What is the monthly PMI amount (in dollars) charged by the lender?

Create a new tab with the following based on the original information.

An extra $10,000 is paid along with the 12^th payment.

How many months will it take until there is 20% equity in the property?

How much is owed on the loan at that time?