+ Reply to Thread
Results 1 to 7 of 7

Straight Line Formula based on exact date of purchase

  1. #1
    Registered User
    Join Date
    11-07-2012
    Location
    MN, USA
    MS-Off Ver
    Excel 2010
    Posts
    5

    Straight Line Formula based on exact date of purchase

    What formula would I use to calculate straight line depreciacion based on the exact day of purchase? I have attached an Excel Workbook that provides the Acquisition Date, Cost, Estimated life and salvage value. I am wanting to calculate the SL depreciation each year since purchase.
    Thanks in advance


    straight line depreciation.xlsx

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Straight Line Formula based on exact date of purchase

    I'm not sure what you want to achieve.

    I used pivot table to get this result.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    11-07-2012
    Location
    MN, USA
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Straight Line Formula based on exact date of purchase

    I am looking to have the following calculation on the actual spreadsheet. Under Column L, total amount of depreciation for each individual item in 2004. Ultimatly row 7 was purchased on 3/29/07, I am basically looking at calculating the total depreciation from that exact day for 2004, 2005, 2006..... This is straight line so ultimatly each day the item depreciates the same amount for 5 years straight having no value in the end.
    Thanks for your help.

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Straight Line Formula based on exact date of purchase

    I don't understand, maybe someone else have the solution for you.

  5. #5
    Registered User
    Join Date
    11-07-2012
    Location
    MN, USA
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Straight Line Formula based on exact date of purchase

    Maybe this makes more sense. If you see the attached,the blue is calculated by month, I am wanting to know how to do the same but by day (in red). So if I change the date by a couple days the formula would recalculate and I would get a different number for the first and last year of the depreciation period.

    STL Depr by Month.xls

  6. #6
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Straight Line Formula based on exact date of purchase

    The example makes it clear for me.

    Unfortunally, I have no solution for your problem.

  7. #7
    Registered User
    Join Date
    11-07-2012
    Location
    MN, USA
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Straight Line Formula based on exact date of purchase

    If anyone knows how to do this and thinks it would work by using a 360-day year, with 30 days allocated to each month, I would be happy with that.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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