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 2: / Line 2: @@
 [[Category:Doc Status D]] <!-- For Lumina use, do not change -->
-= PPmt(rate,per,nper,pv'',fv,type'') =
+== 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.
+;«Rate»: The interest rate per period.
-  Per:  The period to compute the principal payment for. {1..NPer}
+;«Per»:  The period to compute the principal payment for. {1..«NPer»}
-  NPer: The total number of periods in the annity's lifetime.
+;«NPer»: The total number of periods in the annity's lifetime.
-  Pv:   The present value. If you receive a loan, this is the
+;«Pv»:   The present value.
-        loan amount as a positive number.  If you give someone
+:If you receive a loan, this is the loan amount as a positive number.
-        a loan, this is a negative number.
+:If you give someone a loan, this is a negative number.
-  Fv:   (Optional) Future value of annuity at the end of the NPer
+;«Fv»:   (Optional) Future value of annuity at the end of «NPer» periods.
-        periods.  If you receive a loan, this is your final balloon
+:If you receive a loan, this is your final balloon payment at the end as a negative number.
-        payment at the end as a negative number.  If you get money
+:If you get money back at the end, this is a positive number.
-        back at the end, this is a positive number.
+;«Type»: (Optional) Indicates whether payments are at the beginning of the period.
-  Type: (Optional) Indicates whether payments are at the beginning of the
+:<code>True</code>  = Payments due at beginning of period, with first payment due immediately.
-        period.
+:<code>False</code> = Payments due at end of period. (default)
-        True  = Payments due at beginning of period, with first payment
-                due immediately.
-        False = Payments due at end of period. (default)
-= Library =
+== Library ==
 Financial Functions
-= Examples =
+== 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
+:<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>
-[[PPmt]](6.5%/12, 5*12+1, 30*12, $350K) / [[Pmt]](6.5%/12,30*12,$350k) &rarr; 19.8%
+== See Also ==
+* [[IPmt]]
-= See Also =
+* [[Pmt]]
-* [[IPmt]], [[Pmt]]
 * [[CumPrinc]]
-* [[Rate]], [[Pv]], [[NPer]]
+* [[Rate]]
+* [[Pv]]
+* [[NPer]]
+* [[Financial functions]]