Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

On each data tab, use formulas to calculate the following financial indicators for each year of data: o Current ratio o Debt/equity ratio o Free

On each data tab, use formulas to calculate the following financial indicators for each year of data:

o Current ratio o Debt/equity ratio o Free cash flow o Earnings per share o Price/earnings ratio o Return on equity o Net profit margin

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

1 Apple Inc (NMS: AAPL) 2 Exchange rate used is that of the Year End 6 As Reported Annual Cash Flow 09/30/2017 09/24/2016 09/26/2015 8 Currency Audit Status Qualifie Qualifie Qualifie 10 Consolidated Thousand Thousand Thousand 21120000 45687000 10505000 4210000 4938000 12 Cash &cash equivalents, beginning of the year 20484000 48351000 10157000 4840000 5966000 166000 -2093000 2723000 -4254000 -5318000 9618000 626000 154000 63598000 1.59E+08 27 Proceeds from maturities of marketable securities 31775000 94564000 -329000 30 Payment for acquisition of property, plant & equip -12451000 344000 13 Net income (loss) 14 Depreciation & amortization 15 Share-based compensation expense 16 Deferred income tax expense (benefit 17 Other adjustments 13844000 53394000 11257000 3586000 1382000 611000 -238000 -3735000 179000 5400000 1042000 8746000 81266000 1.66E+08 14538000 1095000 217000 51000 1090000 1791000 1554000 2104000 65824000 1.42E+08 21258000 90536000 -297000 12734000 -814000 1388000 110000 -45977000 495000 407000 1570000 12150000 29722000 24954000 2500000 -397000 20483000 636000 20484000 10444000 1316000 19 Inventories 20 Vendor non-trade receivables 21 Other current & non-current assets 23 Deferred revenue 24 Other current & non-current liabilities 25 Net cash flows from operating activities 26 Purchases of marketable securities 28 Proceeds from sales of marketable securities 29 Payments made in connection with business acq 11247000 241000 31 Payment for acquisition of intangible assets 32 Payments for strategic investments 33 Other cash flow from investing activities 34 Net cash flows from investing activities 35 Proceeds from issuance of common stock 36 Excess tax benefits from equity awards -395000 220000 46446000 555000 627000 37 Payments for taxes related to net share settlee -1874000 38 Payments for dividends & dividend equivalent pa -12769000 32900000 28662000 3500000 3852000 17347000 44 Increase (decrease) in cash & cash equivalents 195000 20289000 26000 56274000 543000 749000 -1499000 11561000 35253000 27114000 39 Repurchases of common stock 40 Proceeds from issuance of term debt, net 41 Repayments of term debt 42 Change in commercial paper, net 43 Net cash flows from financing activities 2191000 -17716000 7276000 21120000 13252000 514000 45 Cash & cash equivalents, end of the year 46 Cash paid (received) for income taxes, net 47 Cash paid during the year for interest 2092000 2017 Balance Sheet 2017 Income Statement 2017 Cash Flow Stock Prices + 1 Apple Inc (NMS: AAPL) 2 Exchange rate used is that of the Year End 6 As Reported Annual Cash Flow 09/30/2017 09/24/2016 09/26/2015 8 Currency Audit Status Qualifie Qualifie Qualifie 10 Consolidated Thousand Thousand Thousand 21120000 45687000 10505000 4210000 4938000 12 Cash &cash equivalents, beginning of the year 20484000 48351000 10157000 4840000 5966000 166000 -2093000 2723000 -4254000 -5318000 9618000 626000 154000 63598000 1.59E+08 27 Proceeds from maturities of marketable securities 31775000 94564000 -329000 30 Payment for acquisition of property, plant & equip -12451000 344000 13 Net income (loss) 14 Depreciation & amortization 15 Share-based compensation expense 16 Deferred income tax expense (benefit 17 Other adjustments 13844000 53394000 11257000 3586000 1382000 611000 -238000 -3735000 179000 5400000 1042000 8746000 81266000 1.66E+08 14538000 1095000 217000 51000 1090000 1791000 1554000 2104000 65824000 1.42E+08 21258000 90536000 -297000 12734000 -814000 1388000 110000 -45977000 495000 407000 1570000 12150000 29722000 24954000 2500000 -397000 20483000 636000 20484000 10444000 1316000 19 Inventories 20 Vendor non-trade receivables 21 Other current & non-current assets 23 Deferred revenue 24 Other current & non-current liabilities 25 Net cash flows from operating activities 26 Purchases of marketable securities 28 Proceeds from sales of marketable securities 29 Payments made in connection with business acq 11247000 241000 31 Payment for acquisition of intangible assets 32 Payments for strategic investments 33 Other cash flow from investing activities 34 Net cash flows from investing activities 35 Proceeds from issuance of common stock 36 Excess tax benefits from equity awards -395000 220000 46446000 555000 627000 37 Payments for taxes related to net share settlee -1874000 38 Payments for dividends & dividend equivalent pa -12769000 32900000 28662000 3500000 3852000 17347000 44 Increase (decrease) in cash & cash equivalents 195000 20289000 26000 56274000 543000 749000 -1499000 11561000 35253000 27114000 39 Repurchases of common stock 40 Proceeds from issuance of term debt, net 41 Repayments of term debt 42 Change in commercial paper, net 43 Net cash flows from financing activities 2191000 -17716000 7276000 21120000 13252000 514000 45 Cash & cash equivalents, end of the year 46 Cash paid (received) for income taxes, net 47 Cash paid during the year for interest 2092000 2017 Balance Sheet 2017 Income Statement 2017 Cash Flow Stock Prices +

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

My Favorite Auditor Gave Me This Book

Authors: Funny Planner Publishing

1st Edition

1676058060, 978-1676058069

More Books

Students also viewed these Accounting questions