02-21-2018, 04:21 PM | #1 |
Captain
261
Rep 692
Posts |
Man math spreadsheet?
Hi all,
I’ve 6 months or so before I’ll be swapping, so it’s time for some man maths. Does any one have a costs spreadsheet they’d be willing to share? I’d be looking to compare derv with petrol and pcp against cheap loan or using cash. More complex the better so I can tinker around and convince myself it’s all good. 25k to 30k per annum in miles is looking like a problem with all this uncertainty on diesel. Thanks for sharing.
__________________
GONE : F31 335D EBII - with lots of toys & big grins.
|
02-21-2018, 04:27 PM | #2 |
Enlisted Member
12
Rep 46
Posts |
20-30k miles per annum forces you into a diesel regardless. Your savings will be circa 100/month on fuel.
Man math from my local Costco: Diesel: 112p/l (premium diesel) @ 50mpg for 20,000 miles = £2,036.65 per year in fuel Petrol: 109p/l (premium petrol) @30mpg for 20,000 miles = £3,303.49 per year in fuel. You can fiddle here: https://www.which.co.uk/reviews/new-...sel-calculator 30k miles per annum is gonna put most dealers off a good PCP, as at 120k miles you'll be handing back a corpse, you may wanna seriously look at large deposit + 6yr HP. |
Appreciate
0
|
02-21-2018, 04:39 PM | #3 |
Captain
261
Rep 692
Posts |
I’m probably nearer 40mpg in a 335 and I’d likely be staying with a 6 pot, with either fuel. So comparatively maybe not so different.
Was going to look at getting something a year or so old, me using it for a couple of years and then the other half having it for a year. She does 6k per annum. Hence spreadsheet to play with.
__________________
GONE : F31 335D EBII - with lots of toys & big grins.
|
Appreciate
0
|
02-21-2018, 06:06 PM | #4 | |
Major
454
Rep 1,373
Posts |
Quote:
Is this company allowance funded? |
|
Appreciate
0
|
02-22-2018, 01:28 AM | #6 |
Lieutenant Colonel
901
Rep 1,801
Posts |
I looked into PCP when I bought my car and decided the saving of getting a loan was far greater than the pcp route.
£26000 car £5000 deposit £2000 credit card 35 payments @ £402.48 Bubble of £9386.85 30'000 miles Total payment = 30'473.65 OR for me £26000 car £5000 deposit £2000 0% credit card 36 payments @551.39 Total payment = £26'850.04 The credit card is 0% for another 18 months so as long as I pay that off at £112 a month there will be no interest accrued on that. This is with low mileage and I'm sure the car wont plummet in value like yours would if you're putting ~90k on it in 3 years. Even if you get a 1 year old car with 10k on the clock you having it for 2 years and your missus having it for one would give you a 4 year old car with nearly 80'000 miles. |
Appreciate
0
|
02-22-2018, 01:44 AM | #7 |
Private
50
Rep 84
Posts |
that sounds suspiciously like you want to do actual maths not man maths
__________________
Now - G87 M2 - Black, Black, Black, Comfort, Full Carbon pack and M performance Exhaust
Gone - M440i - Brooklyn Grey Tacora red, 797s, HK, M Technology pack, Visibilty & shadow line plus |
Appreciate
0
|
02-22-2018, 01:49 AM | #8 |
Lieutenant Colonel
901
Rep 1,801
Posts |
|
Appreciate
0
|
02-22-2018, 01:55 AM | #9 |
Captain
247
Rep 805
Posts |
Lol@chris-c this sounds like every car I have ever purchased
@Op - I have a man maths spreadsheet, but I used it to calculate company vs private ownership, doesn’t include any fuel, if that’s useful drop me a PM with your email address |
Appreciate
0
|
02-22-2018, 02:03 AM | #10 |
Captain
261
Rep 692
Posts |
This is private but with fuel allowance, standard 40p for 10k then 25p after. Work mileage about 20k so about 6.5k fuel contribution. It’s depreciation I’m mor concerned about if I self fund a vehicle.
And yes, PCP, is probably the obvious route and just vt as suggested.
__________________
GONE : F31 335D EBII - with lots of toys & big grins.
|
Appreciate
0
|
02-22-2018, 02:20 AM | #11 |
Captain
247
Rep 805
Posts |
If it’s depreciation, then buy the more special models such as S4 or AMG 43, they hold their value better, they are not just seen as another M Sport, plus options rarely hold their value, so buying a model which has all the options you want as std also helps IMO ie it maybe beneficial to move up a class of car if you like lots of options, a 5 will come with more as STD than a 3
Every time I have run PCP for 20/30k per year it does work out better to do HP and sell the car after |
Appreciate
0
|
02-22-2018, 03:39 AM | #12 | |
Lieutenant General
1867
Rep 13,043
Posts
Drives: BMW M340I G20
Join Date: Aug 2007
Location: UK
|
Quote:
__________________
--------------------------------------------------------------
Current car.M240i. Previous.MINI JCW. E92 325i. 435d M235i.M135i. 635d Coupe, E92 M3 manual, E92 M3 DCT Competition Pack. E92 335i, Porsche Cayman S Gen2, 135i Coupe. E92 320d, MK5 R32. MK5 Golf GTi,MK5 Golf GT-TDI,E46 318Ci. |
|
Appreciate
0
|
02-22-2018, 04:30 AM | #13 | |
Captain
273
Rep 915
Posts |
Quote:
I get paid HMRC rates and the fuel reimbursement rate for over 2l petrol is 21p per mile versus 14p for diesel I think There are so many variables you need to create your own sheet unfortunately |
|
Appreciate
0
|
02-22-2018, 04:31 AM | #14 | ||
Captain
273
Rep 915
Posts |
Quote:
|
||
Appreciate
0
|
02-22-2018, 05:21 AM | #16 |
Captain
261
Rep 692
Posts |
Decision will likely be PCP a 535D/640D or buy something around £35k up to a couple of years old where i can stomach the depreciation. If i go for buying something it will likely be petrol as it's looking like they may hold a little more value. To be honest i'm in a bit of a holding pattern for next three or so years until something electric comes along thats useable.
All depends on what deals are around later this year of course.
__________________
GONE : F31 335D EBII - with lots of toys & big grins.
|
Appreciate
0
|
02-22-2018, 06:50 AM | #17 |
General
17488
Rep 25,113
Posts |
Fake News Thread.
True Man Maths would not involve a spreadsheet at all. Too much logic and actual maths required. Unless optimistic lies are added
__________________
My car made front page of Bimmerpost
|
Appreciate
0
|
02-22-2018, 09:43 AM | #19 |
Captain
261
Rep 692
Posts |
You speak the truth. We need another phrase for spreadsheet driven man math.
__________________
GONE : F31 335D EBII - with lots of toys & big grins.
|
Appreciate
0
|
02-22-2018, 02:10 PM | #20 |
Major
454
Rep 1,373
Posts |
I have a pretty complex spread sheet which calculates Car Allowance for Diesel and petrol and what you claim back from HMRC. It allows me to input fuel prices and service costs etc and then what i reclaim from HMRC and spits out monthly budget for depreciation. I had to modify the sheet to allow for shit company allowance and good company allowance. As some companies pay 45/25p per mile and some pay company car rates as low as 11-13p per mile. The difference is significant.
|
Appreciate
0
|
02-22-2018, 03:59 PM | #22 | |
Captain
261
Rep 692
Posts |
Quote:
__________________
GONE : F31 335D EBII - with lots of toys & big grins.
|
|
Appreciate
0
|
Post Reply |
Bookmarks |
|
|