Fixed Asset/Depreciation formula

  • Thread starter Thread starter GregR
  • Start date Start date
G

GregR

I am looking for a formula that will calculate the PV of a fixed asset
less accumulated depriciation at a given time. Example: I know the
following

Aquisition Cost: 100,000
Aquistion date: 3/24/2004
Monthly depreciation expense: 4500
PV at 12/31/2006: ?

TIA

Greg
 
Hi Greg

Take a look at all the financial functions in the Add-in
analysis tool pack ...

HTH
Cheers
Carim
 
To find the number of full months between two dates you can use a formula
like this:

=DATEDIF(AcqDate,CurrDate,"m")

So you could multiply that by the monthly depreciation. It gets more
complicated if you're not using straight line depreciation, but you are<g>.

--
Jim
|I am looking for a formula that will calculate the PV of a fixed asset
| less accumulated depriciation at a given time. Example: I know the
| following
|
| Aquisition Cost: 100,000
| Aquistion date: 3/24/2004
| Monthly depreciation expense: 4500
| PV at 12/31/2006: ?
|
| TIA
|
| Greg
|
 
Jim, we are using straight line depreciation and the formula you
suggested I used, but it is short 1 month. For example in the above
example the datedif is 33 months and the result I expected was 34
months, actually counting March 04 as an actual month. TIA

Greg
 
I guess you have to add 1 to my formula. I know you can do that<g>.

--
Jim
| Jim, we are using straight line depreciation and the formula you
| suggested I used, but it is short 1 month. For example in the above
| example the datedif is 33 months and the result I expected was 34
| months, actually counting March 04 as an actual month. TIA
|
| Greg
|
 
Back
Top