6. An alternative definition of the IRR is the rate that makes the principal at the beginning of year 6 equal to zero.

[5] This is shown in the preceding printout, in which cell E14 gives the principal at the beginning of year 6.

Using the Goal Seek function of Excel, find this rate (we illustrate how the screen should look).