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.


Topics - erwintwr

Pages: [1]
1
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 :




2
Shares / Junk Status - how to prepare
« on: May 26, 2016, 01:01:36 pm »
hi guys

i did search on the forum a bit, but it doesn't seem like there is a thread directly related to this.

asssuming most of you did your research already, but what will be the best / ? safest investment ETF to carry you through the junk status?


i know some local shares and thus ETF's coupled to them might stick through a junk rating, but i dont want to do the long term thing only to discover 2/3 years down the line that we are not going to recover :(


currently i am into the following ETF's :

DIVTRX +- 60%
then equally divided:
STXIND
DBXUS
DBXWD
STXFIN
PTXTEN
PTXSPY


what sectors will be hurt the most on a junk rating?

my feeling is to just jump ship onto DBXUS / DBXWD, as i dont think the USD/ZAR will ever recover with a bad rating..

sigh.... zuma fail


Thx fuys

3
Shares / Etoro - Anybody using?
« on: December 18, 2015, 09:23:55 am »
hi guys

international investing is becoming more and more tempting, and i saw this platform linked in a mybb post earlier today :
http://www.etoro.com/en/customer-service/fees/

The only thing that bothers me - is that i cant understand their Fee structure. the above link, if you move over to stocks, mentions :
Quote
please note: we will not charge holding fees for non-leveraged buy positions.

thus the only fee should be on trading, and also depositing/withdrawing your money.

This blog post indicates that a fee of 0.1% will be charge on buying a stock, and then $25 to withdraw $500 or more(5%). - eg withdrawing larger amounts is the only way to avoid the fee's.

http://www.savethestudent.org/make-money/stock-market-investing.html


They are obviously catered for the trading persona, allowing you to copy other traders with a % of your investment, which seems tempting as well - but i will rather buy and hold.

does any one see any other catches i might need to know about?



4
Shares / Dividend tax - Where is it applied?
« on: June 22, 2015, 09:37:41 am »
Quite an interesting question came up during my recent en devours to build a F.I calculator, where someone asked if Dividend tax was allowed for.

Although i couldn't include this in the calculator (dividends and thus the resulting tax will be different per instrument), i was however wondering what the fact sheets out there are using.

verifying with Satrix directly, the calculator on their website shows results without dividend tax applied - which means my returns investing via my broker will be a few percent lower than what is reported :(

Assuming this is the case with most online sources, i am wondering which investment tools/platforms allow you to enjoy to enjoy growth on a Equity/ETF without paying tax on dividends?

currently the only two i can think off is  Retirement annuities and TFSA?

does anyone else maybe have additional platforms they can recommend?

erwintwr

5
Hi guys

Since Financial independence have been bugging me a while, i decided to put some time into the following calculator.

Calculator Link
(hosted on dropbox, please select download (Three dots top right)



It basically calculates over 4 evenly distributed periods what your after tax return will be for the different type of investments (and combinations there of)
Basic operation :
  • income is invested as per inputs
  • investment is stopped at the configured FI years
  • Required salary at that age is calculated (basically current expenses inflation adjusted plus the spending buffer
  • draw-down is tested(eg first equity then TFSA(using the required salary calculated as per above)
  • once 55 is reached draw capital is combined with RA, and max salary is drawn to reach 95
  • possible surplus salary at 55 is reported (after tax, inflation adjusted), as well as draw strategy that gave the best result
**Note1  If draw down pre 55  failed, salary will be shown as R0.00

Inputs:






Something interesting that the calculator now roughly allows is to determine if pre tax or post tax RA contributions is the best (remember to adjust your after tax savings percentage accordingly)


Capital gain tax is applied to Equity investments with exclusions applied.

If any obvious mistakes is picked up, please let me know. Otherwise - i hope this helps someone :)

The usual yada yada T&C's applies - cant take responsibility if an excel mistake causes you to eat beans at the age of 60 :P).

Have fun

Neo_x

*edit*
Update to version 4.2(4/05/2017)
* Added the latest tax tables (note that tax tables for future years is automatically adjusted based on a 10 year average.)
* increased TFSA to 33,000  (note that there is an option to automatically increase the TFSA)



Update to version 4.1(8/03/2016)
* Added the latest tax tables (note that tax tables for future years is automatically adjusted based on a 10 year average.)
* improved the CGT formulae to allow adapting to future tax changes (latest tax change moved the previous 33% up to 40%)

*pending - still to Add the RA contribution limit ( there is an annual amount after which the tax benefit doesn't apply on a RA)

Update to version 4.0(6/12/2015)
* Added functionality to add retirement annuity deduction as per payslip. (caution  - this is kept constant throughout the calculator and adjusted as per your pay increases. Any other contributions towards an RA will be after tax, and tax returns will be re-invested).
Although some checks is in place, please double check that your RA deduction is not greater than the allowed SARS Tax benefit.
/* this is quite a major update - if anything strange is noted on the results, please provide feedback

* Summary screen was updated -with a total Portfolio value, and some readability/formatting.



Update to version 3.8(03/12/2015)
* Improved summary page after some recommendations (added portfolio values at the FI year, so that you can have a visual of the values)

Update to version 3.7(19/11/2015)
* improved a formula to be more accurate for monthly interest(This was workbook wide, thus affects all totals)

Update to version 3.6 (7/7/2015)
* fixed a bug that slipped in when moving some of the reference tables around (affected TFSA contributions)
* adjusted tax table inflation averages a little.


Update to version 3.5
* Added a once off bonus at FI - configurable. This is to allow a lumpsum draw to happen at FI, mostly  for big expenses (paying off house/car, etc)
* Fixed tax tables between FI age and 55- changed to  CGT tax(was previously normal tax)
* Improved readability on summary screen


Update to version 3.4
*Adjusted internal calculations ,based on paying current loans (eg home /car) - expenses that wont remain into financial independence for long - configurable(change to zero if you plan to keep paying off your home/car  up to 95 :P)
*improved the results screen ,showing more details as to what is happening, including your salary at FI.

only challenges that still remains :
* Drawing a salary after FI is calculated, mostly, based on drawing your tax every month. this wont be the case, as you will draw a once off SARS amount after tax claims are due.

* Homeloan and car expenses is removed after the payment period is complete - not sure how to tackle the scenario where you want to continue wasting money into the latest and fastest clown-mobiles every few years. for now, please configure the buffer to allow for any expenses that you will keep/add after FI.


Update to version 3.3
*discovered and fixed a major miscalculation with regards to savings (was previously matching salary increases, while it should be based on salary minus inflation adjusted expenses.
Bonus part is that this increases savings, and thus will result in a quicker FI.
*added more accurate descriptions on the summary page
*added a check to show a salary shortfall (eg your increases is below inflation, which then results in running into a salary that cant carry your expenses.

Update to version 3.2
*Tax tables was "ahead" with a year - Corrected
*Improved the Salary prediction required at Financial Independence - should now be much more accurate(current expenses is inflation adjusted with buffer added, then reverse tax is applied to determine the before tax salary)
*Added a Spending buffer which will be added to your salary after FI (use full if you want to go on that yearly travel trip :p



Update to version 3.1
* Expanded draw down function - now select the most rewarding draw path (selecting between Equities/ TFSA and also splitting a third of the RA at 55 into equities or keeping it in tact)
* Added a option to block TFSA limits from increasing every  year(configurable under constants)
* fixed some calculations for extreme cases(eg paying RA and TFSA off in one month)

Update to version 3.0
Major functionality update - basically it is now a South African Financial Independence calculator. Most Inputs is customizable, including Age, Inflation, and current portfolio values. System will output 3 periods between your current age and 55 years, allowing you to see capital growth.

Update to version 2.0
* major changes in tax tables - applied 10% increase on tax tables per year (current average since 2005) - this is configurable under inputs...
* added 20 and 30 year results sets as well
* 10 year result is based on tax for a ten year "draw" (year 15 tax is applied)
* 20 year result is based on tax for a twenty year "draw" (year 30 tax is applied)
* 30 year result is based on tax for a thirty year draw (year 45 tax is applied)


Update to version 1.7
* Fixed tax tables related to tax return(now properly selects the correct bracket)
* Applied the before 65 rebate of 13 to all calculations

Updated to version 1.6
* Fixed a mistake on the first third RA tax (Thank you KalMaverick!)

Updated to version 1.5
* Added Ability to limit RA contribution to values other than 15%
* Applied latest SARS tax tables
* Tax on RA 2/3's and Equities was adjusted to be more leniant (assuming 10% draw down)
* Tax bracket changes due to salary increase should also be handled better now
*

Updated to version 1.4
* Fixed RA SARS return when only small portion of Salary is paid

Updated to version 1.3
fixed major mistake on "TFSA then RA" worksheet, plus corrected RA lump sum tax as per latest SARS document

Updated to version 1.2
Fixed for small salaries (eg not capable of reaching RA of 15%)
fixed for big salaries (tax return of greater than 30k was messing up TFSA allocation)

6
Shares / PE ratio History graph / Porfolio tracker
« on: February 12, 2015, 05:08:23 pm »
Hi guys

Does anyone have a good reference where i will be able to draw P/E history, preferably in graph format, for different shares?

Most of the tools i currently use only shows current PE ( google and MSN finance), unless i am overlooking it


7
Shares / Top performing shares(10 years)
« on: November 22, 2014, 06:34:58 pm »
Hi guys

since most of the JSE statistics is available in a few online platforms, i was hoping someone could point me to the correct tool.

I am looking to find the top 10/20 shares as measured over the last 10 years, but looking at the number of shares that is currently available it seems a daunting task to randomly select shares and compare them with each other.

i could obviously look at international markets as well (probably via PSG online), but for now i will stick with SA markets is possible.

Unfortunately my google-skills on this is not the very best (sometimes a top performing article is released for a specific year, but i was hoping that a more accurate option is available.


hope someone can help

thx


8
Shares / Shares vs compound interest
« on: July 26, 2014, 09:53:51 am »
Hi guys

Lots of friendly folk on here (Orca included :D), and i would like to see if someone can bite the bullet and help some of us out.
I am still very green on this, and would like someone to explain in plain English (if thats possible :P ), what am i to do.

the obvious question - where best to invest my money :).

What i try to understand, is if i should choose a bank do do my investments ( lets say R1k per month with inflation), or should i directly buy shares with that.

At a bank, they will pay me annual interest monthly at a small % rate, but the interest is straight back into my account, and thus next month its interest on top of interest. thus after a few years this could really work.

but if i should go with a shares platform ( lets go with the satrix INDI), what will the end result be? eg if i use dividents to buy shares again each 3months, for  about five years, what will the resulting fee be?
eg month 1 , R1k shares, month 2 R1k shares, Month 3 R1k shares, month 4, R1k shares + dividents, and so on


Complicating the question more is obviously how does tax affect both scenario's? i don't remember ever submitting my interest gained via bank account to SARS, but it seems to be a very strict thing when looking at shares...


Also the next thing that comes to mind, is which platform to use to go for the long term ( ie i wont be buying and selling - just a constant monthly "investment"). Is the usual FNB/ Standerbank platforms too expensive in terms of monthly costs and brokerage fee's? what other options does a guy on the street have ( without having to shell out R100's of thousands). Brokerage fee's is something i don't usually pay in the bank scenario, which could affect the comparison i guess..



hope this discussion will help other people in the future too


thx guys



Pages: [1]