roi

Hi, I need some help with Excel to calculate ROI for this situation: <tbody> date quantity price bought quantity price sold ROI 2015-09-05 4,000 3.16 2015-11-05 1,500 3.56 2016-07-08 2,000 4.13 2016-11-10 2,000 4.51 2017-01-05 1,000 4.12...

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.

Hi All, I know that there will be multiple threads about IF statement issues but i thinks mines quite specified :( You will see from below the statement checks for data in the cells and if empty moves onto the next...

Am having difficulty writing a batch file around the following TYPE Microsoft Office Excel 2007 Macro-Enabled Workbook LOCATION C:\Users\Peter\Documents\AllData\PVOutput files\Pvoutput solar alinta estimates FILE NAME 7XX ROI sheet FOR BILL starting 090318.xlsm” This is what I wrote Start /D...

How do I properly set-up Solver to maximize an ROI equation? Specifically, the target being ROI and the constraints using daily spend and revenue data? I have paid search spend and revenue data by day for 1.5 years... I would like to understand the point of diminishing returns to understand my...

Hello folks, need som help with finding value on a certain date to calculate monthly change! I want to calculate the percentage changed every month, and so i got transactions every month, but not always is it the first or last in the month, to find right dates? could perhaps go from last...

Looking to find out the correct formula to calculate the ROI Ratio Example 7:1. I am getting conflicting answers from my counterparts on how to compute this? Here is the information; Avoided Cost is $503,913, Expenses are $60,585 1. Some say the correct method is; Avoided Cost/Expenses = ROI...

Hi, I am looking to find a way to calculate a tie weighted return for my investor. I want to calculate what his average rate of return will be, given that he will be lending me different amounts of money at different times, and I will be giving him all of his money back plus interest on date in...

Team, I'm trying to calculate the ROI where there are many outflows & inflows. Since inflows > outflows; the investor makes $$ The return is 31% if the Cost of Capital is Zero. The ROI is that Cost of Capital which yields Zero for the Net Return. To solve this I need a column (or many...