Depreciation of assets - no. of yrs required Excel Kindly tell me whether there is any formula on. I want the year to be calculated until the value becomes $1 . The minimum depreciation during any year should be $1 i.e., if it happens that in any year the depreciation will be less $ 1 , the minimum depreciation to be provided would be $1 so as to reach balance asset value of $1 1. It will also show that after 46 years there will be less than $1 depreciation each year. Is this correct? And which figure are you trying to achieve? There is Create the following VBA function which I believe does what you want: Function Years(Value, Rate) Do Until Value < = 1 Value = Value - Value * Rate Y = Y + 1 Loop Years = Y End Function Using your numbers, if you entered 1000 Shane Devenshire Hi Balan, If you're a programmer then: Function Years(Value As Double, Rate As Double) As Integer Dim Y As Integer Do Until Value < = 1 Value = Value - Value

It's got nothing to do with Excel, it's the mathmatics of declining balance depreciation (or geometric progressions, if you want to generalize). Regards, Fred There are two issues to consider. The first issue is that declining-balance depreciation is determined by multiplying the remaining value (less salvage value) by a depreciation rate - - some percentage less than 100%. Thus, the remaining value after depreciation is the remaining value (less salvage value) times 1 minus the rate (1-r). Mathematically, such a formula will never reach zero. But in practical terms, the depreciation must be rounded at least to the penny. So in fact, eventually you can indeed moment. The second issue is that by default, the Excel DDB() function arbitrarily chooses a depreciation rate of 2 / life. So, for example, if the lifetime is 10 years, the depreciation

Depreciation DataBase We did a normal (monthly) depreciation procedure before we did our year end close and we realized that the depreciation amount was multiplied by 11 months some by 10 months e.g the monthy depreciation amount is 5.55 per asset but it increased to 61.05. Can someone help more than 12 periods in your fiscal year? I have seen some strange behavior in depreciation when you have 13 or more periods setup. Frank Hamelly MCP-GP, MCT, MVP East such a problem. . .What info do you require? I would want to see all the depreciation settings on one of the assets affected by this. If you would like, you can www.eastcoast-dynamics.com blog: www.gp2themax.blogspot.com Place in service - -> 2007 / 06 / 28 Depreciation to Date - -> 2009 / 06 / 30 Begin Year Cost - -> 3813.00 Cost Basis - -> 3813.00 Yearly depr. Rate - -> 659.0500 Current depr - -> 672.15 YTD Depreciation - -> 59.91 LTD Depreciation- -> 3213.86 Net

Returns the accrued interest for a security that pays interest at maturity AMORDEGRC Returns the depreciation for each accounting period by using a depreciation coefficient AMORLINC Returns the depreciation for each accounting period COUPDAYBS Returns the number of days from the beginning of the CUMPRINC Returns the cumulative principal paid on a loan between two periods DB Returns the depreciation of an asset for a specified period by using the fixed-declining balance method DDB Returns the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify DISC Returns the discount rate for a security DOLLARDE Converts a dollar price, expressed as a fraction, into a dollar annual duration of a security with periodic interest payments EFFECT Returns the effective annual interest rate FV Returns the future value of an investment FVSCHEDULE Returns the future value of an initial principal after applying a series of compound interest rates INTRATE Returns the interest rate for a fully invested security IPMT Returns the interest payment for an investment for a

Depreciation Table Formula Excel Dear Experts I am trying to create a depreciation table with the details mentioned below. I hope what I am trying to convey below is clear enough to understand. I have columns for Purchase Date, Cost, Rate, Year Days (Closing Date-Purchase Date, which should not be more than 365 or 366 days), Total Days (Closing Date-Purchase Date = Actual number of days), Opening Depreciation and Year's Depreciation. The method is Straight Line method and the rate is 20% per annum. So in 5 years an asset is fully depreciated. The Year's Depreciation is based on actual days from the date of purchase. So I request your help to write a formula based on the following situations. Case 1 If Opening Depreciation is equal to Cost, then the result in the Column Case 2 If Opening Depreciation