In: Finance
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?
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 SolutionsYou 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
Latest Questions
ADVERTISEMENT
|