Interesting stuff - stress testing Asset Allocation (a variety of sub-methodologies)
https://www.dropbox.com/s/ep841u04ks0lri9/s...est_taa_v01.pdf

just confirmed,...i can access.

Yup, can but check formulas yar. can run
[attachmentid=4191376]

Did U log in with your Google a/c?
If U did and U already "made a copy", that copy is your private Google Sheet already.

er.. if U've no Google a/c.. heheh- sorry ar, can't "make copy" coz make copy to where?

Of course, I knew that, how silly of me

---
BTW, hint hint (and real life):
Try placing in cell G14:
Net Salary * 1/3 *12 (ie. U save 1/3 of your net salary - may be tough but do-able)  +Net Bonus *1/3 (ie. U save 1/3 of your bonus - do-able)
VS
Net Salary * 5% *12 (ie. U save 1/3 of your net salary - may be tough but do-able)  +Net Bonus *1/3 (ie. U save 1/3 of your bonus - do-able)
VS
Net Salary * 10% *12 (ie. U save 1/3 of your net salary - may be tough but do-able)  +Net Bonus *1/3 (ie. U save 1/3 of your bonus - do-able)

See the column D when turn red - which year for all 3.
Notice a big enough difference even with 10% vs 5%?
This shows that DEFENCE is very important as well (keeping $), not just making $ (returns pa%)
With this, U can literally see the future visually (RED = must die liao, no $)

Hope to quit my job so that I can manage/grow my portfolio in the next couple of years. So no more fixed income
---
Other than that, one can also use the sheet to ascertain how much death insurance required.
Eg. i change the retirement year to 1 or 2 from now, simulating my death thus no more income and need to eat into cash investments' returns.
Also no more savings

Then scroll down lor to see how long family can live off current VS what i want/thought.
See the variance if any, and i can agak agak how much more death insurance i need.
Just a thought 

Interesting to see the differences when I make changes to cost/year or ROI or Child's UNI cost. TYVM.

Any chance that u are going to become a Professional Financial Planner?

No sifu here Sir/Ma'am, i'm just another worrier and problem solver 

Thank U for your feedback.
Makes it worthwhile for me.

As an evolving work - i've again UPDATED the GOOGLE SHEET:
Added sheets to ascertain our total portfolio's returns based on our asset allocation + track investments'/trades' net profits/losses
Sheets named "Asset Allocation Planning" & "Investment / Trade Tracking" (being captain obvious )
Sample data provided for easier visualization & understanding

Again, please play with the YELLOW cells' variables

Clarification:
U are looking to find "Present Value" of Column D's future portfolio? ie Column D, Row 14, 15, etc?

Simple, look at the row, say 16.
Year = say 2016
Current year = say 2014
D16 = $100,000
Inflation assumed = 4%pa

Present value = $100,000 * (1 +4%pa inflation) ^(2014-2016)
or Future Value *(1 + Inflation %pa) ^(years to regress inflation)

OR U can copy below into C16 
=D16 *(1+$G$5)^($G$1-B16)

After that U can just copy C16 to any C14 to Cwhatever (yellow cells in Column C) to see the Present Value

Hope that helps