Calculation Issues

Calculate After-Tax Investment Growth in Excel with FV

Kushani NimanthikaKushani Nimanthika Nov 14, 2026 868 views

Question details

Calculate the future value of an investment after accounting for tax on its growth.

Product
Microsoft Excel
Device & OS
not provided
Scenario
Estimate monthly compounded investment growth without regular contributions using the FV function.
Observed behavior
The desired result is an estimated future investment value using a tax-adjusted growth rate.
Before you start

Enter the annual growth rate in B3, the starting investment in C8, the number of months in C9, and the tax rate on growth in E25. Enter rates as percentages or equivalent decimals, such as 5% or 0.05.

Solution 1Recommended

Use Excel FV with a Tax-Adjusted Growth Rate

Use this formula to estimate future value when investment growth is taxed at a constant rate and compounded monthly.

The formula reduces the annual growth rate by the tax rate, then divides it by 12 to obtain a monthly rate. It assumes B3 is a nominal annual rate and that tax applies to each month's growth before reinvestment.

This is a simplified estimate. Tax-deferred accounts, taxes paid only when an investment is sold, and other tax rules may produce different results.

1
Enter the investment inputs

In the worksheet, enter the annual growth rate in B3, the starting investment in C8, the investment term in months in C9, and the tax rate on growth in E25.

2
Enter the FV formula

Select an empty result cell and enter =FV((B3*(1-E25))/12,C9,0,-C8,0).

3
Check the result

Press Enter to calculate the estimated future value. If needed, select the result cell and use Home > Number to apply a currency format.

Use Excel FV with a Tax-Adjusted Growth Rate
Why the starting investment is negative: The formula uses -C8 to represent the initial investment as an outflow, so FV returns the future value as a positive amount.
Calculate investment growth in WPS

Estimate After-Tax Investment Growth in WPS Spreadsheet

Use the FV function in WPS Spreadsheet to calculate an estimated future investment value with a tax-adjusted monthly growth rate.

  1. 1. Open a spreadsheet: Open WPS Spreadsheet and create a workbook or open an existing Excel file.
  2. 2. Enter the inputs: Enter the annual growth rate in B3, the starting investment in C8, the number of months in C9, and the tax rate in E25.
  3. 3. Calculate the future value: Select an empty cell, enter =FV((B3*(1-E25))/12,C9,0,-C8,0), and press Enter.
  4. 4. Format the result: Select the result cell and use the number-format controls on the Home tab to display it as currency.
Calculate monthly compounded growth with the FV functionOpen and save Microsoft Excel XLSX filesFormat the result as currency for easier reading
microsoft office alternative - wps office

Frequently Asked Questions

Should I enter the tax rate as 20 or 20%?

Enter 20% or its decimal equivalent, 0.20, in E25. Entering 20 would represent a rate of 2,000%.

What does C9 represent in the formula?

C9 is the number of monthly compounding periods. For a five-year investment, enter 60.

Does this formula account for tax only when I sell the investment?

No. It reduces each month's growth rate before compounding. An investment taxed only on sale requires a different calculation based on the applicable tax rules.

Can I include regular contributions in this formula?

Yes. Replace the third FV argument, currently 0, with a negative monthly contribution amount. Check the timing of contributions when choosing the final FV argument.