Profit Distribution between 2 people

Excel-ent

New member
Joined
Nov 15, 2019
Messages
3
Hello.

i am a noob in maths.

I have made an excel sheet for distribution of Profit between me and my partner and would appreciate if you guys can review it and make any changes to the mistakes in the work sheet.

I really appreciate your kind help.

Thanks

Notes:
We buy a car, we pay half / half at the same time

Then we register the vehicle and also distribute Half/half at the same time.

Then we pay extra costs, which sometimes he pays, sometimes I pay...

Then when we sell the car, I distribute it following the attached sheet.

But not sure if it has mistakes.

Thanks

My e mail is:
mbnz at Live dot com
 

Attachments

  • Screenshot_20191116-022444.png
    Screenshot_20191116-022444.png
    233.2 KB · Views: 7
A
Hello.

i am a noob in maths.

I have made an excel sheet for distribution of Profit between me and my partner and would appreciate if you guys can review it and make any changes to the mistakes in the work sheet.

I really appreciate your kind help.

Thanks

Notes:
We buy a car, we pay half / half at the same time

Then we register the vehicle and also distribute Half/half at the same time.

Then we pay extra costs, which sometimes he pays, sometimes I pay...

Then when we sell the car, I distribute it following the attached sheet.

But not sure if it has mistakes.

Thanks

My e mail is:
mbnz at Live dot com

So apparently you are a noob at the capitals button as well.;) Just kidding.

So your spreadsheets are correct..so far...I'm double checking.
 
All good.:thumbup:

Is my sheet calculation is correct, or the attached calculation is correct, please advise .

If both are correct, why aren't the (total amounts received) are matching.

Thanks very much.
 

Attachments

  • Screenshot_20191118-012216~2.png
    Screenshot_20191118-012216~2.png
    168.1 KB · Views: 6
The figures in your spreadsheet (post#1) and those in your post #4 don't match.

What is the total you paid for the car and extras?
According to your spreadsheet:
Shawn paid $9485 + $870 + $4350 = $14 705.
Harry paid $9485 + $870 + $920 = $11 275.
That is, a total of $14705 + $11275 = $25980 was paid. Is that correct?

What was the car sold for? In your spreadsheet you say $32 000. In your other post, you say $38 000. Which is it?
 
The figures in your spreadsheet (post#1) and those in your post #4 don't match.

What is the total you paid for the car and extras?
According to your spreadsheet:
Shawn paid $9485 + $870 + $4350 = $14 705.
Harry paid $9485 + $870 + $920 = $11 275.
That is, a total of $14705 + $11275 = $25980 was paid. Is that correct?

What was the car sold for? In your spreadsheet you say $32 000. In your other post, you say $38 000. Which is it?

Considering figures in post No. 4 to be considered, which calculation is correct. Post # 1 or Post No. 4 calculations?

Thanks
 
Top