F30POST
F30POST
2012-2015 BMW 3-Series and 4-Series Forum
BMW Garage BMW Meets Register Search Today's Posts Mark Forums Read
BMW 3-Series and 4-Series Forum (F30 / F32) | F30POST > 2012-2019 BMW 3 and 4-Series Forums > Regional Forums > UK > Man math spreadsheet?
GetBMWParts
Post Reply
 
Thread Tools Search this Thread
      02-21-2018, 06:21 PM   #1
bodtwo
Lieutenant
188
Rep
549
Posts

Drives: F31 335D
Join Date: Sep 2015
Location: Sheffield

iTrader: (0)

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.
__________________
Received F31 335D EBII - with lots of toys, may need more.
Appreciate 0
      02-21-2018, 06:27 PM   #2
Grim
Enlisted Member
12
Rep
46
Posts

Drives: 320i X M Sport
Join Date: Nov 2016
Location: Edinburgh

iTrader: (0)

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, 06:39 PM   #3
bodtwo
Lieutenant
188
Rep
549
Posts

Drives: F31 335D
Join Date: Sep 2015
Location: Sheffield

iTrader: (0)

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.
__________________
Received F31 335D EBII - with lots of toys, may need more.
Appreciate 0
      02-21-2018, 08:06 PM   #4
ZeroFx
Captain
39
Rep
637
Posts

Drives: 430D M Sport Convertible
Join Date: Apr 2014
Location: West Mids

iTrader: (0)

Quote:
Originally Posted by bodtwo View Post
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?
Appreciate 0
      02-21-2018, 08:18 PM   #5
teaston
General
teaston's Avatar
United Kingdom
6424
Rep
23,852
Posts

Drives: 335d M Sport Plus
Join Date: May 2012
Location: Norfolk 'n' Good

iTrader: (1)

Quote:
Originally Posted by ZeroFx View Post
PCP is a bitch at them miles.

Is this company allowance funded?
Mileage doesnít matter on PCP if you VT
__________________
Current: LCI F30 335d M Sport Plus in BSM/CR
Appreciate 1
BMWChap198.00

      02-22-2018, 03:28 AM   #6
chris-c
Captain
United Kingdom
404
Rep
950
Posts

Drives: F31 340i MG + MPPSK
Join Date: Feb 2018
Location: Berkshire

iTrader: (0)

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, 03:44 AM   #7
De30m
Private
De30m's Avatar
33
Rep
81
Posts

Drives: 2017 430D
Join Date: May 2012
Location: Hampshire

iTrader: (0)

that sounds suspiciously like you want to do actual maths not man maths
__________________
2017 430D - EVOLVE remap, H&R Super Sports - 12F 15R spacers - 440i Exhaust
Appreciate 0
      02-22-2018, 03:49 AM   #8
chris-c
Captain
United Kingdom
404
Rep
950
Posts

Drives: F31 340i MG + MPPSK
Join Date: Feb 2018
Location: Berkshire

iTrader: (0)

Quote:
Originally Posted by De30m View Post
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
Appreciate 0
      02-22-2018, 03:55 AM   #9
mssond
Captain
166
Rep
640
Posts

Drives: on order
Join Date: May 2010
Location: Brizzle

iTrader: (0)

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, 04:03 AM   #10
bodtwo
Lieutenant
188
Rep
549
Posts

Drives: F31 335D
Join Date: Sep 2015
Location: Sheffield

iTrader: (0)

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.
__________________
Received F31 335D EBII - with lots of toys, may need more.
Appreciate 0
      02-22-2018, 04:20 AM   #11
mssond
Captain
166
Rep
640
Posts

Drives: on order
Join Date: May 2010
Location: Brizzle

iTrader: (0)

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, 05:39 AM   #12
creepy coupe
Lieutenant General
creepy coupe's Avatar
1425
Rep
12,321
Posts

Drives: Mazda 6. Help
Join Date: Aug 2007
Location: UK

iTrader: (2)

Garage List
2015 BMW 435d  [0.00]
2009 335i  [0.00]
Quote:
Originally Posted by Grim View Post
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
__________________
--------------------------------------------------------------
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, 06:30 AM   #13
335i nthehouse
Captain
212
Rep
830
Posts

Drives: F30 335i
Join Date: Apr 2014
Location: Devon

iTrader: (0)

Quote:
Originally Posted by Grim View Post
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
Appreciate 0
      02-22-2018, 06:31 AM   #14
335i nthehouse
Captain
212
Rep
830
Posts

Drives: F30 335i
Join Date: Apr 2014
Location: Devon

iTrader: (0)

Quote:
Originally Posted by 335i nthehouse View Post
Quote:
Originally Posted by Grim View Post
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
This is if your mileage is business mileage of course, which 30k usually is
Appreciate 0
      02-22-2018, 06:39 AM   #15
LobB
Major General
LobB's Avatar
4434
Rep
5,407
Posts

Drives: M135i
Join Date: Feb 2016
Location: Manchester

iTrader: (0)

Quote:
Originally Posted by bodtwo View Post
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.
This is very easily solved by ditching your plan.
Appreciate 0
      02-22-2018, 06:39 AM   #16
BMWChap
Major
198
Rep
1,287
Posts

Drives: F32
Join Date: Jun 2012
Location: UK

iTrader: (0)

Quote:
Originally Posted by teaston View Post
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.
Appreciate 0
      02-22-2018, 07:21 AM   #17
bodtwo
Lieutenant
188
Rep
549
Posts

Drives: F31 335D
Join Date: Sep 2015
Location: Sheffield

iTrader: (0)

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.
__________________
Received F31 335D EBII - with lots of toys, may need more.
Appreciate 0
      02-22-2018, 08:50 AM   #18
JustChris
Lieutenant General
JustChris's Avatar
United Kingdom
5335
Rep
13,606
Posts

Drives: Range Rover Sport
Join Date: Jul 2013
Location: North West UK

iTrader: (0)

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
__________________
RRS HSE Currently & Previously as below
M2 / Mini JCW / X5M50d / 335d / Mini Cooper / M4 / M235i / 520D / X5 / X1 / 520D / 330D / 330i

http://f30.bimmerpost.com/forums/sho....php?t=1500221
Appreciate 0
      02-22-2018, 10:24 AM   #19
Solstice1
Private
11
Rep
56
Posts

Drives: F31 335d Birds B3
Join Date: Jan 2016
Location: Salisbury Plain

iTrader: (0)

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.
Appreciate 0
      02-22-2018, 11:43 AM   #20
bodtwo
Lieutenant
188
Rep
549
Posts

Drives: F31 335D
Join Date: Sep 2015
Location: Sheffield

iTrader: (0)

Quote:
Originally Posted by JustChris View Post
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.
__________________
Received F31 335D EBII - with lots of toys, may need more.
Appreciate 0
      02-22-2018, 04:10 PM   #21
ZeroFx
Captain
39
Rep
637
Posts

Drives: 430D M Sport Convertible
Join Date: Apr 2014
Location: West Mids

iTrader: (0)

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, 04:14 PM   #22
jdrally
New Member
11
Rep
20
Posts

Drives: F30 335d
Join Date: Apr 2017
Location: saltash

iTrader: (0)

Quote:
Originally Posted by chris-c View Post
I had a budget of ~£22k and bought a £26k car.
I do man maths
Not math but meth.
Appreciate 0
Post Reply

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


All times are GMT -4. The time now is 05:14 AM.




f30post
Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
1Addicts.com, BIMMERPOST.com, E90Post.com, F30Post.com, M3Post.com, ZPost.com, 5Post.com, 6Post.com, 7Post.com, XBimmers.com logo and trademark are properties of BIMMERPOST