Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - erwintwr

Pages: [1] 2 3 ... 7
1
Shares / Re: My retirement blog.
« on: October 20, 2018, 02:54:47 pm »
ouch!!! that is half a bar, depending on your greatest enemy, GBP/ZAR exchange rate i assume?

2
re-looking at all these formulas really made me wonder where did i find the time :O

in the specific test data you entered, the above corrections might be more accurate, but then lots of other dependencies is affected (for example the RA tax return).
looking at it now, it is a bug, but the work required to fix it seems daunting... i might sleep on it and feel intrigued to fix it tomorrow:P

for now, think it will be safe to stick with the calculated values, and "work" one month longer eg 1 year +1 month :)

thx for testing in such detail!

A little while after I posted, I also noticed the tax return thing, so I'm glad we're on the same page there. It does look like it would be difficult to fix, and in a longer term scenario of ~25 years (which is what I'm most interested in) it will hardly matter.

After plugging in some conservative numbers, I'm feeling a lot more comfortable now about my prospects in retirement! ;D

always glad to hear :)
now just to get equities etc to start growing a bit faster :P

3
its a pleasure :) - glad it is still helping out there
you have a few really odd entries there lol.


i don't believe it is a bug, i checked through the monthly calculations and seems to match. but yes - if you manage to earn a 5 bar salary, without having anything invested then there is bigger problems afloat :P

lol yeah I don't have the "problem" of a 5 mil salary and no investments :D

Why do scenario 3 and 4 arrive at different values? With 5 mil salary, my intuition is that the 27.5% RA contribution and the R33,000 TFSA contribution will both "fit" into the salary available for investment. In both scenarios, I had thought the final number would be identical as both RA and TFSA get "saturated" by the massive salary (i.e. it doesn't matter if you go into TFSA first or RA first, as there is "plenty" of salary to go around and fill up both).

Actually, I think I might know the answer since you mentioned the monthly calculations (had a closer look at them). With scenario 3 (TFSA first) the TFSA contribution is done in the first month of each year, whereas with scenario 4 (RA first) it goes in a few months later.

Could that still be a slight error then? It seems the first month of contributions are taken into account at the end of the 1 year period (in the image). I.e. 1 year is actually considering 13 months, and therefore catches an extra 33,000 in the "RA first" scenario. In the Max TFSA then RA then equity sheet
G29=OFFSET($J$283,D3*12,0,1,1) - this should maybe be
G29=OFFSET($J$283,D3*12-1,0,1,1)

I am still wrapping my head around all this stuff. I see you have a cool optimization in that monthly section where the SARS return from RA contributions gets plugged directly back into the next year's RA – smart! I am learning a lot, thanks again! ;D


re-looking at all these formulas really made me wonder where did i find the time :O

in the specific test data you entered, the above corrections might be more accurate, but then lots of other dependencies is affected (for example the RA tax return).
looking at it now, it is a bug, but the work required to fix it seems daunting... i might sleep on it and feel intrigued to fix it tomorrow:P

for now, think it will be safe to stick with the calculated values, and "work" one month longer eg 1 year +1 month :)

thx for testing in such detail!




4
This is very cool, Erwin! Thanks a lot for providing it!

Playing around with it a bit to try and understand everything. Is it a bug that scenario 4 is sitting on 33,000 for the TFSA while scenario 1 and 3 are sitting on 66,000?

https://imgur.com/FODkoZN

its a pleasure :) - glad it is still helping out there
you have a few really odd entries there lol.


i don't believe it is a bug, i checked through the monthly calculations and seems to match. but yes - if you manage to earn a 5 bar salary, without having anything invested then there is bigger problems afloat :P

5
Shares / Re: My retirement blog.
« on: June 14, 2017, 05:01:40 pm »
Staan sterk Orca!


6
Such a fantastic tool!  Any update on this since v4.1? Holding thumbs :D

now i have a nice headache trying to figure out all my formulae of 3 years ago  - guess i was really bored then :D


updated tax tables as much as possible, but had to skip one of the "brackets" due to a new bracket introduced. shouldn't be too much of a problem though.

7
Off topic / Live chat
« on: February 20, 2017, 03:07:55 pm »
hmmm anybody able to buy AXL on investorchallenge?

8
Shares / Re: My retirement blog.
« on: November 25, 2016, 03:52:01 pm »
such a life changing event - which we dont want to wish on our worst enemies :(

strength there for you and your wife. Its better if you spend time with children/grandchildren.

9
Shares / Re: How is your portfolio doing?
« on: October 25, 2016, 09:28:02 am »
EasyEquities reports 8% move on my equities ( little bit below the 30% i was expecting over two years :?)

Best  : ADI 42.59%
worst : BAT -32.74

on the TFSA is much more quiet  2.23% over two years
best : PTXTEN 6.37%  (and that excluded DIV's :o)
worst : STXFIN -5.95%

have been a learning curve  - but not pulling out!  O:-)

10
Off topic / Re: Wanted - a detailed Retirement Calculator
« on: July 03, 2016, 06:39:48 pm »
There are many retirement calculators on the net but they all seem to be at a very high level asking the same standard few questions. I am in my early 50's and looking at retiring at 55. I met with a finance guy who typed in all my investments etc and showed me the results the program spat out. This is okay but I don't have access to his 'fancy' program and would like to in my own time manipulate values and scenarios.
I am looking for a DETAILED retirement program/system/tool where I can enter all my values for local shares, offshore funds, RA's, assets, monthly contributions,  when I want stop contributing, inflation, expected funds growth, expenses, planned holidays, buying a car in retirement ...etc etc etc.
Anything like that out there?


you can try my calculator - most results/ formulae is available throughout the workbook - so you should be able to see achievable results in 5 years.

hope it helps :)

11
Shares / Re: Biggest companies 2006 vs 2016
« on: June 13, 2016, 10:20:38 am »
although its based on profit - not sure if that alone is a good enough measure,

but the Naspers market cap blew everything else out of the water in 10 years. And that is pure investor valuation of the company....

wonder if it will every adjust to a normal PE ratio?

12
Shares / Biggest companies 2006 vs 2016
« on: June 12, 2016, 11:25:28 pm »
was quite an interesting article. thought i should share it here as well :

http://businesstech.co.za/news/business/126533/south-africas-biggest-companies-2006-vs-2016/

some of the graphs :




13
Shares / Re: Noob Question.
« on: May 31, 2016, 02:14:33 pm »
Good day,

I am stressing a bit about the developments in SA. How can one take a lump sum out of SA or would be the best option? Would the DBX-WLD tracker be such an option?

Regards

the dbx wld will be a way to safeguard against ZAR devaluing against the dollar yes. but you cant "Draw" it out if you are overseas. thus the cash is technically still in south africa.

you can use global accounts, which should be available at most banks i think., but for now your best option is to put it into the DBX world, and then to draw out as needed- or cashing out completely should you need to skip country.

i am also interested to see what other options there are otherwise.

14
Shares / Re: My retirement blog.
« on: May 31, 2016, 02:11:13 pm »
Stopped raining today at last. :TU:

I had a similar problem jaDEB. My calf and foot went lame and I could not walk but it was a pinched nerve in my lower back. That is when I was left on the gurney in the passage the whole f**ing night.

Mr_D...I do have medical insurance so I went to the private hospital across the road from me. Have to go back today for physio.

Glad it was nothing too serious (maybe the beer versus Bicycle recommendation by Patrick isnt that bad)

Just to confirm, you mentioned your medical adds R1050 to your monthly bill?  for two 60? year young people that is extremely cheap compared with our local ripoff's (discovery i'm pointing at you!)

15
Shares / Re: Junk Status - how to prepare
« on: May 26, 2016, 03:27:18 pm »
Listen to this (the part where he interview Nerina Visser): http://justonelap.com/simple-diverse-etf-portfolio/

It deals with duplicate investments etc. as well.

very interesting - always love the way Simon Brown tackles things, and having another expert in made it better.

so i am looking forward to buying ETF's on special it seems :D

will adjust DBXUS to DBXWD on my portfolio, and maybe average it out a little, but for now i wont go on a selling spree.

Thx for the recommendation. i will add to this thread if i encounter other sources of relevant info

Pages: [1] 2 3 ... 7