Calculate After-Tax Investment Growth in Excel with FV
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.
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.
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.
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.
Select an empty result cell and enter =FV((B3*(1-E25))/12,C9,0,-C8,0).
Press Enter to calculate the estimated future value. If needed, select the result cell and use Home > Number to apply a currency format.

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. Open a spreadsheet: Open WPS Spreadsheet and create a workbook or open an existing Excel file.
- 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. Calculate the future value: Select an empty cell, enter =FV((B3*(1-E25))/12,C9,0,-C8,0), and press Enter.
- 4. Format the result: Select the result cell and use the number-format controls on the Home tab to display it as currency.

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.




