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 $ $520000$ December $$540000$

Forecast: Jan. $$600000$ Feb. $640,000$ March $$510000.$ The additonal information is April forecast $$500000.$

OF the firms sales $50\%$ are cash and the remaining $50\%$ are on credit. On credit $50\%$ are paid in the month after sale and $50\%$ are paid in the second month after the sael. Mateials cost $40\%$ fof sales and are purcased and received each month in an amount sufficient to cover the following months expedcted sdales. Material are paid for in the month after they are received. Labor expenses is $30\%$ of sal;es and is paid for in themonth of sales. Selling and aministration expenses is $20\%$ of sales and is paid in the month of sales. Overhead expenses is $$36000$ in cash per month. Depreciation expense is $$11600$ per month. taex of $$9600$ will be paid in January and dividends of $$10000$ will be paid in march. Cah at the beginning of Jan is $$112,000$ and the min desired cash ballance is $$107000.$ Prepare a monthyl budget with borrowings and repayments for Jan Feb and March.

The total cash payment is NOT $585600,612000$ and $505000.$ Prepare a schedule of monthly cash payments for January, February, and March.

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

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

Jote: Negative amounts should be indicated by a minus sign. Assume the January beginning loan balance is $$0.$ Leave no cells

lank be certain to enter $0$ wherever required.