Can someone please help me in requirement number one only
Matheson Electronics has just developed a new electronic device that it believes will have broad market appeal. The company has performed marketing and cost studies that revealed the following information: a. New equipment would have to be acquired to produce the device. The equipment would cost $258,000 and have a six-year useful life. After six years, it would have a salvage value of about $24,000. b. Sales in units over the next six years are projected to be as follows: Year 1 2 3 4-6 Sales in Units 15,000 20,000 22,000 24,000 c. Production and sales of the device would require working capital of $58,000 to finance accounts receivable, inventories, and day-to-day cash needs. This working capital would be released at the end of the project's life. d. The devices would sell for $45 each; variable costs for production, administration, and sales would be $30 per unit. e. Fixed costs for salaries, maintenance, property taxes, insurance, and straight-line depreciation on the equipment would total $147,000 per year. (Depreciation is based on cost less salvage value.) f. To gain rapid entry into the market, the company would have to advertise heavily. The advertising costs would be: Year 1-2 3 4-6 Amount of Yearly Advertising $128,000 $ 67,000 $ 57,000 g. The company's required rate of return is 16%. Click here to view Exhibit 14B-1 and Exhibit 14B-2, to determine the appropriate discount factor(s) using tables. Required: 1. Compute the net cash inflow (incremental contribution margin minus incremental fixed expenses) anticipated from sale of the device for each year over the next six years. 2-a. Using the data computed in (1) above and other data provided in the problem, determine the net present value of the proposed investment 2-b. Would you recommend that Matheson accept the device as a new product? Complete this question by entering your answers in the tabs below. Req 1 Req 2A Reg 28 Compute the net cash inflow (incremental contribution margin minus incremental fixed expenses) anticipated from sale of device for each year over the next six years. (Negative amounts should be indicated by a minus sign.) Incremental contribution margin Incrememental fixed expenses Net cash inflow (outflow) Year 1 Year 2 Year 3 Year 4-6 $ 225,000 $ 300,000 $ 330,000$ 360,000 $ 236,000 $ 236.000 $ 175,000 $ 165.000 $ (11,000) $ 64,000 $ 155,000 $ 195,000 EXHIBIT 140-1 Present Value of the Periods 1 2 3 4 5 6 7 8 9 10 11 12 14 15 16 17 10 19 20 21 22 23 24 25 20 27 28 29 30 6% 7 89 9% 10% 124 134 14% 15% 16% 17 18% 20% 214 22% 23% 245 254 0.962 0.952 0.943 0.935 0926 0917 0.909 0.901 0.893 0.885 0877 0.870 0.862 0855 0.847 0.840 0.833 0826 0.820 0.83 0.806 0.800 0925 0907 0.890 0.873 0857 0.842 0826 0812 0.797 0.783 0.769 0.756 0743 0731 0718 0.706 0.694 0.683 0.672 0661 0.650 0.640 0.889 0.864 0.840 0.816 0.794 0.772 0.751 0731 0.712 0.693 0.675 0.658 0.641 0.624 0.609 0.593 0.579 0.564 0551 0.537 0.524 0.512 0.855 0.823 0.792 0.753 0.735 0.708 0683 0659 0.636 0.613 0.592 0.572 0.552 0534 0.516 0.499 0.482 0.467 0.451 0.437 0423 0.410 0.822 0784 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.385 0.370 0.355 0.3410328 0.790 0746 0705 0.666 0630 0596 0.564 0535 0.507 0480 0456 0432 04100390 0.370 0352 0335 0.319 0.303 0.289 0.275 0.262 0.750 071 0.665 0.623 0.583 0.54705130482 0.452 0.425 0.400 0.375 0.354 0333 0.314 0.296 0.279 0.263 0.249 0.235 0.222 0.210 0.731 0.677 0.627 0.582 0540 0.502 0.467 0.434 0.404 0.376 0351 0.327 0.305 0.285 0.266 0.249 0.233 0.218 0.204 0191 0.179 0.160 0.703 0.645 0.592 0.544 0500 0.460 0424 0.391 0.361 0333 0.308 0.284 0.263 0243 0.225 0.209 0.194 0130 0.167 0.155 0144 0134 0.676 0.614 0.558 0.508 0.463 0422 0.396 0.352 0.322 0.295 0.2700.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 0527 0.475 0.429 0.388 0.350 03170282 0.261 0237 0.25 01950178 0.162 0.140.135 0123 0.112 0103 0.094 0036 0.625 0.557 0.4970444 0.397 0356 0.319 0286 0.257 0231 0203 0.137 0.158 0:1520:137 0.124012 0.02 0.092 0.033 0.076 0.069 0.601 0.530 0.469 0.415 0.368 0.326 0.290 0.250 0.229 0.204 0182 0.163 0.145 01300116 0.104 0.093 0.084 0.075 0.008 0.061 0.055 0.577 0.505 0442 0388 0340 0.299 0.263 0232 0.205 0.191 03600141 0.125 0.111 0.099 0.088 0.078 0.069 0.062 0.055 0049 0.044 0.5550 401 0417 0.362 0.315 0.275 0239 0.209 0.183 0.160 0.1400123 0.1080095 0.084 0.074 0.065 0.057 0.051 0.045 0.040 0.035 0.534 0458 0.394 0.339 0292 0.252 0.2180188 0.163 0141 012301070093 0.081 0.071 0,062 0:054 0.047 0.042 0,036 0.032 0.028 0500436 0371 0317 0.270 0221 0198 0170 0.146 0.125 0108 0.093 0.000 0.069 0.060 0,052 0.045 0.039 0.034 0.030 0.026 0.023 0494 0.41 0.50 0.296 0.250 0.212 01000153 0130 01 0.095 0.001 0.000 0.050 0.051 0.04 0.008 0.032 0.0200.024 0.021 0.018 0.475 0.396 03310277 0232 0.194 0164 008 0116 0.098 0083 0.070 0000 0.051 0.043 0.037 0.031 0,027 0.025 0.0200017 0.014 0.456 0.377 0.312 0.250 0.215 0.170 0.149 0124 0.04 0.007 0.073 0.001 0.098 0.043 0.037 0.031 0.025 0.022 0.019 0.09 0.014 0.012 0.439 0.359 0294 0242 01990954 0.135 0,112 0.093 0077 0.064 0.053 0.044 0.037 0.031 0.026 0.022 0.010 0,015 0.01300110.000 0422 0342 0273 0226 0764 01500123 0101 0.083 0068 0056 0.046 0.038 0032 0.026 0.022 0.018 0.015 0.00 0.00 0.000 0.007 0406 0.326 0202 0.211 0.1700.138 0112 0.091 0.074 0.000 0.049 0.040 0.00 0.027 0.022 0.01 0.0150012 0.00 0.00 0.007 0.005 0.390 0.310 02:47 0197 0158 0126 0102 0.002 0.066 0.053 0043 0.035 0.025 0.023 0.019 0,015 0.01 0.010 0.008 0.007 0.006 0.005 0.375 0.295 0.233 0.134 0.148 0.116 0.092 0.074 0.059 0.047 0.03 0.030 0.024 0.020 0.0160.003 0.00 0.009 0.007 0.005 0.005 0.004 0.361 0281 0.220 0.172 0135 0.500 0.094 0.005 0.053 0042 0093 0.025 0.021 0.01 0.014 0.01 0.009 0.007 0.006 0.005 0004 0.003 0.347 0.268 0.207 0161 0.125 0.098 0.078 0.060 0,047 0.037 0029 0023 0.018 0.054 0.00 0.00 0.007 0.006 0.005 0.004 0.003 0.002 0.333 0.255 0.196 0.150 0.116 0090 0009 0.054 0042 0.033 0026 0.0200016 0.0120.010 0.008 0.006 0.005 0.004 0.003 0.002 0.002 0.321 0.243 0.185 0.141 0107 0.002 0.063 0.048 0.037 0.029 0022 0.01 0.01 0.0110.000 0.006 0.005 0.004 0.000 0.002 0.002 0.002 0.308 0.221 0.174 0131 0.099 0.075 0.057 0.044 0.033 0.025 0.020 0,015 0.0120.009 0.007 0.005 0.000 0.003 0.003 0.002 0.002 0.001 0.208 0.142 0.097 0.067 0.046 0.032 0.022 0.015 0.011 0.008 0.005 0.004 0.003 0.002 0.001 0.001 0.001 0.000 0.000 0.000 0.000 0.000 40 EXHIBIT 948-2 Precent Value of an Annulty of $1 in Armeer Periods 1 2 3 4 5 6 7 8 9 10 11 3 14 15 16 17 18 19 20 21 45 7% 8 95 10% 123 135 15% 173 189 199 20% 255 224 249 25% 0.952 0.952 0.943 0935 0.926 0917 0.909 0901 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 1886 1859 1.833 1.808 1783 1759 1735 113 1.090 1668 1647 1625 1805 15851568 1547 1528 1509 1492 1474 1457 1440 2775 2.723 2673 2624 2577 2531 2487 2444 2.402 2351 2.322 2.283 2.246 2.210 2174 2.540 2006 2.074 2042 2011 1981 1952 3630 3546 3.465 3.387 3.312 3.240 3.170 3102 3037 2974 2954 2.855 2.798 2743 2.690 2639 2.589 2540 2494 2.443 2404 2362 4452 4.329 4.212 4100 3.993 3.890 3.791 3690 3605 3.517 3.433 3.352 3.274 3199 3.127 3.058 2.991 2926 2864 2.603 2745 2.689 5.24250764917 4767 4623 4.496 4355 4231 411 3.998 3.899 3.784 3.685 3.509 3.498 3.450 3326 3.245 3167 3.092 3.020 2951 6.002 5706 5.582 5 389 5.200 5.033 4.8684712 4564 4423 4.288 4160 4.039 3.922 3.812 3.706 3.605 3.508 3.45 3.327 3242 3.361 6.733 6.463 6.210 5.971 5.747 5.535 5.335 5146 4 968 4.799 4639 4487 4.344 4.207 4078 3954 3.837 3.726 3619 3510 3.421 3.329 7435 7.108 6.802 6.515 6.247 5995 5.759 5.537 5328 5132 4 946 4772 4.607 4.451 4303 4.963 4.031 3.905 3.786 3.673 3.566 3:483 3.111 2722 7360 7024 6.710 6.419 6.145 5.899 5.650 5.426 5.216 5.019 4.833 4659 4494 4339 4.1924.054 3.923 3.7993.682 3571 8.750 8.3067887 7.499 7039 6.805 6.495 6.207 5.938 5.687 5.453 5.234 5.0294.836 4656 4.486 4327 4177 4035 3902 3.776 3656 9.3958.863 3.384 7943 7536 2161 6,814 6.492 6194 5.918 5660 5.421 5197 4988 47924611 4.439 4278 4127 3.905 3.851 3.725 9.996 9,394 8.853 83587904 7487 7100 6.750 6424 6122 5.842 5583 5342 5118 4.910 471 4533 4362 4203 4053 3912 2.780 10.563 9.899 9.295 8.745 8.244 7.796 7367 6.902 6628 6.302 6.002 5.724 5.668 5.229 5.000 4.102 4.011 4.432 4.265 4.108 3.962 3.824 11.118 103809712 9.900 3.559 8.061 7606 7191 6 811 6.42 6.142 5.847 5.575 5324 5.092 4.876 46754489 4315 41534001 3.859 11652 10838 10.106 9.447 8.851 8313 782473796.974 6,604 6.265 5.954 5668 5.405 51624938 4730 4530 4357 4189 4.0333 887 12.166 11274 10.477 9.763 9.122 8.544 8.022754971206.729 6.373 6047 5749 5.475 5.222 4.990 4775 4578 4391 4219 4059 3.910 12.659 11690 10828 10.0599372 8.756 3.201 2202 7.250 6.840 6.467 6128 5818 5534 5.2735033 48124608 4.419 4243 4.080 3.928 194 12.005 11150 103369.004 8.365 782973666938 6.550 61905877 5504 5.316 5.070 43434635 44424203 4097 3.92 3590 12.402 11.470 10.594 9.818 9129 8.5 2963 7409 7025 6.623 6.259 5929 5628 5353 5901 4.870 405744604279 47103954 14.029 12821 11.764 10.836 10.017 9.292 3.649 3.075756271026687 6.312 5973 5605 5.384 5127 4.891 4675 4.476 4.292 4121 3.963 14.451 1316312042 1106190201 442 0.772 0.170 7645 2170 6.7436359 0.01 5096 5.41051494.909 4690 4438 4302 4130 3.970 14.857 13.459 12.300 11.272 10.37 8.580 8.883 8.206 7710 7230 6.792 6.399 8044 5723 5.432 5.167 4.925 4703 4.499 4.311 4137 3.976 15,247 13.799 12.550 1146090529 9707 8.905 8.348 7704 7283 6.835 6.434 6073 5.746 5.451 530249974714507 4310 4143 3.981 15.622 14.094 1278311854 10675 9.823 9.0778422784373306873 6.464 6.097 5766 5.667 51954948 4721 4.514 4323 4147 3985 15 983 14.3751300311826108109.929 9161 8.489 7896 7372 6906 6.4916118 5.783 5.480 5.2064956 4728 4520 4320 4151 3.983 16.330 14643 13.211 71987 90 935 10027 9.237 8.543 7943 7409 6935 6.514 6136 5.798 5.492 5215 4.954 4734 4524 4332 4.154 3.990 16.663 14.890 13.406 12137 11051 10.116 9.307 8.602 7.934 7441 6901 6.534 6.152 5.810 5.502 5.223 4.970 4719 4.528 4335 41573992 16 984 15.141 1591 12.278 12158 10190 9.370 8.650 9.022 7470 6983 6551 65065.820 5.510 5229 4.975 47434531433741593994 17.292 15.372 13.765 12.409 1.258 10.274 9.427 8.694 8.055 74967003 6.566 6.177 5.829 5.517 5.235 4.979 4745 4534 4339 4160 3.995 19.793 1215915046 1333218925 10.7579.7798.951 8.244 7634 2105 6,542 6 233 5.871 5518 5.258 499747604544 43474166 3.999 24 25 26 27