USE EXCEL ONLY AND DEMOSTRATE THE FINANCIAL FUNCTIONS ON EXCEL.

The Microsoft Company purchased a new office computer and other depreciable computer hardware for $12,000. Assume that no salvage was initially declared and that the machine was expected to last 5 years. Required: 1. Prepare a table with the depreciation schedules and book values for each method: a. Straight-line depreciation b. Double declining balance depreciation c. 100% bonus depreciation d. MACRS depreciation.

2.Compute the PW of the depreciation charges for each method using an interest rate of 10%. Summarize all the information in a table and interpret the results.

***Important*** Use Excel ONLY to do this (tables, graphs, PW, etc.) and demonstrate the use of financial functions to compute the depreciation schedules a, b, d.