Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

I need a Financial stement analysis on the company 3M! for the year 2021! The calculations i have to do are as follows . Prepare

I need a Financial stement analysis on the company 3M! for the year 2021!

The calculations i have to do are as follows . Prepare a horizontal (trend) analysis for the balance sheet 1 point 2. Prepare a horizontal (trend) analysis for the income statement 1 point 3. Prepare a vertical (common size) analysis for the balance sheet 1 point 4. Prepare a vertical (common size) analysis for the income statement 1 point 5. Net profit margin 2 points P a g e 2 | 2 6. Gross profit percentage 2 points 7. Fixed asset turnover ratio 3 points 8. Return on Equity (ROE) 3 points 9. Earnings per Share (EPS) 3 points 10. Price / Earnings Ratio (P/E) 2 points 11.Receivables turnover ratio and days to collect 4 points 12. Inventory turnover ratio and days to sell 4 points 13.Current ratio 2 point 14. Debt-to-assets ratio 3 points 15. Times interest earned 3 points

Attached is a link to 3Ms statements and balance sheets. https://investors.3m.com/financials/sec-filings/default.aspx preferable for 2020-2021

please Include these ratios in excel for me and or so i cant readilly read it! thank you!

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

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

Step: 2

blur-text-image

Step: 3

blur-text-image

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

Management Accounting

Authors: Will Seal, Carsten Rohde, Ray Garrison, Eric Noreen

6th Edition

9780077185534

Students also viewed these Accounting questions