{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Interest -use tab button to use"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":1,"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":"Interest -use tab button to use","index":0,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[[24,9,25,9],[11,0,11,7],[1,0,1,3],[1,4,1,9],[11,8,11,9],[5,8,5,9],[7,8,7,9],[10,0,10,9],[24,8,25,8],[24,0,25,7],[12,0,12,9],[14,0,14,9],[6,0,6,9],[4,0,4,9],[2,0,2,9],[21,0,23,0],[6,11,8,11],[6,12,8,12],[0,0,0,2],[18,0,19,0],[16,4,16,6],[16,1,16,3],[3,4,3,9],[3,0,3,3],[9,0,9,7],[7,0,7,7],[5,0,5,7],[15,0,15,7],[13,0,13,7],[13,8,13,9],[15,8,15,9]]}
["Developed By - Rahul Fageria  ",null,null,null,"ऐ समन्दर मैं तुझसे वाकिफ हूं मगर इतना बताता हूं, वो आंखें तुझसे ज्यादा गहरी हैं जिनका मैं दीवाना हूं..!!",null,null,null,null,null,null,"Download Source- http://taxguru.in/"]
["07827920818- From Jhunjhunu Rajasthan",null,null,null,"rahulfageria@gmail.com"]
[]
["Service Tax Delayed Payment Interest calculation",null,null,null,"Fill Data only in the <-- cells "]
[null,null,null,null,null,null,null,null,null,null,null,"Total Tax",{"$f":"+I10+J10","v":3200}]
["Turnover During The Preceding Financial Year",null,null,null,null,null,null,null,0,null,"←","Total Interest",{"$f":"+I25+J25","v":761}]
[null,null,null,null,null,null,null,null,null,null,null,"Total Payable With Interest",{"$f":"SUM(M5:M6)","v":3961}]
["Concession of 3% in Rate of  Interest applicable or not ( Provision to section 75 of finance Act, 1994.)",null,null,null,null,null,null,null,{"$f":"IF(I6=0,\"N.A.\",IF(I6<=6000000,\"YES\",\"NO\"))","v":"N.A."}]
[null,null,null,null,null,null,null,null,"Service Tax","SBC"]
["Service Tax Payable",null,null,null,null,null,null,null,3000,200]
[]
["Due Date of Payment                                       (DD/MM/YEAR)",null,null,null,null,null,null,null,"2016-01-06",null,"←"]
[]
["Actual  Date of Payment                                 (DD/MM/YEAR)",null,null,null,null,null,null,null,"2017-02-06",null,"←"]
[]
["Total Period of Delay  (In Days)",null,null,null,null,null,null,null,{"$f":"($I$14-$I$12)","v":397}]
["Period of Delay","Rate of Simple Interest",null,null,"Interest for the period",null,null,"No. of days of delay"," Interest on Service Tax","Interest on SBC "]
[{"$f":"IF($I$16<=181,\"Upto 6 Months\",\"----\")","v":"----"},null,{"$f":"IF(D18>0%,D18,\"--\")","v":"--"},{"$f":"IF($A$18=\"upto 6 months\",IF($I$16<=181,IF($I$8=\"yes\",15%,18%)),0)","v":0},{"$f":"IF($A$18=\"Upto 6 months\",$I$12,\"----\")","v":"----"},{"$f":"IF(E18=\"----\",\"--\",\"To\")","v":"--"},{"$f":"IF($A$18=\"Upto 6 months\",$I$14,\"----\")","v":"----"},{"$f":"IF(G18=\"----\",\"----\",G18-E18)","v":"----"},{"$f":"IF(H18=\"----\",\"N.A.\",ROUNDUP($I$10*D18*H18/365,0))","v":"N.A."},{"$f":"+IF(H18=\"----\",\"N.A.\",ROUNDUP($J$10*D18*H18/365,0))","v":"N.A."}]
[{"$f":"IF(AND($I$16>181,$I$16<=365),\"More than 6 Months but upto 1 year\",\"----\")","v":"----"},{"$f":"IF($A$19=\"More than 6 months but upto 1 year\",\"For the first 6 months of delay\",\"----\")","v":"----"},{"$f":"IF(D19>0%,D19,\"--\")","v":"--"},{"$f":"IF(B19=\"for the first 6 months of delay\",IF($I$16>181,IF(I16<=365,IF(I8=\"yes\",15%,18%))),0)","v":0},{"$f":"IF($B$19=\"for the first 6 months of delay\",$I$12,\"----\")","v":"----"},{"$f":"IF(E19=\"----\",\"--\",\"To\")","v":"--"},{"$f":"IF($B$19=\"for the first 6 months of delay\",E19+181,\"----\")","v":"----"},{"$f":"IF(G19=\"----\",\"----\",G19-E19)","v":"----"},{"$f":"IF(H19=\"----\",\"N.A.\",ROUNDUP($I$10*D19*H19/365,0))","v":"N.A."},{"$f":"+IF(H19=\"----\",\"N.A.\",ROUNDUP($J$10*D19*H19/365,0))","v":"N.A."}]
[null,{"$f":"IF($A$19=\"More than 6 months but upto 1 year\",\"For the delay beyond 6 months but upto 1 year\",\"----\")","v":"----"},{"$f":"IF(D20>0%,D20,\"--\")","v":"--"},{"$f":"IF(B20=\"for the delay beyond 6 months but upto 1 year\",IF($I$16>181,IF(I16<=365,IF(I8=\"yes\",21%,24%))),0)","v":0},{"$f":"IF($B$20=\"For the delay beyond 6 months but upto 1 year\",$G$19,\"----\")","v":"----"},{"$f":"IF(E20=\"----\",\"--\",\"To\")","v":"--"},{"$f":"IF($B$20=\"For the delay beyond 6 months but upto 1 year\",$I$14,\"----\")","v":"----"},{"$f":"IF(G20=\"----\",\"----\",G20-E20)","v":"----"},{"$f":"IF(H20=\"----\",\"N.A.\",ROUNDUP($I$10*D20*H20/365,0))","v":"N.A."},{"$f":"+IF(H20=\"----\",\"N.A.\",ROUNDUP($J$10*D20*H20/365,0))","v":"N.A."}]
[]
[{"$f":"IF($I$16>365,\"More than 1 year\",\"----\")","v":"More than 1 year"},{"$f":"IF($A$22=\"more than 1 year\",\"For the first 6 months of delay\",\"----\")","v":"For the first 6 months of delay"},{"$f":"IF(D22>0%,D22,\"--\")","v":0.18},{"$f":"IF(B22=\"for the first 6 months of delay\",IF(I16>365,IF(I8=\"yes\",15%,18%)),0)","v":0.18},{"$f":"IF($B$22=\"For the first 6 months of delay\",$I$12,\"----\")","v":"2016-01-06"},{"$f":"IF(E22=\"----\",\"--\",\"To\")","v":"To"},{"$f":"IF($B$22=\"for the first 6 months of delay\",E22+181,\"----\")","v":"2016-07-05"},{"$f":"IF(G22=\"----\",\"----\",G22-E22)","v":181},{"$f":"IF(H22=\"----\",\"N.A.\",ROUNDUP($I$10*D22*H22/365,0))","v":268},{"$f":"+IF(H22=\"----\",\"N.A.\",ROUNDUP($J$10*D22*H22/365,0))","v":18}]
[null,{"$f":"IF($A$22=\"more than 1 year\",\"For the delay beyond 6 months but upto 1 year\",\"----\")","v":"For the delay beyond 6 months but upto 1 year"},{"$f":"IF(D23>0%,D23,\"--\")","v":0.24},{"$f":"IF(B23=\"for the delay beyond 6 months but upto 1 year\",IF($I$16>365,IF(I8=\"yes\",21%,24%)),0)","v":0.24},{"$f":"IF($B$23=\"For the delay beyond 6 months but upto 1 year\",$G$22,\"----\")","v":"2016-07-05"},{"$f":"IF(E23=\"----\",\"--\",\"To\")","v":"To"},{"$f":"IF($B$23=\"For the delay beyond 6 months but upto 1 year\",E23+181,\"----\")","v":"2017-01-02"},{"$f":"IF(G23=\"----\",\"----\",G23-E23)","v":181},{"$f":"IF(H23=\"----\",\"N.A.\",ROUNDUP($I$10*D23*H23/365,0))","v":358},{"$f":"+IF(H23=\"----\",\"N.A.\",ROUNDUP($J$10*D23*H23/365,0))","v":24}]
[null,{"$f":"IF($A$22=\"more than 1 year\",\"For any delay beyond 1 year\",\"----\")","v":"For any delay beyond 1 year"},{"$f":"IF(D24>0%,D24,\"--\")","v":0.3},{"$f":"IF(B24=\"for any delay beyond 1 year\",IF(I16>365,IF(I8=\"yes\",27%,30%)),0)","v":0.3},{"$f":"IF($B$24=\"For any delay beyond 1 year\",$G$23,\"----\")","v":"2017-01-02"},{"$f":"IF(E24=\"----\",\"--\",\"To\")","v":"To"},{"$f":"IF($B$24=\"For any delay beyond 1 year\",$I$14,\"----\")","v":"2017-02-06"},{"$f":"IF(G24=\"----\",\"----\",G24-E24)","v":35},{"$f":"IF(H24=\"----\",\"N.A.\",ROUNDUP($I$10*D24*H24/365,0))","v":87},{"$f":"+IF(H24=\"----\",\"N.A.\",ROUNDUP($J$10*D24*H24/365,0))","v":6}]
["TOTAL INTEREST",null,null,null,null,null,null,null,{"$f":"+SUM(I18:I24)","v":713},{"$f":"+SUM(J18:J24)","v":48}]