Question

he president of the retailer Prime Products has just approached the company’s bank with a request...

he 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:

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.

b.

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% 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 $ ?   ?    65,000   
  Depreciation $ 15,000    $ 15,000    $ 15,000   
c.

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.

d.

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.

Prepare a schedule of 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. (Cash deficiency, repayments and interest should be indicated by a minus sign.)

     

Homework Answers

Answer #1

Solution 1:

Schedule of expected cash collection - Prime Products
Particulars April May June Total
Accounts receivables $120,000.00 $16,000.00 $136,000.00
Cash received for April Sale $90,000.00 $180,000.00 $24,000.00 $294,000.00
Cash received for May Sale $120,000.00 $240,000.00 $360,000.00
Cash received for June Sale $75,000.00 $75,000.00
Budgeted Cash Collection $210,000.00 $316,000.00 $339,000.00 $865,000.00

Solution 2:

Cash Budget - Prime Products
Particulars April May June Total
Beginning Cash balance $24,000.00 $22,000.00 $26,000.00 $24,000.00
Total reciepts $210,000.00 $316,000.00 $339,000.00 $865,000.00
Total cash available (A) $234,000.00 $338,000.00 $365,000.00 $889,000.00
Cash Disbursements:
Purchase of merchandise $140,000.00 $210,000.00 $160,000.00 $510,000.00
Payroll $20,000.00 $20,000.00 $18,000.00 $58,000.00
Lease payment $22,000.00 $22,000.00 $22,000.00 $66,000.00
Advertisting $60,000.00 $60,000.00 $50,000.00 $170,000.00
Equipment purchases $0.00 $0.00 $65,000.00 $65,000.00
Total cash disbursements (B) $242,000.00 $312,000.00 $315,000.00 $869,000.00
Excess of cash available over disbursement (A-B) -$8,000.00 $26,000.00 $50,000.00 $20,000.00
Financing:
Borrowings $30,000.00 $0.00 $0.00 $30,000.00
Loan principal repaid $0.00 $0.00 $30,000.00 $30,000.00
Loan interest paid $0.00 $0.00 $1,200.00 $1,200.00
Total financing $30,000.00 $0.00 -$31,200.00 -$1,200.00
Ending cash balance $22,000.00 $26,000.00 $18,800.00 $18,800.00
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
The president of the retailer Prime Products has just approached the company’s bank with a request...
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 cash budget to help determine whether the loan should be made. The following data are available for the months April through June, during which...
Problem 8-23 Schedule of Expected Cash Collections; Cash Budget [LO8-2, LO8-8] The president of the retailer...
Problem 8-23 Schedule of Expected Cash Collections; Cash Budget [LO8-2, LO8-8] The president of the retailer Prime Products has just approached the company’s bank with a request for a $51,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...
COURSE PROJECT 1 INSTRUCTIONS You have just been contracted as a new management trainee by Earrings...
COURSE PROJECT 1 INSTRUCTIONS You have just been contracted as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. Since you are well trained in budgeting, you have decided to prepare a master budget for the upcoming second quarter. To this end, you have...
You have just been hired as a new management trainee by Earrings Unlimited, a distributor of...
You have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. Since you are well trained in budgeting, you have decided to prepare a master budget for the upcoming second quarter. To this end, you have...
Deacon Company is a merchandising company that is preparing a budget for the three-month period ended...
Deacon Company is a merchandising company that is preparing a budget for the three-month period ended June 30th. The following information is available Deacon Company Balance Sheet March 31 Assets Cash $ 55,000 Accounts receivable 36,000 Inventory 40,000 Buildings and equipment, net of depreciation 100,000 Total assets $ 231,000 Liabilities and Stockholders’ Equity Accounts payable $ 51,300 Common stock 70,000 Retained earnings 109,700 Total liabilities and stockholders’ equity $ 231,000 Budgeted Income Statements April May June Sales $ 100,000 $...
You have just been hired as a new management trainee by Earrings Unlimited, a distributor of...
You have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. Since you are well trained in budgeting, you have decided to prepare a master budget for the upcoming second quarter. To this end, you have...
You have just been contracted as a new management trainee by Earrings Unlimited, a distributor of...
You have just been contracted as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. Since you are well trained in budgeting, you have decided to prepare a master budget for the upcoming second quarter. To this end, you have worked with accounting and...
You have just been contracted as a new management trainee by Earrings Unlimited, a distributor of...
You have just been contracted as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. Since you are well trained in budgeting, you have decided to prepare a master budget for the upcoming second quarter. To this end, you have worked with accounting and...
Deacon Company is a merchandising company that is preparing a budget for the three-month period ended...
Deacon Company is a merchandising company that is preparing a budget for the three-month period ended June 30th. The following information is available Deacon Company Balance Sheet March 31 Assets Cash $ 60,000 Accounts receivable 30,000 Inventory 43,900 Buildings and equipment, net of depreciation 131,000 Total assets $ 264,900 Liabilities and Stockholders’ Equity Accounts payable $ 72,000 Common stock 70,000 Retained earnings 122,900 Total liabilities and stockholders’ equity $ 264,900 Budgeted Income Statements April May June Sales $ 113,000 $...
You have just been hired as a new management trainee by Earrings Unlimited, a distributor of...
You have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. Since you are well trained in budgeting, you have decided to prepare a master budget for the upcoming second quarter. To this end, you have...