Question

In: Accounting

Exercise D5-26 Will Benjamin has been working on Bramble Paints' cash budget for the coming year....

Exercise D5-26 Will Benjamin has been working on Bramble Paints' cash budget for the coming year. Based on his projections for March, the beginning cash balance will be $50,181; cash collections will be $700,000; and cash disbursements will be $710,430. Bramble Paints desires to maintain a $50,000 minimum cash balance. The company has a 10% open line of credit with its bank, which provides short-term borrowings in $500 increments. All borrowings are made at the beginning of the month, and all repayments are made at the end of the month (in $500 increments). When partial payments are made against the line of credit, accrued interest applicable to the full amount due through that date is paid along with the partial principal repayment. (a) How much will Bramble Paints need to borrow from the bank at the beginning of March? Bramble Paints should borrow $ (b) Bramble anticipates having a positive $7,000 net cash flow from April activities. How much of the line of credit from March can be repaid? How much interest will be repaid in April? (Round interest repaid answer to the nearest whole dollar amount, e.g. 5,275.) Principal to be repaid $ Interest to be repaid $

Solutions

Expert Solution

a) Excess or deficiency of cash for March = Beg. Cash Bal+Cash Collections-Cash Disbursements

= $50,181+$700,000-$710,430 = $39,751

Minimum cash balance required = $50,000

Shortage of cash balance = $50,000 - $39,751 = $10,249

As the cash is borrowed in the increments of $500, the amount of borrowings at the beginning of March will be $10,500.

b) The opening cash balance for the month of april will be $50,000 and positive cash flow of 7,000 implies that there is an excess amount of $7,000 over the minimum required cash of $50,000. The repayment of interest and partial principal payments will be from total amount of $7,000 in the month of april

Accrued Interest on Short term borrowings for march and april = Amount of Borrowings*10%*2/12

= $10,500*10%*2/12 = $175

Partial Principal payments at the end of April = $7,000 - $175 = $6,825

Thus interest to be repaid in April will be $175 and principal to be repaid will be $6,825.


Related Solutions

John Johnson has been working on Swifty Paints' cash budget for the coming year. Based on...
John Johnson has been working on Swifty Paints' cash budget for the coming year. Based on his projections for March, the beginning cash balance will be $45,700; cash collections will be $600,000; and cash disbursements will be $634,000. Swifty Paints desires to maintain a $43,000 minimum cash balance. The company has a 6% open line of credit with its bank, which provides short-term borrowings in $500 increments. All borrowings are made at the beginning of the month, and all repayments...
The Hale Company is currently working on its cash budget for the coming year. The following...
The Hale Company is currently working on its cash budget for the coming year. The following information is available: Projected sales for the coming year: Month Projected Sales January $850,000 February 750,000 March 730,000 April 850,000 May 830,000 June 750,000 July 900,000 The collection history of the Hale Company has been as follows: 20% of sales are collected in the month of the sale. 60% of the sales are collected in the month following the sale. 12% of the sales...
Exercise D5-21 In the coming year, Urayse, Inc. will be introducing its first product, a wrist...
Exercise D5-21 In the coming year, Urayse, Inc. will be introducing its first product, a wrist brace that protects serious video gamers from repetitive-motion injuries. The brace will be sold for $11.25 to retailers throughout the country. All sales will be made on account. An expected 65% of sales will be collected within the quarter of the sale, and another 30 % in the quarter following the sale. The remaining 5% of credit sales are expected to be uncollectible. The...
As part of the process of preparing the master budget for the coming year, you’ve been...
As part of the process of preparing the master budget for the coming year, you’ve been asked to perform what-if analyses, in the form of scenarios, on the original planning assumptions regarding Product A produced by your company. The following are the baseline planning data for the coming year for this product: Sales volume (annual, in units) 2,500 Selling price per unit $ 1,500 Variable cost per unit $ 1,000 Fixed costs (per year) $ 200,000 Required: 1. Based on...
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%...
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...
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...
About 26% of movies coming out of Hollywood are comedies, Warner Bros has been the lead...
About 26% of movies coming out of Hollywood are comedies, Warner Bros has been the lead studio for about 13% of recent movies, and about 3% of recent movies are comedies from Warner Bros. Let C denote the event a movie is a comedy and W denote the event a movie is produced by Warner Bros. (e) What is the probability that a movie coming out of Hollywood is not a comedy? (f) In terms of movies, what would it...
You have been asked to prepare a cash budget for Ashton company, a distributor of exercise...
You have been asked to prepare a cash budget for Ashton company, a distributor of exercise equipment. The following information is available about the company's operation A. The cash balance on December 1 will be $40,000 B. Actual sales for October and November and expected sales for December are as follows: Cash sales:                   Oct.      Nov.        Dec              . 65000 70000.   83000 Sales on account:                  Oct.           Nov.       Dec              400000.   525000   600000 Sales on account are collected over a...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT