Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Use the spreadsheet to calculate the companys profitability, turnover-control, and leverage and liquidity ratios for these years. What do these ratios suggest about the companys
Use the spreadsheet to calculate the companys profitability, turnover-control, and leverage and liquidity ratios for these years. What do these ratios suggest about the companys performance over this period? I need the table below filled out please!
RAAS, INC. | ||||
BALANCE SHEET ($ millions) | ||||
2017 | 2018 | 2019 | 2020 | |
ASSETS | ||||
Cash & Short-Term Investments | 7,179 | 6,345 | 5,763 | 7,787 |
Net Receivables | 3,677 | 3,498 | 4,272 | 2,749 |
Inventories | 5,055 | 5,261 | 5,622 | 7,367 |
Prepaid Assets | 1,150 | 1,130 | 1,968 | 1,653 |
Total Current Assets | 17,061 | 16,234 | 17,625 | 19,556 |
Gross Plant, Property & Equipment | 7,958 | 8,891 | 9,469 | 12,758 |
Accumulated Depreciation | 3,969 | 4,437 | 4,725 | 4,795 |
Net Plant, Property & Equipment | 3,989 | 4,454 | 4,744 | 7,963 |
Intangibles | 422 | 439 | 437 | 497 |
Other Assets | 3,787 | 3,787 | 3,787 | 3,787 |
TOTAL ASSETS | 25,259 | 24,914 | 26,593 | 31,803 |
LIABILITIES | ||||
Long Term Debt Due in One Year | 331 | 342 | 15 | 696 |
Accounts Payable | 2,048 | 2,279 | 2,612 | 2,248 |
Taxes Payable | 280 | 374 | 463 | 358 |
Accrued Expenses | 1,080 | 1,196 | 1,215 | 1,038 |
Other Current Liabilities | 1,735 | 1,849 | 3,561 | 3,944 |
Total Current Liabilities | 5,474 | 6,040 | 7,866 | 8,284 |
Long Term Debt | 3,471 | 3,468 | 3,464 | 12,319 |
Deferred Liabilities | 1,907 | 3,216 | 3,347 | 2,684 |
TOTAL LIABILITIES | 10,852 | 12,724 | 14,677 | 23,287 |
EQUITY | ||||
Common Stock | 3 | 3 | 3 | 3 |
Additional Paid in Capital | 8,638 | 6,384 | 7,163 | 8,299 |
Retained Earnings | 3,979 | 3,517 | 1,643 | (191) |
Other Gains | (213) | (92) | 231 | (56) |
TOTAL EQUITY | 12,407 | 9,812 | 9,040 | 8,055 |
TOTAL LIABILITIES & EQUITY | 23,259 | 22,536 | 23,717 | 31,342 |
Common Shares Outstanding | 1,643 | 1,601 | 1,568 | 1,558 |
INCOME STATEMENT ($ millions, except per share) | ||||
2017 | 2018 | 2019 | 2020 | |
Sales | 34,350 | 36,397 | 39,117 | 37,403 |
Cost of Goods Sold | 19,038 | 20,441 | 21,643 | 21,162 |
Gross Profit | 15,312 | 15,956 | 17,474 | 16,241 |
Selling, General, & Administrative Exp. | 10,563 | 11,511 | 12,702 | 13,126 |
Operating Profit | 4,749 | 4,445 | 4,772 | 3,115 |
Interest Expense | 59 | 54 | 49 | 89 |
Other Expense | (196) | 66 | (78) | 139 |
Pretax Income | 4,886 | 4,325 | 4,801 | 2,887 |
Provision for Taxes | 646 | 2,392 | 772 | 348 |
Net Income | 4,240 | 1,933 | 4,029 | 2,539 |
EPS | 2.58 | 1.21 | 2.57 | 1.63 |
Calculate the following ratios (it is acceptable to write the formulas) | ||||||
a. | 2017 | 2018 | 2019 | 2020 | ||
Profitability Ratios | ||||||
Return on equity | 29.4% | 15.9% | 33.8% | 29.8% | ||
Return on assets | 16.8% | 7.8% | 15.2% | 8.0% | ||
Return on invested capital | ||||||
Profit margin | ||||||
Gross margin | ||||||
Turnover-Control Ratios | ||||||
Asset turnover | ||||||
Fixed-asset turnover | ||||||
Inventory turnover | ||||||
Collection period (days) | ||||||
Days' sales in cash | ||||||
Payables period | ||||||
Leverage and Liquidity Ratios | ||||||
Assets to equity | ||||||
Debt to assets | ||||||
Debt to equity | ||||||
Times interest earned | ||||||
Current ratio | ||||||
Acid test | ||||||
b. | Comments | |||||
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