Guys i need help to do Depreciation in VBA Excel.Im Clueless
Guys i need help to do Depreciation in VBA Excel.Im Clueless
Welcome to the Forum Nesh31!
You will need to be more specific. Do you have an Excel file with data in it to start with? Please see yellow banner at the top of the page and attach it.
Is the problem that you do not understand depreciation, or that you just don't know how to set it up in Excel?
You posted as a VBA question but it is almost certain that you don't need VBA for this.
There are several methods of depreciation. The most common is straight line. To do straight-line depreciation you have to know the initial value of an asset, it's depreciable life, and salvage value. The depreciable cost is the initial value minus salvage value. Often salvage value is zero. You just divide the depreciable cost by the number of periods in the depreciable life and then allot that number to each period.
Let's say you have a truck that costs $40,000 (A1). It's useful life is 10 years (A2). Let's assume no salvage value to keep it simple. Use A3 to calculate the depreciation per year:
Formula:Please Login or Register to view this content.
That is $4000 in this example.
Cells B1:B10 will be the remaining value after depreciation at the end of each year. So in B1, take the initial value and subtract the yearly depreciation:
Formula:Please Login or Register to view this content.
That will be $36,000.
Then in B2:
Formula:Please Login or Register to view this content.
That will be $32,000.
Now copy B2 down to B10. If you've done everything right B10 will be 0.
(There is also declining balance, double declining balance, sum of the year's digits, and units of production, but I'm not going to go there unless you tell me that's what you need to use.)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks