70.2K

Verified Solution

Link Copied!

Kristopher Company is a merchandising company that sells a single product. The company's inventories, production, and sales in units for the next three months have been forecasted as follows: October November December Beginning inventory Merchandise purchases Sales Ending inventory 10,000 60,000 60,000 10,000 10,000 70,000 70,000 10,000 10,000 35,000 40,000 5,000 Units are sold for $12 each. One fourth of all sales are paid for in the month of sale and the balance is paid in the following month. Accounts receivable at September 30 totaled $450,000 Merchandise is purchased for $7 per unit. Half of the purchases are paid for in the month of purchase and the remainder is paid in the month following purchase. Selling and administrative expenses are expected to total $120,000 each month, excluding depreciation. These will be paid as they are incurred. Depreciation is $5,000 per month. Accounts payable at September 30 totaled $230,000 and related only to merchandise purchases The cash balance at September 30 is $80,000. A payment of $300,000 for purchase of equipment is scheduled for November and a dividend of $200,000 is to be paid in December Company policy indicates a minimum cash balance of $80,000. They can borrow short- term from the bank at an interest rate of 8%. They never borrow more than they need and they must borrow and repay in increments of $1,000. Interest is paid when repayments are made. Required: Prepare a cash budget in good form for each of the months October, November and December, including all required supporting schedules

Answer & Explanation Solved by verified expert

See Answer