{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Cash Budget"],"not_rendered":{"images":1,"defined_names":21,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Cash Budget","index":0,"n_rows":200,"n_cols":53,"rows_kept":200,"merged":[[26,1,26,15]]}
[]
[]
[]
[null,"Cash Budget"]
[null,"For Jul-2009 through Jun-2010"]
[]
[null,null,"Jul",{"$f":"INDEX(AP199:BA200,1,AQ200+1)","v":"Aug"},{"$f":"INDEX(AP199:BA200,1,AR200+1)","v":"Sep"},{"$f":"INDEX(AP199:BA200,1,AS200+1)","v":"Oct"},{"$f":"INDEX(AP199:BA200,1,AT200+1)","v":"Nov"},{"$f":"INDEX(AP199:BA200,1,AU200+1)","v":"Dec"},{"$f":"INDEX(AP199:BA200,1,AV200+1)","v":"Jan"},{"$f":"INDEX(AP199:BA200,1,AW200+1)","v":"Feb"},{"$f":"INDEX(AP199:BA200,1,AX200+1)","v":"Mar"},{"$f":"INDEX(AP199:BA200,1,AY200+1)","v":"Apr"},{"$f":"INDEX(AP199:BA200,1,AZ200+1)","v":"May"},{"$f":"INDEX(AP199:BA200,1,BA200+1)","v":"Jun"},null,"Total"]
[null,"Beginning cash balance",{"v":935,"d":"$935"},{"$f":"IF(ISNUMBER(C24),C24,\"\")","v":{"v":891,"d":"$891"}},{"v":928,"d":"$928"},{"v":895,"d":"$895"},{"v":889,"d":"$889"},{"v":939,"d":"$939"},{"v":952,"d":"$952"},{"v":927,"d":"$927"},{"v":920,"d":"$920"},{"v":909,"d":"$909"},{"v":977,"d":"$977"},{"v":927,"d":"$927"},null,{"$f":"IF(ISNUMBER(C8),C8,\"\")","v":{"v":935,"d":"$935"}}]
[null,"Cash from operations",{"v":125,"d":"125 "},{"v":218,"d":"218 "},{"v":141,"d":"141 "},{"v":156,"d":"156 "},{"v":211,"d":"211 "},{"v":161,"d":"161 "},{"v":155,"d":"155 "},{"v":187,"d":"187 "},{"v":167,"d":"167 "},{"v":246,"d":"246 "},{"v":132,"d":"132 "},{"v":184,"d":"184 "},null,{"$f":"IF(SUM(C9:N9),SUM(C9:N9),\"\")","v":{"v":2083,"d":"2,083 "}}]
[null,"Total Available Cash",{"$f":"IF(OR(C8<>0,C9),C8+C9,\"\")","v":{"v":1060,"d":"$1,060"}},{"$f":"IF(OR(ISNUMBER(D8),ISNUMBER(D9)),D8+D9,\"\")","v":{"v":1109,"d":"$1,109"}},{"v":1069,"d":"$1,069"},{"v":1051,"d":"$1,051"},{"v":1100,"d":"$1,100"},{"v":1100,"d":"$1,100"},{"v":1107,"d":"$1,107"},{"v":1114,"d":"$1,114"},{"v":1087,"d":"$1,087"},{"v":1155,"d":"$1,155"},{"v":1109,"d":"$1,109"},{"v":1111,"d":"$1,111"},null,{"$f":"IF(SUM(P8:P9),SUM(P8:P9),\"\")","v":{"v":3018,"d":"$3,018"}}]
[null,"Less:"]
[null,"   Capital expenditures",{"v":113,"d":"$113"},{"v":123,"d":"$123"},{"v":113,"d":"$113"},{"v":106,"d":"$106"},{"v":102,"d":"$102"},{"v":94,"d":"$94"},{"v":114,"d":"$114"},{"v":126,"d":"$126"},{"v":133,"d":"$133"},{"v":126,"d":"$126"},{"v":119,"d":"$119"},{"v":123,"d":"$123"},null,{"$f":"IF(SUM(C12:N12),SUM(C12:N12),\"\")","v":{"v":1392,"d":"$1,392"}}]
[null,"   Interest",{"v":20,"d":"20 "},{"v":26,"d":"26 "},{"v":24,"d":"24 "},{"v":25,"d":"25 "},{"v":21,"d":"21 "},{"v":22,"d":"22 "},{"v":27,"d":"27 "},{"v":29,"d":"29 "},{"v":20,"d":"20 "},{"v":27,"d":"27 "},{"v":23,"d":"23 "},{"v":29,"d":"29 "},null,{"$f":"IF(SUM(C13:N13),SUM(C13:N13),\"\")","v":{"v":293,"d":"293 "}}]
[null,"   Dividends",{"v":2,"d":"2 "},{"v":4,"d":"4 "},{"v":3,"d":"3 "},{"v":5,"d":"5 "},{"v":0,"d":"0 "},{"v":2,"d":"2 "},{"v":1,"d":"1 "},{"v":2,"d":"2 "},{"v":3,"d":"3 "},{"v":2,"d":"2 "},{"v":4,"d":"4 "},{"v":5,"d":"5 "},null,{"$f":"IF(SUM(C14:N14),SUM(C14:N14),\"\")","v":{"v":33,"d":"33 "}}]
[null,"   Debt retirement",{"v":50,"d":"50 "},{"v":31,"d":"31 "},{"v":40,"d":"40 "},{"v":32,"d":"32 "},{"v":48,"d":"48 "},{"v":39,"d":"39 "},{"v":46,"d":"46 "},{"v":41,"d":"41 "},{"v":34,"d":"34 "},{"v":30,"d":"30 "},{"v":40,"d":"40 "},{"v":42,"d":"42 "},null,{"$f":"IF(SUM(C15:N15),SUM(C15:N15),\"\")","v":{"v":473,"d":"473 "}}]
[null,"   Other",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":2,"d":"2 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},null,{"$f":"IF(SUM(C16:N16),SUM(C16:N16),\"\")","v":{"v":2,"d":"2 "}}]
[null,"   Total Disbursements",{"$f":"IF(SUM(C12:C16),SUM(C12:C16),\"\")","v":{"v":185,"d":"$185"}},{"v":184,"d":"$184"},{"v":180,"d":"$180"},{"v":168,"d":"$168"},{"v":171,"d":"$171"},{"v":157,"d":"$157"},{"v":188,"d":"$188"},{"v":198,"d":"$198"},{"v":190,"d":"$190"},{"v":187,"d":"$187"},{"v":186,"d":"$186"},{"v":199,"d":"$199"},null,{"$f":"IF(SUM(P12:P16),SUM(P12:P16),\"\")","v":{"v":2193,"d":"$2,193"}}]
[null,"Cash Balance (Deficit)",{"$f":"IF(OR(SUM(C10),SUM(C17)),SUM(C10)-SUM(C17),\"\")","v":{"v":875,"d":"$875"}},{"v":925,"d":"$925"},{"v":889,"d":"$889"},{"v":883,"d":"$883"},{"v":929,"d":"$929"},{"v":943,"d":"$943"},{"v":919,"d":"$919"},{"v":916,"d":"$916"},{"v":897,"d":"$897"},{"v":968,"d":"$968"},{"v":923,"d":"$923"},{"v":912,"d":"$912"},null,{"$f":"IF(OR(SUM(P10),SUM(P17)),SUM(P10)-SUM(P17),\"\")","v":{"v":825,"d":"$825"}}]
[null,"Add:"]
[null,"   Short-term loans",6,3,6,6,10,9,8,4,7,9,4,5,null,{"$f":"IF(SUM(C20:N20),SUM(C20:N20),\"\")","v":77}]
[null,"   Long-term loans",{"v":10,"d":"$10"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":5,"d":"$5"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},null,{"$f":"IF(SUM(C21:N21),SUM(C21:N21),\"\")","v":{"v":15,"d":"$15"}}]
[null,"   Capital stock issues",{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},null,{"$f":"IF(SUM(C22:N22),SUM(C22:N22),\"\")","v":""}]
[null,"   Total Additions",{"$f":"IF(SUM(C20:C22),SUM(C20:C22),\"\")","v":{"v":16,"d":"16 "}},{"v":3,"d":"3 "},{"v":6,"d":"6 "},{"v":6,"d":"6 "},{"v":10,"d":"10 "},{"v":9,"d":"9 "},{"v":8,"d":"8 "},{"v":4,"d":"4 "},{"v":12,"d":"12 "},{"v":9,"d":"9 "},{"v":4,"d":"4 "},{"v":5,"d":"5 "},null,{"$f":"IF(SUM(C23:N23),SUM(C23:N23),\"\")","v":{"v":92,"d":"92 "}}]
[null,"Ending Cash Balance",{"$f":"IF(OR(ISNUMBER(C18),ISNUMBER(C23)),SUM(C18)+SUM(C23),\"\")","v":{"v":891,"d":"$891"}},{"v":928,"d":"$928"},{"v":895,"d":"$895"},{"v":889,"d":"$889"},{"v":939,"d":"$939"},{"v":952,"d":"$952"},{"v":927,"d":"$927"},{"v":920,"d":"$920"},{"v":909,"d":"$909"},{"v":977,"d":"$977"},{"v":927,"d":"$927"},{"v":917,"d":"$917"},null,{"$f":"IF(OR(ISNUMBER(P18),ISNUMBER(P23)),SUM(P18)+SUM(P23),\"\")","v":{"v":917,"d":"$917"}}]
{"$rows_empty":173}
[{"$nulls":41},"MONTH TABLE: DO NOT CHANGE"]
[{"$nulls":41},"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
[{"$nulls":41},{"$f":"MATCH(PROPER(LEFT(TRIM(C7),3)),AP199:BA199,0)-1","v":6},{"$f":"IF(AP200=11,0,AP200+1)","v":7},8,9,10,11,0,1,2,3,4,5]