Jayden$$s Carryout Stores has eight locations. The firm wishes to expand by two more stores and needs a bank loan to do this. Mrs$.$ Wilson, the banker, will finance construction if the firm can present an acceptable three$-$month financial plan for January through March. The following are actual and forecast sales figures:

Actual Forecast Additional Information

November $ $500,000$ January $ $580,000$ April forecast $ $490,000$

December $520,000$ February $620,000$

March $500,000$

Of the firm$$s sales, $40$ percent are for cash and the remaining $60$ percent are on credit. Of credit sales, $40$ percent are paid in the month after sale and $60$ percent are paid in the second month after the sale. Materials cost $20$ percent of sales and are purchased and received each month in an amount sufficient to cover the following month$$s expected sales. Materials are paid for in the month after they are received. Labor expense is $50$ percent of sales and is paid for in the month of sales. Selling and administrative expense is $20$ percent of sales and is paid in the month of sales. Overhead expense is $$26,000$ in cash per month.

Depreciation expense is $$11,500$ per month. Taxes of $$9,500$ will be paid in January, and dividends of $$9,500$ will be paid in March. Cash at the beginning of January is $$110,000,$ and the minimum desired cash balance is $$105,000.$

Prepare a schedule of monthly cash receipts for January, February, and March.

Prepare a schedule of monthly cash payments for January, February, and March.

Note: Input all amounts as positive. Leave no cells blank be certain to enter $0$ wherever required.

Prepare a monthly cash budget with borrowings and repayments for January, February, and March.

Note: Negative amounts should be indicated by a minus sign. Assume the January beginning loan balance is $$0.$ Leave no cells blank be certain to enter $0$ wherever required.