Question

In: Accounting

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. Interest of 1% per month is paid in cash at the end of each month debt is outstanding. Borrowing and repayment is carried out in multiples of $1,000. Required: Prepare a cash budget for July. Answer: Beginning cash balance $50,000 Minimum cash balance desired 50,000 Available cash balance $0 Cash receipts and disbursements: Collections from customers $510,000 Payments for merchandise (180,000) Payments for operating expenses (185,500) Dividends paid (60,000) Purchase equipment for cash (94,500) Net cash receipts and disbursements (10,000) Deficiency of cash before financing $(10,000) Borrowing(at beginning of month) 11,000 Interest Payment($11,000 x 1%) (110) Total cash increase from financing 10,890 Ending cash balance $50,890

How is the ending balance $50,890?

Solutions

Expert Solution

Cash budget for July

Beginning cash balance

50000

Cash collections on sales in July

510,000

Cash Available for disbursements (A)

560,000

Less: Cash disbursements

Merchandise purchases paid in July

180,000

Cash paid for operating expenses in July

185,500

Dividends paid in July

60,000

Purchase equipment for cash in July

94,500

Total Cash disbursements (B)

520,000

Add: minimum cash Balance

50,000

Total cash needed for maintain cash balance of 50000

570,000

Deficiency of cash before financing (560000-570000)

-10,000

Financing

Borrowing of loan

11000

Repayment of loan

Interest paid (11000*1%)

-110

Total Financing ( C )

10890

Ending cash balance (A - B + C)

50,890

Company need to borrow money for 11000 (10000 for maintain cash balance and 1000 for interest payment).

Depreciation expense in non-cash expense. It is not considered for cash budget.


Related Solutions

The cash records of Carla Vista Company show the following. For July: 1. The June 30...
The cash records of Carla Vista Company show the following. For July: 1. The June 30 bank reconciliation indicated that deposits in transit total $ 780. During July, the general ledger account Cash shows deposits of $ 18,190, but the bank statement indicates that only $15,990 in deposits were received during the month. 2. The June 30 bank reconciliation also reported outstanding checks of $ 935. During the month of July, Carla Vista Company books show that $ 19,400 of...
A company has the following information. 1. Cash balance per bank, July 31, $7,328 2. July...
A company has the following information. 1. Cash balance per bank, July 31, $7,328 2. July bank service charge on bank statement, $40 3. Cash balance per company books, July 31, $7,280 4. Bank statement shows a Note Receivable of $2,000 plus $16 of interest was collected by the bank. 5. Outstanding checks, July 31, $772 6. Deposits in transit, July 31, $2,700 Compute the adjusted cash balance per company books. Do not enter a dollar sign or any commas.
3. Carter Inc. has the following information for July: Cash T-Account Balance, July 31 $8,069 Cash...
3. Carter Inc. has the following information for July: Cash T-Account Balance, July 31 $8,069 Cash as per Bank Statement, July 31; $6,522 Deposits in Transit $3000 Service Charges $27 Outstanding Checks $550 Interest Earned on Account $30 EFT Accounts Receivable Collection from Customers $900 a.) Prepare a bank reconciliation dated July 31. b.) Prepare any journal entries necessary to make the accounting records correct and complete. c.) What amount of cash should be reported on the July 31 Balance...
The information relates to the Cash Account in the ledger of Covid Company : Balance June...
The information relates to the Cash Account in the ledger of Covid Company : Balance June 1 $7,150 ; cash deposited $64,000; Balance June 30 $17,404 ; checks written $63,746. The June bank statement shows a balance of $16,122 on June 30. The following are memoranda from bank : Collection of $1,500 note plus interest $30; Interest earned on checking account $45; NSF check from Violet Jones $725; Safety deposit box rent $65. At June 30, deposits in transit were...
Upham Company’s June 30, 2016, balance sheet included the following information: Upham Company Partial Balance Sheet...
Upham Company’s June 30, 2016, balance sheet included the following information: Upham Company Partial Balance Sheet June 30, 2016 1 Accounts Receivable $248,000.00 2 Less: Allowance for Doubtful Accounts (14,400.00) $233,600.00 3 Notes Receivable 21,400.00 4 Total Receivables $255,000.00 5 * The company has a recourse liability of $2,450 for notes receivable sold with recourse. During the company’s fiscal year ending June 30, 2017, the following transactions occurred: 1. Sales on credit $870,400 2. Collections of accounts receivable 842,800 3....
On July 1, 2020, IBM Inc. purchased a 3-year, $50,000 bond with a June 30, 2023...
On July 1, 2020, IBM Inc. purchased a 3-year, $50,000 bond with a June 30, 2023 maturity date. The bond’s stated rate of interest was 5%, paid semiannually (June 30 and December 31). The bond was purchased at face value for $50,000 and properly reported as a trading security. The fair market value of the bond purchased by IBM was $51,000 on December 31, 2020. What was the balance in the Securities Fair Value Adjustment account at December 31, 2020?...
M&H Ltd. budgeted the following information for 2020: May June July August Budgeted purchases $50,000 $60,000...
M&H Ltd. budgeted the following information for 2020: May June July August Budgeted purchases $50,000 $60,000 $45,000 $55,000 •        Cost of goods sold is 50% of sales. Accounts payable is used only for inventory acquisitions. •        M&H purchases and pays for merchandise 50% in the month of acquisition and 50% in the following month. •        Selling and administrative expenses are budgeted at $30,000 for May and are expected to increase 2% per month. They are paid during the month of...
The following information is for Blossom Company: 1. Cash balance per bank, July 31, $8,836. 2....
The following information is for Blossom Company: 1. Cash balance per bank, July 31, $8,836. 2. July bank service charge not recorded by the depositor, $28. 3. The bank erroneously charged another company’s $840 cheque against Blossom’s account. 4. Cash balance per books, July 31, $10,541. 5. The bank charged Blossom’s account $420 for a customer’s NSF cheque. 6. Deposits in transit, July 31, $2,640. 7. Blossom recorded a cash receipt for a cash sale from a customer as $32....
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...
The balance sheet of Murdoch Pty Ltd as at 30 June 2019 reveals the following information:...
The balance sheet of Murdoch Pty Ltd as at 30 June 2019 reveals the following information: $(‘000s) Paid-up Capital (1,000,000 shares) 3,000 Bank Overdraft 1,000 Accounts Payable 1,500 Mortgage Bonds, $1,000 face value (10%) 4,000 You are also given the following additional information about the firm: a) The company’s marginal tax rate is 30 cents in a dollar. The proportion of tax collected from the company that is claimed by shareholders is 0.6. b) The market price per mortgage bond...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT