# Cost Per Mile Calculator Excel or Spreadsheet Debt Payoff Calculator for Loan Repayment Excel formula

Spreadsheet Debt Payoff Calculator For Loan Repayment Excel Formula from cost per mile calculator excel, source:veoeyewear.com

Cost Per Mile Calculator Excel – calculating your cost per mile rigbooks calculating your cost per mile then do the same calculation as before for example let’s say you have just one truck or are just calculating your cpm for just one of your trucks and this past month you’ve spent \$3000 in fuel \$150 in tolls \$75 in supplies for the truck your truck payment is at \$1000 \$200 for food \$800 for insurance .

calculate your cost per mile – truckers & owner operators to calculate the “cost per mile ” divide the cost by the number of miles you drove that month for example “fixed costs per mile” is calculated by dividing \$2515 fixed costs by 8 400 miles which gives us \$0 30 per mile using the same method we calculate variable costs to be \$0 70 cost per mile spreadsheet owner operator independent cost per mile spreadsheet the third column is the result of dividing the annual costs by the number of miles run in the year for our example we are assuming the truck was driven for 100 000 miles so since the annual mortgage payments on the truck were 16 000 we divide 16 000 by the 100 000 miles and we find the cost of the truck mortgage in \$0 16 cents per mile figuring cost per mile owner operator independent drivers the final \$0 69 per mile cost for 130 000 miles represents a vehicle cost of \$89 000 and a "driver in e