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 — Your age in the corresponding year.
• Year — The year corresponding to each row in the table.
• 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 — The total of Income for the year (pre-tax).
• Pre-Tax Contributions — When you contribute to certain types of Retirement Plans (such as 401Ks or Traditional IRAs) those contributions typically occur "pre-tax". This column shows any of those contributions that are deducted from your Income before calculating your Taxes on Income, which is displayed on the Grand Total tab.
• Tax Rate — The tax rate applied to Income for that year.
• Net (post-tax) Total Income — The total income amount after taxes.

2. Expenses Tab

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

• Age — Your age in the corresponding year.
• Year — The year corresponding to each row in the table.
• 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 — The total of amount of debt you have defined within Expense items.
• Total Expenses — The total of the amounts in the other columns.

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
• Tax-Deferred Accounts
• Annually-Taxed Accounts

The Deposit 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. It displays the following columns:

• Age — Your age in the corresponding year.
• Year — The year corresponding to each row in the table.
• Defined Contribution — The annual amount contributed to this account as specified on the Accounts & Taxes page.
• Contributions from Drawdowns / Rollovers / Credits — Deposits made to this account as a result of drawdowns from other accounts (when required to cover negative cash flows) as well as scheduled rollovers from other accounts (note: a rollover occurs when the End Age of an account is reached). This column also includes any tax "credits" you receive by contributing certain types of retirement accounts, such as 401Ks or Traditional IRAs.
• Contributions from RMDs — This column is unique to the default account. When RMDs are taken from tax-deferred accounts, they go into this account. This column shows the gross annual RMD amount being deposited.
• Taxes on RMDs — The taxes on the gross RMD amount.
• Pre-Tax Gains — The annual growth of this account.
• Taxes on Annual Gains — The annual taxes on the growth of this account.
• Cashflow Contribution — The annual contributions to this account resulting from positive cash flows (i.e. the excess funds available whenever current income exceeds current expenses).
• Drawdown Withdrawal — The annual withdrawals from this account resulting from negative cash flows (i.e. the shortage of funds that must be accounted for whenever current expenses exceed current income).
• Inflation Devaluation — This term applies whenever the data is shown in today’s dollars and is the effective loss of purchasing power of the dollars in this account due to inflation.
• Balance (Start of Year) — The account balance at the start of the associated year.
• Balance (End of Year) — The account balance at the end of the associated year.

Tax-Deferred Accounts

This is any account with an Investment Tax 'Type' of Tax-Deferred, Tax-Deferred (gains only), or Tax-Exempt. Typically, these are accounts like 401ks, 403bs, IRAs, etc. Tax-Deferred accounts display the following columns:

• Age — Your age in the corresponding year.
• Year — The year corresponding to each row in the table.
• Defined Contribution — The annual amount contributed to this account as specified on the Accounts & Taxes page.
• Contributions from Employer — Amount matched / contributed by your employer (only visible for Retirement Accounts such as 401k/403b/TSP).
• RMD — The annual 'Required Minimum Distribution' taken from this account and deposited in the 'Default Account'.
• Gains for Year — The annual growth of this account.
• Total Tax-Deferred — The total amount subject to tax over the entire modeling period.
• Drawdown Withdrawal — The annual withdrawals from this account resulting from negative cash flows (i.e. the shortage of funds that must be accounted for whenever current expenses exceed current income) that could not be covered by another account with a higher withdrawal priority.
• Rollover withdrawal — The annual withdrawals from this account associated with scheduled rollovers of funds to another account (note: a rollover occurs when the End Age of an account is reached).
• Early Withdrawal — The annual amount of any scheduled or unscheduled withdrawals from this account prior to the account owner reaching age 60.
• Early Withdrawal Penalty — The 10% tax penalty applied to any early withdrawals from this account.
• Taxes on Tax-Defered Withdrawals — The taxes resulting from withdrawals from this account.
• Remaining Principal — Displayed only for Home Equity accounts, this column shows the principal remaining on the loan (if one exists).
• Inflation Devaluation — This term applies whenever the data is shown in today’s dollars and is the effective loss of purchasing power of the dollars in this account due to inflation.
• Balance (Start of Year) — The account balance at the start of the associated year.
• Balance (End of Year) — The account balance at the end of the associated year.

Annually-Taxed Accounts

This is any account with an Investment Tax 'Type' of Tax-Annual. Typically, these are accounts like Checking, Savings, or even Brokerage accounts depending on trading frequency. The following columns are shown for these types of accounts:

• Age — Your age in the corresponding year.
• Year — The year corresponding to each row in the table.
• Defined Contribution — The annual amount contributed to this account as specified on the Accounts & Taxes page.
• Gains for Year — The annual growth of this account.
• Annually-Taxed Amount — The amount that is taxed at the Annual (short-term) Rate. Calculated using Dividend Yield, if defined for the account.
• Annual Taxes — Taxes on the Annually-Taxed Amount.
• Total Tax-Deferred — The total amount subject gains-tax over the entire modeling period (up to that year). This amount includes both gains that were tax-deferred, as well as gains based on Cost Basis, if it was entered.
• Drawdown Withdrawal — The annual withdrawals from this account resulting from negative cash flows (i.e. the shortage of funds that must be accounted for whenever current expenses exceed current income) that could not be covered by another account with a higher withdrawal priority.
• Rollover withdrawal — The annual withdrawals from this account associated with scheduled rollovers of funds to another account (note: a rollover occurs when the End Age of an account is reached).
• Taxes on Tax-Defered Withdrawals — The taxes resulting from withdrawals from this account.
• Inflation Devaluation — This term applies whenever the data is shown in today’s dollars and is the effective loss of purchasing power of the dollars in this account due to inflation.
• Balance (Start of Year) — The account balance at the start of the associated year.
• Balance (End of Year) — The account balance at the end of the associated year.

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 — The age of the Account ownder in the corresponding year.
• Year — The year corresponding to each row in the table.
• Account — The name of the Account funds were drawn from.
• Amount — The amount of the drawdown.
• Purpose — Whether the drawdown was to cover negative Cashflow in a given year, or for the purposes of making a defined Contribution to another account.
• Criteria Met — Automatic drawdowns are made based on the order defined under Menu / Settings / Calculation Options in the section "Drawdown Preferences". This value reflects the matching preference criteria when the funds were drawn. The only exception to this is if you have defined a Negative Contribution for a given year — in that case "Negative Contribution" appears.

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:

• Age — Your age in the corresponding year.
• Year — The year corresponding to each row in the table.
• Gross (pre-tax) Total Income — The pre-tax total of all income streams.
• Other Contributions — Contributions that are not "funded" from either Income or from another account. For example, Employer Contributions, Starting Balances of accounts that do not begin in year-1 or your Trajectory, additional contributions to a home equity account, or contributions to an any account designated as "unfunded" on its properties tab.
• Taxes on Income — Total taxes on income.
• Taxes Credits — If you have made an pre-tax contributions, a credit is added based on the Income Tax Rate for the year.
• RMDs — Total RMDs from applicable tax-deferred accounts (not used to calculate the Total for the year since those funds are simply "transferred" to the Default Account).
• Taxes on RMDs — The taxes on the gross RMD amount.
• Taxes on Tax-Deferred Withdrawals — Total taxes on withdrawals from tax-deferred accounts (includes any Early Withdrawal Penalties).
• Gains — The annual growth of all accounts.
• Taxes on Annual Gains — The annual taxes on the growth of taxable accounts.
• Expenses — Total expenses (excluding taxes).
• Income Tax Rate — The tax rate used to determine taxes on income and annual (short-term) gains.
• Gains Tax Rate — The tax rate used to determine taxes on tax-deferred (long-term) gains.
• Cashflow — The difference between annual post-tax income and annual expenses (not used to calculate the Total since it is accounted for in the Income and Expense columns). NOTE: If "Debt Reduction" is enabled, cashflow is decreased because debt reductions are considered Expenses.
• Funded Contributions — The amount of defined contributions that were actually made into your accounts (not used to calculate the Total shown only for informational purposes).
• Inflation Devaluation — This term applies whenever the data is shown in today’s dollars and is the effective loss of purchasing power of the dollars in this account due to inflation.
• Total Debt — The total amount of Debt from both Expense or Account (Home Equity) items.
• Total — The account balance at the end of the year. All columns except RMDs, Funded Contributions, and Cashflow are used to calculate the Total. The following math is performed for each year:

5. Metrics for Year