Question

In: Accounting

A company is preparing their 4th quarter cash summary budget. Based on their beginning cash balance...

A company is preparing their 4th quarter cash summary budget.

Based on their beginning cash balance and anticipated cash receipts and cash disbursements (payments), here are the ending cash balances initially planned each month.  The balances shown below are BEFORE any borrowing of money or repayment of loans and interest.

Management wants to keep a minimum cash balance of $20,922. Therefore, they will clearly need to borrow money in November. Luckily, December looks like a good month and they will have plenty of money to pay the loan back.

Suppose their line of credit with the bank charges 12% interest annually. Assume if they borrow money in any month with a shortfall, they borrow it on the 1st day of the month. So you should assume they borrowed the money on the 1st day of November. If they pay money back in any one month, they will pay it back on the last day of the month.

October November December
Ending Cash Balance per the initial budget plan analysis $23,852 $12,984 $46,786

What will their final ending cash balance be as of December 31st after taking out the loan, paying back the loan and paying back the interest? Don't round any intermediate calculations. Round your answer to the nearest whole number.

Solutions

Expert Solution

ekkarill92 answered 1 year ago
Next > < Previous

Related Solutions

Bench Corporation is a merchandising company that is preparing a cash budget for the third quarter....
Bench Corporation is a merchandising company that is preparing a cash budget for the third quarter. They have the following budget information available.   1. Estimated sales for July, August, September, and October will be $210,000, $230,000, $220,000, and $240,000. Accounts receivable from June sales are $136,000. All sales are on credit and collected 35% in the month of sale and 65% in the month following sale. 2. Inventory purchases for July, August, and September are budgeted as $129,600, $136,200, and...
Bench Corporation is a merchandising company that is preparing a cash budget for the third quarter....
Bench Corporation is a merchandising company that is preparing a cash budget for the third quarter. They have the following budget information available.   1. Estimated sales for July, August, September, and October will be $210,000, $230,000, $220,000, and $240,000. Accounts receivable from June sales are $136,000. All sales are on credit and collected 35% in the month of sale and 65% in the month following sale. 2. Inventory purchases for July, August, and September are budgeted as $129,600, $136,200, and...
Bench Corporation is a merchandising company that is preparing a cash budget for the third quarter....
Bench Corporation is a merchandising company that is preparing a cash budget for the third quarter. They have the following budget information available.   1. Estimated sales for July, August, September, and October will be $210,000, $230,000, $220,000, and $240,000. Accounts receivable from June sales are $136,000. All sales are on credit and collected 35% in the month of sale and 65% in the month following sale. 2. Inventory purchases for July, August, and September are budgeted as $129,600, $136,200, and...
Walsh Corporation is preparing its cash budget for January. The budgeted beginning cash balance is $18,000....
Walsh Corporation is preparing its cash budget for January. The budgeted beginning cash balance is $18,000. Budgeted cash receipts total $183,000 and budgeted cash disbursements total $188,000. The desired ending cash balance is $30,000. The excess (deficiency) of cash available over disbursements for January is: Select one: a. 23,000 b. $13,000 c. $201,000 d. ($5,000)
Bries Corporation is preparing its cash budget for January. The budgeted beginning cash balance is $18,900....
Bries Corporation is preparing its cash budget for January. The budgeted beginning cash balance is $18,900. Budgeted cash receipts total $187,500 and budgeted cash disbursements total $189,800. The desired ending cash balance is $30,900. To attain its desired ending cash balance for January, the company should borrow: Multiple Choice $30,900 $47,500 $14,300 $0 Sarafiny Corporation is in the process of preparing its annual budget. The following beginning and ending inventory levels are planned for the year. Beginning Inventory Ending Inventory...
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...
Todd Enterprises is preparing a cash budget for the second quarter of the coming year. The...
Todd Enterprises is preparing a cash budget for the second quarter of the coming year. The following data have been forecasted: April May Sales ………………………………………………………… $150,000 $157,500 Merchandise purchases …………………………… 107,000 112,400 Operating expenses: Payroll ………………………………………………… 13,600 14,280 Advertising ………………………………………….. 5,400 5,700 Rent …………………………………………………….. 2,500 2,500 Depreciation ………………………………………… 7,500 7,500 End of April balances: Cash ……………………………………………………… 30,000 Bank loan payable ………………………………… 26,000 Additional data: (1) Sales are 40% cash and 60% credit. The collection pattern for credit sales is 50%...
The Fortunate Co. is preparing a cash budget for the 2nd quarter. The following information is...
The Fortunate Co. is preparing a cash budget for the 2nd quarter. The following information is available: Projected cash sales:   $10,000 each month Projected credit sales: $ 8,000 each month One half of the credit sales are collected in the month of sale, and the remainder collected in the following month (there are no uncollectible accounts). Accounts receivable on April 1st were $3,000. Operating expenses (paid in cash): $20,000 for April, and $13,000 for each of the following two months....
Diaz Company is preparing a cash summary budget using the data below. They have already prepared...
Diaz Company is preparing a cash summary budget using the data below. They have already prepared their cash receipts and cash payments budget so that data is provided: October November Beginning Cash Balance $16000 Expected Cash Receipts $63000 $95000 Expected Cash Payments $45000 $76000 Management always wants to maintain a $41,023 minimum cash balance at the end of every month. If there is an expected cash shortfall in the budget they will be proactive and borrow money at the first...
Colerain Corporation is a merchandising company that is preparing a budget for the third quarter of...
Colerain Corporation is a merchandising company that is preparing a budget for the third quarter of the calendar year. The company’s balance sheet as of June 30 is shown below: COLERAIN CORPORATION Balance Sheet June 30 Assets   Cash $   88,000   Accounts receivable 134,000   Inventory 60,000   Plant and equipment, net of depreciation 280,000   Total assets $ 562,000 Liabilities and Shareholders’ Equity   Accounts payable $   69,000   Common shares 380,000   Retained earnings 113,000   Total liabilities and shareholders’ equity $ 562,000 Colerain’s managers have...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT