Pmt 函数Pmt function

语法Syntax

Pmt(rate, nper, pv, [ fv, [ type ]])Pmt(rate, nper, pv, [ fv, [ type ]])

Pmt 函数包含以下命名参数The Pmt function has these named arguments:

PartPart 说明Description
rate 必需。Required. 指定每个周期的利率的 DoubleDouble specifying interest rate per period. 例如，如果您获得了年利率 (APR) 为 10% 的汽车贷款并进行月供，则每期利率为 0.1/12 或 0.0083。For example, if you get a car loan at an annual percentage rate (APR) of 10 percent and make monthly payments, the rate per period is 0.1/12, or 0.0083.
npernper 必需。Required. 指定年金付款期的总数的 IntegerInteger specifying total number of payment periods in the annuity. 例如，如果您每月偿还为期 4 年的汽车贷款，则您的贷款期总数为 4 * 12（或 48）。For example, if you make monthly payments on a four-year car loan, your loan has a total of 4 * 12 (or 48) payment periods.
pvpv 必需。Required. Double 指定现值（或一次付清额），是未来一系列付款在目前的价值。Double specifying present value (or lump sum) that a series of payments to be paid in the future is worth now. 例如，您借钱购买了一辆车，贷款额就是您按月还给贷款人的现值。For example, when you borrow money to buy a car, the loan amount is the present value to the lender of the monthly car payments you will make.

typetype 可选。Optional. 指定付款的到期时间的 VariantVariant specifying when payments are due. 如果付款在付款期结束时到期，则使用 0；如果付款在付款期开始时到期，则使用 1。Use 0 if payments are due at the end of the payment period, or use 1 if payments are due at the beginning of the period. 如果省略，则假定为 0。If omitted, 0 is assumed.

示例Example

``````Dim Fmt, FVal, PVal, APR, TotPmts, PayType, Payment
Const ENDPERIOD = 0, BEGINPERIOD = 1    ' When payments are made.
Fmt = "###,###,##0.00"    ' Define money format.
FVal = 0    ' Usually 0 for a loan.
PVal = InputBox("How much do you want to borrow?")
APR = InputBox("What is the annual percentage rate of your loan?")
If APR > 1 Then APR = APR / 100    ' Ensure proper form.
TotPmts = InputBox("How many monthly payments will you make?")
PayType = MsgBox("Do you make payments at the end of month?", vbYesNo)
If PayType = vbNo Then PayType = BEGINPERIOD Else PayType = ENDPERIOD
Payment = Pmt(APR / 12, TotPmts, -PVal, FVal, PayType)
MsgBox "Your payment will be " & Format(Payment, Fmt) & " per month."

``````