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
Copied
  Completed
You need to have access to the item to view this lesson.
One-time Fee
$69.99
List Price:  $99.99
You save:  $30
€67.23
List Price:  €96.05
You save:  €28.81
£54.79
List Price:  £78.28
You save:  £23.48
CA$100.29
List Price:  CA$143.28
You save:  CA$42.98
A$112.09
List Price:  A$160.13
You save:  A$48.04
S$94.52
List Price:  S$135.03
You save:  S$40.51
HK$543.88
List Price:  HK$777
You save:  HK$233.12
CHF 61.94
List Price:  CHF 88.49
You save:  CHF 26.55
NOK kr788.73
List Price:  NOK kr1,126.80
You save:  NOK kr338.07
DKK kr502.03
List Price:  DKK kr717.22
You save:  DKK kr215.19
NZ$123.81
List Price:  NZ$176.87
You save:  NZ$53.06
د.إ257.07
List Price:  د.إ367.26
You save:  د.إ110.18
৳8,350.53
List Price:  ৳11,929.84
You save:  ৳3,579.31
₹5,977
List Price:  ₹8,538.94
You save:  ₹2,561.93
RM314.04
List Price:  RM448.65
You save:  RM134.61
₦108,176.53
List Price:  ₦154,544.52
You save:  ₦46,367.99
₨19,454.09
List Price:  ₨27,792.76
You save:  ₨8,338.66
฿2,391.55
List Price:  ฿3,416.65
You save:  ฿1,025.10
₺2,463.31
List Price:  ₺3,519.17
You save:  ₺1,055.85
B$446.27
List Price:  B$637.56
You save:  B$191.28
R1,312.34
List Price:  R1,874.85
You save:  R562.51
Лв131.59
List Price:  Лв188
You save:  Лв56.40
₩101,993.60
List Price:  ₩145,711.39
You save:  ₩43,717.78
₪255.42
List Price:  ₪364.90
You save:  ₪109.48
₱4,105.61
List Price:  ₱5,865.41
You save:  ₱1,759.80
¥11,000.67
List Price:  ¥15,715.92
You save:  ¥4,715.24
MX$1,411.29
List Price:  MX$2,016.21
You save:  MX$604.92
QR254.14
List Price:  QR363.08
You save:  QR108.93
P970.50
List Price:  P1,386.50
You save:  P415.99
KSh9,031.50
List Price:  KSh12,902.70
You save:  KSh3,871.20
E£3,557.88
List Price:  E£5,082.90
You save:  E£1,525.02
ብር8,897.26
List Price:  ብር12,710.92
You save:  ብር3,813.65
Kz63,830.88
List Price:  Kz91,190.88
You save:  Kz27,360
CLP$69,240.40
List Price:  CLP$98,919.10
You save:  CLP$29,678.70
CN¥510.85
List Price:  CN¥729.82
You save:  CN¥218.97
RD$4,256.60
List Price:  RD$6,081.12
You save:  RD$1,824.52
DA9,455.74
List Price:  DA13,508.78
You save:  DA4,053.03
FJ$162.28
List Price:  FJ$231.84
You save:  FJ$69.55
Q538.26
List Price:  Q768.97
You save:  Q230.71
GY$14,619.81
List Price:  GY$20,886.35
You save:  GY$6,266.53
ISK kr9,767.10
List Price:  ISK kr13,953.60
You save:  ISK kr4,186.50
DH704.68
List Price:  DH1,006.73
You save:  DH302.05
L1,289.28
List Price:  L1,841.91
You save:  L552.62
ден4,135.94
List Price:  ден5,908.74
You save:  ден1,772.79
MOP$559.01
List Price:  MOP$798.63
You save:  MOP$239.61
N$1,299.34
List Price:  N$1,856.28
You save:  N$556.93
C$2,571.30
List Price:  C$3,673.45
You save:  C$1,102.14
रु9,517.06
List Price:  रु13,596.38
You save:  रु4,079.32
S/260.20
List Price:  S/371.74
You save:  S/111.53
K283.61
List Price:  K405.18
You save:  K121.56
SAR262.82
List Price:  SAR375.47
You save:  SAR112.65
ZK1,933.89
List Price:  ZK2,762.82
You save:  ZK828.92
L334.85
List Price:  L478.38
You save:  L143.52
Kč1,692.49
List Price:  Kč2,417.95
You save:  Kč725.45
Ft27,633.93
List Price:  Ft39,478.73
You save:  Ft11,844.80
SEK kr761.65
List Price:  SEK kr1,088.11
You save:  SEK kr326.46
ARS$71,885.87
List Price:  ARS$102,698.50
You save:  ARS$30,812.63
Bs482.86
List Price:  Bs689.84
You save:  Bs206.97
COP$308,852.42
List Price:  COP$441,236.66
You save:  COP$132,384.23
₡35,480.70
List Price:  ₡50,688.88
You save:  ₡15,208.18
L1,775.44
List Price:  L2,536.46
You save:  L761.01
₲544,980.94
List Price:  ₲778,577.57
You save:  ₲233,596.63
$U3,110.44
List Price:  $U4,443.67
You save:  $U1,333.23
zł286.56
List Price:  zł409.39
You save:  zł122.83
Already have an account? Log In

Transcript

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

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.