|Construction, Equipment Rental, Financial Model|
|Cash Flow Analysis, Cash Flow Projections, Excel, Financial Feasibility, Financial Projections, Rental income|
Update: Added logic to account for the frequency that a given piece of equipment gets rented out and returned as well as tied a cost to each occurrence.
**Note, both the original and modified version have been upgraded to show a DCF analysis and executive summary. The modified version has additional inputs for investor funding, startup costs, and one-time future expenditures that may fall outside of regular operating expenses. Also, the modified version only goes out for a period of 5 years and it allows for utilization to be adjusted on a quarterly basis rather than an annual basis.
The financial forecast is for a 10 year period.
If you are looking to get into the equipment rental business, you will want to plan out what kind of equipment you want to buy, when you want to buy it, and how much you want to rent it out for. You may also want to factor in the equipment being used up and discontinued/salvaged (with a salvage value you want to account for).
You will also need to know how much financing the business can support, how much cash you may need to put into the business (how long the rental cash flows will take to pay you back), and how much debt to cash you have over time.
All of those factors have been taken into account and applied to this super intuitive model. You can even pick by year how many days on average each piece of equipment will project to be used per month.
The total equipment pieces supported is 100, but that can easily be changed to 1,000 or more with little effort.
Video Overview of Version 2:
VERSION 2: This is a completely different model with new revenue assumptions and more advanced logic. It also includes depreciation calculations that are automatically based on purchase schedule and defined useful life. It drives down to EBT and Net Income after Taxes as well.