Lease Purchase Calculator
The best time to know if a Lease-Purchase contract will be profitable for you is before you sign it. The same is true if the contract is so flawed that there is no way on earth you can buy that truck and make a living at the same time. You don’t want to come to that realization six months down the road when you find yourself under emergency financial stress.
This simple calculator has a place for every variable that goes into a small trucking business’s cash flow analysis. Note that as you put in your variables, the bottom line of whether you are making or losing money changes. After you put in the figures that reflects what you think you will do in the coming year, (not what the recruiter blows smoke about) do some additional calculations. Change the miles to a lower and then a higher number and see how mileage affects the bottom line. Then go back to your original best estimate of miles and do some “If/Then” calculations on diesel fuel prices. Put in the highest figure you have ever seen on a fuel pump. Put in the figure between today’s price and the highest price you have seen. Note how little diesel price fluctuations have to be to make thousands of dollars difference in the bottom line. Because fuel is your single biggest cost, go back and check the lease’s handling of fuel surcharges. If there is no fuel surcharge in place, you can easily see with this calculator how a simple hic-up in the fuel price can take you from being a profitable trucker to being a bankrupt trucker in short order.
INSTRUCTIONS: Open with Microsoft® Excel or online via ZOHO Sheet. Then, simply enter your data into the yellow colored fields, and our calculator will formulate your net income with a lease-purchase contract.
Note: All figures currently shown are examples designed to demonstrate the uses of the calculator, try altering the numbers to see what will be generated.