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 day of the month. That way they will not risk having too low of a balance during the month. They can borrow any amount of money needed. They may not pay loans back in installments. They have to pay them back all at once. The interest rate is 12%. Assume if they pay back money, they pay it back on the last day of the month.

What is the ending cash balance for November after all loan repayments of principle and interest?

Solutions

Expert Solution

ekkarill92 answered 1 year ago

Next > < Previous

Related Solutions

A company is preparing completing their Cash Budget. The following data has been prepared for cash...

A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash payments 954,500 1,210,000 1,075,000 The company’s cash balance at January 1st is $290,000. This company desires a minimum cash balance of $340,000. What is the amount of excess cash or deficiency of cash (after considering the minimum cash balance required) for February?

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...

Beasley Company prepared a cash budget by quarters for the upcoming year. Missing data amounts are...

Beasley Company prepared a cash budget by quarters for the upcoming year. Missing data amounts are indicated with question marks or lower case letters; these lower case letters will be referred to in the questions that follow. Beasley requires a minimum balance of $10,000 to start a quarter. All data are in thousands. Beasley Corporation Cash Budget QTR 1 QTR 2 QTR 3 QTR 4 Cash balance, beginning $16 $ e $13 $10 Add collections from customers a 70 67...

Transcript Company is preparing a cash budget for June. The company has $145,000 cash at the...

Transcript Company is preparing a cash budget for June. The company has $145,000 cash at the beginning of the month and anticipates having total sales of $1,222,000, consisting of 25% cash sales and 75% credit card sales. The bank charges 3 percent for credit card deposits. The firm sets its selling price at 150 percent of the cost of purchases and pays the cost of each month's sales at the end of the month. Other cash disbursements are $66,000 per...

Honolua Company is preparing a cash budget for November. The company has $150,000 cash at the...

Honolua Company is preparing a cash budget for November. The company has $150,000 cash at the beginning of November and anticipates total sales of $1,000,000, consisting of 25% cash sales and 75% bank credit-card sales. The bank charges 3% for credit-card deposits. The firm sets its selling price at 160% of the cost of purchases and pays the cost of each month's sales at the end of the month. Operating expenses are $45,000 per month, of which $25,000 is depreciation...

5. ABC Company is preparing their master budget and is preparing a schedule of expected cash...

5. ABC Company is preparing their master budget and is preparing a schedule of expected cash collections from sales for the first quarter of 2019. They expect sales in January to be $400,000, February to be $300,000, and March to be $500,000. !0% of the sales will be paid for in cash. The remainder will be charged on account. From past experience, the company knows their customers take 3 months to pay their bills in total, with 40% of a...

In preparing an operating budget, the sales budget is prepared first. Which of the following is...

In preparing an operating budget, the sales budget is prepared first. Which of the following is prepared next?

Pavone Corp. has prepared a preliminary cash budget for the third quarter as shown below: Cash...

Pavone Corp. has prepared a preliminary cash budget for the third quarter as shown below: Cash Budget Jul Aug Sep Beginning cash balance $34,000 $15,000 $18,500 Plus: Cash collections $56,000 $52,000 47,000 Cash available 90,000 $67,000 $65,500 Less: Cash payments: Purchases of direct materials 35,000 9,000 11,000 Operating expenses 40,000 30,500 30,800 Capital expenditures 0 9,000 7,400 Ending cash balance $15,000 $18,500 $16,300 Subsequently, the marketing department revised its figures for cash collections. New data are as follows: $53,000 in...

ZYX Corporation is preparing a cash budget for January of the coming year. The following data...

ZYX Corporation is preparing a cash budget for January of the coming year. The following data have been forecasted: January February Sales 750,000 800,000 Purchases 450,000 480,000 Operating expenses Payroll 146,800 167,000 Advertising 52,700 62,800 Rent 8,750 8,750 Depreciation 23,750 23,750 End-of-December balances Cash 120,000 Accounts payable 250,000 Bank loan 480,000 Sales are 40% cash. The term of credit sales is 2/10, n/30. The collection pattern for credit sales is 75% in the month following the month of sale (of...

XYZ Corporation is preparing a cash budget for January of the coming year. The following data...

XYZ Corporation is preparing a cash budget for January of the coming year. The following data have been forecasted: January February Sales 750,000 800000 Purchases 450,000 480000 Operating expenses: Payroll 146,800 167400 Advertising 52,700 62800 Rent 8,750 8750 Depreciation 23,750 23,750 End-of-December balances: Cash 120,000 Accounts payable 200,000 Bank loan 480,000 Additional data: Sales are 40% cash. The term of credit sales is 2/10, n/30. The collection pattern for credit sales is 75% in the month following the month of...

Subjects