Advertisement
Anonymous
It mentions that we assume the person saves 50% of the salary and take into account a 1.4% yearly inflation. But the numbers dont seem to add up - would be really helpful if anyone could clarify how the numbers in savings column were derived?
2
Discussion (2)
Learn how to style your text
Billy
Edited 22 Dec 2021
Development & Acquisitions Manager at Real Estate Private Equity
Reply
Save
Reply
Save
Write your thoughts
Related Articles
Related Posts
Related Posts
Advertisement
Hi, I managed to recreate Ming Feng's excel but only managed to get the values for the 2nd year.
β
Contrary to what YJ mentioned, there is a 4% salary increment factored in as you can see from column B (e.g. B2 to B3)
β
There is also a 1.4% inflation factored in hence if 4% = 100% of a pie, you would only be able to save 2.6% which equates to 65% of the pie (as you can see from the formula). Tried to use the same formula for the following years but there's slight mismatch in terms of figures. Can't really figure out how the following years are being derived but I believe it should be how the 1.4% is being accounted for.