The excel function for monthly payments is =PMT()
The excel function for cumulative total interest is =CUMIPMT()
The CUMIPMT Function[1] is an Excel Financial function. CUMIPMT helps in calculating the cumulative interest paid on a loan taken out, or earned on an investment made.
- The Excel PMT function is a financial function that returns the periodic payment for a loan. You can use the PMT function to figure out payments for a loan, given the loan amount, number of periods, and interest rate. Get the periodic payment for a loan. loan payment as a number. =PMT
- =PMT(rate, nper, pv, [fv], [type]) The PMT function uses the following arguments: Rate (required argument) – The interest rate of the loan. Nper (required argument) – Total number of payments for the loan taken.
- PMT is an abbreviation of the word 'payment'. In finance, PMT is a function which is used to calculate payments which are due at specific frequencies, for example loans or mortgages. In order to use the PMT function, the interest rate will need to be constant, and the payments will need to be level.
Learn more about, refer
https://brainly.com/question/16794311
#SPJ2
