Question

can you pls solve all these questions 1 thru 4. this is my 3rd time posting this question but no one is answering it correctly. (dont forget the summary) thanks

also, the company is Alembic Pharmaceuticals. pls do it on this company

1. Pick a company that has been in the news in 2020 and find their financial statements (5 points) 2. Using the equations below, perform all of the 15 calculations below (30 points) 3. Based on your findings, explain in one paragraph, whether or not you would want to work for or invest in the company you researched. You should use your calculations to support your answer. (10 points) 4. Publish your summary in the discussion board and comment on a least one other person's project. (5 points) Return on Assets = Net Income / Average Total Assets Debt Ratio = Total Liabilities / Total Assets Profit Margin = Net Income / Net Sales Current Ratio = Current Assets / Current Liabilities Acid Test Ratio = Quick Assets / Current Liabilities Gross Margin Ratio = (Net Sales- Cost of Goods Sold) / Net Sales Inventory Turnover = Cost of Goods Sold / Average Inventory Days' Sales in Inventory = (Ending Inventory / Cost of Goods Sold) * 365 Days' Sales Uncollected = (Account Receivable / Net Sales) * 365 Accounts Receivable Turnover = Net Sales / Net Average Accounts Receivable Total Asset Turnover = Net Sales / Average Total Assets Times Interest Earned = Income before Interest and Income Taxes / Interest Expense Book Value per Common Share - Stockholder's equity applicable to common shares / number of outstanding common shares Book Value per Preferred Share = Stockholder's equity applicable to preferred shares / number of outstanding preferred shares Cash Flow on Total Assets - Cash flow from operations / average total assets

Answer 1

COMPANY NAME ALEMBIC PHARMACEUTICALS Mar-19 Mar-20 4605.75 3934.68 1084.97 1249.98 210.59 92.27 88.86 PROFIT & LOSS Report Date Sales Raw Material Cost Change in Inventory Power and Fuel Other Mfr. Exp Employee Cost Selling and admin Other Expenses Other Income Depreciation Interest Profit before tax 102.4 325.77 906.44 238.98 746.69 961.11 32.76 9.38 115.23 18.41 749.32 156.75 584.37 103.68 913.65 97.17 -36.63 157.32 27.16 Tax 999.82 199.18 828.82 188.5 Net profit Dividend Amount

COMPANY NAME ALEMBIC PHARMACEUTICALS Jun-20 1341.32 933.96 Quarters Report Date Sales Expenses Other Income Depreciation Interest Profit before tax Mar-20 1206.83 914.73 25.45 44.14 7.75 0.31 41.5 6.67 265.66 359.5 Tax 62.14 66.77 224.93 Net profit Operating Profit 301.46 407.36 292.1

COMPANY NAME ALEMBIC PHARMACEUTICALS Mar-19 37.7 2681.12 1128.43 BALANCE SHEET Report Date Equity Share Capital Reserves Borrowings Other Liabilities Total Net Block Capital Work in Progress Investments Other Assets Total Receivables Inventory Cash & Bank No. of Equity Shares New Bonus Shares Face value 930.54 4777.79 1158.45 1551.23 48.76 Mar-20 37.7 3181.71 1747.49 1022.14 5989.04 1551.84 1846.18 17.62 2573.4 5989.04 864.75 2019.35 4777.79 488.92 967.26 1187.53 205.62 188515914 80.75 188515914 2 N

COMPANY NAME ALEMBIC PHARMACEUTICALS Mar-20 Mar-19 811.96 CASH FLOW: Report Date Cash from Operating Activity Cash from Investing Activity Cash from Financing Activity Net Cash Flow 449.15 -731.23 -755.67 59.04 154.85 -127.23 115.33 PRICE: 537.8 534.25 DERIVED: Adjusted Equity Shares in Cr 18.85 18.85

3 The company has good product rangeand have brandlike Zeet Glycodin, Althrocin is the market leader in India on the Macrolides segment of anti-infective drugs. The manufacturing facilities of Alembic are situated in Baddi (Himachal Pradesh) and Vadodara or Baroda in Gujarat. The facility at Baroda is famous for housing the biggest fermentation facility in the country. The Panelay plant is home to the formulation manufacturing and aspartyl protease inhibitor (both recognized by US FDA) facilities. The Baddi (Himachal Pradesh) plant is used to make preparations for the non-regulated export market and regional markets. A modern research hub has been set up in Vadodara. Name Avg R&D Cost per ANDA in Rs cus Ajanta Pharma 19.0 Alembic Pharma 18.8 Torrent Pharma 27.6 Lupin 44.7 Cipla 26.9 Aurobindo Pharma 18.2