Concept explainers
Videos
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 solution
Chapter 26 Solutions
UPENN: LOOSE LEAF CORP.FIN W/CONNECT
- John and Jane Doe, a married couple filing jointly, have provided you with their financial information for the year, including details of federal income tax withheld. They need assistance in preparing their tax return. W-2 Income: John earns $150,000 with $35,000 withheld for federal income tax. Jane earns $85,000 with $15,500 withheld for federal income tax. Interest Income: They received $2500 in interest from a savings account, with no tax withheld. Child Tax Credit: They have two children under the age of 17. Mortgage Interest: Paid $28,000 in mortgage interest on their primary residence. Property Taxes: Paid $4,800 in property taxes on their primary residence. Charitable Donations: Donated $22,000 to qualifying charitable organizations. Other Deductions: They have no other deductions to claim. You will gather the appropriate information and complete the forms provided in Blackboard (1040, Schedule A, and Schedule B in preparation of their tax file.arrow_forwardOn the issue date, you bought a 20-year maturity, 5.85% semi-annual coupon bond. The bond then sold at YTM of 6.25%. Now, 5 years later, the similar bond sells at YTM of 5.25%. If you hold the bond now, what is your realized rate of return for the 5-year holding period?arrow_forwardBond Valuation with Semiannual Payments Renfro Rentals has issued bonds that have an 11% coupon rate, payable semiannually. The bonds mature in 17 years, have a face value of $1,000, and a yield to maturity of 9.5%. What is the price of the bonds? Round your answer to the nearest cent.arrow_forward
- analyze at least three financial banking products from both the liability side (like time deposits, fixed income, stocks, structure products, etc). You will need to examine aspects such as liquidity, risk, and profitability from a company and an individual point of view.arrow_forwardHow a does researcher ensure that consulting recommendations are data-driven? What does make it effective, and sustainable? Please help explain and give the example How does DMAC help researchers to improve their business processes? How to establish feedback loops for ongoing refinement. Please give the examplesarrow_forwardDon't used hand raiting and don't used Ai solutionarrow_forward
- Explain what the business model of payday lenders, title pawn lenders, and “credit approved” used car dealers.arrow_forwardThe current NPV of a $30 million bond with 9% interest, 8% coupon rate, and discounted at $95arrow_forwardCould you please help to explain the DMAIC phases and how a researcher would use them to conduct a consulting project? What is a measure process performance and how to analyze the process? What is an improve process performance and how the control improves process and future process performance?arrow_forward
- Consider the two stocks below. Graph the frontier of combinations of the two stocks. Show the effect on the frontier of varying the correlation from −1 to +1. 1 2 3 Mean A B C D TWO STOCKS Varying the correlation coefficient Stock A Stock B 3.00% 8.00% 4 Sigma 15.00% 22.00% 5 Correlation 0.3000 Farrow_forwardLindsay is 30 years old and has a new job in web development. She wants to make sure that she is financially sound by the age of 55, so she plans to invest the same amount into a retirement account at the end of every year for the next 25 years. (a) Construct a data table in Excel that will show Lindsay the balance of her retirement account for various levels of annual investment and return. If Lindsay invests $10,000 at return of 6%, what would be the balance at the end of the 25th year? Note that because Lindsay invests at the end of the year, there is no interest earned on the contribution for the year in which she contributes. Round your answer to a whole dollar amount. $ (b) Develop a two-way table for annual investment amounts of $5,000 to $20,000 in increments of $1,000 and for returns of 0% to 12% in increments of 1%. From the 2-way table, what are the minimum annual investments Lindsay must contribute for annual rates ranging from 6% to 11%, if she wants to…arrow_forwardDoes Airbnb have any impaired assets? If so, what are they?arrow_forward
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College