Need some help a formula Please

[Get_Involved]

I have cost of $100.00, I need a 10% profit = $110.00. total selling price.

I have a 35% lease agreement that reduces $110.00 to $71.50.

I have tried to merge these two formulas to accomplish, a formula that will tell me what profit I need to make for my total selling price, to be the same after the lease deducted.

 =SUM(111.11-100)/100

 =SUM(100*0.1+100

Without the lease being charged back in extra percentage to compensate for the lease.

Hope this makes sense

Thanks in advance
Bill

 

[kweaver]

Does this help?

Excel 2010
	A	B	C	D	E
1	Cost	Profit %	Selling $	Lease %	Final Amt
2	100.00	10%	110.00	35%	71.50
3	500.00	10%	550.00	35%	357.50
4	750.00	15%	862.50	40%	517.50
Sheet6

Cell Formulas
Range	Formula
C2	=A2*(1+B2)
E2	=C2*(1-D2)

 

[Get_Involved]

kweaver

Thanks for the response.

That I know, in reality the lease is part of my expense.

What I am trying to find is a formula the to tell me what extra to add to my profit of 10%, so when the lease .35% is deducted from my cost 100 + 10% = 110.00.

110.00 * .35 = 43.75 lease

I need to count that as my expense, but not added back into the Lease, because that just makes more coming from my 110.00.

Hope i am making sense.

 

[kweaver]

I don't understand, sorry. Especially, since 110*0.35 = 38.50 and not 43.75

 

[Get_Involved]

sorry I hit the wrong key. You are correct

if you tell me what part it is yo don't understand, because I am not very good at explaining this formula stuff.

 

[Peter_SSs]

Is this what you mean?

Excel Workbook
	A	B
1	Cost	Selling Price
2	100	169.23
3	500	846.15
4	750	1269.23
Selling Price

 

[kweaver]

I thought you were looking for the Final Amt that I calculated in my example in column E.
Are my five columns correct for what you wanted? If so, what is missing that you also need? Do you want to show the 38.50 somewhere?

Excel 2010
	A	B	C	D	E	F
1	Cost	Profit %	Selling $	Lease %	Final Amt	Lease Amt
2	100.00	10%	110.00	35%	71.50	169.23
3	500.00	10%	550.00	35%	357.50	846.15
4	750.00	15%	862.50	40%	517.50	1437.50
Sheet6

Cell Formulas
Range	Formula
E2	=C2*(1-D2)
F2	=C2/(1-D2)
C2	=A2*(1+B2)

 

[Get_Involved]

Kweaver

Yes I need to get that 38.50 back into Your E2 to make it 110.00

Without making the lease greater than the original 38.50 after placing it into E2

I think to deep don't I

 

[kweaver]

Like this?

Excel 2010
	A	B	C	D	E
1	Cost	Profit %	Selling $	Lease %	Final Amt
2	100.00	10%	110.00	35%	38.50
3	500.00	10%	550.00	35%	192.50
4	750.00	15%	862.50	40%	345.00
Sheet6

Cell Formulas
Range	Formula
C2	=A2*(1+B2)
E2	=C2*D2

 

[Peter_SSs]

I have cost of $100.00, I need a 10% profit = $110.00. total selling price.

I have a 35% lease agreement that reduces $110.00 to $71.50.

I have tried to merge these two formulas to accomplish, a formula that will tell me what profit I need to make for my total selling price, to be the same after the lease deducted.

Hmm, I thought this meant that after 35% was deducted from the selling price, you still made your 10% profit.

So in my first example, if you sold for 169.23 and deducted 35% of that (59.23) you would end up with 110.00 which still gives you the 10% profit on your cost of 100

It looks like I may have misunderstood?