looks like we crossed on this post and my last response to brty about the starting wage.Thanks Craft for the numbers. I have sense checked a few key rates assumptions and I can't really flaw any of them. It doesn't mean the next 40 years will turn out the same, but it is a robust basis to believe that the assumptions aren't pies in the sky.
The only thing I have some reservations about is the capital contribution profile. The starting salary for a 23 year old appears too high, as pointed out by Brty. Note the $80k gross salary is before super which implies a total package of ~$87.5k. While ABS statistics suggests that salary income of under 24 years is a lot lower than the average. Sure the % of capital contribution profile can change accordingly but there is a limit to how much that can be done. The other thing of note is whether the numbers (given the lower income of the average 23 year old) allow for the purchase of the PPOR outside super some time down the track. Again, especially the early years when you need to save a deposit, on a lower income, while contributing to the super following this approach. Will it become unworkable?
A quick sensitivity check... if we reduce the contribution in the first 7 years (so up to age 30) by 50%, my model (which is a clone of yours) suggests that the passive income would be closer to $50k than $60k. So even allowing for this, the growth in the numbers are pretty amazing and doesn't really detract the finding of this exercise. The assumptions made are not that heroic... 4.6% inflation is not small, while 0.5% expense is probably on the high side. I didn't think it was doable because I didn't think the nominal return would be 12% (in fact 10.25% is what was used due to your conservatism) and I used a lower salary as a starting point.
Everyone is free to find their own value and utility of money. If you believe spending $2k at age 23 gives you more happiness than $15k (in real terms, not nominal terms) at age 63, then by all means spend that $2k. Just don't complain at age 63 that you wish you knew about the power of compounding over 40 years time. In actual fact, the correct comparison should be whether the happiness of spending $2k at age 23 outweighs the potential struggles you might experience at age 63 without that $15k. My guess is that, if you spent that $2k on smashed avocados at 23, but can't afford to heat your home at 63, there may be some regrets.
I agree.