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): 1 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: $4,816.00 $1,000 $1,000 $1,000 1% 0.9901 0.9803 0.9706 $2,940.99 $990.10 $980.30 $970.59 NPV $7,756.99 PV OF FUTURE CASH FLOWS AT PV OF $1.00 1% 3% 7% 12% 2% 0.9804 0.9612 1 6% 0.9434 4% 0.9615 0.9246 8% 0.9259 0.8573 9% 0.9174 0.8417 10% 0.9091 0.8264 11% 0.9009 0.8116 14% 0.8772 0.7695 2 0.8900 0.9901 0.9803 0.9706 0.9610 0.9515 5% 0.9524 0.9070 0.8638 0.8227 0.7835 0.9709 0.9426 0.9151 0.8885 0.8626 3 15% 0.8696 0.7561 0.6575 13% 0.8850 0.7831 0.6931 0.6133 0.5428 0.9423 0.9238 0.9057 0.9346 0.8734 0.8163 0.7629 0.7130 0.8890 0.8548 0.8219 4 0.8396 0.7921 0.7473 0.7938 0.7350 0.6806 0.8929 0.7972 0.7118 0.6355 0.5674 0.7722 0.7084 0.6499 0.7513 0.6830 0.6209 0.7312 0.6587 0.5935 0.6750 0.5921 0.5194 0.5718 0.4972 5 PV OF AN ANNUITY OF $1.00 4% 7% 10% 13% 0.8850 1 2 1% 0.9901 1.9704 2.9410 3.9020 4.8534 2% 0.9804 1.9416 2.8839 3.8077 4.7135 3% 0.9709 1.9135 2.8286 3.7171 4.5797 5% 0.9524 1.8594 2.7232 3.5460 4.3295 0.9615 1.8861 2.7751 3.6299 4.4518 6% 0.9434 1.8334 2.6730 3.4651 4.2124 8% 0.9259 1.7833 2.5771 3.3121 3.9927 0.9346 1.8080 2.6243 3.3872 4.1002 9% 0.9174 1.7591 2.5313 3.2397 3.8897 11% 0.9009 1.7125 2.4437 3.1024 3.6959 0.9091 1.7355 2.4869 3.1699 3.7908 12% 0.8929 1.6901 2.4018 3.0373 3.6048 1.6681 2.3612 3 14% 0.8772 1.6467 2.3216 2.9137 3.4331 15% 0.8696 1.6257 2.2832 2.8550 3.3522 4 5 2.9745 3.5172 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): 1 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: $4,816.00 $1,000 $1,000 $1,000 1% 0.9901 0.9803 0.9706 $2,940.99 $990.10 $980.30 $970.59 NPV $7,756.99 PV OF FUTURE CASH FLOWS AT PV OF $1.00 1% 3% 7% 12% 2% 0.9804 0.9612 1 6% 0.9434 4% 0.9615 0.9246 8% 0.9259 0.8573 9% 0.9174 0.8417 10% 0.9091 0.8264 11% 0.9009 0.8116 14% 0.8772 0.7695 2 0.8900 0.9901 0.9803 0.9706 0.9610 0.9515 5% 0.9524 0.9070 0.8638 0.8227 0.7835 0.9709 0.9426 0.9151 0.8885 0.8626 3 15% 0.8696 0.7561 0.6575 13% 0.8850 0.7831 0.6931 0.6133 0.5428 0.9423 0.9238 0.9057 0.9346 0.8734 0.8163 0.7629 0.7130 0.8890 0.8548 0.8219 4 0.8396 0.7921 0.7473 0.7938 0.7350 0.6806 0.8929 0.7972 0.7118 0.6355 0.5674 0.7722 0.7084 0.6499 0.7513 0.6830 0.6209 0.7312 0.6587 0.5935 0.6750 0.5921 0.5194 0.5718 0.4972 5 PV OF AN ANNUITY OF $1.00 4% 7% 10% 13% 0.8850 1 2 1% 0.9901 1.9704 2.9410 3.9020 4.8534 2% 0.9804 1.9416 2.8839 3.8077 4.7135 3% 0.9709 1.9135 2.8286 3.7171 4.5797 5% 0.9524 1.8594 2.7232 3.5460 4.3295 0.9615 1.8861 2.7751 3.6299 4.4518 6% 0.9434 1.8334 2.6730 3.4651 4.2124 8% 0.9259 1.7833 2.5771 3.3121 3.9927 0.9346 1.8080 2.6243 3.3872 4.1002 9% 0.9174 1.7591 2.5313 3.2397 3.8897 11% 0.9009 1.7125 2.4437 3.1024 3.6959 0.9091 1.7355 2.4869 3.1699 3.7908 12% 0.8929 1.6901 2.4018 3.0373 3.6048 1.6681 2.3612 3 14% 0.8772 1.6467 2.3216 2.9137 3.4331 15% 0.8696 1.6257 2.2832 2.8550 3.3522 4 5 2.9745 3.5172