Homework: Chapter 20 Homework 2020 Save Score: 0 of 1 pt 15 of 15 (0 complete) HW Score: 0%, 0 of 15 pts P 20-20 (book/static) Question Help O 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 tion 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 Enter any number in the edit fields and then click Check Answer. A parts 4 remaining Clear All Check Answer A1 : for Quarter G H I J K L M N O P Q R S B C D E F 2009Q4 201001201002 1201003201004 4545 2955 455 1135 455 6801 239 5000 3250 1000 750 500 250 88 162 6000 3900 600 1500 525 9751 6000 3900 600 1500 525 975 341 6341 6000 3900 600 1500 525 975 341 634 341 441 634| 441 162 500 634 525 634 525 525 A 1 Quarter 2 Income Statement ($000) 3 Sales 4. Cost of Goods Sold 5 Selling, Gen., and Admin. 6 EBITDA 7 Depreciation 8 EBIT 9 Taxes 10 Net Income 11 Statement of Cash Flow 12 Net Income 13 Depreciation 14 Changes in Working Capital: 15 Accounts Receivable 16 Inventory 17 Accounts Payable 18 Cash from Operating Act. 19 Capital Expenditures 20 Other Investments 21 Cash from Investing Act. 22 Net Borrowing 23 Dividends 24 Capital Contributions 25 Cash from Financing Act. 26 Change in Cash Equiv. 27 28 -300 0 0 48 105 00 5741 964 1159 1159 -1500 -525 -525 -525 ol 0 0 0 -1500 -525 -525 -525 ol o ol 0 0 0 0 000 -926 439 634| 634 30 31 0 - - Homework: Chapter 20 Homework 2020 Save Score: 0 of 1 pt 15 of 15 (0 complete) HW Score: 0%, 0 of 15 pts P 20-20 (book/static) Question Help O 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 tion 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 Enter any number in the edit fields and then click Check Answer. A parts 4 remaining Clear All Check Answer A1 : for Quarter G H I J K L M N O P Q R S B C D E F 2009Q4 201001201002 1201003201004 4545 2955 455 1135 455 6801 239 5000 3250 1000 750 500 250 88 162 6000 3900 600 1500 525 9751 6000 3900 600 1500 525 975 341 6341 6000 3900 600 1500 525 975 341 634 341 441 634| 441 162 500 634 525 634 525 525 A 1 Quarter 2 Income Statement ($000) 3 Sales 4. Cost of Goods Sold 5 Selling, Gen., and Admin. 6 EBITDA 7 Depreciation 8 EBIT 9 Taxes 10 Net Income 11 Statement of Cash Flow 12 Net Income 13 Depreciation 14 Changes in Working Capital: 15 Accounts Receivable 16 Inventory 17 Accounts Payable 18 Cash from Operating Act. 19 Capital Expenditures 20 Other Investments 21 Cash from Investing Act. 22 Net Borrowing 23 Dividends 24 Capital Contributions 25 Cash from Financing Act. 26 Change in Cash Equiv. 27 28 -300 0 0 48 105 00 5741 964 1159 1159 -1500 -525 -525 -525 ol 0 0 0 -1500 -525 -525 -525 ol o ol 0 0 0 0 000 -926 439 634| 634 30 31 0