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

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

• Age — xxx
• Year — xxx
• Income Name — A column for each income stream, column headers correspond to the income's Name. The values shown are pre-tax amounts.
• Gross (pre-tax) Total Income — xxx
• Pre-Tax Contributions — xxx
• Tax Rate — xxx
• Net (post-tax) Total Income — xxx

2. Expenses Tab

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

• Age — xxx
• Year — xxx
• Expense Name — One column for each expense item, column headers correspond to expense's Name. The values shown are pre-tax amounts.
• Total Debt from Expenses — xxx
• Sourced Expenses — xxx
• Total Expenses — xxx

3. Accounts Tab

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:

• Age — xxx
• Year — xxx
• Defined Contribution — xxx
• Miscellaneous Contributions — xxx
• Contributions from Employer — xxx
• Contributions from RMDs — xxx
• Taxes on RMDs — xxx
• RMD — xxx
• Total Gains for Year — xxx
• Annually-Taxed Amount — xxx
• Taxes on Annual Gain — xxx
• Total Tax-Deferred Gains — xxx
• Cashflow Contribution — xxx
• Drawdown Withdrawal — xxx
• Rollover withdrawal — xxx.
• Early Withdrawal — xxx
• Early Withdrawal Penalty — xxx
• Taxes on Tax-Deferred Withdrawals — xxx
• Remaining Principal — xxx
• Balance Adjustment — xxx
• Inflation Devaluation — xxx
• Balance (Start of Year) — xxx
• Balance (End of Year) — xxx

4. Drawdowns Tab

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:

• Age — xxx
• Year — xxx
• Account — xxx
• Amount — xxx
• Purpose — xxx
• Criteria Met — xxx

For more information on Drawdowns, see the guide

5. Grand Total Tab

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

6. Metrics for Year