Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Can anyone help me with these questions in the excel box? Apple Inc. # Question 26 To whom is the Report of Independent Registered Public

image text in transcribedimage text in transcribedCan anyone help me with these questions in the excel box?

Apple Inc. # Question 26 To whom is the "Report of Independent Registered Public Accounting Firm" addressed? 27 Liquidity Ratios: What was the company's current ratio for 2019? 1.54 28 Liquidity Ratios: What was the company's Accounts Receivable turnover for 2019? 29 Liquidity Ratios: What was the company's Days to Collect for 2019? 30 Liquidity Ratios: What was the company's Inventory Trunover Ratio for 2019? 31 Liquidity Ratios: What was the company's Days to Sell for 2019? 32 Profitability ratios: What was the gross profit percentage for 2019? 33 Profitability ratios: What was the net profit margin ratio for 2019? 34 Profitability ratios: What was the FIXED asset turnover ratio for 2019? 35 Profitability ratios: What Return on Equity for 2019? 36 Profitability ratios: What was the BASIC Eamings Per Share for 2019? 37 Profitability ratios: Price/Eamings Ratio for 2019? (Use a Close Price of $218.82 for Apple & $95.83 for Walmart) 38 Solvency Ratios: What was the debt-to-asset ratio for 2019? 39 Solvency Ratios: What was the times interest earned for 2019? 40 What was the net sales for 2019? 41 What is the net sales % change between 2019 - 2018? 42 What is the net sales % change between 2019-2015? (Apple ONLY : 2015 not a typo) 43 What is the net sales % change between 2019-2017? (Walmart ONLY; 2017 not a typo) 43 What was the cost of Sales (aka COGS) for 2019? 44 What was the Cost of Sales PERCENTAGE (aka COGS) for 2019? (Answer to 2 decimals: 0.00%) 45 What was the Gross Margin dollar amount for 2019? 46 What was the Gross Margin % for 2019? (Answer to 2 decimals: 0.00%) 47 How much cash was provided/used by "Operating activities" in 2019? 48 How much cash was provided/used by "Financing activities" in 2019? 49 How much cash was provided/used by "Investing activities" in 2019? 50 What was the % Change in Cash from Operating activities from 2017 - 2919? Apple Inc. CONSOLIDATED BALANCE SHEETS (In millions, except number of shares which are reflected in thousands and par value) September 28, 2019 September 29, 2018 ASSETS: $ $ 48,844 51,713 25,913 40,388 23,186 3.956 22.926 Current assets: Cash and cash equivalents Marketable securities Accounts receivable, net Inventories Vendor non-trade receivables Other current assets Total current assets 4,106 25,809 22,878 12,352 162,819 12,087 131,339 Non-current assets: Marketable securities Property, plant and equipment, net Other non-current assets Total non-current assets Total assets 105,341 37,378 32,978 175,697 338,516 170.799 41.304 22,283 234,386 365.725 $ $ LIABILITIES AND SHAREHOLDERS' EQUITY: : $ $ 55,888 33,327 Current liabilities: Accounts payable Other current liabilities Deferred revenue Commercial paper Term debt Total current liabilities 46,236 37,720 5,522 5,980 10,260 105,718 5,966 11,964 8,784 115,929 Non-current liabilities: Term debt Other non-current liabilities Total non-current liabilities Total liabilities 91,807 50,503 142,310 248,028 93,735 48,914 142,649 258,578 Commitments and contingencies Shareholders' equity: Common stock and additional paid-in capital, $0.00001 par value: 12,600,000 shares authorized: 4,443,236 and 4,754,986 shares issued and outstanding, respectively Retained earnings Accumulated other comprehensive income/(loss) Total shareholders' equity Total liabilities and shareholders' equity 45, 174 45,898 (584) 40,201 70,400 (3,454) 107,147 365,725 90,488 338,516 $ $ See accompanying Notes to Consolidated Financial Statements

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

Money, Markets And Capital The Case For A Monetary Analysis

Authors: Jean Cartelier

1st Edition

0815355777, 9780815355779

More Books

Students also viewed these Accounting questions