Help with Financial Calcuations

profileksawndk2

Ratio Calculation

On each data tab in the attached excel workbook, use formulas to calculate the following financial indicators for each year of data:

o Current ratio

o Debt/equity ratio

o Free cash flow

o Earnings per share

o Price/earnings ratio

o Return on equity

o Net profit margin

Written Responses

Respond to the following:

o Describe how and why each of the ratios has changed over the three-year period. For example, did the current ratio increase or decrease? Why?

o Describe how three of the ratios you calculated for your company compare to the general industry.

 Find general industry data by entering your specific company’s ticker symbol here:  https://biz.yahoo.com/p/

 

  • 7 years ago
  • 20
Answer(1)

Purchase the answer to view it

blurred-text
NOT RATED
  • attachment
    ratio-tesla.docx
  • attachment
    book1-01.xlsx
Bids(1)