Great program, but I think I may have found an editing bug in the "Taxes on portfolio growth" column of detailed view. I'm running version 4.03.02.
Assume a 100,000k taxable portfolio (0 for the other 2). 0% interest, 20% investment and income tax rates. In additional inputs set 10% rate of return from start of plan to end of plan with no standard deviation. Set annual retirement spending to 20000.
What I get the in taxes on portfolio growth the first year is $1728. That appears to be calculated based on the subsequent year (and done either incorrectly or in a manner I do not understand). Using the value of $86400 (calculated below). The taxes on that balance's growth would be 86400*0.1*.2 = $1728. SO I think I understand how it was calculated, but:
The taxable portfolio value in the first year (86400) is correct. it is calculated as $100,000  20,000 expenses = 80000. Then there is growth of 10% so $88000. Then taxes are calculated as 8000*0.20 = *1860. Final balance is $100000  20000 + 8000  1860 = $86400, which is right.
I sure expect that the taxes on portfolio growth in that year should thus be reported as $1860. But possibly it would show up in the following year (deferred?). Regardless, that $1860 value never shows up in the taxes on portfolio growth column, so I'm quite confused.
But it is an extra column, and doesn't seem to impact the real ones that matter...
Attachment has the very simple frp file I was playing with.
Thoughts?
Thanks much.
Detailed view  taxes on portfolio growth seem wrong
Detailed view  taxes on portfolio growth seem wrong
 Attachments

 2020test2.zip
 (1.37 KiB) Downloaded 57 times
Re: Detailed view  taxes on portfolio growth seem wrong
Logically, annual expenses are deducted from the portfolio on the first of the year and portfolio growth and taxes are computed at the end of the year. Does that help to make your numbers make sense?
Re: Detailed view  taxes on portfolio growth seem wrong
Hi Jim,
No, it does not.
I've already subtracted expenses at the beginning (100K 20K = 80k). Then figured the return on 80K => 88K, then the taxes on the 8K (which I believe is consistent with the end of the year). The number in the taxes on portfolio growth column still seems wrong (and inconsistent with the taxes on portfolio growth actually used in the calculation of the value reported in the "taxable portfolio value" column. I believe taxes should be $1600 in that first year.
Do note I made a typo on the taxes part originally. Everywhere I typed 1860 (all 4 times) should instead be 1600. So sorry about that.
No, it does not.
I've already subtracted expenses at the beginning (100K 20K = 80k). Then figured the return on 80K => 88K, then the taxes on the 8K (which I believe is consistent with the end of the year). The number in the taxes on portfolio growth column still seems wrong (and inconsistent with the taxes on portfolio growth actually used in the calculation of the value reported in the "taxable portfolio value" column. I believe taxes should be $1600 in that first year.
Do note I made a typo on the taxes part originally. Everywhere I typed 1860 (all 4 times) should instead be 1600. So sorry about that.
Re: Detailed view  taxes on portfolio growth seem wrong
Thanks for the update and for the nice clear report of what you are seeing.
That column was sort of an afterthought and because I didn't want to increase the storage used by the sim code, I calculate it after the fact rather than saving the data needed to pull a median value out of the simulation.
Anyhow, as you indicated, I was sloppy with the calculation. I was using the ending portfolio value and just multiplying it by the growth rate times the tax rate. The trouble is the calculation should be based on the starting portfolio value (after expenses but before any portfolio contributions).
The easiest way I can think of to correct this is to solve for the start portfolio value based on the ending value, the growth rate, and the tax rate. To do this, I brushed off my algebra skills (thanks google) and came up with this formula:
taxes on growth = (ending portfolio value / (1 + (return * (1  tax rate))) * return * tax rate
I updated the code to use this formula and it seems to produce the expected results.
I'm not exactly sure when I'll release the next version, so if you'd like a prerelease version, just email me at info@flexibleRetirementPlanner.com and I'll send a download link for an interim version.
Jim
That column was sort of an afterthought and because I didn't want to increase the storage used by the sim code, I calculate it after the fact rather than saving the data needed to pull a median value out of the simulation.
Anyhow, as you indicated, I was sloppy with the calculation. I was using the ending portfolio value and just multiplying it by the growth rate times the tax rate. The trouble is the calculation should be based on the starting portfolio value (after expenses but before any portfolio contributions).
The easiest way I can think of to correct this is to solve for the start portfolio value based on the ending value, the growth rate, and the tax rate. To do this, I brushed off my algebra skills (thanks google) and came up with this formula:
taxes on growth = (ending portfolio value / (1 + (return * (1  tax rate))) * return * tax rate
I updated the code to use this formula and it seems to produce the expected results.
I'm not exactly sure when I'll release the next version, so if you'd like a prerelease version, just email me at info@flexibleRetirementPlanner.com and I'll send a download link for an interim version.
Jim
Re: Detailed view  taxes on portfolio growth seem wrong
Thanks jim.
I sent you an email the other day. Gonna try again from a different account.
I sent you an email the other day. Gonna try again from a different account.
Re: Detailed view  taxes on portfolio growth seem wrong
Hi Jim,
Just updated to version 04.03.03.
Have a very naïve question regarding Portfolio growth and Tax on Growth.
Regarding the formula for Tax on portfolio growth as showed on the Support Forum :
Taxes on growth = (ending portfolio value / (1 + (return * (1  tax rate))) * return * tax rate
Is the “return” in the formula the Investment return before inflation is taken into account? Or after?
For example: Return on investment = 5% and Inflation =2%
Therefore, the investment return afterinflation = 3%
It seems that the Planner reflects the use of beforeinflation number as shown in the “detail table” for “tax on portfolio growth”. It in turn may affect the Investment Portfolio growth value.
Probably wrong on this, but like to ask.
Thanks and look forward to your advice.
PYN
Just updated to version 04.03.03.
Have a very naïve question regarding Portfolio growth and Tax on Growth.
Regarding the formula for Tax on portfolio growth as showed on the Support Forum :
Taxes on growth = (ending portfolio value / (1 + (return * (1  tax rate))) * return * tax rate
Is the “return” in the formula the Investment return before inflation is taken into account? Or after?
For example: Return on investment = 5% and Inflation =2%
Therefore, the investment return afterinflation = 3%
It seems that the Planner reflects the use of beforeinflation number as shown in the “detail table” for “tax on portfolio growth”. It in turn may affect the Investment Portfolio growth value.
Probably wrong on this, but like to ask.
Thanks and look forward to your advice.
PYN
Re: Detailed view  taxes on portfolio growth seem wrong
Keep in mind that this is a display only column. Because I didn't save the original value in the sim code, I had to be reverseengineer the value after the fact. That made the formula a lot more complicated. But this isn't the formula that's used inside the actual simulation code.PYN wrote: ↑Wed Aug 19, 2020 2:18 pmRegarding the formula for Tax on portfolio growth as showed on the Support Forum :
Taxes on growth = (ending portfolio value / (1 + (return * (1  tax rate))) * return * tax rate
Is the “return” in the formula the Investment return before inflation is taken into account? Or after?
The actual simulation calculation uses real return to compute the portfolio growth, and then subtracts out the taxes due, which are computed using nominal return.
Re: Detailed view  taxes on portfolio growth seem wrong
Thanks Jim. I appreciated.
Peter
Peter
Who is online
Users browsing this forum: No registered users and 5 guests