case study 1 Please be informed that This is strictly an individual assignment. In the multiple-choice questions, please highlight your answer. Once you are done with inserting all your answers in this sheet, please make sure they are correctly saved, and then upload the word file to the folder on blackboard you initially downloaded it from (course materials/case study 1) Make sure that you upload your file before the due date (September 24th at 11:59pm). following is the balance sheet for Excel Inc. for the year ended Dec 31st, 2018. Consolidated Balance sheet Excel ing As of Dec 31", 2018 Assets Liabilities + Owners Equity Current Assets Current Liabilities Cash 40,000 Accounts Payable 12,000 Accounts Receivables 4,000 Notes Payable 6,000 Inventory 14,000 Accrue Wages 1000 Total Current Assets 58,000 Total Current Liabilities 19,000 Fixed Assets Long term debt 40,000 Property, Plant, and 56,000 Equipment Owners' equity Goodwill 24,000 Common Shares 40,000 Total Fixed Assets 80,000 Retained Earnings 39,000 Total Owners equity 79,000 Total Assets 138.000 Liabilities +0.E 138.000 In addition to that you know the following facts about firm's operations throughout the year: revenues for the year includes the following: Domestic revenues $160,000. International revenues $80,000. cost of sales and direct labor is 50% of annual revenues. Because of the strong competition that it faces. Excel Inc. has a generous marketing plan. They signed a contract with the marketing planet Inc. by which the marketing agency will be responsible for Excel Inc. marketing for five years period started this year. The contract costs Excel $100,000 that will be paid evenly over the next five years, the company thinks this plan will affect its sales evenly over the five years period. Excel Inc. also spends $30,000 in the form of general and administrative expenses per year. The depreciable assets historical value is $40,000 and is depreciated on a straight-line basis over 10 years. Excel pays 10% interest rate on its Long-term debt outstanding. Excel pays 40% of its taxable income as tax expense. 1 Out of the year's net income, Excel Inc. is planning to repay $30,000 to its shareholders in the form of cash dividends. The company currently has 60,000 shares outstanding Please set up the income statement for Excel Inc: Consolidated Income Statement Excel Inc. As of Dec 31, 2018 Revenues (-) Cost of goods sold Gross margin (-) Marketing expenses (-) General and administrative expenses (-) Depreciation EBIT (-) Interest expenses EBT (-) Tax expenses Net income Dividends Additions to Retained Earnings 1- Ms. Janet Mcinish works as an elementary school teacher and has a taxable income from her job of $35,000. She inherited 10% of Excel shares outstanding, and recently received her annual dividends. What is the amount of annual dividends received by Mrs. Melnish? a) $ 5000 b) $ 720 c) $ 3000 d) $3720 Mr. David Lawson, the CFO of Excel Inc. plans to increase the company's long term debt from $40,000 to $80,000 by getting a 5 year loan from bank of America. 2- What type of financial decisions did MR. David take? a) Capital budgeting decision. (investment decision) b) Capital structure decision. (financing decision) c) Working capital management decision d) Accounting decision 2 3. Will this decision result in Excel to be excessively levered if everything else remains unchanged? Knowing that industry average debt/equity ratio is 1. a) Yes, because total debt to equity ratio for Excel inc, will be more than the industry average means that this firm has more debt than equity in its capital structure. b) Yes, because total debt to equity ratio for Excel inc, will be more than the industry average means that this firm has lower debt than equity in its capital structure. c) No, because total debt to equity ratio for Excel ing, will be lower than the industry average means that this firm has lower debt than equity in its capital structure. d) No, because total debt to equity ratio for Excel ing, will be higher than the industry average means that this firm has lower debt than equity in its capital structure. 4. The company is planning to use half of the long-term loan proceeds to increase the inventory holdings and keep the rest in its cash bank account, what type of financial decision is this? a) Capital budgeting decision (investment decision) b) Capital structure decision (financing decision) c) Working capital management decision d) Accounting decision 5. If nothing else changes, how would this decision affect Excel Inc. liquidity? a) The liquidity measured by both current ratio and quick ratio will increase. b) The liquidity measured by current ratio will increase however if we measure it using the quick ratio it will show a decrease in firm's liquidity. c) The liquidity measured by both current ratio and quick ratio will decrease. d) The liquidity measured by quick ratio will increase however if we measure it using the current ratio it will show a decrease in firm's liquidity. The decision to increase inventory holdings resulted from the consistent pressure of Excel Board of Directors to increase amount of inventory. Mr. David's own opinion was that Excel is holding enough inventory to keep the business running without costing the company lots of money on inventory carrying costs. On the other hand, BOD believes that in such a dynamic industry, holding more inventory is necessary to keep smooth business operations. 6- How long does it currently take the company to tumover its inventory? (before taking the loan) a) 8.57 days b) 12.63 days c) 42.57 days d) 28.9 days 7- Do you agree with Mr. David's opinion? Or, With the BOD? And why? Knowing that industry average inventory turnover is 8. a) I agree with Mr. David because the company's current inventory tumover is larger than the industry average. b) I agree with Mr. David because the company's current inventory tumover is lower than the industry average. c) I agree with BOD because the company's current inventory turnover is lower than the industry average. Alternatively, Assume that the entire debt taken will be invested in assets (half on inventory and half on land). The BOD believes this step will increase sales by $20,000 next year which they think certainly justifies the decision to increase inventory. Mr. David argues that this sales increase is not enough to balance the drop in firm's total asset utilization 8- what is the current total asset utilization? (before the loan) a) 1.74 b) 1.16 c) 0.08 d) 2.74 9- What is the new total assets utilization? a) 1.19 b) 1.46 c) 1.34 d) 1.94 10- Do you agree with Mr. David? Or with the BOD? a) I agree with Mr. David b) I agree with BOD If you are given the following information about the year ended Dec 2017 (previous year). Total assets = $120,000, Total Equity = $70,000, Sales = 150,000, Net income = $35,000 11- Calculate Excel's profitability (ROE) for year ended Dec 2017. a) 2 b) 1.5 c) 0.5 d) 1.7 12- Calculate Excel's profitability (ROE) for year ended Dec 2018. a) 0.47 b) 0.44 c) 0.27 d) 1.7 13-Based on your knowledge of determinants of corporate profitability (DuPont identity). did any significant change happen to Excel's profitability measured by ROE? Did it increase or decrease? What is the underlying reason behind the change, if any? (using your understanding of the Dupont system) a) The profitability of Excel inc, increased mainly because of the increase in total asset utilization. b) The profitability of Excel inc, decreased mainly because the company increased its leverage. c) The profitability of Excel inc, decreased because of the deterioration in fim's efficiency to generate sales. Ms. Janet McInish is currently considering selling her stock ownership. She strongly believes that the share is overpriced and is going to experience a price drop soon. In order to better understand the current situation of Excel stock, she was advised to use the price earnings ratio Giving that the total market value of Ms. Janet Excel shares is $120,000. 14- If Ms. Janet believes that any stock that has a P/E ratio that is more that 20% of the industry average to be overpriced, do you recommend Ms. Janet to sell her shares knowing that industry average P/E ratio is 10? a) I recommend for her to sell her stocks because the stock is now overpriced. b) I recommend for her to hold on her stocks because the stock is undervalued