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

Returns the fixed payment made in each period of a series of equal cash flows at regular intervals.

rateThe fixed interest rate per period.
perThe period and must be in the range 1 to nper.
nperThe total number of payments.
pvThe present value.
fv(Optional) The future value (or cash balance) after all the payments.
type(Optional) The number indicating when the payments are due:
0 = the end of the period (default)
1 = the start of the period

Remarks

* A negative number represents any cash you pay out.
* A positive number represents any cash you receive (start with or end with).
* The "rate" and "nper" MUST be expressed in the same units of time: years, months or days.
* The present value is the total amount that the payments are worth now.
* If "fv" is left blank, then 0 is used.
* If "type" is left blank, then 0 is used.
* If "type" = 0, then payments are made in arrears.
* If you calculate the PPMT and IPMT for the same period you can add them together to get the total amount.
* In Excel 2010 the accuracy of this function was improved.
* The equivalent VBA function is PPMT
* For the Microsoft documentation refer to support.office.com

 A
1=PPMT(10%/12,1,2*12,2000) = -£75.62
2=PPMT(10%,1,2,2000) = -£952.38
3=PPMT(10%/12,1,5*12,-10000) = £129.14
4=PPMT(8%,10,10,200000) = -£27,598.05

1 - How much principal is paid back in the first month of a 2 year £2,000 loan at 10% annual interest:
2 - How much principal is paid back in the first year of a 2 year £2,000 loan at 10% annual interest:
3 - How much principal is paid back in the first month if I take out a loan for £10,000 over 5 years with an annual interest rate of 10%.

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