Question: QUESTION 2: LOAN AMORTIZATION [35 MARKS] Please answer iii only. I already have the answer for i and ii. I. A family buys a house

QUESTION 2: LOAN AMORTIZATION [35 MARKS] Please answer iii only. I already have the answer for i and ii.

I. A family buys a house worth $326,000. They pay $75,000 deposit and take a mortgage for the balance at J12=9% p.a. to be amortized over 30 years with monthly payments. A. Find the value of the mortgage on their house? (1 mark) B. Find the value of the monthly payment? (3 marks) C. Find the loan outstanding after making 20 payments? (4 marks) D. Find the principal repaid in the 21st payment? (5 marks)

II. Fill out the loan amortization schedule provided in the solution template for the first 5 loan payments. What do you notice about the composition of the payment amount? (6 marks)

III. Suppose that after making 50 payments, the interest rate changes to J2=9% p.a.: A. Convert the interest rate J2=9% to J12 equivalent (2 marks B. Assuming that the family seeks to accept the change in interest rates, what would be their new payment based on the new interest rate? (5 marks) C. Assuming that the family seeks to continue their initial monthly payment calculated in part I, how many full payments would be required to pay off the loan and what would be the final concluding smaller payment one period later? (9 marks)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

I earnestly need help to PART III of this Question. QUESTION 2: LOAN AMORTIZATION (35 MARKS] 1. A family buys a house worth $326,000. They pay $75,000 deposit and take a mortgage for the balance at...

I.Find the present and future value of $1000 received every month end for 20 years if the interest rate is J12 = 12% p.a. (5 marks) II.Find the present value of $10,000 received at the start of every...

Question 1 Martin uses $40,000 of his own funds and borrows additional funds through a margin lending facility to buy a total of $100,000 worth of shares. The value of Martin's total share portfolio...

Could you please help answering the questions in the Accounting assignment? Need answers for questions 1,2 and 4. Thank you ACG11 - Accounting for Business - SP2 2016 Assignment Part B 97 marks -...

Hi, Lengthy assignment - questions corporate finance. Significant work required. Please provide quote. Regards BFA728 assignment RWC2016 UNIVERSITY OF TASMANIA Tasmanian School of Business and...

MULTIPLE CHOICE 1 Using the recurrence relation t0 = 8, tn+1 = tn + 9, the sixth term would be: A 2 15 B 17 C 23 D 53 E 62 A canoe costs $40 to hire for the first day and $30 for each extra day. If...

This is the whole question but when i posted the entire question then only part This is the whole question but when i posted the entire part then only part I was answered. I have posted this question...

THE QUESTIONS ARE BELOW I appreciate this help very much . The Butterfiells have also allocated $1,200 per vear to help pay for Troy's travel expenses He has completed one vear of college His health...

I need to complete phase 3 of the schnappauf family case. PHASE lI-CHAP'I'EIIE 5-5 This is the seeenci phase eF the te:t tenIIn prehlem Ire-u began at the end efhapter 1r. Th' phase uf the tax return...

Excel Case 1 Case 1 instructions Complete Comprehensive Case-SportZ Lt.-on page 330 of your math textbook. You may work alone or in a group of two. Value 10% Criteria: complete in Excel use formulas...

(a) The scores in the final year maths exams in a large university are normally distributed with a mean score of 63 marks and a standard deviation of 6. Find the proportion of students who got a...

Taylor is applying for a position as a teller at First Bank and Trust Company of Tinsel town. He submits a resume and attends an interview with the human resources department and, a few days later,...

The budget prepared for the general fund for the current fiscal year included total appropriations of $ 2 , 5 2 0 , 0 0 0 and estimated revenues of $ 2 , 2 5 0 , 0 0 0 . Government - Wide General...

8:37 * N. 80% i ... OBJECTIVES: Create relationships Create a Pivot Table from Related Tables Create a PivotChart Modify the PivotChart The major section in this chapter :ontinuation is: Data...