Answered step by step
Verified Expert Solution
Question
1 Approved Answer
= Homework: Module 8 Intro Assignment Question 13, TIM9-4 (si... Part 1 of 4 HW Score: 55.11%, 27.56 of 50 points O Points: 0 of
= Homework: Module 8 Intro Assignment Question 13, TIM9-4 (si... Part 1 of 4 HW Score: 55.11%, 27.56 of 50 points O Points: 0 of 6 Collins Company is considering a project with an initial investment of $599,500 that is expected to produce cash inflows of $130,500 for ten years. Collins's required rate of return is 10%. (Click on the icon to view Present Value of $1 table.) (Click on the icon to view Present Value of Ordinary Annuity of $1 table.) 14. What is the NPV of the project? 15. What is the IRR of the project? 16. Is this an acceptable project for Collins? 14. What is the NPV of the project? (Enter the factor amount to three decimal places, X.XXX. Round the present value of the annuity to the nearest whole dollar. Use parentheses or a minus sign for a negative net present value. Net Cash Annuity PV Factor Present Years Inflow (i=10%, n=10) Value 1 - 10 Present value of annuity 0 Investment Net present value Present Value of $1 5 % Periods 1% 2% 3% 4% 6% 7% 8% 9% 10% 12% 14% 15% 16% 18% 20% Period 1 0.990 0.980 0.971 0.962 0.952 0943 0.935 0.926 0.917 0.909 0.893 0.877 0.870 0.862 0.847 0.833 Period 2 0.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 3 0.971 0.942 0.915 0.8890.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.8230.792 0.763 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.681 0.650 0.621 0.567 0.519 0.497 0.476 0.437 0.402 Period 6 0.942 0.888 0.837 0.790 0.746 0.705 0.6660.630 0.596 0.564 0.507 0.456 0.432 0.410 0.370 0.335 Period 7 0.933 0.871 0.813 0.760 0.7110.665 0.623 0.583 0.547 0.513 0.452 0.400 0.376 0.354 0.3140.279 Period 8 0.923 0.853 0.789 0.731 0.677 0.627 0.5820.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.5440.500 0.460 0.424 0.361 0.308 0.2840263 0.225 0.194 Period 10 0.905 0.820 0.744 0.676 0.6140558 0.508 0.463 0.422 0.386 0.322 0.270 0.2470 227 0.1910.162 Period 11 0.896 0.804 0.722 0.650 0.585 0.527 0.475 0.429 0.388 0.350 0.287 0.237 0.215 0.195 0.162 0.135 Period 12 0.887 0.788 0.701 0.625 0.557 0.497 0.444 0.397 0.356 0319 0.257 0.208 0.187 0.168 0.137 0.112 Period 13 0.879 0.773 0.681 0.601 0.530 0.469 0.415 0.368 0.326 0.290 0.229 0.182 0.163 0.145 0.116 0.093 Period 14 0.870 0.758 0.661 0.577 0.505 0.442 0.388 0.340 0.299 0.263 0.205 0.160 0.141 0.125 0.099 0.078 Period 15 0.861 0.743 0.642 0.555 0.481 0.417 0.362 0.315 0.275 0.239 0.183 0.140 0.123 0.108 0.084 0.065 Period 16 0.853 0.728 0.623 0.534 0.458 0.394 0.3390.292 0.252 0.218 0.163 0.123 0.107 0.093 0.071 0.054 Period 17 0.844 0.714 0.605 0.513 0.436 0.371 0.317 0.270 0.231 0.198 0.146 0.108 0.093 0.080 0.060 0.045 Period 18 0.836 0.700 0.587 0.494 0.4160350 0.296 0.250 0.212 0.180 0.130 0.095 0.081 0.069 0.051 0.038 Period 19 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 Period 20 0.820 0.673 0.554 0.456 0.37703120.258 0.215 0.178 0.149 0.104 0.073 0.061 0.051 0.037 0.026 Present Value of Ordinary Annuity of $1 Periods 1% 2% 3% 4% 5% 6% 7% 8% 9% 10% 12% 14% 15% 16% Period 1 0.990 0.980 0.971 0.962 0.952 0.943 0.935 0.926 0.9170.9090.893 0.877 0.870 0.862 Period 2 1.970 1.942 1913 1.886 1.859 1.833 1.808 1.783 1.759 1.736 1.690 1.647 1.626 1.605 Period 3 2.9412.884 2.829 2.775 2.723 2.673 2.624 2.577 2531 2.487 2.4022322 2283 2246 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 Period 5 4.853 4713 4.580 4.452 4.329 4.212 4.100 3.993 3.890 3.791 3.605 3.433 3.3523274 Period 6 5.795 5.601 5.417 5.2425.076 4.917 4.767 4.623 4.486 4355 4.111 3.889 3.784 3.685 Period 7 6.728 6.472 6.230 6.002 5.786 5.582 5.389 5.20 5.033 4.868 4.564 4.288 4160 4.039 Period 8 7.652 7.325 7.020 6.733 6.463 6.2105.971 5.747 5.535 5.335 4.968 4.639 4.487 4.344 Period 9 8.566 8.1627.786 7.435 7.108 6.802 6.515 6.247 5.9955.759 5.328 4.946 4.7724.607 Period 10 9.471 | 8.983 | 8530 8.111 7.722 7.360 7.0246.710 6.418 6.145 5.6505.216 5.019 4.833 Period 11 10.368 9.7879.2538.760 8.306 7.887 7.499 7.139 6.805 6.495 5.938 5.453 5.234 5.029 Period 12 11.255 10.575 9.9549.3858.863 8.384 7.943 7.5367.1616.8146.1945.660 5.421 5.197 Period 13 12.134 11.348 10.635 9.986 9.394 8.853 8.358 7.9047.487 7.103 6.424 5.8425.583 5.342 Period 14 13.004 12.106 11.296 10.563 9.899 9.295 8.745 8.244 7.786 7.367 | 6.628 6.002 5.724 5.468 Period 15 13.865 12.849 11.938 11.118 10.380 9.712 9.108 8.559 8.061 7.606 6.811 6.142 5.8475575 Period 16 14.718 13.578 12 561 11.652 10.838 10.106 9.447 8.851 8.313 7.8246.9746.265 5.954 5.669 Period 17 15.562 14.292 13.166 12.166 11.274 10.477 9.763 9.122 8.544 8.022 7.1206.373 6.047 5.749 Period 18 16.398 14.992 13.754 12.659 11.690 10.828| 10.059 9.372 8.756 8.2017.250 6.467 | 6.128 5.818
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started