 |
Sample Roth
Conversion Worksheet
The
new and improved Roth conversion program.
<% if request("process") = "Process" then
' calculate
Roth_Withdrawl = Request("amountConvert")*.8*(Request("taxBracket")/100)
Annual_Tax = Request("amountConvert")*(Request("taxBracket")/100)*0.058
Sum_Annual_Tax = Request("amountConvert")*(Request("taxBracket")/100)*0.058*30
Tax_Reduced = Request("amountConvert")*(Request("taxBracket")/100)
Ten_Percent = Request("amountConvert")*.10
Twenty_Percent = Request("amountConvert")*.20
Sum_Tax_Due_Tenp = Request("amountConvert")*(.10)*(Request("taxBracket")/100)*62
Tax_Due_Tenp = Request("amountConvert")*(.10)*(Request("taxBracket")/100)
Tax_Due_Twep = Request("amountConvert")*(.20)*(Request("taxBracket")/100)
Sum_Tax_Due_Twep = Request("amountConvert")*(.20)*(Request("taxBracket")/100)*51
Net_After1 = Request("amountConvert")*.10-Request("amountConvert")*(.10)*(Request("taxBracket")/100)
Net_After3 = Request("amountConvert")*.20-Request("amountConvert")*(.20)*(Request("taxBracket")/100)
Net_After4 = Request("amountConvert")*.20-Request("amountConvert")*(Request("taxBracket")/100)*0.058
Net_After2 = Request("amountConvert")*.10-Request("amountConvert")*(Request("taxBracket")/100)*0.058
%>
| Save
On Taxes |
| |
|
|
| Tax
Due Under Traditional Conversion |
| Year |
|
| 1 |
<%= FormatCurrency(Tax_Reduced,0) %> |
| 2 |
0 |
| 3 |
0 |
| 4 |
0 |
| 5 |
0 |
| 6 |
0 |
| 7 |
0 |
| 12 |
0 |
| 17 |
0 |
| 22 |
0 |
| 27 |
0 |
| 32 |
0 |
|
 |
| Tax
Due Under New & Improved Roth Conversion |
| Year |
|
| 1 |
0 |
| 2 |
0 |
| 3 |
<%= FormatCurrency(Annual_Tax,0) %> |
| 4 |
<%= FormatCurrency(Annual_Tax,0) %> |
| 5 |
<%= FormatCurrency(Annual_Tax,0) %> |
| 6 |
<%= FormatCurrency(Annual_Tax,0) %> |
| 7 |
<%= FormatCurrency(Annual_Tax,0) %> |
| 12 |
<%= FormatCurrency(Annual_Tax,0) %> |
| 17 |
<%= FormatCurrency(Annual_Tax,0) %> |
| 22 |
<%= FormatCurrency(Annual_Tax,0) %> |
| 27 |
<%= FormatCurrency(Annual_Tax,0) %> |
| 32 |
<%= FormatCurrency(Annual_Tax,0) %> |
|
|
Keep More Income
IRA vs the
roth rollover.
Which
strategy provides more after tax income?
Assume
you opt to take <%= FormatCurrency(Ten_Percent,0) %> per year
from your account.
|
| |
|
|
| Keep
Money In IRA |
| Year |
IRA
distribution |
Tax
due |
Net
after tax |
| 1 |
<%= FormatCurrency(Ten_Percent,0) %> |
<%= FormatCurrency(Tax_Due_Tenp,0) %> |
<%= FormatCurrency(Net_After1,0) %> |
| 2 |
<%= FormatCurrency(Ten_Percent,0) %> |
<%= FormatCurrency(Tax_Due_Tenp,0) %> |
<%= FormatCurrency(Net_After1,0) %> |
| 3 |
<%= FormatCurrency(Ten_Percent,0) %> |
<%= FormatCurrency(Tax_Due_Tenp,0) %> |
<%= FormatCurrency(Net_After1,0) %> |
| 4 |
<%= FormatCurrency(Ten_Percent,0) %> |
<%= FormatCurrency(Tax_Due_Tenp,0) %> |
<%= FormatCurrency(Net_After1,0) %> |
| 5 |
<%= FormatCurrency(Ten_Percent,0) %> |
<%= FormatCurrency(Tax_Due_Tenp,0) %> |
<%= FormatCurrency(Net_After1,0) %> |
| 6 |
<%= FormatCurrency(Ten_Percent,0) %> |
<%= FormatCurrency(Tax_Due_Tenp,0) %> |
<%= FormatCurrency(Net_After1,0) %> |
| 7 |
<%= FormatCurrency(Ten_Percent,0) %> |
<%= FormatCurrency(Tax_Due_Tenp,0) %> |
<%= FormatCurrency(Net_After1,0) %> |
| 12 |
<%= FormatCurrency(Ten_Percent,0) %> |
<%= FormatCurrency(Tax_Due_Tenp,0) %> |
<%= FormatCurrency(Net_After1,0) %> |
| 17 |
<%= FormatCurrency(Ten_Percent,0) %> |
<%= FormatCurrency(Tax_Due_Tenp,0) %> |
<%= FormatCurrency(Net_After1,0) %> |
| 22 |
<%= FormatCurrency(Ten_Percent,0) %> |
<%= FormatCurrency(Tax_Due_Tenp,0) %> |
<%= FormatCurrency(Net_After1,0) %> |
| 27 |
<%= FormatCurrency(Ten_Percent,0) %> |
<%= FormatCurrency(Tax_Due_Tenp,0) %> |
<%= FormatCurrency(Net_After1,0) %> |
| 32 |
<%= FormatCurrency(Ten_Percent,0) %> |
<%= FormatCurrency(Tax_Due_Tenp,0) %> |
<%= FormatCurrency(Net_After1,0) %> |
| 62 |
<%= FormatCurrency(Ten_Percent,0) %> |
<%= FormatCurrency(Tax_Due_Tenp,0) %> |
<%= FormatCurrency(Net_After1,0) %> |
| |
|
<%= FormatCurrency(Sum_Tax_Due_Tenp,0) %> |
|
|
|
| Roll
to the Roth |
| Year |
Roth
distribution |
Tax
payment |
Net
after tax |
| 1 |
<%= FormatCurrency(Ten_Percent,0) %> |
0 |
<%= FormatCurrency(Ten_Percent,0) %> |
| 2 |
<%= FormatCurrency(Ten_Percent,0) %> |
0 |
<%= FormatCurrency(Ten_Percent,0) %> |
| 3 |
<%= FormatCurrency(Ten_Percent,0) %> |
<%= FormatCurrency(Annual_Tax,0) %> |
<%= FormatCurrency(Net_After2,0) %> |
| 4 |
<%= FormatCurrency(Ten_Percent,0) %> |
<%= FormatCurrency(Annual_Tax,0) %> |
<%= FormatCurrency(Net_After2,0) %> |
| 5 |
<%= FormatCurrency(Ten_Percent,0) %> |
<%= FormatCurrency(Annual_Tax,0) %> |
<%= FormatCurrency(Net_After2,0) %> |
| 6 |
<%= FormatCurrency(Ten_Percent,0) %> |
<%= FormatCurrency(Annual_Tax,0) %> |
<%= FormatCurrency(Net_After2,0) %> |
| 7 |
<%= FormatCurrency(Ten_Percent,0) %> |
<%= FormatCurrency(Annual_Tax,0) %> |
<%= FormatCurrency(Net_After2,0) %> |
| 12 |
<%= FormatCurrency(Ten_Percent,0) %> |
<%= FormatCurrency(Annual_Tax,0) %> |
<%= FormatCurrency(Net_After2,0) %> |
| 17 |
<%= FormatCurrency(Ten_Percent,0) %> |
<%= FormatCurrency(Annual_Tax,0) %> |
<%= FormatCurrency(Net_After2,0) %> |
| 22 |
<%= FormatCurrency(Ten_Percent,0) %> |
<%= FormatCurrency(Annual_Tax,0) %> |
<%= FormatCurrency(Net_After2,0) %> |
| 27 |
<%= FormatCurrency(Ten_Percent,0) %> |
<%= FormatCurrency(Annual_Tax,0) %> |
<%= FormatCurrency(Net_After2,0) %> |
| 32 |
<%= FormatCurrency(Ten_Percent,0) %> |
<%= FormatCurrency(Annual_Tax,0) %> |
<%= FormatCurrency(Net_After2,0) %> |
| 62 |
<%= FormatCurrency(Ten_Percent,0) %> |
$0 |
<%= FormatCurrency(Ten_Percent,0) %> |
| |
|
<%= FormatCurrency(Sum_Annual_Tax,0) %> |
|
|
Defer
for More Income
IRA
vs the roth rollover.
Which strategy
provides more after tax income after 12 years of growth?
Assume you
opt to take <%= FormatCurrency(Twenty_Percent,0) %> per year from your
account.
| Keep
Money In IRA |
| Year |
IRA
distribution |
Tax
due |
Net
after tax |
| 1 |
|
|
|
| 2 |
|
|
|
| 3 |
|
|
|
| 4 |
|
|
|
| 5 |
|
|
|
| 6 |
|
|
|
| 7 |
|
|
|
| 12 |
<%= FormatCurrency(Twenty_Percent,0) %> |
<%= FormatCurrency(Tax_Due_Twep,0) %> |
<%= FormatCurrency(Net_After3,0) %> |
| 17 |
<%= FormatCurrency(Twenty_Percent,0) %> |
<%= FormatCurrency(Tax_Due_Twep,0) %> |
<%= FormatCurrency(Net_After3,0) %> |
| 22 |
<%= FormatCurrency(Twenty_Percent,0) %> |
<%= FormatCurrency(Tax_Due_Twep,0) %> |
<%= FormatCurrency(Net_After3,0) %> |
| 27 |
<%= FormatCurrency(Twenty_Percent,0) %> |
<%= FormatCurrency(Tax_Due_Twep,0) %> |
<%= FormatCurrency(Net_After3,0) %> |
| 32 |
<%= FormatCurrency(Twenty_Percent,0) %> |
<%= FormatCurrency(Tax_Due_Twep,0) %> |
<%= FormatCurrency(Net_After3,0) %> |
| 62 |
<%= FormatCurrency(Twenty_Percent,0) %> |
<%= FormatCurrency(Tax_Due_Twep,0) %> |
<%= FormatCurrency(Net_After3,0) %> |
| |
|
<%= FormatCurrency(Sum_Tax_Due_Twep,0) %> |
|
|
| Roll
to the Roth |
| Year |
Roth
distribution |
Tax
payment |
Net
after tax |
| 1 |
|
0 |
|
| 2 |
|
0 |
|
| 3 |
|
<%= FormatCurrency(Annual_Tax,0) %> |
|
| 4 |
|
<%= FormatCurrency(Annual_Tax,0) %> |
|
| 5 |
|
<%= FormatCurrency(Annual_Tax,0) %> |
|
| 6 |
|
<%= FormatCurrency(Annual_Tax,0) %> |
|
| 7 |
|
<%= FormatCurrency(Annual_Tax,0) %> |
|
| 12 |
<%= FormatCurrency(Twenty_Percent,0) %> |
<%= FormatCurrency(Annual_Tax,0) %> |
<%= FormatCurrency(Net_After4,0) %> |
| 17 |
<%= FormatCurrency(Twenty_Percent,0) %> |
<%= FormatCurrency(Annual_Tax,0) %> |
<%= FormatCurrency(Net_After4,0) %> |
| 22 |
<%= FormatCurrency(Twenty_Percent,0) %> |
<%= FormatCurrency(Annual_Tax,0) %> |
<%= FormatCurrency(Net_After4,0) %> |
| 27 |
<%= FormatCurrency(Twenty_Percent,0) %> |
<%= FormatCurrency(Annual_Tax,0) %> |
<%= FormatCurrency(Net_After4,0) %> |
| 32 |
<%= FormatCurrency(Twenty_Percent,0) %> |
<%= FormatCurrency(Annual_Tax,0) %> |
<%= FormatCurrency(Net_After4,0) %> |
| 62 |
<%= FormatCurrency(Twenty_Percent,0) %> |
$0 |
<%= FormatCurrency(Twenty_Percent,0) %> |
| |
|
<%= FormatCurrency(Sum_Annual_Tax,0) %> |
|
|
<% end if %>
Click
here
to complete a client fact finder now!
Copyright,
1998-2002, US Library Of Congress
|