Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1) Using an Excel spreadsheet, three-year ratio trend analysis from the financial statements data for your Lowes corporation. Your spreadsheet must include actual formulas that

1) Using an Excel spreadsheet, three-year ratio trend analysis from the financial statements data for your Lowes corporation. Your spreadsheet must include actual formulas that calculate the ratios. The trend will consist of the following ratios:

  • Current Ratio and the Quick Ratio from the "I. Short term solvency, or liquidity, ratios" category
  • Return on Assets Ratio and the Return on Equity Ratio from the "IV. Profitability ratios" category
  • Price Earnings Ratio and the Price Sales Ratio from the "V. Market value ratios" category.

Then provide a one-page (minimum) discussion about what each trend indicates for your assigned corporation. Is the trend good or bad, why?

2) Using the investing dot com study guide Download investing dot com study guide, find the industry ratios for your corporation (you will also find the earnings growth rate here). Note that the ratios provided in investing.com for your assigned corporation may not match your part (1) calculations exactly. IF THE INVESTING.COM WEBSITE DOES NOT PROVIDE INDUSTRY DATA please use thehttps://www.readyratios.com/sec/SUN_sunoco-lp Links to an external site.website for the liquidity ratios and for the profitability ratios. You may skip the market value ratios industry comparison. This link is for Sunoco (SUN) but simply type the stock symbol for your corporation in the top of the website and hit enter.

Compare your calculated ratios for your assigned corporation to the industry ratios. Then provide a one-page (minimum) discussion that details whether your assigned corporation is performing better or worse than the industry based on the definitions of the six ratios. Are your calculated trends from part (1) moving closer to or farther away from the industry averages? Is this good or bad?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

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

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

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

Get Started

Recommended Textbook for

Intermediate Financial Management

Authors: Eugene F. Brigham, Phillip R. Daves

11th edition

978-1111530266

More Books

Students also viewed these Finance questions