Matching
Match the following terms with the corresponding description.
Premises:
PPMT
CUMPRINC
Loan amortization
CUMIPMT
IPMT
Responses:
Calculates the principal payment for a specified payment period on a loan or an investment given a fixed interest rate,term,and periodic payments
Calculates the cumulative interest throughout a loan amortization table
A schedule that calculates the interest,principal repayment,and remaining balance
Calculates the cumulative principal throughout a loan amortization table
Calculates the periodic interest for a specified payment period on a loan or an investment given a fixed interest rate,term,and periodic payments
Correct Answer:
Premises:
Responses:
PPMT
CUMPRINC
Loan amortization
CUMIPMT
IPMT
Premises:
PPMT
CUMPRINC
Loan amortization
CUMIPMT
IPMT
Responses:
Related Questions
Q5: =IF(E5<J7,F5*K7,IF(E5<=J8,F5*K8,F5*K9))is an example of a(n):<br>A)Database function.<br>B)Look Up
Q6: The MATCH function can be used to
Q7: The NPER function would be best used
Q8: The _ function is best suited when
Q9: Match the following terms with the corresponding
Q11: The _ function will only trigger the
Q12: In order for the AND function to
Q13: Which function will calculate the final value
Q14: In order for the NOT function to
Q15: The CUMPRINC function requires both starting and