Equipment Rental - 10 Year Cash Flow Excel Model
  • Equipment Rental - 10 Year Cash Flow Excel Model
  • Equipment Rental - 10 Year Cash Flow Excel Model
  • Equipment Rental - 10 Year Cash Flow Excel Model
  • Equipment Rental - 10 Year Cash Flow Excel Model
  • Equipment Rental - 10 Year Cash Flow Excel Model
  • Equipment Rental - 10 Year Cash Flow Excel Model
  • Equipment Rental - 10 Year Cash Flow Excel Model
  • Equipment Rental - 10 Year Cash Flow Excel Model
  • Equipment Rental - 10 Year Cash Flow Excel Model
  • Equipment Rental - 10 Year Cash Flow Excel Model
Originally published: 04/03/2018 09:08
Last version published: 12/10/2018 09:58
Publication number: ELQ-71003-8
View all versions & Certificate
certified

Equipment Rental - 10 Year Cash Flow Excel Model

The Equipment Rental business is a cash flow business. This bottom up forecast will help you craft scenarios.

cash flow forecastequipment rentalfinancial forecasting

Description
The model is not designed for a traditional P&L look. Instead, it looks at cash flows and the timing of those cash flows. The main areas that you can change variables in will include:

1. Up to 4 loans.
2. Up to 100 equipment types
3. Average amount of days utilized per month per equipment type on a per year basis
4. The start/end month of a given equipment type
5. Expected salvage values per equipment type
6. Revenue per day per equipment type
7. Running costs by year (including variable %'s relative to total value of active equipment)

All of those inputs come together in a monthly and annual cash flow forecast that lets you see how your cash position would do given various assumptions of cash in/out activity over time.

Examples of logic include the reduction of cash if an item is to be purchased in a given month and the cash receipt of anything marked with a salvage value at its determined end month.

There are many charts that will show various metrics such as cash position relative to debt position, rental income to running costs, and your running asset value (non-depreciated).

The current data in this model is in there so you can get a feel for what moves what as well as force you to look at each of the various assumptions and how it effects the cash flow. This will help with final ability to craft your scenario the way you want.

This business tool includes
1 Excel template and 1 Tutorial video

Acquire business license for $45.00

Add to cart

Add to bookmarks

Discuss

Further information

Plan out cash flows from renting equipment over 10 years.

Rental equipment business.

Non-rental revenues.

Reviews

  • No review yet!

keyboard_arrow_leftkeyboard_arrow_right

More tools from Jason Varner

See all
keyboard_arrow_leftkeyboard_arrow_right

Any questions on Equipment Rental - 10 Year Cash Flow Excel Model?

The user community and author are here to help. Go ahead!

please wait...