Depreciation Formula

[Guest]

I have setup a spreadsheet to calculat depreciation for a number of assets
using the straight line method. The calculation for a full month's
depreciation is very straightforward but was wondering what is the best way
to calculate the partial deprecation for an asset that was put in place in
the middle of the month. For example, in column B is the date that an asset
was acquired. If the acquisition date is 6/7/2006 is there a means to create
a formula that will recognize that the month of June has 30 days and the
depreciation should be 7/30 of the full amount?

Also, what is the most accurate way to get the month and year that a
specific asset reaches it's useful life. For example, if an asset was
acquired on 6/7/2006 and it expires in 10 years what is the easiest way to
simply add 120 months to the date of 6/7/2006?


Thank you very much in advance for your assistance.

 

[Sandy Mann]

a formula that will recognize that the month of June has 30 days and the
depreciation should be 7/30 of the full amount?

With the acquired date in H10 try:
=DAY(H10)/DAY(DATE(YEAR(H10),MONTH(H10)+1,0))
to give 7/30

acquired on 6/7/2006 and it expires in 10 years what is the easiest way to
simply add 120 months to the date of 6/7/2006?

To add 10 years use:
=DATE(YEAR(H10)+10,MONTH(H10),DAY(H10))

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk