Sullivan ranch corporation EXCEL FORMULA HELP PLEASE!

Please help solve the proper excel formulas :(. I've tried so many times and it doesn't come outright. I would deeply appreciate it!

DDB EXCEL FORMULA FOR CELLS NEEDED! PLEASE! Example =DDB (,,,,) etc.

Sullivan Ranch corporation 2 Matching principle demands that all expense must be reported in the income statement related to the revenues of the current period. When an asset is purchased, then its cost is capitalised and is not expensed since the asset is going to be used for several years and will generate revenue through |out its useful life. Therefore, a concept depreciation/ amortisation evolved in which the cost of the asset is expensed every year to a certain extent. Part 1 a -Calculation of Depreciation exp. Under SLM Method (Acquisition cost - Salvage value) / useful life (150000 - 10000) Depreciable cost 10 Depreciation for the year Dep. Rate (1/4 = 25 % ) Accumulated dep. Book value 11 %3D Dep. Expense 12 At acquisition 150000 13 Year 1 140000 0.25 35000 35000 115000 Year 2 140000 0.25 14 35000 70000 80000 Year 3 35000 105000 15 140000 0.25 45000 140000 Year 4 0.25 35000 140000 10000 17 Part 1b - Calculation of Depreciation exp. Under Units of production method Depreciation for the year 18 ( 150000 - 10000) Depreciable cost 19 20 Accumulated dep. Book value Dep. Rate Dep. Expense 21 150000 At acquisition 360 / 1200 270/1200 350 / 1200 22 140000 42000 108000 Year 1 42000 23 Year 2 76500 140000 31500 73500 24 Year 3 140000 40833 114333 35667 220/ 1200 25667 25 Year 4 140000 140000 10000 26 Part 1c- Calculation of Depreciation exp. Under Double declining balance 27 28 Depreciation for the year Opening Book value (a) Depreciation rate(b) ( see W.N) Accumulated dep. 29 Dep. Expense (a*b) Closing Book value 30 At acquisition 150000 31 Year 1 150000 0.5 75000 75000 75000 32 Year 2 37500 18750 75000 0.5 112500 37500 33 Year 3 37500 18750 0.5 131250 Year 4 34 18750 0.5 8750 140000 10000 Working Note ( WN) - ( adjusted in order to get salvage value ) 35 36 In DDB method, Salvage value is not considered. 37 SLM rate = 25 % 38 DDB rate = 25 * 2 = 50 % 39 1234 n670 9OENM456N 2 3 6 Part 1 a -Calculation of Depreciation exp. Under SLM Method (Acquisition cost - Salvage value )/ useful life ( 150000 - 10000) 10 Depreciation for the year Dep. Rate (1/4 = 25 % ) Accumulated dep. 11 Depreciable cost Dep. Expense Book value %3D 150000 12 13 140000 14 140000 15 140000 16 140000 =B13*C13 0.25 =D13 =F12-D13 0.25 =B14*C14 =E13+D14 =F13-D14 0.25 =E14+D15 =B15*C15 =F14-D15 =F15-D16 0.25 =B16*C16 =E15+D16 17 Part 1b - Calculation of Depreciation exp. Under Units of production method 18 ( 150000 - 10000 ) Depreciable cost 19 Depreciation for the year 20 Dep. Expense Accumulated dep. Dep. Rate Book value 21 150000 360 / 1200 270 / 1200 350 / 1200 220/1200 22 140000 23 140000 24 140000 25 140000 42000 =D22 =F21-D22 31500 =E22+D23 =F22-D23 40833 =E23+D24 =F23-D24 =F24-D25 25667 =E24+D25 26 Part 1 c- Calculation of Depreciation exp. Under Double declining balance 27 28 Depreciation for the year Depreciation rate(b) ( see W.N) Dep. Expense (a*b) Accumulated dep. Closing Book value 29 Opening Book value (a) 30 =F21 31 150000 32 =F31 33 =F32 34 =F33 =B31*C31 =B31-D31 0.5 =D31 =B32-D32 0.5 =B32*C32 =E31+D32 =B33*C33 =B33-D33 0.5 =E32+D33 0.5 8750 =E33+D34 =B34-D34 ( adjusted in order to get salvage value ) 35 36 37 38 8. Year 1 360 9. Year 2 270 10 Year 3 350 11 Year 4 220 12 Prepare the following Straight Line depreciation schedule by using the excel SLN FUNCTION (fx) to calculate the 13 Depreciation Expense for Years 1-4 in the Depreciation Expense column. Enter formulas or absolute cell references for the remaining cells. 14 15 16 SULLIVAN RANCH CORPORATION 17 Depreciation Schedule-Straight Line Method End of year amounts Accumulated Depreciation 18 Depreciation Expense 19 Year Book Value 20 35,000 $ 35,000 $ 70,000 | $ 105,000 $ 115,000 21 35,000 $ 80,000 35,000 $ 35,000 S 22 45,000 23 $4 140,000 S 10,000 24 Total 140,000 25 Prepare the following Units-of-Production depreciation schedule by entering formulas. 26 Use absolute cell references when appropriate. SULLIVAN RANCH CORPORATION 27 Sheeti 100% READY Attemptis) Next Prev 1 of 1 Assignment 6 A. 140,000 2$ Total 24 25 Prepare the following Units-of-Production depreciation schedule by entering formulas. 26 Use absolute cell references when appropriate. SULLIVAN RANCH CORPORATION Depreciation Schedule-Units-of-Production Method End of year amounts 27 28 29 Accumulated Depreciation Expense 42,000 $ 31,500 $ 40,833 Book Value Year Depreciation 30 42,000 1 31 73,500 2$ 32 2$ 3 33 25,667 4. 34 Total 35 36 Prepare the following Double-Declining-Balance depreciation schedule by using the Excel DDB FUNC" calculate Depreciation Expense for Years 1-4 in the Depreciation Expense column. Enter formulas or a references for the remaining cells. 38 39 SULLIVAN RANCH CORPORATION 40 37 Help Save Excel Assignment 6 Saved Prepare the following Double-Declining-Balance depreciation schedule by using the Excel DDB FUNCTION (fx) to 37 calculate Depreciation Expense for Years 1-4 in the Depreciation Expense column. Enter formulas or absolute cell references for the remaining cells. 38 39 SULLIVAN RANCH CORPORATION Depreciation Schedule-Double-Declining-Balancd Method 40 41 End of year amounts: 42 Depreciation Expense Accumulatisd Deprecition Book Value Year 43 44 45 46 47 Total 48 49 50 51 52 G rocc - Google Sea. First Horizon Bank. el Assignment G 76.92/100 Total points awarded Submitted Help You received partial credit in the previous attempt. Prepare the following Double-Declining-Balance depreciation schedule by using the Excel DDB FUNCTION (x) to 37 calculate Depreciation Expense for Years 1-4 in the Depreciation Expense column. Enter formulas or absolute cell references for the remaining cells. 38 39 SULLIVAN RANCH CORPORATION Depreciation Schedule-Double-Declining-Balance Method End of year amounts 40 41 42 Depreciation Expense X =ddb(b3,b4,b5.c44 S X -ddb(b3,b4 ,b5,1) X =ddb(e44-e45) X -b33*c33 X =ddb(b3,b4 B31*X =(e33+d34) Accumulated Year 43 Book Value Depreciation 75,000 X =f21 44 45 37,500 X -(e45+d46) 46 S 18,750 FC b3-047 3. 47 4 140,000 48 Total 49 50 51 1 of 1 Prev Next 7