syntax:functions:ipmt

Category: Number (Financial) function

This function calculates the interest payment for a given period for an investment .

Optional *future value* (fut_val) argument.

IPmt(rate, per, num_per, curr_val, fut_val)

Optional *payments due* (pay_due) argument.

IPmt(rate, per, num_per, curr_val, fut_val, pay_due)

Argument | Type | Description |
---|---|---|

rate | Number (decimal) | The interest rate of the loan (entered as a decimal). |

per | Number | The period of the interest payment. Must be a value between 1 and num_per. |

num_per | Number | The number of payments of the loan (usually in months or years). |

curr_val | Number | The current value of the loan. |

fut_val | Number | Optional. The future value to be achieved after the last payment (i.e., "0" to pay the loan off in full). The default, if not supplied, is 0. |

pay_due | Binary (0 or 1) | Optional. This value defines when payments are due. Options: 0 (the beginning of the period; default),or 1 (the end of the period). |

**Return value type:** Number

For an accurate calculation, be sure to convert *rate* and *num_per* to the same time period. If calculating a monthly payment and *rate* is an annual rate, divide it by 12 (*rate* / 12). If *num_per* is given as years, multiply by 12 (*num_per* * 12).

** Calculate the annual interest payment for period 1:** Annual rate of 8%, for period 1, number of periods is 3 years, value is $20,000, (final value = default, 0).

ipmt(0.08, 1, 3, 20000) //Returns -1600 (annual payment, rounded)

** Calculate the monthly interest payment for period 24:** Annual rate of 6%, number of periods is 48 months, value is $10,000, final value is 0 (paid off).

ipmt(0.06/12, 24, 48, 10000, 0) //Returns -27.53 (monthly payment, rounded)

** Calculate the monthly interest payment for period 20:** Annual rate of 10%, number of periods is 2 years, value is $8,000, final value is 0 (paid off), with payments due at the end of the period.

ipmt(0.10/12,20, 2*12, 8000, 0, 1) //Returns -14.88 (monthly payment, rounded)

** Calculate the monthly interest payment for period 25:** Annual rate of 10%, number of periods is 2 years, value is $8,000, final value is 0 (paid off), with payments due at the end of the period.

ipmt(0.10/12,25, 2*12, 8000,0,1) //Returns an error. "Per" is outside of 1-24 (the # of months).

syntax/functions/ipmt.txt · Last modified: 2021/10/24 00:32 by craigt