formula for projecting out cash at retirement

[Tom Poje]

The following formula could be added to Part1pg (or a variety of certificates) to project out a cash at retirement.

This particular formula, since it uses '1' would be for projecting out the deferral account on that report.

It assumes the current year deferral will be constant for all future years.

This is written for 6%, easily modified for other interest rates.

You would have to add PLANEE table to make it work.

you could modify it to project out on other sources. e.g ContrForf2 would be match.

the first half of the formula uses the current year contribution. The second half is the ending balance in that source.

Round ((Sum ({@ContrForf1}, {RPTEE.SSNUM})*((1.06^{PLANEE.FUTRSVCYRS})-1)/.06

+Sum ({@EndBal1}, {RPTEE.SSNUM})*1.06^{PLANEE.FUTRSVCYRS}))