{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["TRP"],"not_rendered":{"images":1},"read":"whole","date_system":"1900"}

{"sheet":"TRP","index":0,"n_rows":36,"n_cols":16,"rows_kept":36,"merged":[[0,0,0,5]]}
["Transition to Retirement Pension Calculator"]
[]
[{"$nulls":7},"Todays Date",{"$f":"TODAY()","v":{"v":41834,"d":"41834.00"}}]
["Enter Members Date of Birth","1950-01-01",{"$f":"IF(I6<F5,\"TRP Not Available\",\"\")","v":""},"Members Concessional Contributions Cap",null,{"$f":"I14","v":{"v":35000,"d":"$35,000"}},null,"D.O.B",{"$f":"+B4","v":{"v":18264,"d":"18264.00"}}]
["Enter Fund Balance",{"v":0.01,"d":"$0"},null,"Members Preservation Age",null,{"$f":"IF(I4<22098,55,IF(I4<22463,56,IF(I4<22828,57,IF(I4<23193,58,IF(I4<23559,59,IF(I4>23559,60))))))","v":55},null,null,{"$f":"+I3-I4","v":{"v":23570,"d":"23570.00"}}]
[{"$nulls":3},"Members Age",null,{"$f":"ROUNDDOWN(I6,0)","v":64},null,"Age",{"$f":"+I5/365.25","v":{"v":64.53114305270363,"d":"64.53"}}]
["Enter Tax Free Component",{"v":0,"d":"$0"},null,"Maximum TRP Pension",null,{"$f":"+P7","v":{"v":1E-3,"d":"$0"}},{"$nulls":9},{"$f":"IF(F6>=65,B5,B5*0.1)","v":1E-3}]
["Taxable Component",{"$f":"+B5-B7","v":{"v":0.01,"d":"$0"}}," "]
[]
["Enter Fund Earnings Rate",{"v":0,"d":"0%"},null,"Estimated Fund Earnings",null,{"$f":"+B5*B10","v":{"v":0,"d":"$0"}},null,null,"2014-07-01"]
["Enter Members Taxable Income",{"v":0,"d":"$0"},null,"Estimated Tax on Earnings",null,{"$f":"+F10*0.15","v":{"v":0,"d":"$0"}},null,null,{"$f":"+I10","v":41821}]
["Enter Members Existing SG and Salary Sacrifice Contributions",{"v":0,"d":"$0"},null,"Salary Sacrifice Available within Cap",null,{"$f":"+F4-B12","v":{"v":35000,"d":"$35,000"}}]
[{"$nulls":8},{"$f":"IF(F6>50,35000,25000)","v":35000}]
[{"$nulls":8},{"$f":"IF(I6>=75,0,I13)","v":35000}]
[null,"Scenario 1 - No TRP","Scenario 2 - With TRP"]
[null," "]
["Taxable Income",{"$f":"+B11","v":{"v":0,"d":"$0"}},{"$f":"+B11","v":{"v":0,"d":"$0"}},{"$nulls":4},"Min",{"$f":"IF(I6<65,(B5*0.04),IF(I6<75,(B5*0.05),IF(I6<80,(B5*0.06),IF(I6<85,B5*0.07))))","v":0.0004}]
["Extra Salary Scarifice (Within Cap)",{"v":0,"d":"$0"},{"$f":"+I21*-1","v":{"v":-1E-3,"d":"-$0"}},{"$nulls":4},"Max TRP",{"$f":"+F7","v":{"v":1E-3,"d":"$0"}},null,null," "," "]
["TRP Recommended",{"v":0,"d":"$0"},{"$f":"IF(I17>I19,I17,I19)","v":{"v":1E-3,"d":"$0"}},{"$nulls":4},"TRP Needed",{"$f":"IF(F12<I18,F12,I18)","v":1E-3},null,null," "]
["$ Amount of TRP Not Taxable",{"$f":"+H30","v":{"v":0,"d":"$0"}},{"$f":"+I30*-1","v":{"v":-1E-3,"d":"-$0"}},{"$nulls":5},{"$f":"IF(I6>=75,0,I19)","v":1E-3},null,null," "]
["Net Taxable Income",{"$f":"+B17+B18+B19","v":{"v":0,"d":"$0"}},{"$f":"+C17+C18+C19+C20","v":{"v":-1E-3,"d":"-$0"}},{"$nulls":5},{"$f":"IF(I20<0,0,I20)","v":1E-3}]
[]
["Total Tax Payable (Inc Medicare)",{"$f":"+H27","v":{"v":0,"d":"$0"}},{"$f":"+J27","v":{"v":0,"d":"$0"}},{"$nulls":3},"Tax Payable",{"$f":"IF(B21<=18200,0,IF(B21<=37000,(B21-18200)*0.19,IF(B21<=80000,(B21-37000)*0.325+3572,IF(B21<=180000,(B21-80000)*0.37+17547,IF(B21>180000,(B21-180000)*0.45+54547)))))","v":{"v":0,"d":"$0"}},{"$f":"IF(C21<=18200,0,IF(C21<=37000,(C21-18200)*0.19,IF(C21<=80000,(C21-37000)*0.325+3572,IF(C21<=180000,(C21-80000)*0.37+17547,IF(C21>180000,(C21-180000)*0.45+54547)))))","v":{"v":0,"d":"$0"}}]
[{"$nulls":6},"Medicare",{"$f":"IF(B21<20542,0,B21*0.02)","v":{"v":0,"d":"$0"}},{"$f":"IF(C21<20542,0,C21*0.02)","v":{"v":0,"d":"$0"}}]
[" "," "," ",{"$nulls":3},"Total",{"$f":"+H23+H24","v":{"v":0,"d":"$0"}},{"$f":"+I23+I24","v":{"v":0,"d":"$0"}}]
["Tax No Longer payable on Fund Earnings",{"v":0,"d":"$0"},{"$f":"+F11*-1","v":{"v":0,"d":"$0"}},{"$nulls":3},"Rebate",{"$f":"+B19*0.15","v":{"v":0,"d":"$0"}},{"$f":"(C19+C20)*0.15","v":{"v":0,"d":"$0"}}]
["Tax on Additional Super Contributions",{"$f":"+B18*0.15","v":{"v":0,"d":"$0"}},{"$f":"+C18*0.15*-1","v":{"v":0.00015,"d":"$0"}},{"$nulls":3},"After Rebate",{"$f":"+H25-H26","v":{"v":0,"d":"$0"}},{"$f":"+I25-I26","v":{"v":0,"d":"$0"}},{"$f":"IF(I27<0,0,I27)","v":0}]
["Enter Full Cost Financial Planner will charge to setup TRP",{"v":0,"d":"$0"},{"v":0.01,"d":"$0"}]
[]
["Net First Year Savings of Setting up a TRP",{"$f":"+H36","v":{"v":-0.010150000000000001,"d":"-$0"}},{"$f":"+C4","v":""},{"$nulls":4},{"$f":"IF(I6>=60,0,(B7/600000)*B19)","v":{"v":0,"d":"$0"}},{"$f":"IF(I6>=60,C19,(B7/B5)*C19)","v":{"v":1E-3,"d":"$0"}}]
[]
[{"$nulls":7},{"$f":"+B23-C23","v":{"v":0,"d":"$0"}}]
[{"$nulls":7},{"$f":"+C26*-1","v":{"v":0,"d":"$0"}}]
[{"$nulls":7},{"$f":"+C27","v":{"v":0.00015,"d":"$0"}}]
[{"$nulls":7},{"$f":"+C28","v":{"v":0.01,"d":"$0"}}]
[{"$nulls":7},{"$f":"+H32+H33-H34-H35","v":{"v":-0.010150000000000001,"d":"-$0"}}]