Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Current ratio (current assets/current liabilities) Inventory turnover (sales/inventories) If the firm has zero inventory, please write down N/A. Debt ratio (total liabilities/total assets) Profit margin

image text in transcribed

Current ratio (current assets/current liabilities)

Inventory turnover (sales/inventories)

If the firm has zero inventory, please write down N/A.

Debt ratio (total liabilities/total assets)

Profit margin (net incomes/sales)

PE ratio (stock price/earnings per share) Use the stock price on the financial statement date as the numerator. Stock price is not available on the financial statements, you have to find it online. (it is not available, when looking online I found $422.99) Make sure you use cell reference to do the calculation so that if the data is changed, all of your results are automatically changed. I will test this when I grade the assignment.

I can not get these answers right or the calculations on excel. Please show all work and make cell references when doing the calculations. Thank you.

Consolidated Balance Sheets - USD ($) $ in Thousands Dec. 31, 2019 Dec. 31, 2018 $5,018,437 o 1,160,067 6,178,504 24,504,567 565,221 2,727,420 33,975,712 $3,794,483 5,151,186 748,466 9,694,135 14,951,141 418,281 910,843 25,974,400 Cash and cash equivalents Current content assets, net Other current assets Total current assets Non-current content assets, net Property and equipment, net Other non-current assets Total assets Current liabilities: Current content liabilities Accounts payable Accrued expenses and other liabilities Deferred revenue Total current liabilities Non-current content liabilities Long-term debt Other non-current liabilities Total liabilities Commitments and contingencies Stockholders' equity: Preferred stock, $0.001 par value; 10,000,000 shares authorized at December 31, 21 Common stock, $0.001 par value; 4,990,000,000 shares authorized at December 31 Accumulated other comprehensive loss Retained earnings Total stockholders' equity Total liabilities and stockholders' equity 4,413,561 674,347 843,043 924,745 6,855,696 3,334,323 14,759,260 1,444,276 26,393,555 4,681,562 562,985 481,874 760,899 6,487,320 3,759,026 10,360,058 129,231 20,735,635 2,793,929 -23,521 4,811,749 7,582,157 $33,975,712 2,315,988 -19,582 2,942,359 5,238,765 $25,974,400

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

Auditing Oracle E Business Suite Common Issues

Authors: Jeffrey T. Hare

1st Edition

1329529766, 978-1329529762

More Books

Students also viewed these Accounting questions