Question
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
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
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