Question
Prepare a report that presents ALL your computations and discussions in Part 2. The report should be ORGANIZED AND easy to follow (i.e., put your
- Prepare a report that presents ALL your computations and discussions in Part 2. The report should be ORGANIZED AND easy to follow (i.e., put your computation in labeled tables like Exhibit A of this document).
- Prepare a letter to accompany the report. The LETTER should NOT go into detail about formulas and how amounts were determined. Instead, the letter should immediately (in the first paragraph) state the purpose of the analysis and your RECOMMENDATION. The paragraphs to follow should discuss HOW and WHY you make the recommendation. Most importantly, your letter MUST reference the report throughout. Be sure to mention in the first paragraph that you have attached a detailed report on which your recommendation is based.
INFORMATION/COMPUTATIONS
inventory turnover ratio
company 1 | company 2 | |
2017 | 111.9/13.754=8.1 | 29,963/4,864 = 6.16 |
2018 | 139.4/16.61=8.4 | 32,275/5,209 = 6.2 |
2019 | 165.5/18.835=8.8 | 32,918/5,409 = 6.09 |
Receivables Turnover
company 1 | company 2 | |
2017 | 15.04 | 29.95 |
2018 | 14.33 | 40.18 |
2019 | 13.69 | 42.25 |
Acid test ratio-Quick ratio
company 1 | company 2 | |
2017 | 30.986B+6.4B/ 57.883=0.6 | 10,616/7,122 = 1.49 |
2018 | 41.25B+12.6B/68.391=0.8 | 9,829/7,817 = 1.26 |
2019 | 55.021+16.8/87.812=0.8 | 8,870/7,315 = 1.21 |
Current ratio
company 1 | company 2 | |
2017 | 131,310/45,718=2.87:1 | 1.5 |
2018 | 162,648/50,708=3.21:1 | 1.3 |
2019 | 225,248/75,376=2.99:1 | 1.2 |
free cash flow
comapny 1 | company 2 | |
2017 | 18,365-(-11,955)= 30,320 | 2,557-580 = 1,977 |
2018 | 30,723-(-13,427)= 44,150 | 2,141-668 = 1,473 |
2019 | 38,514-(-16,861)=55,375 | 2,408-819 = 1,589 |
debt to total assets ratio
company 1 | company 2 | |
2017 | 45,718/131,310= 35% | 7,826/13,856 = 56.5% |
2018 | 50,708/162,648= 31% | 8,626/13,059 = 66.1% |
2019 | 75,376/225,248= 33% | 8,263/12,901 = 64% |
Return on common stockholders' equity ratio
company 1 | company 2 | |
2017 | 3,033/23.497=12.9% | 1,228/4,709 = 26% |
2018 | 10,073/35.629=28.3% | 1,000/3,612 = 27.7% |
2019 | 11,588/52.804=21.9% | 1,464/3,306 = 44.3% |
ROA
company 1 | company 2 | |
2017 | 3,033/131,310= 2.31% | 1207/13856 = 8.71% |
2018 | 10,073/162,648= 6.19% | 999/13059 = 7.65% |
2019 | 11,588/225,248= 5.15% | 1464/12901 = 11.35% |
asset turnover ratio
company 1 | company 2 | |
2017 | NS=177,866 TA= 131,310 , ATR= 1.35 | 13856=TA TR=39403,,, 2.84 |
2018 | NS=232,887 TA=162,648 ATR= 1.43 | TA= 13,059 TR=42,151,, 3.22 |
2019 | NS=280,522 TA= 225,248 ATR= 1.25 | TA=12,901 TR=42,879,, 3.32 |
profit margin formula
company 1 | company 2 | |
2017 | company 1 reported net losses instead of gaining revenue for the profit margin on all accounts. | 1228/39,409 3.15% |
2018 | 1000/42,151 = 2.37% | |
2019 | 1464/42,879 = 3.41% |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started