Please help fill out for Quarters 1-4 and also show your work or tell how you got the answer. thanks!

XP 20-20 (similar to) 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.07 million in cash and that its bank will offer it a short-term loan at the rate 2.75% per quarter. Assume that the minimum cash balance to be maintained is $485,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 6 6 6 6 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 $ 6 67 Enter any number in the edit fields and then click Check Answer. 4 parts Clear All 4 remaining Check Answer i Data Table 2012Q4 2013Q1 2013Q2 2013Q3 2013Q4 O 6,050 3,933 500 4,540 2,951 460 1,129 451 678 237 441 5,050 3,283 1,050 717 500 217 76 1,617 550 1,067 373 694 6,200 4,030 650 1,520 600 920 322 598 6,000 3,900 650 1,520 600 920 322 598 694 598 600 598 Quarter Income Statement ($000) Sales Cost of Goods Sold Selling ,Gen., and Admin. EBITDA Depreciation EBIT Taxes Net Income Statement of Cash Flow ($000) 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. 500 550 - 140 - 290 52 553 - 1,500 115 1,069 - 535 1.198 - 530 ,198 530 1,500 -535 0 0 0 -947534668 360 Print Done