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 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

The Law And Economics Of Patent Damages, Antitrust, And Legal Process

Authors: James Langenfeld, Frank Fagan, Samuel Clark

2nd Edition

1800710259, 9781800710252

More Books

Students also viewed these Accounting questions

Question

Discuss the significance of evolutionary theory to psychology.

Answered: 1 week ago

Question

What is the formula to calculate the mth Fibonacci number?

Answered: 1 week ago

Question

Describe the major barriers to the use of positive reinforcement.

Answered: 1 week ago