I am looking to figure the depreciation schedule on an asset over various years and different percentage rates but I need it to stop "figuring" at a certain year i.e. 5 years.
Original cost: 5,000.
depr %: 20%
Total Time to depreciate over: 5 Years
Purchase date: 11/15/2014 - Current date= age 12 months
How can I get real time book value?