View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GregR GregR is offline
external usenet poster
 
Posts: 246
Default Fixed Asset/Depreciation formula

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