PPMT

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

Returns the principal amount paid on a given period on a loan with fixed interest.

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 (0).
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 add the PPMT and the IPMT for the same period you will get the PMT.
* You can use the IPMT function to return the interest amount paid on a given period on a loan with fixed interest.
* You can use the PMT function to return the full amount (principal + interest) paid every period on a loan with fixed interest.
* The equivalent VBA function is VBA.PPMT
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.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%.

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