Hàm Google Sheets

PV

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

Tạo công thức bằng AI Cùng hàm trong Excel

Hàm này hoạt động trong Google Sheets giống như trong Excel — cùng cú pháp và đối số.

Cú pháp

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.

Đối số

ratebắt buộcThe interest rate per period.
nperbắt buộcThe total number of payment periods in an annuity.
pmtbắt buộcThe payment made each period; it cannot change over the life of the annuity.
fvtùy chọnThe future value or a cash balance you want to attain after the last payment is made.
typetùy chọnThe number 0 or 1 and indicates when payments are due (0 = end of period, 1 = beginning of period).

Ví dụ

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

Kết quả: -10328.01

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

Câu hỏi thường gặp

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.

Hàm liên quan

FV PMT RATE NPER