For your course project, assume you have just earned your master’s degree in finance and are now employed by the Cosmo K Manufacturing Group. Your employment is contingent on your successful completion of several tasks over the next four weeks and the successful completion of a comprehensive exam to obtain company certification in finance. Each week, your supervisor, Gerry, will assign you projects of interest to the company that will test your competence in finance. Under these projects, you will be required to complete several specific tasks.
You will conduct a ratio analysis and a trend analysis for a company of your choice, one which is listed on the New York Stock Exchange (NYSE) or the National Association of Securities Dealers Automated Quotations (NASDAQ). I have not picked a company yet so you can pick one.
Gerry has decided that you need some experience in evaluating other firms in the marketplace. Accordingly, he has asked you to select any company listed on the NYSE or the NASDAQ. For your selected company, identify and download the most recent financial statements for the last three to five years, to include the following:
• Balance sheet
• Income statement
• Per share data
Tasks:
Gerry would like you to complete the following tasks and submit your report by the end of the week:
• Identify the predominant industry in which your company operates. Find the industry averages for that industry for the following ratios:
o Current ratio
o Debt ratio
o Quick ratio
o Debt-equity ratio
o Total asset turnover
o Profit margin
o Inventory turnover
o Return on assets
o Receivables turnover
o Return on equity
• Calculate as many of the listed ratios for your selected company as possible using the financial statements you acquired.
• Conduct a trend analysis for the last three to five years. What trends can you identify? What do they indicate?
• Compare the ratios for the last common year to the industry averages. What conclusions can you draw regarding your company’s performance? What are your company’s strengths and weaknesses?
• Identify the changes that need to be made by the company to improve its performance, as compared to the industry, on the basis of the ratios.
• Conduct a DuPont analysis for your selected company. What conclusions can you draw for improving your company’s performance on the basis of this analysis?
This report aims to perform ratio and trend analysis for General Motors – NYSE listed corporation engaged in automobile industry. Data has been sourced from www.Morningstar.com for General motors and other peers operating in the industry. Since this analysis involves working on ratios which are absolute numbers, reporting of financial data in different currencies have been ignored.
Section I provide insights into trend analysis of General Motors. Latest financial performance and ratios are compared with the industry peers in Section II. Section III suggests areas of improvement for General Motors to improve its financial performance using Ratio Analysis. Section IV uses DuPont Analysis to provide suggestions on bettering the current financial performance.
Trend of ratios – General Motors
Source: Financials obtained from www. Morningstar.com for trend analysis
Interpretation: From the trend above, it is noted that there the quick ratio has been consistent over the period and is pegged at around 0.9 indicating steady liquidity position for General Motors. It suggests that the company has sufficient liquid assets to meet its current obligations. Similarly the current assets ratio has also been stable at around 1.2-1.3 times. Debt ratio which is calculated as the ratio of debts to total assets, have seen a steady rise from 0.09 (9%) in 2011 to 0.264 (26%) in 2014. This is corroborated by the trend in Debt-Equity ratio as well. Here Debt-Equity is measured as ratio of Total liabilities to Total Equity. Debt-Equity ratio has increase from 2.793 in 2011 to 4.011 in 2014. This either implies that General Motors have increased its debts or there has been decline in shareholders equity during the same period. General Motors’ profit margin has been declining over the period as is also evident from the declining trend in Return on equity and Return on Assets. The inventory turnover and receivables turnover has been fairly stable for General Motors. Total Assets turnover has fairly stable as over the 4 year period.
Industry comparison:
Source: Financials obtained from www. Morningstar.com for ratio analysis
Interpretation: General Motors’ current ratio is marginally better than the industry whereas its quick ratio is lower than the industry. It has been able to recover its dues from its debtors at a much faster rate than the industry. However, its ability to sell its inventory is lower than the industry. Peers in the industry have Debts of 37% of its Total Assets as against General Motors’ 26%. However, its Debt Equity ratio is fairly aggressive as against peers in the industry. Debt-Equity ratio of 4 indicates that the company’s 80% financing is from Debts.
Suggestions as under:
DuPont analysis is an effective tool to gauge the company’s efficiency in generating profits, management of assets and striking a critical balance between owned and borrowed funds. (Wayne, 2012).
General Motors has significantly higher reliance on external sources of funds which has an increasing effect on Return on Equity. Reduction in Debts will have a direct increasing impact on the Return on Equity. Low Asset turnover indicates General Motor’s ineffective in utilising its assets to drive sales reflecting idle fixed assets or high inventory turnaround time (Peavler, 2014).Further, General Motors operates on slim margin of 2.5% which is lower than the industry in which it operates.
Anon n.d., Assets Turnover Ratio, [Online], Available at: https://www.investopedia.com/terms/a/assetturnover.asp, [Accessed date: January 18, 2016]
Morning Star, 2016, Financials for various companies, [Online], Available at: https://financials.morningstar.com/income-statement/is.html?t=GM®ion=USA&culture=en_US, [Accessed date: January 18, 2016]
Rosemary Peavler, 2014, What is Total asset turnover and how is it calculated?, [Online], Available at: https://bizfinance.about.com/od/financialratios/f/Total_Asset_Turnover.htm, [Accessed date: January 18, 2016]
Wayne Thorp, 2012, Deconstructing ROE: DuPont Analysis, [Online], Available at: https://www.aaii.com/computerizedinvesting/article/deconstructing-roe-dupont-analysis, [Accessed date: January 18, 2016)
Essay Writing Service Features
Our Experience
No matter how complex your assignment is, we can find the right professional for your specific task. Contact Essay is an essay writing company that hires only the smartest minds to help you with your projects. Our expertise allows us to provide students with high-quality academic writing, editing & proofreading services.
Free Features
Free revision policy
$10Free bibliography & reference
$8Free title page
$8Free formatting
$8How Our Essay Writing Service Works
First, you will need to complete an order form. It's not difficult but, in case there is anything you find not to be clear, you may always call us so that we can guide you through it. On the order form, you will need to include some basic information concerning your order: subject, topic, number of pages, etc. We also encourage our clients to upload any relevant information or sources that will help.
Complete the order form
Once we have all the information and instructions that we need, we select the most suitable writer for your assignment. While everything seems to be clear, the writer, who has complete knowledge of the subject, may need clarification from you. It is at that point that you would receive a call or email from us.
Writer’s assignment
As soon as the writer has finished, it will be delivered both to the website and to your email address so that you will not miss it. If your deadline is close at hand, we will place a call to you to make sure that you receive the paper on time.
Completing the order and download