Question

In: Accounting

Transcript Company is preparing a cash budget for June. The company has $125,000 cash at the...

Transcript Company is preparing a cash budget for June. The company has $125,000 cash at the beginning of the month and anticipates having total sales of $1,222,000, consisting of 25% cash sales and 75% credit card sales. The bank charges 3 percent for credit card deposits. The firm sets its selling price at 150 percent of the cost of purchases and pays the cost of each month's sales at the end of the month.

Other cash disbursements are $66,000 per month, 4 percent of the total sales and the cash purchase of a new tractor for $125,000. In addition, a $545,000 note will be due this month for equipment purchased last year. Transcript Company has an agreement with its bank to maintain a cash balance of $125,000.

Required: What is the cash balance and what amount, if any, must the company borrow during June?

Solutions

Expert Solution

Note : I have rounded off answer to nearest dollar

Answer

Cash Balance at the end = $125000

Borrowings required = $ 405042

Transcript Company
Cash Budget for June
Beginning cash balance $            125,000
Add:
      Cash Sales 25% of $1222000 $            305,500
      Credit card sales 75% of $1222000 less 3% Bank charges $            889,005
Total Available Cash $        1,319,505
Less:
    Cash Payments for merchandise = 1222000*100/150 $            814,667
     Monthly Cash Disbursements $              66,000
     4% of Total Sale = 4% of 1222000 $              48,880
     New Tractor purchase $            125,000
     Note Due for payment $            545,000
Total Disbursements $        1,599,547
Net Cash Balance or Deficiency of Cash $         (280,042)
Add; Financing $            405,042
Less: Repayment of borrowings
Ending Cash Balance $            125,000

Workings

Amount of merchandise purchases and paid during June = $1222000 x 100/150 = $814666.67 or rounded off to $814667

Amount of borrowings  

Cash deficient after disbursements = $280042

Ending balance required = $125000

So borrowings required = $280042 + $125000 = $405042

Hit Thumbs up if satisfied

Have any query mention in comment section please

Thank you

ekkarill92 answered 3 months ago
Next > < Previous

Related Solutions

Transcript Company is preparing a cash budget for June. The company has $145,000 cash at the...
Transcript Company is preparing a cash budget for June. The company has $145,000 cash at the beginning of the month and anticipates having total sales of $1,222,000, consisting of 25% cash sales and 75% credit card sales. The bank charges 3 percent for credit card deposits. The firm sets its selling price at 150 percent of the cost of purchases and pays the cost of each month's sales at the end of the month. Other cash disbursements are $66,000 per...
Honolua Company is preparing a cash budget for November. The company has $150,000 cash at the...
Honolua Company is preparing a cash budget for November. The company has $150,000 cash at the beginning of November and anticipates total sales of $1,000,000, consisting of 25% cash sales and 75% bank credit-card sales. The bank charges 3% for credit-card deposits. The firm sets its selling price at 160% of the cost of purchases and pays the cost of each month's sales at the end of the month. Operating expenses are $45,000 per month, of which $25,000 is depreciation...
Cash Budget The owner of a building supply company has requested a cash budget for June....
Cash Budget The owner of a building supply company has requested a cash budget for June. After examining the records of the company, you find the following: Cash balance on June 1 is $1,436. Actual sales for April and May are as follows: April May Cash sales $10,000 $18,000 Credit sales 28,900 35,000 Total sales $38,900 $53,000 Credit sales are collected over a 3-month period: 40% in the month of sale, 30% in the second month, and 20% in the...
A company is preparing completing their Cash Budget. The following data has been prepared for cash...
A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash payments 954,500 1,210,000 1,075,000 The company’s cash balance at January 1st is $290,000. This company desires a minimum cash balance of $340,000. What is the amount of excess cash or deficiency of cash (after considering the minimum cash balance required) for February?
5. ABC Company is preparing their master budget and is preparing a schedule of expected cash...
5. ABC Company is preparing their master budget and is preparing a schedule of expected cash collections from sales for the first quarter of 2019. They expect sales in January to be $400,000, February to be $300,000, and March to be $500,000. !0% of the sales will be paid for in cash. The remainder will be charged on account. From past experience, the company knows their customers take 3 months to pay their bills in total, with 40% of a...
A company is preparing their 4th quarter cash summary budget. Based on their beginning cash balance...
A company is preparing their 4th quarter cash summary budget. Based on their beginning cash balance and anticipated cash receipts and cash disbursements (payments), here are the ending cash balances initially planned each month.  The balances shown below are BEFORE any borrowing of money or repayment of loans and interest. Management wants to keep a minimum cash balance of $20,922. Therefore, they will clearly need to borrow money in November. Luckily, December looks like a good month and they will have...
Bench Corporation is a merchandising company that is preparing a cash budget for the third quarter....
Bench Corporation is a merchandising company that is preparing a cash budget for the third quarter. They have the following budget information available.   1. Estimated sales for July, August, September, and October will be $210,000, $230,000, $220,000, and $240,000. Accounts receivable from June sales are $136,000. All sales are on credit and collected 35% in the month of sale and 65% in the month following sale. 2. Inventory purchases for July, August, and September are budgeted as $129,600, $136,200, and...
Bench Corporation is a merchandising company that is preparing a cash budget for the third quarter....
Bench Corporation is a merchandising company that is preparing a cash budget for the third quarter. They have the following budget information available.   1. Estimated sales for July, August, September, and October will be $210,000, $230,000, $220,000, and $240,000. Accounts receivable from June sales are $136,000. All sales are on credit and collected 35% in the month of sale and 65% in the month following sale. 2. Inventory purchases for July, August, and September are budgeted as $129,600, $136,200, and...
Bench Corporation is a merchandising company that is preparing a cash budget for the third quarter....
Bench Corporation is a merchandising company that is preparing a cash budget for the third quarter. They have the following budget information available.   1. Estimated sales for July, August, September, and October will be $210,000, $230,000, $220,000, and $240,000. Accounts receivable from June sales are $136,000. All sales are on credit and collected 35% in the month of sale and 65% in the month following sale. 2. Inventory purchases for July, August, and September are budgeted as $129,600, $136,200, and...
A company is preparing the production budget
A company is preparing the production budget for the second quarter Projected sales (in units) are as follows: • April 600 Units • May 680 units • June 750 units The company policy decided at the start of the period on 1 April to have an ending finished goods stocks of 20% of the next month's projected sales. Assuming that there was no opening stock for April, what should be the production quota for May? Select one: O a. 680 units O b. 666 units O c....
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT