POR (%) Calculation

[mac1001]

Hi,
Please, can someone help me with an Excel formula for finding a Selling Price calculation based on known margin required & Cost Price (Ex. VAT)?

Thanks

Thanks

 

[Fluff]

How about

Excel 2013 32 bit
	A	B	C
1	Cost	Margin	Sell
2	£20.00	10.00%	£22.00
3	£100.00	5.00%	£105.00
4	£80.00	20.00%	£96.00
Track

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

 

[mac1001]

Thanks but I'm meaning that if a product costs £7.50 (ex. VAT) and I want to make 10%...what's my selling price including VAT? VAT=20%

 

[Fluff]

How about
=(A2*(1+B2))*1.2

 

[shg]

[Table="width:, class:grid"][tr][td="bgcolor:#C0C0C0"][/td][td="bgcolor:#C0C0C0"]

A​

[/td][td="bgcolor:#C0C0C0"]

B​

[/td][td="bgcolor:#C0C0C0"]

C​

[/td][/tr][tr][td="bgcolor:#C0C0C0"]

1​

[/td][td]Cost[/td][td]

$ 7.50​

[/td][td]B1: Input[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

2​

[/td][td]Margin[/td][td]

10%​

[/td][td]B2: Input[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

3​

[/td][td]VAT[/td][td]

20%​

[/td][td]B3: Input[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

4​

[/td][td]Price[/td][td="bgcolor:#E5E5E5"]

$ 10.23 ​

[/td][td]B4: =B1 / (1 - 10% - B3/(1+B3))[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

5​

[/td][td]Check[/td][td][/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

6​

[/td][td]VAT[/td][td="bgcolor:#E5E5E5"]

$ 1.70​

[/td][td]B6: =B4 * B3 / (1+B3)[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

7​

[/td][td]Cost[/td][td="bgcolor:#E5E5E5"]

$ 7.50​

[/td][td]B7: =B1[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

8​

[/td][td]Profit[/td][td="bgcolor:#E5E5E5"]

$ 1.02​

[/td][td]B8: =B4-B6-B7[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

9​

[/td][td]Margin[/td][td="bgcolor:#E5E5E5"]

10%​

[/td][td]B9: =B8/B4[/td][/tr]
[/table]

 

[mac1001]

Much appreciated!

 

[shg]

You're welcome.