Patricia’s housekeeping company has the following data projected for June. Beginning cash balance $24,500 Cash collections...

Patricia’s housekeeping company has the following data projected for June. Beginning cash balance $24,500 Cash collections from customers 36,200 Cash disbursements 54,300 Patricia wants to maintain a cash balance of $10,000 or more. Any amount below this can be borrowed from a local bank as needed in increments of $1,000. All borrowings are made at month end. In Patricia's cash budget for June, how much money will Patricia need to borrow at month end? A. $6,000 B. $5,000 C. $7,000 D. $4,000

Expert Solution

Patricia's housekeeping company wants to maintain a cash balance of $ 10,000 or more. If there is any shortage, then $ 1,000 in increments are to be borrowed inorder to have minimum cash balance. For example, if there is shortage of $500, then the company want to borrow $ 1,000 because only increments of $ 1,000 can be borrowed. So coming to the question,

Opening cash balance = $ 24,500.

Cash collections = $ 36,200.

Cash disbursements = $ 54,300.

So,

Closing balance = Opening balance + cash collections - cash disbursements.

Closing balance = 24,500+36,200-54,300

Closing balance = $ 6,400.

So company is having only $ 6,400 as closing balance. So they need to buy $ 3,600 inorder to get minimum balance of $ 10,000. But it is said that only increments of $ 1,000 can be borrowed from bank. So the company need to borrow $ 4,000 from bank so that the new ending balance will be $ 10,400.

Hence, option D is the correct answer.

SUMMARY:

Company is having shortage of $ 3,600. So it is said that only increments of $1,000 can be borrowed. If company borrows $3,000, then the ending balance will be only $ 9,400 which also results in shortage. So $4,000 is the amount needed to borrow from the local bank so that they can maintain atleast minimum balance of $10,000 or more.

Hence, option D is the correct answer.

That is $ 4,000 need to borrowed.

ekkarill92 answered 2 years ago

Your job is to create the following documents: Cash Budget (per quarter) Beginning cash balance Collections...

Your job is to create the following documents: Cash Budget (per quarter) Beginning cash balance Collections in quarter of sale Collections in quarter following sale Total cash available Payments in quarter of purchase Payments in quarter following purchase Direct labor Overhead Selling and Administrative expense Equipment purchases Dividends Total Cash Disbursements Net cash balance Minimum cash balance Excess (Deficiency) of cash Cash balance before interest on balance Interest earned on cash balance Cash balance after interest on balance Diesel Dynamo...

At the beginning of June, Circuit Country has a balance in inventory of $2,650. The following...

At the beginning of June, Circuit Country has a balance in inventory of $2,650. The following transactions occur during the month of June. June 2 Purchase radios on account from Radio World for $2,350, terms 2/15, n/45. June 4 Pay cash for freight charges related to the June 2 purchase from Radio World, $330. June 8 Return defective radios to Radio World and receive credit, $300. June 10 Pay Radio World in full. June 11 Sell radios to customers on...

At the beginning of June, Circuit Country has a balance in inventory of $2,900. The following...

At the beginning of June, Circuit Country has a balance in inventory of $2,900. The following transactions occur during the month of June. June 2 Purchase radios on account from Radio World for $2,600, terms 1/15, n/45. June 4 Pay cash for freight charges related to the June 2 purchase from Radio World, $380. June 8 Return defective radios to Radio World and receive credit, $200. June 10 Pay Radio World in full. June 11 Sell radios to customers on...

The company has a beginning cash balance of $7,000. Using the following information, calculate the ending...

The company has a beginning cash balance of $7,000. Using the following information, calculate the ending balance of cash: -Note receivable collected by the bank = $5,000 -Checks outstanding = $8,000 -Bank service fees = $1,000 -Non-sufficient funds (NSF) checks = $2,000 -Deposits Outstanding = $11,000 I know the anwer is 9000. Explain it!!!!! Suppose supplies at the beginning of the year equal $1,200. During the year, an additional $5,400 of supplies is purchased. At the end of the year,...

X Company has the following budgeted cash flows for January Cash collections $55,000 Cash Payments...

X Company has the following budgeted cash flows for January Cash collections $55,000 Cash Payments Inventory 17,000 Operating Expenses 13,000 Capital Expenditures 18,000 If the cash balance is $5,000 on January 1 and the company wants to maintain a minimum cash balance of $5,000, what amount can either be invested or used to pay down existing debt for January?

1.Centore Inc. has provided the following data for the month of June. There were no beginning...

1.Centore Inc. has provided the following data for the month of June. There were no beginning inventories; consequently, the direct materials, direct labor, and manufacturing overhead applied listed below are all for the current month. Work In Process Finished Goods Cost of Goods Sold Total Direct materials $ 650 $ 7,590 $ 24,860 $ 33,100 Direct labor 2,180 20,700 67,800 90,680 Manufacturing overhead applied 930 7,130 22,940 31,000 Total $ 3,760 $ 35,420 $ 115,600 $ 154,780 Manufacturing overhead for...

The following information relates to Stevens Company for June 20XX: Direct materials inventory, beginning balance $...

The following information relates to Stevens Company for June 20XX: Direct materials inventory, beginning balance $ 7,000 Direct materials inventory, ending balance 3,000 Work-in –process inventory, beginning balance 5,000 Work-in-process inventory, ending balance 8,000 Finished goods inventory, beginning balance 10,000 Finished goods inventory, ending balance 12,000 Direct Labor 48,000 Direct materials purchases 26,000 Indirect labor 6,000 Depreciation: factory equipment 11,000 Depreciation: office equipment 4,000 Insurance, factory 3,000 Advertising expense 8,000 Repair and maintenance, factory 5,000 Question 1: (1.0 point) Required:...

LockUp Corporation has the following items in the Petty Cash and Cash Collections combined as of...

LockUp Corporation has the following items in the Petty Cash and Cash Collections combined as of as of January 5, 2020 during the checking of Cash for December 31, 2019 balance sheet. a. Bills and Coins Denomination Bundle of 100 pcs Rolls of 50 coins Loose P 500 1 9 100 2 27 50 3 5 20 5 4 10 10 5 6 4 1 10 20 .25 40 16 b. Checks Maker Payee Date Amount Baran - Customer LockUp 12/30/2019 P...

28) O'Brien Company has the following information: Cash Balance, June 30 $50,000 Dividends paid in July...

28) O'Brien Company has the following information: Cash Balance, June 30 $50,000 Dividends paid in July 60,000 Cash paid for operating expenses in July 185,500 Depreciation expense in July 12,000 Cash collections on sales in July 510,000 Merchandise purchases paid in July 180,000 Purchase equipment for cash in July 94,500 O'Brien Company wants to maintain a minimum cash balance of $50,000. Assume that borrowing occurs at the beginning of the month and repayments occur at the end of the month....

The following data are revealed by King Kong Pty Ltd at 30 June 2019. Cash balance...

The following data are revealed by King Kong Pty Ltd at 30 June 2019. Cash balance at 1 July 2018 $50 000 Gain on sale of equipment 6 000 Income tax payments 21 000 Cash paid to suppliers 153 500 Cash received from customers 425 500 Proceeds from issue of shares 216 000 Proceeds from sale of land 76 000 Depreciation expense 55 000 Interest payments 30 000 Payments of long-term debt 16 500 Payments to employees 78 000 Dividends...

Question