reverse calculate

I need to reverse a formula for my list price to match our Gross Margin %. They all need to =65% GM. Ex: List Price: $267.87 (C4) Landed: $44.21 (E4) GM%: 83% (H4) New List Price: ? New GM%: 65% Is there an excel formula that can make this easier for me to apply to all the other prices that...

Hi, I have a situation where I know a final price and the percentage for commission & tax on the commission only. I need to reverse calculate this to get the starting price. Example: If the commission is 15% and the tax on the commission only is 20% and the final value is 118.00 then I need a...

Hi Need help with this. I have a range of sizes of pieces of art from 35 inches2 to 352 inches2. I then put amounts of money along side each size. The amount per square inch decreases as the size gets larger. 35 x £10 = £ 350 352 x £3 = £1056 The rates in £'s per square inch between 35...

First time poster and desperate for help! I work in sales spend a lot of my time working out selling prices for my team and me. As a sanity check, I use a spreadsheet (I call my Margin Calculator) to enter all costs and then, depending on the client, the final selling price rather than pen and...