Question

Batista Company management wants to maintain a minimum monthly cash balance of $ 20,800. At the...

Batista Company management wants to maintain a minimum monthly cash balance of $ 20,800. At the beginning of April, the cash balance is $ 22,900, expected cash receipts for April are $245,900, and cash disbursements are expected to be $ 257,700.

How much cash, if any, must be borrowed to maintain the desired minimum monthly balance?

Amount to be borrowed to maintain the desired minimum monthly balance

$

Homework Answers

Answer #1

Working:

Beinning Cash Balance               22,900
Expected Cash Receipts           2,45,900
Expected Cash Disbursements         (2,57,700)
Desired Ending Cash Balance             (20,800)
Amount to be Borrowed               (9,700)

Hence, Batisata Company needs to borrow $9,700.

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
Do It! Review 21-4 Batista Company management wants to maintain a minimum monthly cash balance of...
Do It! Review 21-4 Batista Company management wants to maintain a minimum monthly cash balance of $19,100. At the beginning of April, the cash balance is $22,700, expected cash receipts for April are $245,800, and cash disbursements are expected to be $257,700. How much cash, if any, must be borrowed to maintain the desired minimum monthly balance? Amount to be borrowed to maintain the desired minimum monthly balance
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:
Use the following information to answer Question 3.   Harvest Oaks’ beginning balance of cash on April...
Use the following information to answer Question 3.   Harvest Oaks’ beginning balance of cash on April 1 is $450,000. Harvest Oaks wants to maintain a minimum cash balance of $400,000. The company has an agreement with a local bank that allows the company to borrow money in any increment at the beginning of each month. The interest rate on these loans is 1% per month and is not compounded. The company would, as far as it is able, repay the...
During December, the capital budget indicates a $279100 purchase of equipment for cash. The ending November...
During December, the capital budget indicates a $279100 purchase of equipment for cash. The ending November cash balance is budgeted to be $40800. Cash receipts are $840700, and cash disbursements are $610400 during December. The company wants to maintain a minimum cash balance of $20100. What is the minimum cash loan that must be planned to be borrowed from the Bank during December? $28100 $8000 $48800 $0
During December, the capital budget indicates a $280700 purchase of equipment for cash. The ending November...
During December, the capital budget indicates a $280700 purchase of equipment for cash. The ending November cash balance is budgeted to be $39200. Cash receipts are $839200, and cash disbursements are $609400 during December. The company wants to maintain a minimum cash balance of $20400. What is the minimum cash loan that must be planned to be borrowed from the Bank during December? $32100 $11700 $50900 $0
During December, the capital budget indicates a $280200 purchase of equipment for cash. The ending November...
During December, the capital budget indicates a $280200 purchase of equipment for cash. The ending November cash balance is budgeted to be $39600. Cash receipts are $839900, and cash disbursements are $610400 during December. The company wants to maintain a minimum cash balance of $20300. What is the minimum cash loan that must be planned to be borrowed from the Bank during December? $11100 $50700 $31400 $0
Zolezzi Inc. is preparing its cash budget for March. The budgeted beginning cash balance is $28,000....
Zolezzi Inc. is preparing its cash budget for March. The budgeted beginning cash balance is $28,000. Budgeted cash receipts total $105,000 and budgeted cash disbursements total $92,000. The desired ending cash balance is $60,000. The company can borrow up to $60,000 at any time from a local bank, with interest not due until the following month. Required: Prepare the company's cash budget for March in good form. Make sure to indicate what borrowing, if any, would be needed to attain...
Danner Company expects to have a cash balance of $46,800 on January 1, 2020. Relevant monthly...
Danner Company expects to have a cash balance of $46,800 on January 1, 2020. Relevant monthly budget data for the first 2 months of 2020 are as follows. Collections from customers: January $88,400, February $156,000. Payments for direct materials: January $52,000, February $78,000. Direct labor: January $31,200, February $46,800. Wages are paid in the month they are incurred. Manufacturing overhead: January $21,840, February $26,000. These costs include depreciation of $1,560 per month. All other overhead costs are paid as incurred....
Piano Man, Inc., has a 40-day average collection period and wants to maintain a minimum cash...
Piano Man, Inc., has a 40-day average collection period and wants to maintain a minimum cash balance of $40 million, which is what the company currently has on hand. The company currently has a receivables balance of $197 million and has developed the following sales and cash disbursement budgets in millions:     Q1 Q2 Q3 Q4 Sales $ 450 $ 522 $ 603 $ 567 Total cash disbursement 335 466 720 466    Complete the following cash budget for the...
2.   Piano Man, Inc., has a 40-day average collection period and wants to maintain a minimum...
2.   Piano Man, Inc., has a 40-day average collection period and wants to maintain a minimum cash balance of $25 million, which is what the company currently has on hand. The company currently has a receivables balance of $185 million and has developed the following sales and cash disbursement budgets in millions: Q1 Q2 Q3 Q4 Sales $   342         $   414         $   495         $   459      Total cash disbursement         281        ...