Bramble Enterprises had a tough month in May, but June's sales and cash activity are looking strong. Bramble had to borrow $3,000 inMay in order to maintain the company's required minimum balance of $5,000. The loan carries an annual interest rate of 6%, withmonthly interest payments required. Loan withdrawals, in $1,000 increments, are assumed to be taken out on the first of the month.Loan payments, also in $1,000 increments, reduce the principal on the last day of the month. The June 1 cash balance is $5,780. Withbudgeted cash receipts of $105,000 and cash disbursements of $102,800 in June, how much of the prior month's loan would Bramblebe able to pay off in June, if any? What is Bramble's projected ending cash balance in June?Loan paid off$1000Projected ending cash balance$6980

Cash Budget -A cash budget is a documented financial plan that outlines the business's anticipated…

ible Enterprises had a tough month in May, but June's sales and cash activity are looking strong. Bramble had to bor ay in order to maintain the company's required minimum balance of $5,000. The loan carries an annual interest rate of onthly interest payments required. Loan withdrawals, in $1,000 increments, are assumed to be taken out on the first o Dan payments, also in $1,000 increments, reduce the principal on the last day of the month. The June 1 cash balance is udgeted cash receipts of $105,000 and cash disbursements of $102,800 in June, how much of the prior month's loan w e able to pay off in June, if any? What is Bramble's projected ending cash balance in June? Loan paid off $ 1000

ible Enterprises had a tough month in May, but June's sales and cash activity are looking strong. Bramble had to bor ay in order to maintain the company's required minimum balance of $5,000. The loan carries an annual interest rate of onthly interest payments required. Loan withdrawals, in $1,000 increments, are assumed to be taken out on the first o Dan payments, also in $1,000 increments, reduce the principal on the last day of the month. The June 1 cash balance is udgeted cash receipts of $105,000 and cash disbursements of $102,800 in June, how much of the prior month's loan w e able to pay off in June, if any? What is Bramble's projected ending cash balance in June? Loan paid off $ 1000

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Blossom Enterprises had a tough month in May, but June's sales and cash activity are looking strong. Blossom had to borrow $4,000 in May in order to maintain the company's required minimum balance of $5,000. The loan carries an annual interest rate of 6%, with monthly interest payments required. Loan withdrawals, in $1,000 increments, are assumed to be taken out on the first of the month. Loan payments, also in $1,000 increments, reduce the principal on the last day of the month. The June 1 cash balance is $5,590. With budgeted cash receipts of $103,200 and cash disbursements of $101,100 in June, how much of the prior month's loan would Blossom be able to pay off in June, if any? What is Blossom's projected ending cash balance in June? Loan paid off Projected ending cash balance
The George Company has a policy of maintaining an end-of-month cash balance of at least $30,000.In months where a shortfall is expected, the company can draw in $1,000 increments on a line ofcredit it has with a local bank, at an interest rate of 12% per annum. All borrowings are assumed forbudgeting purposes to occur at the beginning of the month, while all loan repayments (in $1,000increments of principal) are assumed to occur at the end of the month. Interest is paid at the end ofeach month. For April, an end-of-month cash balance (prior to any financing and interest expense)of $18,000 is budgeted; for May, an excess of cash collected over cash payments (prior to any interest payments and loan repayments) of $22,000 is anticipated. What is the interest payment estimatedfor April (there is no bank loan outstanding at the end of March)? What is the total financing effect(cash interest plus loan transaction) for May?
The Balance Sheet of Lopez Agri-ventures, Inc. at December 31 is shown below. The company has received a large order and anticipates the need to go to the bank to increase its borrowings. As a result, it has to forecast its cash requirement to January, February and March. Typically, the company collects 20 percent of its sales in the month of sale, 70 percent in the subsequent month, and 10 percent in the second month after the sale. All sales are credit sales. (000s) Cash Accounts Payable 50 Notes Payable 530 Accrued Expenses 545 360 400 Accounts Receivable 212 Inventories Current Liabilities 972 Current Assets 1125 Long-term Liabilities Total Liabilities 450 1422 Non-current Assets 1836 Common Stocks 100 Retained Earnings Total Liabilities & Shareholder's Equity 1439 2961 Total Assets 2961 Purchase of raw materials are made in the month prior to the sale and amount to 60 percent of sales in the subsequent month. Payments for these purchases occur in the month after the purchase.…
ABC Company is considering to establish a line of credit with a local bank to make up for the cash deficit for the next three months. The company expects a 60% chance for a $287.945 deficit and a 40% chance for no deficit at all. The line of credit charges 0.56% of interest rate per month on the amount borrowed plus a commitment fee of $2,500 for a quarter. It also requires a 7% compensation balance for outstanding loans. The company can reinvest any excess cash at an annual rate of 8%. What will the expected cost of establishing a line of credit be? Round your answer to the nearest dollar. (Hint: Refer to a numerical example in short-term financing choices.) O $5,617 $5,602 O $5,612 O $5.608 O $5,621
ABC Company is considering to establish a line of credit with a local bank to make up for the cash deficit for the next three months. The company expects a 60% chance for a $273,446 deficit and a 40% chance for no deficit at all. The line of credit charges 0.52% of interest rate per month on the amount borrowed plus a commitment fee of $2,500 for a quarter. It also requires a 9% compensation balance for outstanding loans. The company can reinvest any excess cash at an annual rate of 8%. What will the expected cost of establishing a line of credit be? Round your answer to the nearest dollar. (Hint: Refer to a numerical example in short-term financing choices.) Group of answer choices $5,313 $5,321 $5,304 $5,309 $5,317
Holiday Tree Farm has a cash balance of $34 and a short-term loan balance of $180 at the beginning of Qt. The net cash inflow for the first quarter is $36 and for the second quarter there is a net cash outflow of $48. All cash shortfalls are funded with short-term debt. The firm pays 2 percent of its prior quarter's ending loan balance as interest each quarter. The minimum cash balance is $20. What is the short-term loan balance at the end of Q2? Multiple Choice $184.3 $179.2 $138.6 $128.4 $1931
Motors Corporation manufactures motors for dirt bikes. The company requires a minimum $30,000 cash balance at each month-end. If necessary, the company borrows to meet this requirement at a cost of 2% interest per month (paid at the end of each month). Any preliminary cash balance above $30,000 at month-end is used to repay loans. The cash balance on July 1 is $30,000, and the company has no outstanding loans. Budgeted cash receipts and budgeted cash payments (other than for interest on the loan and loan activity) follow. Cash receipts Cash payments Beginning cash balance July August $ 81,000 $ 107,000 109,000 95,900 Prepare a cash budget for July, August, and September. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Round your final answers to the nearest whole dollar.) Total cash available MOTORS CORPORATION Cash Budget Total cash payments Preliminary cash balance Additional loan (loan repayment) Ending cash balance Loan activity Loan…
Jane MacDonald, Carroll Financial Analyst, prepared the following sales and cash disbursement estimates for the February-June period of this year. Month Sales Cash Disbursements February 500 400 March 600 300 April 400 600 May 200 500 June 200 200 MacDonald indicates that 30% of sales have been, historically, in cash. 70% of credit sales are collected one month after the sale, and the remaining 30% are collected two months after the sale. The company wants to keep a minimum final balance in its $ 25 cash account. Balances in excess of this amount will be invested in short-term government securities (marketable securities), while any deficits will be financed through short-term bank borrowing (payable securities). The cash balance initially on April 1 is $ 115. Prepare cash budgets for April, May, and June. How much, if any, of the maximum funding would Carroll require to meet its obligations within this three-month period?…
Management wants to know if there will be a need for short-term financing in February. Essential information is as follows: Estimated sales for January and February are $1.1 million and $750,000, respectively. Sixty percent of sales are for cash and 40 percent are credit sales that are collected the next month. Cash disbursements that vary with sales are 35 percent of sales. Fixed operating disbursements are $400,000 a month. Depreciation expense is $50,000 a month. A tax payment of $70,000 is due in January. A bond payment of $250,000 is owed and will be due in February. The cash balance at the beginning of January is $12,000. Management seeks a minimum cash balance of $9,000. December credit sales were $110,000. Round your answers to the nearest dollar. Use a minus sign to enter shortage of cash, if any. January February Excess (shortage) of cash $ $ The firm need short-term funds in February.
Motors Corporation manufactures motors for dirt bikes. The company requires a minimum $30,000 cash balance at each month-end. If necessary, the company borrows to meet this requirement at a cost of 3% interest per month (paid at the end of each month). Any preliminary cash balance above $30,000 at month-end is used to repay loans. The cash balance on July 1 is $43,000, and the company has no outstanding loans. Budgeted cash receipts and budgeted cash payments (other than for interest on the loan and loan activity) follow. July Cash receipts Cash payments $ 94,000 122,000 August September $120,000 108,900 $ 159,000 136,400 Prepare a cash budget for July, August, and September. Note: Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Round your final answers to the nearest whole dollar. Answer is not complete. MOTORS CORPORATION Cash Budget July August September Beginning cash balance $ 43,000 $ 30,000 $ 30,000 Add: Cash receipts 94,000 120,000…
A firm collects 25% of its credit sale in the month of sale and the remainder in the following month. The credit sale for the month of June is GHC 150,000. It expert to pay bills of GHC 22,000 in July. The depreciation for the month is GHC 1000. If the company maintains an end month cash balance of GHC 100,000, what is the external finance required?
Motors Corporation manufactures motors for dirt bikes. The company reguires a minimum $30,000 cash balance at each month-end. If necessary, the company borrows to meet this requirement at a cost of 3% interest per month (paid at the end of each month). Any preliminary cash balance above $30,000 at month-end is used to repay loans. The cash balance on July 1 is $39,000, and the company has no outstanding loans. Budgeted cash receipts and budgeted cash payments (other than for interest on the loan and loan activity) follow. Cash receipts Cash payments July S 9e, eee 118, e00 August $ 116,000 104, 900 September $ 155,000 132,400 Prepare a cash budget for July, August, and September (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Round your final answers to the nearest whole dollar.) MOTORS CORPORATION Cash Budget July August September Total cash available Less: Cash payments for