Mathematics
Mathematics, 19.06.2021 07:10, brookemcelhaney

A couple purchased a home and signed a mortgage contract for $400,000 to be paid with half-yearly payments over a 25-year period. The interest rate applicable is j2 = 7.5% p. a. applicable for the first five years, with the condition that the interest rate will be increased by 9% every 5 years for the remaining term of the loan. Based on the given information. your group is required to use Exxcel software to: (a) Calculate the half-yearly payment required for each five-year interval |10 marks (b) Calculate the loan outstanding (outstanding balance) at the beginning of each five year interval. [10 marks| (c) Prepare a loan amortization table for the final 12 half-years of the loan term. |10 marks​

answer
Answers: 2

Other questions on the subject: Mathematics

image
Mathematics, 21.06.2019 15:10, 437012
Aline parallel to a triangle's side splits ab into lengths of x - 5 and x + 2. the other side, ac, is split into lengths of x and x + 12. what is the length of ac? a) 12 b) 24 c) 36 d)
Answers: 1
image
Mathematics, 21.06.2019 15:30, orlando19882000
You have 6 dollars +12 pennies +to quarters + 4 dimes=2 nickels how much do you have
Answers: 1
image
Mathematics, 21.06.2019 17:00, vaelriacb9300
The rumpart family is building a new room onto their house. the width of the new room will be 16 feet. the length of the room will be 4% greater than the width. write an expression to find the length of the new room. what will be the area of this new room?
Answers: 2
image
Mathematics, 21.06.2019 23:00, esme72
Acompany made a profit of 75000 over a period of 6 years on an initial investment of 15000 what is the annual roi
Answers: 1
Do you know the correct answer?
A couple purchased a home and signed a mortgage contract for $400,000 to be paid with half-yearly pa...

Questions in other subjects: