Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Compute the following ratios for the current year and the prior year. Show the appropriate formulas in the first column. Show all supporting computations in

Compute the following ratios for the current year and the prior year. Show the appropriate formulas in the first column. Show all supporting computations in the second and third columns.

Ratio

Current Year

Prior Year

  1. Inventory Turnover

Formula:

  1. Current Ratio

Formula:

  1. Debt to Capital

Formula:

  1. Return on Assets

Formula:

  1. Return on Equity

Formula:

  1. Times Interest Earned

Formula:

  1. Price to Earnings

Formula:

  1. Price to Book

Formula:

image text in transcribed

image text in transcribed

Jun 30, 2019 Jun 30, 2018 $ 11,356 122,463 133,819 29,524 2,063 10,146 175,552 36,477 7,379 2,649 42,026 7,750 14,723 286,556 $ 11,946 121,822 133,768 26,481 2,662 6,751 169,662 29,460 6,686 1,862 35,683 8,053 7,442 258,848 Common-Size Balance Sheet Jun. 30, 2019 Jun 30, 2018 3.96% 4.62% 42.74% 47.06% 46.70% 51.68% 10.30% 10.23% 0.72% 1.03% 3.54% 2.61% 61.26% 65.55% 12.73% 11.38% 2.58% 2.58% 0.92% 0.72% 14.67% 13.79% 2.70% 3.11% 5.14% 2.88% 100.00% 100.00% BALANCE SHEETS- USD ($) $ in Millions Current assets: Cash and cash equivalents Short-term investments Total cash, cash equivalents, and short-term investments Accounts receivable, net of allowance for doubtful accounts of $411 and $377 Inventories Other Total current assets Property and equipment, net of accumulated depreciation of $35,330 and $29,223 Operating lease right-of-use assets Equity investments Goodwill Intangible assets, net Other long-term assets Total assets Current liabilities: Accounts payable Current portion of long-term debt Accrued compensation Short-term income taxes Short-term unearned revenue Other Total current liabilities Long-term debt Long-term income taxes Long-term unearned revenue Deferred income taxes Operating lease liabilities Other long-term liabilities Total liabilities Commitments and contingencies Stockholders' equity: Common stock and paid-in capital - shares authorized 24,000; outstanding 7,643 and 7,677 Retained earnings Accumulated other comprehensive loss Total stockholders' equity Total liabilities and stockholders' equity 9,382 5,516 6,830 5,665 32,676 9,351 69,420 66,662 29,612 4,530 233 6,188 7,581 184,226 8,617 3,998 6,103 2,121 28,905 8,744 58,488 72,242 30,265 3,815 541 5,568 5,211 176,130 3.27% 1.92% 2.38% 1.98% 11.40% 3.26% 24.23% 23.26% 10.33% 1.58% 0.08% 2.16% 2.65% 64.29% 3.33% 1.54% 2.36% 0.82% 11.17% 3.38% 22.60% 27.91% 11.69% 1.47% 0.21% 2.15% 2.01% 68.04% 78,520 24,150 (340) 102,330 $ 286,556 71,223 13,682 (2,187) 82,718 $ 258,848 27.40% 8.43% -0.12% 35.71% 100.00% 27.52% 5.29% -0.84% 31.96% 100.00%

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

A Step By Step Guide To Doing An Internal Audit Of Your Supply Chain

Authors: Barden Gonzalez

1st Edition

B0BZFCVLBR, 979-8388637338

More Books

Students also viewed these Accounting questions

Question

What is absolute advantage?

Answered: 1 week ago

Question

Understanding Group Leadership Culture and Group Leadership

Answered: 1 week ago