Mileage Expenses Calculations

[monkey_boy]

Hi All,

It's a motors-related excel question really. I want to create a spreadsheet where i can compare 2 scenarios and see at what mileage the crossover point is.

Scenario 1: mileage rate of Xp per mile

Scenario 2: mileage rate of Yp per mile plus annual lump sum of £Z

I hope I've explained it properly and hope someone can help...

 

[Basher]

You'll also need to consider the tax break between Yp in scenario two and the HMRC rate.

 

[Kenai]

It's pretty simple, just do one column with miles in it, one where you do miles x rate X and another where you do miles x rate Y + lump

You could do it with Goalseek or something but given the above seems to have eluded you, that may be a bit advanced

 

[Kingy]

Hi All,

It's a motors-related excel question really. I want to create a spreadsheet where i can compare 2 scenarios and see at what mileage the crossover point is.

Scenario 1: mileage rate of Xp per mile

Scenario 2: mileage rate of Yp per mile plus annual lump sum of £Z

I hope I've explained it properly and hope someone can help...

Where:-
Xp = 45p
Yp = 25p
£Z = £2000 (Net of Tax / NI)
Mileage = 10,000

Mileage/Xp = £4500
Mileage/Yp = £2500
((Mileage/Yp)+£Z)) = £4500

Using the figures above, if an annual mileage above 10,000 were projected, £Z + Yp would be greater than Xp...

 

[Kingy]

given the above seems to have eluded you, that may be a bit advanced

HIGHFIVE!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

 

[monkey_boy]

Thanks Kingy, had a brainfart of how to set it out to get a chart to work!

Here's a sheet with a chart (which is the bit I was after). http://dl.dropbox.com/u/21114181/Higher_Mileage_Rate_Vs_Lower_Mileage_Rate_&_Lump_Sum(1).xlsx

Kenai - useless as ever. Where would we be without you.

 

[Kenai]

Kenai - useless as ever. Where would we be without you.

So useless you've pretty much done exactly what I suggested. Okey doke.