Depreciation Methods Model
Product Description
This comprehensive application covers most Depreciation methods! Model is extremely easy to use and is capable of carrying out complex calculations. Just enter few inputs into the spreadsheet and select depreciation method of your liking. Model can calculate Depreciation Expense, Beginning and Ending Book Value Balances for EACH PERIOD, and can support: Straight Line, ANY DECLINING Balance, and SUM-of-the-YEARS Depreciation Methods.
That’s right! In addition to Straight Line and Sum-of-the-Years Methods, Application can accommodate: Double Declining, 2.5 Times (250%) Declining, Triple Declining, 3.5 Times (350%), and ANY OTHER DECLINING BALANCE METHOD (Yes Even 1000 Times Declining Balance). The Decline Factor (Decline Rate) that user can enter into the model can be both: an integer, and a decimal!
Application accommodates: Annual, Semiannual, Quarterly, and Monthly Depreciation Frequencies!
The model supports four different theme colors (Olive Green, Dark Blue, Black, and Dark Orange) for user convenience.
In rare cases model may detect “Circular Reference” issues. In such cases user will need to press the “Enable Iterations” button (This button is very visible in the model and should be pressed ONLY when Microsoft Excel detects Circular Reference). Special VBA Code attached to button will enable iterations and resolve all issues.
***NOTE: xlsm format requires MS Office 2007!
***NOTE: THIS IS A VBA PROJECT. PLEASE ENABLE MACROS BEFORE USING!!!
That’s right! In addition to Straight Line and Sum-of-the-Years Methods, Application can accommodate: Double Declining, 2.5 Times (250%) Declining, Triple Declining, 3.5 Times (350%), and ANY OTHER DECLINING BALANCE METHOD (Yes Even 1000 Times Declining Balance). The Decline Factor (Decline Rate) that user can enter into the model can be both: an integer, and a decimal!
Application accommodates: Annual, Semiannual, Quarterly, and Monthly Depreciation Frequencies!
The model supports four different theme colors (Olive Green, Dark Blue, Black, and Dark Orange) for user convenience.
In rare cases model may detect “Circular Reference” issues. In such cases user will need to press the “Enable Iterations” button (This button is very visible in the model and should be pressed ONLY when Microsoft Excel detects Circular Reference). Special VBA Code attached to button will enable iterations and resolve all issues.
***NOTE: xlsm format requires MS Office 2007!
***NOTE: THIS IS A VBA PROJECT. PLEASE ENABLE MACROS BEFORE USING!!!
Share Your Favorite Models on Other Social Networks:
= = = = = = = = = = =
Subscribe to Newsletter