QUOTE(kochin @ May 17 2023, 08:59 AM)
thanks for your reply. in all honesty i find the reported inflation rate on yearly basis a bit unpredictable and rather hard to gauge. furthermore some items goes down too instead of up albeit more on increase rather than decrease though. but i understand your point.
but to argue further, it should be inflation rate on the spending rather than an outright 7-9% return on savings. so it should be 4% + (4% * 4%) = 4.16% the following year and continue on subsequently, no?
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?
paid off props - yes
stocks with divvy yield - yes
but not intending to muzzle the already complicated calculation hence only concentrating on return from cash instead.
and forgot to mention, everything is based on individual for the time being.
as the saying goes, help yourself before helping others.
yup. with the slightly higher opr, FD rates are going back to 4% ish and EPF is 5% ish or more.
am taking 4% just to be prudent without taking into account other riskier return which carries some risk of decreasing my capital
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.