+ Reply to Thread
Results 1 to 2 of 2

Calculating depreciation

  1. #1
    Registered User
    Join Date
    12-15-2020
    Location
    Malaysia
    MS-Off Ver
    2007
    Posts
    1

    Post Calculating depreciation

    Guys i need help to do Depreciation in VBA Excel.Im Clueless

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: VBA Applications

    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: copy to clipboard
    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: copy to clipboard
    Please Login or Register  to view this content.

    That will be $36,000.

    Then in B2:
    Formula: copy to clipboard
    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.)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Depreciation
    By Mahmoudelnemr in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-14-2019, 11:30 AM
  2. how to stop calculating depreciation using date
    By bbacaron in forum Excel General
    Replies: 1
    Last Post: 07-06-2018, 01:24 AM
  3. Straight Line Depreciation for Long Term Model of Depreciation
    By fornight in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-13-2017, 03:14 PM
  4. [SOLVED] Formulas to show all previous depreciation combined, and also current depreciation.
    By Morisk in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-20-2012, 09:05 AM
  5. calculating rest value by depreciation
    By Mx7733 in forum Excel General
    Replies: 1
    Last Post: 11-07-2008, 08:57 PM
  6. Calculating variable depreciation values
    By emacl in forum Excel General
    Replies: 1
    Last Post: 01-29-2008, 02:16 PM
  7. calculating depreciation
    By manda in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-18-2007, 11:24 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1