Calculates the future value of an investment based on periodic, constant payments and a constant interest rate.
Hàm này hoạt động trong Google Sheets giống như trong Excel — cùng cú pháp và đối số.
FV(rate, nper, pmt, [pv], [type])The FV function helps determine the final value of an investment or loan after a specific number of periods. It assumes that interest rates and payment amounts remain constant throughout the duration of the investment. You can use this to plan for savings goals or calculate the maturity value of an annuity.
=FV(0.05/12, 10*12, -200, -500, 0)Kết quả: 31573.35
Calculates the future value of a 10-year investment with a 5% annual interest rate, $200 monthly deposits, and a $500 starting balance.
In Excel financial functions, cash outflows (like deposits) are typically entered as negative numbers, resulting in a positive future value representing the cash you receive back.