Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can it be calculated by formula? Don't use Excel solution We take a 10 year mortgage for $200,000 at 8 25% pa it is to

image text in transcribed
image text in transcribed
Can it be calculated by formula? Don't use Excel solution
We take a 10 year mortgage for $200,000 at 8 25% pa it is to be repaid in monthly repayments (a)What is the repayment amount? Assume that interest is compounded monthly. Which formula should you use to solve this problem? (b) What is the balance outstanding after two years? How much principal and how much interest have been paid? (c) After two years, the interest rate falls to 7 75%pa What prepayment penalty would make it unattractive to prepay the loan? (a) The formula in it's most basic form . PMT FV[1-(1+i)"] OB FV PV = C. PMT PV = OD. FV = PV(1 - i)" The repayment amount is (Round to the nearest cent) (b) The inputs in my calculator will be O A N=2 I/YR=8 25/12 PMT= -(Answer from a) FV=0, Find PV OB. N=2"12 1/YR= 8.25 PMT= -(Answer from a) FV= 0, Find PV OC. N=81/YR=8.25 PMT= -(Answer from a) FV=0. Find PV OD. N= 8'12 I/YR= 8.25/12 PMT=-(Answer from a) FV=0. Find PV The outstanding balance outstanding after two years is sis SIL (Round to the nearest cent) The amount of principal that has been paid after two years is 1 and the amount of interest that has been paid after two years is $ (Round to the nearest cent) (d) The new PV after two years with the same monthly payments is (Round to the nearest cent) The prepayment penalty would have to be at least to make it unattractive to prepay the loan (Round to the nearest cent)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Finance

Authors: John Fred Weston, Eugene F. Brigham, John Boyle, Robin John Limmack

1st Edition

0039101975, 978-0039101978

More Books

Students also viewed these Finance questions

Question

Discuss some ways agents can make self-serving decisions.

Answered: 1 week ago