Begin with essential spending and actual policy terms where known. This worksheet organizes conditional cash flow; it does not predict disability, approval, tax eligibility or insurance prices.
A benefit rate is different from a payment timeline
A monthly contract rate describes what the policy might pay under the entered assumptions. It does not mean that income is available during elimination, payment lag or after the contract ends. Start with essential monthly expenses, then enter a known monthly benefit or choose a percentage of annual income. The optional cap limits that contract rate before the monthly ledger prorates active payments. Fixed 12-,24- and 60-month terms begin after elimination plus payment lag. The age-65 option instead ends at the modeled age endpoint measured from onset.
The timeline uses equal 30-day months. An optional onset date labels those intervals, including boundaries that differ from calendar month ends. It does not estimate daily accrual or an insurer decision date. Selecting a month inspects its actual row without changing the policy. Automatic inspection chooses the first full month after the latest relevant private or assumed SSDI start. That can be a period after private coverage has already ended; the receipt names the phase so an apparently adequate combined benefit cannot hide earlier or later gaps.
Offsets, funding and taxes remain distinct assumptions
SSDI is not inferred from salary or occupation. Enter an amount only as a scenario assumption and choose its first modeled payment month; earlier rows retain zero SSDI. A selected dollar-for-dollar offset reduces private benefits for SSDI paid in the same month, limited to the contract monthly rate. For a partial private-payment month, this offset is prorated to the same active fraction. The model then applies the entered private tax percentage and a separate SSDI tax percentage. Other net income is added once, after those separate calculations.
Record who paid premiums and whether they were funded before or after tax. IRS guidance distinguishes funding arrangements, so group or individual coverage alone cannot determine the tax result. These choices provide review context and do not automatically replace the entered tax rates. Actual contracts may contain minimum benefit floors, exclusions, retroactive adjustments and other offsets that are not modeled here. Use official SSA information and the IRS reference alongside the policy and your own circumstances. No health history, employer identity, medical record or personal disability probability is requested or inferred.
Compare the same household and preserve a useful receipt
Compare actual policy terms while holding essential expenses, other income, assumed SSDI, starting reserve and the inspected month fixed. Alternative elimination periods keep the separately entered payment lag unchanged. A common projection horizon makes total private payouts comparable, although the inspected month may fall in different policy phases. The cash bridge reports need before private payments begin. It is separate from starting reserve, reserve withdrawals and the unfunded gap. Reserves pay positive gaps until exhausted and are not replenished from modeled surpluses.
Premium information stays secondary. A known entered premium is not deducted again from the ledger; include ongoing premiums in essential expenses when appropriate. The optional inherited premium formula is explicitly unverified and is not a quote or recommendation. Save on this device only when you choose to do so. A default shared link contains no financial amounts; review any values before including them. CSV contains every raw monthly component and all entered assumptions, while displayed currency rounds separately. Copy and paper provide readable context, and the complete monthly table preserves the actual cash path rather than substituting a single steady-state amount.