Instructions 1) Read the attached case, Financial Statement Analysis for Small Business, A Resource Guide. Focus...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Instructions 1) Read the attached case, "Financial Statement Analysis for Small Business, A Resource Guide." Focus on how the author uses the ratios to interpret the business performance. 2) Select a public listed company with less than $1 billion market cap. You can get a list of stocks from web sources, such as http://www.nasdaq.com/reference/stock- screener.aspx. 3) Collect at least 3 years of financial information from Morningstar.com. Morningstar.com generally will provide 5-year history if it is available. Some ratios need to be calculated. 4) Using the suggested framework below and answer each of the listed questions. Questions Study the financials from the perspectives of different groups: owners, managers, short-term creditors, long-term creditors, and market. For each question, include the related financial ratios and explain the changes over time. Quite often, for fundamental analysis, we need to include comparison against peers or benchmarks. However, due to the limitation of time and resources, it is not required in this assignment. Introduction Owners 1-1. How well is the company doing as an investment? Return on Equity or Investment: ROE Short description of the company background 2016 2015 2014 2013 2012 Comments: ?? 1-2. How well has management employed the company's assets? Return on Asset: ?? 1-3. 2016 2015 2014 2013 2012 List of the sources for the change of Return on equity using DuPont Identity. ROE = (Net profit margin) * (Total asset turnover) * (Equity multiplier) Explain how the three components contributed to the change of return on equity. Net profit margin Total asset turnover Equity multiplier Return on equity 2016 2015 2014 2013 2012 1-4. Comment the track records of free cash flow over the recent years? Using Morningstar.com → cash flow statement → Free cash flow = Operating cash flow - Capital expenditure Managers 2-1. Are profits high enough, given the level of sales? Net profit margin 2016 2015 2014 2013 2012 2-2. How well are the company's assets being employed to generate sales revenue? The Asset Turnover ratio [Sales Average Total Assets] 2016 2015 2014 2013 2012 2-3. Are receivables coming in too slowly? The Average Collection Period [(Average A/R + Annual Credit Sales) x 365] 2016 2015 2014 2013 2012 2-4. Is too much cash tied up in inventories? The Inventory Turnover [Cost of Goods Sold Expense + Average Inventory] 2-5. What is the breakeven profit? VC Variable cost = cogs = CFC = (Admin + marketing + other operating expense) + (interest expense) R = Revenue SR = Survival revenue = CFC/(1-VC/R) R VC CFC SR Ratio of R/SR 2016 2015 2014 2013 2012 Comments Short-Term Creditors 3-1. Does this customer have sufficient cash or other liquid assets to cover its short-term obligations? The Current Ratio [Current Assets Current Liabilities] The Quick Ratio [Cash + Marketable Securities + A/R + Current Liabilities] 2016 2015 2014 2013 2012 3-2. How quickly does the prospective credit customer pay its bills? The Average Age of Payables [(Average Payable + Net Purchases) x 365] 2016 2015 2014 2013 2012 Long-Term Creditors 4-1. As a potential or present long-term borrower, Debt-to-Equity (D/E) [Total Debt Total Equity] 2016 2015 2014 2013 2012 4-2. Are earnings and cash flow sufficient to cover interest payments and provide for some principal repayment? The Times Interest Earned (TIE) [Income + (Interest + Taxes) + Interest Expense] The Cash Flow to Total Liabilities [Operating Cash Flow ÷ Total Liabilities] 2016 2015 2014 2013 2012 Market 5-1. How the financial performance is priced by the financial markets? Price-book ratio = price per share/ book value per share Price-earnings ratios = price per share/ earnings per share Price per share Book value per share Earnings shares Price-book ratio Price- earnings ratio 2016 2015 2014 2013 2012 Comments Summary 6-1. How to evaluate the overall financial profiles (ratios) of the company? List major conclusions from the financial analysis. 6-2. Was the price movement an accurate reflection of the change in the financial profile? Is the stock over-priced or underpriced compared against the fundamentals (financial profiles)? Is the stock a good candidate to invest? Buy or Sell? 6-3. Instructions 1) Read the attached case, "Financial Statement Analysis for Small Business, A Resource Guide." Focus on how the author uses the ratios to interpret the business performance. 2) Select a public listed company with less than $1 billion market cap. You can get a list of stocks from web sources, such as http://www.nasdaq.com/reference/stock- screener.aspx. 3) Collect at least 3 years of financial information from Morningstar.com. Morningstar.com generally will provide 5-year history if it is available. Some ratios need to be calculated. 4) Using the suggested framework below and answer each of the listed questions. Questions Study the financials from the perspectives of different groups: owners, managers, short-term creditors, long-term creditors, and market. For each question, include the related financial ratios and explain the changes over time. Quite often, for fundamental analysis, we need to include comparison against peers or benchmarks. However, due to the limitation of time and resources, it is not required in this assignment. Introduction Owners 1-1. How well is the company doing as an investment? Return on Equity or Investment: ROE Short description of the company background 2016 2015 2014 2013 2012 Comments: ?? 1-2. How well has management employed the company's assets? Return on Asset: ?? 1-3. 2016 2015 2014 2013 2012 List of the sources for the change of Return on equity using DuPont Identity. ROE = (Net profit margin) * (Total asset turnover) * (Equity multiplier) Explain how the three components contributed to the change of return on equity. Net profit margin Total asset turnover Equity multiplier Return on equity 2016 2015 2014 2013 2012 1-4. Comment the track records of free cash flow over the recent years? Using Morningstar.com → cash flow statement → Free cash flow = Operating cash flow - Capital expenditure Managers 2-1. Are profits high enough, given the level of sales? Net profit margin 2016 2015 2014 2013 2012 2-2. How well are the company's assets being employed to generate sales revenue? The Asset Turnover ratio [Sales Average Total Assets] 2016 2015 2014 2013 2012 2-3. Are receivables coming in too slowly? The Average Collection Period [(Average A/R + Annual Credit Sales) x 365] 2016 2015 2014 2013 2012 2-4. Is too much cash tied up in inventories? The Inventory Turnover [Cost of Goods Sold Expense + Average Inventory] 2-5. What is the breakeven profit? VC Variable cost = cogs = CFC = (Admin + marketing + other operating expense) + (interest expense) R = Revenue SR = Survival revenue = CFC/(1-VC/R) R VC CFC SR Ratio of R/SR 2016 2015 2014 2013 2012 Comments Short-Term Creditors 3-1. Does this customer have sufficient cash or other liquid assets to cover its short-term obligations? The Current Ratio [Current Assets Current Liabilities] The Quick Ratio [Cash + Marketable Securities + A/R + Current Liabilities] 2016 2015 2014 2013 2012 3-2. How quickly does the prospective credit customer pay its bills? The Average Age of Payables [(Average Payable + Net Purchases) x 365] 2016 2015 2014 2013 2012 Long-Term Creditors 4-1. As a potential or present long-term borrower, Debt-to-Equity (D/E) [Total Debt Total Equity] 2016 2015 2014 2013 2012 4-2. Are earnings and cash flow sufficient to cover interest payments and provide for some principal repayment? The Times Interest Earned (TIE) [Income + (Interest + Taxes) + Interest Expense] The Cash Flow to Total Liabilities [Operating Cash Flow ÷ Total Liabilities] 2016 2015 2014 2013 2012 Market 5-1. How the financial performance is priced by the financial markets? Price-book ratio = price per share/ book value per share Price-earnings ratios = price per share/ earnings per share Price per share Book value per share Earnings shares Price-book ratio Price- earnings ratio 2016 2015 2014 2013 2012 Comments Summary 6-1. How to evaluate the overall financial profiles (ratios) of the company? List major conclusions from the financial analysis. 6-2. Was the price movement an accurate reflection of the change in the financial profile? Is the stock over-priced or underpriced compared against the fundamentals (financial profiles)? Is the stock a good candidate to invest? Buy or Sell? 6-3.
Expert Answer:
Answer rating: 100% (QA)
Introduction The events surrounding the killing of George Floyd in 2020 ignited widespread protests and discussions about systemic racism and discrimination particularly within law enforcement In resp... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these accounting questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
If a company is very diversified, (a) it makes it easier to classify the company by industry. (b) it would not be necessary to provide any segmented information. (c) it can limit the usefulness of...
-
High Society Corp., a company with headquarters in London, England, is a fully owned subsidiary of Preston Inc. The accountant for Preston just received High Societys financial statements and must...
-
For n = 1, 2,¦, let X n , Y n and X , Y be r.v.s such that P ( X n ³ Y n ³ 0) = 1. And Finite. Then show that , , , 2 . X,Yn >00
-
Why is the term double-entry an appropriate expression for describing an accounting system? LO18
-
The comparative statements of Wahlberg Company are presented here. All sales were on account. Net cash provided by operating activities for 2017 was $220,000. Capital expenditures were $136,000, and...
-
A person had a zero balance then took out a cash advance on a credit card on November 15th of $1200. They had no other charges on the credit card and received their statement on Nov 30th. If they...
-
Large central power stations (about 1000 MW electrical) using fluidized bed combustors may be built some day These giants would be fed 240 tons of coallhr (90% C, 10 % H2,), 50% of which would burn...
-
how can I consider the theoretical tenants and interventions of Freud's psychodynamic theory with an adaptation to meet the needs of immigrants and refugees. What interventions/techniques, I can...
-
Identify what process you would use to craft a marketing message that would be specially tailored to the employee stakeholder group to aid in recruiting top candidates. Include information on...
-
Scenario You are the senior clinical analyst for the Oakridge Health System. Oakridge Health System is comprised of Medicare-certified hospitals, home health, hospice, inpatient rehabilitation and...
-
Your Chief Financial Officer (CFO) has called you into a meeting with the other three clinic managers, and has tasked you with preparing a "financial health status report" of your departments within...
-
What is the stance of Reid et al. (2012) regarding the imposition of negative sanctions for staff performance ? Explain
-
Discuss the following for your product or service: Marketing Mix Product strategy - in addition to career clothing, what other products should the Consignment Store carry and what is your strategy...
-
On Saturday 180 vehicles visited Lana s Car Wash Of those vehicles 3 out of every 4 were cars and the rest were trucks How many trucks visiting Lana s Car Wash on Saturday TYPE THE NUMBER ONLY
-
Prove that if Σ an is absolutely convergent, then a. an
-
Mary paid $2,000 of state income taxes in 2012. The total sales tax she paid during 2012 was $5,500, which included $3,000 for the cost of a new car. How should Mary treat the taxes paid on her 2012...
-
Mallory Corporation has a calendar year-end. The corporation has paid estimated payments of $10,000 during 2012 but still owes an additional $5,000 for its 2012 tax year. a. When is the 2012 tax...
-
Yolanda earns $112,000 in 2012. Calculate the FICA tax that must be paid by: Yolanda:.....................Soc.Sec..................$__________...
-
compare the interrelationships and conflicts among individuals, groups, and organizations that result in emotions and stress;
-
Prepare budgeted income statement (Learning Objective 2) Representatives of the various departments of Go Sports have assembled the following data. As the business manager, you must prepare the...
-
discuss burnout and ways to avoid it; and
Study smarter with the SolutionInn App