Q3. Fill in the blanks of Table 1: Monthly Cash Outflows and Table 2: Monthly Cash Inflows. Then, use the information to generate Table3: Pro-Forma Cash Flow Budget and answer the following questions. (10 points in total) Table 1: AgBiz Estimated Monthly Cash Outflows (Jan-Apr:) Jan Feb Mar Apr tem Sales Purchases) S1.500 54.000 55.000 Payment of Account S. 54.000 Payable Payment of 1,000,000 11:00 Ched Total Cash Outlews Inventory Les 55.000 Assumptions: 1. The inventory turnover rate is 12. 2. Inventory is equal to current month's purchases + previous month's purchases 3. Cost of goods sold=25% of sales 4. Account payable turnover ratio=6. Table 2: AgBiz Estimated Cash Inflows (Jan. - Apr.) Jan Feb Mar Ape Sales 58.000 57.000 Cash Sales (5) 51.790 Account Receivable 54,000 (I meath old) Account Receivable 52,000,000,000 moothold) Total Coah Infos Assumptions: 1. Sales are 114 cash, and 3/4 credits 2. Account Receivable ratio is 4. Table 3: Pro-Forma Cash Flow Budget Jan Feb Mar A Initial Cash Balance 51000 51.000 51.000 $1,000 Cash Inflow Totalcinh vilable Calicut Nel Cash Need Big End Ch Bale $1.000.000.000 Cumulative borrowings (Hint: These three tables are consistent. You are able to get cash inflow from table 2 and cash outflow from table 3) Based on the above Pro-Forma Cash Flow Budget, answer the following two questions: (1) Does the business need to borrow money? If yes, how much money needs to be borrowed? Q3. Fill in the blanks of Table 1: Monthly Cash Outflows and Table 2: Monthly Cash Inflows. Then, use the information to generate Table3: Pro-Forma Cash Flow Budget and answer the following questions. (10 points in total) Table 1: AgBiz Estimated Monthly Cash Outflows (Jan-Apr:) Jan Feb Mar Apr tem Sales Purchases) S1.500 54.000 55.000 Payment of Account S. 54.000 Payable Payment of 1,000,000 11:00 Ched Total Cash Outlews Inventory Les 55.000 Assumptions: 1. The inventory turnover rate is 12. 2. Inventory is equal to current month's purchases + previous month's purchases 3. Cost of goods sold=25% of sales 4. Account payable turnover ratio=6. Table 2: AgBiz Estimated Cash Inflows (Jan. - Apr.) Jan Feb Mar Ape Sales 58.000 57.000 Cash Sales (5) 51.790 Account Receivable 54,000 (I meath old) Account Receivable 52,000,000,000 moothold) Total Coah Infos Assumptions: 1. Sales are 114 cash, and 3/4 credits 2. Account Receivable ratio is 4. Table 3: Pro-Forma Cash Flow Budget Jan Feb Mar A Initial Cash Balance 51000 51.000 51.000 $1,000 Cash Inflow Totalcinh vilable Calicut Nel Cash Need Big End Ch Bale $1.000.000.000 Cumulative borrowings (Hint: These three tables are consistent. You are able to get cash inflow from table 2 and cash outflow from table 3) Based on the above Pro-Forma Cash Flow Budget, answer the following two questions: (1) Does the business need to borrow money? If yes, how much money needs to be borrowed