You Are Eligible For 15% Discount This Month!
Excel spreadsheet and 3 page APA style paper. The next step for Dr. Bueller is to help him compare stocks and make good investment decisions. With that in mind, you want to compare Industrial Company #1 with its top rival Industrial Company #2 and explain to Dr. Bueller which one would make a better investment.In preparation for sharing your thoughts with Dr. Bueller,Operating income marginNet income marginCurrent ratioEarnings per sharePrice-to-earnings (P/E) ratio.Industrial Company #1(in millions)200820092010Sales$4,250$4,500$4,750Operating Income$400$445$480Net Income$200$225$250Current Assets$2,500$2,750$2,850Current Liabilities$2,300$2,450$2,500Shares Outstanding100100100Average Stock Price$32$39$50Industrial Company #2(in millions)200820092010Sales$3,350$3,750$4,250Operating Income$335$395$470Net Income$168$198$240Current Assets$1,750$1,900$2,100Current Liabilities$1,350$1,400$1,500Shares Outstanding808080Av Stock Price$38$46$622010 Industry Avg.Operating Margin10.50%Net Margin5.50%Current Ratio1.25Earnings/Share$2.75PE Ratio20.0Group Project GuidelinesPerform the calculations of the following values for both Industrial Company #1 and Industrial Company #2 using the information from the data tables located in the Assignment Description:Operating income marginNet income marginCurrent ratioEarnings per sharePrice-to-earnings (P/E) ratio.Must organize your calculations in an Excel spreadsheet In your own words, explain the significance of each calculation. Write a 3 page (body of paper), in a Word document, about which company is a better investment.