Concept explainers
Rework the cash budget and short-term financial plan assuming Keafer changes to a minimum cash balance of $90,000.
KEAFER MANUFACTURING
WORKING CAPITAL MANAGEMENT
You have recently been hired by Keafer Manufacturing to work in its established treasury department. Keafer Manufacturing is a small company that produces highly customized cardboard boxes in a variety of sizes for different purchasers. Adam Keafer, the owner of the company, works primarily in the sales and production areas of the company. Currently, the company basically puts all receivables in one pile and all payables in another, and a part-lime bookkeeper periodically comes in and attacks the piles. Because of this disorganized system, the finance area needs work, and that's what you've been brought in to do.
The company currently has a cash balance of $210,000, and it plans to purchase new machinery in the third quarter at a cost of 5390,000. The purchase of the machinery will be made with cash because of the discount offered for a cash purchase. Adam wants to maintain a minimum cash balance of $135,000 to guard against unforeseen contingencies. All of Keafer’s sales to customers and purchases from suppliers are made with credit, and no discounts are offered or taken.
The company had the following sales each quarter of the year just ended:
After some research and discussions with customers, you’re projecting that sales will be 8 percent higher in each quarter next year. Sales for the first quarter of the following year are also expected to grow at 8 percent. You calculate that Keafer currently has an accounts receivable period of 57 days and an accounts receivable balance of $675,000. However, 10 percent of the accounts receivable balance is from a company that has just entered bankruptcy, and it is likely that this portion will never be collected.
You’ve also calculated that Keafer typically orders supplies each quarter in the amount of 50 percent of the next quarter’s projected gross sales, and suppliers are paid in 53 days on average. Wages, taxes, and other costs run about 25 percent of gross sales. The company has a quarterly interest payment of $185,000 on its long-term debt. Finally, the company uses a local bank for its short-term financial needs. It currently pays 1.2 percent per quarter on all short-term borrowing and maintains a
Adam has asked you to prepare a cash budget and short-term financial plan for the company under the current policies. He has also asked you to prepare additional plans based on changes in several inputs.
Want to see the full answer?
Check out a sample textbook solutionChapter 26 Solutions
Corporate Finance
- Friendly Bank is attempting to determine the cost behavior of its small business lending operations. One of the major activities is the application activity. Two possible activity drivers have been mentioned: application hours (number of hours to complete the application) and number of applications. The bank controller has accumulated the following data for the setup activity: Required: 1. Estimate a regression equation with application hours as the activity driver and the only independent variable. If the bank forecasts 2,600 application hours for the next month, what will be the budgeted application cost? 2. Estimate a regression equation with number of applications as the activity driver and the only independent variable. If the bank forecasts 80 applications for the next month, what will be the budgeted application cost? 3. Which of the two regression equations do you think does a better job of predicting application costs? Explain. 4. Run a multiple regression to determine the cost equation using both activity drivers. What are the budgeted application costs for 2,600 application hours and 80 applications?arrow_forwardYou begin a new job at Cabrera Medical Supplies. The company is considering a new accounting system, with an initial investment of about half a million dollars for new software and hardware. You are excited for the opportunity to apply your managerial accounting skills regarding screening and preference methods to decide on the best system for the company. Your boss is a little old-school, and when you mention some of the things you learned in managerial accounting, he says. Discounted cash flow methods are not the only way to approach this. I have more of a gut reaction approach that blows most managers out of the water when they become absorbed by discounted cash flow methods (DCF). How would you react and what would you discuss with your boss?arrow_forwardClassical Furniture is a manufacturer of reproduction antique furniture. It is owned by Helen Sutton as a sole trader business. There are four employees and annual sales revenue is approximately £200,000 per year. You are required to: (a) Explain two benefits of budgetary control to Helen Sutton. (b) Suggest three budgets which Helen could use in the business to provide an adequate system of budgetary control. (c) Advise Helen of the relevant factors to consider when implementing budgetary control.arrow_forward
- Designs Ventures is a small business owned and run by Kwesi Foh from a small rented art studio at Akyem, Cape Coast. He designs and makes T-shirts for craft shops. In most months he produces and sells 1,000 T-Shirts at GH¢50 each. Kwesi would need your assistance in preparing a cash budget so that he can manage his business finances better and plan for unforeseen events that may have an impact on his business costs and revenues. He was sick a few months ago and was unable to meet some orders. As a result, his revenue was down and he has to use a bank overdraft to cover a large electricity bill. The overdraft has now been paid off but Kwesi does not want to run out of cash again. Develop a cash budget for Kwesi showing total cash in and out of his business each month and his cash balances. He currently has GH¢15,000 in his business account at a bank and has made you the list of regular outgoings shown below: Your cash budget should be for the period June to December. Quarterly bills…arrow_forwardShanice works in finance for a small manufacturing company and is working on next year’s budget. She has been doing research to compare the cost of outsourcing some upcoming jobs versus the cost of purchasing the equipment to keep the jobs in-house. In what step in financial planning is Shanice involved? Multiple Choice developing financial statements for outside investors forecasting short-term financial needs establishing financial controls and tax policy forecasting long-term financial needsarrow_forwardSuppose that you have been given a summer job as an intern at Issac Aircams, a company that manufacturessophisticated spy cameras for remote-controlled military reconnaissance aircraft. The company, which isprivately owned, has approached a bank for a loan to help it finance its growth. The bank requires financialstatements before approving such a loan. You have been asked to help prepare the financial statements andwere given the following list of costs:1. Depreciation on salespersons’ cars.2. Rent on equipment used in the factory.3. Lubricants used for machine maintenance.4. Salaries of personnel who work in the finished goods warehouse.5. Soap and paper towels used by factory workers at the end of a shift.6. Factory supervisors’ salaries.7. Heat, water, and power consumed in the factory.8. Materials used for boxing products for shipment overseas. (Units are not normally boxed.)9. Advertising costs.10. Workers’ compensation insurance for factory employees.11. Depreciation on chairs…arrow_forward
- Your friend, Catherine Ross, owns Knockoffs Unlimited, a nationwide distributor of low-cost imitation designer necklaces. She has contacted you for some assistance because the accounting clerk, George Forrest, recently won a sum of money and decided to resign immediately. Catherine knows that you are completing an accounting course at Cape Breton University and hopes you can prepare the cash budget for the upcoming quarter (April, May and June, 2021). Catherine has provided you with the budgets completed by George. She has also provided you with additional information that will assist with the completion of the cash budget. Completed Budgets (April, May, June, and Quarter Total, 2021) please find the required numerical information from the images attached REQUIRED: Prepare a cash budget . Show the budget by month and in total. What will be reported on the budgeted balance sheet at June 30, 2021 for accounts receivable? Supporting calculations required to earn available…arrow_forwardBTB (Pty) Limited is a distributor of PPE to rural health clinics in KZN. Turnover has been good and running expenses are under control, however the owner of the business, Mr Sam Jonas, is concerned that upcoming legal expenses and necessary vehicle repairs may negatively affect the business’ cash flow. He has hired you to prepare a cash budget for the next four months, from July to October 2022. All sales are made on credit and collected as follows: • 40% in the month of the sale; • 35% in the month after the sale; • 15% in the second month after the sale; • 10% will be written off as bad debts. All purchases are made on credit and paid for as follows: • 60% in the month of the purchase and • 40% in the month after the purchase. Total administration expenses (rent, rates stationary etc) will be R14 000 per month. The legal costs will be R34 000 in each of July and August 2022. Major repairs and maintenance to vehicles will cost R45 000 and this amount will be paid in three equal…arrow_forwardKaren has been working with a small travel agency for the past few years to learn the business and to better understand what costs are necessary to run it. Now, having been in the business world for a few years, she's ready to start her own travel agency, specializing in "off the grid" locations. She knows there will be both overhead costs and labor costs, since she intends to hire one assistant. The following chart outlines her estimates thus far. Annual net operating cash flows³ Initial asset investment Asset life in years $3,800 $9,800 8 Salvage value of asset at end of useful life $1,000 Tax rate 25% a After assistant and overhead costs, but does not include a salary for Karen. As a new business owner, Karen only expects to earn a 5% rate of return. She conducted an initial NPV anlaysis for an 8-year interval, recognizing that she'll make some significant adjustments after that point. Her initial analysis revealed a positive NPV. Click here to view the factor table (a) Rerun the…arrow_forward
- BTB (Pty) Limited is a distributor of PPE to rural health clinics in KZN. Turnover has been good and running expenses are under control, however the owner of the business, Mr Sam Jonas, is concerned that upcoming legal expenses and necessary vehicle repairs may negatively affect the business’ cash flow. He has hired you to prepare a cash budget for the next four months, from July to October 2022. All sales are made on credit and collected as follows: • 40% in the month of the sale; • 35% in the month after the sale; • 15% in the second month after the sale; • 10% will be written off as bad debts. All purchases are made on credit and paid for as follows: • 60% in the month of the purchase and • 40% in the month after the purchase. Total administration expenses (rent, rates stationary etc) will be R14 000 per month. The legal costs will be R34 000 in each of July and August 2022. Major repairs and maintenance to vehicles will cost R45 000 and this amount will be paid in three equal…arrow_forwardBTB (Pty) Limited is a distributor of PPE to rural health clinics in KZN. Turnover has been good and running expenses are under control, however the owner of the business, Mr Sam Jonas, is concerned that upcoming legal expenses and necessary vehicle repairs may negatively affect the business’ cash flow. He has hired you to prepare a cash budget for the next four months, from July to October 2022. All sales are made on credit and collected as follows: • 40% in the month of the sale; • 35% in the month after the sale; • 15% in the second month after the sale; • 10% will be written off as bad debts. All purchases are made on credit and paid for as follows: • 60% in the month of the purchase and • 40% in the month after the purchase. Total administration expenses (rent, rates stationary etc) will be R14 000 per month. The legal costs will be R34 000 in each of July and August 2022. Major repairs and maintenance to vehicles will cost R45 000 and this amount will be paid in three equal…arrow_forwardBTB (Pty) Limited is a distributor of PPE to rural health clinics in KZN. Turnover has been good and running expenses are under control, however the owner of the business, Mr Sam Jonas, is concerned that upcoming legal expenses and necessary vehicle repairs may negatively affect the business’ cash flow. He has hired you to prepare a cash budget for the next four months, from July to October 2022. All sales are made on credit and collected as follows: • 40% in the month of the sale; • 35% in the month after the sale; • 15% in the second month after the sale; • 10% will be written off as bad debts. All purchases are made on credit and paid for as follows: • 60% in the month of the purchase and • 40% in the month after the purchase. Total administration expenses (rent, rates stationary etc) will be R14 000 per month. The legal costs will be R34 000 in each of July and August 2022. Major repairs and maintenance to vehicles will cost R45 000 and this amount will be paid in three equal…arrow_forward
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeCornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning