Group Company Project – Part II The purpose of the second part of the comprehensive project is to compute financial statement ratios. Based on the company you selected in Part I, complete the following:
Based on formulas in your textbook, compute the following ratios for two years. You may use Excel to compute your ratios.
Debt ratio
Gross profit margin
Free cash flow
Times interest earned
Accounts receivable turnover
Inventory turnover
Prepare a DuPont Analysis of ROE for two years, including computations of
Return on Sales
Asset Turnover
Return on Assets
Financial Leverage
Return on Equity
Briefly evaluate the ratio trends. Indicate on your worksheet whether each ratio is:
stronger / weaker
quicker /slower
more / less liquid
more / less risk
Write a 3-6 page report evaluating trends in all of the above ratios. Discuss whether your company’s profitability, efficiency, liquidity, and solvency are improving or deteriorating. Suggest ways the company can improve the ratios that show problems. The report should be well written with cover page, introduction, the body of the paper (with appropriate subheadings), conclusion, and reference page. References must be appropriately cited.
Submit Group Project Part III (Read Instructions):Important: Turnitin is active. Turnitin score greater than 25% will be investigated. In addition, you may lose points if your Turnitin score is greater than 25%. Group Company Project Part III The purpose of the third part of the comprehensive project is to use resources available to obtain industry averages for commonly used ratios. Additionally, you will compare company ratio results to industry averages.
Obtain the four-digit primary SIC (Standard Industrial Classification) Code and industry title for your company. Record the primary SIC code and industry title at the top of the Ratio Analysis Worksheet.
Obtain industry averages for commonly used ratios in the current period. Industry average information is reported by industry title or SIC code.
Look up the following industry-average ratios:
Current ratio
Debt ratio
Gross profit margin
Times interest earned
Accounts receivable turnover
Inventory turnover
Return on Sales
Asset Turnover
Return on Assets
Financial Leverage
Return on Equity
Note that some industry averages may not apply to your company.Alternative to Industry Averages:If you are not able to find the industry average for part 3 of your project, please consider the following:Unfortunately, some of the websites where you can find industry averages will require you to pay for them. Instead of using industry average, calculate the same ratios for one of the competitors to the company you used in your project. That will give you the comparative information you need for Part 3 of the project. I believe this will help.
Write a 3-5 page report comparing the above ratios to industry averages. Discuss whether your company’s profitability, efficiency, liquidity, and solvency are better than, or worse than, its peers. The report should be well written with cover page, introduction, body of paper (with appropriate subheadings), conclusion, and reference page. References must be appropriately cited. Format: Double-spaced, one-inch margins, using a 12-point Times New Roman font.
Group Project Part IV (Read Instructions)
Important: Turnitin is active. Turnitin score greater than 25% will be investigated. In addition, you may lose points if your Turnitin score is greater than 25%. Group Company Project Part IV: Final Written Paper The final written paper requires you to prepare a well-written titled “Would You Advise a Friend to Invest in This Company?” based upon your research and analysis of this company’s financial information. You should identify at least 5-7 significant points that justify your conclusion. Support your points with a comprehensive explanation incorporating sound reasoning. The significant points you identified should be consistent with what you said in Parts I, II, and III.Your final written paper should be 4-5 pages long. The report should be well written with cover page, introduction, the body of the paper (with appropriate subheadings), conclusion, and reference page. References must be appropriately cited. Format: Double-spaced, one-inch margins, using a 12-point Times New Roman font.
“Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!”
What Students Are Saying About Us
.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐"Honestly, I was afraid to send my paper to you, but splendidwritings.com proved they are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"
.......... Customer ID: 14***| Rating: ⭐⭐⭐⭐⭐
"The company has some nice prices and good content. I ordered a term paper here and got a very good one. I'll keep ordering from this website."
