FinanceTier 820 minadvanced

Straight-Line Depreciation Schedule

Build a multi-year depreciation schedule where each year carries forward the previous year's closing balance.

What you will learn

• Carry a running book value forward from one row to the next
• Explain why recomputing from the original cost every row breaks the running total
• Calculate straight-line depreciation from cost, salvage value and useful life

Excel skills

SLN, running totals · Running Calculations

The task

An asset worth 120479 depreciates in a straight line to a salvage value of 12048 over 5 years. Row 6 already has the opening book value. Calculate the depreciation and closing book value for that row, then carry the closing balance forward as next year's opening balance.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free