1 of 1 SU This Question: 1 pt Cancel BON Construct a short-term financial plan for Speingfield Snowboards based on its expansion opportunity described in the Positive Cash Flow Shacks part of Section 201 Base the plan on the following table which forecasts additional capital expenditures, marketing (SGRA), and working capital in Q1 and 2 along with higher sales In 02-04. Assume that Springfield ends 2014 with $1,05 million in cash and that is bank will offer a short-term loan at the rate 200% per quarter Assume that the minimum canh balance to be maintained is $495,000 Complete the cash budget based on the assumptions of the problem Round to the he nearest integer) Cash Balance and ShortTerm Financing (5000) 201301 201307 201303 201304 Starting Cash Balance $ $ $ $ Change in Cash and Equivalents $ 5 $ S Minimum Cash Balance s $ $ 5 Surplus (Dell) Relative to Minimum 5 5 S $ Increase (Decrease) in Short Term Financing 5 5 Existing Short-term Financing $ 5 5 Total Short-term Financing S 5 Library lculator UZN ources $ dy tion Tools Enter any number in the edities and then continue to the next question 201204 2013Q1 2013Q2 2013Q3 2013Q4 E 6,000 3,900 550 1,550 Quarter Income Statement (5000) Sales Cost of Goods Sold Selling Gen, and Admin EBITDA Depreciation EBIT Taxes Net Income Statement of Cash Flow (5000) Net Income Depreciation Changes in Working Capital: Accounts Receivable Inventory 4,540 2,951 458 1,131 453 678 237 441 5,000 3,250 900 850 500 350 6,150 3,998 600 1,552 600 952 333 619 600 6,050 3,933 500 1,550 450 1.100 385 715 123 950 333 617 227 227 500 619 600 617 600 715 450 145 300 0 - 145 - 300 0 0 54 636 - 1,600 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. 100 1,019 -525 0 525 0 0 0 1,217 -530 0 -530 0 1,165 -525 0 - 525 0 0 0 1,600 0 0 0 0 -964 OOOO 0 OOololo 0 494 687 1 of 1 SU This Question: 1 pt Cancel BON Construct a short-term financial plan for Speingfield Snowboards based on its expansion opportunity described in the Positive Cash Flow Shacks part of Section 201 Base the plan on the following table which forecasts additional capital expenditures, marketing (SGRA), and working capital in Q1 and 2 along with higher sales In 02-04. Assume that Springfield ends 2014 with $1,05 million in cash and that is bank will offer a short-term loan at the rate 200% per quarter Assume that the minimum canh balance to be maintained is $495,000 Complete the cash budget based on the assumptions of the problem Round to the he nearest integer) Cash Balance and ShortTerm Financing (5000) 201301 201307 201303 201304 Starting Cash Balance $ $ $ $ Change in Cash and Equivalents $ 5 $ S Minimum Cash Balance s $ $ 5 Surplus (Dell) Relative to Minimum 5 5 S $ Increase (Decrease) in Short Term Financing 5 5 Existing Short-term Financing $ 5 5 Total Short-term Financing S 5 Library lculator UZN ources $ dy tion Tools Enter any number in the edities and then continue to the next question 201204 2013Q1 2013Q2 2013Q3 2013Q4 E 6,000 3,900 550 1,550 Quarter Income Statement (5000) Sales Cost of Goods Sold Selling Gen, and Admin EBITDA Depreciation EBIT Taxes Net Income Statement of Cash Flow (5000) Net Income Depreciation Changes in Working Capital: Accounts Receivable Inventory 4,540 2,951 458 1,131 453 678 237 441 5,000 3,250 900 850 500 350 6,150 3,998 600 1,552 600 952 333 619 600 6,050 3,933 500 1,550 450 1.100 385 715 123 950 333 617 227 227 500 619 600 617 600 715 450 145 300 0 - 145 - 300 0 0 54 636 - 1,600 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. 100 1,019 -525 0 525 0 0 0 1,217 -530 0 -530 0 1,165 -525 0 - 525 0 0 0 1,600 0 0 0 0 -964 OOOO 0 OOololo 0 494 687