# PPMT

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

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

 rate The fixed interest rate per period. per The period and must be in the range 1 to nper. nper The total number of payments. pv The 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%.