Access tutorial 10.12 supplement content 9: PPmt Functions

Source: Internet
Author: User
PPmt (rate, per, nper, pv [, fv [, type]) rate is required. Double specifies the interest rate for each period. For example, if a loan has a car loan with an annual percentage (APR) of 10 percent and is paid on a monthly basis, the interest rate for each phase is 0.112 or 0.0083. Per is required. Integer specifies the payment cycle in the range of nper 1.

PPmt (rate, per, nper, pv [, fv [, type]) rate is required. Double specifies the interest rate for each period. For example, if there is a loan for a car loan with an annual percentage (APR) of 10 percent and a monthly payment, the interest rate for each phase is 0.1/12 or 0.0083. Per is required. Integer specifies the payment cycle in the range of nper 1.


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

Rate is required. Double specifies the interest rate for each period. For example, if there is a loan for a car loan with an annual percentage (APR) of 10 percent and a monthly payment, the interest rate for each phase is 0.1/12 or 0.0083.

Per is required. Integer specifies the payment cycle in the range of nper 1.

Nper is required. Integer specifies the total number of payment periods for an annuity. For example, if you choose to pay by month for a four-year car loan, there will be 4*12 (or 48) payment periods.

Pv is required. Double specifies the present value of a series of future payments or collections. For example, when a loan is made to buy a car, the amount borrowed from the lender is the present value of future monthly payments to the lender.

Fv is optional. Variant specifies the expected future value or cash settlement value after the loan is paid. For example, the future value of a loan is 0 USD after the loan is paid. However, if you want to save $50,000 for the past 18 years as the Children's Education Fund, then $50,000 will be worth the future. If omitted, the default value is 0.

Type is optional. Variant specifies the loan expiration time. If the loan expires at the end of the loan cycle, use 0. If the loan expires at the beginning of the cycle, use 1. If omitted, the default value is 0.

Note: Gold is a series of fixed cash payments within a period of time. An annuity can be a loan (such as a mortgage loan) or an investment (such as a monthly savings plan ). The rate and nper parameters must be calculated in the same unit during the payment period.

For example, if rate is calculated by month, nper must also be calculated by month. For all parameters, a negative number indicates cash expenditure (such as savings and deposits), and a positive number indicates cash income (such as a dividend check ).

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.