Using the following tables answer the following question.

Data Window Help 88% 0 E Excel File Edit o AutoSave OFF Home Insert Draw View Insert Format Tools HO S JE Page Layout Formulas Data AS#6-Selection (3520) Tue 11:50 PM Q Q Search Sheet Share E AY- O Review View Comments = = = DO abe F D 2 Insert General $ - % = , e 2X Delete Format Formatting as Table Sensitivity Styles Sort & Filter X Find & Select K L M N O P Q R S T Verdana (Body) 12 A A Paste BI U BOA L11 x fx G H I J 1 Quotations 52 Week Vol Div High Low 43,804 9.42 4.95 0.12 342,886 | 32.81 19.05 0.42 72,203 16.1 10.6 37,481 39.9 17.31 0.06 PE ROE PM TATO EM 15.84 24.49% 1.0000 1.12 0.75 42.55 4.91 175.88 -11.90% 12.44% 10.75% 1.45 1.52 1.1541 1.0702 1.6306 Table 6.1 Table 6.2 + 0 -- - + 100% Tools Data Window Help 88% 0 a E Excel File Edit o AutoSave OFF Home Insert Draw View Insert Format HO S JE Page Layout Formulas AS#6-Selection (3520) Tue 11:50 PM Q Search Sheet Share Data Review View Comments abe General Verdana (Body) 12 A A = = = do BI U BOA ES IB Insert 2X Delete 1. Format Ev 480 Paste $ % -99 Conditional Format Formatting as Table Cell Styles Sensitivity X Sort & Filter Find & Select A11 x fx L M N 2. Table 6.2. Maturity 4/30/20 3/30/22 8/15/47 Coupon 2.625 1.75 2.875 T-Bond Quotations Bid Asked Chg 104.3984 104.4141 0.3047 99.2734 99.2891 0.5938 96.7656 96.7969 0.9375 Asked 0.914 1.866 3.039 Table 6.1 Table 6.2 @ -- + 100% Question 2 3 pts Assume investor X is a Bottom Fisher. Select the stock in Table 6.1 that provides the strongest buy signal. O MCBC O MTSI OMCUR OMGNX O MAGS Question 5 3 pts Assume a bond investor believes nominal yields will increase, meaning bond prices will fall. Using the quotations provided in Table 6.2, select the bond most beneficial to this investor. The 4/30/20 provides the greatest benefit to the investor in a rising interest rate environment. The 3/31/24 provides the greatest benefit to the investor in a rising interest rate environment. The 8/15/47 provides the greatest benefit to the investor in a rising interest rate environment. Question 6 3.5 pts Solve for the earnings per share (EPS) MCBC. Question 7 2 pts What is the volume of trade for MTSI stock? (Table 6.1) Question 9 3 pts Select the company in Table 6.1, that has the most efficient management? O MCBC OMISI O MCUR O MGNX Question 10 3 pts Select the company in Table 6.1, that has the best control of the balance sheet expenses? O MCBC O MISI OMCUR O MGNX