Difference between revisions of "PPmt"

Latest revision as of 01:11, 30 January 2016

PPmt(rate, per, nper, pv, fv, type)

Returns the principal portion of a payment received on an annuity, assuming constant periodic payments and a fixed interest rate.

Parameters:

«Rate»: The interest rate per period.
«Per»: The period to compute the principal payment for. {1..«NPer»}
«NPer»: The total number of periods in the annity's lifetime.
«Pv»: The present value.; If you receive a loan, this is the loan amount as a positive number.; If you give someone a loan, this is a negative number.
«Fv»: (Optional) Future value of annuity at the end of «NPer» periods.; If you receive a loan, this is your final balloon payment at the end as a negative number.; If you get money back at the end, this is a positive number.
«Type»: (Optional) Indicates whether payments are at the beginning of the period.; True = Payments due at beginning of period, with first payment due immediately.; False = Payments due at end of period. (default)

Library

Financial Functions

Examples

You have a 30-year fixed-rate mortgage at 6.5% on an initial loan amount of $350K. You have held the mortgage for 5 years -- your next payment will be the 61th payment. How much of your current monthly payment goes towards principle?

-PPmt(6.5%/12, 61, 30*12, $350K) → $437.53

As a percentage:

PPmt(6.5%/12, 5*12 + 1, 30*12, $350K)/Pmt(6.5%/12, 30*12, $350k) → 19.8%

@@ Line 1: / Line 1: @@
-[[category:Distribution Functions]]
+[[category:Financial Functions]]
-{{stub}}
+[[Category:Doc Status D]] <!-- For Lumina use, do not change -->
+== PPmt(rate, per, nper, pv'', fv, type'') ==
+Returns the principal portion of a payment received on an annuity, assuming constant periodic payments and a fixed interest rate.
+Parameters:
+;«Rate»: The interest rate per period.
+;«Per»:  The period to compute the principal payment for. {1..«NPer»}
+;«NPer»: The total number of periods in the annity's lifetime.
+;«Pv»:   The present value.
+:If you receive a loan, this is the loan amount as a positive number.
+:If you give someone a loan, this is a negative number.
+;«Fv»:   (Optional) Future value of annuity at the end of «NPer» periods.
+:If you receive a loan, this is your final balloon payment at the end as a negative number.
+:If you get money back at the end, this is a positive number.
+;«Type»: (Optional) Indicates whether payments are at the beginning of the period.
+:<code>True</code>  = Payments due at beginning of period, with first payment due immediately.
+:<code>False</code> = Payments due at end of period. (default)
+== Library ==
+Financial Functions
+== Examples ==
+You have a 30-year fixed-rate mortgage at 6.5% on an initial loan amount of $350K. You have held the mortgage for 5 years -- your next payment will be the 61th payment. How much of your current monthly payment goes towards principle?
+:<code>-PPmt(6.5%/12, 61, 30*12, $350K) &rarr; $437.53</code>
+As a percentage:
+:<code>PPmt(6.5%/12, 5*12 + 1, 30*12, $350K)/Pmt(6.5%/12, 30*12, $350k) &rarr; 19.8%</code>
+== See Also ==
+* [[IPmt]]
+* [[Pmt]]
+* [[CumPrinc]]
+* [[Rate]]
+* [[Pv]]
+* [[NPer]]
+* [[Financial functions]]