Finance Assignment
Instructions for Jones Electrical Distribution
(1) The case should be written as an executive memo, containing the following sections:
• Executive Summary
• Introduction
• Analysis and Recommendations
• Conclusion (brief summary)
(2) Do NOT just answer the questions as in a homework style format. Note the following:
• The case analysis is done in group.
• The case report should be (1.5 spaced, 12 point font) with up to 5 pages of appendices (graphs, tables, etc.). Please do NOT insert appendices from the case into your report unless you have added your own calculations to the page.
• Executive Summary should include:
o 2 to 3 sentence overview of the firm oBrief statement of the situation/problem
o Your recommendation. Include important numbers in the recommendation, but do not show how they are calculated (the calculations should be in an appendix).
o The executive summary should be about ¾ page to 1 page. The intent is that if an executive read only the executive summary, they should be able to understand thesituation, the problem, and your recommendations, without reading the rest of thereport.
• Introduction: This section should briefly describe the company, the current situation and the issues.
• Analysis and Recommendations: This section is the most important section. This should be the main component (and longest section) of the report. Most importantly, you must take a position regarding the issues and make specific recommendations on how to overcome them. Also, make sure you provide support for you recommendations. Use specific data and/or calculations to provide this support.
• Conclusion: This section should briefly summarize the main conclusion.
(3) The case questions, which are available below, are designed to assist you in focusing on the issues. If you believe that the questions do not fully address the issues, then you may go outside the parameters of the questions.
Policies on the submission of the case analysis:
(1) Send the completed report along with the Excel filesin which you do the calculations to me via email, one copy per group. No hard copy is accepted. Please do not send duplicates for the same group.
(2) Do not forget to put your names and Section Number 004on the report.
Case Questions:
There are three main questions for this case. Under each main question, there are sub-points that will help you to reach a conclusion for the main question. All assumptions that are necessary for calculations are also included.
1. Why does this firm need to external financing to support its growth?
(1) Prepare a statement for the sources and uses of cash for this firm in the year 2005 and in the year 2006 and also answer the following questions (i) and (ii)
(i) What are the main drivers for the increased need for fund?
(ii) How much does retained earnings account for the total uses of cash?
(2) If we use the receivables turnover ratio in 2004 as a benchmark, what is the amount of change in accounts receivables that resulted from a longer collection period in 2006?
If we use the inventory turnover ratio in 2004 as a benchmark, what is the amount of change in inventories that resulted from a slower inventory turnover in 2006?
(3) Prepare a statement of cash flows for this firm in the year 2006.
2. Is $350,000 borrowing from banks enough for this firm (Pro Forma Analysis)? Please use the assumptions made below.
Assumptions for the Pro Forma Analysis:
(1) The sales in 2007 will be $ 2.7 million, as Mr. Jones anticipates.
(2) We only consider two cases:
o Take discounts: The discounts from suppliers are available to Mr. Jones if it takes him 10 days to make payments to suppliers. oSkip discounts: The discounts from suppliers are not available to Mr. Jones if it takes him 30 days to make payments to suppliers.
(3) The ratio of operating expense to sales is constant, same as the number in 2006
(4) Interest expense is assumed to be constant, $31,000
(5) Receivable turnover is constant, same as the number in 2006
(6) Inventory turnover is constant, same as the number in 2006
(7) $24,000 of long-term debt principal is repaid during 2007
(8) No new long-term debt will be issued in 2007
(9) Retention ratio is constant, same as the number in 2006
(10) Dollar balances for cash holding, Property & Equipment, and accrued expense are unchanged in 2007, same as the numbers in 2006
(11) If Mr. Jones takes the 100% of the discounts available in 2007, then the ratio of COGS to sales is constant, , same as the number in 2006; If Mr. Jones does not take the discounts, then the ratio of COGS to sales in 2007 is 2% higher than that in 2006.
Q1: What is the projected income statement for this firm in 2007 when Mr. Jones takes or skips the discount offered by the suppliers? Prepare the projected income statement for both cases.
Q2: What is the projected balance sheet for this firm in 2007 when Mr. Jones takes or skips the discount offered by the suppliers? Prepare the projected balance sheet for both cases.
3. What Mr. Jones could do if $350,000 credit lines are not sufficient to support the growth of his firm?
(1) What are the potential options for Mr. Jones?
(2) What is the growth rate of sales that Mr. Jones can achieve if he wants to make the ratio of debt-net worth constant?
(3) If Mr. Jones wants to expand the business at the rate larger than this calculated growth rate, what are the implications for his firm?
(4) What is the growth rate of sales that Mr. Jones can achieve if no outside capital is needed, assuming that capital expenditure is equal to depreciation, no repayment of long-term debt principal and accrued liabilities are unchanged year over year.
(5) Is slowing down the expansion of the firm necessarily bad for the firm? For example, you can consider the net income when Mr. Jones takes the discounts and when he skips the discounts.
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also include a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also Include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.
Attachment:- Case.rar