Short Report on Cash Budgeting Problem
Not what you're looking for?
1. You work for Keafer Inc., a small, family-owned manufacturer of custom cardboard boxes. Up until now, payables and receivables were handled haphazardly with little planning. You have been hired to apply the skills you learned in business school to institute some formality to the process. Currently the firm has a cash balance of $115,000, with plans for a $200,000 capital investment in new machinery in the third quarter that will be paid from cash in order to obtain a discount. The CEO has indicated he would like a minimum cash balance of $90,000 to provide liquidity in case of any unforeseen contingencies. The company provides credit to all of its customers with terms of net 45 days. Quarterly sales for the year that just ended were: Q1, $565,000; Q2, $585,000; Q3, $628,000; and Q4, $545,000. You project quarterly sales will grow 8% over the coming year. Current receivables are $426,000 with an average collection period of 57 days. However, 10% of receivables are from a firm that just filed for bankruptcy and it is unlikely any of this will ever be collected. The firm purchases supplies using trade credit with terms of net 60 days. Keafer typically orders supplies equal to 50% of next quarter's gross sales, with an average payables period of 53 days. Wages, taxes and other costs run about 25% of current-quarter sales. The company also has a quarterly interest payment of $120,000 on its long-term debt. Your job is to prepare a cash budget for the company under the current policy. In addition, rework the analysis assuming an 11% growth in sales, and again assuming the original growth rate but minimum cash balance of $70,000. Write a short report explaining your analysis, you findings and your recommendations.
Purchase this Solution
Solution Summary
The solution discusses a short report on cash budgeting problem.
Solution Preview
See the attached files.
To,
From,
Date,
Dear Sir,
Subject: REPORT ON ANALYSIS OF CASH BUDGETING AND RECOMMENDATION
As per analysis performed in attached Excel sheet, the closing balance as per current policy(8% growth in sales) and Minimum Cash Balance requirement of $ 70,000. The Cash Flows are the same and it ...
Purchase this Solution
Free BrainMass Quizzes
Paradigms and Frameworks of Management Research
This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.
Basics of corporate finance
These questions will test you on your knowledge of finance.
Academic Reading and Writing: Critical Thinking
Importance of Critical Thinking
Accounting: Statement of Cash flows
This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.
IPOs
This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)