{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Cash flow forecast","Cash flow chart"],"not_rendered":{"charts":1,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Cash flow forecast","index":0,"n_rows":66,"n_cols":16,"rows_kept":66,"merged":[[0,1,0,14],[1,1,1,14],[6,14,7,14]]}
[null,"ELBIDE REALTY"]
[null,"Cash flow forecast",{"$nulls":13}," "]
[]
[null,"Starting cash on hand",{"v":10000,"d":"$10,000.00"},null,"Starting date",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())+1,1)","v":"2023-02-01"},null,"Cash minimum balance alert",null,{"v":2000,"d":"$2,000.00"}]
[]
[]
[null,null,{"$f":"IF(Start_Date=\"\",\"\",Start_Date)","v":"2023-02-01"},{"$f":"IF(C7=\"\",\"\",DATE(YEAR(C7),MONTH(C7)+1,1))","v":"2023-03-01"},{"$f":"IF(D7=\"\",\"\",DATE(YEAR(D7),MONTH(D7)+1,1))","v":"2023-04-01"},"2023-05-01","2023-06-01","2023-07-01","2023-08-01","2023-09-01","2023-10-01","2023-11-01","2023-12-01","2024-01-01","Total"]
[null,"Cash on hand (beginning of month)",{"$f":"C4","v":{"v":10000,"d":"$10,000.00"}},{"$f":"C57","v":{"v":8050,"d":"$8,050.00"}},{"v":9350,"d":"$9,350.00"},{"v":890,"d":"$890.00"},{"v":2190,"d":"$2,190.00"},{"v":13590,"d":"$13,590.00"},{"v":13790,"d":"$13,790.00"},{"v":15290,"d":"$15,290.00"},{"v":16410,"d":"$16,410.00"},{"v":14360,"d":"$14,360.00"},{"v":16560,"d":"$16,560.00"},{"v":18780,"d":"$18,780.00"}]
[]
[null,"Cash receipts"]
[]
[null,"Cash sales",{"v":2500,"d":"$2,500.00"},{"v":3000,"d":"$3,000.00"},{"v":3600,"d":"$3,600.00"},{"v":3000,"d":"$3,000.00"},{"v":14000,"d":"$14,000.00"},{"v":6000,"d":"$6,000.00"},{"v":3000,"d":"$3,000.00"},{"v":2800,"d":"$2,800.00"},{"v":3500,"d":"$3,500.00"},{"v":4000,"d":"$4,000.00"},{"v":3800,"d":"$3,800.00"},{"v":4200,"d":"$4,200.00"},{"$f":"SUM(C12:N12)","v":{"v":53400,"d":"$53,400.00"}}]
[null,"Returns and allowances",null,null,{"v":200,"d":"$200.00"},{"$nulls":9},{"v":200,"d":"$200.00"}]
[null,"Collections on accounts receivable",{"$nulls":12},0]
[null,"Interest, other income",{"$nulls":12},0]
[null,"Loan proceeds",{"$nulls":12},0]
[null,"Owner contributions",{"$nulls":12},0]
[null,"Other receipts",{"$nulls":12},0]
[null,"Total cash receipts",{"$f":"SUM(C12,C14:C18,(C13*-1))","v":{"v":2500,"d":"$2,500.00"}},{"$f":"SUM(D12,D14:D18,(D13*-1))","v":{"v":3000,"d":"$3,000.00"}},{"v":3400,"d":"$3,400.00"},{"v":3000,"d":"$3,000.00"},{"v":14000,"d":"$14,000.00"},{"v":6000,"d":"$6,000.00"},{"v":3000,"d":"$3,000.00"},{"v":2800,"d":"$2,800.00"},{"v":3500,"d":"$3,500.00"},{"v":4000,"d":"$4,000.00"},{"v":3800,"d":"$3,800.00"},{"v":4200,"d":"$4,200.00"},{"$f":"SUM(O12:O18)","v":{"v":53600,"d":"$53,600.00"}}]
[null,"Total cash available",{"$f":"(C8+C19)","v":{"v":12500,"d":"$12,500.00"}},{"v":11050,"d":"$11,050.00"},{"v":12750,"d":"$12,750.00"},{"v":3890,"d":"$3,890.00"},{"v":16190,"d":"$16,190.00"},{"v":19590,"d":"$19,590.00"},{"v":16790,"d":"$16,790.00"},{"v":18090,"d":"$18,090.00"},{"v":19910,"d":"$19,910.00"},{"v":18360,"d":"$18,360.00"},{"v":20360,"d":"$20,360.00"},{"v":22980,"d":"$22,980.00"}]
[]
[null,"Cash paid out"]
[]
[null,"Advertising",{"v":3000,"d":"$3,000.00"},{"$nulls":11},{"$f":"SUM(C24:N24)","v":{"v":3000,"d":"$3,000.00"}}]
[null,"Commissions and fees",{"v":250,"d":"$250.00"},{"v":300,"d":"$300.00"},{"v":360,"d":"$360.00"},{"v":300,"d":"$300.00"},{"v":1400,"d":"$1,400.00"},{"v":400,"d":"$400.00"},{"v":300,"d":"$300.00"},{"v":280,"d":"$280.00"},{"v":350,"d":"$350.00"},{"v":400,"d":"$400.00"},{"v":380,"d":"$380.00"},{"v":420,"d":"$420.00"},{"v":5140,"d":"$5,140.00"}]
[null,"Contract labor",null,{"v":200,"d":"$200.00"},null,{"v":200,"d":"$200.00"},null,{"v":200,"d":"$200.00"},null,{"v":200,"d":"$200.00"},null,{"v":200,"d":"$200.00"},null,{"v":200,"d":"$200.00"},{"v":1200,"d":"$1,200.00"}]
[null,"Employee benefit programs",{"$nulls":12},0]
[null,"Insurance (other than health)",null,null,{"v":4000,"d":"$4,000.00"},null,null,{"v":4000,"d":"$4,000.00"},null,null,{"v":4000,"d":"$4,000.00"},null,null,{"v":4000,"d":"$4,000.00"},{"v":16000,"d":"$16,000.00"}]
[null,"Interest expense",{"$nulls":12},0]
[null,"Materials and supplies (in COGS)",{"v":1200,"d":"$1,200.00"},{"v":1200,"d":"$1,200.00"},{"v":7500,"d":"$7,500.00"},{"v":1200,"d":"$1,200.00"},{"v":1200,"d":"$1,200.00"},{"v":1200,"d":"$1,200.00"},{"v":1200,"d":"$1,200.00"},{"v":1200,"d":"$1,200.00"},{"v":1200,"d":"$1,200.00"},{"v":1200,"d":"$1,200.00"},{"v":1200,"d":"$1,200.00"},{"v":1200,"d":"$1,200.00"},{"v":20700,"d":"$20,700.00"}]
[null,"Meals and entertainment",{"$nulls":12},0]
[null,"Mortgage interest",{"$nulls":12},0]
[null,"Office expense",{"$nulls":12},0]
[null,"Other interest expense",{"$nulls":12},0]
[null,"Pension and profit-sharing plan",{"$nulls":12},0]
[null,"Purchases for resale",{"$nulls":12},0]
[null,"Rent or lease",{"$nulls":12},0]
[null,"Rent or lease: vehicles, equipment",{"$nulls":12},0]
[null,"Repairs and maintenance",{"$nulls":12},0]
[null,"Supplies (not in COGS)",{"$nulls":12},0]
[null,"Taxes and licenses",{"$nulls":12},0]
[null,"Travel",{"$nulls":12},0]
[null,"Utilities",{"$nulls":12},0]
[null,"Wages (less emp. credits)",{"$nulls":12},0]
[null,"Other expenses",{"$nulls":12},0]
[null,"Other expenses",{"$nulls":12},0]
[null,"Other expenses",{"$nulls":12},0]
[null,"Miscellaneous",{"$nulls":12},0]
[null,"Subtotal",{"$f":"SUM(C24:C48)","v":{"v":4450,"d":"$4,450.00"}},{"v":1700,"d":"$1,700.00"},{"v":11860,"d":"$11,860.00"},{"v":1700,"d":"$1,700.00"},{"v":2600,"d":"$2,600.00"},{"v":5800,"d":"$5,800.00"},{"v":1500,"d":"$1,500.00"},{"v":1680,"d":"$1,680.00"},{"v":5550,"d":"$5,550.00"},{"v":1800,"d":"$1,800.00"},{"v":1580,"d":"$1,580.00"},{"v":5820,"d":"$5,820.00"},{"v":46040,"d":"$46,040.00"}]
[]
[null,"Loan principal payment",{"$nulls":12},0]
[null,"Capital purchases",{"$nulls":12},0]
[null,"Other startup costs",{"$nulls":12},0]
[null,"To reserve and/or escrow",{"$nulls":12},0]
[null,"Owners' withdrawal",{"$nulls":12},0]
[null,"Total cash paid out",{"$f":"C49-SUM(C51:C55)","v":{"v":4450,"d":"$4,450.00"}},{"$f":"D49-SUM(D51:D55)","v":{"v":1700,"d":"$1,700.00"}},{"v":11860,"d":"$11,860.00"},{"v":1700,"d":"$1,700.00"},{"v":2600,"d":"$2,600.00"},{"v":5800,"d":"$5,800.00"},{"v":1500,"d":"$1,500.00"},{"v":1680,"d":"$1,680.00"},{"v":5550,"d":"$5,550.00"},{"v":1800,"d":"$1,800.00"},{"v":1580,"d":"$1,580.00"},{"v":5820,"d":"$5,820.00"},{"$f":"SUM(O49:O55)","v":{"v":46040,"d":"$46,040.00"}}]
[null,"Cash on hand (end of month)",{"$f":"(C20-C56)","v":{"v":8050,"d":"$8,050.00"}},{"v":9350,"d":"$9,350.00"},{"v":890,"d":"$890.00"},{"v":2190,"d":"$2,190.00"},{"v":13590,"d":"$13,590.00"},{"v":13790,"d":"$13,790.00"},{"v":15290,"d":"$15,290.00"},{"v":16410,"d":"$16,410.00"},{"v":14360,"d":"$14,360.00"},{"v":16560,"d":"$16,560.00"},{"v":18780,"d":"$18,780.00"},{"v":17160,"d":"$17,160.00"}]
[]
[null,"Other operating data"]
[]
[null,"Sales volume (dollars)"]
[null,"Accounts receivable balance"]
[null,"Bad debt balance"]
[null,"Inventory on hand"]
[null,"Accounts payable balance"]
[null,"Depreciation"]

{"sheet":"Cash flow chart","index":1,"n_rows":16,"n_cols":15,"rows_kept":16,"merged":[[0,1,0,10],[1,1,1,10]]}
[null,"ELBIDE REALTY"]
[null,"Cash flow forecast",{"$nulls":9}," "]
[]
[null,"Month","Cash on hand",{"$nulls":9},{"$f":"B4","v":"Month"},"Not Below Minimum","Below Minimum"]
[null,{"$f":"'Cash flow forecast'!C7","v":"2023-02-01"},{"$f":"'Cash flow forecast'!C8","v":{"v":10000,"d":"$10,000.00"}},{"$nulls":9},{"$f":"B5","v":"2023-02-01"},{"$f":"IF(C5<Cash_Minimum,0,C5)","v":{"v":10000,"d":"$10,000.00"}},{"$f":"IF(C5<Cash_Minimum,C5,0)","v":0}]
[null,{"$f":"'Cash flow forecast'!D7","v":"2023-03-01"},{"$f":"'Cash flow forecast'!D8","v":{"v":8050,"d":"$8,050.00"}},{"$nulls":9},"2023-03-01",{"v":8050,"d":"$8,050.00"},0]
[null,{"$f":"'Cash flow forecast'!E7","v":"2023-04-01"},{"$f":"'Cash flow forecast'!E8","v":{"v":9350,"d":"$9,350.00"}},{"$nulls":9},"2023-04-01",{"v":9350,"d":"$9,350.00"},0]
[null,{"$f":"'Cash flow forecast'!F7","v":"2023-05-01"},{"$f":"'Cash flow forecast'!F8","v":{"v":890,"d":"$890.00"}},{"$nulls":9},"2023-05-01",0,{"v":890,"d":"$890.00"}]
[null,{"$f":"'Cash flow forecast'!G7","v":"2023-06-01"},{"$f":"'Cash flow forecast'!G8","v":{"v":2190,"d":"$2,190.00"}},{"$nulls":9},"2023-06-01",{"v":2190,"d":"$2,190.00"},0]
[null,{"$f":"'Cash flow forecast'!H7","v":"2023-07-01"},{"$f":"'Cash flow forecast'!H8","v":{"v":13590,"d":"$13,590.00"}},{"$nulls":9},"2023-07-01",{"v":13590,"d":"$13,590.00"},0]
[null,{"$f":"'Cash flow forecast'!I7","v":"2023-08-01"},{"$f":"'Cash flow forecast'!I8","v":{"v":13790,"d":"$13,790.00"}},{"$nulls":9},"2023-08-01",{"v":13790,"d":"$13,790.00"},0]
[null,{"$f":"'Cash flow forecast'!J7","v":"2023-09-01"},{"$f":"'Cash flow forecast'!J8","v":{"v":15290,"d":"$15,290.00"}},{"$nulls":9},"2023-09-01",{"v":15290,"d":"$15,290.00"},0]
[null,{"$f":"'Cash flow forecast'!K7","v":"2023-10-01"},{"$f":"'Cash flow forecast'!K8","v":{"v":16410,"d":"$16,410.00"}},{"$nulls":9},"2023-10-01",{"v":16410,"d":"$16,410.00"},0]
[null,{"$f":"'Cash flow forecast'!L7","v":"2023-11-01"},{"$f":"'Cash flow forecast'!L8","v":{"v":14360,"d":"$14,360.00"}},{"$nulls":9},"2023-11-01",{"v":14360,"d":"$14,360.00"},0]
[null,{"$f":"'Cash flow forecast'!M7","v":"2023-12-01"},{"$f":"'Cash flow forecast'!M8","v":{"v":16560,"d":"$16,560.00"}},{"$nulls":9},"2023-12-01",{"v":16560,"d":"$16,560.00"},0]
[null,{"$f":"'Cash flow forecast'!N7","v":"2024-01-01"},{"$f":"'Cash flow forecast'!N8","v":{"v":18780,"d":"$18,780.00"}},{"$nulls":9},"2024-01-01",{"v":18780,"d":"$18,780.00"},0]