i need help guys! due today. please include any formulas or work needed.

Instructions: .Create depreciation schedules in Excel for the Akeo Appetizers using the data provided in the Acc 255 Graded Assignment 4 Plant Assets Excel file o Create a depreciation schedule for each asset Each schedule should be a new sheet in the workbook. Name the new sheets after the name of the asset (Example: Building) The depreciation schedule should include calculations of annual depreciation AND accumulated depreciation for each year of the asset's useful life o o Include a data section for each schedule (i.e. Cost, Salvage value, estimated useful life, etc. o Create formulas or use the Excel functions to calculate depreciation. Use cell references to the data section (use absolute cell references when appropriate) Set up the depreciation schedules so that it can be used as a template for other assets. For each asset, include the adjusting journal entry for depreciation for the year 2017 at the bottom of the schedule o o . Format each schedule to make it visually organized and appealing . Adjust settings so that each schedule prints out on one page. .Add your name to the bottom right-hand footer of the all of the worksheets. . Add your name to the completed Excel file using your first initial and last name. (Example: ACC ment #4-Plant .Submit your completed Excel file back to the Assignment in Laulima by the due date indicated in the assignment. Grading Rubric Maximum Points 10 Requirements Create accurate depreciation schedules for each asset from the data provided Set up schedules so that they can be used as a template for other assets Use or create Excel formulas to calculate depreciation Use absolute cell references in depreciation formulas where a Prepare adjusting Use formatting tools in Excel to make each schedule (including adjusting journal entry) print to one page and visuall Create and name new sheets in workbook Add your name to footer of each sheet and to file name 10 riate rnal entry for each plant asset anized and appealin Total points 50 Hints: .Building depreciation for 2017 should just be for 4/1 to 12/31 (or 9/12 3/4) . Delivery truck do NOT need to adjust 2017 depreciation for purchase on 4/1/2017 since depreciation is based on miles (not, years). Equipment depreciation for 2017 should just be for 7/1 to 12/31 (or 6/12~ ). You can NOT use the Declining Balance formula in Excel due to the partial year adjustment in 2017! Time to get creative with Excel;) o Bookshelf depreciation for 2017 should just be for 10/1 to 12/31 (or 3/12 )