I've been having trouble with this problem. Please do it on excel.

In this learning activity, you will prepare financial statements for a merchandise company. You will also do basic ratio analysis to determine if the company is performing better than its peers or not for the current accounting period. Lastly, you will evaluate if the company's stock value is fairly valued, overvalued or undervalued. Instructions Part 1: Work in two or three person teams or you can work alone. Prepare an income statement and classified balance sheet for the period ended Dec 31, 20xx. The balance of inventory on Dec 31 is $30. The company's stock trades on the NASDAQ exchange for $75 per share. Dilbert is an L.L.C. and does not pay federal income taxes. Dilbert Pharmaceuticals, Inc. Trial Balance December 31, 20xx (in Millions) $8 $10 $15 $135 $55 uo Cash Inventory (Jan. 1, 20xx bal.) Land Building Equipment Accounts Payables Wages Payable Notes Payable (Due in 7 Years) Common Stock Retained Earnings Dividends Sales Purchases Purchases Returns Purchases Discounts Freight In Selling Expenses R&D Expenses Loss from Natural Disaster $100 $50 $30 $15 $150 $40 WN $12 $35 $20 $15 $360 $360 Instructions Part 2: Prepare the financial statements needed in excel. Calculate the following ratios. Most of these have come up in class so far but, if not, use your textbook or Investopedia.com to look them up. Calculate (1) Current Ratio; (2) Debt to Asset Ratio; Return on Assets Ratio, Return on Equity Ratio and the Price Earnings Ratio. Once you have the ratios calculated, write a brief memo, addressed to your teacher, that explains the results of your ratio analysis. Use a memo template found in Microsoft Word or something similar. Make sure to proof read your memo. It will be graded based on content and how professional looking it is. The memo doesn't have to be excessively long but it should explain your evaluation of Dilbert Pharmaceuticals, Inc.'s liquidity, solvency and profitability. In addition, the memo should conclude with your opinion as to whether the company's stock is fairly valued or not and why you think that. Dilbert has been in business since 1982. The company is located in Hot Springs, Arkansas and employs 2,400 people. The company sells pharmaceutical products in the USA, Mexico and Canada. The company's sales primarily come from three drugs used to treat various cancers and pain loss conditions. Sales and cash flows from operations have increased steadily since the company was founded averaging increases of at least 10% per year. The company operates in a highly competitive global industry and can't increase selling price on its products without losing significant sales volume and market share. For the last two years, the current ratio was 1.20 and 1.35 and the debt to asset ratio was 45% and 48%. The industry average for these two ratios is 2.0 and 70%. For previous years, the ROA has been 15% and 18%. The industry average is 20%. For previous years, the ROE has been 35% and 38%. The industry average is 40%. For the other companies in Dilbert's industry, the Price Earnings Ratio average is 50. For the S&P 500, the average Price Earnings Ratio is 20. That should be all the data you need to complete this assignment. The Earnings Per Share for the year ended 20xx is $2.50. This assignment is meant to be fun and interesting so don't stress about it but use it to learn