needs to be filled out and excel with formulas

105,800 305,000 95,000 Q1 Q2 844.000 $ 03 914,000 $ 795,000 $ Q4 783,000 Beginning cash balance Outlay in third Target cash balance Last years' sales Growth rate in sales Collection period Beg AR Percent uncollectible % of purchases for next Q sales Suppliers pald % of sales for expenses Interest and dividends 7.90% 50 Days 348.000.00 44% 39 Days 23% 32,000 $ Output Area: Sales next year Sales following year Quarterly cash flow Q1 Q2 03 04 Collections from previous quarter Collections from current quarter sales Payments to suppliers for previous quarter Payments to suppliers for current quarter Expenses Dividends and interest Outlay Net cash flow Cash Balance Q1 02 Q3 04 Beginning cash balance Net cash inflow Ending cash balance Minimum cash balance Cumulative surplus (deficit)