1 ALT-IRR-CASH-STREAM Score: 0 Instructions: Choose the Discount Rate (cell C9) that makes the NPV =0. Note that when you choose the Discount Rate, the interest factors are automatically Choose Exercise (1-5): selected from the PV of $1.00 table, and the NPV is automatically calculated. The rate that makes NPV=O is the IRR. Charlie invested $2,673 to receive the the cash flows shown below: 0 1 2 3 4 5 Choose Discount Rate: -$2,673.01 $1,000 $1,000 $1,000 1% 0.9901 0.9803 0.9706 $2,940.99 $990.10 $980.30 $970.59 NPV $267.97 PV OF $1.00 2% 3% 6% 9% 1 7% 0.9346 0.8734 8% 0.9259 0.8573 2 1% 0.9901 0.9803 0.9706 0.9610 0.9515 0.9804 0.9612 0.9423 0.9238 0.9057 0.9709 0.9426 0.9151 0.8885 0.8626 4% 0.9615 0.9246 0.8890 0.8548 0.8219 5% 0.9524 0.9070 0.8638 0.8227 0.7835 0.9434 0.8900 0.8396 0.7921 0.7473 10% 0.9091 0.8264 0.7513 0.6830 0.6209 11% 0.9009 0.8116 0.7312 0.6587 0.5935 0.9174 0.8417 0.7722 0.7084 0.6499 12% 0.8929 0.7972 0.7118 0.6355 13% 0.8850 0.7831 0.6931 0.6133 0.5428 14% 0.8772 0.7695 0.6750 0.5921 0.5194 15% 0.8696 0.7561 0.6575 0.5718 0.4972 0.7938 0.8163 0.7629 0.7130 st 0.7350 0.6806 5 0.5674 PV OF AN ANNUITY OF $1.00 3% 6% 2% 0.9804 1 4% 0.9615 1.8861 0.9434 1.8334 2 1.9416 1% 0.9901 1.9704 2.9410 3.9020 4.8534 5% 0.9524 1.8594 2.7232 3.5460 0.9709 1.9135 2.8286 3.7171 4.5797 7% 0.9346 1.8080 2.6243 3.3872 8% 0.9259 1.7833 2.5771 3.3121 3.9927 9% 0.9174 1.7591 2.5313 3.2397 3.8897 10% 0.9091 1.7355 2.4869 3.1699 3.7908 11% 0.9009 1.7125 2.4437 3.1024 3.6959 12% 0.8929 1.6901 2.4018 3.0373 3.6048 13% 0.8850 1.6681 2.3612 2.9745 3.5172 14% 0.8772 1.6467 2.3216 2.9137 3.4331 15% 0.8696 1.6257 2.2832 2.8550 3.3522 3 2.8839 3.8077 4.7135 4 2.7751 3.6299 4.4518 2.6730 3.4651 4.2124 5 4.3295 4.1002