please answer everything in yellow!

A H J K B C D E F G 15 Capital Decision Making 16 17 18 Big Al gives his worker's a one hour lunch and two fifteen minute breaks each day. He believes that a 28 cold soda machine would be appreciated by his workers, and an appreciated worker is a good worker 29 He has priced a machine at a national member only warehouse for $2,050. The machine should be 30 usable for 6 years, after which it would be inefficient, obsolete and would have to be disposed of at the 31 dump Big Al believes that 8 cans a day will be purchased. The plant is open five days a week, 50 32 weeks per year. A case of soda (24 cans) costs $5 76 and Big Al believes that a price of $ 80 per 42 can would win him good will. What is the estimated annual sales in cans of soda? (1701) What is the contribution margin per can of soda? (rounded to two places, $#.) 117021 43 44 45 46 56 57 58 59 60 70 71 72 73 74 84 85 86 87 88 98 99 How many cans of soda must be sold each year to breakeven? (Round up to zero places, ## cans) 11703) Annual incremental cash inflows from the soda machine? (rounded to two places $#.##) 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 Present Value Tables ready Clipboard Number Tont Alignment A1 f B C D E F G H 1 J K 117.02) How many cans of soda must be sold each year to breakeven? (Round up to zero places i cans) A 70 71 72 73 74 84 85 86 87 88 98 99 100 101 11703) Annual incremental cash inflows from the soda machine? (rounded to two places, S4 MB) 102 1704 What is the payback period in years? (rounded to two places, ... years) 11705) 112 113 114 115 116 126 127 128 129 130 131 132 133 134 135 136 127 It the time value of money is 12% por year what is the not prosent valuo? Uso the tables on page 18 117061 18 Present Value Tables 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 Ready Type here to search A B D E F G H K What is the payback period in years? (rounded to two places, #.## years) 112 113 114 115 116 126 127 128 129 130 131 132 133 11705) If the time value of money is 12% per year what is the net present value? Use the tables on page 18 134 11706) What is the internal rate of return. Pick the closest interest rate from the tables on page 18 135 136 137 138 139 140 141 142 143 144 (1707) 145 146 147 148 149 150 A1 fo B G H 1 J M 1 2 3 Interest D E F Present Value of Annuity $1.00 in Arrears N- Periods Interest Periods 5 UNCA 4 Rate 3 4 2.0% 2.884 3.808 2.5% 2 856 3.762 3.0% 2.829 3.717 3.5% 2.802 3.673 4.0% 2.775 3.630 10 4.5% 2.749 3.588 11 5.0% 2.723 3.546 5.5% 2.698 3505 13 6.0% 2 673 3.465 14 6.5% 2.648 3.426 15 7.0% 2624 3.387 16 7.5% 2.601 3.349 17 8.0% 2577 3.312 18 8.5% 2.554 3.276 19 9.0% 2.531 3.240 20 9.5% 2.509 3 204 21 10.0% 2 487 3.170 22 10.5% 2465 3.136 23 11.0% 2.444 3 102 24 11.5% 2.423 3.070 25 12.0% 2.402 3.037 26 12.5% 2 381 3006 27 13 0% 2 361 2 974 28 13 5% 2 341 2 944 29 14.0% 2.322 2914 30 14 5% 2 302 2.884 31 15.09 2283 2855 1 2 3 4 5 4.713 4.646 4.580 4.515 4.452 4.390 4.329 4.270 4.212 4.156 4.100 4.046 3.993 3.941 3.890 3.840 3.791 3.743 3.696 3650 3.605 3.561 3.517 3.475 3.433 3.392 3352 5 6 6 5.601 5.508 5.417 5.329 5.242 5.158 5.076 4.996 4.917 4.841 4.767 4.694 4 623 4.554 4.486 4.420 4.355 4.292 4.231 4.170 4.111 4.054 3.998 3.943 3.889 3.836 3.784 7 8 Rate 50.5% 51 0% 51 5% 52 0% 52.5% 53.0% 53.5% 54 0% 54.5% 55.0% 55.5% 56.0% 56.5% 57.0% 57.5% 58.0% 58.5% 59.0% 59.5% 60.0% 60.5% 61.0% 61.5% 62.0% 62.5% 63 0% 63 5% 11 12 3 4 1.399 1.594 1.391 1 584 1.383 1.573 1.375 1.563 1.368 1.553 1.360 1.542 1.352 1.532 1 345 1.523 1.337 1.513 1.330 1.503 1.323 1.494 1.315 1.484 1.308 1.475 1.301 1466 1 294 1.457 1 287 1.447 1.280 1.439 1.273 1.430 1.266 1.421 1 260 1.412 1 253 1.404 1.247 1 395 1 240 1.387 1234 1.379 1227 1.371 1221 1.362 1214 1.354 13 14 75 5 1.724 1.711 1.698 1.686 1.674 1.662 1.650 1.638 1.626 1.615 1.604 1.592 1.581 1.570 1.560 1.549 1.539 1.528 1.518 1.508 1.498 1 488 1.478 1.468 1.459 1.449 1440 16 17 6 1.810 1.795 1.781 1.767 1.753 1.740 1.726 1.713 1.700 1.687 1.674 1.662 1.649 1 637 1.625 1.613 1.602 1.590 1.579 1.567 1.556 1.545 1.534 1.524 1.513 1.503 1492 18 Present Value Tables - 9 10 Ready - Type here to search O 99+ A1 x & fr F : 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 A 14.5% 15.0% 15.5% 16.0% 16.5% 17.0% 17 5% 18.0% 18.596 19.0% 19.5% 20.0% 20.5% 21.0% 21.5% 22.0% 22 5% 23.0% 23.5% 24.0% 24.5% 25.0% 25.5% 26.0% 26.5% 27 0% 27.5% 28.0% 28 5% 29.0% 29.5% 30.0% B D 2.302 2.884 3.392 2 283 2.855 3.352 2.264 2826 3.313 2.246 2.798 3.274 2.228 2.770 3.236 2.210 2.743 3.199 2.192 2.716 3.163 2.174 2.690 3.127 2.157 2 664 3.092 2.140 2639 3.058 2.123 2613 3.024 2 106 2.589 2.991 2.090 2.564 2.958 2.074 2.540 2.926 2.058 2.517 2 895 2.042 2494 2.864 2027 2.471 2.833 2011 2.448 2.803 1.996 2.426 2.774 1.981 2.404 2.745 1.967 2.383 2.717 1952 2362 2.689 1.938 2.341 2.662 1923 2.320 2.635 1 909 2.300 2.609 1.896 2 280 2 583 1.882 2 260 2.557 1.868 2 241 2.532 1.855 2.222 2.507 1 842 2 203 2.483 1.829 2 185 2.459 1 816 2166 2436 1 2 3 4 5 6 E 3.836 3.784 3734 3.685 3.636 3.589 3.543 3.498 3.453 3.410 3.367 3.326 3.285 3245 3205 3.167 3.129 3.092 3.056 3.020 2 986 2.951 2.918 2.885 2 853 2.821 2.790 2.759 2.729 2.700 2 671 2643 8 9 G 63.0% 63.5% 64.0% 64.5% 65.0% 65.5% 66.0% 66.5% 67.0% 675% 68 0% 68.5% 69.0% 69.5% 70.0% 70.5% 71.0% 71.5% 72.0% 72.5% 73.0% 73.5% 74.0% 74.5% 75.0% 75.5% 76.0% 76.5% 77 0% 77 5% 78.0% 78.5% 11 12 H 1 1.221 1.362 1.214 1.354 1 208 1.347 1 202 1.339 1.196 1.331 1.190 1.323 1 184 1.316 1.178 1.308 1.172 1.301 1.166 1 293 1.160 1.286 1. 155 1.279 1.149 1272 1.143 1.265 1.138 1.258 1.132 1 251 1.127 1 244 1.121 1.237 1 116 1.230 1.111 1.224 1.105 1 217 1.100 1.210 1 095 1 204 1.090 1.198 1.085 1.191 1.079 1.185 1074 1.179 1 089 1.172 1.064 1.166 1 060 1. 160 1055 1.154 1050 1 148 13 14 15 J 1.449 1.440 1.431 1.422 1.413 1.404 1.395 1.386 1378 1.369 1.361 1.352 1.344 1.336 1.328 1.320 1.312 1.304 1.297 1.289 1.281 1 274 1 267 1.259 1 252 1.245 1.238 1 231 1.224 1 217 1 210 1 204 16 17 1.503 1.492 1.482 1.472 1.462 1.452 1.443 1.433 1.424 1.414 1.405 1 396 1.387 1.378 1.369 1.361 1.352 1.344 1.335 1327 1.319 1311 1.303 1 295 1.287 1 279 1.272 1.264 1.256 1 249 1 242 1235 18 Present Value Tabl 2. 7 10 - Ready Type here to search OPE 99+ hp A1 - f F S C A B 61 30 0% 1.816 2.166 62 30.5% 1.803 2.148 63 31.0% 1.791 2.130 64 31.5% 1.779 2.113 65 32 0% 1.766 2.096 66 32.5% 1.754 2.079 67 33.0% 1.742 2.062 68 33.5% 1.730 2.045 69 34.0% 1.719 2.029 70 34.5% 1.707 2013 71 35 0% 1.696 1.997 72 35.5% 1.685 1.981 73 36.0% 1 673 1.966 74 36.5% 1 662 1.951 75 37.0% 1.652 1.935 76 37.5% 1 641 1.921 38 0% 1.630 1.906 78 38.5% 1.620 1.892 79 39.0% 1.609 1.877 80 39.5% 1.599 1.863 81 40.0% 1.589 1.849 82 40.5% 1.579 1.836 83 41.0% 1.569 1.822 84 41.5% 1.559 1.809 85 42 0% 1.549 1.795 86 42.5% 1.540 1.782 43.0% 1.530 1.769 88 43.5% 1.521 1.757 89 44 0% 1.512 1.744 90 44.5% 1.502 1.732 91 45.0% 1.493 1.720 92 15.5% 1.484 1707 1 2 3 4 D 2.436 2.412 2.390 2 367 2.345 2.324 2.302 2 281 2.260 2.240 2 220 2 200 2.181 2.162 2.143 2.124 2.106 2.088 2.070 2.052 2035 2.018 2.001 1.985 1.969 1.953 1.937 1.921 1.906 1.890 1.876 1861 5 6 7 E 2.643 2615 2.588 2.561 2534 2.508 2.483 2.458 2.433 2.409 2.385 2 362 2.339 2.316 2.294 2272 2.251 2 229 2 209 2.188 2 168 2.148 2.129 2. 109 2.091 2.072 2.054 2.036 2018 2.000 1.983 1966 8 9 G 78.5% 79.0% 79.5% 80.0% 80.5% 81 0% 81.5% 82.0% 82.5% 83 0% 83.5% 84.0% 84.5% 85.0% 85,5% 86.0% 86.5% 87,0% 87.5% 88 0% 88.5% 89.0% 89.5% 90.0% 90.5% 91.0% 91.5% 92 0% 92.5% 93.0% 93 5% 94.0% 11 12 H 1.050 1.045 1.040 1036 1.031 1 026 1.022 1.017 1.013 1.008 1.004 0.999 0.995 0.991 0.986 0.982 0.978 0.974 0.969 0.965 0.961 0.957 0.953 0.949 0.945 0.941 0.937 0.933 0.930 0926 0.922 0918 13 14 1.148 1.143 1.137 1.131 1.125 1.120 1.114 1.108 1.103 1.097 1.092 1.087 1.081 1.076 1.071 1.066 1.061 1.055 1.050 1.045 1.040 1.036 1.031 1.026 1 021 1.016 1,012 1.007 1.002 0.998 0.993 0989 15 J K 1 204 1 235 1.197 1.227 1.190 1.220 1.184 1.213 1.177 1. 206 1. 171 1.199 1.165 1.193 1.158 1.186 1.152 1.179 1.146 1.173 1.140 1.166 1.134 1.160 1.128 1.153 1.122 1.147 1.116 1.141 1.111 1.135 1.105 1.129 1.099 1.123 1.094 1.117 1.088 1.111 1.082 1.105 1.077 1.099 1.072 1.093 1.066 1.087 1.061 1.082 1.056 1.076 1.050 1071 1.045 1.065 1.040 1.060 1.035 1.054 1.030 1.049 1025 1 044 16 17 18 Present Value Ta 77 ce 87 10 Ready Type here to search ORE 99+ A1 F 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 37.5% 38 0% 38.5% 390% 39.5% 40.0% 40.5% 41.0% 41.5% 42.0% 42.5% 43.0% 43.5% 44.0% 44.5% 45.0% 45.5% 46.0% 46.5% 47.0% 47.5% 48 0% 48.5% 49.0% 49 5% 50.0% B 1.641 1.630 1.620 1 609 1.599 1.589 1.579 1.569 1.559 1.549 1.540 1.530 1.521 1.512 1.502 1.493 1.484 1.475 1.467 1.458 1.449 1.441 1.432 1.424 1.416 1.407 C 1.921 1.906 1.892 1.877 1.863 1.849 1.836 1.822 1.809 1.795 1.782 1.769 1.757 1.744 1.732 1.720 1.707 1.695 1.684 1.672 1.660 1.649 1.638 1.627 1.616 1.605 D 2.124 2. 106 2.088 2.070 2.052 2.035 2.018 2001 1.985 1.969 1.953 1.937 1.921 1.906 1.890 1.876 1.861 1.846 1.832 1.818 1.804 1.790 1.776 1.763 1.750 1.737 E 2.272 2 251 2.229 2.209 2.188 2.168 2.148 2.129 2.109 2.091 2.072 2.054 2036 2.018 2.000 1.983 1.966 1.949 1.933 1.917 1.901 1.885 1.870 1.854 1.839 1.824 G 86.0% 86.5% 87 0% 87 5% 88 0% 88.5% 89.0% 89.5% 90.0% 90.5% 91.096 91.5% 92.0% 92.5% 93.0% 93.5% 94.0% 94.5% 95 0% 95.5% 96 0% 96.5% 97 0% 97.5% 98.0% 98.5% 99 0% 99.5% 100.0% H 0.982 0.978 0.974 0.969 0.965 0.961 0.957 0.953 0.949 0.945 0.941 0.937 0.933 0.930 0.926 0.922 0.918 0.914 0.911 0.907 0.903 0.900 0.896 0.893 0.889 0 885 0.882 0.878 0 875 1.066 1.061 1.055 1.050 1.045 1.040 1.036 1,031 1.026 1.021 1.016 1.012 1.007 1.002 0.998 0.993 0.989 0.984 0.980 0.975 0.971 0.967 0.962 0.958 0.954 0.950 0.946 0.942 0.938 J 1.111 1.105 1.099 1.094 1,088 1.082 1.077 1.072 1.066 1.061 1.056 1.050 1.045 1.040 1.035 1.030 1.025 1.020 1.015 1.010 1.006 1.001 0.996 0.992 0.987 0982 0.978 0.973 0.969 K 1.135 1.129 1.123 1.117 1 111 1.105 1.099 1.093 1.087 1.082 1.076 1.071 1.065 1.060 1.054 1.049 1.044 1.039 1.033 1.028 1.023 1.018 1.013 1.008 1.003 0.999 0.994 0.989 0.984 97 98 99 100 101 102 103 104 105 106 107 If off the chart use 100% 11 12 13 14 2 3 4 5 6 7 00 8 9 10 15 16 17 18 Present Value T Ready Type here to search o O i BE 99+