The following tate includes quarterly working capital levels for your firm for the next year (Click on the following icon in order to copy the contents into a spreadsheet) Quarters (5000) 3 4 Cash 100 100 100 100 Accounts Receivable 200 100 100 600 Inventory 200 500 SOO 50 Accounts Payable 100 100 100 100 if you want to limit your macmum shontorm borrowing to $500,000 and maintain a minimum cash balance of $100.000, how much cash must you carry The cash needed $ Round to the nearest dollar) Construct a short term financial plan for Whistler Snowboards based on its expansion opportunity described in the follow table, which forecasts additional capital expenditures, marketing (SOBA) and working capital in 1 and 2 along with higher sale in Q2 to 1. Assume that White ands 2019 with 100 million in cash and that its bark will offer a short-term can the rate 2.50% per curter. Assume that the minimum cash bilance to be maintained is $500.000 Complete the cash budget based on the sumption of the problem (Round to the stars 5000) Cash Balance and Short Term Financing (5000) 202001 Starting Cash Balance Change in Caith and Equivalent $ Minimum Cash Balance 0 Gurplus (D) Relative to Minimum Increase (Deco) in Short Term Financing Existing short-term Facing $ Total Short-ton Francing 5 Ending Cash Balance 5 Question View (Click on the icon located on the top-right corner of the data table below to copy its contents into a spreadsheet.) 2019Q4 202001 202002 202003 202004 Quarter Income Statement ($000) Sales Cost of Goods Sold Selling, General, and Admin. EBITDA Depreciation EBIT Taxes Net Income Statement of Cash Flow ($000) Net Income Depreciation Changes in Working Capital: Accounts Receivable Inventory Accounts Payable Cash from Operating Act. Capital Expenditures Other Investments 4545 2955 455 1135 455 680 239 441 5000 3250 1000 750 500 250 88 162 6000 3900 600 1500 525 975 341 634 6000 3900 600 1500 525 975 341 634 6000 3900 600 1500 525 975 341 634 162 634 634 525 634 525 500 525 - 136 - 300 - 48 574 - 1500 105 964 -525 1159 -525 1159 -525 680 239 441 250 88 162 975 341 634 975 341 634 975 341 634 162 500 634 525 634 525 634 525 - 136 - 300 - - EBIT Taxes Net Income Statement of Cash Flow ($000) Net Income Depreciation Changes in Working Capital: Accounts Receivable Inventory Accounts Payable Cash from Operating Act. Capital Expenditures Other Investments Cash from Investing Act. Net Borrowing Dividends Capital Contributions Cash from Financing Act. Change in Cash Equiv. 48 574 - 1500 105 964 -525 1159 525 1159 -525 - 1500 -525 -525 -525 -926 439 634 634