Question

Ivanhoe Company has the following cash budget information available for the month of August: Beginning cash...

Ivanhoe Company has the following cash budget information available for the month of August:

Beginning cash balance $134,000
Cash receipts from sales and collections on account 111,000
Collection of note receivable and interest 7,300
Cash disbursements for operating expenses 95,600



If the company has a policy of maintaining an end of the month cash balance of $103,000, determine the amount the company would have to borrow or the amount of excess cash it will have to invest in August.

The company would have to invest

Homework Answers

Answer #1
Cash Budget
Beginning cash balance 134,000
Cash receipts from sales and collections on account 111,000
Collection of note receivable and interest 7,300
Total available cash 252,300
Cash disbursements for operating expenses -95,600
Preliminary cash balance 156,700
Excess cash to be invested -53,700
Ending cash balance 103,000
The company would have to invest $53,700

Kindly comment if you need further assistance. Thanks

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
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:
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...
KARIM CORP. Cash Budget For July, August, and September July August September Beginning cash balance $8,600...
KARIM CORP. Cash Budget For July, August, and September July August September Beginning cash balance $8,600 Total cash available Preliminary cash balance Ending cash balance Loan balance Loan balance - Beginning of month $0 Additional loan (loan repayment) Loan balance - End of month Karim Corp. requires a minimum $8,200 cash balance. If necessary, loans are taken to meet this requirement at a cost of 1% interest per month (paid monthly). Any excess cash is used to repay loans at...
The cash budget was prepared with the following assumptions: The Company has borrowed a $500,000 revolving...
The cash budget was prepared with the following assumptions: The Company has borrowed a $500,000 revolving loan on 31 December last year, charging 1% interest per month.   Borrowing should be made to bring the Company to minimum $4,000 cash balance at each month end. Partially loan repayment should be made whenever there is any excess cash. Borrowing and repayment of the loans should be in multiples of $1,000. It is assumed that borrowing occurs at the beginning of the month...
Minot Corporation is preparing its cash budget for August. The following information is available concerning its...
Minot Corporation is preparing its cash budget for August. The following information is available concerning its accounts receivable: Estimated credit sales for August $ 200,000 Actual credit sales for July $ 151,000 Estimated collections in August for credit sales in August 25 % Estimated collections in August for credit sales in July 70 % Estimated collections in August for credit sales prior to July $ 16,000 Estimated write-offs in August for uncollectible credit sales $ 8,000 Estimated provision for bad...
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...
Given the following information, complete the cash budget: Collections occur one month after the sale. January’s...
Given the following information, complete the cash budget: Collections occur one month after the sale. January’s credit sales were $100,000. The firm has a certificate of deposit for $30,000 that matures in April. Salaries are $140,000 a month. The monthly mortgage payment is $15,000. Monthly depreciation is $30,000. Property tax of $35,000 is due in February. Round your answers to the nearest dollar. Enter the disbursements values as positive values. Use a minus sign to enter shortage of cash, negative...
C) Complete a manufacturing overhead budget from the given information: July August September Total Budgeted MHs...
C) Complete a manufacturing overhead budget from the given information: July August September Total Budgeted MHs 2,000 5,000 7,000 14,000 The company’s variable overhead rate is $4 per machine hour (MH). Total expected fixed overhead costs are $12,000 per month. Total non-cash fixed overhead expenses are $3,000 per month. July August September Total Budgeted MHs VMOH rate VMOH costs FMOH costs Total MOH costs Less: non-cash Cash disbursements for MOH D) Complete a cash budget from the given information: July...
Mosbey Inc. is working on its cash budget for June. The budgeted beginning cash balance is...
Mosbey Inc. is working on its cash budget for June. The budgeted beginning cash balance is $18,000. Budgeted cash receipts total $175,300 and budgeted cash disbursements total $204,000. The desired ending cash balance is $49,000, and the company borrows in increments of $500 only. The amount Mosbey Inc needs to borrow for June will be:
Question 5: Corrugated Box Company had the following estimated cash flows for the third quarter: August...
Question 5: Corrugated Box Company had the following estimated cash flows for the third quarter: August September October Quarter Cash receipts $900,000 $1,000,000 $1,300,000 $3,200,000 Cash disbursements 1,100,000 1,000,000 1,000,000 3,100,000 The company begins the year with $100,000 in cash and requires a minimum cash balance of $25,000. The company may borrow any amount from a local bank at an annual interest rate of 3%, The borrowing must occur at the beginning of any month and all repayments must be...