{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Quarterly Cash Flow Projection"],"not_rendered":{"defined_names":28,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Quarterly Cash Flow Projection","index":0,"n_rows":213,"n_cols":19,"rows_kept":213,"merged":[[37,1,37,13]]}
[]
[]
[null,"Quarterly Cash Flow Projection"]
[null,"The ABC Corporation"]
[null,"First Quarter, 2010"]
[]
[{"$nulls":3},"JANUARY",{"$nulls":3},{"$f":"R198","v":"FEBRUARY"},{"$nulls":3},{"$f":"S198","v":"MARCH"}]
[null,"Cash Received",null,"Estimate","Actual","Variance",null,"Estimate","Actual","Variance",null,"Estimate","Actual","Variance"]
[null,"Beginning Cash Balance",null,{"v":52552,"d":"$52,552"},{"v":54530,"d":"$54,530"},{"$f":"IF(OR(D9>0,E9),D9-E9,\"\")","v":{"v":-1978,"d":"($1,978)"}},null,{"$f":"D35","v":{"v":36247,"d":"$36,247"}},{"$f":"E35","v":{"v":42762,"d":"$42,762"}},{"$f":"IF(AND(ISNUMBER(H9),ISNUMBER(I9)),H9-I9,\"\")","v":{"v":-6515,"d":"($6,515)"}},null,{"$f":"H35","v":{"v":33469,"d":"$33,469"}},{"$f":"I35","v":{"v":38955,"d":"$38,955"}},{"$f":"IF(AND(ISNUMBER(L9),ISNUMBER(M9)),L9-M9,\"\")","v":{"v":-5486,"d":"($5,486)"}}]
[null,"Cash Sales",null,{"v":23821,"d":"23,821 "},{"v":25485,"d":"25,485 "},{"$f":"IF(OR(D10>0,E10),D10-E10,\"\")","v":{"v":-1664,"d":"(1,664)"}},null,{"v":23819,"d":"23,819 "},{"v":26468,"d":"26,468 "},{"$f":"IF(OR(H10>0,I10),H10-I10,\"\")","v":{"v":-2649,"d":"(2,649)"}},null,{"v":25443,"d":"25,443 "},{"v":26780,"d":"26,780 "},{"$f":"IF(OR(L10>0,M10),L10-M10,\"\")","v":{"v":-1337,"d":"(1,337)"}}]
[null,"Collections",null,{"v":59014,"d":"59,014 "},{"v":61001,"d":"61,001 "},{"$f":"IF(OR(D11>0,E11),D11-E11,\"\")","v":{"v":-1987,"d":"(1,987)"}},null,{"v":62394,"d":"62,394 "},{"v":63666,"d":"63,666 "},{"$f":"IF(OR(H11>0,I11),H11-I11,\"\")","v":{"v":-1272,"d":"(1,272)"}},null,{"v":73702,"d":"73,702 "},{"v":69487,"d":"69,487 "},{"$f":"IF(OR(L11>0,M11),L11-M11,\"\")","v":{"v":4215,"d":"4,215 "}}]
[null,"Loans",null,{"v":15121,"d":"15,121 "},{"v":18452,"d":"18,452 "},{"$f":"IF(OR(D12>0,E12),D12-E12,\"\")","v":{"v":-3331,"d":"(3,331)"}},null,{"v":12329,"d":"12,329 "},{"v":19109,"d":"19,109 "},{"$f":"IF(OR(H12>0,I12),H12-I12,\"\")","v":{"v":-6780,"d":"(6,780)"}},null,{"v":14513,"d":"14,513 "},{"v":19452,"d":"19,452 "},{"$f":"IF(OR(L12>0,M12),L12-M12,\"\")","v":{"v":-4939,"d":"(4,939)"}}]
[null,null,"Total Cash Available  ",{"$f":"IF(SUM(D9:D12),SUM(D9:D12),\"\")","v":{"v":150508,"d":"$150,508"}},{"$f":"IF(SUM(E9:E12),SUM(E9:E12),\"\")","v":{"v":159468,"d":"$159,468"}},{"$f":"IF(SUM(F9:F12),SUM(F9:F12),\"\")","v":{"v":-8960,"d":"($8,960)"}},null,{"$f":"IF(SUM(H9:H12),SUM(H9:H12),\"\")","v":{"v":134789,"d":"$134,789"}},{"$f":"IF(SUM(I9:I12),SUM(I9:I12),\"\")","v":{"v":152005,"d":"$152,005"}},{"$f":"IF(SUM(J9:J12),SUM(J9:J12),\"\")","v":{"v":-17216,"d":"($17,216)"}},null,{"$f":"IF(SUM(L9:L12),SUM(L9:L12),\"\")","v":{"v":147127,"d":"$147,127"}},{"$f":"IF(SUM(M9:M12),SUM(M9:M12),\"\")","v":{"v":154674,"d":"$154,674"}},{"$f":"IF(SUM(N9:N12),SUM(N9:N12),\"\")","v":{"v":-7547,"d":"($7,547)"}}]
[null,"Cash Disbursed"]
[null,"Salaries and Wages",null,{"v":14752,"d":"$14,752"},{"v":15855,"d":"$15,855"},{"$f":"IF(OR(D15>0,E15),D15-E15,\"\")","v":{"v":-1103,"d":"($1,103)"}},null,{"v":12890,"d":"$12,890"},{"v":13659,"d":"$13,659"},{"$f":"IF(OR(H15>0,I15),H15-I15,\"\")","v":{"v":-769,"d":"($769)"}},null,{"v":15042,"d":"$15,042"},{"v":14150,"d":"$14,150"},{"$f":"IF(OR(L15>0,M15),L15-M15,\"\")","v":{"v":892,"d":"$892"}}]
[null,"Lease/Mortgage",null,{"v":1659,"d":"1,659 "},{"v":1659,"d":"1,659 "},{"v":0,"d":"0 "},null,{"v":1422,"d":"1,422 "},{"v":1776,"d":"1,776 "},{"v":-354,"d":"(354)"},null,{"v":1589,"d":"1,589 "},{"v":1778,"d":"1,778 "},{"v":-189,"d":"(189)"}]
[null,"Insurance",null,{"v":1041,"d":"1,041 "},{"v":1085,"d":"1,085 "},{"v":-44,"d":"(44)"},null,{"v":956,"d":"956 "},{"v":1175,"d":"1,175 "},{"v":-219,"d":"(219)"},null,{"v":980,"d":"980 "},{"v":1328,"d":"1,328 "},{"v":-348,"d":"(348)"}]
[null,"Office Supplies",null,{"v":5404,"d":"5,404 "},{"v":3505,"d":"3,505 "},{"v":1899,"d":"1,899 "},null,{"v":4646,"d":"4,646 "},{"v":3911,"d":"3,911 "},{"v":735,"d":"735 "},null,{"v":5395,"d":"5,395 "},{"v":4676,"d":"4,676 "},{"v":719,"d":"719 "}]
[null,"Utilities",null,{"v":7316,"d":"7,316 "},{"v":7105,"d":"7,105 "},{"v":211,"d":"211 "},null,{"v":8212,"d":"8,212 "},{"v":7190,"d":"7,190 "},{"v":1022,"d":"1,022 "},null,{"v":6837,"d":"6,837 "},{"v":7535,"d":"7,535 "},{"v":-698,"d":"(698)"}]
[null,"Repairs and Maintenance",null,{"v":4378,"d":"4,378 "},{"v":4155,"d":"4,155 "},{"v":223,"d":"223 "},null,{"v":4161,"d":"4,161 "},{"v":3694,"d":"3,694 "},{"v":467,"d":"467 "},null,{"v":4766,"d":"4,766 "},{"v":4330,"d":"4,330 "},{"v":436,"d":"436 "}]
[null,"Operating Supplies",null,{"v":2805,"d":"2,805 "},{"v":3950,"d":"3,950 "},{"v":-1145,"d":"(1,145)"},null,{"v":3114,"d":"3,114 "},{"v":4538,"d":"4,538 "},{"v":-1424,"d":"(1,424)"},null,{"v":3247,"d":"3,247 "},{"v":5170,"d":"5,170 "},{"v":-1923,"d":"(1,923)"}]
[null,"Professional Fees",null,{"v":3437,"d":"3,437 "},{"v":1575,"d":"1,575 "},{"v":1862,"d":"1,862 "},null,{"v":3097,"d":"3,097 "},{"v":1630,"d":"1,630 "},{"v":1467,"d":"1,467 "},null,{"v":3245,"d":"3,245 "},{"v":1514,"d":"1,514 "},{"v":1731,"d":"1,731 "}]
[null,"Commissions",null,{"v":13716,"d":"13,716 "},{"v":15850,"d":"15,850 "},{"v":-2134,"d":"(2,134)"},null,{"v":12293,"d":"12,293 "},{"v":17303,"d":"17,303 "},{"v":-5010,"d":"(5,010)"},null,{"v":11060,"d":"11,060 "},{"v":19577,"d":"19,577 "},{"v":-8517,"d":"(8,517)"}]
[null,"Travel and Entertainment",null,{"v":3734,"d":"3,734 "},{"v":4580,"d":"4,580 "},{"v":-846,"d":"(846)"},null,{"v":4061,"d":"4,061 "},{"v":4509,"d":"4,509 "},{"v":-448,"d":"(448)"},null,{"v":4546,"d":"4,546 "},{"v":4923,"d":"4,923 "},{"v":-377,"d":"(377)"}]
[null,"Purchases",null,{"v":4140,"d":"4,140 "},{"v":4500,"d":"4,500 "},{"v":-360,"d":"(360)"},null,{"v":4830,"d":"4,830 "},{"v":4783,"d":"4,783 "},{"v":47,"d":"47 "},null,{"v":4161,"d":"4,161 "},{"v":5129,"d":"5,129 "},{"v":-968,"d":"(968)"}]
[null,"Advertising",null,{"v":1957,"d":"1,957 "},{"v":2850,"d":"2,850 "},{"v":-893,"d":"(893)"},null,{"v":1841,"d":"1,841 "},{"v":3205,"d":"3,205 "},{"v":-1364,"d":"(1,364)"},null,{"v":1700,"d":"1,700 "},{"v":3499,"d":"3,499 "},{"v":-1799,"d":"(1,799)"}]
[null,"Transportation",null,{"v":14776,"d":"14,776 "},{"v":13505,"d":"13,505 "},{"v":1271,"d":"1,271 "},null,{"v":12681,"d":"12,681 "},{"v":12838,"d":"12,838 "},{"v":-157,"d":"(157)"},null,{"v":10522,"d":"10,522 "},{"v":14371,"d":"14,371 "},{"v":-3849,"d":"(3,849)"}]
[null,"Other",null,{"v":12352,"d":"12,352 "},{"v":11318,"d":"11,318 "},{"v":1034,"d":"1,034 "},null,{"v":12794,"d":"12,794 "},{"v":12410,"d":"12,410 "},{"v":384,"d":"384 "},null,{"v":10630,"d":"10,630 "},{"v":13920,"d":"13,920 "},{"v":-3290,"d":"(3,290)"}]
[null,null,"Total Disbursements  ",{"$f":"IF(SUM(D15:D28),SUM(D15:D28),\"\")","v":{"v":91467,"d":"$91,467"}},{"$f":"IF(SUM(E15:E28),SUM(E15:E28),\"\")","v":{"v":91492,"d":"$91,492"}},{"$f":"IF(SUM(F15:F28),SUM(F15:F28),\"\")","v":{"v":-25,"d":"($25)"}},null,{"$f":"IF(SUM(H15:H28),SUM(H15:H28),\"\")","v":{"v":86998,"d":"$86,998"}},{"$f":"IF(SUM(I15:I28),SUM(I15:I28),\"\")","v":{"v":92621,"d":"$92,621"}},{"$f":"IF(SUM(J15:J28),SUM(J15:J28),\"\")","v":{"v":-5623,"d":"($5,623)"}},null,{"$f":"IF(SUM(L15:L28),SUM(L15:L28),\"\")","v":{"v":83720,"d":"$83,720"}},{"$f":"IF(SUM(M15:M28),SUM(M15:M28),\"\")","v":{"v":101900,"d":"$101,900"}},{"$f":"IF(SUM(N15:N28),SUM(N15:N28),\"\")","v":{"v":-18180,"d":"($18,180)"}}]
[null,"Cash Position"]
[null,"Loan Payment with Interest",null,{"v":8214,"d":"$8,214"},{"v":8214,"d":"$8,214"},{"$f":"IF(OR(D31>0,E31),D31-E31,\"\")","v":{"v":0,"d":"$0"}},null,{"v":7318,"d":"$7,318"},{"v":8665,"d":"$8,665"},{"$f":"IF(OR(H31>0,I31),H31-I31,\"\")","v":{"v":-1347,"d":"($1,347)"}},null,{"v":6353,"d":"$6,353"},{"v":8278,"d":"$8,278"},{"$f":"IF(OR(L31>0,M31),L31-M31,\"\")","v":{"v":-1925,"d":"($1,925)"}}]
[null,"Capital Purchases",null,{"v":2080,"d":"2,080 "},{"v":1500,"d":"1,500 "},{"$f":"IF(OR(D32>0,E32),D32-E32,\"\")","v":{"v":580,"d":"580 "}},null,{"v":2004,"d":"2,004 "},{"v":1764,"d":"1,764 "},{"$f":"IF(OR(H32>0,I32),H32-I32,\"\")","v":{"v":240,"d":"240 "}},null,{"v":2348,"d":"2,348 "},{"v":1493,"d":"1,493 "},{"$f":"IF(OR(L32>0,M32),L32-M32,\"\")","v":{"v":855,"d":"855 "}}]
[null,"Owner's Withdrawal",null,{"v":12500,"d":"12,500 "},{"v":15500,"d":"15,500 "},{"$f":"IF(OR(D33>0,E33),D33-E33,\"\")","v":{"v":-3000,"d":"(3,000)"}},null,{"v":5000,"d":"5,000 "},{"v":10000,"d":"10,000 "},{"$f":"IF(OR(H33>0,I33),H33-I33,\"\")","v":{"v":-5000,"d":"(5,000)"}},null,{"v":15000,"d":"15,000 "},{"v":10000,"d":"10,000 "},{"$f":"IF(OR(L33>0,M33),L33-M33,\"\")","v":{"v":5000,"d":"5,000 "}}]
[null,null,"Total Cash Paid Out  ",{"$f":"IF(SUM(D29:D33),SUM(D29:D33),\"\")","v":{"v":114261,"d":"$114,261"}},{"$f":"IF(SUM(E29:E33),SUM(E29:E33),\"\")","v":{"v":116706,"d":"$116,706"}},{"$f":"IF(SUM(F29:F33),SUM(F29:F33),\"\")","v":{"v":-2445,"d":"($2,445)"}},null,{"$f":"IF(SUM(H29:H33),SUM(H29:H33),\"\")","v":{"v":101320,"d":"$101,320"}},{"$f":"IF(SUM(I29:I33),SUM(I29:I33),\"\")","v":{"v":113050,"d":"$113,050"}},{"$f":"IF(SUM(J29:J33),SUM(J29:J33),\"\")","v":{"v":-11730,"d":"($11,730)"}},null,{"$f":"IF(SUM(L29:L33),SUM(L29:L33),\"\")","v":{"v":107421,"d":"$107,421"}},{"$f":"IF(SUM(M29:M33),SUM(M29:M33),\"\")","v":{"v":121671,"d":"$121,671"}},{"$f":"IF(SUM(N29:N33),SUM(N29:N33),\"\")","v":{"v":-14250,"d":"($14,250)"}}]
[null,null,"End Of Month  ",{"$f":"IF(AND(ISNUMBER(D13),ISNUMBER(D34)),D13-D34,\"\")","v":{"v":36247,"d":"$36,247"}},{"$f":"IF(AND(ISNUMBER(E13),ISNUMBER(E34)),E13-E34,\"\")","v":{"v":42762,"d":"$42,762"}},{"$f":"IF(AND(ISNUMBER(F13),ISNUMBER(F34)),F13-F34,\"\")","v":{"v":-6515,"d":"($6,515)"}},null,{"$f":"IF(AND(ISNUMBER(H13),ISNUMBER(H34)),H13-H34,\"\")","v":{"v":33469,"d":"$33,469"}},{"$f":"IF(AND(ISNUMBER(I13),ISNUMBER(I34)),I13-I34,\"\")","v":{"v":38955,"d":"$38,955"}},{"$f":"IF(AND(ISNUMBER(J13),ISNUMBER(J34)),J13-J34,\"\")","v":{"v":-5486,"d":"($5,486)"}},null,{"$f":"IF(AND(ISNUMBER(L13),ISNUMBER(L34)),L13-L34,\"\")","v":{"v":39706,"d":"$39,706"}},{"$f":"IF(AND(ISNUMBER(M13),ISNUMBER(M34)),M13-M34,\"\")","v":{"v":33003,"d":"$33,003"}},{"$f":"IF(AND(ISNUMBER(N13),ISNUMBER(N34)),N13-N34,\"\")","v":{"v":6703,"d":"$6,703"}}]
{"$rows_empty":160}
[{"$nulls":15},"DO NOT ERASE OR DELETE ROWS OR"]
[{"$nulls":15},"COLUMNS FROM THIS SECTION"]
[{"$nulls":15},{"$f":"IF(CELL(\"type\",D7)=\"l\",UPPER(LEFT(D7,3)),D7)","v":"JAN"},{"$f":"INDEX($Q$200:$Q$213,MATCH($P$198,$P$200:$P$213,0),1)","v":"JANUARY"},{"$f":"INDEX($Q$200:$Q$213,MATCH($P$198,$P$200:$P$213,0)+1,1)","v":"FEBRUARY"},{"$f":"INDEX($Q$200:$Q$213,MATCH($P$198,$P$200:$P$213,0)+2,1)","v":"MARCH"}]
[]
[{"$nulls":15},{"$f":"LEFT(Q200,3)","v":"JAN"},"JANUARY"]
[{"$nulls":15},"FEB","FEBRUARY"]
[{"$nulls":15},"MAR","MARCH"]
[{"$nulls":15},"APR","APRIL"]
[{"$nulls":15},"MAY","MAY"]
[{"$nulls":15},"JUN","JUNE"]
[{"$nulls":15},"JUL","JULY"]
[{"$nulls":15},"AUG","AUGUST"]
[{"$nulls":15},"SEP","SEPTEMBER"]
[{"$nulls":15},"OCT","OCTOBER"]
[{"$nulls":15},"NOV","NOVEMBER"]
[{"$nulls":15},"DEC","DECEMBER"]
[{"$nulls":15},{"$f":"LEFT(Q212,3)","v":"JAN"},"JANUARY"]
[{"$nulls":15},{"$f":"LEFT(Q213,3)","v":"FEB"},"FEBRUARY"]