A future-value calculation can look deceptively simple until monthly deposits, payment timing, and Excel's sign rules enter the picture. One misplaced minus sign or a monthly rate paired with annual periods can turn a useful projection into a misleading number.

The Excel FV function solves a practical question: given what you have now, what you add regularly, and the interest rate, what will the balance be later? Here is how to build the formula correctly for savings plans and loan projections.

What the FV function calculates in Excel

FV stands for future value. In Excel, it calculates the ending balance of an investment, savings plan, or loan after a specified number of periods. It can include a starting amount, regular payments, or both.

Use FV when you know the interest rate, the number of periods, the recurring payment amount, and possibly the initial balance, but need to find the ending value. For example, it can answer questions such as:

• How much will $1,000 grow to if I save $200 each month for 10 years?
• What will a loan balance be after 24 payments?
• How much could a retirement or emergency fund be worth at a given date?

You could calculate simple compound interest manually with a formula such as principal * (1 + rate)^periods. That works for a single lump sum. FV is the better Excel function once recurring deposits or payments are part of the model.

Understand the Excel FV formula syntax before entering it

The Excel FV formula syntax is:

=FV(rate, nper, pmt, [pv], [type])

The arguments in brackets are optional. In most real savings calculations, however, you will use at least pv or pmt, and often both.

• rate: Interest rate for each period.
• nper: Total number of payment or compounding periods.
• pmt: Payment made each period.
• pv: Present value, or the starting balance/principal.
• type: Payment timing: 0 for the end of a period, 1 for the beginning.

The most important rule is that rate and nper must use the same period. If deposits are monthly, divide an annual rate by 12 and multiply years by 12. A 6% annual rate over 10 years becomes a monthly rate of 6%/12 and 10*12, or 120 monthly periods.

Excel also follows a cash-flow sign convention. Money you pay out is normally negative; money you receive is positive. If you deposit money into savings, the deposit is an outflow from your perspective, so it is entered as a negative number. The future balance then appears as a positive result.

Calculate compound interest on a lump-sum initial investment

Suppose you invest $10,000 today at 6% annual interest for 10 years, with no additional deposits. Enter:

=FV(6%,10,0,-10000)

In this formula, 6% is the annual rate, 10 is the number of annual periods, and 0 tells Excel there are no regular payments. The -10000 represents the amount you are putting into the investment today.

The formula returns approximately $17,908.48. That positive value is the projected amount you receive at the end of the 10-year period.

The same compound-interest idea can be written manually as:

=10000*(1+6%)^10

Both approaches produce the same projected value in this simple case. The FV function becomes more useful when you begin adding regular savings deposits, because it handles the initial investment and the payment stream in one formula.

Add regular savings deposits to the FV calculation

Now assume you start with $1,000, add $200 at the end of every month, and earn 6% annually for 10 years. Use:

=FV(6%/12,10*12,-200,-1000)

This future value of annuity formula in Excel uses a monthly interest rate and 120 monthly periods. Excel combines the growth of the $1,000 initial investment with the growth of every $200 monthly contribution.

The result is approximately $34,595.27. Your total contributions are $25,000: the original $1,000 plus 120 deposits of $200. The difference comes from the assumed investment growth.

FormulaBerry can translate a plain-language savings scenario into an FV formula to use as a starting point.

The most common error in a monthly FV model is entering 6% as the rate and 10 as the number of periods. That tells Excel to apply 6% every month for only 10 months, which is not the scenario you intended. For monthly savings, use 6%/12 and years*12.

Choose payments at the end or beginning of each period

By default, Excel assumes payments happen at the end of each period. That is type 0, and you can omit it because Excel uses it automatically.

If you deposit money at the beginning of each month instead, use type 1:

=FV(6%/12,120,-200,-1000,1)

This returns a slightly higher amount because each $200 contribution receives one extra month of growth. Use type 1 only if the money genuinely enters the account at the beginning of each period. Do not select it simply because the higher result looks better.

Calculate future value when payments change over time

FV accepts one constant payment amount. It cannot directly model a plan where deposits vary each month, such as $200 most months, $500 in December, and nothing during an unexpected expense.

For changing payments, build a cash-flow schedule. Put one period per row, record the actual deposit for that period, and calculate how much each deposit will be worth at the target date. Then add the projected values together.

For example, keep a base monthly savings plan in one FV calculation and model an annual bonus separately. If you save $200 monthly for 10 years and add a $1,000 bonus at the end of each year, calculate the monthly deposits with FV, calculate the annual bonuses with a second FV formula, and add the results. This is clearer and more accurate than forcing unequal payments into the pmt argument.

A full cash-flow schedule is the best choice when contributions change frequently. It also makes the assumptions visible to anyone reviewing the worksheet.

Use FV for loans and interpret the result correctly

The same FV function can project a loan balance, but the signs must reflect the borrower's cash flows. If you receive a loan amount today, that initial amount is positive from your perspective. Payments you make to the lender are negative.

For example, suppose you borrow $10,000 at 6% annual interest and make monthly payments of $200 for 24 months:

=FV(6%/12,24,-200,10000)

The result represents the projected balance after those payments under the stated assumptions. If the answer is positive, money is still owed; if it reaches zero, the loan has been repaid based on that payment pattern.

FV is useful for a quick balance projection, but it is not a complete amortization schedule. Use an amortization table when the interest rate changes, payments vary, extra principal payments are made, or you need to see the balance and interest charge for every month.

Fix a negative FV result and other common formula errors

A negative FV result does not automatically mean your formula is wrong. It usually means Excel is applying the cash-flow direction you provided.

For example, this formula returns a negative ending value:

=FV(6%/12,120,200,1000)

Excel reads the positive $200 payment and positive $1,000 present value as money received by you. It therefore reports the future amount as a negative outflow. Reverse the signs for a typical savings scenario:

=FV(6%/12,120,-200,-1000)

The magnitude stays the same, but the result now displays as a positive future balance.

Also check these common problems before rewriting the formula:

• #VALUE! error: One or more inputs may be text rather than numbers. Remove currency symbols typed directly into cells, apostrophes, or text labels from the value cells.
• Result is too high or too low: Check that the interest rate and number of periods match. Monthly payments require a monthly rate and monthly periods.
• Payments seem ignored: Confirm that the pmt argument is not zero, blank, or stored as text.
• Small unexpected difference: Check payment timing. Type 0 and type 1 produce different results.

Know when to use PV versus FV in Excel

Use FV when you want to know what a known starting amount and payment plan will grow into. Use PV when you know the target amount and need to calculate how much is required today.

For instance, FV can answer: "If I start with $1,000 and save $200 per month for 10 years, what will I have?" PV answers the reverse question: "If I want approximately $34,595.27 in 10 years, how much do I need to invest now if I continue saving $200 per month?"

The direction of the question determines the function. FV moves forward from today's amounts to a future balance; PV works backward from a future target to a present amount.

If the missing input is the interest rate rather than the starting or ending balance, use Excel's RATE function. RATE is the appropriate rate formula in Excel when you know the payment, term, present value, and future value but need to solve for the periodic return or borrowing rate.

Use the FV function in Google Sheets

Google Sheets supports the same core calculation. Its syntax is:

=FV(rate, number_of_periods, payment_amount, [present_value], [end_or_beginning])

The monthly savings example works in Google Sheets as written:

=FV(6%/12,10*12,-200,-1000)

The same rules apply: match the period used for the rate and the number of periods, use consistent cash-flow signs, and set the final argument to 1 only for beginning-of-period deposits. Whether you are using an FV function in Sheets or Excel, the financial logic matters more than the software label.

Build a reusable future-value worksheet

Do not hard-code every number into a formula if you expect to update the plan. A reusable worksheet makes assumptions easier to review and reduces mistakes when rates or contributions change.

Set up labeled input cells such as:

Cell	Label	Example value
B2	Annual interest rate	6%
B3	Years	10
B4	Monthly deposit	200
B5	Initial investment	1000
B6	Payment timing	0

Then calculate the future value with:

=FV(B2/12,B3*12,-B4,-B5,B6)

Add a separate total-contributions cell with:

=B5+(B4*B3*12)

Showing both the projected ending balance and total contributions helps you see how much of the final amount comes from deposits versus growth. It also gives you a quick reasonableness check before using the estimate in a financial decision.

FormulaBerry

FormulaBerry is useful when you understand the financial scenario but need help translating it into an Excel or Google Sheets formula. You can describe the inputs in plain language, such as "I have $1,000, save $200 monthly for 10 years at 6%, with deposits at the end of the month," and use the generated formula as a starting point. For broader formula help, see the Excel Formula Generator: Create, Explain, and Fix Formulas.

It can also explain an existing FV formula or help identify a misplaced argument. Its limitation is important: it cannot decide whether your assumed interest rate, contribution schedule, or savings goal is financially appropriate. You still need to supply accurate inputs and verify whether deposits occur at the beginning or end of each period.

Apply FV confidently to your next savings or loan projection

The FV formula in Excel is reliable when the inputs match the real situation. Keep the interest rate and number of periods in the same unit, use negative signs for money you pay out, and deliberately choose whether payments occur at the beginning or end of each period.

Before relying on a large projection, test your model with a simple known example, such as a one-time $10,000 investment at 6% for 10 years. Then add monthly contributions or loan payments after the base calculation behaves as expected.

If you need help turning a stated savings or loan scenario into a formula, FormulaBerry's formula generator can generate, explain, or correct an FV formula for Excel or Google Sheets.