ABSTRACT

A slightly more sophisticated approach allows comparison between different investment opportunities. The Discounted Cash Flow (DCF) Internal Rate of Return is the interest rate which gives an NPV for the investment of zero. The calculation is not easy and the simplest approach one of trial and error on a spreadsheet. In fact Excel has a built-in DCF function.