EXCEL FORMULAS NEEDED! I cannot figure out the correct formula as DB, DDB, SNL for the correct answers to match the cells on the photos that have been given :(

Sullivan ranch corporation has purchased a new tractor and has provided the information related to the purchase. the controller has asked you to calculate the depreciation for the new piece of equipment using different methods. straight-line depreciation, units if production depreciation, and double-declining balance depreciation. use the information included in the excel simulation and EXCEL FUNCTION FORMULAS described below to complete the task.

Sullivan ranch corporation has purchased a new tractor and has provided the information related to the purchase. the controller has asked you to calculate the depreciation for the new piece of equipment using different methods. straight-line depreciation, units if

I cannot figure out the correct formulas to get the proper numbers...help! The last response given was all incorrect as the formula did not match the correct cells:(

Requirement 1: Straight Line Depreciation

	A	B	C=A-B	sum of each year's depreciation expense
Year	Book Value	Depreciation expense	Ending Book Value	Accumulated Depreciation
1	$ 150,000.00	$ 35,000.00	$ 115,000.00	$ 35,000.00
2	$ 115,000.00	$ 35,000.00	$ 80,000.00	$ 70,000.00
3	$ 80,000.00	$ 35,000.00	$ 45,000.00	$ 105,000.00
4	$ 45,000.00	$ 35,000.00	$ 10,000.00	$ 140,000.00

Working:

(Straight Line Method)		tractor A
A	Cost	$ 150,000.00
B	Residual Value	$ 10,000.00
C=A - B	Depreciable base	$ 140,000.00
D	Life [in years]	4
E=C/D	Annual SLM depreciation	$ 35,000.00

Requirement 2:

	A	B	C =B * Depreciation expense per hour	D=A-C	sum of each year's depreciation expense
Year	Book Value	Usage	Depreciation expense	Ending Book Value	Accumulated Depreciation
1	$ 150,000.00	360	$ 42,000.00	$ 108,000.00	$ 42,000.00
2	$ 108,000.00	270	$ 31,500.00	$ 76,500.00	$ 73,500.00
3	$ 76,500.00	350	$ 40,833.33	$ 35,666.67	$ 114,333.33
4	$ 35,666.67	220	$ 25,666.67	$ 10,000.00	$ 140,000.00

Working:

Bus 3 (Unit of Activity)
A	Cost	$ 150,000.00
B	Residual Value	$ 10,000.00
C=A - B	Depreciable base	$ 140,000.00
D	Usage IN Hours	1,200
E = C/D	Depreciation per Hour	$ 116.67

Requirement 3:

Year	Beginning Book Value	Depreciation rate	Depreciation expense	Ending Book Value	Accumulated Depreciation
1	$ 150,000.00	50.00%	$ 75,000.00	$ 75,000.00	$ 75,000.00
2	$ 75,000.00	50.00%	$ 37,500.00	$ 37,500.00	$ 112,500.00
3	$ 37,500.00	50.00%	$ 18,750.00	$ 18,750.00	$ 131,250.00
4	$ 18,750.00	Beginning book value - Residual value	$ 8,750.00	$ 10,000.00	$ 140,000.00

Working:

Bus 2 (Double declining method)		Tractor A
A	Cost	$ 150,000.00
B	Residual Value	$ 10,000.00
C=A - B	Depreciable base	$ 140,000.00
D	Life [in years]	4
E=C/D	Annual SLM depreciation	$ 35,000.00
F=E/C	SLM Rate	25.000%
G=F x 2	DDB Rate	50.000%

Workbook Views Show Zoom Macros fx Sullivan Ranch Corporation has purchased a new tractor. The following Sullivan Ranch Corporation has purchased a new tractor. The following information is given: $ $ 150,000 10,000 1200 Cost: Estimated Residual: Estimated Life in years: 6 Estimated Life in hours: 7 Actual Hours: Year 1 9 Year 2 Year 3 Year 4 360 10 Prey 1 of 1 Next Assignment i Saveu 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 Depreciation Schedule-Units-of-Production Method End of year amounts Depreciation Accumulated Book Value Expense Depreciation 42,000 $ 42,000 2 $ 31,500 $ 73,500 40,833 25,667 Total Year 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. SULLIVAN RANCH CORPORATION B C 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 Depreciation Schedule-Units-of-Production Method End of year amounts Depreciation Accumulated Year Book Value Expense Depreciation 1 $ 42,000 $ S 42,000 2 S AMBALL 31,500 73,500 3 $ 40,833 $ 25,667 Total 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. SULLIVAN RANCH CORPORATION Prey 1 of 1 !!! Next Excel Assignment Help Sav Prepare the following Double-Declining-Balance depreciation schedule by using the Excel DDB FUNCTION (fx) to calculate Depreciation Expense for Years 1-4 in the Depreciation Expense column. Enter formulas or absolute cell references for the remaining cells. SULLIVAN RANCH CORPORATION Depreciation Schedule-Double Declining-Balance Method E End of year amounts Depreciation Accumulated Book Value Expense Depreciition Total Depreciation Expense Accumulated Depreciation Book value 31 year 1 =B8*B13 =C31 -B3-D31 32 year2 =B9*B13 =C31-C32 -B3-D32 33 year3 =B10*B13 =D32-C33 =B3-D33 34 year4 =B11*B13 =D33-C34 =B3-D34 Working A 3 cost * 150,000.00 4 Estimated Residual * 10,000.00 5 Estimated Life in years 4 6 Estimated life in hours 1200 7 Actual hours 8 year 1 360 9 year2 270 10 year3 350 11 year4 12 Residual value 140000 13 Depreciation per hour * 116.67 220