Question 1115525
results are in the picture of my excel spreadsheet shown below.


<img src = "http://theo.x10hosting.com/2018/042302.jpg"alt="$$$" >


the net present value at the indicated rate of return is zero, as it should be.


the yearly rate of return is the nominal yearly rate of return, which is the monthly rate of return * 12.


the internal rate of return is calculated using the irr(data set)) function of excel.


the data set for cf1 is in cells d4 to d8.


the data set for cf2 is in cells f4 to f8.


the npv is calculated using the npv(rate, data set) function of excel.


the rate used for cf1 is in cell d10.


the rate used for cf2 is in cell f10.