1200904 201001 2010Q2 201003201004 6000 3900 600 1500 4545 2955 455 11351 455 680 2391 441) 5000 3250 1000 750 5001 250 88 162 6000 3900 600 1500 525 975 525 975 341 341 634 441 162 500 634 525 Quarter Income Statement ($000) Sales Cost of Goods Sold Selling ,Gen., and Admin. EBITDA Depreciation EBIT Taxes Net Income Statement of Cash Flow 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. -136 -3001 1159 -525 48 1050 574964 - 1500 -525 ol -1500 -525 ol 0 -525 -9261439 634 P 20-20 (book/static) Question Help Construct a short-term financial plan for Springfield Snowboards based on its expansion opportunity described in the "Positive Cash Flow Shocks" part of Section 20.1. Base the plan on the following table , which forecasts additional capital expenditures, marketing (SG&A), and working capital in Q1 and Q2 along with higher sales in Q2-Q4. Assume that Springfield ends 2014 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 integer. Cash Balance and Short-Term Financing ($000) 2013Q1 $ Starting Cash Balance Change in Cash and Equivalents Minimum Cash Balance Surplus (Deficit) Relative to Minimum Increase (Decrease) in Short-Term Financing Existing Short-term Financing Total Short-term Financing Ending Cash Balance 1200904 201001 2010Q2 201003201004 6000 3900 600 1500 4545 2955 455 11351 455 680 2391 441) 5000 3250 1000 750 5001 250 88 162 6000 3900 600 1500 525 975 525 975 341 341 634 441 162 500 634 525 Quarter Income Statement ($000) Sales Cost of Goods Sold Selling ,Gen., and Admin. EBITDA Depreciation EBIT Taxes Net Income Statement of Cash Flow 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. -136 -3001 1159 -525 48 1050 574964 - 1500 -525 ol -1500 -525 ol 0 -525 -9261439 634 P 20-20 (book/static) Question Help Construct a short-term financial plan for Springfield Snowboards based on its expansion opportunity described in the "Positive Cash Flow Shocks" part of Section 20.1. Base the plan on the following table , which forecasts additional capital expenditures, marketing (SG&A), and working capital in Q1 and Q2 along with higher sales in Q2-Q4. Assume that Springfield ends 2014 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 integer. Cash Balance and Short-Term Financing ($000) 2013Q1 $ Starting Cash Balance Change in Cash and Equivalents Minimum Cash Balance Surplus (Deficit) Relative to Minimum Increase (Decrease) in Short-Term Financing Existing Short-term Financing Total Short-term Financing Ending Cash Balance
