{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Rates and Allowances","Workings(Inc Tax)","Summary"," Tax","Corporation Tax","Graph Data","New Format for output"],"not_rendered":{"charts":5,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":1,"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":"Rates and Allowances","index":0,"n_rows":46,"n_cols":17,"rows_kept":46,"cut":false,"hidden":true,"merged":[[10,0,10,4],[3,11,6,13],[19,8,21,13],[11,14,11,16]]}
["Income Tax ",null,null,null,null,null,null,"Born"]
["Personal Allowance (1)",12570,null,null,null,null,null,"After 5 April 1948",1,10000]
["Income limit for Personal Allowance",100000,null,null,null,null,null,"Before 6 April 1938",2,10660]
["Personal Allowance for people aged 65-74 (1)(2)",10600,{"$f":"B4-B2","v":-1970},null,{"$f":"(C4*2)+B5","v":23760},null,null,"Between 6 April 1938 and 5 April 1948",3,10500,null,"grey boxes not used"]
["Income limit for age-related allowances",27700]
[]
["(1) From the 2010-11 tax year the Personal Allowance reduces where the income is above £100, 000 - by £1 for every £2 of income above the £100,000 limit. This reduction applies irrespective of age."]
["(2) These allowances reduce where the income is above the income limit for age - related allowances - by £1 for every £2 of income above the limit. From the 2010-11 tax year the Personal Allowance "]
["for people aged over 65 can be reduced below the basic Personal Allowance where the income is above £100,000."]
[]
["Income Tax rates and taxable bands SRIT",null,null,null,null,null,null,null,"Inserted for combined results"]
["Rate",null,null,null,null,null,null,null,"SRIT","UKIT","Scot Limit","UK Limit",null,null,"for srit bands"]
["Starter rate",{"$f":"IF(Summary!$F$6=\"Yes\",I13,J13)","v":0},0,"to",{"$f":"IF(Summary!$F$6=\"Yes\",K13,L13)","v":0},null,null,null,0.19,0,2827,0,{"$f":"B2+K13","v":15397},null,15397,12571,{"$f":"O13-P13","v":2826}]
["Basic rate",{"$f":"IF(Summary!$F$6=\"Yes\",I14,J14)","v":0.2},{"$f":"E13","v":0},null,{"$f":"IF(Summary!$F$6=\"Yes\",K14,L14)+E13","v":37700},null,null,null,0.2,0.2,12094,37700,{"$f":"K13+K14+B2","v":27491},null,27491,15398,{"$f":"O14-P14","v":12093}]
["Intermediate rate",{"$f":"IF(Summary!$F$6=\"Yes\",I15,J15)","v":0},{"$f":"E14","v":37700},null,{"$f":"IF(Summary!$F$6=\"Yes\",K15,L15)+E14","v":37700},null,null,null,0.21,0,16171,0,{"$f":"M14+K15","v":43662},null,43662,27492,{"$f":"O15-P15","v":16170}]
["Higher rate",{"$f":"IF(Summary!$F$6=\"Yes\",I16,J16)","v":0.4},{"$f":"E15","v":37700},"to",{"$f":"IF(Summary!$F$6=\"Yes\",K16,L16)+E15","v":37700},null,null,null,0.42,0.4,31338,0,{"$f":"K16+M15","v":75000}]
["Advanced Rate",{"$f":"IF(Summary!$F$6=\"Yes\",I17,J17)","v":0},{"$f":"E16","v":37700},null,{"$f":"IF(Summary!$F$6=\"Yes\",K17,L17)","v":125140},null,null,null,0.45,0,125140,125140]
[{"$f":"IF(Summary!F6=Summary!AA3,\"Top Rate\",\"Additional Rate\")","v":"Additional Rate"},{"$f":"IF(Summary!$F$6=\"Yes\",I18,J18)","v":0.45},"Over ",null,{"$f":"IF(Summary!$F$6=\"Yes\",K18,L18)","v":0},null,null,null,0.48,0.45]
[]
["Dividends - Non devolved",null,null,null,null,null,null,null,"Update this table, not the info on the left"]
["Basic Rate",null,null,null,null,37700]
["Higher Rate",null,null,null,null,112300]
[]
["Dividends"]
["Zero Rate",0]
["Basic Rate",8.7499999999999994E-2]
["Higher Rate",0.33750000000000002,null,null,null,null,null,null,"Suicide Code"]
["Additional Rate",0.39350000000000002,null,null,null,null,null,null,{"$f":"TODAY()","v":"2025-04-02"}]
[null,null,null,null,null,null,null,null,"2026-04-05"]
["Divi Allowance",500]
[]
[]
["Corporation Tax"]
["Small Profits Rate",50000,0.19]
["Marginal Rate",null,0.26500000000000001]
["Main Rate",250000,0.25]
[]
["National Insurance"]
["£ per week","£ per week","£ annually"]
["Lower earnings limit, primary Class 1",120,{"$f":"B40*52","v":6240}]
["Upper earnings limit, primary Class 1",null,50270]
["Primary threshold",null,12570,null,{"$f":"C41-C42","v":37700}]
["Secondary threshold",null,5000]
["Employees’ primary Class 1 rate between primary threshold and upper earnings limit",0.08]
["Employees’ primary Class 1 rate above upper earnings limit",0.02]
["Employers’ secondary Class 1 rate above secondary threshold",0.15]

{"sheet":"Workings(Inc Tax)","index":1,"n_rows":29,"n_cols":12,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
[null,"Existing Position",null,null,null,null,null,"After new contribution"]
[]
[null,"Taxable Income",null,null,null,{"$f":"Summary!F10","v":0},null,"Taxable Income",null,null,null,{"$f":"Summary!F29","v":0}]
[]
[null,null,"Allowances","Still to tax","Allowance balance","tax_sal_bandx_pre",null,null,"Allowances","Still to tax","Allowance balance"]
[null,"Tax Free",{"$f":"' Tax'!E21","v":12570},{"$f":"F3","v":0},{"$f":"MAX(0,C6-F6)","v":12570},{"$f":"IF(F3<C6,F3,C6)","v":0},null,"TaxFree",{"$f":"' Tax'!M21","v":12570},{"$f":"L3","v":0},{"$f":"MAX(0,I6-L6)","v":12570},{"$f":"IF(L3<I6,L3,I6)","v":0}]
[null,"Starter Rate",{"$f":"'Rates and Allowances'!E13-'Rates and Allowances'!C13","v":0},{"$f":"F3-F6","v":0},0,{"$f":"MIN(D7,C7)","v":0},null,"Starter Rate",{"$f":"'Rates and Allowances'!E13-'Rates and Allowances'!C13","v":0},{"$f":"L3-L6","v":0},0,{"$f":"MIN(J7,I7)","v":0}]
[null,"Basic Rate",{"$f":"'Rates and Allowances'!E14-'Rates and Allowances'!C14+Summary!K8","v":37700},{"$f":"MAX(0,D7-F7)","v":0},37700,0,null,"Basic Rate",{"$f":"'Rates and Allowances'!E14-'Rates and Allowances'!C14+Summary!K31","v":37700},{"$f":"MAX(0,J7-L7)","v":0},37700,{"$f":"MIN(J8,I8)","v":0}]
[null,"Intermediate Rate",{"$f":"'Rates and Allowances'!E15-'Rates and Allowances'!C15","v":0},{"$f":"MAX(0,D8-F8)","v":0},0,0,null,"Intermediate Rate",{"$f":"'Rates and Allowances'!E15-'Rates and Allowances'!C15","v":0},{"$f":"MAX(0,J8-L8)","v":0},0,0]
[null,"Higher Rate",{"$f":"'Rates and Allowances'!E16-'Rates and Allowances'!C16","v":0},{"$f":"MAX(0,D9-F9)","v":0},0,0,null,"Higher Rate",{"$f":"'Rates and Allowances'!E16-'Rates and Allowances'!C16","v":0},{"$f":"MAX(0,J9-L9)","v":0},0,0]
[null,"Advanced Rate",{"$f":"'Rates and Allowances'!E17-'Rates and Allowances'!C17","v":87440},{"$f":"MAX(0,D10-F10)","v":0},87440,0,null,"Advanced Rate",{"$f":"'Rates and Allowances'!E17-'Rates and Allowances'!C17","v":87440},{"$f":"MAX(0,J10-L10)","v":0},87440,0]
[null,"Additional Rate       >",{"$f":"'Rates and Allowances'!E18+Summary!K8","v":0},{"$f":"MAX(0,D11-F11)","v":0},0,{"$f":"MIN(D12,C12)","v":0},null,"Additional Rate       >",{"$f":"'Rates and Allowances'!E18+Summary!K31","v":0},{"$f":"MAX(0,J11-L11)","v":0},0,0]
[]
[]
[]
[null,"Dividend",null,null,null,{"$f":"Summary!F12","v":0},null,"Dividend",null,null,null,{"$f":"Summary!F31","v":0}]
[null,"Tax Free",{"$f":"MAX(0,E6)","v":12570},{"$f":"F16","v":0},{"$f":"MIN(E6,E6-F17)*0+MAX(0,C17-D17)","v":12570},{"$f":"MIN(C17,D17)","v":0},null,"Tax Free",{"$f":"MAX(0,K6)","v":12570},{"$f":"L16","v":0},{"$f":"MIN(K6,K6-L17)*0+MAX(0,I17-J17)","v":12570},{"$f":"MIN(I17,J17)","v":0}]
[null,"Divi Allowance",{"$f":"'Rates and Allowances'!B30","v":500},{"$f":"D17-F17","v":0},null,{"$f":"MIN(C18,D18)","v":0},null,"Divi Allowance",{"$f":"'Rates and Allowances'!B30","v":500},{"$f":"J17-L17","v":0},null,{"$f":"MIN(I18,J18)","v":0}]
[null,"Basic Rate",{"$f":"IF((F7+C18)>C29,MAX(0,(E7-F18)),C29-(F7+C18))*0+MAX(0,(E7-C18+IF(D7<C29,MIN(C29-D7,C29-'Rates and Allowances'!E13),0)))","v":37200},{"$f":"D18-F18","v":0},{"$f":"MIN(E7,E7-F18)*0+MAX(0,C19-D19)","v":37200},{"$f":"MIN(C19,D19)","v":0},null,"Basic Rate",{"$f":"IF((L7+I18)>I29,MAX(0,(K7-L18)),I29-(L7+I18))*0+MAX(0,(K7-I18+IF(J7<I29,MIN(I29-J7,I29-'Rates and Allowances'!E13),0)))","v":37200},{"$f":"J18-L18","v":0},{"$f":"MIN(K7,K7-L18)*0+MAX(0,I19-J19)","v":37200},{"$f":"MIN(I19,J19)","v":0}]
[null,"Higher Rate",{"$f":"MAX(0,SUM(E6:E11)-SUM(C17:C19))","v":87440},{"$f":"D19-F19","v":0},{"$f":"MIN(0,C20-D20)*0+MAX(0,C20-D20)","v":87440},{"$f":"MIN(D20,C20)","v":0},null,"Higher Rate",{"$f":"MAX(0,SUM(K6:K11)-SUM(I17:I19))","v":87440},{"$f":"J19-L19","v":0},{"$f":"MIN(0,I20-J20)*0+MAX(0,I20-J20)","v":87440},{"$f":"MIN(J20,I20)","v":0}]
[null,"Additional Rate       >",{"$f":"C12","v":0},{"$f":"D20-F20","v":0},0,{"$f":"D21","v":0},null,"Additional Rate       >",{"$f":"I12","v":0},{"$f":"J20-L20","v":0},0,{"$f":"J21","v":0}]
[]
[]
[]
[]
[]
[]
[null,"Divi Bands",null,null,null,null,null,"Divi Bands"]
[null,"Basic Rate",{"$f":"'Rates and Allowances'!F21+Summary!K8","v":37700},null,null,null,null,"Basic Rate",{"$f":"'Rates and Allowances'!F21+Summary!K31","v":37700}]

{"sheet":"Summary","index":2,"n_rows":111,"n_cols":27,"rows_kept":111,"cut":false,"hidden":false,"merged":[[40,3,44,23],[0,16,0,17],[0,3,0,8],[13,21,13,23],[11,8,11,9],[24,8,24,9],[4,21,4,23],[2,16,2,23],[4,8,4,10],[0,9,0,10]]}
["Individuals age",null,null,"Extracting Company Profits Tool\nbuilt by M&G",null,null,null,null,null,null,null,null,null,null,null,null,"Tax Year 2025/26"]
["Between 6 April 1938 and 5 April 1948"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'New Format for output'!A1","v":"Short Summary"},null,null,null,null,null,null,null,null,null,"Yes"]
[null,null,null,"Pre change position",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[null,null,null,null,null,null,null,null,"Gross value of individuals pension contributions",null,null,null,null,null,null,null,null,{"$f":"'New Format for output'!B2","v":"Pre Change"},null,{"$f":"'New Format for output'!D2","v":"After change"},null,{"$f":"'New Format for output'!F2","v":"Difference"}]
[null,null,null,"Scottish Tax Payer",null,"No",null,null,"Paid gross e.g.OPS, RACs, AVCs",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'New Format for output'!A4","v":"Individual Bank Account"},{"$f":"'New Format for output'!B4","v":0},null,{"$f":"'New Format for output'!D4","v":0},null,{"$f":"'New Format for output'!F4","v":0},null,{"$f":"'New Format for output'!G4","v":"No change"}]
[null,null,null,"Available Profits",null,0,null,null,"Relief at Source e.g PP,GPP",null,0,null,null,null,null,null,{"$f":"'New Format for output'!A5","v":"Company Bank Account"},{"$f":"'New Format for output'!B5","v":0},null,{"$f":"'New Format for output'!D5","v":0},null,{"$f":"'New Format for output'!F5","v":0},null,{"$f":"'New Format for output'!G5","v":"No change"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'New Format for output'!A6","v":"Pension Contributions"},{"$f":"'New Format for output'!B6","v":0},null,{"$f":"'New Format for output'!D6","v":0},null,{"$f":"'New Format for output'!F6","v":0},null,{"$f":"'New Format for output'!G6","v":"No change"}]
[null,null,null,"Salary Paid",null,0,null,null,null,null,null,null,null,null,null,null,{"$f":"'New Format for output'!A7","v":"HMRC total take"},{"$f":"'New Format for output'!B7","v":0},null,{"$f":"'New Format for output'!D7","v":0},null,{"$f":"'New Format for output'!F7","v":0},null,{"$f":"'New Format for output'!G7","v":"No change"}]
[]
[null,null,null,"Dividends Paid",null,0,null,null,"Employer \nContributions",null,0,null,null,null,null,null,{"$f":"'New Format for output'!A10","v":"Detailed View"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'New Format for output'!B11","v":"Pre Change"},null,{"$f":"'New Format for output'!D11","v":"After change"},null,{"$f":"'New Format for output'!F11","v":"Difference"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'New Format for output'!A12","v":"Individual"}]
[null,null,null,"Change (use a - for reductions)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'New Format for output'!A14","v":"Salary"},{"$f":"'New Format for output'!B14","v":0},null,{"$f":"'New Format for output'!D14","v":0},null,{"$f":"'New Format for output'!F14","v":0},null,{"$f":"'New Format for output'!G14","v":"No change"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'New Format for output'!A15","v":"Plus Dividend received"},{"$f":"'New Format for output'!B15","v":0},null,{"$f":"'New Format for output'!D15","v":0},null,{"$f":"'New Format for output'!F15","v":0},null,{"$f":"'New Format for output'!G15","v":"No change"}]
[null,null,null,"Salary Paid",null,0,null,null,"Paid gross e.g.OPS, RACs, AVCs",null,0,null,{"$f":"IF(K29<0,\"Total pension cannot be negative\",\"\" )","v":""},null,null,null,{"$f":"'New Format for output'!A16","v":"Less Income Tax "},{"$f":"'New Format for output'!B16","v":0},null,{"$f":"'New Format for output'!D16","v":0},null,{"$f":"'New Format for output'!F16","v":0},null,{"$f":"'New Format for output'!G16","v":"No change"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'New Format for output'!A17","v":"Less National Insurance"},{"$f":"'New Format for output'!B17","v":0},null,{"$f":"'New Format for output'!D17","v":0},null,{"$f":"'New Format for output'!F17","v":0},null,{"$f":"'New Format for output'!G17","v":"No change"}]
[null,null,null,"Dividends Paid",null,0,null,null,"Relief at Source e.g PP,GPP",null,0,null,{"$f":"IF(K31<0,\"Total pension cannot be negative\",\"\" )","v":""},null,null,null,{"$f":"'New Format for output'!A18","v":"Less Contributions gross"},{"$f":"'New Format for output'!B18","v":0},null,{"$f":"'New Format for output'!D18","v":0},null,{"$f":"'New Format for output'!F18","v":0},null,{"$f":"'New Format for output'!G18","v":"No change"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'New Format for output'!A19","v":"Net Income"},{"$f":"'New Format for output'!B19","v":0},null,{"$f":"'New Format for output'!D19","v":0},null,{"$f":"'New Format for output'!F19","v":0},null,{"$f":"'New Format for output'!G19","v":"No change"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'New Format for output'!A20","v":"Less Contributions paid net"},{"$f":"'New Format for output'!B20","v":0},null,{"$f":"'New Format for output'!D20","v":0},null,{"$f":"'New Format for output'!F20","v":0},null,{"$f":"'New Format for output'!G20","v":"No change"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'New Format for output'!A21","v":"Cash remaining"},{"$f":"'New Format for output'!B21","v":0},null,{"$f":"'New Format for output'!D21","v":0},null,{"$f":"'New Format for output'!F21","v":0},null,{"$f":"'New Format for output'!G21","v":"No change"}]
[null,null,null,null,null,null,null,null,"Employer \nContributions",null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'New Format for output'!A23","v":"Employer"}]
[null,null,null,"After change"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'New Format for output'!A25","v":"Available Profits"},{"$f":"'New Format for output'!B25","v":0},null,{"$f":"'New Format for output'!D25","v":0},null,{"$f":"'New Format for output'!F25","v":0},null,{"$f":"'New Format for output'!G25","v":"No change"}]
[null,null,null,"Salary",null,{"$f":"F10+F19","v":0},null,null,"Paid gross e.g.OPS, RACs, AVCs",null,{"$f":"K6+K19","v":0},null,null,null,null,null,{"$f":"'New Format for output'!A26","v":"Less Dividend Paid"},{"$f":"'New Format for output'!B26","v":0},null,{"$f":"'New Format for output'!D26","v":0},null,{"$f":"'New Format for output'!F26","v":0},null,{"$f":"'New Format for output'!G26","v":"No change"}]
["Increase by",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'New Format for output'!A27","v":"Less Employer Pension Contribution"},{"$f":"'New Format for output'!B27","v":0},null,{"$f":"'New Format for output'!D27","v":0},null,{"$f":"'New Format for output'!F27","v":0},null,{"$f":"'New Format for output'!G27","v":"No change"}]
["Reduce by",null,null,"Dividends",null,{"$f":"F12+F21","v":0},null,null,"Relief at Source e.g PP,GPP",null,{"$f":"K8+K21","v":0},null,null,null,null,null,{"$f":"'New Format for output'!A28","v":"Less Corporation Tax"},{"$f":"'New Format for output'!B28","v":0},null,{"$f":"'New Format for output'!D28","v":0},null,{"$f":"'New Format for output'!F28","v":0},null,{"$f":"'New Format for output'!G28","v":"No change"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'New Format for output'!A29","v":"Less Salary Paid"},{"$f":"'New Format for output'!B29","v":0},null,{"$f":"'New Format for output'!D29","v":0},null,{"$f":"'New Format for output'!F29","v":0},null,{"$f":"'New Format for output'!G29","v":"No change"}]
[null,null,null,null,null,null,null,null,"Employer Contributions",null,{"$f":"K12+K25","v":0},null,null,null,null,null,{"$f":"'New Format for output'!A30","v":"Less Employers National Insurance"},{"$f":"'New Format for output'!B30","v":0},null,{"$f":"'New Format for output'!D30","v":0},null,{"$f":"'New Format for output'!F30","v":0},null,{"$f":"'New Format for output'!G30","v":"No change"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'New Format for output'!A31","v":"Profit remaining"},{"$f":"'New Format for output'!B31","v":0},null,{"$f":"'New Format for output'!D31","v":0},null,{"$f":"'New Format for output'!F31","v":0},null,{"$f":"'New Format for output'!G31","v":"No change"}]
[]
[null,null,null,"Assumed rate of tax on pension income",null,null,0.2,null,"Reduction in individuals bank account",null,{"$f":"IF(V7<=0,-V7,0)","v":0},null,{"$f":"IF(V7>0,\"Bank account has increased\",\"\" )","v":""}]
[null,null,null,null,null,null,null,null,"Increase in pension provision",null,{"$f":"V37","v":0},null,null,null,null,null,{"$f":"'New Format for output'!A34","v":"Pension Contributions"},{"$f":"'New Format for output'!B34","v":0},null,{"$f":"'New Format for output'!D34","v":0},null,{"$f":"'New Format for output'!F34","v":0},null,{"$f":"'New Format for output'!G34","v":"No change"}]
[null,null,null,null,null,null,null,null,"Amount after PCLS and tax",null,{"$f":"K37-(K37*0.75*G36)","v":0}]
[null,null,null,null,null,null,null,null,"\"Return\" on bank account reduction",null,{"$f":"IF(K36=0,\"No reduction\",((K38/K36)-1))","v":"No reduction"}]
[]
[null,null,null,"This tool will enable you to sit with a client and discuss the different options that they have for extracting profits from their business. You can input a client's current remuneration structure and highlight the difference adjusting this structure can benefit them and possibly mitigate the tax and national insurance payable to HMRC.\n\nThe above is based on our understanding of current taxation, legislation and HM Revenue & Customs practice all of which is subject to change without notice. Every care has been taken as to its accuracy, but it must be appreciated that neither M&G nor its representatives can accept any responsibility for loss, however caused, suffered by any person who has acted or refrained from acting as a result of material contained in this calculator.\n\nPlease note that the tool uses Category A National Insurance. Any employment allowance which may be available is not taken into account. The employment allowance is not available for sole owner/directors.\n\nPlease note, this tool will cease to operate at the end of the tax year displayed above. \n\nTax legislation states that that the personal allowance may be deducted in the way which will result in the greatest reduction in the taxpayer's liability to income tax. The calculator however proceeds on the basis that it is offset firstly against non-savings income, then savings income and then dividend income. In particular circumstances, a different order may produce a more beneficial result for the individual."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cash Flows"]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pre Change",null,"After change",null,"Difference"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Individual"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Salary",{"$f":"F10","v":0},null,{"$f":"F29","v":0},null,{"$f":"T59-R59","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Plus Dividend received",{"$f":"F12","v":0},null,{"$f":"F31","v":0},null,{"$f":"T60-R60","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Less Income Tax ",{"$f":"' Tax'!F43","v":0},null,{"$f":"' Tax'!M43","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Less National Insurance",{"$f":"' Tax'!F54","v":0},null,{"$f":"' Tax'!M54","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Less Contributions gross",{"$f":"K6","v":0},null,{"$f":"K29","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Net Income",{"$f":"R59+R60-R61-R62-R63","v":0},null,{"$f":"T59+T60-T61-T62-T63","v":0},null,0]
[null,null,null,null,{"$f":"SUM(J49:J50)","v":0},null,null,null,null,null,null,null,null,null,null,null,"Less Contributions paid net",{"$f":"K8*(1-'Rates and Allowances'!B14)","v":0},null,{"$f":"K31*(1-'Rates and Allowances'!B14)","v":0},null,0,null,null,null,null,{"$f":"10395+K31","v":10395}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cash remaining",{"$f":"R64-R65","v":0},{"$f":"IF(R66<0,\"Warning Cashflow\",\"\")","v":""},{"$f":"T64-T65","v":0},null,0,null,"Personal Bank Account"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Employer"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Available Profits",{"$f":"F8","v":0},null,{"$f":"R70","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Less Dividend Paid",{"$f":"F12","v":0},null,{"$f":"F31","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Less Employer Pension Contribution",{"$f":"K12","v":0},null,{"$f":"K33","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Less Corporation Tax",{"$f":"'Corporation Tax'!E17","v":0},null,{"$f":"'Corporation Tax'!L17","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Less Salary Paid",{"$f":"F10","v":0},null,{"$f":"F29","v":0},null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Less Employers National Insurance",{"$f":"' Tax'!F79","v":0},null,{"$f":"' Tax'!M79","v":0},null,0]
[]
[null,null,null,{"$f":"Summary!F29+Summary!E65-Summary!K29-Summary!K31","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Profit remaining",{"$f":"R70-R71-R72-R73-R74-R75","v":0},{"$f":"IF(R77<0,\"Warning Cashflow\",\"\")","v":""},{"$f":"T70-T71-T72-T73-T74-T75","v":0},null,0,null,"Business Bank Account"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pension Contributions",{"$f":"K12+K6+K8","v":0},null,{"$f":"K25+K12+K19+K6+K21+K8","v":0},null,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"HMRC total take",{"$f":"R75+R73+R62+R61-(K8-R65)","v":0},null,{"$f":"T75+T73+T62+T61-(K31-T65)","v":0},null,0,null,"HMRC's Bank Account"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Individual"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Before","After"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pension",{"$f":"K6+K8+K12","v":0},{"$f":"K6+K8+K19+K21+K12+K25","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tax/NI Paid to HMRC",{"$f":"R61+R62","v":0},{"$f":"T61+T62","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"In bank account",{"$f":"R64-R65","v":0},{"$f":"T64-T65","v":0}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pension","Tax/NI Paid to HMRC","In bank account"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Before",{"$f":"R101","v":0},{"$f":"R102","v":0},{"$f":"R103","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"After",{"$f":"S101","v":0},{"$f":"S102","v":0},{"$f":"S103","v":0}]

{"sheet":" Tax","index":3,"n_rows":79,"n_cols":18,"rows_kept":79,"cut":false,"hidden":false,"merged":[[57,7,57,12],[57,1,57,6],[1,1,1,6],[1,8,1,13],[4,16,5,17],[0,8,0,9],[0,1,0,4],[3,1,3,6],[3,8,3,13]]}
[null,"Extracting Company Profits Tool\nbuilt by M&G",null,null,null,null,null,null,null,null,null,{"$f":"Summary!Q1","v":"Tax Year 2025/26"}]
[null,"Pre change Position",null,null,null,null,null,null,"After change Position"]
[]
[null,"Individual",null,null,null,null,null,null,"Individual"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"KEEP"]
[null,"Allowances",null,null,null,null,null,null,"Allowances"]
[null,"Adjusted Net Income (for allowance purposes)",{"$f":"Summary!F10+Summary!F12-Summary!K6-Summary!K8","v":0},null,null,null,null,null,{"$f":"B7","v":"Adjusted Net Income (for allowance purposes)"},{"$f":"Summary!F29+Summary!F31-Summary!K29-Summary!K31","v":0},null,null,null,null,null,null,{"$f":"C7-'Rates and Allowances'!B3","v":-100000},{"$f":"J7-'Rates and Allowances'!B3","v":-100000}]
[]
[null,"Personal Allowance",{"$f":"'Rates and Allowances'!B2","v":12570},null,null,null,null,null,{"$f":"B9","v":"Personal Allowance"},{"$f":"C9","v":12570}]
[null,"Adjustment",{"$f":"IF(Q7<1,0,(IF(Q7>(2*'Rates and Allowances'!B2),-C9,MAX(-C9,Q7/-2))))","v":0},null,null,null,null,null,{"$f":"B10","v":"Adjustment"},{"$f":"IF(R7<1,0,(IF(R7>(2*'Rates and Allowances'!B2),-J9,MAX(-J9,R7/-2))))","v":0}]
[]
[]
[]
[null,"Total Allowance",{"$f":"C9+C10","v":12570},null,null,null,null,null,{"$f":"B14","v":"Total Allowance"},{"$f":"J9+J10","v":12570}]
[]
[null,"Tax Calculation",null,null,null,null,null,null,{"$f":"B16","v":"Tax Calculation"}]
[]
[null,"Income",null,null,{"$f":"Summary!F10+Summary!F12","v":0},null,null,null,{"$f":"B18","v":"Income"},null,null,null,{"$f":"Summary!F29+Summary!F31","v":0}]
[null,"Less ",null,null,null,null,null,null,{"$f":"B19","v":"Less "}]
[null,"Contributions Paid Gross",{"$f":"Summary!K6","v":0},null,null,null,null,null,{"$f":"B20","v":"Contributions Paid Gross"},null,null,{"$f":"Summary!K29","v":0}]
[null,"Allowance",{"$f":"' Tax'!C14","v":12570},null,{"$f":"SUM(C20:C21)","v":12570},null,null,null,{"$f":"B21","v":"Allowance"},null,null,{"$f":"J14","v":12570},{"$f":"SUM(L20:L21)","v":12570}]
[null,"Taxable Income",null,null,{"$f":"MAX(0,E18-E21)","v":0},null,null,null,{"$f":"B22","v":"Taxable Income"},null,null,null,{"$f":"MAX(0,M18-M21)","v":0}]
[]
[]
[null,"Income - Salary",{"$f":"Summary!F10","v":0},null,null,null,null,null,{"$f":"B25","v":"Income - Salary"},{"$f":"Summary!F29","v":0}]
[null,{"$f":"IF(Summary!$F$6=Summary!$AA$3,'Rates and Allowances'!A13,\"\")","v":""},{"$f":"'Workings(Inc Tax)'!F7","v":0},"@",{"$f":"'Rates and Allowances'!B13","v":0},{"$f":"C26*E26","v":0},null,null,{"$f":"IF(Summary!$F$6=Summary!$AA$3,'Rates and Allowances'!A13,\"\")","v":""},{"$f":"'Workings(Inc Tax)'!L7","v":0},"@",{"$f":"E26","v":0},{"$f":"J26*L26","v":0}]
[null,{"$f":"IF(Summary!$F$6=Summary!$AA$3,'Rates and Allowances'!A14,\"\")","v":""},{"$f":"IF(Summary!F6=Summary!AA4,0,'Workings(Inc Tax)'!F8)","v":0},"@",{"$f":"'Rates and Allowances'!B14","v":0.2},0,null,null,{"$f":"IF(Summary!$F$6=Summary!$AA$3,'Rates and Allowances'!A14,\"\")","v":""},{"$f":"IF(Summary!F6=Summary!AA4,0,'Workings(Inc Tax)'!L8)","v":0},"@",{"$f":"'Rates and Allowances'!B14","v":0.2},0]
[null,{"$f":"IF(Summary!$F$6=Summary!$AA$3,'Rates and Allowances'!A15,'Rates and Allowances'!A14)","v":"Basic rate"},{"$f":"IF(Summary!$F$6=Summary!$AA$3,'Workings(Inc Tax)'!F9,'Workings(Inc Tax)'!F8)","v":0},"@",{"$f":"IF(Summary!$F$6=Summary!$AA$3,'Rates and Allowances'!B15,'Rates and Allowances'!B14)","v":0.2},0,null,null,{"$f":"B28","v":"Basic rate"},{"$f":"IF(Summary!$F$6=Summary!$AA$3,'Workings(Inc Tax)'!L9,'Workings(Inc Tax)'!L8)","v":0},"@",{"$f":"IF(Summary!F6=Summary!AA4,'Rates and Allowances'!B14,'Rates and Allowances'!B15)","v":0.2},{"$f":"J28*L28","v":0}]
[null,{"$f":"'Rates and Allowances'!A16","v":"Higher rate"},{"$f":"IF(Summary!$F$6=Summary!$AA$3,'Workings(Inc Tax)'!F10,'Workings(Inc Tax)'!F11)","v":0},"@",{"$f":"'Rates and Allowances'!B16","v":0.4},0,null,null,{"$f":"B29","v":"Higher rate"},{"$f":"IF(Summary!$F$6=Summary!$AA$3,'Workings(Inc Tax)'!L10,'Workings(Inc Tax)'!L11)","v":0},"@",{"$f":"E29","v":0.4},{"$f":"J29*L29","v":0}]
[null,{"$f":"IF(Summary!$F$6=Summary!$AA$3,'Rates and Allowances'!A17,'Rates and Allowances'!A18)","v":"Additional Rate"},{"$f":"IF(Summary!$F$6=Summary!$AA$3,'Workings(Inc Tax)'!F11,'Workings(Inc Tax)'!D12)","v":0},"@",{"$f":"IF(Summary!$F$6=Summary!$AA$3,'Rates and Allowances'!B17,'Rates and Allowances'!B18)","v":0.45},0,null,null,{"$f":"B30","v":"Additional Rate"},{"$f":"IF(Summary!$F$6=Summary!$AA$3,'Workings(Inc Tax)'!L11,'Workings(Inc Tax)'!J12)","v":0},"@",{"$f":"E30","v":0.45},{"$f":"J30*L30","v":0}]
[null,{"$f":"IF(Summary!$F$6=Summary!$AA$3,'Rates and Allowances'!A18,\"\")","v":""},{"$f":"IF(Summary!$F$6=Summary!$AA$3,'Workings(Inc Tax)'!D12,0)","v":0},"@",{"$f":"IF(Summary!$F$6=Summary!$AA$3,'Rates and Allowances'!B18,'Rates and Allowances'!B19)","v":0},0,{"$f":"SUM(F26:F31)","v":0},null,"",{"$f":"IF(Summary!$F$6=Summary!$AA$3,'Workings(Inc Tax)'!J12,0)","v":0},"@",{"$f":"IF(Summary!M9=Summary!AH7,'Rates and Allowances'!I18,'Rates and Allowances'!I19)","v":0.48},{"$f":"J31*L31","v":0},{"$f":"SUM(M26:M31)","v":0}]
[]
[null,"Income - Dividend",{"$f":"Summary!F12","v":0},null,null,null,null,null,{"$f":"B33","v":"Income - Dividend"}]
[]
[null,{"$f":"'Rates and Allowances'!A25","v":"Zero Rate"},{"$f":"'Workings(Inc Tax)'!F18","v":0},"@",{"$f":"'Rates and Allowances'!B25","v":0},{"$f":"C35*E35","v":0},null,null,{"$f":"B35","v":"Zero Rate"},{"$f":"'Workings(Inc Tax)'!L18","v":0},"@",{"$f":"E35","v":0},{"$f":"J35*L35","v":0}]
[null,{"$f":"'Rates and Allowances'!A26","v":"Basic Rate"},{"$f":"'Workings(Inc Tax)'!F19","v":0},"@",{"$f":"'Rates and Allowances'!B26","v":8.7499999999999994E-2},{"$f":"C36*E36","v":0},null,null,{"$f":"B36","v":"Basic Rate"},{"$f":"'Workings(Inc Tax)'!L19","v":0},"@",{"$f":"E36","v":8.7499999999999994E-2},{"$f":"J36*L36","v":0}]
[null,{"$f":"'Rates and Allowances'!A27","v":"Higher Rate"},{"$f":"'Workings(Inc Tax)'!F20","v":0},"@",{"$f":"'Rates and Allowances'!B27","v":0.33750000000000002},{"$f":"C37*E37","v":0},null,null,{"$f":"B37","v":"Higher Rate"},{"$f":"'Workings(Inc Tax)'!L20","v":0},"@",{"$f":"E37","v":0.33750000000000002},{"$f":"J37*L37","v":0}]
[null,{"$f":"'Rates and Allowances'!A28","v":"Additional Rate"},{"$f":"'Workings(Inc Tax)'!F21","v":0},"@",{"$f":"'Rates and Allowances'!B28","v":0.39350000000000002},{"$f":"C38*E38","v":0},{"$f":"SUM(F36:F38)","v":0},null,{"$f":"B38","v":"Additional Rate"},{"$f":"'Workings(Inc Tax)'!L21","v":0},"@",{"$f":"E38","v":0.39350000000000002},{"$f":"J38*L38","v":0},{"$f":"SUM(M36:M38)","v":0}]
[]
[]
[]
[]
[null,"Tax to pay",null,null,null,{"$f":"G31+G38","v":0},null,null,"Tax to pay",null,null,null,{"$f":"N31+N38","v":0}]
[]
[]
[]
[null,"Employee National Insurance",null,null,null,null,null,null,"National Insurance"]
[]
[]
[null,"`- to Primary Threshold",{"$f":"MIN(C25,'Rates and Allowances'!C42)","v":0},"@",0,0,null,null,"`- to Primary Threshold",{"$f":"MIN(J25,'Rates and Allowances'!C42)","v":0},"@",0,0]
[null,"` - Primary Threshold to Upper Earnings Limit",{"$f":"IF(C25=0,0,IF(C50+'Rates and Allowances'!E42<' Tax'!C25,'Rates and Allowances'!E42,' Tax'!C25-' Tax'!C50))","v":0},"@",{"$f":"'Rates and Allowances'!B44","v":0.08},{"$f":"C51*E51","v":0},null,null,"` - Primary Threshold to Upper Earnings Limit",{"$f":"IF(J25=0,0,IF((J50+'Rates and Allowances'!E42)<' Tax'!J25,'Rates and Allowances'!E42,' Tax'!J25-' Tax'!J50))","v":0},"@",{"$f":"E51","v":0.08},{"$f":"J51*L51","v":0}]
[null,"`- over Upper Earnings Limit",{"$f":"MAX(0,C25-'Rates and Allowances'!C41)","v":0},"@",{"$f":"'Rates and Allowances'!B45","v":0.02},{"$f":"C52*E52","v":0},null,null,"`- over Upper Earnings Limit",{"$f":"MAX(0,J25-'Rates and Allowances'!C41)","v":0},"@",{"$f":"E52","v":0.02},{"$f":"J52*L52","v":0}]
[]
[null,null,null,null,"Total",{"$f":"SUM(F50:F53)","v":0},null,null,null,null,null,"Total",{"$f":"SUM(M50:M53)","v":0}]
[]
[]
[]
[null,"Employer",null,null,null,null,null,"Employer"]
[]
[null,"Total profit",{"$f":"Summary!F8","v":0},null,null,null,null,null,{"$f":"B60","v":"Total profit"},{"$f":"C60","v":0}]
[]
[null,"Salary Paid",{"$f":"C25","v":0},null,null,null,null,null,{"$f":"B62","v":"Salary Paid"},{"$f":"J25","v":0}]
[null,"NI Paid (see below for calculations)",{"$f":"F79","v":0},null,null,null,null,null,"NI Paid (see below for calculations)",{"$f":"M79","v":0}]
[null,"Pension Paid",{"$f":"Summary!K12","v":0},null,null,null,null,null,"Pension Paid",{"$f":"Summary!K33","v":0}]
[]
[null,"Total Subject to Corporation Tax",{"$f":"MAX(0,C60-C62-C63-C64)","v":0},null,null,null,null,null,{"$f":"B66","v":"Total Subject to Corporation Tax"},{"$f":"MAX(0,J60-J62-J63-J64)","v":0}]
[]
[null,{"$f":"'Corporation Tax'!A14","v":"Small Profits Rate"},{"$f":"'Corporation Tax'!B14","v":0},"@",{"$f":"'Rates and Allowances'!C34","v":0.19},{"$f":"C68*E68","v":0},null,null,{"$f":"B68","v":"Small Profits Rate"},{"$f":"'Corporation Tax'!I14","v":0},{"$f":"D68","v":"@"},{"$f":"E68","v":0.19},{"$f":"J68*L68","v":0}]
[null,{"$f":"'Corporation Tax'!A15","v":"Marginal Rate"},{"$f":"'Corporation Tax'!B15","v":0},"@",{"$f":"'Rates and Allowances'!C35","v":0.26500000000000001},{"$f":"C69*E69","v":0},null,null,{"$f":"B69","v":"Marginal Rate"},{"$f":"'Corporation Tax'!I15","v":0},{"$f":"D69","v":"@"},{"$f":"E69","v":0.26500000000000001},{"$f":"J69*L69","v":0}]
[null,{"$f":"'Corporation Tax'!A16","v":"Main Rate"},{"$f":"'Corporation Tax'!B16","v":0},"@",{"$f":"'Rates and Allowances'!C36","v":0.25},0,null,null,"Main Rate",{"$f":"'Corporation Tax'!I16","v":0},"@",0.25,0]
[null,null,null,null,null,{"$f":"SUM(F68:F70)","v":0},null,null,null,null,null,null,{"$f":"SUM(M68:M70)","v":0}]
[]
[null,"Effective Rate of Corporation Tax",null,null,null,{"$f":"F71/C66","v":{"$error":"#DIV/0!"}},null,null,"Effective Rate of Corporation Tax",null,null,null,{"$f":"M71/J66","v":{"$error":"#DIV/0!"}}]
[null,null,null,null," "]
[null,"Employer National Insurance",null,null,null,null,null,null,"Employer National Insurance"]
[null,null,"Amount",null,"Rate","NI Payable",null,null,null,"Amount",null,"Rate","NI Payable"]
[null,"`- to Secondary Threshold",{"$f":"MIN(C25,'Rates and Allowances'!$C$43)","v":0},"@",0,{"$f":"C77*E77","v":0},null,null,"`- to Secondary Threshold",{"$f":"MIN(J25,'Rates and Allowances'!$C$43)","v":0},"@",0,{"$f":"J77*L77","v":0}]
[null,"`- over Secondary Threshold",{"$f":"MAX(C25-'Rates and Allowances'!C43,0)","v":0},"@",{"$f":"'Rates and Allowances'!B46","v":0.15},{"$f":"C78*E78","v":0},null,null,"`- over Secondary Threshold",{"$f":"MAX(J25-'Rates and Allowances'!C43,0)","v":0},"@",{"$f":"E78","v":0.15},{"$f":"J78*L78","v":0}]
[null,null,null,null,null,{"$f":"SUM(F77:F78)","v":0},null,null,null,null,null,null,{"$f":"SUM(M77:M78)","v":0}]

{"sheet":"Corporation Tax","index":4,"n_rows":17,"n_cols":12,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["Pre change Position",null,null,null,null,null,null,"After change"]
[]
["Taxable Profit (before Salary, NI and Employer Pension Contribution)",null,null,null,{"$f":"Summary!F8","v":0},null,null,"Taxable Profit (before Salary, NI and Employer Pension Contribution)",null,null,null,{"$f":"E3","v":0}]
[]
["Less                                                                         Salary",null,null,{"$f":"Summary!F10","v":0},null,null,null,"Less                                                         Salary",null,null,{"$f":"Summary!F29","v":0}]
["Employers National Insurance",null,null,{"$f":"' Tax'!F78","v":0},null,null,null,"Employers National Insurance",null,null,{"$f":"' Tax'!M78","v":0}]
["Employer Pension Contribution",null,null,{"$f":"Summary!K12","v":0},{"$f":"SUM(D5:D7)","v":0},null,null,"Employer Pension Contribution",null,null,{"$f":"Summary!K33","v":0},{"$f":"SUM(K5:K7)","v":0}]
["Taxable Profit",null,null,null,{"$f":"E3-E7","v":0},null,null,"Taxable Profit",null,null,null,{"$f":"L3-L7","v":0}]
[]
["NB: Dividends are not an allowable expense",null,null,null,null,null,null,"NB: Dividends are not an allowable expense"]
[]
[]
[]
[{"$f":"'Rates and Allowances'!A34","v":"Small Profits Rate"},{"$f":"IF(E8>'Rates and Allowances'!$B$36,0,(MIN('Rates and Allowances'!$B$34,'Corporation Tax'!E8)))","v":0},"@",{"$f":"'Rates and Allowances'!C34","v":0.19},{"$f":"B14*D14","v":0},null,null,{"$f":"A14","v":"Small Profits Rate"},{"$f":"IF(L8>'Rates and Allowances'!$B$36,0,(MIN('Rates and Allowances'!$B$34,'Corporation Tax'!L8)))","v":0},"@",{"$f":"D14","v":0.19},{"$f":"I14*K14","v":0}]
[{"$f":"'Rates and Allowances'!A35","v":"Marginal Rate"},{"$f":"IF(E8>'Rates and Allowances'!$B$36,0,MAX(0,'Corporation Tax'!E8-'Rates and Allowances'!$B$34))","v":0},"@",{"$f":"'Rates and Allowances'!C35","v":0.26500000000000001},{"$f":"B15*D15","v":0},null,null,{"$f":"A15","v":"Marginal Rate"},{"$f":"IF(L8>'Rates and Allowances'!$B$36,0,MAX(0,'Corporation Tax'!L8-'Rates and Allowances'!$B$34))","v":0},"@",{"$f":"D15","v":0.26500000000000001},{"$f":"I15*K15","v":0}]
[{"$f":"'Rates and Allowances'!A36","v":"Main Rate"},{"$f":"IF(E8>'Rates and Allowances'!$B$36,'Corporation Tax'!E8,0)","v":0},"@",{"$f":"'Rates and Allowances'!C36","v":0.25},0,null,null,{"$f":"A16","v":"Main Rate"},{"$f":"IF(L8>'Rates and Allowances'!$B$36,'Corporation Tax'!L8,0)","v":0},"@",0.25,0]
["Tax to pay",null,null,null,{"$f":"MAX(0,SUM(E14:E16))","v":0},null,null,"Tax to pay",null,null,null,{"$f":"MAX(0,SUM(L14:L16))","v":0}]

{"sheet":"Graph Data","index":5,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
[null,"Pre change Position","After change"]
["Income Tax",{"$f":"Summary!R61","v":0},{"$f":"Summary!T61","v":0}]
["Employee NI",{"$f":"Summary!R62","v":0},{"$f":"' Tax'!M54","v":0}]
["Employer NI",{"$f":"Summary!R75","v":0},{"$f":"' Tax'!M79","v":0}]
["Corporation Tax",{"$f":"Summary!R73","v":0},{"$f":"'Corporation Tax'!L17","v":0}]
["Profit remaining",{"$f":"Summary!R77","v":0},{"$f":"Summary!T77","v":0}]
["Cash remaining",{"$f":"Summary!R66","v":0},{"$f":"Summary!T66","v":0}]
["Pension Fund",{"$f":"Summary!K6+Summary!K8+Summary!K12","v":0},{"$f":"Summary!K29+Summary!K31+Summary!K33","v":0}]
[]
[null,"Pre change Position","After change"]
["Taxes and NI",{"$f":"B2+B3+B4+B5-(Summary!K8*'Rates and Allowances'!B13)","v":0},{"$f":"C2+C3+C4+C5-((Summary!K31*'Rates and Allowances'!B13))","v":0}]
["Cash and Profit",{"$f":"B7+B6","v":0},{"$f":"C7+C6","v":0}]
["Pension",{"$f":"B8","v":0},{"$f":"C8","v":0}]
[]
[null,{"$f":"SUM(B11:B14)","v":0},{"$f":"SUM(C11:C14)","v":0}]

{"sheet":"New Format for output","index":6,"n_rows":34,"n_cols":22,"rows_kept":34,"cut":false,"hidden":true,"merged":[[1,5,1,6],[10,5,10,6],[3,17,3,18],[3,20,3,21]]}
["Short Summary",null,null,null,null,null,null,"Button to expand this"]
[null,"Pre Change",null,"After change",null,"Difference"]
[]
["Individual Bank Account",{"$f":"B21","v":0},null,{"$f":"D21","v":0},null,{"$f":"F21","v":0},{"$f":"IF((B4-D4)=0,\"No change\",(IF(AND(B4=0,D4>0),\"Infinite Increase\",(D4/B4)-1)))","v":"No change"},null,null,null,null,"Individual",null,null,null,null,null,"Individual",null,null,"Company"]
["Company Bank Account",{"$f":"B31","v":0},null,{"$f":"D31","v":0},null,{"$f":"F31","v":0},{"$f":"IF((B5-D5)=0,\"No change\",(IF(AND(B5=0,D5>0),\"Infinite Increase\",(D5/B5)-1)))","v":"No change"},null,null,null,null,"Before","After",null,null,null,null,"Before","After",null,"Before","After"]
["Pension Contributions",{"$f":"B34","v":0},null,{"$f":"D34","v":0},null,{"$f":"F34","v":0},{"$f":"IF((B6-D6)=0,\"No change\",(IF(AND(B6=0,D6>0),\"Infinite Increase\",(D6/B6)-1)))","v":"No change"},null,null,null,"Pension",{"$f":"B6","v":0},{"$f":"D6","v":0},null,null,null,"Pension",{"$f":"L6","v":0},0]
[{"$f":"Summary!Q90","v":"HMRC total take"},{"$f":"Summary!R90","v":0},null,{"$f":"Summary!T90","v":0},null,{"$f":"Summary!V90","v":0},{"$f":"IF((B7-D7)=0,\"No change\",(IF(AND(B7=0,D7>0),\"Infinite Increase\",(D7/B7)-1)))","v":"No change"},null,null,null,"Tax/NI Paid to HMRC",{"$f":"B16+B17-(B20/4)","v":0},{"$f":"D16+D17-(D20/4)","v":0},"In grey not to be displayed",null,null,"Tax/NI Paid to HMRC",0,0]
[null,null,null,null,null,null,null,null,null,null,"In bank account",{"$f":"B21","v":0},{"$f":"D21","v":0},null,null,null,"In bank account",0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tax/NI Paid to HMRC",null,null,null,{"$f":"L15","v":0},0]
["Detailed View",null,null,null,null,null,null,"Button to expand this",null,null,null,null,null,null,null,null,"In Company Bank Account",null,null,null,0,0]
[null,{"$f":"Summary!R56","v":"Pre Change"},null,{"$f":"Summary!T56","v":"After change"},null,{"$f":"Summary!V56","v":"Difference"},null,null,null,null,null,null,null,null,null,null,"Cost of Remuneration",null,null,null,0,0]
[{"$f":"Summary!Q57","v":"Individual"}]
[null,null,null,null,null,null,null,null,null,null,null,"Company"]
[{"$f":"Summary!Q59","v":"Salary"},{"$f":"Summary!R59","v":0},null,{"$f":"Summary!T59","v":0},null,{"$f":"Summary!V59","v":0},{"$f":"IF((B14-D14)=0,\"No change\",(IF(AND(B14=0,D14>0),\"Infinite Increase\",(D14/B14)-1)))","v":"No change"},null,null,null,null,"Before","After"]
[{"$f":"Summary!Q60","v":"Plus Dividend received"},{"$f":"Summary!R60","v":0},null,{"$f":"Summary!T60","v":0},null,{"$f":"Summary!V60","v":0},{"$f":"IF((B15-D15)=0,\"No change\",(IF(AND(B15=0,D15>0),\"Infinite Increase\",(D15/B15)-1)))","v":"No change"},null,null,null,"Tax/NI Paid to HMRC",{"$f":"B28+B30","v":0},{"$f":"D28+D30","v":0}]
[{"$f":"Summary!Q61","v":"Less Income Tax "},{"$f":"Summary!R61","v":0},null,{"$f":"Summary!T61","v":0},null,{"$f":"Summary!V61","v":0},"No change",null,null,null,"In Company Bank Account",{"$f":"B31","v":0},{"$f":"D31","v":0}]
[{"$f":"Summary!Q62","v":"Less National Insurance"},{"$f":"Summary!R62","v":0},null,{"$f":"Summary!T62","v":0},null,{"$f":"Summary!V62","v":0},"No change",null,null,null,"Cost of Remuneration",{"$f":"B27+B29+B26","v":0},{"$f":"D27+D29+D26","v":0}]
[{"$f":"Summary!Q63","v":"Less Contributions gross"},{"$f":"Summary!R63","v":0},null,{"$f":"Summary!T63","v":0},null,{"$f":"Summary!V63","v":0},"No change"]
[{"$f":"Summary!Q64","v":"Net Income"},{"$f":"Summary!R64","v":0},null,{"$f":"Summary!T64","v":0},null,{"$f":"Summary!V64","v":0},"No change"]
[{"$f":"Summary!Q65","v":"Less Contributions paid net"},{"$f":"Summary!R65","v":0},null,{"$f":"Summary!T65","v":0},null,{"$f":"Summary!V65","v":0},"No change"]
[{"$f":"Summary!Q66","v":"Cash remaining"},{"$f":"Summary!R66","v":0},null,{"$f":"Summary!T66","v":0},null,{"$f":"Summary!V66","v":0},"No change"]
[]
[{"$f":"Summary!Q68","v":"Employer"}]
[]
[{"$f":"Summary!Q70","v":"Available Profits"},{"$f":"Summary!R70","v":0},null,{"$f":"Summary!T70","v":0},null,{"$f":"Summary!V70","v":0},{"$f":"IF((B25-D25)=0,\"No change\",(IF(AND(B25=0,D25>0),\"Infinite Increase\",(D25/B25)-1)))","v":"No change"}]
[{"$f":"Summary!Q71","v":"Less Dividend Paid"},{"$f":"Summary!R71","v":0},null,{"$f":"Summary!T71","v":0},null,{"$f":"Summary!V71","v":0},"No change"]
[{"$f":"Summary!Q72","v":"Less Employer Pension Contribution"},{"$f":"Summary!R72","v":0},null,{"$f":"Summary!T72","v":0},null,{"$f":"Summary!V72","v":0},"No change"]
[{"$f":"Summary!Q73","v":"Less Corporation Tax"},{"$f":"Summary!R73","v":0},null,{"$f":"Summary!T73","v":0},null,{"$f":"Summary!V73","v":0},"No change"]
[{"$f":"Summary!Q74","v":"Less Salary Paid"},{"$f":"Summary!R74","v":0},null,{"$f":"Summary!T74","v":0},null,{"$f":"Summary!V74","v":0},"No change"]
[{"$f":"Summary!Q75","v":"Less Employers National Insurance"},{"$f":"Summary!R75","v":0},null,{"$f":"Summary!T75","v":0},null,{"$f":"Summary!V75","v":0},{"$f":"IF((B30-D30)=0,\"No change\",(IF(AND(B30=0,D30>0),\"Infinite Increase\",(D30/B30)-1)))","v":"No change"}]
[{"$f":"Summary!Q77","v":"Profit remaining"},{"$f":"Summary!R77","v":0},null,{"$f":"Summary!T77","v":0},null,{"$f":"Summary!V77","v":0},"No change"]
[]
[]
[{"$f":"Summary!Q80","v":"Pension Contributions"},{"$f":"Summary!R80","v":0},null,{"$f":"Summary!T80","v":0},null,{"$f":"Summary!V80","v":0},{"$f":"IF((B34-D34)=0,\"No change\",(IF(AND(B34=0,D34>0),\"Infinite Increase\",(D34/B34)-1)))","v":"No change"}]