View attachment 30020
The app I had customized (Access) has a great number of forms used to enter the $ forecasts which generate this report.
- purchase price, financing cost (options for term, down, interest), lifespan (I choose 10 years on trucks, 7 years on chippers), it calculates residual based on depreciation rates you choose
- if you choose an ROI factor of 1, you pay for the unit. If you choose and ROI factor of 2 you pay for the unit and have cash at the end of term to outright buy the second
- the only players that win with an ROI factor of 1 is the bank as they perpetually garner interest
I budget for worst case scenario, then find ways to save.
In being aware of my numbers in this detail (App also budgets EVERYTHING else and helps me determine hourly, daily, weekly breakeven and % profit) I have been able to be more competitive when work is lean. I know what breakeven is. Hanging out here in Jan/Feb helps seize more of a small supply of available work and keep key staff in paycheques. And when workload is plentiful I can clearly identify profit % in this period and average how that will impact the 12 month period overall.
Overall awareness of numbers allows you to pay staff better, keep and maintain a late model fleet, and make sure shareholders are adequately compensated for their sacrifice.