Multiple Choice
Identify the correct formula to calculate the cumulative interest paid on a mortgage loan for the second year of the loan (periods 13-24,where rate =9%,nper= 5,present value = $250,000.
A) =CUMIPMT(.09/12, 5*12, 250000,13,24,0)
B) =CUMIPMT(.09/12, 5*12, 250000,24,13,0)
C) =CUMIPMT(.09*12, 30/12,-250000,13,24,0)
D) =CUMIPMT(.09/12, 30/12,-250000,24,13,0)
Correct Answer:

Verified
Correct Answer:
Verified
Q54: The par value is how much the
Q55: The pv argument in the PMT function
Q56: To calculate a loan payment for a
Q57: A(n)_ is a legal document that can
Q58: The _ function calculates what an investment
Q60: _ is a reduction in the value
Q61: As the total loan balance decreases,a larger
Q62: The IRR and _ functions are used
Q63: A(n)_ can be used to assess a
Q64: By default,the PMT function returns a positive