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 company’s 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.

Question

Want to see more full solutions like this?

Answer 1

Textbook Question

Chapter 21, Problem 1R

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 company’s 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:

Chapter 21, Problem 1R, On January 1, Sweet Pleasures, Inc., begins business. The company has 14,000 cash on hand and is

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.

Definition Definition Estimate of an organization's cash flow for a future period. A cash budget forecasts future cash receipts and payments from various sources for a fiscal year. A cash budget can be created once a month or once a week to determine the organization's cash position and ensure its performance in relation to the budget. It aids in determining whether the company has enough cash and cash equivalents to meet its operational needs in the future.

Expert Solution & Answer

To determine

Prepare a cash budget for the four months.

Explanation of Solution

Given data,

Excel Applications for Accounting Principles, Chapter 21, Problem 1R , additional homework tip 1

Figure (1)

Prepare a cash budget:

Excel Applications for Accounting Principles, Chapter 21, Problem 1R , additional homework tip 2

Figure (2)

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Students have asked these similar questions

Chai Me, Inc., a merchandiser of herbal tea products, began operations on January 1. The company expects sales in its first month of operations to total $18,000. 80% of the sales are expected to be cash sales. The remaining sales are expected to be on account and will carry payment terms of net 30. The company estimates that 99% of its sales on account will be collected in the month following the month of sale. The remaining 1% is deemed uncollectible. The company will recognize bad debt expense under the allowance method of accounting for bad debts in the month in which the credit sales occur. Inventory purchases during January are expected to equal $4,000. Purchases are paid for in the month of purchase. No purchase discounts are available. Chai pays its sales staff a 10% commission on all sales made. The commission expense is recognized in the month of sale and is paid on the 10th of the following month. Chai’s expected fixed monthly operating expenses are $4,570.…

On July 8, Azure Corporation enters into an agreement with one of its customers, Madsen, Inc. to provide them with 4,500 units at a cost of $500 per unit. Madsen sends a cash deposit of $225,000 on the same day. Azure sends the first 2,700 units on August 31, with an invoice for $675,000 due September 15. The remaining 1,800 units are delivered on October 15, along with an invoice for the remaining amount of the total $2,250,000 purchase price, due October 31. Madsen made all payments on the invoice due dates. Assume that Azure Corporation had no uncertainties about its own ability to meet the terms of the contract or about Madsen, Inc.'s ability and willingness to pay. Prepare the journal entries to record the events (leaving out the accounting for Azure's costs). Date July 8 August 31 September 15 October 15 October 31 Account To record the deposit. To record initial delivery of units. To collect cash on account. To record delivery of remaining units. To collect cash on account. <<…

Rooney Pointers Corporation expects to begin operations on January 1, year 1; it will operate as a specialty sales company that sells laser pointers over the Internet. Rooney expects sales in January year 1 to total $380,000 and to increase 15 percent per month in February and March. All sales are on account. Rooney expects to collect 67 percent of accounts receivable in the month of sale, 23 percent in the month following the sale, and 10 percent in the second month following the sale. Required a. Prepare a sales budget for the first quarter of year 1. b. Determine the amount of sales revenue Rooney will report on the year 1 first quarterly pro forma income statement. c. Prepare a cash receipts schedule for the first quarter of year 1. d. Determine the amount of accounts receivable as of March 31, year 1. Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Prepare a sales budget for the first quarter of year 1. Sales Budget…

Answer 2

Textbook Question

Chapter 21, Problem 1R

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 company’s 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:

Chapter 21, Problem 1R, On January 1, Sweet Pleasures, Inc., begins business. The company has 14,000 cash on hand and is

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.

Definition Definition Estimate of an organization's cash flow for a future period. A cash budget forecasts future cash receipts and payments from various sources for a fiscal year. A cash budget can be created once a month or once a week to determine the organization's cash position and ensure its performance in relation to the budget. It aids in determining whether the company has enough cash and cash equivalents to meet its operational needs in the future.

Expert Solution & Answer

To determine

Prepare a cash budget for the four months.

Explanation of Solution

Given data,

Excel Applications for Accounting Principles, Chapter 21, Problem 1R , additional homework tip 1

Figure (1)

Prepare a cash budget:

Excel Applications for Accounting Principles, Chapter 21, Problem 1R , additional homework tip 2

Figure (2)

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Answer 3

Textbook Question

Chapter 21, Problem 1R

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 company’s 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:

Chapter 21, Problem 1R, On January 1, Sweet Pleasures, Inc., begins business. The company has 14,000 cash on hand and is

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.

Definition Definition Estimate of an organization's cash flow for a future period. A cash budget forecasts future cash receipts and payments from various sources for a fiscal year. A cash budget can be created once a month or once a week to determine the organization's cash position and ensure its performance in relation to the budget. It aids in determining whether the company has enough cash and cash equivalents to meet its operational needs in the future.

Expert Solution & Answer

To determine

Prepare a cash budget for the four months.

Explanation of Solution

Given data,

Excel Applications for Accounting Principles, Chapter 21, Problem 1R , additional homework tip 1

Figure (1)

Prepare a cash budget:

Excel Applications for Accounting Principles, Chapter 21, Problem 1R , additional homework tip 2

Figure (2)

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Answer 4

Textbook Question

Chapter 21, Problem 1R

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 company’s 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:

Chapter 21, Problem 1R, On January 1, Sweet Pleasures, Inc., begins business. The company has 14,000 cash on hand and is

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.

Definition Definition Estimate of an organization's cash flow for a future period. A cash budget forecasts future cash receipts and payments from various sources for a fiscal year. A cash budget can be created once a month or once a week to determine the organization's cash position and ensure its performance in relation to the budget. It aids in determining whether the company has enough cash and cash equivalents to meet its operational needs in the future.

Expert Solution & Answer

To determine

Prepare a cash budget for the four months.

Explanation of Solution

Given data,

Excel Applications for Accounting Principles, Chapter 21, Problem 1R , additional homework tip 1

Figure (1)

Prepare a cash budget:

Excel Applications for Accounting Principles, Chapter 21, Problem 1R , additional homework tip 2

Figure (2)

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!

Answer 5

Textbook Question

Answer 6

Textbook Question

Answer 7

Expert Solution & Answer

To determine

Prepare a cash budget for the four months.

Explanation of Solution

Given data,

Excel Applications for Accounting Principles, Chapter 21, Problem 1R , additional homework tip 1

Figure (1)

Prepare a cash budget:

Excel Applications for Accounting Principles, Chapter 21, Problem 1R , additional homework tip 2

Figure (2)

Answer 8

Expert Solution & Answer

To determine

Prepare a cash budget for the four months.

Explanation of Solution

Given data,

Excel Applications for Accounting Principles, Chapter 21, Problem 1R , additional homework tip 1

Figure (1)

Prepare a cash budget:

Excel Applications for Accounting Principles, Chapter 21, Problem 1R , additional homework tip 2

Figure (2)

Answer 9

Expert Solution & Answer

Answer 10

Expert Solution & Answer

Answer 11

To determine

Prepare a cash budget for the four months.

Answer 12

Explanation of Solution

Given data,

Excel Applications for Accounting Principles, Chapter 21, Problem 1R , additional homework tip 1

Figure (1)

Prepare a cash budget:

Excel Applications for Accounting Principles, Chapter 21, Problem 1R , additional homework tip 2

Figure (2)

Answer 13

Ch. 21 - On January 1, Sweet Pleasures, Inc., begins...Ch. 21 - Open the file CASHBUD from the website for this...Ch. 21 - Can the 10,000 note be repaid on May 1? Explain.Ch. 21 - Prob. 4R Ch. 21 - The following four suggestions have been made to...Ch. 21 - Reset cells to their initial values. Sweet...Ch. 21 - Prob. 7R

Videos

Explanation of Solution

Want to see more full solutions like this?

Chapter 21 Solutions