Resources: Financial Accounting: Tools for Business Decision Making Note :

I need to create a spreadsheet using the following information from the assignment.

Resources: Financial Accounting: Tools for Business Decision Making 

Note: The financial statements of Apple, Inc. are presented in Appendix A of Financial Accounting. Instructions for accessing and using the company's complete annual report, including the notes to the financial statements, are also provided in Appendix A. 

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.

Total cost and book value of property, plant, and equipment at September 27, 2014 :Total Cost : $ 39,015 MillionBook Value : $ 20,624 Million2. Methods of depreciation are used by Apple for...