Depreciation Schedule help!

[IrishHawg09]

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!!!

 

[IrishHawg09]

Sorry, one other thing. We are needing this as granular as on a monthly basis.

Thanks!

 

[IrishHawg09]

Bumpity bump!