Google スプレッドシート関数

PV

Calculates the present value of a loan or an investment based on a constant interest rate.

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

構文

PV(rate, nper, pmt, [fv], [type])

The PV function determines the current worth of a series of future payments. It is commonly used to evaluate the value of an annuity or to determine how much a loan is worth today given future repayment terms.

引数

rate必須The interest rate per period.
nper必須The total number of payment periods in an annuity.
pmt必須The payment made each period; it cannot change over the life of the annuity.
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).

例

=PV(0.05/12, 12*5, 200)

結果: -10328.01

Calculates the present value of a 5-year loan with a 5% annual interest rate and $200 monthly payments.

よくある質問

Why is the result of the PV function negative?

Excel follows cash flow conventions; since payments are money leaving your pocket, they are represented as negative values.

PV

構文

引数

例

よくある質問

関連する関数

PV

構文

引数

例

よくある質問

関連する関数