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- ACCESS >C<
- You just borrowed $203,584. You plan to repay this loan by making regular quarterly payments of X for 69 quarters and a special payment of $56,000 in 7 quarters. The interest rate on the loan is 1.94 percent per quarter and your first regular payment will be made today. What is X? Input instructions: Round your answer to the nearest dollar. 59arrow_forwardYou plan to retire in 4 years with $698,670. You plan to withdraw $X per year for 17 years. The expected return is 17.95 percent per year and the first regular withdrawal is expected in 5 years. What is X? Input instructions: Round your answer to the nearest dollar. $arrow_forwardYou just borrowed $111,682. You plan to repay this loan by making X regular annual payments of $15,500 and a special payment of $44,900 in 10 years. The interest rate on the loan is 13.33 percent per year and your first regular payment will be made in 1 year. What is X? Input instructions: Round your answer to at least 2 decimal places.arrow_forward
- You just borrowed $174,984. You plan to repay this loan by making regular annual payments of X for 12 years and a special payment of $11,400 in 12 years. The interest rate on the loan is 9.37 percent per year and your first regular payment will be made today. What is X? Input instructions: Round your answer to the nearest dollar. $arrow_forwardYou plan to retire in 7 years with $X. You plan to withdraw $54,100 per year for 15 years. The expected return is 13.19 percent per year and the first regular withdrawal is expected in 7 years. What is X? Input instructions: Round your answer to the nearest dollar. 59 $arrow_forwardYou plan to retire in 3 years with $911,880. You plan to withdraw $X per year for 18 years. The expected return is 18.56 percent per year and the first regular withdrawal is expected in 3 years. What is X? Input instructions: Round your answer to the nearest dollar. 99 $arrow_forward
- You have an investment worth $56,618 that is expected to make regular monthly payments of $1,579 for 25 months and a special payment of $X in 8 months. The expected return for the investment is 0.76 percent per month and the first regular payment will be made today What is X? Note: X is a positive number. Input instructions: Round your answer to the nearest dollar. $arrow_forwardYou plan to retire in 8 years with $X. You plan to withdraw $114,200 per year for 21 years. The expected return is 17.92 percent per year and the first regular withdrawal is expected in 9 years. What is X? Input instructions: Round your answer to the nearest dollar. $ EAarrow_forwardYou have an investment worth $38,658 that is expected to make regular monthly payments of $1,130 for 16 months and a special payment of $X in 11 months. The expected return for the investment is 1.46 percent per month and the first regular payment will be made in 1 month. What is X? Note: X is a positive number. Input instructions: Round your answer to the nearest dollar. $arrow_forward
- You just borrowed $373,641. You plan to repay this loan by making regular annual payments of X for 18 years and a special payment of $56,400 in 18 years. The interest rate on the loan is 12.90 percent per year and your first regular payment will be made in 1 year. What is X? Input instructions: Round your answer to the nearest dollar. EA $arrow_forwardHow much do you need in your account today if you expect to make quarterly withdrawals of $6,300 for 7 years and also make a special withdrawal of $25,700 in 7 years. The expected return for the account is 4.56 percent per quarter and the first regular withdrawal will be made today. Input instructions: Round your answer to the nearest dollar. $ 69arrow_forwardYou just bought a new car for $X. To pay for it, you took out a loan that requires regular monthly payments of $2,200 for 10 months and a special payment of $24,100 in 6 months. The interest rate on the loan is 1.07 percent per month and the first regular payment will be made today. What is X? Input instructions: Round your answer to the nearest dollar. 59 $arrow_forward
- Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage LearningExcel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning