Video Tutorial:
This model has two main parts. Part 1 allows you to display up to 30 years’ worth of depreciation happening with up to 95 different fixed assets at once. The monthly and annual display will show the depreciation and book value over time.
Your inputs will be the useful life, salvage value, purchase price, and date of purchase.
The second part of this model is a comparative tool that spans 15 years and will show you the difference in annual and monthly depreciation when using a double-declining balance vs. a straight line. This is designed for just a single asset and there are two visuals that come along with this.
Similar Products
Other customers were also interested in...
All My Financial Models, Spreadsheets, Templates, ...
Lifetime access to all future templates as well! Here is a set of spreadsheets that have some of the... Read more
Franchisor Licensing: Financial Model with Cap Tab...
Build up to a 10 year financial forecast with assumptions directly related to the startup and operat... Read more
Small Business Playbook (Financial / Tracking Temp...
About the Template Bundle: https://youtu.be/FPj9x-Ahajs These templates were built with the ... Read more
Top 16 Google Sheet Templates
This is a bundle of all the most useful and efficient google sheet templates I have built over the y... Read more
Joint Venture and Fund Cash Flow Waterfall Templat...
Here are all the spreadsheets I've built that involve cash flow distributions between GP/LP. Include... Read more
Preferred Equity Cash Distribution Model – 2...
A 10-year joint venture model to plan out various scenarios for the way cash is shared between a GP ... Read more
Cumulative LP Distribution Joint Venture Waterfall...
A 6 Tier cash flow waterfall template. Plug in the distributable cash flow (+/-) and set the hurdle ... Read more
Inventory Valuation Using FIFO – Automatical...
Any accountant that needs to comply with IFRS will have to use the FIFO valuation method for calcula... Read more
Private Equity Fund Model (Investor Cashflows)
Private Equity Financial Model to analyze fund cashflows and returns available to Limited Partners (... Read more
Advanced Financial Model with DCF & Valuation
New Version Updates:• Model is now dynamic. Users can select the desired forecast length for up to... Read more
You must log in to submit a review.