FVReturns the future value (FV) of an initial investment, based on a constant interestRate and payment amount for the number of periods in months.payment - payment to be made per periodinterestRate - interest rate per periodperiods - number of periodsUse this function to calculate FV. For example, you can calculate how much you’ll earn on an investment in which you pay $50 a month for 60 months at a 6 percent annual interest rate.

•

• The FV function doesn’t account for the present value of your investment, and it assumes that payment is made at the end of each period.FV(50;.11/12;5 * 12) returns 3975.90398429....FV(2000;.12;30) + 5000 * (.12 + 1) ^ 30 returns 632464.97928640....FV(500;.11/5;60) returns 61141.65130790....To set the decimal precision of the returned value, enclose the current formulas with the Round function. For example, Round(Current Formula;2).

Was this topic helpful? Send feedback.