Straight Lind Deprec Calc + HELP!

January 05th, 2009 edit

  • I have the following table on which I'm trying to create the Straight Line Depreciation from the Capitalization Date. I've got the first year portion correct and subsequebnt years. The trouble I'm having is that the calculation won't stop from the orifginal Capex Date plus Sal.vage years.

    You can see below that S2 is correct and so is T&U2 but V2 should only be a portion of the 3yr Asset Life.

    Please somebody show me where I'm going wrong:-

    Microsoft Excel - God's Son's FILE (do not modify).xls___Running: xl2002 XP : OS = Windows XP
    (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
    =

    J
    K
    L
    M
    N
    O
    P
    Q
    R
    S
    T
    U
    V
    W
    X
    Y
    1
    		Cap. DateTextAcquisition CostNBVPO NoMatchAsset LifeDepreciation 200420052006200720082009Current NBV
    2
    		27/07/2004292889-421 ProLiant DL360 (G3) R02 Xeon DP 2.8GHz, 512MB2,216.50 
    		3  295.53443.30443.30443.30443.30443.301147.24
    3
    		27/07/2004292889-421 ProLiant DL360 (G3) R02 Xeon DP 2.8GHz, 512MB2,216.50 
    		3         
    4
    		27/07/2004292889-421 ProLiant DL360 (G3) R02 Xeon DP 2.8GHz, 512MB2,216.50 
    		3         
    5
    		27/07/2004292889-421 ProLiant DL360 (G3) R02 Xeon DP 2.8GHz, 512MB2,216.50 
    		3         
    6
    		27/07/2004292889-421 ProLiant DL360 (G3) R02 Xeon DP 2.8GHz, 512MB2,216.50 
    		3         
    7
    		16/07/2004WS-C3550-48-EMI 48-10/100 + 2 GBIC ports: EMI2,697.003         
    8
    		27/07/2004292889-421 ProLiant DL360 (G3) R02 Xeon DP 2.8GHz, 512MB2,697.38 
    		3         
    9
    		26/07/2004325134-421 ProLiant DL580 (G2) R02  Xeon 13,555.00 
    		3         
    10
    		26/07/2004FAS960C-IB-BASE 2 FAS960, CFO, IB, DATA ONTAP38960.64 
    		3         
    11
    		30/07/20047038-6M2 Rack Server 1:pSeries 650 Model 6M2 CEC95,436.62 
    		5         
    12
    		30/07/20047038-6M2 Rack Server 1:pSeries 650 Model 6M2 CEC95,436.62 
    		5         
    13
    		30/07/20047038-6M2 Rack Server 1:pSeries 650 Model 6M2 CEC95,436.62 
    		5         
    14
    		30/07/20047038-6M2 Rack Server 1:pSeries 650 Model 6M2 CEC95,436.62 
    		5         
    BP2I New Assets 

    [HtmlMaker 2.42] To see the formula in the cells just click on the cells hyperlink or click the Name box
    PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.


  • Howdy, and welcome to the board.

    Can you post an actual sample spreadsheet? you have references outside what is posted.


  • Can you post an actual sample spreadsheet?

    I thought that is what I done.

    I'm trying to get the formulas to work in S2:X2.

    I've posted the spreadsheet using HTML Maker, can u see it?







    • #If you have any other info about this subject , Please add it free.#
    Your name:
    E-mail:
    Telphone:

    Your comments:


    If you have any other info about Straight Lind Deprec Calc + HELP! , Please add it free.