The president of the retailer Prime Products has just approached the company’s bank with a request for a $30,000, 90-day loan. The purpose of the loan is to assist the company in acquiring inventories. Because the company has had some difficulty in paying off its loans in the past, the loan officer has asked for a
April | May | June | ||||
Sales (all on account) | $ | 300,000 | $ | 400,000 | $ | 250,000 |
Merchandise purchases | $ | 210,000 | $ | 160,000 | $ | 130,000 |
Payroll | $ | 20,000 | $ | 20,000 | $ | 18,000 |
Lease payments | $ | 22,000 | $ | 22,000 | $ | 22,000 |
Advertising | $ | 60,000 | $ | 60,000 | $ | 50,000 |
Equipment purchases | − | − | $ | 65,000 | ||
$ | 15,000 | $ | 15,000 | $ | 15,000 | |
-
Merchandise purchases are paid in full during the month following purchase. Accounts payable for merchandise purchases during March, which will be paid in April, total $140,000.
-
In preparing the cash budget, assume that the $30,000 loan will be made in April and repaid in June. Interest on the loan will total $1,200.
Required:
1. Calculate the expected cash collections for April, May, and June, and for the three months in total.
2. Prepare a cash budget, by month and in total, for the three-month period.
Trending nowThis is a popular solution!
Step by stepSolved in 3 steps with 5 images
The president of the retailer Prime Products has just approached the company’s bank with a request for a $30,000, 90-day loan. The purpose of the loan is to assist the company in acquiring inventories. Because the company has had some difficulty in paying off its loans in the past, the loan officer has asked for a
- On April 1, the start of the loan period, the cash balance will be $24,000.
Accounts receivable on April 1 will total $140,000, of which $120,000 will be collected during April and $16,000 will be collected during May. The remainder will be uncollectible. - Past experience shows that30% of a month’s sales are collected in the month of sale, 60% in the month followingsale, and 8% in the second month following sale. The other 2% represents
bad debts that are never collected. Budgeted sales and expenses for the three-month period follow:
|
April |
May |
June |
Sales (all on account) |
$300,000 |
$400,000 |
$250,000 |
Merchandise purchases |
$210,000 |
$160,000 |
$130,000 |
Payroll |
$20,000 |
$20,000 |
$18,000 |
Lease payments |
$22,000 |
$22,000 |
$22,000 |
Advertising |
$60,000 |
$60,000 |
$50,000 |
Equipment purchases |
- |
- |
$55,000 |
|
$15,000 |
$15,000 |
$15,000 |
- Merchandise purchases are paid in full during the month following purchase. Accounts payable for merchandise purchases during March, which will be paid during April, total $140,000.
- The company needs a minimum cash balance of $20,000 to start each month, the interest rate of loan is 12%. To maintain the cash balance, the company will borrows on the first day of the month and when the company have enough cash to repays loans and interest, it will pay on the last day of the month.
The president of the retailer Prime Products has just approached the company’s bank with a request for a $30,000, 90-day loan. The purpose of the loan is to assist the company in acquiring inventories. Because the company has had some difficulty in paying off its loans in the past, the loan officer has asked for a
- On April 1, the start of the loan period, the cash balance will be $24,000.
Accounts receivable on April 1 will total $140,000, of which $120,000 will be collected during April and $16,000 will be collected during May. The remainder will be uncollectible. - Past experience shows that30% of a month’s sales are collected in the month of sale, 60% in the month followingsale, and 8% in the second month following sale. The other 2% represents
bad debts that are never collected. Budgeted sales and expenses for the three-month period follow:
|
April |
May |
June |
Sales (all on account) |
$300,000 |
$400,000 |
$250,000 |
Merchandise purchases |
$210,000 |
$160,000 |
$130,000 |
Payroll |
$20,000 |
$20,000 |
$18,000 |
Lease payments |
$22,000 |
$22,000 |
$22,000 |
Advertising |
$60,000 |
$60,000 |
$50,000 |
Equipment purchases |
- |
- |
$55,000 |
|
$15,000 |
$15,000 |
$15,000 |
- Merchandise purchases are paid in full during the month following purchase. Accounts payable for merchandise purchases during March, which will be paid during April, total $140,000.
- The company needs a minimum cash balance of $20,000 to start each month, the interest rate of loan is 12%. To maintain the cash balance, the company will borrows on the first day of the month and when the company have enough cash to repays loans and interest, it will pay on the last day of the month.
- Papst Company is preparing its cash budget for the month of May. The following information is available concerning its accounts receivable (based on sales made to customers on open account): Actual credit sales for March Actual credit sales for April Estimated credit sales for May Estimated collections in the month of sale Estimated collections in the first month after the month of sale Estimated collections in the second month after the month of sale Estimated provision for bad debts (made in the month of sale) $225,000 $ 293,000 $ 438,000 25% 60% 10% 5% The firm writes off all uncollectible accounts at the end of the second month after the month of sale. Required: Determine for Papst Company for the month of May: 1. The estimated cash receipts from accounts receivable collections. 2. The gross amount of accounts receivable at the end of the month (after appropriate write-off of uncollectible accounts). 3. The net amount of accounts receivable at the end of the month. 4. Recalculate…arrow_forwardLois Bragg owns a small restaurant in Boston. Ms. Bragg provided her accountant with the following summary information regarding expectations for the month of June. The balance in accounts receivable as of May 31 is $57,000. Budgeted cash and credit sales for June are $148,000 and $589,000, respectively. Credit sales are made through Visa and MasterCard and are collected rapidly. Sixty percent of credit sales is collected in the month of sale, and the remainder is collected in the following month. Ms. Bragg's suppliers do not extend credit. Consequently, she pays suppliers on the last day of the month. Cash payments for June are expected to be $712,000. Ms. Bragg has a line of credit that enables the restaurant to borrow funds on demand; however, they must be borrowed on the last day of the month. Interest is paid in cash also on the last day of the month. Ms. Bragg desires to maintain a $32,000 cash balance before the interest payment. Her annual interest rate is 8 percent. Required…arrow_forwardThe president of the retailer Prime Products has just approached the company's bank with a request for a $57,000, 90-day loan. The purpose of the loan is to assist the company in acquiring inventories. Because the company has had some difficulty in paying off its loans in the past, the loan officer has asked for a cash budget to help determine whether the loan should be made. The following data are available for the months April through June, during which the loan will be used: On April 1, the start of the loan period, the cash balance will be $30,800. Accounts receivable on April 1 will total $159,600, of which $136,800 will be collected during April and $18,240 will be collected during May. The remainder will be uncollectible. Past experience shows that 30% of a month’s sales are collected in the month of sale, 60% in the month following sale, and 8% in the second month following sale. The other 2% is bad debts that are never collected. Budgeted sales and expenses for the…arrow_forward
- Boris runs a small manufacturing operation, producing and selling machine parts to European companies. At the start of April, his bank account had an overdrawn bank balance of $2,500. His bank has asked him to produce a budgeted bank balance for the end of April. Boris estimates that his customers will pay him $41,000 of what is owed while he will pay his suppliers $26,000 during the month. What is Boris's budgeted bank account balance at the end of April? $17,500 overdrawn $12,500 overdrawn $12,500 positive balance $17,500 positive balancearrow_forwardLane Products manufactures a popular kitchen utensil. The company recently expanded, and the controller believes that it will need to borrow cash to continue operations. It opened negotiations with the local bank for a one-month loan of $60,000 starting March 1. The bank would charge interest at the rate of 0.5 percent per month and require the company to repay interest and principal on March 31. In considering the loan, the bank requested a projected income statement and cash budget for March. The following information is available: The company budgeted sales at 22,000 units per month in February, April, and May and at 19,000 units in March. The selling price is $70 per unit. The company offers a 2 percent discount for cash sales. The company's experience is that bad debts average 1 percent of credit sales. The inventory of finished goods on February 1 was 3,400 units. The desired finished goods inventory at the end of each month equals 25 percent of sales anticipated for the…arrow_forwardThe president of the retailer Prime Products has just approached the company’s bank with a request for a $30,000, 90-day loan. The purpose of the loan is to assist the company in acquiring inventories. Because the company has had some difficulty in paying off its loans in the past, the loan officer has asked for a cash budget to help determine whether the loan should be made. The following data are available for the months April through June, during which the loan will be used: On April 1, the start of the loan period, the cash balance will be $24,000. Accounts receivable on April 1 will total $140,000, of which $120,000 will be collected during April and $16,000 will be collected during May. The remainder will be uncollectible. Past experience shows that30% of a month’s sales are collected in the month of sale, 60% in the month followingsale, and 8% in the second month following sale. The other 2% represents bad debts that are never collected. Budgeted sales and expenses for the…arrow_forward
- Minden Company is a wholesale distributor of premium European chocolates. The company's balance sheet as of April 30 is given below: Assets Cash Accounts receivable Inventory Buildings and equipment, net of depreciation Total assets Liabilities and Stockholders' Equity Accounts payable Minden Company Balance Sheet April 30 Note payable Common stock Retained earnings Total liabilities and stockholders' equity Required: For May: The company is in the process of preparing a budget for May and assembled the following data: a. Sales are budgeted at $247,000 for May. Of these sales, $74,100 will be for cash; the remainder will be credit sales. One-half of a month's credit sales are collected in the month the sales are made, and the remainder are collected in the following month. All of the April 30 accounts receivable will be collected in May. b. Purchases of inventory are expected to total $172,000 during May. These purchases will all be on account. Forty percent of all purchases are paid…arrow_forwardMotors Corporation manufactures motors for dirt bikes. The company requires a minimum $30,000 cash balance at each month-end. If necessary, the company borrows to meet this requirement at a cost of 3% interest per month (paid at the end of each month). Any preliminary cash balance above $30,000 at month-end is used to repay loans. The cash balance on July 1 is $43,000, and the company has no outstanding loans. Budgeted cash receipts and budgeted cash payments (other than for interest on the loan and loan activity) follow. July Cash receipts Cash payments $ 94,000 122,000 August September $120,000 108,900 $ 159,000 136,400 Prepare a cash budget for July, August, and September. Note: Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Round your final answers to the nearest whole dollar. Answer is not complete. MOTORS CORPORATION Cash Budget July August September Beginning cash balance $ 43,000 $ 30,000 $ 30,000 Add: Cash receipts 94,000 120,000…arrow_forwardThe Hubbard Corporation is a distributor of hair care products and is ready to start the third quarter, in which its peak sales occur. The company has requested a $100,000, 90-day loan from its bank to help them meet their cash requirements for the third quarter. Since Hubbard Corporation has experienced difficulty in paying off their loans in previous years, the loan officer has requested the company prepare a cash budget for the third quarter. The following data has been gathered by the staff. On July 1, 2021, the beginning of the third quarter, the company will have a cash balance of $75,000. Actual sales for the last 2 months and budgeted sales for the third quarter (all sales are on account). Month Amount in Dollars ($) May (actual) 500,000 June (actual) 480,000 July (budgeted) 520,000 August (budgeted) 550,000 September (budgeted) 600,000 Past experience shows that 30% of a month's sales are collected in the month of sale, 60% in the month…arrow_forward
- Lane Products manufactures a popular kitchen utensil. The company recently expanded, and the controller believes that it will need to borrow cash to continue operations. It opened negotiations with the local bank for a one-month loan of $56,000 starting March 1. The bank would charge interest at the rate of 0.5 percent per month and require the company to repay interest and principal on March 31. In considering the loan, the bank requested a projected income statement and cash budget for March. The following information is available: . The company budgeted sales at 20,000 units per month in February, April, and May and at 17,000 units in March. The selling price is $68 per unit. The company offers a 2 percent discount for cash sales. The company's experience is that bad debts average 1 percent of credit sales. The inventory of finished goods on February 1 was 3,200 units. The desired finished goods inventory at the end of each month equals 25 percent of sales anticipated for the…arrow_forwardWestern Company is preparing a cash budget for June. The company has $10,400 in cash at the beginning of June and anticipates $31,600 in cash receipts and $37,700 in cash payments during June. Western Company has an agreement with its bank to maintain a minimum cash balance of $10,000. As of May 31, the company has no loans outstanding. To maintain the $10,000 required balance, during June the company must:arrow_forwardUrban Industries needs to maintain a minimum cash balance of $10,000 and has entered into an agreement with their bank to accomplish this. Urban is preparing a cash budget for September. Urban has $11,300 in cash at the beginning of September and anticipates $30,700 in cash receipts and $35,900 in cash payments during September. As of August 31, the company has no loans outstanding. To maintain the $10,000 required balance, during September the company must: O A. Borrow $3,900. O B. Borrow $10,000. OC. Borrow $5,200. OD. Repay $3,900. OE.Repay $6.100.arrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education