How can we apply the three methods of calculating depreciation in the below excel ? Using the three depreciation functions in excel, "SLN," "SYD" and "VDB,"

Example 3.18 Using the three depreciation functions in excel, "SLN," "SYD" and "VDB," we can apply the three methods of calculating depreciation requested: A B D Notes 1 2. Formula 3 SLN(cost, salvage,life) SLN(10000,2000,4) 4 SYD(cost, salvage, life, period) SYD(10000,2000,4,1) 5 SYD(10000,2000,4,2) 6 SYD(10000,2000,4,3) 7 SYD(10000,2000,4,4) For year 1 For year 2 For year 3 For year 4 Answe $2,000 $3,200 $2,400 $1,600 $800 VDB(cost, salvage, life, starting 8 period, ending period) VDB(10000,2000,4,0,1) Between Yr 0 and 1 $5,000 9 VDB(10000,2000,4,1,2) Between Yr 1 and 2 $2,500 10 VDB(10000,2000,4,2,3) Between Yr 2 and 3 $500 11 VDB(10000,2000,4,3,4) Between Yr 3 and 4 $0 12