Dai Hing Bookshop Ltd. has a beginning cash balance of $44,000 on November 1. The firm has projected sales of $61,000 in October, $68,000 in November, and $74,000 in December. The cost of goods sold is equal to 60 percent of sales. Goods are purchased one month prior to the month of sale and there is no ending inventory requirement. The accounts payable period is 30 days and the accounts receivable period is 15 days. The firm has monthly cash expenses of $16,000. What is the projected ending cash balance at the end of November and December? Assume every month has 30 days.

Dai Hing Bookshop Ltd. has a beginning cash balance of $44,000 on November 1. The firm has projected sales of $61,000 in October, $68,000 in November, and $74,000 in December. The cost of goods sold is equal to 60 percent of sales. Goods are purchased one month prior to the month of sale and there is no ending inventory requirement. The accounts payable period is 30 days and the accounts receivable period is 15 days. The firm has monthly cash expenses of $16,000. What is the projected ending cash balance at the end of November and December? Assume every month has 30 days.

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter7: Budgeting

Section: Chapter Questions

Problem 14EB: Earthies Shoes has 55% of its sales in cash and the remainder on credit. Of the credit sales, 70% is...

See similar textbooks

Similar questions

Langstons purchased $3,100 of merchandise during the month, and its monthly income statement shows a cost of goods sold of $3,000. What was the beginning inventory if the ending inventory was $1,250?
Nonnas Re-Appliance Store collects 55% of its accounts receivable in the month of sale and 40% in the month after the sale. Given the following sales, how much cash will be collected in February?
Halifax Shoes has 30% of its sales in cash and the remainder on credit. Of the credit sales, 65% is collected in the month of sale, 25% is collected the month after the sale, and 5% is collected the second month after the sale. How much cash will be collected in August if sales are estimated as $75,000 in June, $65,000 in July, and $90,000 in August?
Logo Gear purchased $2,250 worth of merchandise during the month, and its monthly income statement shows cost of goods sold of $2,000. What was the beginning inventory if the ending inventory was $1,000?
Earthies Shoes has 55% of its sales in cash and the remainder on credit. Of the credit sales, 70% is collected in the month of sale, 15% is collected the month after the sale, and 10% is collected the second month after the sale. How much cash will be collected in June if sales are estimated as $75,000 in April, $65,000 in May, and $90,000 in June?
My Aunts Closet Store collects 60% of its accounts receivable in the month of sale and 35% in the month after the sale. Given the following sales, how much cash will be collected in March?
Cash collections for Renew Lights found that 65% of sales were collected in the month of sale, 25% was collected the month after the sale, and 10% was collected the second month after the sale. Given the sales shown, how much cash will be collected in March and April?
Amusement tickets estimated sales are: What are the balances in accounts receivable for April, May, and June if 60% of sales are collected in the month of sale, 30% are collected the month after the sale, and 10% are collected the second month after the sale?
On January 1, Sweet Pleasures, Inc., begins business. The company has 14,000 cash on hand and is attempting to project cash receipts and disbursements through April 30. On May 1, a note payable of 10,000 will be due. This amount was borrowed on January 1 to carry the company through its first four months of operation. The unit purchase cost of the companys single product, a box of Sweet Pleasures chocolates, is 12. The unit sales price is 28. Projected purchases and sales in units for the first four months are: Sales terms call for a 5% discount if paid within the same month that the sale occurred. It is expected that 50% of the billings will be collected within the discount period, 25% by the end of the month after purchase, 19% in the following month, and 6% will be uncollectible. Approximately 60% of the purchases are paid for in the month purchased. The rest are due and payable in the next month. Total fixed marketing and administrative expenses for each month include cash expenses of 5,000 and depreciation on equipment of 2,000. Variable marketing and administrative expenses total 6 per unit sold. All marketing and administrative expenses are paid as incurred. REQUIREMENT You have been asked to prepare a cash budget for the next four months to see if the loan can be repaid. Review the worksheet CASHBUD that follows these requirements. The problem data have already been entered in the Data Section of the worksheet.
Jupiter stores had a Quarter 2 beginning cash balance of $430. Sales for Quarters 1 through 3 are estimated at $600, $800, and $900, respectively. The cost of goods sold is equal to 70 percent of sales. Goods are purchased one quarter prior to the month of sale. The accounts payable period is 30 days and the accounts receivable period is 15 days. The firm had quarterly cash expenses of $180. What was the cash balance at the end of Quarter 2?
As of January 1 of the current year, Grayson Company had accounts receivable of $40,000. The sales for January, February, and March were $120,000, $140,000, and $150,000, respectively. Of each month's sales, 20% are for cash. Of the remaining 80% (the credit sales), 60% are collected in the month of sale, with the remaining 40% collected in the following month. What is the total cash collected (both from accounts receivable and for cash sales) in the month of January?
At the end of September a company has cash balance of $800, trade receivables of $12000 and trade payables of $5000. The company can sell goods costing $9000 for $17100 in October. 50% of all sales are collected in the month of sale and the remainder in the following month. All purchases are made on credit and paid during the following month. Inventory levels will remain constant during the month. General cash expenses will be $600 during October. What is the cash balance at the end of October?