Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Your parents are considering investing in Apple Inc. common stock. They ask you, as an accounting expert, to make an analysis of the company for

Your parents are considering investing in Apple Inc. common stock. They ask you, as an accounting expert, to make an analysis of the company for them. Financial statements of Apple are presented on the following:

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

Instruction

image text in transcribed

image text in transcribed

Compute for all 5 years, (1) Debt to assets Ratio and (2) Times Interest Earned

Debt to Assets Ratio: _______% (2018) ____________% (2017) ___________% (2016) __________% (2015) ________% (2014)

Times Interest Interest Earned: ______times ________times ________times ______times ______times

-

Compute for all 5 years, (1) Profit Margin, (2) Asset Turnover, (3) Return on Assets and (4) return on Common StockHolder's Equity

(I NEED HELP !! Pls answer it, fast!)

A-2 APPENDIX A Specimen Financial Statements: Apple Inc. Apple Inc. Consolidated Statements of Comprehensive Income (in millions) Net income Other comprehensive income/(loss): Change in foreign currency translation, net of tax effects of $(1),$(77) and $8, respectively (525) Years ended Change in unrealized gains/losses on derivative instruments: Change in fair value of derivatives, net of tax benefit/(expense) of $(149),$(478) and $(7), respectively Adjustment for net (gains)/losses realized and included in net income, net of tax expense/(benefit) of $(104),$475 and $131, respectively Total change in unrealized gains/losses on derivative instruments, net of tax 905 (162) (3,407) (782) (741) Change in unrealized gains/losses on marketable securities: Change in fair value of marketable securities, net of tax benefit/ (expense) of $1,156,$425 and $(863), respectively Adjustment for net (gains)/losses realized and included in net income, net of tax expense/(benefit) of $21,$35 and $(31), respectively \begin{tabular}{rrr} 1 & (64) & 56 \\ \cline { 3 - 3 }(3,406) & (846) & 1,638 \\ \hline \end{tabular} Total other comprehensive income/(loss) Total comprehensive income Apple Inc. Consolidated Balance Sheets (in millions, except number of shares which are reflected in thousands and par value) ASSETS: Current assets: Cash and cash equivalents \begin{tabular}{cc} September 29, September 2018 & 2017 \\ \hline \end{tabular} Marketable securities Accounts receivable, net Inventories Vendor non-trade receivables Other current assets Total current assets Non-current assets: Marketable securities Property, plant and equipment, net Other non-current assets Total non-current assets Total assets LIABILITIES AND SHAREHOLDERS' EQUITY: Current liabilities: Commitments and contingencies Shareholders' equity: Common stock and additional paid-in capital, $0.00001 par value: 12,600,000 shares authorized; 4,754,986 and 5,126,201 shares issued and outstanding, respectively Retained earnings \begin{tabular}{rr} $25,913 & $20,289 \\ 40,388 & 53,892 \\ 23,186 & 17,874 \\ 3,956 & 4,855 \\ 25,809 & 17,799 \\ 12,087 & 13,936 \\ \hline 131,339 & 128,645 \end{tabular} A nola Ine Apple Inc. Consolidated Statements of Cash Flows (in millions) Years ended Cash and cash equivalents, beginning of the year Operating activities: Net income Adjustments to reconcile net income to cash generated by operating activities: Depreciation and amortization Share-based compensation expense Deferred income tax expense/(benefit) Other 59,53148,35145,687 Changes in operating assets and liabilities: Accounts receivable, net Inventories Vendor non trade receivables Other current and non-current assets Accounts payable Deferred revenue Other current and non-current liabilities Cash generated by operating activities Investing activities: Purchases of marketable securities Proceeds from maturities of marketable securities Proceeds from sales of marketable securities Payments for acquisition of property, plant and equipment 10,9035,340(32,590)(444)10,1574,8405,966(166)10,5054,2104,938486 Payments made in connection with business acquisitions, net \begin{tabular}{ccc} (5,322) & (2,093) & 527 \\ 828 & (2,723) & 217 \\ (8,010) & (4,254) & (51) \\ (423) & (5,318) & 1,055 \\ 9,175 & 8,966 & 2,117 \\ (44) & (626) & (1,554) \\ 38,490 & 1,125 & (1,906) \\ \hline 77,434 & 64,225 & 66,231 \\ \hline \end{tabular} Purchases of non-marketable securities Proceeds from non-marketable securities Other Cash generated by/(used in) investing activities Financing activities: Make a 5-year trend analysis, using 2014 as the base year, of (1) net sales and (2) net income. (To satisfy this requirement you must access information regarding performance in prior years. This information is provided in the complete annual report available on the company's website.) (Round percentages to 0 decimal places, e.g. 15% and enter amounts in millions.) APPLE INC. Trend Analysis of Net Sales and Net Income For the Three Years Ended 2018 (1) Net sales 2018 2017 2016 Trend % % % (2) Net income $ 59,531 $ 48,351 $ 45,687 Trend % % % A-2 APPENDIX A Specimen Financial Statements: Apple Inc. Apple Inc. Consolidated Statements of Comprehensive Income (in millions) Net income Other comprehensive income/(loss): Change in foreign currency translation, net of tax effects of $(1),$(77) and $8, respectively (525) Years ended Change in unrealized gains/losses on derivative instruments: Change in fair value of derivatives, net of tax benefit/(expense) of $(149),$(478) and $(7), respectively Adjustment for net (gains)/losses realized and included in net income, net of tax expense/(benefit) of $(104),$475 and $131, respectively Total change in unrealized gains/losses on derivative instruments, net of tax 905 (162) (3,407) (782) (741) Change in unrealized gains/losses on marketable securities: Change in fair value of marketable securities, net of tax benefit/ (expense) of $1,156,$425 and $(863), respectively Adjustment for net (gains)/losses realized and included in net income, net of tax expense/(benefit) of $21,$35 and $(31), respectively \begin{tabular}{rrr} 1 & (64) & 56 \\ \cline { 3 - 3 }(3,406) & (846) & 1,638 \\ \hline \end{tabular} Total other comprehensive income/(loss) Total comprehensive income Apple Inc. Consolidated Balance Sheets (in millions, except number of shares which are reflected in thousands and par value) ASSETS: Current assets: Cash and cash equivalents \begin{tabular}{cc} September 29, September 2018 & 2017 \\ \hline \end{tabular} Marketable securities Accounts receivable, net Inventories Vendor non-trade receivables Other current assets Total current assets Non-current assets: Marketable securities Property, plant and equipment, net Other non-current assets Total non-current assets Total assets LIABILITIES AND SHAREHOLDERS' EQUITY: Current liabilities: Commitments and contingencies Shareholders' equity: Common stock and additional paid-in capital, $0.00001 par value: 12,600,000 shares authorized; 4,754,986 and 5,126,201 shares issued and outstanding, respectively Retained earnings \begin{tabular}{rr} $25,913 & $20,289 \\ 40,388 & 53,892 \\ 23,186 & 17,874 \\ 3,956 & 4,855 \\ 25,809 & 17,799 \\ 12,087 & 13,936 \\ \hline 131,339 & 128,645 \end{tabular} A nola Ine Apple Inc. Consolidated Statements of Cash Flows (in millions) Years ended Cash and cash equivalents, beginning of the year Operating activities: Net income Adjustments to reconcile net income to cash generated by operating activities: Depreciation and amortization Share-based compensation expense Deferred income tax expense/(benefit) Other 59,53148,35145,687 Changes in operating assets and liabilities: Accounts receivable, net Inventories Vendor non trade receivables Other current and non-current assets Accounts payable Deferred revenue Other current and non-current liabilities Cash generated by operating activities Investing activities: Purchases of marketable securities Proceeds from maturities of marketable securities Proceeds from sales of marketable securities Payments for acquisition of property, plant and equipment 10,9035,340(32,590)(444)10,1574,8405,966(166)10,5054,2104,938486 Payments made in connection with business acquisitions, net \begin{tabular}{ccc} (5,322) & (2,093) & 527 \\ 828 & (2,723) & 217 \\ (8,010) & (4,254) & (51) \\ (423) & (5,318) & 1,055 \\ 9,175 & 8,966 & 2,117 \\ (44) & (626) & (1,554) \\ 38,490 & 1,125 & (1,906) \\ \hline 77,434 & 64,225 & 66,231 \\ \hline \end{tabular} Purchases of non-marketable securities Proceeds from non-marketable securities Other Cash generated by/(used in) investing activities Financing activities: Make a 5-year trend analysis, using 2014 as the base year, of (1) net sales and (2) net income. (To satisfy this requirement you must access information regarding performance in prior years. This information is provided in the complete annual report available on the company's website.) (Round percentages to 0 decimal places, e.g. 15% and enter amounts in millions.) APPLE INC. Trend Analysis of Net Sales and Net Income For the Three Years Ended 2018 (1) Net sales 2018 2017 2016 Trend % % % (2) Net income $ 59,531 $ 48,351 $ 45,687 Trend % % %

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

International Finance Transactions Policy And Regulation

Authors: Hal Scott, Anna Gelpern

20th Edition

1609303164, 978-1609303167

More Books

Students also viewed these Finance questions

Question

=+b) What would the data values in such an indicator variable be?

Answered: 1 week ago

Question

When should you avoid using exhaust brake select all that apply

Answered: 1 week ago