guys, am thinking of taking the next step.

kindly advise if i have left out anything?

assuming if there are flaws or things i left out in the calculation please highlight.

ideally of course hoping that current savings are sufficient to cover and be in self sustaining mode, but of course if inflation rises, can always start "eating" into the current savings.

if anybody is able to help to improve the spreadsheet to say:
inflation rate at 3% to 5%, what would be the current required savings (both basic and upgrade version) value to cover the increase year on year for me to say live another 35 years.
alternatively same scenario applies but without self sustaining model but depreciating savings model.

thanks.

PS: any advise on what to do post retirement? i am currently in mid 40's

Implicit in your pdf example is that the return on capital (4%) is real rate of return.
Ie, what you are targeting is to have your portfolio earn a nominal return of of around 7% (= 4% real return + 3% inflation), if you are assuming inflation moving forward is 3%. If not, the npv of your portfolio will erode as time passes.

if you assume 5% inflation, then you are basically saying your portfolio needs to earn nominal return of 9%.

I think you now realize that 4% nominal return is not sufficient... need to take riskier investments.

To have a depreciating assets as time passes is harder to example, but would be easier to visualize using a excel spreadsheet. It is similar to calculating mortgage payment of each month and where the payment goes to: reducing outstanding balance or interest payment.

yes i forgotten to factor in ang pow and phone/pc replacement say once every 3-5 years.
fyi i got my ip7 from launch and still using it although i think it's time for a change.

travelling is meant for local travel and the "upgrade" which has a factor of RM6k per annum allows me to travel yearly somewhere below that threshold or travel somewhere <rm12k every 2 years. does that make sense?

and forgot to mention, everything is based on individual for the time being.
as the saying goes, help yourself before helping others.

if basic

1.7million x 1.03^35 = 4.78million

upgrade version roughly 6.2million

in chinese vocab, there is not really hav retirement. 

ur spreadsheet shows u hav balance distribution of money across all expenditure categories for an individual.

I haven't take a look at excel but if you got 5%p.a dividend and it's growing say 5-6%p a you should be able to live off to infinity even with inflation at 4%p.a

If you wan to make sure your investment can outlive you. You might want to take a look at safe withdrawal rates by kyith from investmentmoats (warning wall of text) but you might find gems in there.

What to do in retirement
1. Travel with your spouse 1 country per year
2. Be there for your kids when they need you
3. Gardening , build your own mini farm and get vegetables from there. This will usually take up half a day
4. Volunteer at soup kitchen, animal shelters
5. Join those uncle and aunties for taichi every morning
6. Read books
7. Play computer games like Skyrim, red dead redemption, elden ring, fallout.

Instead of intricate budgeting, why not do a simple one. Tally all your credit cards monthly spending and all your cash withdrawal yearly, divide by 12 to get monthly average. There you will have your required monthly and yearly expenditure , which then you can calculate your requirements for retirement.

yes, the inflation concern is on spending. Nonetheless, it is your assets/portfolio that is funding your spending. So to simplify the calculation, we either calculate everything in nominal terms or in inflation-adjusted terms.
(if you calculate your portfolio in nominal while spending in inflation-adjusted, your excel spreadsheet will get trickier.)

btw, the actual formula to adjust between nominal and inflation adjusted is (1+nominal) = (1+real) * (1+inflation).
I would hazard to guess that what you are trying to do in your formula a% + (b% * c%) is to say a is real return and b is spending and c is inflation, but summing them up doesn't mean anything as they are not of the same unit measurement. a relates to portfolio and b relates to spending.

Like what others say, there should be a misc item where you just throw some buffer in for spending. Sort of like emergency spending money, to account of error in planning.

this FI/RE thingy is new concept ? never heard of it until now. if retire early then do what?

So many things to do leh. Imagine waking up without alarm clock, go for morning jog or taichi, then only go to work. Work also until you want then just leave early. No need to bring work back to house.

I concur, some really just love the stress and politics in a corporate career.

But then again not all who are capable want to climb up the corporate ladder. Some just want peace in life. Some just want to spend more time on their family and hobbies.

If you look at his spreadsheet,  its fantasy wheras my way is reality.

Its not difficult with online banking to download monthly statements of credit cards and savings account. Been doing that as retired early for many years now. I also did a quarterly review so that can keep track.

Their biggest fallacy is the spend as much as they earn putting themselves in perpetual debt.

but the real question is what is the cutoff to be T10 and is that number really enough to survive for 20 years?

here many already saying 2 million ringgit is not enough to retire... so I guess T10 is destined not to retire also.

Actually I quit my job too. Told my boss to f**k off. He said you don't need the money meh? I told him if I need the money I would be working. I am resigning right? He got a shocked and keep quiet.

My passive income have more or less match my active income so I took the leap of faith. But I will still be working free lance.

Cannot tahan the horrible office politics in this Chinaman company.

Will be experiencing what is lean FIRE is like. Lol.

In Oz u will face less racial bias if u r a professional like engineer, doctor, architect, programmer, STEM jobs that the whites shun. What is your daughter's occupation?

And here I am I thought Australia is an ok country.
Was planning to take exams and go to Australia.

Updated above...but I guess RM2.5k per pax is a safe calculation.

And I am totally debt free (when I choose to retired, I cleared all my debts).

wow, how old are you?

you got guts! 

Yup that's right. Ok la. My profit for past 6 months have been hovering in the range of USD300-400/week.