Complete a Balance Sheet for the below statement of cash flows

Please complete a projected balance sheet for the attached statement of cash flow 12 Month Cash Flow SCORE / FOR THE LIFE OF YOUR BUSINESS Jan-19 EST Cash Flow (12 months) Enter Company Name Here Fiscal Year Begins: Startup Jan-19 Feb-19 Mar-19 Apr-19 May-19 Jun-19 Jul-19 Aug-19 Sep-19 Oct-19 Nov-19 Dec-19 Total Item EST Cash on Hand beginning of 191544 176.544 207.519 236,694 238.369 275.944 308.169 339,644 363.369 338.544 432.154 463.684 494.659 month 176,544 CASH RECEIPTS Cash Sales 65.000 65,000 68,000 73.000 75.000 78,000 82.000 85.000 85,700 85,800 87.000 30,000 933,500 TOTAL CASH RECEIPTS 65,000 65,000 68,000 73.000 75,000 78,000 82.000 85.000 85,700 85.800 87.000 30,000 339.500 Total Cash Available before 191544 241.544 272.519 304,694 311369 350,944 386,169 421644 448.369 484.244 517.954 550.684 584.659 1116.044 cash out) CASH PAID OUT Purchases inventory 10.000 11.000 11000 13.000 16,000 20.000 22.000 24.000 26.000 28.000 30.000 34.000 245.000 Payroll expenses tasses, etc.) 0 55.000 15,000 15,000 15,000 15,000 15,000 15,000 15.000 15.000 15,000 15,000 15,000 15.000 Supplies (office & oper) 3,000 3.200 3,400 3.700 3.500 3.500 3.550 3.550 3.700 3.700 3.750 3.750 42.300 Repaits & maintenance 2.000 2.600 2.300 300 4.250 4,000 3.700 3.250 3.365 3.545 3.250 3.100 38.360 Advertising 1.000 1,000 1.000 1.000 1000 1,000 1000 1.000 1000 1.000 1.000 1.000 12,000 Rent 1.700 1.700 1.700 1.700 1.700 1700 1700 1700 1700 1700 1700 1.700 20,400 Telephone 200 200 200 200 200 200 200 200 200 200 200 2.400 Utilities 500 500 500 500 500 500 500 500 500 500 500 6.000 Insurance 250 250 250 250 250 250 250 250 250 250 250 250 3.000 Tanes realestate, etc.) 375 375 375 375 375 375 375 375 375 375 375 375 4,500 SUBTOTAL 0 34,025 35.825 35.725 36,025 42.775 46.525 48,275 49,825 52,090 54,270 56,025 59.875 388,360 Other startup costs 15,000 15.000 Owners' Wihdrawal 30,000 10.000 25.000 65.000 TOTAL CASH PAID OUT 15.000 34,025 35.825 65.725 36,025 42.775 46.525 58.275 49.825 52.030 54.270 56,025 84.875 468.960 Cash Position lend of month 176,544 207.519 236,694 238,969 275.344 308.169 339,644 363,369 338,544 432.154 463,684 494,659 439.784 647.084 200 500 ESSENTIAL OPERATING DATA (non cash flow information) Bad Debelend of month) 2.500 2,000 1200 1100 1.200 1.200 1200 1.200 1.200 2.000 2.500 3,000 25,800