APPENDICES TABLE 1: 1% 2% Future Value of R1: FVIF(1,N) = (1 + i)ª Period 3% 4% 5% 896 7% 8% 9% 10% 11% 12% 13% 14% 15% 18% 17% 18% 19% 1 1.0100 2 1.0200 1.0201 1.0400 1.0300 1.0400 1.0500 1.0609 3 1.0303 4 1.0406 5 1.0510 1.0612 1.0927 1.0824 1.1256 1.1041 1.1093 1.0816 1.1025 1.1249 1.1576 1.1699 12155 1.0000 1.1236 1.1910 12625 1.2167 1.2763 1.3382 1.0700 1.0800 1.0900 1.1000 1.1100 1.1200 1.1300 1.1409 1.1500 1.1000 1.1700 1.1800 1.1900 1.1449 1.1564 1.1881 1.2230 1.2397 12950 1.3108 1.3605 1.4116 1.4026 1.4693 12100 1.2321 1.2544 1.2769 1.2995 1.3225 1.3456 13310 1.3676 1.4049 1.4429 1.4815 1.3209 1.5609 1.3589 1.6016 14641 1.5181 1.5736 1.6305 1.6090 1.7490 1.8106 1.3924 1.6430 1.8739 1.5388 20053 1.4161 1.6852 1.5386 1.6105 1.6851 1.7623 1.8424 1.9254 20114 2.1003 21924 2.2878 23804 в 1.0615 1.1262 1.1941 1.2653 1.3401 14185 1.5007 1.5869 1.6771 1.7716 1.8704 1.9738 2.0820 2.1950 2.3131 2.4364 25652 2.6006 28398 7 8 10037 10 2 1.1046 1.3439 1.0721 1.1487 1.2299 1.3109 1.4071 1.5036 1.0829 1.1717 1.2008 1.3066 1.4775 1.5930 1.1951 1.3048 1.4233 1.5513 1.6895 1.2190 1.4802 1.6289 1.7908 1.0008 1.7138 1.0280 1.9467 1.7182 1.8509 1.9925 21430 1.8385 1.9672 2.0762 22107 2.3526 23023 20000 2.8282 3.0012 3.1000 3.3750 2.3045 24760 2.6504 2.8525 3.0590 3.2784 3.5115 3.7589 4.0214 1.9990 21718 23579 21589 23674 25937 2.5330 27731 3.0040 3.2518 35179 3.8030 4.1084 4.4355 4.7854 21094 3.1060 3.3946 3.7072 4.0456 4.4114 4.8068 5.2338 56947 11 1.1157 1.2434 1.3842 12 1.1268 1.2682 1.53%5 1.4258 16010 17105 1.7050 1.8983 20122 21040 2.3316 2404 28531 2.2522 25182 28127 3.1384 3.1518 34785 3.4935 3.8960 3.8350 4.3345 4.2262 4.6594 5.1173 56240 6.1759 67767 4.817 5.3503 5.9360 65801 75876 8.0642 12 1.1381 1.2930 1.4685 1.0851 1.8850 2.1329 14 15 1.1490 1.3196 1.5126 1.7317 1.1610 1.3459 1.5380 19799 1.8009 2.2609 20789 2.3966 2.4098 27190 3.0658 2.5785 29372 3.3417 2.7500 3.1722 3.6425 3.4523 3.8833 3.7975 41772 4.3104 4.7846 4.3635 4.8980 4.8871 5.5348 6.2013 5.4924 1528 5.8858 7.0967 8.5994 9.5904 7.0767 54736 6.2543 7.1379 8.1371 7.9875 8.2885 10.3387 9.0075 10.1472 11.4198 11.9737 13.5895 15 17 1.1726 1.3728 1.8047 1.1843 1.4002 1.6528 1.8730 21829 1.9479 22820 18 19 1.1961 1.4182 1.2081 1.7024 2.0258 24066 1.4508 1.7535 2.5404 2.5928 3.1580 3.7000 43276 50145 2.8543 3.3799 3.9060 4.7171 55500 2.1068 25270 3.0256 3.8155 4.3157 5.1417 2.9522 3.4259 39703 4.5900 5.3109 8.1304 7.0073 5.8951 6.8660 7.9861 6.5436 7.6900 9.0243 6.1159 7.2833 8.5128 10.1974 8.1372 9.2765 10.5752 120557 9.3576 10.7480 12.3303 10.7613 12.4677 14.4265 12.3755 144625 16.8790 14.2318 16.7765 19.7484 14.1290 16.1715 16.6722 19.3441 196733 22.9005 23.2144 27.2516 20 1.2202 1.4859 1.8061 2.1911 2.6533 32071 3.8697 4.6610 5.6044 6.7275 8.0623 96463 11.5231 13.7435 16.3665 19.4608 21.1056 27.3930 32.4294 21 22 23 24 1.2572 1.5769 1.9736 2.4647 3.0715 1.2697 1.6084 20129 2.5633 3.2251 1.2324 1.5157 1.8603 2.2788 2.7860 3.3998 4.1406 5.0338 1.2447 1.5460 19161 2.3699 2.9253 36035 4.4304 3.8197 4.7406 5.0715 5.4365 40489 5.0724 6.3412 1088 66586 72579 0.9543 7.9111 9.8497 7.4002 8.1403 18.7881 23.2122 8.8492 10.8038 13.0211 15.8878 18.8215 22.5745 27.0336 32.3238 38.5910 9.9336 12.1003 14.7138 17.8610 21.6447 26.1864 31.0293 38.1421 45.9233 11.0263 13.5523 16.5266 20.3616 24.0915 30.3762 37.0062 45.0076 54.6487 122092 15.1786 28.6252 35.2364 43.2073 53.1090 65.0320 25 1.2824 1.6406 20938 2.6658 2.3864 42919 5.4274 6.8485 8.6231 10.8347 13.5855 17.0001 21.2305 26.4619 32.9190 40.8742 50.6578 626686 77.3881 Shares Ronaldo and Messi have the following historical returns: Year 2016 2017 Share Ronaldo Returns (%) Share Messi Returns (%) 4 -8 -3 -6 2018 17.45 19.39 2019 36.62 43.79 2020 16.33 2021 32.00 7.81 29.30 1 Calculate which of the two shares had the most volatile returns over the five-year period.

Which of the following should NOT be included in the analysis of a new product? 1. money already spent for research and development of the new product II. reduction in sales for a current product once the new product is introduced III. increase in accounts receivable needed to finance sales of the new product IV. market value of a machine owned by the firm which will be used to produce the new product V. $1,000,000 the company spent 5 years ago to buy a machine which will be used to produce the new product I and III QI and V II, III, and IV I, II, and IV

A B C 20 12345690022===≈ Year Quarter Revenue 2010 1 7,131.00 2010 2 6,566.00 2010 3 7,560.00 2010 4 12,947.00 2011 1 9,857.00 7 2011 2 9,913.00 8 2011 3 10,876.00 2011 4 17,431.00 10 2012 1 13,185.00 11 2012 2 12,834.00 12 2012 3 13,806.00 13 2012 4 21,268.00 14 2013 1 16,070.00 15 2013 2 15,704.00 16 2013 3 17,091.00 17 2013 4 25,587.00 18 2014 1 19,741.00 19 2014 2 19,340.00 20 2014 3 20,578.00 21 2014 4 29,329.00 22 2015 1 22,717.00 23 2015 2 23,184.00 24 2015 3 25,358.00 25 2015 4 35,747.00 26 2016 1 29,128.00 27 2016 2 30,404.00 28 2016 3 32,714.00 29 2016 4 43,741.00 30 2017 1 35,714.00 31 2017 2 37,955.00 32 2017 3 43,744.00 33 2017 4 60,453.00 34 2018 1 51,042.00 35 2018 2 52,886.00 36 2018 3 56,576.00 37 2018 4 72,383.00 38 2019 1 59,700.00 39 2019 2 63,404.00 40 2019 3 69,982.00 41 2019 4 87,436.00 42 2020 1 75,452.00 43 2020 2 88,912.00 44 2020 3 96,145.00 45 2020 4 125,555.00

1 A manufacturer produces both widgets and gadgets. Widgets generate a profit of $35 each and gadgets have a profit margin of $55 each. To produce each item, a setup cost is incurred. This setup cost is $500 for widgets and $300 for gadgets. Widgets consume 2 units of raw material A and 3 units of raw material B. Gadgets consume 6 units of raw material A and 2 units of raw material B. Each day, the manufacturer has 400 units of each raw material available. Assume that it is possible to produce fractional quantities of widgets and gadgets. X 01:30:43 Set up the problem in Excel and find the optimal solution. a. The manufacturer widgets and gadgets. Skipped (Leave no cells blank – be certain to enter "0" wherever required. Round your answers to 2 decimal places.) b. The manufacturer will produce widgets and gadgets (Round your answer to 2 decimal places.) Mc Graw Hill ASUS