Question - Need to create a spreadsheet using the following information from the assignment.
Resources: Financial Accounting: Tools for Business Decision Making
What were the total cost and book value of property, plant, and equipment at September 27, 2014? Using the notes to find financial statements, what method or methods of depreciation are used by Apple for financial reporting purposes?
What was the amount of depreciation and amortization expense for each of the three years 2012-2014? (Hint: Use the statement of cash flows).
Using the statement of cash flows, what are the amounts of property, plant, and equipment purchased in 2014 and 2013?
Using the notes to the financial statements, explain in the summary how Apple accounted for its intangible assets in 2014.
Use the Excel Workbook (provided with the assignment instructions) to show your work and submit with your analysis.