Calculates the future value of an investment based on periodic, constant payments and a constant interest rate.
Bu işlev, Google E-Tablolar'da Excel'deki gibi çalışır — aynı söz dizimi ve bağımsız değişkenler.
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)Sonuç: 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.