Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

could you solve this problem please!!! Required information Chapter 12: Applying Excel Step 1: Download the Applying Excel form located on the left-hand side, under

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
could you solve this problem please!!!
Required information Chapter 12: Applying Excel Step 1: Download the Applying Excel form located on the left-hand side, under files. If you have trouble, the file is also located in D2L under Course Administration Step 2: Then enter formulas in all cells that contain question marks. For example, in cell C21 enter the formula - B10". Important Note: The present value factors could be computed using the built-in Excel function PV, but we recommend using the formulas in Appendix 138. Step 3: 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 13B formulas that are also noted at the bottom of the spreadsheet instead of using the Discount Factor tables Step 4: Proceed to the requirements below only after completing your worksheet as it will be used to answer the following questions. Click here to view Exhibit 138-1 and Exhibit 138-2. to determine the appropriate discount factor(s) using tables. Chapter 12: Applying Excel: Exercise 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 12B-1 and Exhibit 12B-2. (Use appropriate factor(s) from the tables provided.) $ $ A 1 Chapter 12: Applying Excel 2 3 Data 4 Example E 5 Cost of equipment needed 6 Working capital needed 7 Overhaul of equipment in four years 8 Salvage value of the equipment in five years 9 Annual revenues and costs: 10 Sales revenues 11 Cost of goods sold 12 Out-of-pocket operating costs 13 Discount rate 380,000 50,000 25,000 30.000 $ $ $ $ $ 440,000 280,000 55,000 11 % 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.) Net present value 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 % and d. Reset the discount rate to 11%. 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 net present value EXHIBIT 138-2 Present Value of an Annuity of 1 in Arrears, (1+1 Periods 9% -NM 4 5 6 7 8 9 10 12 13 14 15 5% 7% 10% 11% 12% 13% 14% 15% 16% 17% 18% 19% 20% 21% 22% 23% 24% 25% 0.962 0.952 0.943 0.935 0.926 0.917 0.909 0.901 0.893 0.885 0.877 0.870 0.862 0.855 0.847 0.840 0.833 0.826 0.820 0.813 0.806 0.800 1.886 1.859 1.833 1.808 1.783 1.759 1.736 1.713 1690 1.668 1.647 1.626 1.605 1.585 1.566 1.547 1.528 1.509 1.492 1.474 1.457 1.440 2775 2.723 2.673 2.624 2.577 2.531 2.487 2444 2.402 2361 2.322 2283 2246 2210 2.174 2.140 2.106 2.074 2.042 2.011 1.981 1.952 3.630 3.546 3.465 3.387 3.312 3.240 3.170 3.102 3.037 2974 2.914 2855 2.798 2743 2690 2.639 2589 2540 2.494 2.448 2.404 2.362 4.452 4.329 4212 4.100 3.993 3.890 3.791 3.696 3.605 3.517 3.433 3.352 3.274 3.199 3.127 3.058 2.991 2.926 2.864 2.803 2.745 2.689 5.242 5.076 4.917 4.767 4.623 4.486 4.355 4.231 4.111 3.998 3.889 3.784 3.685 3.589 3.498 3.410 3.326 3.245 3.167 3.092 3.020 2.951 6.002 5.786 5.582 5.389 5.206 5.033 4.868 4.712 4.564 4.423 4.288 4.160 4.039 3.922 3.812 3.706 3.605 3.508 3.416 3.327 3.242 3.161 6.733 6,463 6.210 5.971 5.747 5.535 5335 5.146 4.968 4.799 4.639 4.487 4.344 4 207 4.078 3.954 3.837 3.726 3.619 3.518 3.421 3.329 7.435 7.108 6.802 6.515 6.247 5.995 5.759 5537 5328 5.132 4.946 4.772 4.607 4.451 4.303 4.163 4.031 3.905 3.786 3.673 3.566 3.463 8.111 7.722 7.360 7.024 6.710 6.418 6.145 5.889 5.650 5.426 5216 5.019 4.833 4.659 4.494 4.339 4.192 4.054 3.923 3.799 3.682 3.571 8.760 8.306 7.887 7.499 7.139 6.805 6.495 6.207 5.938 5.687 5.453 5.234 5.029 4.836 4.656 4.486 4.327 4.177 4.035 3.902 3.776 3.656 9.385 8.863 8.384 7943 7.536 7.161 6.814 6.492 6.194 5.918 5.660 5.421 5.197 4.988 4.793 4.611 4 439 4.278 4.127 3.985 3.851 3.725 9.986 9.394 8.853 8.358 7.904 7.487 7.103 6.750 6.424 6.122 5.842 5583 5 342 5.118 4.910 4.715 4.533 4.362 4.203 4.053 3.912 3.780 10.563 9,899 9.295 8.745 8 244 7.786 7.367 6.982 6.628 6.302 6.002 5.724 5.468 5.229 5.000 4.802 4.611 4.432 4.265 4.108 3.962 3.824 11.118 10.380 9.712 9.108 8.559 8,061 7.606 7.191 6811 6.462 6.142 5.847 5.575 5.324 5.092 4.876 4.675 4.489 4.315 4.153 4,001 3.859 11.652 10.838 10.106 9.447 8.851 8.313 7.824 7.379 6.974 6.604 6.265 5.954 5.668 5.405 5.162 4.938 4.730 4.536 4.357 4.189 4.033 3.887 12.166 11.274 10.477 9.763 9.122 8.544 8.022 7549 7.120 6.729 6.373 6.047 5.749 5.475 5.222 4.990 4.775 4.576 4.391 4.219 4.059 3.910 12.659 11 690 10.828 10.059 9.372 8.756 8201 7.702 7.250 6.840 6.467 6.128 5818 5.534 5.273 5.033 4.812 4.608 4.419 4.243 4.080 3.928 13.134 12.085 11.158 10.336 9.604 8.950 8.365 7.839 7.366 6.938 6,550 6.198 5.877 5.584 5.316 5.070 4.843 4.635 4.442 4.263 4,097 3.942 13.590 12.462 11.470 10.594 9.818 9.129 8.514 7.963 7.469 7.025 6.623 6.259 5.929 5.628 5.353 5.101 4.870 4.657 4.460 4.279 4.110 3.954 14.029 12.821 11.764 10.836 10.017 9.292 8.649 8.075 7.562 7.102 6.687 6.312 5.973 5.665 5.384 5.127 4 891 4.675 4.476 4.292 4.121 3.963 14.451 13.163 12.042 11.061 10.201 9.442 8.772 8.176 7.645 7.170 6.743 6.359 6,011 5.696 5.410 5.149 4.909 4.690 4.488 4.302 4.130 3.970 14.857 13.489 12.303 11 272 10.371 9.580 8.883 8.266 7.718 7230 6.792 6.399 6,044 5.723 5.432 5.167 4.925 4.703 4.499 4.311 4.137 3.976 15.247 13.799 12550 11.469 10.529 9.707 8.985 8.348 7.784 7283 6.835 6.434 6.073 5.746 5.451 5.182 4.937 4.713 4.507 4.318 4.143 3.981 15.622 14.094 12783 11.654 10.675 9.823 9.077 8.422 7.843 7.330 6.873 6.464 6,097 5.766 5.467 5.195 4.948 4.721 4.514 4.323 4.147 3.985 15.983 14,375 13.003 11.826 10.810 9.929 9.161 8.488 7.896 7.372 6.906 6.491 6.118 5783 5.480 5,206 4,956 4.728 4.520 4.328 4.151 3.988 16.330 14.543 13 211 11.987 10.935 10.027 9.237 8.548 7.943 7.409 6.935 6.514 6.136 5.798 5.492 5.215 4.964 4.734 4.524 4.332 4.154 3.990 16.663 14.898 13.405 12.137 11.051 10.116 9.307 8.602 7.984 7.441 6.961 6,534 6.152 5.810 5.502 5.223 4.970 4.739 4.528 4.335 4.157 3.992 16.984 15.141 13.591 12278 11.158 10.198 9.370 8.650 8.022 7.470 6.983 6551 6.166 5.820 5.510 5.229 4.975 4.743 4.531 4.337 4.159 3.994 17.292 15.372 13.765 12.409 11.258 10.274 9.427 8.694 8.055 7.496 7.003 6.566 6.177 5.829 5.517 5.235 4.979 4.746 4.534 4,339 4.160 3.995 19793 17.159 15.046 13 332 11.925 10.757 9.779 8.951 8.244 7.634 7.105 6.642 6.233 5.871 5.548 5.258 4,997 4760 4,544 4,347 4.166 3.999 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 40 EXHIBIT 122-1 Present Value of St. Periods 4% 5% 7 8% 9% 10% 11% 12% 13% 14% 15% 16% 18% 19% 20% 21% 22% 23% 24% 25% 1 0 962 0952 0943 0935 0926 0917 0909 0901 0893 0885 0877 08700862 0855 08470840 0.833 0826 0.820 0.813 0806 0800 2 0.925 0907 0890 0.873 0.857 0842 0826 0812 0797 0783 0769 0756 0743 0731 0718 0706 0.694 0683 0672 0.661 0.650 0640 3 0.889 0.864 0.840 0.816 0.794 0.772 0.751 0.731 0712 0.693 0.675 0.658 0641 0624 0.609 0.593 0.579 0564 0.551 0537 0.524 0.512 4 0.855 0823 0.792 0763 0.735 0.708 0683 0.659 0636 0613 0.592 0.572 0.552 0534 0516 0.499 0482 0.467 0451 0437 0423 0.410 5 0822 0784 0.747 0713 0681 0650 0621 0593 0567 0543 0.519 0497 0476 0456 0437 0419 0402 0386 0,370 0355 0.341 0328 6 0790 0.746 0705 0.666 0.630 0.596 0564 0535 0.507 0480 0.456 0.432 0.410 0390 0.370 0352 0.335 0319 0303 0289 0275 0262 7 0.760 0711 0.665 0.623 0583 05470513 0.482 0.452 0425 0.400 0376 0.354 0333 0314 0.296 0279 0263 0249 0235 0222 0210 8 0731 06770627 0.582 0540 0502 0.467 0.434 0.404 0376 0351 0327 0.305 0285 0.256 0249 0.233 0218 0204 0191 0179 0168 9 0.703 0645 0.592 0544 0.500 0460 0.424 0.391 0361 0333 0.308 0.284 0263 0243 0.225 0.209 0.194 0.180 0167 0155 0.144 0.134 10 0676 0614 0.558 0508 0463 0.422 0.386 0352 0322 0295 0270 0247 0227 0208 0191 0176 0.162 0149 0137 0126 0116 0107 11 0650 0585 0527 0475 0429 0388 0.350 0.317 0287 0.261 0237 0215 0195 0178 0162 018 0135 0123 012 0103 0.094 0086 12 0625 0557 0497 0.444 0.397 0356 0.319 0286 0257 0231 0.208 0187 0168 0152 01370124 01120102 0092 0.0830076 0069 13 0601 0530 0469 04150368 0326 0.290 0.258 0229 0204 0.182 0163 014501300115 0104 0.093 0084 0075 0068 0.061 0055 14 0577 0.505 0442 0.388 0.340 0299 0263 0232 0205 0181 0160 0141 01250111 0099 0.088 0.078 0.069 0.062 0055 0.049 0.044 15 0555 0481 0417 0362 0315 0275 0239 0209 0183 016001400123 0108 0095 0084 0074 0065 0057 0051 0045 0040 0035 16 0.534 0.458 0.394 0.339 0.292 0252 0218 0.188 0.163 0.141 012301070093 0.081 0.071 0.062 0.054 0047 004200360032 0.028 0513 0.436 0371 0.317 0270 0231 0198 01700146 01250108 0.093 00800069 00600052 0045 0039 0.034 0.030 0026 0023 18 0.494 0.4160350 0296 0.250 0212 01800153 0.130 0.111 0.095 0.081 0.069 0059 0051 0044 0038 0032 0028 0024 0.021 0.018 19 0475 0396 0331 0.277 0232 0194 0164 0138 0.116 0098 0.083 0.070 0060 0051 0043 0.037 0.031 0027 0023 0.020 001 0.01 20 0456 0377 0312 0258 02150178 019 0124 0104 0.087 0.073 0061 0.051 0.013 0037 0.031 0.026 0022 0.019 0016 0.01 0.012 21 0439 0359 0294 0242 0199 0164 0.135 01120093 0077 0.064 0053 0044 0.037 0.031 0026 0.022 0018 0.015 0013 0011 0009 22 0422 0342 0278 0226 0184 015001230101 0083 0068 0056 0046 0038 0032 0.026 0022 0018 00150013 0011 0009 0007 23 0406 0326 0262 0211 0170 0138 0112 0.091 0.074 0060 0049 00400033 0027 0022 0.01 0015 0012 0010 0009 0.007 0006 24 0390 0310 0247 0197 0158 01260102 0082 0066 0053 0043 0035 0.028 0.023 0.0190015 0.013 0010 0.008 0.007 0.006 0005 25 0.375 0295 02330184 0.146 0.116 0.092 0074 0.059 0047 0038 0.030 0024 0.0200016 0.013 0010 0.009 0.007 0.006 0005 0.004 26 0361 0281 0220 0.172 01350106 0.084 0066 0053 0042 0033 0026 0.021 0.017 001 0011 0009 0007 0006 0005 0004 0003 27 0347 0268 0.207 0161 0125 0098 00760060 0047 0037 0029 0023 0018 00140011 0009 0007 0.006 0005 0004 0003 0002 28 0333 0255 0196 01500116 0090 0.069 0054 0042 0033 0026 0020 0016 0012 0010 0008 0006 0005 0.004 0003 0002 0.002 29 0321 02430185 0.141 0.107 0082 0063 0048 0037 0029 0022 0017 001 0011 0008 0006 0005 0004 0003 0002 0.002 0002 30 0,308 0231 0174 0131 0099 007600620044 0033 0.026 0020 0,015 0012 0.009 0.007 0005 0004 0003 0003 0.002 0.002 0.001 40 0208 0142 0097 0.067 0046 00 U15 0011 0008 0.005 0004 0.003 0002 0001 0.001 0.001 0000 0000 0000 0000 0000

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

Internet Fraud Casebook

Authors: Joseph T. Wells

1st Edition

0470643633, 9780470643631

More Books

Students also viewed these Accounting questions