+ Reply to Thread
Results 1 to 1 of 1

Straight line YTD depreciation using posting and reporting dates

Hybrid View

  1. #1
    Registered User
    Join Date
    02-11-2020
    Location
    London, England
    MS-Off Ver
    2017
    Posts
    1

    Straight line YTD depreciation using posting and reporting dates

    Good day

    I need assistance in calculating YTD depreciation (R9) using the following factors:

    * Posting date (C9)
    * Useful life (I9)
    * Closing balance (N9) - Total cost of item
    * Date of report (E5)

    The first month the item will have 0 depreciation, and if possible, could depreciation stop calculating when the Net Book Value reaches 0.

    Your assistance will be much appreciated.

    Thank you
    Bianca
    Attached Files Attached Files

+ 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. 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. How to use the IF Function in Straight Line Depreciation
    By tobbyexcel in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-07-2015, 06:54 PM
  3. Excel 2007 : Straight line depreciation
    By Simmi7 in forum Excel General
    Replies: 7
    Last Post: 10-10-2014, 08:45 PM
  4. Depreciation Straight line Calculation based on start and end date
    By anjoseph9626 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-03-2013, 04:44 PM
  5. Straight Line Depreciation Calculation
    By andrew8008 in forum Excel General
    Replies: 4
    Last Post: 11-07-2012, 04:29 PM
  6. Straight Line Depreciation using the IF Function (Excel '03)
    By L_haynes in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-09-2010, 03:34 AM
  7. SLN - Straight Line Depreciation
    By tr2yhb@yahoo.com in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-06-2005, 10:05 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