Useful calculator or Template in excel calculate easily all expense and costs with cash flow chart for cost return estimate against new sale or deduction of all miscellaneous, insurance and cost of equipment.

Operational Costs     

  • Cost of equipment
  • Fixed costs
  • Vehicle insurance
  • Driver pay
  • Miscellaneous
  • Maintenance
  • Depreciation
  • New sales
  • Profit per sale
  • Courier delivery charge
  • Number of deliveries
  • Sale of equipment
  • Interest rate

Here below you can compare expenses vs income with no of years


  • Terms in Years
  • Other Costs
  • Total
    Money Saves by Project


  • New Sales Generates by Project
  • Equipment Sales
  • Total
  • Cash Flow


Internal Rate of Return Calculator Excel

After calculating net cash flow you can get IRR using Formula “=IRR(I23:I33, 0.04)”. In 2nd sheet you can experience cash flow chart of IRR.

About The Author

Leave a Reply

Your email address will not be published. Required fields are marked *