Spreadsheet: 102538d1300462504-circular-reference-help-reference-ex
Sheet: Model T

 |  | Current Age | 65
 |  | Optimal Age | 65 |  |  |  |  |  |  |  |  |  |  |  |  | Longevity Risk Aversion
 |  | C knot | -78000 |  | v.A | 0.05 |  |  |  | v.B | 0.05 |  |  |  | [NAME] | 1
 |  |  |  |  | A: RRSP | A: Tax-sheltered | Withdrawal | A: RRSP |  | B: Taxable | B: Taxable | Pension | RRSP | Taxable | Income Taxes | Discretionary | B: Taxable
 | (tpx) | Age | 1/E.t |  | Account (BoY) | Gains (EoY) | from RRSP | Account (EoY) |  | Account (BoY) | Gains (EoY) | Income (EoY) | Income (EoY) | Income (I) | Paid (EoY) | Consumption (EoY) | Account (EoY) |  | Taxable w/draw | Extra w/Drawal RRSP
 | 1 |  | 0.04730116587530097 |  | 500000 |  |  |  |  | 500000 |  | 0
 | 0.991469081361919 |  | 0.04921584025614988 |  |  |  |  |  |  |  |  | 0
 | 0.9820765212321203 |  | 0.05126067817171921 |  |  |  |  |  |  |  |  | 0
 | 0.9717456655374545 |  | 0.0534469929211349 |  |  |  |  |  |  |  |  | 0
 | 0.9603954434519649 |  | 0.05578723742969534 |  |  |  |  |  |  |  |  | 0
 | 0.9479407100838915 |  | 0.05829513063507896 |  |  |  |  |  |  |  |  | 0
 | 0.9342927791398998 |  | 0.06098579873381226 |  |  |  |  |  |  |  |  | 0
 | 0.919360187937573 |  | 0.06387593307362883 |  |  |  |  |  |  |  |  | 0
 | 0.9030497423540658 |  | 0.06698396668713177 |  |  |  |  |  |  |  |  | 0
 | 0.8852678939523007 |  | 0.07033027169458501 |  |  |  |  |  |  |  |  | 0
 | 0.8659225049976956 |  | 0.07393738006061365 |  |  |  |  |  |  |  |  | 0
 | 0.8449250585208007 |  | 0.07783023047325335 |  |  |  |  |  |  |  |  | 0
 | 0.8221933688738486 |  | 0.08203644442630177 |  |  |  |  |  |  |  |  | 0
 | 0.7976548419409624 |  | 0.08658663492964751 |  |  |  |  |  |  |  |  | 0
 | 0.7712503215316098 |  | 0.09151475164965618 |  |  |  |  |  |  |  |  | 0
 | 0.742938537439579 |  | 0.09685846669540911 |  |  |  |  |  |  |  |  | 0
 | 0.7127011388701279 |  | 0.1026596057194876 |  |  |  |  |  |  |  |  | 0
 | 0.6805482520357408 |  | 0.10896462949725 |  |  |  |  |  |  |  |  | 0
 | 0.6465244405249763 |  | 0.1158251716896179 |  |  |  |  |  |  |  |  | 0
 | 0.610714870074372 |  | 0.1232986390853866 |  |  |  |  |  |  |  |  | 0
 | 0.5732513855030066 |  | 0.1314488812645583 |  |  |  |  |  |  |  |  | 0
 | 0.5343180989729628 |  | 0.140346937329774 |  |  |  |  |  |  |  |  | 0
 | 0.4941559710182637 |  | 0.150071868125044 |  |  |  |  |  |  |  |  | 0
 | 0.4530657492576477 |  | 0.1607116832076623 |  |  |  |  |  |  |  |  | 0
 | 0.4114085306325816 |  | 0.1723643727697642 |  |  |  |  |  |  |  |  | 0
 | 0.3696031544015297 |  | 0.1851390557321018 |  |  |  |  |  |  |  |  | 0
 | 0.3281196445728514 |  | 0.1991572563676595 |  |  |  |  |  |  |  |  | 0
 | 0.2874680362745496 |  | 0.2145543230732189 |  |  |  |  |  |  |  |  | 0
 | 0.2481821752819974 |  | 0.2314810043115891 |  |  |  |  |  |  |  |  | 0
 | 0.2107985005324969 |  | 0.2501051983182723 |  |  |  |  |  |  |  |  | 0
 | 0.1758304139625905 |  | 0.2706138949286141 |  |  |  |  |  |  |  |  | 0
 | 0.1437395853154228 |  | 0.2932153298634868 |  |  |  |  |  |  |  |  | 0
 | 0.1149063592330417 |  | 0.3181413740441911 |  |  |  |  |  |  |  |  | 0
 | 0.08960219883468337 |  | 0.3456501830247499 |  |  |  |  |  |  |  |  | 0
 | 0.06796763109641098 |  | 0.3760291344682013 |  |  |  |  |  |  |  |  | 0
 | 0.04999924097630781 |  | 0.4095980847917126 |  |  |  |  |  |  |  |  | 0
 | 0.03554869801311263 |  | 0.4467129797032059 |  |  |  |  |  |  |  |  | 0
 | 0.02433548707099998 |  | 0.4877698573918487 |  |  |  |  |  |  |  |  | 0
 | 0.01597302299926921 |  | 0.533209287659236 |  |  |  |  |  |  |  |  | 0
 | 0.01000545811858437 |  | 0.5835212953325282 |  |  |  |  |  |  |  |  | 0
 | 0.005950268687477687 |  | 0.639250821932531 |  |  |  |  |  |  |  |  | 0
 | 0.003340279184317179 |  | 0.7010037858291203 |  |  |  |  |  |  |  |  | 0
 | 0.001758711271481527 |  | 0.7694538080588736 |  |  |  |  |  |  |  |  | 0
 | 0.000862347314001289 |  | 0.84534967866626 |  |  |  |  |  |  |  |  | 0
 | 0.0003906727358319317 |  | 0.9295236469300405 |  |  |  |  |  |  |  |  | 0
 | 0.0001620964523760939 |  | 1.022900628229587 |  |  |  |  |  |  |  |  | 0
 | 6.099951720428275e-05 |  | 1.126508430683656 |  |  |  |  |  |  |  |  | 0
 | 2.059512383065763e-05 |  | 1.24148911616187 |  |  |  |  |  |  |  |  | 0
 | 6.163929312156293e-06 |  | 1.369111622947908 |  |  |  |  |  |  |  |  | 0
 | 1.613599314297074e-06 |  | 1.510785791361314 |  |  |  |  |  |  |  |  | 0
 | 3.640182550280062e-07 |  | 1.668077949176924 |  |  |  |  |  |  |  |  | 0