Question

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 paid in cash in July $ 56,200 Equipment to be purchased for cash in July $ 20,500

RCH Company wishes to maintain a minimum cash balance of $25,000. 1 Dividends are payable to shareholders of record on declaration date, 30 days after declaration.

Required a. Prepare a cash budget for the month ended July 31, 2020, and indicate how much, if anything, RCH will need to borrow to meet its minimum cash requirement.

b. Explain how cash budgeting can reduce the cost of short-term borrowing.

Homework Answers

Answer #1
Cash Budget for the month ended July 31,2020
Particulars Amount($) Amount($)
Opening Cash Balance on July 01 45000
Add:
Cash Collections 89000
89000
134000
Less:
Operating Expenses 36800
Merchandise Purchases 56200
Equipment Purchase 20500
113500
20500
Short Term Borrowing(Bal Fig)=25000-20500 4500
Balance(To be Maintained) on July 31st 25000

Notes:

1.Dividends though declared are payable only after 30 days from declaration i.e on August 15,hence need not be considered in July's budget.

2.Amortisation expense is a non cash expense.

b. Short term borrowings usually come with High rate of interest. And only units with good credit rating can be eligible for such short term borrowings. hence cash budget obviates short term borrowings and allows the firm to have a control over the expenses to be incurred.

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 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...
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...
Sushi House has budgeted sales revenue as follows: June July August Credit Sales $85,000 $80,000 $72,000...
Sushi House has budgeted sales revenue as follows: June July August Credit Sales $85,000 $80,000 $72,000 Cash Sales 14,000 25,000 32,000 Total Sales $99,000 $105,000 $104,000 Past experience indicates that 70% of the credit sales will be collected in the month of sale and the remaining 30% will be collected in the following month. Purchases of inventory are all on credit and 60% is paid in the month of purchase and 40% in the month following purchase. Budgeted inventory purchases...
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...
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...
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...
Aztec Company sells its product for $180 per unit. Its actual and budgeted sales follow. Units...
Aztec Company sells its product for $180 per unit. Its actual and budgeted sales follow. Units Dollars April (actual) 4,500 $ 810,000 May (actual) 2,200 396,000 June (budgeted) 7,500 1,350,000 July (budgeted) 5,000 900,000 August (budgeted) 3,600 648,000 All sales are on credit. Recent experience shows that 30% of credit sales is collected in the month of the sale, 40% in the month after the sale, 29% in the second month after the sale, and 1% proves to be uncollectible....
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...
Jingga Big Supplies’ projected sales for the next six months of 2020 are given below. July...
Jingga Big Supplies’ projected sales for the next six months of 2020 are given below. July                             RM500,000     October           RM800,000 August                         RM600,000     November       RM900,000 September                  RM800,000     December       RM800,000 40% of sales is collected in the month of the sale, 50% is collected in the month following the sale, and 10% is written off as uncollectible. Cost of goods sold is 70% of sales. Purchases are made on the month prior to the...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT