Answered step by step
Verified Expert Solution
Link Copied!

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

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

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

Fixed Income Securities Tools For Todays Markets

Authors: Bruce Tuckman, Angel Serrat

3rd Edition

0470891696, 978-0470891698

More Books

Students also viewed these Finance questions