Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please show all work and EQUATIONS on excel. Required information The Chapter 14 Form worksheet is to be used to create your own worksheet version
please show all work and EQUATIONS on excel.
Required information The Chapter 14 Form worksheet is to be used to create your own worksheet version of Example E and Exhibit 14.8 In the text. Download the Applying Excel form and enter formules in all cells that contain question marks. For example, in cell C21 enter the formula - 810 Note: The present value factors could be computed using the built-in Excel function PV, but we recommend using the formulas in Appendix 148. Verlty that your worksheet matches the example in the text Check your worksheet by changing the discount rate to 10%. The net present value should now be between $56,400 and $56,535-depending on the precision of the calculations. If you do not get an answer in this range find the errors in your worksheet and correct them. If you did not use formulas to calculate the Discount Factors, be sure that those values are updated appropriately using the Appendix 148 formulas that are also noted at the bottom of the spreadsheet instead of using the Discount Factor tables. Click here to view Exibit 148.) and Exit 18:2. to determine the appropriate discount factory using tables, Sove your completed Applying Excel form to your computer and then upload it here by clicking "browie." Next, click "Sove. You will use this worksheet to answer the questions in Part 2 ECHIBIT 40-1 Precent Value of St Periods 19 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 15 17 18 19 20 21 22 23 24 25 28 27 28 29 30 40 4 5% 65 7 0% 99 10% 10% 12 135 54% 15% 16% 17% 18% 20% 20 22 23 24 259 0.962 0952 0.943 0935 0.926 0917 0.909 0.901 0.893 0.885 0.877 0.870 0.862 0.855 0.847 0940 0.8330826 0820 0.83 0.006 0.800 0.925 0.907 0.890 0.873 0.857 0.842 0.826 0.812 0797 0.783 0789 0.756 0.743 0.731 0.718 0.706 0.694 0.683 0.672 0.661 0650 0.640 0.889 0.864 0.840 0.816 0.794 0772 0751 0731 07120693 0675 0658 0.641 0624 0609 0.593 0.579 0.564 0.551 0.537 0.524 0.512 0.855 0.823 0.7920763 0735 0.708 0683 0.659 0.636 0.6130592 0.572 0.552 0534 0.50 0.499 0482 04670451 0.437 0.423 0.450 0.822 0.784 0.747 0713 0681 0.650 0.621 0.593 0.567 0.543 0519 0.497 0.476 0456 0.437 0.419 0402 0.386 0.370 0.355 0.341 0.328 0.790 0.746 0.705 0.666 0.630 0596 0564 0.535 0507 0.480 0.456 0432 04100390 0.370 0352 0.335 0.319 0.303 0.289 0275 0.262 0.750 0711 0.665 0.623 0583 0547 0.5130482 0.452 0.425 0.000 0.375 0.354 0333 03140295 0279 0.263 0249 0235 0.222 0.210 0731 0.677 0.627 0.582 0540 0.502 0.467 0.434 0.404 0.376 0.351 0.327 0.305 0.285 0.266 0.249 0233 0.21 0.204 0.191 0179 0.168 0.703 0645 0.592 0544 0.500 0.460 0.424 0.391 0.361 0.333 0308 0.284 0 263 0.243 0.225 0.209 0194 0.180 0.167 0.1550144 0134 0.676 0.614 0.558 0.508 0.463 0.422 0.386 0352 0322 0.295 0.270 0.247 0.227 0208 0.191 0.176 0162 0:149 0.137 0126 0176 0.107 0.650 0.505 0.527 0.475 0.429 0388 0.350 0317 0.287 0.261 0237 0215 0195 0178 0.162 0000135 0123 0.112 0.1030094 0006 0.625 0.557 0.497 0.444 0.397 0356 0.319 02860257 0231 0.208 0.587 0.168 0.152 0137 0124 0.112 0.1020.092 0.003 0.076 0.009 0.601 0.530 0469 0.415 0.368 0326 0.290 0258 0.229 0.204 0.182 0163 0145 0130 0.116 0.104 0093 0.084 0.075 0.008 0.001 0.055 0.577 0.505 04420388 0.340 0.299 0263 0.232 0205 0.181 0.360 0541 0125 0.111 0099 0.088 0.078 0.069 0.062 0.055 0.049 0044 0555 0.481 0.417 0.362 0.315 0.275 0.239 0.209 0.183 0.160 05400123 0108 0.095 0.084 0.074 0065 0,057 0.051 0.045 0.040 0.035 0534 0.458 0.394 0.339 0.292 0.252 0.218 0.188 0163 0.141 0123 0107 0.093 0.081 0.07 0.062 0.054 0.047 0042 0.036 0.032 0.028 0500436 0.371 031702700231 0198 0170 0.146 0125 0908 0093 0.000 0.000 0.060 0,052 0045 0.039 0.034 0.030 0.025 0.023 0.494 0.446 0.350 0296 0.250 0.212 01800150 0.130011 0095 0.001 0.00 0.059 0.051 0044 0030 0032 0.025 0.024 0.021 0.01 0.475 0.396 0331 0.277 0232 0194 040138 0116 0.09 0.083 0.070 0.000 0.051 0,043 0.037 0031 0,027 0.023 0.0200.01 0014 0.456 0.377 0.12 0.250 0.215 017009490124 01040087 0.073 0.061 0.051 0043 0.037 0.031 0.028 0.022 0.019 0.01 0.01 0.012 0.439 0359 0.294 0242 0.199 0164 0135 0.12 0.003 0.077 0064 005 0044 0.037 0.031 0.026 0022 0.01 0.0150010001 0.009 04220342 0.2790226 0154 01500123 0101 0.083 0.068 0056 0016 0.038 00320026 0.022 00 00150013 0.01 0.000 0.007 0406 0.326 0.262 0211 0.170 008 0.112 00910074 0.000 0.049 0.040 0.033 0.027 0022 0.018 0015 0.012 0010 0.009 0.007 0.006 0390 0.310 0.247 0.197 0.1580126 0.002 0.002 0.066 0.053 0.043 0.035 0.028 0.023 0.01900150000.010 0.008 0.007 0.006 0.005 0.375 0.295 0.233 0.134 0.146 0.116 0.092 0.074 0.059 0.047 0.000 0.030 0.024 0.0200.0% 0.00 0.00 0.00 0.007 0.006 0.005 0.004 0,361 0.281 0.220 0172 0.125 0.106 0034 0006 0.053 0.042 0.033 0.025 0.021 0017 0054 0.01 0009 0.007 0006 0.005 0.004 0003 0347 0.268 0.207 0181 0.125 0.098 0.076 0.060 0047 0.037 0029 0023 0.018 0.014 0011 0.009 0.007 0.006 0.005 0.004 0.003 0.002 0330 0.255 0.1960.1500116 0.090 0.069 0054 0042 0.033 0.025 0.0200.0160012 0.000 0.008 0006 0.005 0004 0.003 0.002 0002 0321 0.243 0185 0141 0107 0,082 0063 0048 0.037 0.029 0,022 0.01 0.014 0.01 0008 0.006 0.005 0.004 0.003 0.002 0.002 0.002 0.308 0.231 0.174 0131 0.099 0.025 0.057 0.044 0.033 0.026 0.020 0,015 0.012 0.009 0.007 0.005 0.004 0.003 0.003 0.002 0.002 0.001 0.208 0342 0.097 0.067 0.046 0.032 0.022 0.015 0.06 0.008 0.005 0.0040.003 0.002 0.001 0.001 0.001 0.000 0.000 0.000 0.000 0.000 888888 EXHIBIT 140-2 Procent Value of an Annulty of $1 in Arroers: Periods 1 2 4 5 6 7 9 10 12 6.16 14 15 wn m 55 6 7 8% 95 10% 115 12% 13% 14% 15% 165 175 16 199 20% 225 239 24% 25 0.962 0.952 0943 0.935 0.926 0917 0.009 0.901 0.893 0.885 0877 0.870 0.862 0.855 0.847 0.840 0.833 0.826 0820 0,813 0805 0.800 1836 1859 1833 1806 TEA 1759 1736 1690 1668 1647 1626 16051585 1566 1547 1528 1509 1492 1474 1457 1440 2775 2723 2673 2624 2577 2531 2.487 2444 2402 2361 2,322 2283 2246 2210 2174 2140 2106 2.074 2042 2011 1.981 1952 3630 3.546 3.465 3.387 3.312 3.240 0 3102 3.037 2.974 2.914 2.855 2.798 2.743 2.690 2.639 2589 2.540 2494 2448 2404 2.362 4.452 4329 4.212 4.500 3.993 3.890 3.791 3.696 3.605 3.517 3.433 3352 3.274 31993.127 3058 2.991 2926 2864 2.803 2.745 2689 5.242 5076 4917 4767 4.623 4.456 4355 4231 411 3.9983889 3784 3685 3.589 3.498 3410 3:326 3.245 31673092 3020 2.951 6.002 5786 5.582 5389 5.200 5.033 4.868 4712 4564 4.423 4288 4.160 4029 3.922 3.812 3706 3.605 3.508 3.416 3.327 3.242 3161 6.733 6.463 6.290 5.971 5.747 5.535 5.335 51484968 4799 4839 4487 43444 207 4078 3954 3.837 3.726 3619 3.518 3421 3.329 7435 7108 0.802 6515 6.247 5.995 5759 5537 5328 5.132 4946 4772 4607 4.451 4303 4163 4.031 3.905 3786 3.673 3.566 3.463 8111 7.722 7360 7024 6.790 6.418 6.145 5.889 5650 5426 5 216 5.099 4833 4659 4494 4329 4.192 4054 2923 3.799 3682 3.571 8.760 8.306 7887 7490 7139 6.805 6.495 5.207 5.938 5.687 5.453 5.234 50294.8364656 4496 4.327 4.1774.035 3.902 3.775 3.656 9.385 8863 8.384 7943 2536 7161 6.492 6.194 5.918 5.660 5.421 5.197 4.988 47934671 4.439 4.278 4.1273.985 3.851 3.725 9.996 9.394 8.853 8350 7.904 7487 2100 6.750 6.424 6.122 5.842 5583 5.342 5.118 4.910 471 4.533 4.362 4203 4053 3.912 3.780 10563 9.899 9.295 8745 8.244 7786 7367 6.902 6.628 6.302 6.002 5.724 5.468 5.229 5.008 4.802 4.671 4.432 4.205 4108 3.962 3.824 10.380 9.712 9.108 8.5598.061 7606 7191 6.871 6462 6142 5.847 5.575 5.324 5.092 4876 4675 4.489 4315 4153 4.001 3.859 11652 10.838 10.106 9.447 8.851 8.313 7824 73796.974 6604 6.265 5.954 5668 5.405 51624938 4.730 4536 4357 4189 4033 3.537 12.156 11.274 10.477 9763 9.122 8.544 3.022 7549 2120 6.729 6373 6047 5749 5.475 5.222 4.990 4775 4575 4.391 4219 4059 3.910 12.659 1690 10828 10-059 9372 8.756 3.201 7702 72505.840 6.457 6.128 580 5534 5.273 5.033 48124608 4.419 4243 090 3928 12134 12.005 11158 10.336 9.004 8.950 1.365 7839 73668.938 6.550 6.1905.877 5.584 5.316 5.070 4.8434635 4442 4.263 4.097 3.942 13.590 12.462 11470 10594 9.818 9.129 8.514 2963 74697025 6,623 6.259 5.929 5.628 5.353 51014870 4657 4.460 42794110 3.954 14029 12.821 11764 10.838 10097 9292 8.649 8.075 756271026.687 6.312 5973 5665 5384 51274891 4675 4.476 4292 4121 3.963 14.451 13.163 12.042 1001 10 201 9.442 3.772 8.170 2645 2170 6.743 6.399 6011 5.696 5410 5149 4.909 4090 4458 4.302 4130 3.970 14857 13.489 12.303 11272 10371 9.580 8.883 8.2667718 7230 6.792 6.399 6.044 5723 5.432 51674.925 4703 4.499 4311 4137 3.976 15.247 13.799 12.550 11469 10.529 9.701 8.985 8.340 7734 7283 6.835 6.434 60735746 5.45151824937 4713 4.507 4318 410 3.901 15.622 14094 12783 1654 10.6759820 9.077842278437330 6.573 6.464 6.097 5.766 5.467 519549484721 45144323 4147 3.985 15983 14375 13.000 1126 10810 9.929 9161 40 7096 2372 6906 6491 6118 57835.430 5205 4956 4720 4520 43284151 2980 1633014647 3211 1987 10:935 10.027 9.237 8548 7943 74096.935 6.514 6136 5798 5.492 5215 4964 4734 4.524 4.3324154 3.990 16.663 14.89 13.406 12.37 11051 10.116 9.307 8.602 2984 2441 6.901 6.534 61525.810 5.502 5.223 4970 4739 4.528 43354157 3992 16.984 15:41 13591 12.278 11158 10.198 9.3708650 8.022 7470 6993 6.551 6.166 5820 5.50 5.229 4.975 4743 4531 43374159 3.994 1729215372 13765 12.409 11258102749427 8.694 8.055 2496 2003 6556 6177 5.829 5:517 5235 49794745 4534 43394100 3.995 19.793 12:59 15.046 332 11.925 107579.7798951 8.244 7634 2105 642 6233 5.8715.548 5258 49974760454 4347 4.106 3.999 19 20 22 23 24 25 20 27 28 29 30 40 2. The company is considering a project involving the purchase of new equipment Change the data area of your worksheet to match the following: Use Exhibit 148 1 and Exhibit 143-2. (Use appropriate factor(s) from the tables provided.) Chapter 14: Applying Excel 1 2 3 4 5 6 7 8 9 $ $ Data Example E Cost of equipment needed Working capital needed Overhaul of equipment in four years Salvage value of the equipment in five years Annual revenues and costs Sales revenues Cost of goods sold Out-of-pocket operating costs Discount rate 340,000 30.000 20,000 30,000 $ $ $ $ 10 11 12 13 380,000 225,000 50,000 16% S a. What is the net present value of the project? (Negative amount should be indicated by a minus sign. Round your present value factor to 3 decimals and round all other intermediate calculations to nearest whole dollar.) Not procent value 2,378 c. The internal rate of return is between what two whole discount rates (e.g., between 10% and 11%, between 11% and 12%, between 12% and 13%, between 13% and 14%, etc.)? The internal rate of return is between 16% and 17 % d. Reset the discount rate to 16%. Suppose the salvage value is uncertain. How large would the salvage value have to be to result in a positive net present value? Minimum salvage value required to generate a positive present value 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