Help with Financial Calcuations
ksawndk2Ratio 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
NOT RATED
- ratio-tesla.docx
- book1-01.xlsx
Bids(1)