how to do it on excel each method with formula please

E 1 B C D USE THE APPROPRIATE FORMATTING FOR ALL CELLS FOR FULL CREDIT Straight Line Double Declining Balance 101 101 Building Van 2000 2000 $545,000.00 $134,000.00 $45,000.00 $14,000.00 20 Dep EXP Ace Dep Dep HP Remainder 0 Ace Dep 2 Depreciation Method 3 Asset 4 Asset 5 Year Acquired 6 Cost 7 Salvage Value Estimated Useful Life 9 Year 10 2000 11 2001 12 2002 13 2003 14 2004 15 2005 16 2006 17 2007 18 2008 19 2009 20 2010 21 2011 22 2012 23 2013 24 2014 25 2015 26 2016 R Duet rralle Sranarin Cumman Fact Fan Acco D E A 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 2022 2023 2024 2 3 4 5 8 Dep Exp Totals -8 19 10 31 92 43 B. Pivot C - Calculate Scenario Summary D - Forecast E. Dep Asset Extra Credit *** LO Type here to search DELL