Confusing pricing problem for MS Excel automation.
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??