Help with FV formula with taxes and inflation

[rham243]

I am tasked with re creating the calculator shown in the attached picture. I have a simple FV formula to accomplish everything up to and including the starting amount. I just need to incorporate the last three elements including Increase Amount, Tax rate, and Inflation rate. Thanks in advance! Please disregard the chart in the bottom right

I have also attached what I have so far

[shg]

Maybe ...

Row\Col	A	B	C
1	Payment	$ 1,000.00
2	Matures for	10	years
3	Annual Rate	10%
4	Starting Amt	$ -
5	Inflation	3%
6	Tax rate	20%
7
8	Future Value	$161,118.44	B8: =FV((B3 - B5) * (1 - B6) /12, B2*12, -B1, B4, 1)

[rham243]

The above works great, thank you! I also need to add the increase amount as shown in the image above. This increases the payment yearly by whatever percentage is input here. How do I incorporate this?

[shg]

That would be messy via formula.

[rham243]

That would be messy via formula.

I know that's why I ask. There has to be a way to incorporate this. The calc in the picture does it just fine.

[rham243]

[shg]

The calc in the picture does it just fine.

Chances are, it doesn't do it with Excel formulas. A user-defined function would be more appropriate.

[rham243]

Does anyone have a solution?

[J.Ty.]

Hi,

Are you still looking for a solution? I have been directed to your post by shg, on a different forum.

J.Ty.