[bodtwo]

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.

[Grim]

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.

[bodtwo]

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.

[ZeroFx]

Originally Posted by bodtwo

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.

PCP is a bitch at them miles.

Is this company allowance funded?

[teaston]

Originally Posted by ZeroFx

PCP is a bitch at them miles.

Is this company allowance funded?

Mileage doesn’t matter on PCP if you VT

[chris-c]

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.

[De30m]

that sounds suspiciously like you want to do actual maths not man maths

[chris-c]

Originally Posted by De30m

that sounds suspiciously like you want to do actual maths not man maths

I had a budget of ~£22k and bought a £26k car.
I do man maths

[Archer-s]

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

[bodtwo]

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.

[Archer-s]

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

[creepy coupe]

Originally Posted by Grim

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.

50 mpg for a diesel and 30 for petrol are extremes IMO

[335i nthehouse]

Originally Posted by Grim

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.

Not necessarily true - depends how you fund fuel etc

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

[335i nthehouse]

Originally Posted by 335i nthehouse

Not necessarily true - depends how you fund fuel etc

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

This is if your mileage is business mileage of course, which 30k usually is

[BMWChap]

Originally Posted by teaston

Mileage doesn’t matter on PCP if you VT

Yep I agree..so now I need to decide to go M2 or a fully loaded 440i mmm.

[bodtwo]

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.

[JustChris]

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

[Solstice1]

If you're concerned about depreciation I'd start with a 2-3 year old car with 20-30k miles, it will have lost a larger chunk to start with.

[bodtwo]

Originally Posted by JustChris

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

You speak the truth. We need another phrase for spreadsheet driven man math.

[ZeroFx]

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.

[jdrally]

Originally Posted by chris-c

I had a budget of ~£22k and bought a £26k car.
I do man maths

Not math but meth.

[bodtwo]

Originally Posted by ZeroFx

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.

Is that something you can share ZeroFx?