20. Construct a short - term financial plan for Springfield Snowboards based on Sion opportunity described in the Positive Cash Flow Shocks part of Sci Base the plan on the following table , which forecasts additional capital expert marketing ( SC & A , and working capital in Q1 and Q2 along with higher 02-04 . Assume that Springfield ends 2017 with $ 1 million in cash and that will offer it a short - term loan at the rate 2.5 % per quarter See MyFinance Labor Putting It All Together Creating a Short-Term Financial Plan data in Excel format) ZOTTO 201801 201602201103201108 5,000 6.000.000 HE 25 -3.250 155 -1,000 750 51 -500 250 -68 162 8,000 3.900 3900 2.500 600 800 1.500 1,500 1.500 525 975 975 975 -341 - 341 -343 634 634 654 034 500 1 Quarter 2 Income Statement (5000) 3 Sales 4 Cost of Goods Sold 5 Selling, General, and Administrative 5 EBITDA 7 Depreciation 0 Tax 10 Not Income 11 Statement of Cash Flows 12 Not income 13 Depreciation 14 Changes in Working Capital 15 Accounts Receivable 10 Inventory 17 Accounts Payable 10 Cash from Operating Activities 19 Capital Expenditures 20 Other investment 21 Cash from investing Activities 22 Net Borrowing 23 Didends 24 Capital Contributions 25 Cash from Financing Activities 26 Change in Cash and Equivalente 525 634 525 634 525 -300 46 574 TOS 084 -sas 1.150 1.500 525 - 1,500 -525 525 430 534 20. Construct a short - term financial plan for Springfield Snowboards based on Sion opportunity described in the Positive Cash Flow Shocks part of Sci Base the plan on the following table , which forecasts additional capital expert marketing ( SC & A , and working capital in Q1 and Q2 along with higher 02-04 . Assume that Springfield ends 2017 with $ 1 million in cash and that will offer it a short - term loan at the rate 2.5 % per quarter See MyFinance Labor Putting It All Together Creating a Short-Term Financial Plan data in Excel format) ZOTTO 201801 201602201103201108 5,000 6.000.000 HE 25 -3.250 155 -1,000 750 51 -500 250 -68 162 8,000 3.900 3900 2.500 600 800 1.500 1,500 1.500 525 975 975 975 -341 - 341 -343 634 634 654 034 500 1 Quarter 2 Income Statement (5000) 3 Sales 4 Cost of Goods Sold 5 Selling, General, and Administrative 5 EBITDA 7 Depreciation 0 Tax 10 Not Income 11 Statement of Cash Flows 12 Not income 13 Depreciation 14 Changes in Working Capital 15 Accounts Receivable 10 Inventory 17 Accounts Payable 10 Cash from Operating Activities 19 Capital Expenditures 20 Other investment 21 Cash from investing Activities 22 Net Borrowing 23 Didends 24 Capital Contributions 25 Cash from Financing Activities 26 Change in Cash and Equivalente 525 634 525 634 525 -300 46 574 TOS 084 -sas 1.150 1.500 525 - 1,500 -525 525 430 534