depreciation

Hello, this is my first time posting to this site and could really use some help with the below, as I have already spent a long time trying to figure out an appropriate formula. I am creating a waterfall schedule based off monthly expenses, and need to allocate the total monthly expense for a...

After days of researching I am at a loss. I need to work from a depreciation schedule of 10,000 assets. What I know is the date of purchase, asset, cost. I am valuing the assets as of 2012. I am an appraiser so I need to work a formula like this: a one year old computer would be worth 50% of...

Please help me with this question for Excel 2007 I am doing my business federal income taxes myself and I need help please on Federal Depreciation and AMT Depreciation. My past accountant set up a worksheet to automatically compute the depreciation on the assets. He used 150DBHY 5 or 7 years...

I am working on a household inventory spreadsheet. It contains; the item, age and life of the item, replacement cost, the depreciation of the item (age divided by life) and the actual cash value of the item. My problem is with the depreciation. I need to cap it at 75%, so if an item has...