Hello -
Enclosed is a model that captures Capital spend $s by quarter. I am trying to figure out a formula to extrapolate the associated depreciation by quarter based on how many months the asset is in use (either 3 or 5 years (12 quarters or 20 quarters).
Any input would be greatful! See the file below to fully understand.
Thanks,
Chris
Good morning ctsloan
...and welcome to the forum!!
As an accountant, I would recommend you invest in a piece of asset management software - even an off-the-shelf, cheap-as-chips jobby (or even freeware) would do better than Excel at this particular task. As good as Excel is at other things it is crap as an asset management tool, no matter how well designed the spreadsheet is - this coming from someone who is struggling to transfer a large asset register onto a dedicated system.
HTH
DominicB
Please familiarise yourself with the rules before posting. You can find them here.
Thanks for the info - I know that software is the way to go here - but this is an adhoc project and not enough time to buy software...I will look into some free-bies on the net though.
Thanks,
Chris
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks