$ Construct a short-term financial plan for Whistler Snowboards based on its expansion opportunity described in the following table which forecasts additional capital expenditures, marketing (SG&A), and working capital in Q1 and 22 along with higher sales in Q2 to 04. Assume that Whistler ends 2019 with $1.00 million in cash and that its bank will offer it a short-term loan at the rate 2.50% per quarter. Assume that the minimum cash balance to be maintained is $500,000 Complete the cash budget based on the assumptions of the problem. (Round to the nearest $000.) Cash Balance and Short-Term Financing (5000) 202001 Starting Cash Balance Change in Cash and Equivalents Minimum Cash Balance Surplus (Deich) Relative to Minimum Increano (Decreto) in Short Term Financing Existing short-term Financing Total Short-term Financing Ending Cash Balance $ S $ $ $ $ S Data table Lasts ad fith $1.C 00,000 SM sh ca Cas efid (Click on the icon located on the top-right corner of the data table below to copy its contents into a spreadsheet.) Quarter 201904 202001 202002 202003 202004 Income Statement ($000) Sales 4545 5000 6000 6000 6000 Cost of Goods Sold 2955 3250 3900 3900 3900 Selling, General, and Admin. 455 1000 600 600 600 EBITDA 1135 750 1500 1500 1500 Depreciation 455 500 525 525 525 EBIT 680 250 975 975 975 Taxes 239 88 341 341 341 Net Income 441 162 634 634 634 Statement of Cash Flow (5000) Net Income 162 634 634 634 Depreciation 500 525 525 525 Changes in Working Capital: Accounts Receivable - 136 - 300 Inventory Accounts Payable 48 105 Cash from Operating Act. 574 964 Capital Expenditures 1159 1159 1500 -525 Other investments -525 -525 Ded hor H-tel ash 1 Print Done n example ASK my instructor PRINT ase (Ded 105 ting Short 48 574 - 1500 964 1159 -525 1159 -525 Short-tel -525 ing Cash - 1500 -525 525 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. 525 || | | | | 3 Il -926 439 634 634 $ Construct a short-term financial plan for Whistler Snowboards based on its expansion opportunity described in the following table which forecasts additional capital expenditures, marketing (SG&A), and working capital in Q1 and 22 along with higher sales in Q2 to 04. Assume that Whistler ends 2019 with $1.00 million in cash and that its bank will offer it a short-term loan at the rate 2.50% per quarter. Assume that the minimum cash balance to be maintained is $500,000 Complete the cash budget based on the assumptions of the problem. (Round to the nearest $000.) Cash Balance and Short-Term Financing (5000) 202001 Starting Cash Balance Change in Cash and Equivalents Minimum Cash Balance Surplus (Deich) Relative to Minimum Increano (Decreto) in Short Term Financing Existing short-term Financing Total Short-term Financing Ending Cash Balance $ S $ $ $ $ S Data table Lasts ad fith $1.C 00,000 SM sh ca Cas efid (Click on the icon located on the top-right corner of the data table below to copy its contents into a spreadsheet.) Quarter 201904 202001 202002 202003 202004 Income Statement ($000) Sales 4545 5000 6000 6000 6000 Cost of Goods Sold 2955 3250 3900 3900 3900 Selling, General, and Admin. 455 1000 600 600 600 EBITDA 1135 750 1500 1500 1500 Depreciation 455 500 525 525 525 EBIT 680 250 975 975 975 Taxes 239 88 341 341 341 Net Income 441 162 634 634 634 Statement of Cash Flow (5000) Net Income 162 634 634 634 Depreciation 500 525 525 525 Changes in Working Capital: Accounts Receivable - 136 - 300 Inventory Accounts Payable 48 105 Cash from Operating Act. 574 964 Capital Expenditures 1159 1159 1500 -525 Other investments -525 -525 Ded hor H-tel ash 1 Print Done n example ASK my instructor PRINT ase (Ded 105 ting Short 48 574 - 1500 964 1159 -525 1159 -525 Short-tel -525 ing Cash - 1500 -525 525 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. 525 || | | | | 3 Il -926 439 634 634
