Export Column Reference

Export your results as Excel or CSV to inspect the values behind a calculation. Excel has three sheets, in this order: Results, Simulation Summary, and Summary. CSV contains the same tables, with the calculation URL at the top and the summaries in labeled sections after the annual results.

Units and Timing

Nominal, Dollars in That Year means the dollar amount in the simulated year.
Inflation-Adjusted, First-Year Dollars or First-Year Dollars means the amount expressed in the purchasing power of the first retirement year.
Fraction means a decimal rate or allocation: 0.05 means 5%. Configuration percentages use percent units instead: 5 means 5%.
Multiplier means a ratio: cumulative inflation of 1.10 means prices are 10% higher than at the start of retirement.
Income and spending occur at the start of each year. Start balances use start-of-year inflation; end balances use end-of-year inflation.
Dollar amounts are rounded to cents; result rates and allocations are rounded to eight decimal places. Blank cells mean a value is unavailable or does not apply, rather than zero.

Results

Each row represents one year of one simulation. The fixed columns below total 79: 40 identify the year and describe portfolio, spending, and market results; 39 describe stocks, bonds, and cash. Configured income and extra withdrawals add two columns per source.

Simulation and Year

Row ID: simulation number and retirement year joined by a period, such as 1.3 for simulation 1, year 3.
Simulation Number: the simulation's identifier, starting at 1 and shared with its individual export and summary row.
Year Number: position in retirement, starting at 1.
Start Year: first calendar year of the simulation.
End Year: last calendar year of the simulation.
Current Year: calendar year represented by this row.

Portfolio and Spending

The names below cover both nominal and inflation-adjusted columns when both are present. Base Withdrawal Amount and Additional Withdrawal Amount without a dollar-basis suffix are nominal amounts.

Start Portfolio Value: total portfolio balance before the year's income and spending.
End Portfolio Value: total portfolio balance after spending, investment growth, fees, and rebalancing.
Total Available Spending: funded base and extra spending, including the portion paid by income; capped by available funds.
Base Withdrawal Amount: funded spending from the withdrawal strategy, before deducting income; capped by available funds.
Additional Withdrawal Amount: funded extra spending beyond the base amount; capped by remaining available funds.
Additional Income: total income from active configured sources that year, with each source's inflation settings applied.
Actual Portfolio Withdrawal: money taken from investments after income offsets spending; never negative.
Income Added to Portfolio: income left over after spending and deposited into investments.
Portfolio Value After Spending: nominal portfolio balance after withdrawals or income deposits, before investment growth and fees.
Portfolio Investment Return: total investment gain or loss in nominal dollars, after fees; excludes withdrawals, income deposits, and rebalancing transfers.

For example, funded spending of $40,000 with $10,000 of income produces an Actual Portfolio Withdrawal of $30,000. The Base Withdrawal Amount still describes the funded spending, rather than the amount taken from investments.

Outcomes

Is Out of Money?: true when the portfolio is depleted after that year's spending.
Unable to Fund Requested Spending?: true when the year's available funds cannot cover all requested base and extra spending.
Simulation Successful?: true when requested spending was funded in every year; this simulation-wide result is repeated on each annual row.
Simulation Complete?: true when the simulation covers the full requested retirement duration; repeated on each annual row.

Portfolio depletion and spending failure are separate outcomes: income can fund spending even when the portfolio is empty.

Inflation

Cumulative Inflation: start-of-year CPI divided by CPI at the start of retirement; an inflation multiplier.
End-of-Year Cumulative Inflation: end-of-year CPI divided by CPI at the start of retirement; an inflation multiplier.
Start CPI: Consumer Price Index at the beginning of the year.
End CPI: Consumer Price Index at the end of the year.
Annual Inflation Rate (Fraction): change in CPI during the year; 0.03 means 3% inflation.

Market Data

Stocks Total Return (Nominal, Fraction): annual stock return including price changes and dividends, before fees and inflation adjustment.
Stocks Total Return (Real, Fraction): annual stock total return adjusted for inflation, before fees.
Bonds Total Return (Nominal, Fraction): annual bond total return before fees and inflation adjustment.
Bonds Total Return (Real, Fraction): annual bond total return adjusted for inflation, before fees.
Stocks Price Growth (Fraction): annual stock price change, excluding dividends.
Stocks Dividend Yield (Fraction): annual dividend return from the stock market data.
CAPE: cyclically adjusted price-to-earnings ratio for that year; blank when unavailable.

Stocks, Bonds, and Cash

These 13 fields appear with each of the prefixes Stocks, Bonds, and Cash, for 39 columns in total. Dollar amounts are nominal unless labeled First-Year Dollars.

Start Value: the asset's opening balance.
Start Value (First-Year Dollars): opening balance adjusted for inflation.
Start Allocation (Fraction): share of the opening portfolio held in the asset; 0.80 means 80%.
Value After Spending: balance after the asset's proportional share of withdrawals or surplus income deposits, before growth.
Fees: dollar amount charged in investment fees, calculated after growth.
Separately Recorded Dividends: currently zero; stock dividends are already included in growth and are not recorded as a separate payment.
Growth Including Dividends: investment gain or loss in dollars before fees; includes dividends for stocks and configured growth for cash.
Rebalance Transfer: dollars moved into the asset (positive) or out of it (negative) by end-of-year rebalancing; zero when no rebalancing occurs.
End Value: closing balance after growth, fees, and rebalancing.
End Value (First-Year Dollars): closing balance adjusted for inflation.
End Allocation (Fraction): share of the closing portfolio held in the asset.
Value After Growth, Before Fees: Value After Spending plus Growth Including Dividends, before fees and rebalancing.
Investment Return: gain or loss in dollars after fees, before rebalancing; equals Growth Including Dividends minus Fees.

Income and Extra Withdrawal Sources

Each source has a nominal and an inflation-adjusted column. The source number follows its order in the configuration, so identically named sources remain distinct.

Income 1: [name], Income 2: [name], and so on: income from that source in this year, with its timing and inflation settings applied.
Requested Extra Withdrawal 1: [name], and so on: requested extra spending from that source. These amounts may exceed funded Additional Withdrawal Amount when available funds are insufficient.

Disabled sources, zero-duration sources, and sources outside their scheduled years show zero.

Simulation Summary

Each row summarizes one exported simulation.

Simulation Number: identifier matching Results.
Start Year: first calendar year of the simulation.
End Year: last calendar year of the simulation.
Duration (Years): requested retirement length.
Complete?: true when the full retirement duration was simulated.
Successful?: true when requested spending was funded in every year.
Ran Out of Money?: true when the portfolio was depleted after spending in any year.
First Year Out of Money (One-Based): first retirement year of portfolio depletion; blank if the portfolio was never depleted.
Unable to Sustain Spending?: true when requested spending could not be funded in at least one year.
First Year Spending Not Sustained (One-Based): first retirement year with unfunded requested spending; blank when all spending was funded.
Years With Money: years before the first portfolio depletion, or the full duration if the portfolio was never depleted.
Years Spending Sustained: full duration on success; otherwise the first unfunded retirement year number, including that year.
Initial Portfolio (Nominal Dollars): opening portfolio balance.
Final Portfolio (Nominal Dollars): closing portfolio balance.
Final Portfolio (First-Year Dollars): closing balance adjusted for inflation over the retirement.
Total Inflation (Multiplier): final CPI divided by CPI at the start of retirement.
Lifetime Spending (First-Year Dollars): sum of annual funded spending, with each year adjusted for inflation.
Lifetime Income (First-Year Dollars): sum of annual income, with each year adjusted for inflation.
Lifetime Portfolio Withdrawals (First-Year Dollars): sum of annual actual investment withdrawals, with each year adjusted for inflation.

Summary

Metric: name of the count, rate, definition, or distribution statistic.
Value: its numeric result or explanatory text.

Exported Simulations counts the simulations included in the file. Successful Simulations and Failed Simulations count whether all requested spending was funded. Success Rate (Fraction) is the successful count divided by the exported count. Success Definition states the spending-based success rule.

The remaining metrics summarize Final Portfolio, Lifetime Spending, and Annual Spending in first-year dollars. Final Portfolio and Lifetime Spending use one value per simulation. Annual Spending, All Simulated Years pools every annual row, including zero-spending years.

For each group, Minimum and Maximum are the extremes; 10th Percentile, Median, and 90th Percentile describe the distribution; Average is the arithmetic mean; and Standard Deviation measures its spread. Standard Deviation is blank for a single simulation. An individual simulation export summarizes only that simulation.