Spreadsheets

SLN function: depreciate a laptop evenly over its life in Excel

Use the SLN function in Excel to depreciate a work laptop evenly over its life, get a yearly and monthly figure, and see why it is not the tax rate.

Editorial illustration for SLN function: depreciate a laptop evenly over its life in Excel

The SLN function gives straight-line depreciation: the same amount every period. Its syntax is =SLN(cost, salvage, life), so for a ₹72,000 laptop with a ₹6,000 salvage value and a four-year life, =SLN(72000, 6000, 4) returns ₹16,500 a year. Divide by 12, or ask for the life in months, and you get the monthly figure of ₹1,375.

What do the three arguments mean?

  • cost: what you paid, including anything needed to put the laptop to work, ₹72,000 here
  • salvage: what you expect it to be worth at the end of its useful life, ₹6,000 in this example. It can be 0.
  • life: the number of periods over which you spread the cost, 4 years here

Put the three numbers in cells, say B1 = 72000, B2 = 6000 and B3 = 4, and write =SLN(B1,B2,B3). That way you can change an assumption without editing the formula.

How do you get a monthly figure?

SLN works in whatever period you give it, so state the life in months:

=SLN(B1, B2, B3*12)

That is (72,000 - 6,000) / 48 = ₹1,375 a month. The same answer comes from =SLN(B1,B2,B3)/12. Use whichever your reader will find clearer. A life of zero gives a #DIV/0! error, so check that cell first if you see one.

What does the schedule look like?

Book value is cost less the depreciation charged so far. Here are the four years in this made-up example:

YearDepreciationTotal chargedBook value at year end
116,50016,50055,500
216,50033,00039,000
316,50049,50022,500
416,50066,0006,000

After year 4 the book value equals the salvage of ₹6,000, which is how you know the schedule is right. In the sheet, each year's depreciation is =SLN($B$1,$B$2,$B$3), the total charged is a running =SUM($B$6:B6) on that column, and book value is =$B$1-C6.

What if you bought it part-way through the year?

SLN has no start-month argument, so do the proration yourself. Suppose the laptop arrived in October and your financial year runs April to March. That is six months of use in the first year, so the first-year charge is 6 x ₹1,375 = ₹8,250. Years two to four are full years at ₹16,500, and the last year carries the remaining six months, so the total is still ₹66,000. Check: 8,250 + 16,500 x 3 + 8,250 = 66,000.

The same function works in Google Sheets with the same arguments. If you have several laptops, give each its own row with cost, salvage and life in separate cells and fill the formula down. Then a total row adds up the yearly charge for the whole fleet, which is handy when you replace one machine every year and want to see the combined effect on your costs.

How do you choose the life and salvage?

Both are your judgement. A common approach is to look at how long you actually keep laptops and what they fetch when you sell or hand them on. If you are unsure, use 0 for salvage and a life you are comfortable with, then revisit when you replace the machine. Whatever you pick, note it beside the schedule so the numbers can be reproduced later.

Keep the paperwork with the number

  1. Save the purchase invoice with the date, cost and any serial number.
  2. Record the life and salvage you assumed.
  3. Note whether the laptop is used wholly for work or shared with personal use.
  4. Start a new row when you replace it.

SpendixAI keeps receipts with their transactions, so the invoice can stay attached to the purchase entry that your depreciation row refers to.

SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports