Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

ANSWER PARTS G- M PLEASE Table IC 4.2 Income Statements Table IC 4.3 Ratio Analysis Note: E indicates estimated. The 2016 data are forocasts. Calculation

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

ANSWER PARTS G- M PLEASE

Table IC 4.2 Income Statements Table IC 4.3 Ratio Analysis Note: E indicates estimated. The 2016 data are forocasts. "Calculation is based on a 365-day year. Jamison examined monthly data for 2015 (not given in the case), and she detected an improving pattern during the year. Monthly sales were rising. costs were falling, and large losses in the early months had turned to a small profit by December. Thus, the annual data look somewhat worse than final monthly data. Also, it appears to be taking longer for the advertising program to get the message out, for the new sales offices to generate sales, and for the new manufacturing facilities to operate efficiently. In other words, the lags between spending moncy and deriving benefits were longer than D'Leon's managers had anticipated. For these reasons, Jamison and Campo see hope. for the company-provided it can survive in the short run. Jamison must prepare an analysis of where the company is now, what it must do to regain its financial health, and what actions should be taken. Your assignment is to help her answer the following questions. Provide elear explanations, not yes or no answers. a. Why are ratios useful? What are the five major categories of ratios? b. Calculate D'Leon's 2016 current and quick ratios based on the projected balance sheet and income statement data. What can you say about the company's liquidity positions in 2014, in 2015, and as projected for 2016 ? We often think of ratios as being useful (1) to managers to belp run the business, (2) to bankers for credit analysis, and (3) to stockholders for stock valuation. Would these different types of analysts have an equal interest in the company's liquidity ratios? Explain your answer. c. Calculate the 2016 inventory tumover, days sales outstanding (DSO), fixed assets turnover; and total assets turnover. How does D'Leon's utilization of assets stack up against other firms in the industry? d. Calculate the 2016 debt-to-capital and times-interest-carncd ratios. How leverage? What can you conclude from these ratios? c. Calculate the 2016 operating margin, profit margin, basic earning power (BEP), return on assets (ROA), return on equity (ROE), and return on invested capital (ROIC). What can you say about these ratios? f. Calculate the 2016 price/camings ratio and market book ratio. Do these ratios indicate that investors are expected to have a high or low opinion of the company? g. Use the DuPont equation to provide a summary and overvicw of D'Leon's financial condition as projected for 2016 . What are the firm"s major strengths and weaknesses? h. Use the following simplified 2016 balance sheet to show, in general terms, how an improvement in the DSO would tend to affect the stock price. For example, if the company could improve its collection procedures and thereby lower its DSO from 45.6 days to the 32-day industry average without affecting sales, how would that change "ripple through" the financial statements (shown in thousands below) and influence the stock price? i. Does it appear that inventories could be adjusted? If so, how should that adjustment affect D'Leon's profitability and stock price? j. In 2015, the company paid its suppliers much later than the due dates; also, it was not maintaining financial ratios at levels called for in its bank loan agreements. Therefore, suppliers could cut the company off, and its bank could refuse to renew the loan when it comes due in 90 days. On the basis of data provided, would you, as a credit manager, continue to sell to D'Leon on credit? (You could demand cash on delivery - that is, sell on terms of COD - but that might cause D'Leon to stop buying from your company.) Similarly, if you were the bank loan officer, would you recommend renewing the loan or demanding its repayment? Would your actions be influenced if, in early 2016, D'Leon showed you its 2016 projections along with proof that it was going to raise more than $1.2 million of new equity? Table IC 4.2 Income Statements Table IC 4.3 Ratio Analysis Note: E indicates estimated. The 2016 data are forocasts. "Calculation is based on a 365-day year. Jamison examined monthly data for 2015 (not given in the case), and she detected an improving pattern during the year. Monthly sales were rising. costs were falling, and large losses in the early months had turned to a small profit by December. Thus, the annual data look somewhat worse than final monthly data. Also, it appears to be taking longer for the advertising program to get the message out, for the new sales offices to generate sales, and for the new manufacturing facilities to operate efficiently. In other words, the lags between spending moncy and deriving benefits were longer than D'Leon's managers had anticipated. For these reasons, Jamison and Campo see hope. for the company-provided it can survive in the short run. Jamison must prepare an analysis of where the company is now, what it must do to regain its financial health, and what actions should be taken. Your assignment is to help her answer the following questions. Provide elear explanations, not yes or no answers. a. Why are ratios useful? What are the five major categories of ratios? b. Calculate D'Leon's 2016 current and quick ratios based on the projected balance sheet and income statement data. What can you say about the company's liquidity positions in 2014, in 2015, and as projected for 2016 ? We often think of ratios as being useful (1) to managers to belp run the business, (2) to bankers for credit analysis, and (3) to stockholders for stock valuation. Would these different types of analysts have an equal interest in the company's liquidity ratios? Explain your answer. c. Calculate the 2016 inventory tumover, days sales outstanding (DSO), fixed assets turnover; and total assets turnover. How does D'Leon's utilization of assets stack up against other firms in the industry? d. Calculate the 2016 debt-to-capital and times-interest-carncd ratios. How leverage? What can you conclude from these ratios? c. Calculate the 2016 operating margin, profit margin, basic earning power (BEP), return on assets (ROA), return on equity (ROE), and return on invested capital (ROIC). What can you say about these ratios? f. Calculate the 2016 price/camings ratio and market book ratio. Do these ratios indicate that investors are expected to have a high or low opinion of the company? g. Use the DuPont equation to provide a summary and overvicw of D'Leon's financial condition as projected for 2016 . What are the firm"s major strengths and weaknesses? h. Use the following simplified 2016 balance sheet to show, in general terms, how an improvement in the DSO would tend to affect the stock price. For example, if the company could improve its collection procedures and thereby lower its DSO from 45.6 days to the 32-day industry average without affecting sales, how would that change "ripple through" the financial statements (shown in thousands below) and influence the stock price? i. Does it appear that inventories could be adjusted? If so, how should that adjustment affect D'Leon's profitability and stock price? j. In 2015, the company paid its suppliers much later than the due dates; also, it was not maintaining financial ratios at levels called for in its bank loan agreements. Therefore, suppliers could cut the company off, and its bank could refuse to renew the loan when it comes due in 90 days. On the basis of data provided, would you, as a credit manager, continue to sell to D'Leon on credit? (You could demand cash on delivery - that is, sell on terms of COD - but that might cause D'Leon to stop buying from your company.) Similarly, if you were the bank loan officer, would you recommend renewing the loan or demanding its repayment? Would your actions be influenced if, in early 2016, D'Leon showed you its 2016 projections along with proof that it was going to raise more than $1.2 million of new equity

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions