Question

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?

Answer 1

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 jeff jeffy Next > < Previous 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... 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... 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... 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 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... You are going to make a substantial purchase. You have enough money to pay cash, but... You are going to make a substantial purchase. You have enough money to pay cash, but don’t know if that’s the way to make best use of your assets. Maybe you should take out an installment loan to make the purchase and invest the cash you would otherwise have used to pay for it. Use the information provided to complete the following worksheet and analyze how the numbers work out most favorably for you. For simplicity, compounding is ignored in... 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 Subjects Accounting Advanced Math Anatomy and Physiology Biology Chemistry Civil Engineering Computer Science Economics Electrical Engineering Finance History Math Mechanical Engineering Operations Management Physics Psychology Statistics and Probability Nursing Other ADVERTISEMENT Latest Questions Which statement is true of an e-distributor? a. An e-distributor offers services from different vendors in... “It is better to market a new product quickly and then upgrade the design later than... What is is a history behind therapeutic techniques ( from witchcraft to deinstitutionalization) for psychological disorders? The figure presents a skier at Point A, at the top of a ski jump, which... A doctor wants to estimate the mean HDL cholesterol of all​ 20- to​ 29-year-old females. How... Problem 1 You are asked to perform a capacity analysis for the clinic. The current resources... Post Card Depot, an large retailer of post cards, orders 5,784,638 post cards per year from... ADVERTISEMENT About @ 2020 WizEdu