Finance
Work out return on investment (ROI)
=(B2-B1)/B1How it works in Excel
- B2-B1 is what you gained.
- Dividing by B1 compares it to what you put in.
- Format the cell as a percentage.
- ROI ignores how long it took. Use CAGR or IRR to account for time.
The idea in general
It shows what you got back for each dollar you put in.
What I assumed
- The starting amount is in B1 and the ending amount is in B2.
Check the result on your own data before relying on it.