Question

The controller of Trenshaw Company wants to improve the company’s control system by preparing a month-by-month...

The controller of Trenshaw Company wants to improve the company’s control system by preparing a month-by-month cash budget. The following information is for the month ending July 31, 2017. June 30, 2017, cash balance $45,000 Dividends to be declared on July 15* 12,000 Cash expenditures to be paid in July for operating expenses 40,800 Amortization expense in July 4,500 Cash collections to be received in July 90,000 Merchandise purchases to be paid in cash in July 56,200 Equipment to be purchased for cash in July 20,000 *Dividends are payable 30 days after declaration to shareholders of record on the declaration date. Trenshaw Company wants to keep a minimum cash balance of $25,000. (a) Prepare a cash budget for the month ended July 31, 2017, and indicate how much money, if any, Trenshaw Company will need to borrow to meet its minimum cash requirement.

Homework Answers

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 controller of Rise Coffee House (RCH) Company wishes to improve the company’s control system by...
The controller of Rise Coffee House (RCH) Company wishes to improve the company’s control system by preparing a month-by-month cash budget. The following information relates to the month ending July 31, 2020. June 30, 2020 cash balance $ 45,000 Dividends to be declared on July 15 1 $ 12,000 Cash expenditures to be paid in July for operating expenses $ 36,800 Amortization expense in July $ 4,500 Cash collections to be received in July $ 89,000 Merchandise purchases to be...
Jefferson Company has the following information: Cash Balance, April 31                              &nbs
Jefferson Company has the following information: Cash Balance, April 31                                                $45,000 Dividends paid in May                                                12,000 Cash paid for operating expenses in May                 36,800 Equipment depreciation expense in May                    4,500 Patent amortization expense in May                            2,000 Cash collections on sales in May                                99,000 Merchandise purchases paid in May                         56,200 Purchase equipment for cash in May                         17,500 Jefferson Company wants to keep a minimum cash balance of $15,000. Assume that borrowing occurs at the beginning of the month and repayments occur...
Wolfpack Company is a merchandising company that is preparing a budget for the month of July....
Wolfpack Company is a merchandising company that is preparing a budget for the month of July. It has provided the following information: Wolfpack Company Balance Sheet June 30 Assets Cash $ 79,200 Accounts receivable 68,600 Inventory 40,200 Buildings and equipment, net of depreciation 213,000 Total assets $ 401,000 Liabilities and Stockholders’ Equity Accounts payable $ 56,000 Common stock 100,000 Retained earnings 245,000 Total liabilities and stockholders’ equity $ 401,000 Budgeting Assumptions: All sales are on account. Thirty percent of the...
Cash Budget The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash budget...
Cash Budget The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: May June July Sales $128,000 $155,000 $216,000 Manufacturing costs 54,000 67,000 78,000 Selling and administrative expenses 37,000 42,000 48,000 Capital expenditures _ _ 52,000 The company expects to sell about 10% of its merchandise for cash. Of sales on account, 60% are expected to be collected in the month following the...
The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash budget for the...
The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: May June July Sales $90,000 $108,000 $148,000 Manufacturing costs 38,000 46,000 53,000 Selling and administrative expenses 26,000 29,000 33,000 Capital expenditures _ _ 36,000 The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and...
Cash Budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget...
Cash Budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: September October November Sales $101,000 $126,000 $169,000 Manufacturing costs 42,000 54,000 61,000 Selling and administrative expenses 35,000 38,000 64,000 Capital expenditures _ _ 41,000 The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the...
Southland Company is preparing a cash budget for August. The company has $18,400 cash at the...
Southland Company is preparing a cash budget for August. The company has $18,400 cash at the beginning of August and anticipates $123,600 in cash receipts and $137,300 in cash payments during August. Southland Company wants to maintain a minimum cash balance of $10,000. To maintain the minimum cash balance of $10,000, the company must borrow:
Beech Corporation is a merchandising company that is preparing a master budget for the third quarter...
Beech Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company’s balance sheet as of June 30th is shown below: Beech Corporation Balance Sheet June 30 Assets Cash $ 75,000 Accounts receivable 140,000 Inventory 66,500 Plant and equipment, net of depreciation 227,000 Total assets $ 508,500 Liabilities and Stockholders’ Equity Accounts payable $ 88,000 Common stock 311,000 Retained earnings 109,500 Total liabilities and stockholders’ equity $ 508,500 Exercise 8-12...
Cash Budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget...
Cash Budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: September October November Sales $106,000 $137,000 $173,000 Manufacturing costs 45,000 59,000 62,000 Selling and administrative expenses 37,000 41,000 66,000 Capital expenditures _ _ 42,000 The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the...
Cash Budget The controller of Dash Shoes Inc. instructs you to prepare a monthly cash budget...
Cash Budget The controller of Dash Shoes Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: March April May Sales $145,000 $180,000 $247,000 Manufacturing costs 61,000 77,000 89,000 Selling and administrative expenses 42,000 49,000 54,000 Capital expenditures _ _ 59,000 The company expects to sell about 15% of its merchandise for cash. Of sales on account, 60% are expected to be collected in the month following the...