### FRP Taxes (Need to Compute Taxes Paid each Year)

Posted:

**Mon Jun 29, 2020 3:35 pm**Jim/Gentlemen,

I am in the process of benchmarking my FRP model results against the Optimal Retirement Planner (ORP) which I have previously used for years but wanting to branch out a bit. Obviously there are a few differences between the two models/applications, but I am specifically having comparing them from a tax perspective. Here's where I am .....

I've determined suitable values for Investment Tax Rate and Income Tax Rate. Yes I realize these are effective NOT marginal values.

I've run FRP with comparable inputs to my ORP model and the results (from the perspective of a "available expense monies) seem reasonably close. But I want to drill down on the taxes. I've clicked the FRP Detailed View tab and Show More Detail button and I get a full report with 21 columns as follows (my letters assigned for clarity):

A Year

B Median Portfolio Value

C Taxable Portfolio Value

D Tax Def Portfolio Value

E Tax Free Portfolio Value

F Taxes on Portfolio Growth

G New Investment

H New Taxable Inv

I New Tax Def Inv

J New Tax Free Inv

K Median RMD

L Taxes on RMD

M RMD Avail For Expenses

N Planned Expenses

O % Expenses To Fund

P Expenses To Fund

Q RMD Used For Expenses

R After Tax Income

S Additional Withdrawal

T Taxes On Withdrawal

U Additional Withdrawal With Taxes

Note there is no column for Taxes Paid. So I figure I must create one, perhaps using some data from the 21 columns (A thru U) available to me and the specified Investment Tax Rate and Income Tax Rate, but I am stumped as to how.

I am in the process of benchmarking my FRP model results against the Optimal Retirement Planner (ORP) which I have previously used for years but wanting to branch out a bit. Obviously there are a few differences between the two models/applications, but I am specifically having comparing them from a tax perspective. Here's where I am .....

I've determined suitable values for Investment Tax Rate and Income Tax Rate. Yes I realize these are effective NOT marginal values.

I've run FRP with comparable inputs to my ORP model and the results (from the perspective of a "available expense monies) seem reasonably close. But I want to drill down on the taxes. I've clicked the FRP Detailed View tab and Show More Detail button and I get a full report with 21 columns as follows (my letters assigned for clarity):

A Year

B Median Portfolio Value

C Taxable Portfolio Value

D Tax Def Portfolio Value

E Tax Free Portfolio Value

F Taxes on Portfolio Growth

G New Investment

H New Taxable Inv

I New Tax Def Inv

J New Tax Free Inv

K Median RMD

L Taxes on RMD

M RMD Avail For Expenses

N Planned Expenses

O % Expenses To Fund

P Expenses To Fund

Q RMD Used For Expenses

R After Tax Income

S Additional Withdrawal

T Taxes On Withdrawal

U Additional Withdrawal With Taxes

Note there is no column for Taxes Paid. So I figure I must create one, perhaps using some data from the 21 columns (A thru U) available to me and the specified Investment Tax Rate and Income Tax Rate, but I am stumped as to how.

**Bottom Line: I want to compute a new column that is essentially total Taxes Paid for each Year. Help Please?**