Accounting for Depreciation

Master Depreciation Accounting with Advanced Excel Model Various methods of depreciation and Depreciation Accounting
4 minutes
Share the link to this page
You need to have access to the item to view this lesson.
One-time Fee
List Price:  $99.99
You save:  $30
List Price:  €91.99
You save:  €27.60
List Price:  £78.70
You save:  £23.61
List Price:  CA$136.12
You save:  CA$40.84
List Price:  A$149.36
You save:  A$44.81
List Price:  S$134.57
You save:  S$40.37
List Price:  HK$779.70
You save:  HK$233.93
CHF 63.61
List Price:  CHF 90.88
You save:  CHF 27.26
NOK kr746.97
List Price:  NOK kr1,067.14
You save:  NOK kr320.17
DKK kr480.44
List Price:  DKK kr686.38
You save:  DKK kr205.93
List Price:  NZ$163.32
You save:  NZ$49
List Price:  د.إ367.26
You save:  د.إ110.19
List Price:  ৳11,670.06
You save:  ৳3,501.36
List Price:  ₹8,326.90
You save:  ₹2,498.32
List Price:  RM468.45
You save:  RM140.55
List Price:  ₦150,334.96
You save:  ₦45,105
List Price:  ₨27,760.43
You save:  ₨8,328.96
List Price:  ฿3,602.53
You save:  ฿1,080.87
List Price:  ₺3,220.12
You save:  ₺966.13
List Price:  B$510.29
You save:  B$153.10
List Price:  R1,818.79
You save:  R545.69
List Price:  Лв179.65
You save:  Лв53.90
List Price:  ₩135,856.19
You save:  ₩40,760.93
List Price:  ₪369.98
You save:  ₪111
List Price:  ₱5,788.84
You save:  ₱1,736.82
List Price:  ¥15,569.94
You save:  ¥4,671.45
List Price:  MX$1,659.36
You save:  MX$497.86
List Price:  QR363.44
You save:  QR109.04
List Price:  P1,350.41
You save:  P405.16
List Price:  KSh13,098.69
You save:  KSh3,930
List Price:  E£4,680.53
You save:  E£1,404.29
List Price:  ብር5,724.51
You save:  ብር1,717.52
List Price:  Kz84,838.74
You save:  Kz25,454.16
List Price:  CLP$89,276.78
You save:  CLP$26,785.71
List Price:  CN¥709.51
You save:  CN¥212.87
List Price:  RD$5,838.06
You save:  RD$1,751.59
List Price:  DA13,448.41
You save:  DA4,034.92
List Price:  FJ$222.79
You save:  FJ$66.84
List Price:  Q774.26
You save:  Q232.30
List Price:  GY$20,849.79
You save:  GY$6,255.56
ISK kr9,678.91
List Price:  ISK kr13,827.61
You save:  ISK kr4,148.70
List Price:  DH992.23
You save:  DH297.69
List Price:  L1,765.83
You save:  L529.80
List Price:  ден5,662.25
You save:  ден1,698.84
List Price:  MOP$800.92
You save:  MOP$240.30
List Price:  N$1,823.35
You save:  N$547.06
List Price:  C$3,669
You save:  C$1,100.81
List Price:  रु13,286.84
You save:  रु3,986.45
List Price:  S/372.17
You save:  S/111.66
List Price:  K387.03
You save:  K116.12
List Price:  SAR375
You save:  SAR112.51
List Price:  ZK2,543.81
You save:  ZK763.22
List Price:  L457.65
You save:  L137.31
List Price:  Kč2,272.97
You save:  Kč681.96
List Price:  Ft35,512.48
You save:  Ft10,654.81
SEK kr747.87
List Price:  SEK kr1,068.43
You save:  SEK kr320.56
List Price:  ARS$88,665.87
You save:  ARS$26,602.42
List Price:  Bs688.59
You save:  Bs206.59
List Price:  COP$381,601.87
You save:  COP$114,492.01
List Price:  ₡51,006.90
You save:  ₡15,303.60
List Price:  L2,467.63
You save:  L740.36
List Price:  ₲746,739.85
You save:  ₲224,044.36
List Price:  $U3,879.22
You save:  $U1,163.88
List Price:  zł391.77
You save:  zł117.54
Already have an account? Log In


In this section I'll walk you through the efficient accounting principle and journal entries by example. So let's assume the cost of an asset is $3,000. useful life is five years and salvage value is 5000. We'll be assuming straight on method. In this example, as accounting entries in any method would remain same as our contract principle our same after we have put this asset to use, first entry at end of year one or end of month would be depreciated expenditure rehabilitate with $9,000. Here the entries for entire year so the appreciation for the first year is $9,000.

As we've seen in our previous example, straight run methods, the same amount of depreciation each year, assuming that we're going to pause this entry 10 of the year, I'm going to be using yearly figure but the entry for month end would be same as this entry. So that precision expenditure for the year is $9,000, which is debited to your p&l account. An accumulated depreciation account is credited as we understand what is accumulated depreciation in previous section of this course. So, it will be credited to balance sheet as a reduction from fixed assets. Now, at end of useful life of this assets, we have to dispose of this asset and close the fixed asset ledger and also accumulate definition ledger. So, as you see the total depreciation for five years would be 45,000 since we have a salvage value of $5,000.

So, accumulated depreciation account since it is a credit to asset account, we have to debit the account to close the same accumulated depreciation account will be debited cash in bank would be our salvage value. Since we have assumed that our asset would be sold for $5,000 we have confirmed that we're going to receive that much amount if you're going to dispose of the asset at the end of its useful life. So $5,000 would be our income and it will be in form of bank or cash so that we are to debit and credit the asset cost account which is $50,000. So in this example, salary value means the minimum value feature and again at the end of the useful life of the asset, the same amount would be our book value. So, in this case there would be no profit or loss. What is the generality if you sold this asset for a profit, suppose it ends up is useful life that is five years, he has sold his asset for a value of $10,000.

So, in this case we are to debit accumulated depreciation account with $45,000 which is depreciation for five years, we also to debit bank or cash which is $10,000 as we have sold for $10,000 here to credit asset account, which is the main cost of the asset $50,000. And we have to credit profit in our income statement with $5,000. Why $5,000 because our book value is $5,000. So, anything above our book value is a profit. What if the asset is sold at a loss? Suppose you're selling this asset for some reason at the end of year three.

So, in this case, we'll be debiting accumulated depreciation account with $27,000 which is nothing but Three years depreciation your one year two year 300,000 into three. Now, we have to debate whatever we have received from the realization of this assets, which is $10,000. And that would be loss on sale of this asset because the asset still has a book value and we have received less than the book value of the asset which is $13,000 and we are to credit asset account with actual cost which is $15,000. How the loss is calculated here in this example is $50,000 the cost of our asset you would minus the depreciation which accumulated at end of year three which is $27,000. So, the total remaining value would be $23,000 you to minus the utilization of the asset which is $10,000. The remaining value would be $30,000 and loss, while all the deposition formula include salvage value in the calculation of depreciation per month per year, solid value is difficult to estimate for any asset interaction Typical work scenario, I'll be ignoring the same in next section where I'll be demonstrating you depreciation calculation with the pro depreciation model in MS Excel.

Very few assume salvage value to be zero at beginning of the year when you acquire the asset. At the end of the useful life of asset you can always creditor enter realization from the assets sold to your p&l which is simpler version rather than assuming a salvage value which is very difficult to estimate in the first place. The next section will be going through the pro depreciation template which I have created from scratch in Microsoft Excel. Thank you for watching.

Sign Up


Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.