Create two depreciation schedule templates, which automatically adjusts to the value of input variables. One schedule template you will use Excel internal function, and another without Excel internal function. Not to depreciate more than the salvage value, you need to use IF function. The headings of the depreciation schedule include: year, DDB depreciation, and SYD depreciation. You must construct the worksheet with the appropriate numeric format and professional layout. Round number values to the nearest whole dollar. The fixed variables for the assignment are as follows:

Life of asset = 10 years

Depreciation methods = double-declining balance method or SYD

Purchase date of asset = January 1, 2017

I will test accuracy of your worksheet with random input variables acquisition cost and salvage value.