Mark up calculator

Question

I am not great at this.&nbsp; &nbsp; I want to start with a cost of a product $100 A5add my over head variable say of 10% and show various profit margin % 0-100%&nbsp; &nbsp; What is the formula that should be in the C columnSpread sheet to look something like this.ABCCost should include any fees (tax/shipping)MarginAmount to Bill&nbsp;$&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100.00&nbsp;&nbsp;&nbsp;20%&nbsp;&nbsp;15%&nbsp;Profit /Overhead10%$12210.00%5%&nbsp;&nbsp;0%$110Thank you for your a help.

mathetes · Answer

Steviep23&nbsp;&nbsp;If I understand you correctly, here's one approach. You could adapt the formula (or modify it) to fit other layouts. I did this for modeling in a "what-if?" kind of way, where you can change any of the variables in cells A2, B2 and C2. The formula in D2 is=A2*(1+B2)*(1+C2)The result looks like this with the variables shown&nbsp;&nbsp;

Forum Discussion

Mark up calculator

1 Reply

Resources

A	B	C
Cost should include any fees (tax/shipping)	Margin	Amount to Bill
$ 100.00
	20%
	15%
Profit /Overhead	10%	$122
10.00%	5%
	0%	$110