Simulation Parameter Reference

Parameter NameLocationParameter ModeDescription
Parameter ModeSetupN/ABasic or advanced parameter mode for the simulation.
Current DateMain/SetupBasicCurrent date in the simulation. This can be "fast forwarded" to a date in the future. Run Setup to configure.
Retirement DateMain/DashboardBasicCurrently selected retirement date used by the simulation. This can be in the past or future.
Default Wage InflationMainBasicDefault wage inflation rate used for Social Security wage indexing and employer income extrapolation. This can be overridden for specific years in the Economy sheet (Advanced).
Default Consumer Price InflationMainBasicDefault consumer price inflation rate used for real to nominal dollar conversion. This can be overridden for specific years in the Economy sheet (Advanced).
Default Annual Return on StocksMainBasicDefault rate of return on stocks. This can be overridden for specific years in the Economy sheet (Advanced).
Default Bond YieldMainBasicDefault yield on bonds. This can be overridden for specific years in the Economy sheet (Advanced).
Investment StrategyMainBasicThe investment strategy employed by all accounts in the Portfolio.
Marital StatusMain/SetupBasicMarital status. Run Setup to configure.
Filing StatusMain/SetupBasicTax filing status. Run Setup to configure.
InitialsMain/SetupBasicInitials used to identify and filter on yourself and your spouse in the worksheet.
Core Account BalanceMainBasicThis is the core account for all non-retirement funds. Excess income beyond expenses are deposited in this account.
Core Account Cost BasisMainBasicCore account cost basis. The balance above this portion is subject to income tax.
Other Appreciating AssetsMainAdvancedAdditional appreciating assets to be added to your Net Worth calculation.
Additional Retirement IncomeMainBasicNon-taxable annual income with a payment schedule that begins at your SSRIB Primary Benefits Filing Age. It adjusts for inflation up to that date but not beyond. This can be used to simulate annuity income.
State, Local, and Foreign Income Taxes MainBasicState/local/foreign tax approximation (presently only state tax supported). This setting can affect whether Social Security benefits are taxed.
Annuity Payment TermsMainAdvancedLife or Period Certain. The annuity is a deferred income annuity until the Retirement Date is reached, at which point the annuitization phase begins.
Annuity Payment Rate
MainAdvancedFixed, Variable, or Indexed. The fixed rate annuity balance can increase or decrease inversely to bond yields, where the variable rate annuity balance does not. The indexed annuity is tied to Annual Return Stocks instead of Bond Yield to determine the Assumed Interest Rate.
Annuity Inflation Adjusted
MainAdvancedSet to TRUE to lower the payments towards the start of the annuitization phase to adjust for inflation.
Annuity Participation Rate
MainAdvancedThe participation rate in the underlying index.
Annuity Rate CeilingMainAdvancedThe upper limit on the Assumed Interest Rate.
Annuity Rate FloorMainAdvancedThe lower limit on the Assumed Interest Rate. No fees are collected once this limit is reached.
Annuity Spread FeeMainAdvancedAll annuity fees are modeled as a simple percentage which is subtracted from the underlying index to determine the Assumed Interest Rate.
Annuity Survivor Benefit
MainAdvancedSet to TRUE to include the spouse (joint and survivor annuity).
Annuity Guaranteed Term

MainAdvancedThe guaranteed term of the annuity, required for a period certain annuity. A life annuity can optionally have a guaranteed term as well.
Annuity After Tax Contribution
MainBasicContribution to annuity balance in after-tax dollars as a flat annual amount which is adjusted for inflation.
Annuity BalanceMainBasicPresent value of the annuity.
Annuity Cost Basis
MainBasicCost basis of the annuity. This determines the taxable portion of annuity payments.
Debt LimitMainBasicDebt limit. Debt above this limit in a given year results in insolvency for that year.
Current DebtMainBasicCurrent debt on the Current Date.
Interest RateMainBasicInterest rate on debt.
Birth DateMain/SetupBasicBirth date. Run Setup to configure.
Start Work AgeMain/SetupBasicAge used to calculate past years in the workforce for Social Security purposes. Run Setup to configure.
Life ExpectancyMain/SetupBasicLife expectancy, which controls number of future years displayed in the simulation. Run Setup to configure.
DependentsMainBasicNumber of dependents for tax purposes.
Default Annual IncreaseMainBasicAmount to add or subtract from Default Wage Inflation or Default Consumer Price Inflation to determine personalized annual increase to income (employer, self-employment, or passive).
DB Pension Start Work DateMainAdvancedStart date at current employer to be counted towards DB pension benefit
DB Pension Final Average Earnings Years UsedMainAdvancedNumber of years included in DB pension FAE calculation
DB Pension Benefit PercentageMainAdvancedPercent of FAE included in DB pension lump sum for each year of eligibility
DB Pension Payout OptionMainAdvancedSelect a before-tax rollover to the core account (Lump Sum) or the annuity account (Annuity).
Before-Tax ContributionMainBasicContribution to retirement account in before-tax dollars, either by percentage of income (employer or self-employment) or flat annual amount (adjusted for inflation).
Before-Tax BalanceMainBasicBalance in retirement account of before-tax dollars on the Current Date
Company MatchMainBasicCompany match to retirement account in before-tax dollars as a percentage of income (employer or self-employment).
After-Tax ContributionMainBasicContribution to retirement account in after-tax dollars, either by percentage of income (employer or self-employment) or flat annual amount.
After-Tax BalanceMainBasicBalance in retirement account of after-tax dollars on the Current Date
After-Tax Cost BasisMainBasicCost basis of retirement account of after-tax dollars on the Current Date
Qualified Distribution AgeMainAdvancedAge at which qualified distributions can be made from the retirement account.
Primary Benefits Filing AgeMainBasicAge to file for primary Social Security retirement insurance benefits.
Auxiliary Benefits Filing AgeMainBasicAge to file for auxiliary (spousal) Social Security retirement insurance benefits.
Wage InflationEconomyAdvancedOverrides the Default Wage Inflation parameter for specific years. Past inflation rates are shown for informative purposes and are based on the AWI index.
CP InflationEconomyAdvancedOverrides the Default Consumer Price Inflation parameter for specific years. Past inflation rates are shown for informative purposes and are based on the CPI-W index.
Annual Return StocksEconomyAdvancedOverrides the Default Annual Return on Stocks parameter for specific years. Past rates of return are shown for informative purposes and are based on the S&P 500.
Bond YieldEconomyAdvancedOverrides the Default Bond Yield parameter for specific years. Past rates of return are shown for informative purposes and are based on the 10-Year Treasury Note.
Employer IncomeIncomeBasicEmployer income for a full year of earnings. This amount will be prorated automatically for any transitional year. Past and future income will be extrapolated based on the personalized annual increase.
Self-Employment IncomeIncomeBasicSelf-employment income for a full year of earnings. This amount will be prorated automatically for any transitional year. Future income will be extrapolated based on the personalized Default Annual Increase.
Passive IncomeIncomeBasicPassive income for a full year of earnings. Future income will be extrapolated based on the personalized Default Annual Increase. Passive income continues past the Retirement Date.
Pre-FICA DeductionsIncomeAdvancedPre-FICA deductions.
Home ValueExpensesBasicValue of primary residence.
Origination DateExpensesBasicDate that the mortgage loan was started.
Original BalanceExpensesBasicOriginal balance of the mortgage loan.
Principal CurtailmentExpensesAdvancedAmount of mortgage loan principal that has been paid down due to extra payments as of the Current Date
TermExpensesBasicTerm of the mortgage loan.
Interest RateExpensesBasicInterest rate of the mortgage loan.
Real Estate TaxExpensesBasicProperty tax portion of mortgage payment.
Home InsuranceExpensesBasicHomeowners insurance portion of mortgage payment.
Extra PaymentExpensesAdvancedExtra payment to be applied as principal curtailment. Although entered as a monthly amount, it is summed and applied as a single lump sum at the end of the year.
HECM Origination DateExpensesAdvancedDate that the reverse mortgage loan was started.
HECM Original BalanceExpensesAdvancedOriginal balance of the reverse mortgage loan. Enter zero for a future origination date to estimate automatically and generate a lump sum distribution.
HECM Interest RateExpensesAdvancedInterest rate of the reverse mortgage loan.
Living ExpenseExpensesBasicLiving expenses applied during the Accumulation Phase and Distribution Phase.
Tax DeductibleExpensesAdvancedTax deductible status of each Living Expense. The 1 and 2 indicate the Retireatee number for tax purposes.