Google スプレッドシート関数

NPER

Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate.

この関数は Google スプレッドシートでも Excel と同じように機能します。構文も引数も同じです。

構文

NPER(rate, pmt, pv, [fv], [type])

The NPER function calculates the total number of payment periods required to reach a specific financial goal or pay off a loan. It assumes that payments are constant and the interest rate remains unchanged throughout the duration of the investment.

引数

rate必須The interest rate per period.
pmt必須The payment made each period; it cannot change over the life of the annuity.
pv必須The present value, or the lump-sum amount that a series of future payments is worth now.
fv省略可能The future value or a cash balance you want to attain after the last payment is made.
type省略可能The number 0 or 1 and indicates when payments are due (0 = end of period, 1 = beginning of period).

例

=NPER(0.05/12, -200, 10000)

結果: 54.55

Calculates the number of months to pay off a $10,000 loan with a 5% annual interest rate and $200 monthly payments.

よくある質問

Why does NPER return a #NUM! error?

This usually happens if the payment amount is too low to cover the interest, making it impossible to reach the future value.

NPER

構文

引数

例

よくある質問

関連する関数

NPER

構文

引数

例

よくある質問

関連する関数