Depreciation Schedule help!

IrishHawg09

New Member
Joined
Sep 9, 2014
Messages
16
Hello,

I'm completing a financial model, and am running into some issues with correctly calculating our depreciation schedule, due to the fact that we have two fixed assets that will be replaced after a certain period of time. My issue is, I can't figure out how to effectively depreciate one asset (a laptop) to $0.00, while also effectively depreciating a second laptop, and a third, etc.

https://app.box.com/s/ua9w9vaaijeuno3fu4oi

Above is a copy of the data I'm using.

Any suggestions on certain formulas, or even different methods than what I'm currently attempting?

Thanks!!!
 

Some videos you may like

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Watch MrExcel Video

Forum statistics

Threads
1,108,969
Messages
5,525,960
Members
409,673
Latest member
Riseee

This Week's Hot Topics

Top