Calculating The Benefit Cost Ratio
So you should be very careful using IRR function in Excel. It assumes your cash flow starts from year zero or present time. This rate is the interest rate that you’re going to discount your cash flow when you calculate the NPV. You can write a number here, which is going to be 10%, or …