{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Schedule of Premium","NGAorGOCC","Increase in Bond","LGU-Brgy Chair.","SK"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":3,"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":"Schedule of Premium","index":0,"n_rows":39,"n_cols":4,"rows_kept":39,"cut":false,"hidden":false,"merged":[[35,2,38,2],[35,3,38,3]]}
[null,null,null,"ANNEX C"]
["REVISED SCHEDULE OF PREMIUM RATES"]
[]
["I CASH ACCOUNTABILITY"]
["MINIMUM CASH ACCOUNTABILITY","MAXIMUM CASH ACCOUNTABILITY","AMOUNT OF BOND","BOND PREMIUM"]
[5001,9000,"75% of their Total Cash Accountability","Bond Premium shall not be less than P150"]
[9001,12000,9000,150]
[12001,15000,11250,{"$f":"+C8*0.015","v":168.75}]
[15001,18000,13500,{"$f":"+C9*0.015","v":202.5}]
[18001,21000,16750,251.25]
[21001,25000,18900,283.5]
[25001,30000,22500,337.5]
[30001,35000,26250,393.75]
[35001,40000,30000,450]
[40001,50000,37500,562.5]
[50001,60000,45000,675]
[60001,80000,60000,900]
[80001,100000,75000,1125]
[100001,250000,100000,1500]
[250001,500000,225000,3375]
[500001,750000,350250,5253.75]
[750001,1000000,500000,7500]
[1000001,2500000,750000,11250]
[2500001,5000000,1500000,22500]
[5000001,25000000,3500000,52500]
[25000001,75000000,4000000,60000]
[75000001,100000000,5000000,75000]
[100000001,500000000,8000000,120000]
[500000001,1000000000,11000000,165000]
[]
["II PROPERTY ACCOUNTABILITY"]
["1. Property, Plant & Equipment (Net Book Value)",null,"30% of their Total Value","x 1.5% = Premium"]
["2. Inventories (per GAAM)",null,"50% of their Total Value","x 1.5% = Premium"]
[]
["III FOR ACCOUNTABLE FORMS"]
["a) Internal Revenue Stamp",null,"10% of their Total Value\nValue Rounded Off\nto the nearest hundred","x 1.5% = Premium"]
["b) Postage and other Standard Stamped Stock"]
["c) Official Receipt"]
["d) Other Accountable Forms and Valuables"]

{"sheet":"NGAorGOCC","index":1,"n_rows":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":false,"merged":[[6,2,6,3],[0,3,0,4]]}
[null,null,null,"Revised 10-2021"]
[]
[]
[]
[]
[]
[null,null,"BOND CALCULATOR FOR NGAs & GOCCs"]
[]
[null,null,"ACCOUNTABILITY"]
[null,null,"Public Funds"]
[null,null,"as Collecting Officer"]
[null,null,"as Disbursing Officer"]
[null,null,"as Signing Officer"]
[null,null,"Invesment Officer (GS Investments)"]
[null,null,"Public Property"]
[null,null,"Inventories (per GAAM)"]
[null,null,"Property, Plant & Equipment (Net Book Value)"]
[null,null,"Forms and other Valuables"]
[null,null,"Internal Revenue Stamps"]
[null,null,"Postage and Other Stamped Stock"]
[null,null,"Official Receipt"]
[null,null,"Other Forms and Valuables"]
[null,null,"TOTAL ACCOUNTABILITY",{"$f":"SUM(D11:D22)","v":0}]
[]
[null,null,"Amount of Bond",{"$f":"(IF(IFERROR(VLOOKUP(D12+D11+D13+D14,'Schedule of Premium'!$A$6:$C$29,3,TRUE),0)+ROUND((D16*0.5)+(D17*0.3)+(SUM(D19:D22)*0.1),-2)>11000000,11000000,IFERROR(VLOOKUP(D12+D11+D13+D14,'Schedule of Premium'!$A$6:$C$29,3,TRUE),0)+ROUND((D16*0.5)+(D17*0.3)+(SUM(D19:D22)*0.1),-2)))","v":0}]
[null,null,"Bond Premium",{"$f":"IF(D25*0.015<150,150,D25*0.015)","v":150}]

{"sheet":"Increase in Bond","index":2,"n_rows":28,"n_cols":4,"rows_kept":28,"cut":false,"hidden":false,"merged":[[6,2,6,3],[9,2,9,3],[0,3,0,4]]}
[null,null,null,"Revised 10-2021"]
[]
[]
[]
[]
[]
[null,null,"Increase in Amount of Bond:"]
[]
[null,null,"Name of Agency/Accountable Official:"]
[]
[]
[null,null,"Old Effectivity Date (mm/dd/yyyy)"]
[]
[null,null,"New Effectivity Date (mm/dd/yyyy)"]
[]
[null,null,"New Maturity Date",{"$f":"IF(D14=0,\" \",DATE(YEAR(D14)+1,MONTH(D14),DAY(D14)-1))","v":" "}]
[]
[null,null,"No. of Days Used",{"$f":"D14-D12","v":0}]
[null,null,"No. of Days Unused",{"$f":"IF(D18=0,0,(365-D18))","v":0}]
[]
[null,null,"Bond Premium:"]
[null,null,"Old"]
[null,null,"New"]
[]
[null,null,"Used Premium",{"$f":"+(D22/365)*D18","v":0}]
[null,null,"Unused Premium",{"$f":"+(D22/365)*D19","v":0}]
[]
[null,null,"Premium for Payment",{"$f":"+D23-D26","v":0}]

{"sheet":"LGU-Brgy Chair.","index":3,"n_rows":36,"n_cols":4,"rows_kept":36,"cut":false,"hidden":false,"merged":[[6,2,6,3],[9,2,9,3],[35,1,35,3],[34,1,34,3],[0,3,0,4]]}
[null,null,null,"Revised 05-2021"]
[]
[]
[]
[]
[]
[null,null,"BOND CALCULATOR FOR BRGY. CHAIRMAN & TREASURER"]
[]
[null,null,"Name of Barangay:"]
[]
[]
[null,null,"Annual Budget*"]
[null,null,"Property/Inventory"]
[null,null,"Supplies & Materials (if any)"]
[]
[null,null,"ACCOUNTABILITY"]
[null,null,"Cash Accountability**",{"$f":"((D12*0.9)/12)","v":0}]
[null,null,"Property Accountability",{"$f":"+D13","v":0}]
[null,null,"Supplies & Materials",{"$f":"+D14","v":0}]
[null,null,"TOTAL ACCOUNTABILITY",{"$f":"SUM(D17:D19)","v":0}]
[]
[null,null,"Brgy. Chairman:"]
[null,null,"Amount of Bond",{"$f":"IF(IFERROR(VLOOKUP(D17,'Schedule of Premium'!$A$6:$C$29,3,TRUE),0)+ROUND((D18*0.3),-2)+ROUND((D19*0.5),-2)>11000000,11000000,IFERROR(VLOOKUP(D17,'Schedule of Premium'!$A$6:$C$29,3,TRUE),0)+ROUND((D18*0.3),-2)+ROUND((D19*0.5),-2))","v":0}]
[null,null,"Bond Premium",{"$f":"IF(D23=0,0,(IF((D23*0.015)<150,150,(D23*0.015))))","v":0}]
[]
[null,null,"Brgy. Treasurer:"]
[null,null,"Amount of Bond",10000]
[null,null,"Bond Premium",{"$f":"+D27*0.015","v":150}]
[]
[null,null,"Brgy. Chairman & Treasurer:"]
[null,null,"TOTAL AMOUNT OF BOND",{"$f":"+D23+D27","v":10000}]
[null,null,"TOTAL BOND PREMIUM",{"$f":"+D24+D28","v":150}]
[]
[]
[null,"*Pls. input the Total Annual Budget per Brgy. Ordinance."]
[null,"**Cash Acountability is 90% of annual budget divided by 12 months"]

{"sheet":"SK","index":4,"n_rows":47,"n_cols":4,"rows_kept":47,"cut":false,"hidden":false,"merged":[[6,2,6,3],[9,2,9,3],[34,1,34,3],[0,3,0,4]]}
[null,null,null,"Revised 10-2021"]
[]
[]
[]
[]
[]
[null,null,"BOND CALCULATOR FOR SK CHAIRMAN & TREASURER"]
[]
[null,null,"Name of Barangay:"]
[]
[]
[null,null,"Annual Budget (SK)*"]
[null,null,"Property/Inventory (if any)"]
[null,null,"Supplies & Materials (if any)"]
[]
[null,null,"ACCOUNTABILITY"]
[null,null,"Cash Accountability",{"$f":"(D12/12)","v":0}]
[null,null,"Property Accountability",{"$f":"+D13","v":0}]
[null,null,"Supplies & Materials",{"$f":"+D14","v":0}]
[null,null,"TOTAL ACCOUNTABILITY",{"$f":"SUM(D17:D19)","v":0}]
[]
[null,null,"SK Chairman:"]
[null,null,"Amount of Bond",{"$f":"IFERROR(IF(IF(D17<9001,D17*0.75,IF(VLOOKUP(D17,'Schedule of Premium'!$A$7:$C$29,3,TRUE)>11000000,11000000,(VLOOKUP(D17,'Schedule of Premium'!$A$7:$C$29,3,TRUE))))+ROUND((D18*0.3),-2)+ROUND((D19*0.5),-2)>11000000,11000000,(IF(D17<9001,D17*0.75,IF(VLOOKUP(D17,'Schedule of Premium'!$A$7:$C$29,3,TRUE)>11000000,11000000,(VLOOKUP(D17,'Schedule of Premium'!$A$7:$C$29,3,TRUE))))+ROUND((D18*0.3),-2)+ROUND((D19*0.5),-2))),0)","v":0}]
[null,null,"Bond Premium",{"$f":"IF(D23=0,0,(IF((D23*0.015)<150,150,(D23*0.015))))","v":0}]
[]
[null,null,"SK Treasurer:"]
[null,null,"Amount of Bond",{"$f":"IFERROR(IF(D17<9001,D17*0.75,IF(VLOOKUP(D17,'Schedule of Premium'!$A$7:$C$29,3,TRUE)>11000000,11000000,(VLOOKUP(D17,'Schedule of Premium'!$A$7:$C$29,3,TRUE)))),0)","v":0}]
[null,null,"Bond Premium",{"$f":"IF(D27=0,0,(IF((D27*0.015)<150,150,(D27*0.015))))","v":0}]
[]
[null,null,"SK Chairman & Treasurer:"]
[null,null,"TOTAL AMOUNT OF BOND",{"$f":"+D23+D27","v":0}]
[null,null,"TOTAL BOND PREMIUM",{"$f":"+D24+D28","v":0}]
[]
[]
[null,"* SK Budget - pls. input the 10% of the Total General Fund per Barangay Ordinance"]
[]
[null,null,"Bond"]
[null,null,"Cash",{"$f":"IFERROR(IF(D17<9001,D17*0.75,IF(VLOOKUP(D17,'Schedule of Premium'!$A$7:$C$29,3,TRUE)>5000000,5000000,(VLOOKUP(D17,'Schedule of Premium'!$A$7:$C$29,3,TRUE)))),0)","v":0}]
[null,null,"Property 30%",{"$f":"+ROUND((D18*0.3),-2)","v":0}]
[null,null,"Supplies 50%",{"$f":"+ROUND((D19*0.5),-2)","v":0}]
[null,null,"Total",{"$f":"IFERROR(IF(D17<9001,D17*0.75,IF(VLOOKUP(D17,'Schedule of Premium'!$A$7:$C$29,3,TRUE)>5000000,5000000,(VLOOKUP(D17,'Schedule of Premium'!$A$7:$C$29,3,TRUE))))+ROUND((D18*0.3),-2)+ROUND((D19*0.5),-2),0)","v":0}]
[]
[null,null,"Premium"]
[null,null,"Cash",{"$f":"IF(D38<9001,150,IF(D38>5000000,5000000*0.015,D38*0.015))","v":150}]
[null,null,"Property",{"$f":"D39*0.015","v":0}]
[null,null,"Supplies",{"$f":"D40*0.015","v":0}]
[null,null,"Total",{"$f":"IF((IF(D38<9001,150,IF(D38>5000000,5000000*0.015,D38*0.015))+(D39*0.015)+(D40*0.015))>75000,75000,(IF(D38<9001,150,IF(D38>5000000,5000000*0.015,D38*0.015))+(D39*0.015)+(D40*0.015)))","v":150}]