IPMT

IPMT(rate, per, nper, pv [,fv] [,type])

Returns the interest paid in a given period in a series of equal cash flows at regular intervals (Double).


rateThe fixed interest rate per period (Double).
perThe period for which you want to find the interest (Double).
nperThe total number of payments (Double).
pvThe present value (Double).
fv(Optional) The future value (or cash balance) after all the cash flows (Double).
type(Optional) The number indicating when the payments are due:
0 = the end of the period (default)
1 = the start of the period

REMARKS
* This function defines the interest payment for a given period of an annuity based on periodic, fixed payments and a fixed interest rate.
* An annuity is a series of fixed cash payments made over a period of time.
* An annuity can be a loan (such as a home mortgage) or an investment (such as a monthly savings plan).
* The "rate" and "nper" arguments must be in the same units (days, months, years).
* The "per" can be any value between 1 and "nper".
* If "fv" is left blank, then 0 is used.
* If "type" = True, then 1 is used.
* For all arguments, any cash paid out is represented by negative number and any cash received is represented by positive numbers.
* You can use the IRR function to return the interest rate for a series of unequal cash flows at regular intervals (explicit reinvestment rate).
* You can use the MIRR function to return the interest rate for a series of unequal cash flows at regular intervals (implicit reinvestment rate).
* You can use the RATE function to return the interest rate for a series of equal cash flows at regular intervals.
* The equivalent Excel function is Application.WorksheetFunction.IPMT.
* The equivalent .NET function is Microsoft.VisualBasic.Financial.IPmt
* Example - If you have an annual interest rate of 10%, and you make monthly payments then "rate" per period is (10/100 * 1/12) = 0.0083.
* Example - If you are making monthly payments for 5 years then your "nper" is (5*12) = 60.
* Example - When you borrow money to buy a car, the "present value" is the amount you are paying back to the lender ?
* For the Microsoft documentation refer to learn.microsoft.com

Debug.Print Ipmt(0.0081, 2, 48, 20000)   '= -159.2252  

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top