Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

At the end of which month will be for the loan outstanding balance to e less than 90% of the original loan amount for the

At the end of which month will be for the loan outstanding balance to e less than 90% of the original loan amount for the first time.

At least one of the following excel TVM functions must be used: =PV(), =FV(), =PMT(), =RATE(), =NPER(), =IPMT(), =PPMT(), =CUMIPMT(),=CUMPRINC().

NPER1 Number of months with interest only repayments : 18

Number of years, n, with Principal & Interest (P&I) repayments : 23

NPER2 Number of months, n*m, with Principal & Interest (P&I) repayments : 276

Interest rate, jm, p.a (compounding monthly) : 9%

Interet rate per month (i=jm/m) : 9%/12 Loan amount : $928,022

P&I(fixed monthly repayment after interest only expires) : 7,974.20

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

Financial Markets And Institutions

Authors: Frederic S. Mishkin

2nd Edition

0321014650, 9780321014658

More Books

Students also viewed these Finance questions

Question

5-7PagesAPAformat Provideatleast3scholarlyresources...

Answered: 1 week ago