Super DIY Calculator (Assessment)(Spouse)
// Notes //
Logic Testing on Projected Balance on Retirement Age and Preservation Age.
Tested our calculations using Excel, and AI calculations:
- Using yearly method: no margin of error. Both reports calculated at 621K for retirement age, and 793K for preservation age using CAGR. We’ve calculated separating by individual net contributions and existing balance annually for transparency purposes.
- Using monthly method: margin of error is < 2%. Excel calculated at 629K [1.3%] for retirement age, and 807K [1.7%] for preservation age.
- Margin of errors < 2% with a projection of 16 years is an acceptable range as monthly calculations can be skewed due to the timing of salary sacrifice contributions when annualizing the market return rate monthly.
- For simplicity, we didn’t factor in super tax on investment earnings.
// Source //
Super DIY Calculator (Assessment)(Spouse)
// Calculations Validation //
Super DIY Calculator (Assessment)(Spouse)(AI Calculations) [AI]
