|
Re: Re: Profit Margin Calculator
|
Quote:
|
Originally posted by deaddred
A simple Excel spreadsheet will do that:
In A1 put the cost.
In A2 put the margin (say 1.20 for 20%)
in A3 put =a1*a2
|
Actually that is not correct. The calculation is cost/profit margin ( 20%margin=.8) that would give you a price of $125. The proof of that is to take 20% of 125 and you would still have your $100 cost left. If you do it your way you get $120. Take 20% away($24) and now you are short.
Last edited by bigdave240; 01-27-04 at 11:07 AM.
|