How do you generate the costs from the sell price? What's the percentage?Hoping a budding mathematician can help with a problem Iíve got. Iíve been playing around with this one in MS Excel and Iím afraid it has me beat.
Hereís what Iím trying to do
I start with a Sell Price from which there are fixed costs that I know will be incurred.
Sell Price 5000
Cost1 547.50 (Generated from sell price)
Cost2 800 (Generated from sell price)
Tax 3% on buy price ?? Will equal 92.19
Cost Total 1347.50 plus 3% tax on buy price(1439.69)
Sell less known costs 3652.5 should include the 3% tax on buy price(3560.31)
Profit Margin (10% on Sell less known costs) ?? Will equal 454.63
Buy Price ?? Will equal 3073.00
Essentially Iím trying to work out how to construct an Excel formula to calculate all this for me automatically from the information I know starting at a sell price and working back.
Is this possible anybody??