Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please show formula VESEN Su Required information The Chapter 12 Form worksheet is to be used to create your own worksheet version of Example E
please show formula
VESEN Su Required information The Chapter 12 Form worksheet is to be used to create your own worksheet version of Example E and Exhibit 128 in the text Download the Applying Excel form and enter formulas in all cells that contain question marks For example, in cell 21 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 138 Verify 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 138 formulas that are also noted at the bottom of the spreadsheet instead of using the Discount Factor tables This question will be sent to your instructor for grading EXHIBIT 12-8 The Net Present Value Method--An Extended Example 1 B 2 D G Now 2 3 Purchase of equipment 5 $ (60,000) 4 Investment in working capital $ (100,000) 5 Sales $ 200,000 $ 200,000 $ 200,000 $ 200,000 $200,000 6 Cost of goods sold S(125,000) S(125,000) S(125,000) 5 (125,000) 5(125,000 7 Out-of-pocket costs for salaries, advertising, etc. $ (35,000) $ (35,000) S (35,000) S 135,000) 5 135,000) 8 Overhaul of equipment $ 15,000) 9 Salvage value of the equipment $10.000 10 Working capital released $ 100,000 11 Total cash flows (a) $ (160,000) S40,000 $40,000 $40,000 $35,000 5 150,000 12 Discount factor (1496) (b) 1.000 0.877 0.769 0.675 0.5925 0519 13 Present value of cash flows (a) (b) $ (160,000) S 35,080 S 30,760 $ 27,000 520.720 5 77,850 14 Net present value (SUM B13:613) $ 31,410 15 16 Note: The discount factors come from Exhibit 128-1 in Appendix 128 12- Help Save & Exit Required information Verify 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 138 formulas that are also noted at the bottom of the spreadsheet instead of using the Discount Factor tables Click here to view Exhibit 13B-1 and Exhibit 138-2, to determine the appropriate discount factoris) using tables. Save your completed Applying Excel form to your computer and then upload it here by clicking "Browse." Next, click "Save. You will use this worksheet to answer the questions in Part 2 upload a response file (15MB max) EXHIBIT 130-1 Present Value of te Periods 416 5% 7% 89 99, 106 119 12% 131 14% 15% 16% 17% 18% 19% 20% 21% 22% 235 243 26% 1 0.962 0.952 0.943 0.935 0.926 0917 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.005 0.800 2. 0.925 0907 0.890 0.873 0.857 0.842 0826 0.812 0.797 0.783 0.769 0.756 0.743 0.731 0.718 0.706 0.694 0.683 0.672 0661 0.650 0.540 3 0.889 0.064 0.840 0.816 0.794 0.772 0.751 0.731 0.712 0.693 0.675 0.658 0.641 0.624 0.609 0.593 0.579 0.554 0551 0.537 0.524 0.512 0.855 0.823 0.792 0.763 0.735 0.708 0.683 0659 0.636 0.613 0.592 0.572 0.552 0.534 0.516 0.499 0.482 0.467 0.451 0.437 0.423 0.410 0.822 0.784 0.747 0.713 0.681 0.650 0.621 0.593 0.567 0.543 0.519 0.497 0.476 0.456 0.437 0.419 0.402 0.386 0.370 0.355 0.341 0.328 6 0.790 0.746 0.705 0.666 0.630 0.596 0.564 0.535 0.507 0.480 0.456 0.432 0.410 0.390 0.370 0 352 0 335 0.319 0303 0.289 0.275 0.262 7 0.760 0.711 0.665 0.623 0.583 0.547 0.513 0482 0452 0.425 0.400 0.376 0.354 0.333 0.314 0.296 0 279 0.263 0.249 0.235 0 222 0.210 8 0.731 0.677 0.627 0.582 0.540 0.502 0.467 0.434 0.404 0.376 0.351 0.327 0.305 0.285 0.266 0.249 0 233 0.218 0.204 0.191 0.179 0.168 9 0.703 0645 0.592 0.544 0.500 0.460 0.424 0.391 0.361 0.333 0.308 0.284 0.263 0.243 0.225 0.209 0.194 0.180 0.167 0.155 0.144 0.134 10 0.676 0614 0.558 0.508 0.463 0.422 0.386 0.352 0.322 0.295 0.270 0.247 0.227 0.208 0.191 0.176 0.162 0.149 0.137 0.126 0.116 0.107 0.650 0.585 0.527 0.475 0.429 0.388 0.350 0.317 0.287 0.261 0.237 0.215 0.195 0.178 0.162 0.148 0.135 0.123 0.112 0.103 0.094 0.086 12 0.625 0.557 0.497 0.444 0 397 0.356 0.319 0.286 0.25% 0.231 0.208 0.187 0.168 0.152 0.137 0124 0.112 0.102 0.092 0.083 0.076 0.069 13 0601 0530 0.469 0.415 0.368 0.326 0.290 0.258 0.229 0.204 0.182 0.163 0.145 0.130 0.116 0.104 0.093 0.084 0.075 0.068 0.061 0.055 14 0.577 0.505 0.442 0.388 0.340 0.299 0.263 0.232 0.205 0.181 0.160 0.141 0.125 0.111 0.099 0.008 0.078 0.069 0.062 0.055 0.049 0.044 15 0.555 0 481 0.417 0.362 0.315 0.275 0.239 0.209 0.183 0 160 0.140 0.123 0.108 0.095 0.084 0,074 0.065 0.057 0.051 0.045 0.040 0.035 16 0.534 0.458 0.394 0.339 0.292 0.252 0.218 0.188 0.163 0.141 0.123 0.107 0.093 0.081 0.071 0.062 0.054 0.047 0.042 0.036 0032 0.028 17 0.513 0.436 0.371 0.317 0.270 0.231 0 198 0.170 0.146 0.125 0.108 0.093 0.080 0.069 0.060 0,052 0.045 0.039 0.034 0.030 0026 0.023 18 0.494 0416 0.350 0.296 0.250 0.212 0.180 0.153 0.130 0.111 0.095 0.081 0.069 0.059 0.051 0044 0.038 0.032 0.028 0.024 0.021 0.018 19 0.475 0.396 0.331 0.277 0.232 0.194 0.164 0.138 0.116 0.098 0.083 0.070 0.060 0.051 0.043 0.037 0.031 0.027 0023 0.020 0017 0014 20 0.456 0.377 0.312 0.258 0.215 0.178 0.149 0124 0 104 0.087 0.073 0.061 0.051 0.043 0.027 0,031 0.026 0.022 0.019 0.016 0014 0012 21 0.439 0.359 0.294 0 242 0 199 0 164 0.135 0.112 0.093 0.077 0.064 0.053 0.044 0.037 0.031 0.025 0.022 0.018 0.015 0.013 0.011 0.009 22 0.422 0.342 0.278 0.226 0.184 0.150 0.123 0.101 0.083 0.068 0.056 0.046 0.038 0.032 0.026 0.022 0018 0.015 0.013 0.011 0.009 0.007 23 0.406 0.326 0.262 0.211 0.170 0.138 0.112 0.091 0.074 0.060 0.049 0.040 0.033 0.027 0.022 0.018 0.015 0.012 0.010 0.009 0.007 0.006 24 0.390 0310 0.247 0.197 0.158 0.126 0.102 0.082 0.066 0.053 0043 0.035 0.025 0.023 0.019 0.015 0013 0010 0.008 0.007 0.006 0005 25 0.375 0.295 0.233 0.184 0.146 0.116 0.092 0.074 0.059 0.047 0.038 0.030 0,024 0.020 0.016 0013 0010 0.009 0.007 0.006 0.00 0.004 26 0.361 0.281 0220 0.172 0.135 0 106 0.084 0.066 0.053 0.042 0.033 0.026 0.021 0.017 0.014 0.011 0.009 0.007 0.005 0.005 0.004 0003 27 0.347 0.268 0.207 0.161 0.125 0.098 0.076 0.060 0.047 0037 0.029 0.023 0.018 0.014 0.011 0.009 0.007 0.006 0.005 0.004 0.003 0.002 28 0.333 0.25% 0.196 0.150 0.116 0.090 0.069 0.054 0.042 0.033 0.026 0.020 0.016 0.012 0.010 0.008 0.006 0.005 0.004 0.003 0.002 0.002 29 0.321 0.243 0.185 0.141 0.107 0.082 0.063 0.048 0.037 0.029 0.022 0.017 0.014 0.011 0.008 0.006 0.005 0.004 0.003 0.002 0.002 0.002 30 0.308 0.231 0.174 0.131 0.099 0.075 0.057 0044 0.033.0026 0.020 0,015 0,012 0.009 0.007 0.005 0.004 0.003 0.003 0.002 0.002 0.001 40 0208 0.142 0.097 0.067 0.046 0.032 0.022 0.015 0011 0.008 0.005 0.000 0.003 0.002 0.001 0001 0.001 0.000 0.000 0.000 0.000 0.000 Garnison Ite/exhibit 133_2.jpg EXHIBIT 13B-2 Present of an Annalty of $1 in AmarStep 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