Shadow Begone purchases and installs sky lights. The entity’s estimated sales and expenses for the first 4 months of 2025 are below.

Required

(a) Prepare a monthly schedule of expected cash receipts for the first quarter of 2025.

(b) Prepare a monthly purchases budget for the first quarter of 2025.

(c) Prepare a monthly schedule of expected cash payments for the first quarter of 2025.

(d) Prepare a monthly cash budget for the first quarter of 2025.

(e) Prepare a monthly budgeted statement of financial performance for the first quarter of 2025.

(f) Calculate the difference between the expected increase in cash and the expected profit or loss for the first quarter. Explain why the two amounts are different.

Transcribed Image Text:

January February March April Sales Expenses $1 087 500 $285 000 1 410 000 285 000 975 000 285 000 870 000 285 000 Actual sales for November and December 2024 were $875 000 and $925 000 respectively and actual expenses were $295 000 for each month. All sales are on credit, and the firm estimates that 40% of the accounts receivable will be collected in the month after sale with the other 60% collected in the second month following sale. The average selling price for the products sold is $5000. The cash balance as at 1 January 2025 is expected to be $100 000. The firm pays for 40% of its purchases in the month after purchase and the balance is paid in the second month following purchase. Average gross profit margin is 50%. The firm plans to continue maintaining an end-of-month inventory equal to 20% of the next month's projected cost of sales. Depreciation amounting to $25 000 per month and wages of $123 000 are included in the monthly expenses of $285 000. Other expenses are paid during the month they are incurred.