This is meant to be completed on Excel. Please show text boxes and formulas. Thank you!

McConnell Corp. began operations this year The table below contains a list of PP&E acquired by McConnell Corp. McConnell wants to see the difference in depreciation expense over the life of their assets under Straight line, Double Declining Balance, and Sum of the Years' D gits depreciatibn methods They would like to be able to see the annual amounts as well seeing the lifetime totals NAME RESIDUAL VAL 20 14 8.6 IN THOUSANDS COST USEFUL LIFE 155.6 208.9 85.4 10 456.3 - 5 225.4 699.2 558.3 622.85 322.57 1 10.55 15 35 58 56 44 H Required: Please prepare an output of a table, showing only the years in the useful life, that would allow McConnel to view the annual and total depreciation on an asset by asset basis. You may not use any numbers in your final submission other than those you may reference from the table above or may insert in formulas Due date is 12/3 but there is no penalty for late submissions through 12/7 You may discuss or work with others in the class but each of you must submit your own work. Do not copy someone else's file. Post all questions to the Discussion Board set up for this project