Go Back   EcoModder Forum > EcoModding > General Efficiency Discussion
Register Now
 Register Now
 

Reply  Post New Thread
 
Submit Tools LinkBack Thread Tools
Old 09-18-2014, 10:13 PM   #1 (permalink)
Spaced out...
 
spacemanspif's Avatar
 
Join Date: Jul 2013
Location: Dirty Jersey
Posts: 748

The New Focus - '07 Ford Focus ZX5
90 day: 32.44 mpg (US)
Thanks: 142
Thanked 204 Times in 148 Posts
Cost to own spreadsheet?

Who uses a cost to own spreadsheet for their vehicles? I'm looking to use one for my new-to-me Focus and would rather benefit from someones else's efforts than fight the same fight myself. I'm looking to track total cost i.e. purchase cost, insurance, maintenance and fuel. I know it should be easy using columns for date, odometer and cost but what has me hung up is the ever evolving price/mile formula. If you want to help a slacker, please post up your spreadsheets. I swear I've seen a few on here before but I can't seem to find them right now...

Thanks,

__________________
-Mike

2007 Ford Focus ZX5 - 91k - SGII, pending upper and lower grill bocks - auto trans
1987 Monte Carlo SS - 5.3/4L80E swap - 13.67 @ 106
2007 Ford Focus Estate - 230k - 33mpg - Retired 4/2018
1995 Saturn SL2 - 256K miles - 44mpg - Retired 9/2014

Cost to Operate Spreadsheet for "The New Focus"

  Reply With Quote
Alt Today
Popular topics

Other popular topics in this forum...

   
Old 09-19-2014, 12:42 AM   #2 (permalink)
herp derp Apprentice
 
Join Date: Oct 2008
Location: Lawrence, KS
Posts: 1,049

Saturn-sold - '99 saturn sc1
Team Saturn
90 day: 28.28 mpg (US)

Yukon - '03 GMC Yukon Denali
90 day: 13.74 mpg (US)
Thanks: 43
Thanked 331 Times in 233 Posts
Estimate depreciation instead of using purchase price
I don't worry about tracking it myself, just try to keep making cost effective decisions along the way
  Reply With Quote
Old 09-19-2014, 07:53 AM   #3 (permalink)
Spaced out...
 
spacemanspif's Avatar
 
Join Date: Jul 2013
Location: Dirty Jersey
Posts: 748

The New Focus - '07 Ford Focus ZX5
90 day: 32.44 mpg (US)
Thanks: 142
Thanked 204 Times in 148 Posts
I picked up the car for almost nothing so depreciation doesn't really bother me. I like the cost per mile feature on the fuel logs here but I want to track total cost of ownership. I think I may have come up with the formula but am not really sure it works properly and I'd like to see other aspects people add to their own sheets that I am probably overlooking.
__________________
-Mike

2007 Ford Focus ZX5 - 91k - SGII, pending upper and lower grill bocks - auto trans
1987 Monte Carlo SS - 5.3/4L80E swap - 13.67 @ 106
2007 Ford Focus Estate - 230k - 33mpg - Retired 4/2018
1995 Saturn SL2 - 256K miles - 44mpg - Retired 9/2014

Cost to Operate Spreadsheet for "The New Focus"

  Reply With Quote
Old 09-19-2014, 08:41 AM   #4 (permalink)
Administrator
 
Daox's Avatar
 
Join Date: Dec 2007
Location: Germantown, WI
Posts: 11,180

CM400E - '81 Honda CM400E
90 day: 51.49 mpg (US)

Daox's Grey Prius - '04 Toyota Prius
Team Toyota
90 day: 49.53 mpg (US)

Daox's Insight - '00 Honda Insight
90 day: 64.33 mpg (US)

Swarthy - '14 Mitsubishi Mirage DE
Mitsubishi
90 day: 56.69 mpg (US)
Thanks: 2,479
Thanked 2,546 Times in 1,536 Posts
I don't really keep track of a total cost either. I have my fuel log here, and I keep a maintenance spreadsheet on my cars so I know what was done when.
__________________
Current project: A better alternator delete
  Reply With Quote
Old 09-19-2014, 09:16 AM   #5 (permalink)
Rat Racer
 
Fat Charlie's Avatar
 
Join Date: May 2011
Location: Route 16
Posts: 4,150

Al the Third, year four - '13 Honda Fit Base
Team Honda
90 day: 42.9 mpg (US)
Thanks: 1,784
Thanked 1,919 Times in 1,246 Posts
Depreciation?

The entire purchase price is "depreciation!" When I decide to get rid of a car I'll get something for it, but how much I'll recover in the sale isn't a factor in which car I buy. The purchase price is spent money, depreciated away on the spot.
__________________

Quote:
Originally Posted by sheepdog44 View Post
Transmission type Efficiency
Manual neutral engine off.100% @MPG <----- Fun Fact.
Manual 1:1 gear ratio .......98%
CVT belt ............................88%
Automatic .........................86%

  Reply With Quote
The Following User Says Thank You to Fat Charlie For This Useful Post:
ksa8907 (09-20-2014)
Old 09-19-2014, 10:20 AM   #6 (permalink)
herp derp Apprentice
 
Join Date: Oct 2008
Location: Lawrence, KS
Posts: 1,049

Saturn-sold - '99 saturn sc1
Team Saturn
90 day: 28.28 mpg (US)

Yukon - '03 GMC Yukon Denali
90 day: 13.74 mpg (US)
Thanks: 43
Thanked 331 Times in 233 Posts
Depreciation isn't really a factor to me, if I used it vs purchase price of my saturn, it would affect my cost per mile by less than $0.01 / mile at this point. If you bought a $10k car a month ago, drove it 1k miles, and wanted to figure total cost per mile, after one month It would be figuring $10/mi from the purchase price alone. After a year or 2 that affect would be reduced but still there. I thought the point of figuring cost per mile was to help determine when switching to a different vehicle would become cost effective, if you figured in the whole purchase price right away, it would never make sense to buy a newer car that cost anymore than a current required repair on your current vehicle
  Reply With Quote
The Following User Says Thank You to 2000mc For This Useful Post:
bobdbilder (09-19-2014)
Old 09-19-2014, 11:42 AM   #7 (permalink)
Rat Racer
 
Fat Charlie's Avatar
 
Join Date: May 2011
Location: Route 16
Posts: 4,150

Al the Third, year four - '13 Honda Fit Base
Team Honda
90 day: 42.9 mpg (US)
Thanks: 1,784
Thanked 1,919 Times in 1,246 Posts
Quote:
Originally Posted by 2000mc View Post
I thought the point of figuring cost per mile was to help determine when switching to a different vehicle would become cost effective, if you figured in the whole purchase price right away, it would never make sense to buy a newer car that cost anymore than a current required repair on your current vehicle
I'm not spending the whole purchase price right away, and I buy a car estimating I'm going to get in the neighborhood of 200k miles out of it.
Quote:
Originally Posted by Fat Charlie View Post
...in 6 months and 12k miles, I've spent $2682 on payments and gas for the Honda. That's $232 less than the Xterra at its EPA rating would have cost me in gas alone.

...measuring the Honda against what I was managing to eke out of the Xterra puts me $369 behind (but a lot more relaxed, in a reliable and legal car).
So while over six months I'm behind somewhat, I couldn't have made the last car legal, reliable, etc. for anywhere near the few hundred I'm "behind." I also wouldn't have the long time window of not needing repairs. That's money very well spent, regardless of how much I wind up selling the car for- I'm using it.
__________________

Quote:
Originally Posted by sheepdog44 View Post
Transmission type Efficiency
Manual neutral engine off.100% @MPG <----- Fun Fact.
Manual 1:1 gear ratio .......98%
CVT belt ............................88%
Automatic .........................86%

  Reply With Quote
Old 09-19-2014, 01:43 PM   #8 (permalink)
Master EcoModder
 
cowmeat's Avatar
 
Join Date: Jan 2014
Location: Lakeland Florida
Posts: 1,643

Princess Carriage - '20 Ford Explorer Limited

Silver - '22 Ford Maverick Hybrid XLT w/tow pkg
Maverick Hybrids
90 day: 39.9 mpg (US)
Thanks: 126
Thanked 746 Times in 452 Posts
The last time I did the math on cost of ownership on the Black Widow (about six months ago) came in right at 17 cents a mile.
That included the price of the car, tag renewals, car parts, tires, insurance, and all the gas, divided by the total miles driven (about 20,000 miles at that time).
__________________

  Reply With Quote
Old 09-19-2014, 02:08 PM   #9 (permalink)
Spaced out...
 
spacemanspif's Avatar
 
Join Date: Jul 2013
Location: Dirty Jersey
Posts: 748

The New Focus - '07 Ford Focus ZX5
90 day: 32.44 mpg (US)
Thanks: 142
Thanked 204 Times in 148 Posts
Quote:
Originally Posted by cowmeat View Post
The last time I did the math on cost of ownership on the Black Widow (about six months ago) came in right at 17 cents a mile.
That included the price of the car, tag renewals, car parts, tires, insurance, and all the gas, divided by the total miles driven (about 20,000 miles at that time).
That's the kind of thing I'm looking for. I'm guessing you track it on a spread sheet? Would you car to share it? Basically I want to track every dollar I spend on the car to see what has been sunk into it and see how much the car is costing me per mile driven.
__________________
-Mike

2007 Ford Focus ZX5 - 91k - SGII, pending upper and lower grill bocks - auto trans
1987 Monte Carlo SS - 5.3/4L80E swap - 13.67 @ 106
2007 Ford Focus Estate - 230k - 33mpg - Retired 4/2018
1995 Saturn SL2 - 256K miles - 44mpg - Retired 9/2014

Cost to Operate Spreadsheet for "The New Focus"

  Reply With Quote
Old 09-20-2014, 10:02 AM   #10 (permalink)
Master EcoModder
 
cowmeat's Avatar
 
Join Date: Jan 2014
Location: Lakeland Florida
Posts: 1,643

Princess Carriage - '20 Ford Explorer Limited

Silver - '22 Ford Maverick Hybrid XLT w/tow pkg
Maverick Hybrids
90 day: 39.9 mpg (US)
Thanks: 126
Thanked 746 Times in 452 Posts
I created a really simple one just for you, spif!

Rock on with it, and let me know if it needs any tweaking!

Warning: If you add the "original outlay" column and immediately start to cry, switch to the "feel good" version (just don't add the original cost of the car, tags, title, etc. . . .in that column)
That will give you more of a feel for what it's costing you per mile, minus the original shell-out

I like having the original outlay included, because the cost per mile drops dramatically with every tank. ***Note that I didn't add a "payments" column.*** If anybody really wants me to, I'll drop that column in, but I didn't want to upset everybody with the spreadsheet!
True cost of ownership is a lot higher than most people realize when you're making payments!

(You may have to enable editing on the spreadsheet to use it)

Attached Files
File Type: xls COST PER MILE.xls (20.8 KB, 34 views)
__________________


Last edited by cowmeat; 09-20-2014 at 10:18 AM..
  Reply With Quote
The Following User Says Thank You to cowmeat For This Useful Post:
spacemanspif (09-21-2014)
Reply  Post New Thread


Thread Tools




Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Content Relevant URLs by vBSEO 3.5.2
All content copyright EcoModder.com