Calculates the future value of an investment based on periodic, constant payments and a constant interest rate.
Эта функция в Google Таблицах работает так же, как в Excel — тот же синтаксис и аргументы.
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)Результат: 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.