Need Help In FIN

Purpose of Assignment

Students should understand how to use the financial information and tools learned in the class on a public company, obtain public company SEC reports, and use that data to calculate a company's financial ratios and their comparison to industry or competitor standards.

Assignment Steps 

Resources: Tutorial help on Excel® and Word functions can be found on the Microsoft®Office® website. There are also additional tutorials via the web that offer support for office products. 



Obtain the most current SEC Form 10-K (annual financial report) from the company's web site (Do not use the Annual Report that is sent to shareholders):

  • Lowes


Calculate and analyze the following ratios for your selected company for the last two years from the SEC Form 10-K:

  • Current Ratio
  • Debt Ratio
  • Time Interest Earned
  • Gross Profit Margin
  • Net Profit Margin
  • Asset Turnover
  • Return on Assets
  • Equity Multiplier
  • Return on Equity (Use three ratio DuPont method)

All ratios should be calculated using data from the company's financial statements in the 10-K Report.


Specify what year financial data is being used (indicate the dates of the company's fiscal year).

Question Field

Asked by gryan
3 years ago
1142 Rank 1166 Views
59 Rank 766 Views

Asked by jchandler 3 years ago

745 Rank 1305 Views
 No Title

Asked by chelsea28 3 years ago

492 Rank 1156 Views
 For Wendy Lewis

Asked by jchandler 3 years ago

1147 Rank 250 Views

Asked by robertsmaria 3 years ago

35 Rank 302 Views
 No Title

Asked by pooletraci 3 years ago

1152 Rank 284 Views
 Balance Sheet

Asked by sherrywalker 3 years ago

823 Rank 1125 Views