{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["CGT Calculator","Tax table"],"not_rendered":{"charts":1,"images":2,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"CGT Calculator","index":0,"n_rows":56,"n_cols":8,"rows_kept":56,"cut":false,"hidden":false,"merged":[[9,7,9,10],[17,7,17,10],[19,7,19,10],[11,7,11,10],[13,7,13,10],[15,7,15,10],[55,2,62,10],[23,7,23,10],[25,7,25,10],[27,7,27,10],[29,7,29,10],[30,7,30,10],[33,7,33,10],[32,7,32,10]]}
[]
[]
[]
[]
[null,null,"Capital Gains Tax calculator (2023)"]
[]
[null,null,"The calculations are based on the latest tax rates:",null,null,null,null,"http://www.sars.gov.za/Tax-Rates/Pages/default.aspx"]
[null,null,"Input",null,null,null,null,"Notes"]
[]
[null,null,"Taxable entity",null,null,null,null,"Dropdown - select whether the client is an individual or company."]
[]
[null,null,"Age",null,null,null,null,{"$f":"\"Insert investor age as at the end of the \"&MID(C5,31,4)&\" tax year.\"","v":"Insert investor age as at the end of the 2023 tax year."}]
[]
[null,null,"Annual income",null,null,null,null,"Insert investor yearly income before tax. Determines applicable tax rate."]
[]
[null,null,"Base cost (ZAR)",null,null,null,null,"Insert investment cost value."]
[]
[null,null,"Withdrawal amount (ZAR)",null,null,null,null,"Insert investment current value."]
[]
[null,null,"Exclusion already used in tax year",null,null,null,null,"Amount of exclusion already used in tax year."]
[]
[null,null,"Output"]
[null,null," "]
[null,null,"Rate on taxable capital gain",null,{"$f":"IF(E10=\"\",\"\",VLOOKUP(E10,'Tax table'!$B$13:$J$16,2,FALSE))","v":""},null,null,"Tax rate calculated from income."]
[null,null,"CGT inclusion rate",null,{"$f":"IF(E10=\"\",\"\",VLOOKUP(E10,'Tax table'!$B$13:$J$16,3,FALSE))","v":""}]
[null,null,"Effective CGT rate payable",null,{"$f":"IF(OR(E25=\"\",E31=\"\",E34=\"\"),\"\",IFERROR((E34/E31)*E25,0))","v":""},null,null,"Percentage CGT that will be payable by the client."]
[]
[null,null,"Exclusion",null,{"$f":"IF(OR(E10=\"\",E20=\"\"),\"\",MAX(VLOOKUP(E10,'Tax table'!$B$13:$J$16,5,FALSE)-E20,0))","v":""},null,null,"Exclusion that has not been used during the tax year."]
[]
[null,null,"Capital gain/loss",null,{"$f":"IF(OR(E16=\"\",E18=\"\"),\"\",E18-E16)","v":""},null,null,"Profit/loss from investment."]
[null,null,"Taxable capital gain",null,{"$f":"IF(OR(E25=\"\",E28=\"\",E30=\"\"),\"\",IF((E30-E28)<=0,0,(E30-E28))*E25)","v":""},null,null,"Taxable capital gain at the applicable CGT inclusion rate."]
[]
[null,null,"Profit/loss net of CGT",null,{"$f":"IF(OR(E30=\"\",E34=\"\"),\"\",E30-E34)","v":""},null,null,"Amount of profit/loss that can be transferred after CGT."]
[null,null,"Amount CGT payable",null,{"$f":"IF(OR(E10=\"\",E24=\"\",E31=\"\"),\"\",IF(E10=\"Individual\",'Tax table'!C47,E31*E24))","v":""},null,null,"CGT payable by the client."]
[]
[null,null,"Graphical representation"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Disclaimer"]
[]
[null,null,"All information provided in this calculator is provided for information purposes only and does not constitute a legal contract between PSG, the client and any other person or entity unless otherwise specified.  Nothing contained herein is intended to be, or should be construed as an offer or agreement to enter into any transaction or inducement to you or any other person to engage in investment activity, or to enter into any type of financial arrangement or advice on the merit of, or a recommendation in relation to, any particular product or product provider. Nor does it constitute guidance, a proposal or recommendation to enter into any transaction. PSG provides these figures for illustrative purposes and for your convenience. PSG gives no warranty, express or implied, as to the accuracy, reliability and completeness of any information, formulae or calculations provided and does not accept any liability for loss or damage of whatsoever nature, which may be attributable to the reliance on and use of the eventual information. In no event shall PSG be responsible or liable, directly or indirectly, for any damage or loss caused or alleged to be caused by or in connection with the use of or reliance on any such information provided, goods, or services available on or through any related site or report. PSG will refer to PSG Life Limited (1999/010087/06) and PSG Invest (Pty) Limited (1999/014522/07) as the context requires or be a reference to any one of the entities. PSG Wealth may, as part of its services to you, offer computations or information to assist you in managing your tax affairs. Whilst such information will always be provided in the utmost good faith, PSG Wealth gives no representation, warranty or guarantee as to its completeness, accuracy or appropriateness to you. The tax treatment of any investment is determined by the specific circumstances of each client. Taxation may change during the lifetime of an investment. This may result in unanticipated tax liabilities. You should obtain tax advice to be aware of any potential liability before making an investment. If your circumstances change or you are uncertain of how an investment might affect your own tax position, you should seek professional advice."]

{"sheet":"Tax table","index":1,"n_rows":53,"n_cols":10,"rows_kept":53,"cut":false,"hidden":true,"merged":[[19,1,19,2],[19,3,19,4]]}
[]
[null,"2023 Tax Tables - 1 March 2022 to 28 February 2023"]
[]
[null,"Income calculation: "]
[]
[null,"Annual Income",{"$f":"IF('CGT Calculator'!E14>0,'CGT Calculator'!E14,0)","v":0}]
[null,"Taxable Capital Gain",{"$f":"'CGT Calculator'!E31","v":""}]
[null,"Taxable Income",{"$f":"SUM(C6:C7)","v":0}]
[]
[null,"Tax table:"]
[]
[null,"Taxable Entity","Rate on Taxable Capital Gain","CGT Inclusion Rate","Maximum Effective Rate","Exclusion"]
[null,"Individual",{"$f":"C49","v":0},0.4,0.18,40000]
[null,"Company",0.28000000000000003,0.8,0.224,0]
[null,"Trust",0.45,0.8,0.36,0]
[null,"Special Trust",{"$f":"C49","v":0},0.4,0.18,40000]
[]
[null,"Tax table:"]
[]
[null,"Taxable Income (ZAR)",null,"Tax Rate",null,"Test","Test","Calculations","Calculations","Calculations"]
[null,"Lower threshold","Upper Threshold","Add","%","Yearly Income","Yearly Income & taxable capital gain","Yearly Income","Yearly Income & taxable capital gain","Taxable capital gain"]
[null,0,226000,0,0.18,{"$f":"IF(AND($C$6>=B22,$C$6<=C22),TRUE,FALSE)","v":true},{"$f":"IF(AND($C$8>=B22,$C$8<=C22),TRUE,FALSE)","v":true},{"$f":"IF(F22,D22+($C$6-B22)*E22,0)","v":0},{"$f":"IF(G22,D22+($C$8-B22)*E22,0)","v":0},{"$f":"I22-H22","v":0}]
[null,{"$f":"C22+1","v":226001},353100,40680,0.26,{"$f":"IF(AND($C$6>C22,$C$6<=C23),TRUE,FALSE)","v":false},{"$f":"IF(AND($C$8>C22,$C$8<=C23),TRUE,FALSE)","v":false},{"$f":"IF(F23,D23+($C$6-C22)*E23,0)","v":0},{"$f":"IF(G23,D23+($C$8-C22)*E23,0)","v":0},{"$f":"I23-H23","v":0}]
[null,{"$f":"C23+1","v":353101},488700,73726,0.31,{"$f":"IF(AND($C$6>C23,$C$6<=C24),TRUE,FALSE)","v":false},{"$f":"IF(AND($C$8>C23,$C$8<=C24),TRUE,FALSE)","v":false},0,0,0]
[null,488701,641400,115762,0.36,{"$f":"IF(AND($C$6>C24,$C$6<=C25),TRUE,FALSE)","v":false},{"$f":"IF(AND($C$8>C24,$C$8<=C25),TRUE,FALSE)","v":false},0,0,0]
[null,641401,817600,170734,0.39,{"$f":"IF(AND($C$6>C25,$C$6<=C26),TRUE,FALSE)","v":false},{"$f":"IF(AND($C$8>C25,$C$8<=C26),TRUE,FALSE)","v":false},0,0,0]
[null,817601,1731600,239452,0.41,{"$f":"IF(AND($C$6>C26,$C$6<=C27),TRUE,FALSE)","v":false},{"$f":"IF(AND($C$8>C26,$C$8<=C27),TRUE,FALSE)","v":false},0,0,{"$f":"I27-H27","v":0}]
[null,1731601,null,614192,0.45,{"$f":"IF($C$6>C27,TRUE,FALSE)","v":false},{"$f":"IF($C$8>C27,TRUE,FALSE)","v":false},0,0,{"$f":"I28-H28","v":0}]
[null,null,null,null,null,null,null,{"$f":"SUM(H22:H28)","v":0},{"$f":"SUM(I22:I28)","v":0},0]
[]
[null,"Rebate structure:"]
[]
[null,"Type","Age",null,"Value (ZAR)","Test","Calculations","Tax Threshold"]
[null,null,"Lower threshold","Upper Threshold",null,null,"Rebate payable"]
[null,"Primary",0,64,16425,{"$f":"IF(AND('CGT Calculator'!$E$12>=C35,'CGT Calculator'!$E$12<C36),TRUE,FALSE)","v":true},{"$f":"IF(F35,SUM($E$35:E35),0)","v":16425},91250]
[null,"Secondary",{"$f":"D35+1","v":65},74,9000,{"$f":"IF(AND('CGT Calculator'!$E$12>=C36,'CGT Calculator'!$E$12<C37),TRUE,FALSE)","v":false},{"$f":"IF(F36,SUM($E$35:E36),0)","v":0},141250]
[null,"Tertiary",{"$f":"D36+1","v":75},null,2997,{"$f":"IF('CGT Calculator'!$E$12>=C37,TRUE,FALSE)","v":false},{"$f":"IF(F37,SUM($E$35:E37),0)","v":0},157900]
[null,null,null,null,null,null,{"$f":"SUM(G35:G37)","v":16425}]
[null,"Rebate Allocated to Tax on Annual Income",null,{"$f":"IF(H29-G38<=0,H29,IF(H29<=G38,H29,G38))","v":0},{"$f":"D39/G38","v":0}]
[null,"Rebate Allocated to Tax on Capital Gain",null,{"$f":"IF(G38-H29<=0,0,G38-H29)","v":16425},{"$f":"D40/G38","v":1}]
[null,"Unused Rebate",null,{"$f":"G38-D39-D40","v":0},{"$f":"D41/G38","v":0}]
[null,null,null,{"$f":"SUM(D39:D41)","v":16425},{"$f":"SUM(E39:E41)","v":1}]
[]
[null,"Calculations:"]
[]
[null,"Taxable Capital Gain",{"$f":"C7","v":""},null,"Annual Income",null,{"$f":"C6","v":0}]
[null,"Tax on Capital Gain",{"$f":"IF((I29-G38)<=0,0,IF(TRUE,(J29-IF(G38-H29<=0,0,G38-H29)),0))","v":0},null,"Tax on Annual Income",null,{"$f":"IF(H29-G38<=0,0,IF(TRUE,H29-G38,0))","v":0}]
[]
[null,"Rate on Taxable Capital Gain",{"$f":"IFERROR(C47/C46,0)","v":0},null,"Rate on Annual Income",null,{"$f":"IFERROR(G47/G46,0)","v":0}]
[]
[null,"Sources:"]
[]
[null,"https://download.psg.co.za/Files/communications/2020-budget-speech-summary.pdf"]