Total Cost of Ownership for Cars

I created a spreadsheet to compare the total cost of ownership between different cars.

To view, download, and edit the spreadsheet at Google Spreadsheets: http://spreadsheets.google.com/ccc?key=pCRoTBbGNNnWWlB6TDkmQDw

It basically concludes that hybrids still aren't worth the price. But at least it's still a good statement. Just an expensive statement.

Total Cost of Ownership for Cars:

TCO Summary 2006 Prius Civic Hybrid TDI Civic LX Honda Fit 99 Ford Escort 2003 Jetta 2004 Prius Salv 2004 Civic 35k Base price $26,000.00 $22,000.00 $16,091.00 $17,000.00 $15,700.00 $5,000.00 $8,000.00 $22,988.00 $9,555.00 Sales Tax $2,145.00 $1,815.00 $1,327.51 $1,402.50 $1,295.25 $412.50 $660.00 $1,896.51 $788.29 Tax + Base $28,145.00 $23,815.00 $17,418.51 $18,402.50 $16,995.25 $5,412.50 $8,660.00 $24,884.51 $10,343.29 Annual fuel cost $1,764.71 $2,250.00 $2,045.45 $2,571.43 $2,727.27 $3,103.45 $3,103.45 $1,764.71 $2,812.50 Monthly insurance $60.00 $60.00 $60.00 $60.00 $60.00 $60.00 $60.00 $60.00 $60.00 Monthly loan payment* $484.72 $410.15 $299.98 $316.93 $292.70 $93.22 $149.14 $428.57 $178.13 Monthly fuel cost $147.06 $187.50 $170.45 $214.29 $227.27 $258.62 $258.62 $147.06 $234.38 Total Monthly $691.78 $657.65 $530.44 $591.22 $579.97 $411.84 $467.76 $635.62 $472.51 Loan variables Interest rate 4.50% 4.50% 4.50% 4.50% 4.50% 4.50% 4.50% 4.50% 4.50% Loan period in years 5 5 5 5 5 5 5 5 5 # payments per year 12 12 12 12 12 12 12 12 12 Fuel Variables $USD/gallon $4.50 $4.50 $4.50 $4.50 $4.50 $4.50 $4.50 $4.50 $4.50 Miles/year 20000.00 20000.00 20000.00 20000.00 20000.00 20000.00 20000.00 20000.00 20000.00 Miles/gallon 51.00 40.00 44.00 35.00 33.00 29.00 29.00 51.00 32.00

Tax Variables Sales tax rate 8.25% 8.25% 8.25% 8.25% 8.25% 8.25% 8.25% 8.25% 8.25% 8.25% 8.25% Insurance Variables * Assumes tax is paid out of pocket and 100% of car is financed

published via Google Docs & Spreadsheets

Edit this page (if you have permission)