Answer the following questions in excel with formula.

Please answer the following questions 1- A company has a P/E ratio of 19.7. Their current share price is $23.13 and their most recent Net Income is $18,000. How many shares are outstanding? (Show all the work). 2- Calculate embedded cost of long term debt for the following long term debt: 2012 Amount $1,034 764 1265 984 354 2013 AmountRate of Interest $999 7.21% 698 6.95% 1176 6.42% 1023 5.34% 322 6.02% 3- What is Bayside's Altman Z-Score for 2013? Assume that the market value of equity is $6,000 Bayside, Inc. Income Statement For the year ended December 31, 2013 Net Sales Cost of Goods Sold Gross Profit Depreciation Expense Earnings before Interest and Taxes Interest Expense Pre-tax Earnings Income Tax Expense Net Income $5,680 4,060 1,620 420 1,200 30 1,170 410 $760 Bayside, Inc. Balance Sheet 31-Dec-13 Cash A/R Inventory Total Current Assets Net PP&E Total Assets 2013 180 840 1,990 3,010 3,360 6,370 2012 70 980 1,560 2,610 3,600 6,210 A/P Long-term Debt Total Liabilities Common Stock Retained Earnings Total Stockholders' Equity Total Liabilities and Stockholders' Equity Z = 1.2x1 + 1.4x2 + 3.3x3 + 0.6x4 + 1.0x5 x1 = Working capital / Total Assets x2= Retained Earnings / Total Assets x3= EBIT / Total Assets x4= Market Capitalization / Book Value of Liabilities x5= Sales / Total Assets 2013 1,170 500 1,670 2012 1,350 720 2,070 3,500 1,200 4,700 3,200 940 4,140 6,370 6,210