Financial management rate of return worksheet

A more conservative approach then IRR in calculating rate of return. This method still involves discounting future cash flows, however, all negative cash flows are discounted back to the present (beginning of the investment) at a given safe rate and added to the initial investment and all positive cash flows are reinvested and compounded at a given risk rate and then added to the final cash flow.

Input the initial investment, the safe and risk rates, and up to 30 annual cash flows. You get both the IRR and the FMRR so you can compare them.