Difference between revisions of "Manuals/calci/PMTLISTING"
Jump to navigation
Jump to search
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | =PMTLISTING (Rate,Period,NoPaymentPeriods,PresentValue,FutureValue,Type) | + | <div style="font-size:30px">'''PMTLISTING (Rate,Period,NoPaymentPeriods,PresentValue,FutureValue,Type)'''</div><br/> |
| − | |||
where | where | ||
| Line 6: | Line 5: | ||
*<math>Period</math> is the number of period. | *<math>Period</math> is the number of period. | ||
*<math>NoPaymentPeriods</math> is the number of installments. | *<math>NoPaymentPeriods</math> is the number of installments. | ||
| − | + | **PMTLISTING() calculates the payment for a loan based on constant payments and a constant interest rate. | |
| − | |||
| − | PMTLISTING() calculates the payment for a loan based on constant payments and a constant interest rate. | ||
==Description== | ==Description== | ||
| Line 27: | Line 24: | ||
#PMTLISTING(0.11/12,7,14,25000) = -1910.9086778706514 -1776.3836036389553 -134.52507423169618 | #PMTLISTING(0.11/12,7,14,25000) = -1910.9086778706514 -1776.3836036389553 -134.52507423169618 | ||
#PMTLISTING(0.09/12,10,20,50000,10000,1) = -3143.263440567916 -2962.184262392901 -179.4515252518386 | #PMTLISTING(0.09/12,10,20,50000,10000,1) = -3143.263440567916 -2962.184262392901 -179.4515252518386 | ||
| + | |||
| + | ==Related Videos== | ||
| + | |||
| + | {{#ev:youtube|v=WzofplrjidU|280|center|PMT }} | ||
==See Also== | ==See Also== | ||
Latest revision as of 15:19, 22 February 2019
PMTLISTING (Rate,Period,NoPaymentPeriods,PresentValue,FutureValue,Type)
where
- is the rate of interest.
- is the number of period.
- is the number of installments.
- PMTLISTING() calculates the payment for a loan based on constant payments and a constant interest rate.
is the rate of interest.
is the number of period.
is the number of installments.
Description
PMTLISTING (Rate,Period,NoPaymentPeriods,PresentValue,FutureValue,Type)
- is the annual rate of interest for the loan.
- is the number of periods.
- is the total number of payment periods in an annuity.
- is the present value or the amount borrowed or the principal of the loan.
- is the future value of an investment or loan (the value you want to achieve at the end of all periods).
- is the number 0 or 1 which is specifies the time to make a payment during the period.
- When we are not giving the value of ty, then it is assumed to be 0.
- The amount given by the function PMT not containing any taxes,reserve payments or extra fees related with the loan.
- But it contains only the principal amount and interest only.
is the present value or the amount borrowed or the principal of the loan.
is the future value of an investment or loan (the value you want to achieve at the end of all periods).
is the number 0 or 1 which is specifies the time to make a payment during the period.Examples
- PMTLISTING(0.09/12,10,20,50000,10000,0) = -3166.8379163721756 -2986.0405046809483 -180.7974116912274
- PMTLISTING(0.11/12,7,14,25000) = -1910.9086778706514 -1776.3836036389553 -134.52507423169618
- PMTLISTING(0.09/12,10,20,50000,10000,1) = -3143.263440567916 -2962.184262392901 -179.4515252518386
Related Videos
See Also
References