Question
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](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
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](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started