Results 1 to 3 of 3

Depreciation

Threaded View

  1. #1
    Forum Contributor
    Join Date
    05-14-2019
    Location
    Alex, Egypt
    MS-Off Ver
    365
    Posts
    254

    Depreciation

    How to stop depreciation after its fully depreciation?
    Plz check attachement
    The useful life is 26 periiods
    First column is the truck id, i want to depreciate the tire price over 26 months
    The formula works but it continue to add depreciation cost even after 26 periods
    Attached Files Attached Files
    Last edited by Mahmoudelnemr; 05-14-2019 at 09:53 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. 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
  2. [SOLVED] Depreciation
    By domnicmifsud in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-21-2014, 06:40 AM
  3. [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
  4. Depreciation
    By scallywag1000 in forum Excel General
    Replies: 5
    Last Post: 01-31-2011, 03:23 AM
  5. Depreciation formula
    By Cidona in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 08-24-2010, 11:15 AM
  6. Depreciation formula ?
    By leapinlizard in forum Excel General
    Replies: 3
    Last Post: 03-03-2007, 03:58 AM
  7. UDF for Depreciation
    By odysseyoflife in forum Excel General
    Replies: 0
    Last Post: 06-12-2006, 12:38 PM

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