• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 17. Building Loan Formulas > Calculating Interest Costs, Part 2

Calculating Interest Costs, Part 2

Another way to calculate the total interest paid on a loan is to sum the various IPMT() values over the life of the line. You can do that by using an array formula that generates the values of the IPMT() function's per argument. Here's the general formula:

{=IPMT(rate, ROW(INDIRECT("A1:A" & nper)), nper, pv, [fv], [type])}


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint