(PICTURES) Prepare depreciation schedules using Straight-Line, Activity Based, a

Question

(PICTURES) Prepare depreciation schedules using Straight-Line, Activity Based, and Double-Declining Balance Depreciation.

i Safari File Edit View History Bookmarks Develop Window Help :) 21% CO Tue 3:48 PM Dalton Brown 2 TheTC Legend hoo! Sports Taylor Count.SSports.com Apple Disney ESPN Yahoo! Coastal Carol...na University Apple Yahoo Bing Google Wikipedia The Weather Channel Advance thro...uard Member Amazon Bill Chapter 8 Extra Credit G Help Save & Exi Submit Determine depreciation using three methods 1. Prepare depreciation schedules using Straight-Line, Activity Based, and Double-Declining Balance Depreciation 10 Finance Depreciation Schedules Excel - × FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW Vw Sign In Print B l u. : .. Alignment Number Conditional Format as Cell Cells Editing Fomatting TableStyles Paste Clipboard Al K Sullivan Ranch Corporation has purchased a new tractor. The following 1 Sullivan Ranch Corporation has purchased a new tractor. The following information is given S 150,000 S 10,000 3 Cost: 4 Estimated Residual 5 Estimated Life in years: 6 Estimated Life in hours: 7 Actual Hours: 8 Year 1 1200 360 Year 2 10 Year 3 350 Year 4 12 Prepare the following Straight Line depreciation schedule by using the excel SLN FUNCTION (fx) to calculate the l3 Depreciation Exnense for Years14 in the Depreciation Exense column. Enter formulas or absolute cell references Prev 1 of 1 Next

Explanation / Answer

Depreciation schedule :

a) Straight line method dep :

Dep = (150000-10000)/4 =35000 per year

Unit of activity method :

Dep rate = (150000-10000)/1200 = 116.67 per hour

Double decline method :

straight line rate = 100/4=25%

double decline rate = 25*2=50%

Year Depreciation expenses Accumlated depreciation Book value 1 35000 35000 115000 2 35000 70000 80000 3 35000 105000 45000 4 35000 140000 10000 Total 140000

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.