Construction, Equipment Rental, Financial Model

10-year Financial Projections, 5-year Financial Projections, Business Valuation, Cash Flow Analysis, Cash Flow Projections, CFO, Controlling, DCF Model, Excel, Financial Analysis, Financial Feasibility, Financial Model, Financial Planning, Financial Projections, Financial Reporting, Financial Statements, Forecast, Forecasting, Income Statement, Investment Multiple, Investor Cash Flows, Investors, IRR (Internal Rate of Return), NPV (Net Present Value), Pro-Forma, Rental Income, Revenue Projections, Sensitivity Analysis, Startup Financial Models, Three Statement Model | Three Financial Statements

 

Video Tutorial:

Latest Update on 10-Year Comprehensive Model: Added formal monthly and annual financial statements (Income Statement, Balance Sheet, Cash Flow Statement), a formal cap table, distribution summary, startup cost schedule, exit assumptions if applicable, and general formatting convention updates.

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. This model was recently upgraded to include a fully integrated monthly and annual 3-statement model (Income Statement, Balance Sheet, and Cash Flow Statement) and cap table.