Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Cornell Company is considering a project with an initial investment of $596,500 that is expected to produce cash in iows of $125,000 for nine years

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Cornell Company is considering a project with an initial investment of $596,500 that is expected to produce cash in iows of $125,000 for nine years Cornells required rate of retum is 12% (Click on the icon to view Present Value of S1 table) (Click on the icon to view Present Value of Ordinary Annuity of 51 table) What is the NPV of the project? What is the IRR of the project? 16. Is this an acceptable project for Comell? 14 15 14. What is the NPV of the project? (Enter the factor amount to three decimal places, XXXX Round the present value of the annuity to the nearest whole dollar Une parentheses or a minus sign for a negative nel present value) Net Cash Annuity PV Factor Present Years Inflow (1-12%, n=9) Value 19 Present value of annuity 0 Investment Net present value 15. What is the IRR of the project SU Camell Company is considering a project with an initial investment of $596,500 that is expected to produce cash inflows of 5125,000 for nine years, Cornell's 14. What is the NPV of the project tenter the factor amount to three decuma placas xxxx Hound the present value of the annuity to the nearest wnole dollar Use parentheses or a minus sign for a negative not present value) Net Cash Annuity PV Factor Present Inflow (1-12%, n-9) Value 1.9 Present value of annuity 0 Investment Net present value Years 15. What is the IRR of the project? Start by calculating the Annuity PV factor (Enter the factor amount to three decimal places XXXX) Annuity PV factor The IRR of the project is 16. Is this an acceptable project for Comell? This an acceptable project for Comell because the NPV is V than zero and the IRR IS than Comell's required rate of return Time Ramaininn a submit tes This question: 12 polnt(s) possible Comoll Company is considering a project with an initial investment of $596,500 that is expected to produce cash inflows of 5125,000 for nine years Comell's 14. What is the NPV Oft actor amount to three decimai places, XXXX Round the present value of the annuity to the nearest wnole conta Use parentheses or a mir net present value) Cash Annuity PV Factor Present Years 12% 14% low (l-12%, 09) Value 1.9 Present value 14% 0 Investment Net present 14% 15% 15% 15. What is the IRR of the Start by calculating the N 18% the factor amount to three decimal places XXXX) Annuity PV factor 18% 20% The IRR of the project is 16. Is this an acceptable project for Comell? This an acceptable project for Comell because the NPVIS V than zero and the IRR is than Cornell's required rate of return Periods 1% 2% 3% 4% 5% 6% 7% 8% 9% 10% 12% 14% 15% 16% 18% 20% Period 1 0.990 0.980 0.971 0.962 0.952 0.943 0.935 0.926 0.917 0.909 0.893 0.877 0.870/0.862 0.847 0.833 Period 20.980 0.961 0.943 0.925 0.907 0.890 0.873 0.857 0.842 0.826 0.797 0.769 0.756 0.743 0.7180.694 Period 30.971 0.942 0.915 0.889 0.864 0.840 0.816 0.794 0.772 0.751 0.712 0.675 0.658 0.641 0.609 0.579 Period 4 0.961 0.924 0.888 0.855 0.823 0.792 0763 0.735 0.708 0.683 0.636 0.592 0.572 0.552 0.516 0.482 Period 5 0.951 0.906 0.863 0.822 0.784 0.747 0.713 0.6810.650 0.621 0.567 0.519 0.497 0.476 0.437 0.402 Period 60.942 0.888 0.837 0 790 0.746 0.705 0.666 0.630 0.596 0.564 0.507 0.456 0.432 0.410 0.370 0.335 Period 70.933 0.871 0.813 0.7600 7110.665 0.623 0.583 0.547 0.513 0.452 0.400 0.376 0.354 0.314 0.279 Period 8 0.923 0.853 0.789 0.731 0.677 0.627 0.582 0.540 0.502 0.467 0.404 0.351 0.327 0.305 0 266 0.233 Period 9 0.914 0.837 0.766 0.703 0.6450.592 0.544 0.500 0.460 0 424 0.361 0.308 0.284 0.263 0.225 0.194 Period 0.905 0.820 0.744 0.676 0.614 0.558 0.508 0.463 0.422 0.386 0.322 0.270 0.2470 227 0.19 0.162 10 Period 110.896 0.804 0.7220.650 0.585 0.527 0.475 0.429 0.388 0.350 0.287 0 2370 215 0 195 0.162 0.135 Period 0.887 0.788 0.701 0.625 0.557 0.497 0.444 0.397 0.3560 319 0.257 0.208 0.187 0.168 0.137 0.112 12 Period 10 879 0 7730 681 0.601 0.530 0.4690 4150 3680 3260 2900 2290.18210 1630.1450 116/0.093 NE pa Period 0.879 0.773 0.681 0.601 0.530 0.4690415 0.368 0.326 0.290 0.229 0.182 0.163 0.145 0.116 0.093 13 Period 0.870 0.758 0.661 0.577 0.505 0.442 0388 0.340 0.299 0.263 0.205 0.160 0.141 0.125 0.099 0.078 14 Period 0.861 0.743 0.6420.555 0 481 0.417 0.362 0.315 0.2750 239 0.1830 140 0.123 0.108 0.084 0.065 15 Period 0.853 0.728 0,623 0.534 0.458 0.394 0339 0.292 0.252 0218 0 163 0.123 0.107 0.093 0.071 0.054 16 Period 0.844 0714 0.605 0513 0.436 0371 0.317 0.270 0.231 0.1980.146 0108 0.093 0.080 0.060 0.045 17 Period 0.836 0.700 0.587 0.494 0:416 0 350 0.296 0 250 0,212 0.180 0 130 0.095 0.081 0.069 0.051 0.038 18 Period 0.828 0 686 0.570 0.475 0.396 0.331 0.277 0.232 0.194 0.164 0.116 0.083 0.070 0.060 0.043 0.031 19 Period 0820 0.673 0.554 0.4560,377 0312 0.258 0.215 0.178 0.149 0.1040.073 0.061 0.051 0.037 0.026 20 Period 0.811 0.660 0.538 0.439 0.359 0294 0.2420.1990.1640.135 0.093 0064 0.053 0.044 0.031 0.022 Peal WH MH Period 0.811 0.660 0.538 0.439 0.359 0.294 0 242 0.199 0.164 0.13 0.093 0.064 0.0530.044 0.031 0.022 21 Period 0.803 0.647 0.522 0.422 0.342 0.278 0.226 0.18 0.150 0.123 0.083 0.056 0.046 0.038 0.026 0.018 22 Period 10.795 0 634 0.507 0.406 0,326 0.262 0.211 0.170 0.138 0.112 0.074 0.049 0.040 0.033 0.022 0.015 23 Period 0.788 0.622 0.492 0.390 0.3100 2470.1970 158 0.126 0.102 0.066 0043 0.035 0.028 0.019 0.013 24 Period 0.780 0.610 0.478 0.375 0.295 0.2330 184 0.146 0.116 0.092 0.0590.038 0.030 0.024 0.016 0.010 125 Period 0.7720,598 0.464 0.361 0.281 0.220 0.172 0.13 0.106 0.084 0.053 0.033 0,0260.021 0.014 0.009 26 Period 0.764 0.586 0.4500 3470 268 0.207 0 161 0.125 0.098 0.076 0.047 0.029 0.0230018 0.0110.007 27 Period 0.757 0 574 0.437 0.333 0.255 0.196 0.150 0.116 0.090 0.069 0.042 0.026 0.0200.0160.0100,006 28 Period 0.7490.563 0.424 0.321 0 243 0.185 0.141 0.1070.082 0.063 0.037 0.022 0.017 0.014 0.008 0.005 al 20 WH 24 Period 25 0.780 0.610 0.478 0.375 0.295 0.233 0.184 0.146 0.116 0.092 0.059 0.038 0.030 0.024 0.016 0.010 Period 26 Period 27 Period 28 Period 29 Period 30 10.772 0.598 0.464 0.361 0.281 0.220 0.172 0.135 0.106 0.084 0.053 0.033 0.026 0.021 0.014 0.009 0.764 0.586 0.450 0.347 0.268 0.207 0.161 0.125 0.098 0.076 0.047 0.029 0.0230018 0.0110.007 0.757 0.574 0.437 0.333 0 255 0 196 0.150 0.116 0.090 0.069 00420.026 0.020 0.0160.0100.006 0.749 0.563 0.424 0.321 0.243 0.185 0.141 0.107 0.0820.063 0.037 0.022 0.017 0.014 0.008 0.005 07420562 0.412 0.308 0.231 0.174 0131 0.099 0.075 0.057 0.033 0.0200015 0.012 0.007 0.004 0.6720.453 0 307 0.208 0.142 0.097 0.067 0.046 0.032 0.022 0.011 0.005 0.0040.003 0.001 0.001 10 Period 40 Period 50 0.608 0.372 0.228 0.141 0.087 0.054 0.034 0.021 0.013 0.009 0.003 0.001 0.001 0.001 WE 1% 8% Present Value of Ordinary Annuity of S1 Periods 2% 3% 4% 5% 6% 7% 9% 10% 12% 14% 15% 16% 18% 20% Period 1 0.990 0.980 0.971 0.962 0.952 0.943 0.935 0.926 0.917 0.909 0.893 0.877 0.870 0.862 0.847 0.833 Period 2 1970 1942 1913 1.886 1.859 1.8331.808 1 783 1 759 1.736 1.6901.647 1.626 1.6051566 1.528 Period 3 2.941 2.884 2829 2775 2.723 2.673 2.624 2.577 2 531 2487 2.4022 322 2283 2246 2174 2106 Period 4 3.902 3.808 3.717 3.630 3.546 3.465 3.387 3.312 3.240 3.170 3.037 2.914 2.855 2.798 2.6902.589 Period 5 4853 4.713 4.580 4.452 4.3294212 4.100 3.993 3.890 3.791 3.605 3.433 3.352 3.274 3.127 2 991 Period 6 5.795 5601 5.417 5.2425.076 4.917 4.767 4.623 4.486 4355 4 111 3.889 3.784 3.685 3.498 3.326 Period 7 6.728 6.472 6230 6 002 5.786 5.582 5.3895 2065033 4868 4.564 4288 4.160 4.039 3.812 3.605 Period 8 76527325 7020 6733 6.463 6.210 5.97157475.535 5335 4.968 4.639 4.487 4344 4.078 3.837 Period 9 8,566 8.162 7 786 7.435 7 108 6.802 6.515 6 247 5.995 5.759 5 328 4 946 4.772 4.607 4.303 4031 Period 10 9 471 89838.530 8.111 7722 7360 7.024 6.710 6.418 6 145 5650 5216 5.0194.833 44944 192 Period 11 10 368 9.787 9253 8.760 8 306 7 887 7 499 7 139 6.805 6.495 5938 5 453 5 234 5 029 4656 4327 Period 12 11 255 10.575 9.954 93858 863 8.384 7943 7536 7.161 6.814 6.194 5660 5.421 5 1974793 4 439 Period 1312. 13411.348 10.635 9 986 9.394 8.853 8.358 7.904 74877 1036.424 5.842 5583 5.3424 910 4.533 Period 1413.00412 106 11 296 10.563 9.899 9295 8 745 8 244 778673676.628 6.002 5 7245.468 5008 4.611 Period 1513.86512 849 11938 11 11810 38097129 1088.559 8.061 7606 6 811 6 1421 5.8475575/5.092 4.675 0 WH WH pa Period 1614 71813 578 12 561 11652 10.83810 106 9.447 8.851 8.3137 824 6.9746.265 5.954 5.669 5.162 4.730 Period 1715.562 14.292 13.166 12 166 11 27410 477 9763 9.122 8.544 8.022 7.120 6.373 6.047 5.749 5222 4.775 Period 1816,39814 992 13.754 12 659 11.69010 828 10.059 9.372 8.756 8201 7.250 6 467 6.128 5.8185273 4.812 Period 1917 22615.678 14.324 13.1341208511 15810.336 9.604 8.950 8.365 7 366 6.550 6.198 58775316 4 844 Period 2018 04616,351 14.877 13.590 12.462 11 470 10.5949.818 9.129 8.514 7.469 6.623 6.259 5.9295353 4.870 Period 2118 857 17.011 15.415 14.02912.82111.764 1083610,017 9.292 86497562 6.687 6 312 5.973 5.384 4.891 Period 22 19.66017658 1593714 45113.16312.042 11 061 10.2019,442 8.772 7.645 6.743 6,359 6.011 5 410 4 909 Period 2320.45618,292 16.44414857 13.48912 303 11.272 10.371 9.580 8.883 7718 6792 6.399 6,044 5.432 4.925 Period 2421 24318 914 16.936 15 247 13 79912550 11.469 10.529 9.707 8.985 7 784 6.835 6.434 6.073 5451 4.937 Period 25 22.023 19.523 17 413 15 622 14.0941278311654 10.675 9.8239.07778436.873 6.464 6.097 5.467 4.948 Period 26227952012117 877 15.98314 3751300311 826 10 810 9.929 9.161 7.896 6.906 6.491 6.118 5.480 4956 Period 2723.56020 7071832716,33014,64313 21111.987 10.93510.027 9.2377 943 6.935 6,514 6.136 5.492 4964 Period 2824 31621 28118.764 16.663 14 89813 406 12.137 11.05110 116 9.307 7 984 6.961 6.534 6 152 5502 4970 Period 29 25.06621.844 19 188 16.984 15.14113.591/12.278 11 158 10.198 9.370 8.022 6.983 6551 6 166 5.510 4.975 Period 3025 80822 396 19.600 17.292 15,37213 765 12.409 11 258 10 274 9.427 8.055 7.003 6.566 6.177 5517 4.979 Period 40 32 83527 355 23 115 19.793 17 15915 04613.332 11.92510 757 9779 8 244 7.105 6.642 6233 5548 4.997 Period 50 39.19631 4242573021 482 18 25615.762 13.8011223310 962 9.915 8 3047133 6 661 6 246 5554 4.999 Yeal - 15. WH

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Sound Investing, Chapter 18 - Significant Accounting Policies And Changes In Them

Authors: Kate Mooney

3rd Edition

0071719407, 9780071719407

More Books

Students also viewed these Accounting questions