X Cut Calibri (Body) 2b Wrap Text v General Normal Bad Good Neutral Calculation Copy AutoSum Av Format BIUV BY M Av Merge & Center $ ~ % 9 Conditional Format Check Cell Explanatory T... Input Linked Cell Note Fill Insert Delete Format Formatting as Table Clear v Sort & Analyze Select Data fx A B C D E F G H K M N Cookie Business As the owner of the Cookie Business, you are considering the following investment: PV of Annuity Table Purchase of new equipment $ 250,000.00 n 1% 2% 3% 4% 5% 6% 8% 10% 12% Expected annual increase in sales $ 48,017.50 0.9901 0.9804 0.9709 0.9615 0.9524 0.9434 0.9259 0.9091 0.8929 Time frame 7 years 1.9704 1.9416 1.9135 1.8861 1.8594 1.8334 1.7833 1.7355 1.6906 W N Acceptable rate needed 9% 2.941 2.8839 2.8286 2.775 2.723 2.673 2.5771 2.4869 2.4018 A 3.902 3.8077 3.7171 3.6299 3.546 3.4651 3.3121 3.1699 3.0374 Calculate the Internal Rate of Return: 4.8534 4.7135 4.5797 4.4518 4.3295 4.2124 3.9927 3.7908 3. 6048 PV of annuity factor 6 5.7955 5.6014 5.4172 5.2421 5.0757 4.9173 4.6229 4.3553 4.1114 Internal rate of return 7 6.7282 5.472 6.2303 5.0021 5.7864 5.5824 5.2064 4.8684 4.5638 13 8 7.6517 7.3255 7.0197 6.7327 6.4632 6.2098 5.7466 5.3349 4.9676 14 Accept or reject 9 8.566 8.1622 7.7861 7.4353 7.1078 6.8017 6.2469 5.759 5.3283 15 10 9.4713 8.9826 8.5302 8.1109 7.7217 7.3601 6.7101 6.1446 5.6502 16 11 10.3676 9.7869 9.2526 8.7605 8.3064 7.8869 7.139 6.4951 5.9377 8.3838 7.5361 6.1944 17 12 11.2551 10.5753 .954 9.3851 8.8633 6.8137 18 13 12.1337 11.3484 10.635 9.9857 9.3936 8.8527 7.9038 7.1034 6.4236 14 13.0037 12.1063 11.2961 10.5631 9.8986 9.295 8.2442 7.3667 6.6282 19 15 13.8651 12.8493 11.938 11.1184 10.3797 9.7123 8.5595 7.6061 6.8109 36 Full Variable Special Order IRR Cash Budget Variances + Ready 2 Accessibility: Good to go