Output Data

Output Data

Do you love data? Are you, in fact, a data junkie? If so, select Output Data from the main Menu to launch a new page with five primary tabs. The tabs are labeled Incomes, Expenses, Accounts, Drawdowns and Grand Total. Selecting a tab displays a table view of relevant data for the current scenario. Amounts are shown in either today’s or tomorrow’s dollars based on the setting of the radio buttons in the upper right-hand corner of the page.

1. Incomes Tab

Show Data

This tab contains data relevant to the Income item table and displays the following columns:

2. Expenses Tab

Show Data

This tab contains data relevant to the Expenses item table and displays the following columns:

Show Data

Clicking Accounts displays subordinate tabs for each account defined in the Accounts & Taxes table along with an Account Totals tab. Selecting a subordinate tab displays details corresponding to that account in a tabular view on a year-by-year basis.

The contents of each subordinate data table varies somewhat, depending upon the terms relevant to a particular account type and its tax handling (i.e. whether it is a tax-deferred account or not). There are 3 account types outlined below:

The Default Account — Your Default Account is the top-most account in your account list and where your positive cashflow accumulates by default. This is also the account that receives dispersals such as RMDs or rollover funds from other accounts.

Tax-Deferred Accounts — This is any account with an Tax Type of either Tax-Deferred, Tax-Deferred (gains only), or Tax-Exempt. Typically, these are accounts like 401ks, 403bs, IRAs, etc. The gains in these accounts are not taxed until funds are withdrawn.

Annually-Taxed Accounts — This is any account with an Tax Type of Tax-Annual. Typically, these are accounts like Checking, Savings, or even Brokerage accounts depending on trading frequency. These types of accounts can contain a mix of annually-taxed gains and deferred gains.

Account Data Columns

Based on the type of Account being displayed, relevant columns are displayed. Below are all possible columns for all Account types:

4. Drawdowns Tab

Show Data

Unlike other tables that displays data for each year, this table displays a row every time a drawdown from an Account occurs — as a result there could be multiple entries for some years, and for others, none at all. The following columns are displayed:

For more information on Drawdowns, see the guide

5. Grand Total Tab

Show Data

This table shows an integrated summary of all Income, Expense and Account items. The following columns are displayed:

  • Agexxx
  • Yearxxx
  • Gross (pre-tax) Total Income — The pre-tax total of all income streams.
  • Other Contributionsxxx
  • Taxes on Incomexxx
  • Tax Creditsxxx
  • RMDsxxx
  • Taxes on RMDsxxx
  • Taxes on Tax-Deferred Withdrawalxxx
  • Total Gains for Yearxxx
  • Taxes on Annual Gainsxxx
  • Expensesxxx
  • Income Tax Ratexxx
  • Gains Tax Ratexxx
  • Cashflowxxx
  • Funded Contributionsxxx
  • Inflation Devaluationxxx
  • Total Debtxxx
  • Total — The account balance at the end of the year. All columns except, RMDs, Funded Contributions, Cashflow, and Total Debt are used to calculate the Total. The following calculation is performed for each year:
  • Previous Year's Total
    + Gross (pre-tax) Total Income
    + Other Contributions
    - Taxes on Income
    + Tax Credits
    - Taxes on RMDs
    - Taxes on Tax-Deferred Withdrawals
    + Gains
    - Taxes on Annual Gains
    - Expenses
    - Inflation Devaluation

    Note: The Total may be plus/minus a few dollars due to rounding multiple values for Today's versus Tomorrow's dollars.

  • Tracked Progressxxx
  • Progress Growthxxx
  • Variable Spending Approach — This is an informational column showing what your spending would be for a given year should you use a variable spending approach based on the amount of assets from the previous year. A common approach is to use 4%. If you would like a different amount displayed, go to Menu / Interface Options and change the "Default Variable Spending Approach" value.
  • 6. Metrics for Year

    This section displays a few interesting Metrics associated with the year you are currently in. The following are displayed:

    The following topics will be covered in this Guide: