You just bought the first floor of the famous York Hill Building for $250,000. You plan to rent the space to convenience stores. Your banker has offered you a mortgage with the following terms: (PLEASE ANSWER IN EXCEL FORMAT WITH FORMULAS)

• The mortgage is for the full amount of $250,000.
• The mortgage will be repaid in equal monthly payments over 36 months, starting 1 month from now.
• The annual interest rate on the mortgage is 8%, compounded monthly.

You have to pay the bank an initiation charge of $1,500 and 1 point.

1. What is the monthly payment you will pay the bank? (5 points)

2. What is the EAR of the mortgage? (10 points)

3. Compute an amortization table for the amount you get (not the amount you borrow). (5 points)