The Car Cost Calculator - New Car vs. Old can be used to estimate the cost of ownership for a newer car vs. an older car - or a the cost of ownership for a more expensive car vs. a cheaper car.
The calculator can be helpful to
- decide when to replace an old car
- decide between different cars
- decide between buying or leasing a car
The default calculator is set up for a 3 years period but can be easily extended by copying cells as described below.
To use the Car Cost Calculator - New Car vs. Old - open the Car Cost Calculator - New Car vs. Old - save a copy of the spread sheet to your own Google Docs account (you need to be logged into your google account) - or download the spread sheet as an excel file to your computer.
Modify the values:
- add estimated sales value for the old car and the buying cost for the new one. If leasing is an alternative - set the Value to zero - add leasing signing costs in year 1 and yearly leasing costs for every year.
- add depreciation when you own the car - depreciation varies with car make, model and age. Typical values in range 10-20% per year.
- add financing costs. When savings are used interest is lost and should be handled as a cost.
- add insurance costs
- add road taxes
- add expected mileage and fuel costs
- add service costs
- add regular maintenance costs - like tires, brake pads ..
- add unexpected repair costs
- add other costs - like supplementary equipment typically needed for a new car
Extend the calculator with more years by inserting new columns and copying the equations. Unlimited numbers of cars can be added.
The calculator can also be used to compare other similar investments like machinery and more.
Engineering economics - cash flow diagrams, present value, discount rates, internal rates of return - IRR, income taxes, inflation.
Maximum wire lengths vs. currents in the 12 volt electrical system of a car.
Converting between units of acceleration.
Power, torque, efficiency and wheel force acting on a car.
Adhesion and tractive force between car wheel and surface.
Car acceleration calculator.
Calculate fuel consumption in liter per km - consumption chart and calculator.
Forces due to circular motion and centripetal / centrifugal acceleration.
Calculator for CO2 emissions from different kind of cars (gasoline, diesel, LPG, electrical), comparing with alternative forms of transportation (as airplane, bus and train).
The drag coefficient quantifies the drag or resistance of an object in a fluid environment.
Driving distance between some major European cities.
Calculate fuel consumption in miles per gallon - mpg - calculator and consumption charts.
Exhaust ventilation from garages and workshops.
Impact forces acting on falling objects hitting the ground, cars crashing and similar cases.
Cylinder volume and compression ratios in piston engines.
Calculate piston engine displacement.
Rolling friction and rolling resistance.
Speed (km/h) vs. time (hours) and distance traveled (km).
Traffic flow and density as used in highway design.