Can someone please solve this and list out the math involved in the steps?

P 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 EEB,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.09 million in cash and that its bank will offer it a short-term loan at the rate 1.75% per quarter. Assume that the minimum cash balance to be maintained is S495000. Complete the cash budget based on the assumptions of the problem. (Round to the nearest integer.) Cash Balance and Short-Term Financing ($000) 2013Q1 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 $ L Enter any number in the edit fields and then click Check Answer. P 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 EEB,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.09 million in cash and that its bank will offer it a short-term loan at the rate 1.75% per quarter. Assume that the minimum cash balance to be maintained is S495000. Complete the cash budget based on the assumptions of the problem. (Round to the nearest integer.) Cash Balance and Short-Term Financing ($000) 2013Q1 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 $ L Enter any number in the edit fields and then click Check