Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
image text in transcribed
image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

International Financial Management

Authors: Jeff Madura

10th Edition

1439038333, 9781439038338

More Books

Students also viewed these Finance questions

Question

What is crowdsourcing in research?

Answered: 1 week ago

Question

1. What physical and mental tasks does the worker accomplish?

Answered: 1 week ago

Question

5. Why is the job done?

Answered: 1 week ago

Question

4. How does the worker do the job?

Answered: 1 week ago