Based on the following projections for a potential project, complete the Cash Flow Table

Given Info 91 Q2 Q3 125$ Q4 200 $ Estimated Sales (000s) Capital Investment Requirements (000s) 50 $ 10 75 10 Opening Balances @ Jan 1st (0005) A/R @ the beginning of year A/P @ the beginning of year Cash $ $ 25 Sales & Payment Terms A/R Collection Period (days) A/P Payment Period (days) 45 30 $ Purchases ( % of Next Quarters Sales) Next Years Q1 Sales Projection (000s) Operating Expenses (% of sales) Existing Interest Expense per quarter (000s) Minimum Required Cash Balance (000s) Company's Required Return 40% 300 20% 0.5 25 10% Paragraph Styles Cash Budget ('000's) 02 02 03 04 Cash Collections Beginning A/R Sales Cash Collections Ending A/R Cash Disbursements Beginning A/P Purchases Paid A/P Ending A/P Total Cash Outflows Paid A/P Operating Expenses Capital Investments Interest Total cash disbursements Cash Budget Beginning cash balance Total Cash Collections Total Cash Disbursements Net Cash Inflow Ending cash balance Minimum cash balance Cumulative surplus (deficit) Given Info 91 Q2 Q3 125$ Q4 200 $ Estimated Sales (000s) Capital Investment Requirements (000s) 50 $ 10 75 10 Opening Balances @ Jan 1st (0005) A/R @ the beginning of year A/P @ the beginning of year Cash $ $ 25 Sales & Payment Terms A/R Collection Period (days) A/P Payment Period (days) 45 30 $ Purchases ( % of Next Quarters Sales) Next Years Q1 Sales Projection (000s) Operating Expenses (% of sales) Existing Interest Expense per quarter (000s) Minimum Required Cash Balance (000s) Company's Required Return 40% 300 20% 0.5 25 10% Paragraph Styles Cash Budget ('000's) 02 02 03 04 Cash Collections Beginning A/R Sales Cash Collections Ending A/R Cash Disbursements Beginning A/P Purchases Paid A/P Ending A/P Total Cash Outflows Paid A/P Operating Expenses Capital Investments Interest Total cash disbursements Cash Budget Beginning cash balance Total Cash Collections Total Cash Disbursements Net Cash Inflow Ending cash balance Minimum cash balance Cumulative surplus (deficit)