This is the fourth part of a four-part article on the Cash Flow and Tax Advisor Calculator. This tool can assist you in determining the effective tax rate for each year within your financial plan. It also includes a worksheet to differentiate between cash flow and tax liabilities. This section provides step-by-step instructions for entering income when the client has retired, receiving Social Security Benefits, and is withdrawing the RMDs from a Roth account.
To learn more about the Cash Flow and Tax Advisor menu see articles:
To learn more about the Cash Flow and Tax Advisor individual column features see articles:
- Hide/Unhide Feature for Individual Tax Columns
- Permanent Deletion for Individual Tax Columns
- Downloading a 1040 Sample Tax Form
To learn more about forecasting effective tax rates see articles:
- Part One: Forecasting Effective Tax Rates While the Client is working
- Part Two: Forecasting Effective Tax Rates While the Client is in retirement and before Social Security Disbursements
- Part Three: Forecasting Effective Tax Rates While the Client is in Retirement and Social Security Starts Up
- Part Four: Forecasting Effective Tax Rates in Retirement: RMDs, Social Security, and Roth Withdrawals
- Part Five: Adding Expenses into the Cash Flow and Tax Advisor Calculator
Step 1: First Year Income While in Retirement for Social Security and Roth Withdraws: See what incomes need to be modeled in the cashflow and tax advisor to determine the effective tax-rate for that year. 
Step 2: Cash Flow and Tax Advisor: Click on the Cash Flow and Tax Advisor button underneath the Client’s name heading.
Step 3: Edit: Click on the green Edit button underneath the Cashflow and Tax Advisor heading.
Step 4: Add Scenario: Click on the green add scenario button underneath the Cash Flow and Tax Advisor heading.
Step 5: Tax Filing Name: Click on the dropdown to select the tax filing (client 1, client 2, or joint).
Step 6: Tax Filing Year: Click on the dropdown and select which tax year you would like to use. SIPS has the ability to create hypothetical returns for past and future years. 
Step 7: Scenario Title: Enter in a new title for the scenario. 
Step 8: Client 1 Social Security: Enter in the social security amount in the cash flow column. 
Step 9: Short Term Cap Gains: Delete the numbers in the short term capital gains.
Step 10: Long Term Cap Gains: Delete the numbers in the long term capital gains.
Step 11: Client 1 Distribution: Enter in the RMD amount into the Cash Flow column. 
Step 12: Calculate: Click on the green calculate button underneath the Cashflow and Tax Advisor heading.
Step 13: Tax Bracket: Scroll down the page and take note of the marginal tax bracket and effective tax-rate "Eff Tax rate.” 
Step 14: Taxable Social Security: After clicking Calculate, SIPS will automatically show the amount and percentage of the social security that is taxable.
Step 15: Save: Click on the green Save button underneath the Cashflow and Tax Advisor heading.
Step 16: Structured Income Planning: Click on the Structured Income Planning button underneath the Client’s name heading.
Step 17: Edit: Click on the green Edit button underneath the Structured Income Planning heading.
Step 18: Add Inc Tax: Click on the green Add Inc Tax button underneath the Structured Income Planning heading.
Step 19: Add Adjustment Text Box: Enter in the effective tax rate. 
Step 20: Tax Adjustment Check Boxes: Click on the box where you would like the effective tax rate to start. 
Step 21: Start Year for Rest of Plan: Click on the green Start Year for Rest of Plan button.
Step 22: Tax Adjustment Table: The new effective tax rate will automatically be entered into the Tax Adjustment Table.
Step 23: Save: Click on the green Save button underneath the Manage Tax heading.
Step 24: Income Tax Column: The new effective tax rate will automatically be changed in the Income Tax Column.
Step 25: Save: Click on the green save button underneath the Structured Income Planning heading.
If you feel you need more support or would like to set up demo time with one of our representatives, please contact us at: +1-888-449-6917 or support@planscout.com.
