Reverse Calc of ROI

[shlomek12]

I am trying to develop a formula that can give me the cost price by inputting the sell price and Return of Investment (ROI)

My sell price is $20.00 I want to input a ROI of 20% and have the result be my desired cost.

https://www.screencast.com/t/5hhKZVjMNw

Any help would be welcome.

 

[igold]

How about if you take your Sell and divide by 1 + your ROI

For example if your Sell is $60.00 and you wanted to make a 20% ROI then:

60/(1 + 20%) = $50 or $60/1.2 = $50 cost or in your example:

20/1.2 = 16.67

 

[shlomek12]

Yops This is what I want

Thank you

 

[igold]

Happy to help. Thanks for the feedback.