kindly solve this question

Construct a short-term financial plan for Whistler Snowboards based on its expansion opportunity described in the following table, which forecasts additional capital expenditures, marketing (SG&A), and working capital in Q1 and Q2 along with higher sales in Q2 to Q4. Assume that Whistler ends 2019 with $1.06 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 $505,000. Complete the cash budget based on the assumptions of the problem. (Round to the nearest $000.) Cash Balance and Short-Term Financing ($000) 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 $ GA A S S LA $ $ GA *** 2020Q1 e viatic alcul Al A Quarter Income Statement ($000) Sales Cost of Goods Sold Selling,Gen., and Admin. 5 EBITDA Depreciation B EBIT 9 Taxes 0 Net Income 1 Statement of Cash Flow ($000) 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 29 30 Quarter B 201904 4550 2958 460 1132 451 681 238 443 443 C D 202001 202002 5150 3348 950 852 500 352 123 229 229 500 -130 46 645 -1500 0 -1500 OOOO 0 0 0 -855 6200 4030 700 1470 450 1020 357 663 663 450 -300 100 913 -520 0 -520 0 OOO 393 E 202003 6200 4030 600 1570 400 1170 410 760 760 400 0 OO 635 0 1160 -525 0 -525 60005 F 202004 6100 3965 700 1570 450 1120 392 728 728 450 0 000 1178 -535 0 -535 0 0 003 643 S