Answer the following question in excel sheet form, show all work if possible. Thank you.

Comprehensive Ratio Analysis of Two Companies P10. Lucy Lee is considering an investment in the common stock of a chain of retail department stores. She has narrowed her choice to two retail companies, Lucent Cor- poration and Ranbaxy Corporation, whose income statements and balance sheets follow. Income Statements Ranbaxy Lucent Net sales $50,240,000 $100,840,000 Costs and expenses: Cost of goods sold $24,568,000 59,336,000 19,290,400 28,432,800 Selling expenses 9,736,000 Administrative expenses 3,944,000 $47,802,400 97,504,800 Total costs and expenses 2,437,600 3,335,200 Income from operations 776,000 912,000 Interest expense 1,661,600 2,423,200 Income before income taxes 1,200,000 Income taxes expense 800,000 861,600 1,223,200 Net income Earnings per share 8.62 20.38