Answered step by step
Verified Expert Solution
Link Copied!

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

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

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 Amar

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

Auditing An International Approach

Authors: Bahram Soltani

1st Edition

9780273657736

More Books

Students also viewed these Accounting questions

Question

=+ How to develop your first Android application

Answered: 1 week ago

Question

4. Explain how to price managerial and professional jobs.

Answered: 1 week ago