Help me solve these and explain them thank you very much!!!

Hello, sorry for not providing income statement. Here it is!!

Mountain Sports has aquired an open line of credit up to a maximum of $350,000. It will be necessary to convince the bank manager of this new Canmore branch ability to repay its line of credit including any interest. Management has provided the following list of assumptions to help in the preparation of the cash budget (note: you will need to use the projected income statement provided in Question 4 to complete the cash budget): 1. Beginning cash balance invested by owners $ 60,000 Quarter 1 Quarter 2 Quarter 3 Quarter 4 2. Sales by quarter (as % of total projected sales) 27% 26% 26% 21% 3. Type of collections from customers: Cash Sales Credit Sales (accounts receivable) 40% 60% Cash sales are collected in the quarter of the sale, all credit sales are collected in the quarter after the sale. 4. Merchandise purchases Merchandise purchases (cost of goods sold) are all paid in the quarter following purchase. (Quarter 1 purchases are bought in Quarter 1 but paid for in quarter 2). 5. Operating expenses All other operating expenses (all expenses except cost of goods sold) are paid on a monthly basis. 6. Required investment in equipment paid in cash in the first quarter $ 132,000 7. Quarterly income tax payments paid in cash $ 8.000 8. Minimum cash balance $ 29,000 9. Borrowing and Repayments: Any borrowing will take place on the first day of the quarter and any repayments are paid at the end of the quarter. All borrowing and payments are made in increments of $1,000. Interest on borrowing can be ignored. Required: Prepare a cash budget for the first year of operation in Canmore by quarter and in total. Show clearly on your budget the quarter(s) in which borrowing will be needed and the quarter(s) in which repayments can be made, as requested by the company's bank. Mountain Sports Cash Budget For the year ended December 31 Percent of Sales Estimated Sales 1 27% $142.020 Quarter 2 26% $136.760 26% $ 136,760 4 21% $110,460 Year Summary 100% $526.000 CASH BALANCE, Beginning $ 60,000 Collections from customers: Cash Sales Credit Sales CASH AVAILABLE Less: Cash Payments Merchandise purchases (COGS) Sales Commissions Advertising Sales Commissions Advertising Property Taxes Rent Salaries & Wages Equipment Purchase Income tax Installment Total Disbursements Cash Excess (Deficiency) Financing (Note 1) Borrow Repayment of Principal (show as negative) Net Financing - Cash Balance, Ending Note 1: Financing Calculations Cash excess (Deficiency) Minimum cash balance Amount to borrow (repay) Borrowing (Repayments) Rounded to increment of $1,000 % Management has provided the following income statement to the bank manager the expected Static Budget Amount Sales in Units 4,208 Sales 526,000 100% Less: Variable Costs: Cost of Goods Sold 221,000 42% Sales Commissions 78,900 15% Total Variable Costs 299.900 57% Contribution Margin 226,100 43% Less: Fixed Costs: Advertising 24,000 Property Taxes 9,000 Rent 50,000 Salaries & Wages 103,000 Total Fixed Costs 186,000 Net Operating Income 40.100