Finance Deprediation Schedules Excel FOLE HOME INSERT PAGE LAYOUTFORMULAS DATARE

Question

Finance Deprediation Schedules Excel FOLE HOME INSERT PAGE LAYOUTFORMULAS DATAREVIEW E Sign In | asteB A Alignment Number Conditional Format as Cell Cels Editing Formatting. Table. Styles . Styles F1 $150,000 10,000 Cost: 4 Estimated Residual: 5stimated Lite in years: 4 Estimated uife in hours: Actual Hours: eYear3 9 Year 2 360 270 350 220 to calculate the Prspare the folowing Straight Line depreciation schedule by using the excel SLN FUNCTION ( s Depreciation Expense for Years 1-4 in the Depreciation Expense column Lnter the remalning cells.

Explanation / Answer

Prepare depreciation schedule :

a) Straight line method : (150000-10000)/4 = 35000

b) Unit of production method :

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

c) Double decline method :
straight line rate = 100/4 = 25%

double decline rate = 25*2=50%

Year Depreciation expense 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 F
• Subjects

---

---

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