How can I calculate the ROI of an investment from its cash flow?

Question

I've my company cash flow and I'd like to understand if my company is more or less profitable than lending money asking back a 6% yearly interest.

Where can I start from? Is there any Excel Formula?

fyi https://money.stackexchange.com/a/89671/11768 – Chris Degnen Mar 19 '19 at 11:23 — Chris Degnen, Mar 19 '19 at 11:23
also https://money.stackexchange.com/a/64524/11768 – Chris Degnen Mar 19 '19 at 11:33 — Chris Degnen, Mar 19 '19 at 11:33

score 1 · Accepted Answer · answered Mar 18 '19 at 22:06

1

The ROI that can be calculated purely from cash flows is the internal rate of return.

answered Mar 18 '19 at 22:06

nanoman

1 Answers1