Question

In: Finance

You have decided to buy a house for $600,000. You have saved enough money to make...

You have decided to buy a house for $600,000. You have saved enough money to make a 20% down payment, but you will need to borrow the remainder. You arrange for a 30-year mortgage (monthly payments) with a local bank at a stated rate of 3.6% APR. a) What will be your monthly payment? b) Construct the amortization table for the first 12 months of payments (showing how much of your payment goes to principal, how much goes to interest, and the remaining balance on the loan). c) What will be the outstanding balance or remaining principal after 24 monthly payments? In other words, if you decided to pay off the loan after 24 months, how much would you owe?

Solutions

Expert Solution

Loan Required = Price ( 1 -Down Payment Ratio )

= $ 600000 ( 1 - 0.2 )

= $ 600000 * 0.8

= $ 480000

Part A:

Particulars Amount
Loan Amount $         4,80,000.00
Int Rate per month 0.3000%
No. of Months 360

EMI = Loan Amount / PVAF (r%, n)
Where r is Int rate per month & n is no. of months
= $ 480000 / PVAF (0.003 , 360)
= $ 480000 / 219.9517
= $ 2182.3

PVAF = SUm [ PVF(r%, n) ]
PVF(r%, n) = 1 / ( 1 + r)^n
r = Int rate per period
n = No. of periods

Part B:

Period Opening Bal EMI Int Principal Repay Closing Outstanding
1 $         4,80,000.00 $         2,182.30 $            1,440.00 $                742.30 $            4,79,257.70
2 $         4,79,257.70 $         2,182.30 $            1,437.77 $                744.52 $            4,78,513.18
3 $         4,78,513.18 $         2,182.30 $            1,435.54 $                746.76 $            4,77,766.42
4 $         4,77,766.42 $         2,182.30 $            1,433.30 $                749.00 $            4,77,017.42
5 $         4,77,017.42 $         2,182.30 $            1,431.05 $                751.25 $            4,76,266.18
6 $         4,76,266.18 $         2,182.30 $            1,428.80 $                753.50 $            4,75,512.68
7 $         4,75,512.68 $         2,182.30 $            1,426.54 $                755.76 $            4,74,756.92
8 $         4,74,756.92 $         2,182.30 $            1,424.27 $                758.03 $            4,73,998.89
9 $         4,73,998.89 $         2,182.30 $            1,422.00 $                760.30 $            4,73,238.59
10 $         4,73,238.59 $         2,182.30 $            1,419.72 $                762.58 $            4,72,476.01
11 $         4,72,476.01 $         2,182.30 $            1,417.43 $                764.87 $            4,71,711.14
12 $         4,71,711.14 $         2,182.30 $            1,415.13 $                767.16 $            4,70,943.97

Opening Bal = Previous Month closing baance

Instalment = EMI as calculated in Part A

Int = Opening Balance * 0.3%

Principal repay = Instalment - Int

CLsoing Balance = Opening Balnce - Principal Repay

Int - 17131.55

Principal - 9056.03

CLosing Balance - 470943.97

Part C:

Period Opening Bal EMI Int Principal Repay Closing Outstanding
1 $         4,80,000.00 $         2,182.30 $            1,440.00 $                742.30 $            4,79,257.70
2 $         4,79,257.70 $         2,182.30 $            1,437.77 $                744.52 $            4,78,513.18
3 $         4,78,513.18 $         2,182.30 $            1,435.54 $                746.76 $            4,77,766.42
4 $         4,77,766.42 $         2,182.30 $            1,433.30 $                749.00 $            4,77,017.42
5 $         4,77,017.42 $         2,182.30 $            1,431.05 $                751.25 $            4,76,266.18
6 $         4,76,266.18 $         2,182.30 $            1,428.80 $                753.50 $            4,75,512.68
7 $         4,75,512.68 $         2,182.30 $            1,426.54 $                755.76 $            4,74,756.92
8 $         4,74,756.92 $         2,182.30 $            1,424.27 $                758.03 $            4,73,998.89
9 $         4,73,998.89 $         2,182.30 $            1,422.00 $                760.30 $            4,73,238.59
10 $         4,73,238.59 $         2,182.30 $            1,419.72 $                762.58 $            4,72,476.01
11 $         4,72,476.01 $         2,182.30 $            1,417.43 $                764.87 $            4,71,711.14
12 $         4,71,711.14 $         2,182.30 $            1,415.13 $                767.16 $            4,70,943.97
13 $         4,70,943.97 $         2,182.30 $            1,412.83 $                769.47 $            4,70,174.51
14 $         4,70,174.51 $         2,182.30 $            1,410.52 $                771.77 $            4,69,402.73
15 $         4,69,402.73 $         2,182.30 $            1,408.21 $                774.09 $            4,68,628.64
16 $         4,68,628.64 $         2,182.30 $            1,405.89 $                776.41 $            4,67,852.23
17 $         4,67,852.23 $         2,182.30 $            1,403.56 $                778.74 $            4,67,073.49
18 $         4,67,073.49 $         2,182.30 $            1,401.22 $                781.08 $            4,66,292.41
19 $         4,66,292.41 $         2,182.30 $            1,398.88 $                783.42 $            4,65,508.99
20 $         4,65,508.99 $         2,182.30 $            1,396.53 $                785.77 $            4,64,723.22
21 $         4,64,723.22 $         2,182.30 $            1,394.17 $                788.13 $            4,63,935.09
22 $         4,63,935.09 $         2,182.30 $            1,391.81 $                790.49 $            4,63,144.60
23 $         4,63,144.60 $         2,1

Related Solutions

You and your wife have finally saved up enough money to buy your dream home.  You purchase...
You and your wife have finally saved up enough money to buy your dream home.  You purchase a $210,000 home in a nice neighborhood, paying 5% down as a down payment and obtaining the rest of the proceeds to buy your home from the local bank.  Assume that the loan requires you to make monthly payments, with the annual interest rate stated as 5.75% and the term of the loan being 30 years. (12 points) A.        What is your monthly payment? $1166.32             B.        Set...
You have already saved $6850 to buy a used car. You invest this money in a...
You have already saved $6850 to buy a used car. You invest this money in a certificate of deposit earning 0.30% APR compounded monthly. How many years will it take your account to reach your target of $7275 in order to buy the new car?
When you reach retirement​ age, you would like to have enough money saved to be able...
When you reach retirement​ age, you would like to have enough money saved to be able to​ “pay yourself” an annual salary of ​$70​,000 per year for 20 years. To put this another​ way, your plan is to start your retirement with a large amount of money​ saved, and you will withdraw ​$70​,000 from these savings once a year for the next 20 years until all of your savings are depleted. In the​ meantime, you are a​ 25-year-old new UIC​...
When you reach retirement​ age, you would like to have enough money saved to be able...
When you reach retirement​ age, you would like to have enough money saved to be able to​ “pay yourself” an annual salary of ​$74​,000 per year for 20 years. To put this another​ way, your plan is to start your retirement with a large amount of money​ saved, and you will withdraw ​$74​,000 from these savings once a year for the next 20 years until all of your savings are depleted. In the​ meantime, you are a​ 25-year-old new UIC​...
When you reach retirement​ age, you would like to have enough money saved to be able...
When you reach retirement​ age, you would like to have enough money saved to be able to​ “pay yourself” an annual salary of ​$76 ​,000 per year for 20 years. To put this another​ way, your plan is to start your retirement with a large amount of money​ saved, and you will withdraw ​$76 ​,000 from these savings once a year for the next 20 years until all of your savings are depleted. In the​ meantime, you are a​ 25-year-old...
Suppose that you decided to buy a new house. The house you want to buy costs...
Suppose that you decided to buy a new house. The house you want to buy costs $520,000 and the interest rate is 7%. You currently have $130,000 and are required to put a 20% down payment plus an additional 3% of the loan amount as closing costs. 1) When will you have enough money for the down payment and closing costs, assuming that the $80,000 is the only investment that you make? 2) Suppose that you plan to buy the...
A young professional couple buy a house for $600,000. They make a down payment of $60,000...
A young professional couple buy a house for $600,000. They make a down payment of $60,000 and agree to amortise the rest of the debt with quarterly payments made at the end of each quarter over the next 20 years. The interest on the debt is 12% per annum compounded quarterly. 5(a). (i) What type of annuity is this? (ii) How many payments are made in total? (iii) What is the interest rate per period? (iv) Write down an explicit...
You have decided to become a student landlord and plan to buy a house in “The...
You have decided to become a student landlord and plan to buy a house in “The Village” for $920,000. You parents have agreed to supply $200,000 to be used as a down payment, leaving $720,000 to be financed by means of a mortgage. The mortgage broker has quoted 5.25% quoted rate based on a 25-year amortization, which will be compounded semi-annually in accordance with Canadian law. a) What would be the amount of monthly payments on the mortgage? b) What...
You have decided to become a student landlord and plan to buy a house for $920,000....
You have decided to become a student landlord and plan to buy a house for $920,000. You parents have agreed to supply $200,000 to be used as a down payment, leaving $720,000 to be financed by means of a mortgage. The mortgage broker has quoted 5.25% quoted rate based on a 25-year amortization, which will be compounded semi-annually in accordance with the law. a) What would be the amount of monthly payments on the mortgage? b) What would be the...
Problem 4. You would like to have enough money saved to receive $200,000 per year after...
Problem 4. You would like to have enough money saved to receive $200,000 per year after retirement so that you and your family can lead a good life for 30 years (from age 65 to 95). You will make your first withdraw of $200,000 at the end of year when you are 65. If you will be 35 years old when you graduate and plan on making savings contributions at the end of your first year out of school, how...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT