You are the manager of Everyday Sports, Inc. (ESI) Store No. 5 located in Burlington, North Carolina. ESI carries a complete line of outdoor recreation gear. You are to prepare the stores master budget for June, July, August, and September of 2022, the main selling season. The division manager and the assistant controller (head of the Accounting Department) will arrive from headquarters next week to review the budget with you. The following information is needed to complete the master budget:

Cash collections follow sales. When the company needs extra cash, it borrows on six-month installment notes payable.

Your stores actual balance sheet at May 31, 2022 is below.

Sales in May were $40,000. The sales force predicts these future monthly sales are:

June 2022 $50,000

July 2022 80,000

August 2022 60,000

September 2022 50,000

Sales are 60% cash and 40% on credit. ESI collects all credit sales the month after the sale. The $16,000 of accounts receivable at May 31 are from credit sales in May. Uncollectible accounts are insignificant.

ESI maintains inventory equal to $20,000 plus 80% of the budgeted cost of goods sold for the following month. October 2022 projected cost of goods sold is $28,000. Cost of goods sold averages 70% of sales. These percentages are based on experience.

ESI pays for inventory as follows: 50% during the month of purchase and 50% during the next month. Accounts payable consists of inventory purchases only.

Monthly payroll has two parts: a salary of $2,500 plus sales commissions equal to 15% of the months sales. The company pays half this amount during the month and half early in the following month.

Other monthly expenses are as follows:

Rent expense $2,000, paid as incurred

Depreciation expense, including new truck 500

Insurance expense 200 expiration of prepaid amount

Miscellaneous expenses 5% of sales, paid as incurred

ESI plans to purchase a used delivery truck in June for $3,000 cash.

Corporate requires each store to maintain a minimum cash balance of $10,000 at the end of each month. The store can borrow money on 6-month notes payable of $1,000 each at an annual interest rate of 12%. Management borrows enough to maintain the $10,000 minimum, but not a great deal more. Notes payable require six equal monthly payments of principal, plus monthly interest on the entire unpaid principal. Borrowing and all principal and interest payments occur at the end of the month.

Income taxes are the responsibility of corporate headquarters, so you can ignore taxes for budgeting purposes.

Required (on Excel and in good form):

Prepare the budgeted cash disbursements for purchases and operating expenses (each month and total four months)

Prepare the cash budget (each month and total four months)

Prepare the budgeted income statement (each month and total four months)

Prepare the budgeted balance sheet at September 30, 2022