Computer Exercise 2 Income Statement, Balance Sheet, and Financial Ratios This exercise is designed to learn how to use excel spreadsheet to calculate financial ratios. First, you need to download the balance sheet and income statement for Exxon (XOM) from D2L The Exxon's financial statements are from Capital IQ where you will download the financial statements needed for your project. You are required to use the excel spreadsheet to calculate the financial ratios of Exxon according to the statements given for the assignment. The details of the ratios you shall complete and report are listed in a page attached with the financial statements that you will download from D2L too. We will discuss how to use the excel spreadsheet to calculate ratios, and how to format the ratios, etc. in our lab class. Make sure you could do it well and let me know if you have questions. Successful completion of this computer assignment is an essential preparation for your term paper. Exxon's financial statements show much detail than what we experienced in the textbook, and thus this assignment provides a bridge to link our learning from the textbook to the real business world. I provide some explanations for the data presented in the statements and believe they are helpful. The footnotes listed at the bottom of this page and also the notes presented next page explain the questions you may have that shall be helpful. Please read it carefully when you are working on your assignment. We have discussed the financial ratios in class and this hands-on project allows you to walk extra miles to enhance your learning. It is a worthwhile learning opportunity. You can find the stock price at Yahoo Finance, the adjusted closing price at the end of 2014, 2015, 2016, 2017 and 2018. 2 Book Value Per Share Total Common Equity / the Number of Shares Outstanding. You can find the number of shares outstanding in the income statement. Weighted Avg. Basic Shares Out: while Total Common Equity in the balance sheet Please aware that Exxon has preferred stocks that is listed in the balance sheet as Minority Interest. The difference between Total Equity and Total Common Equity reflects the book value of the Prefer Stock. Thus, the company's net income is Earnings from Conti. Ops while Net Income listed in the income Statement is the net income after prefer dividends. Return on Equity is the net income of the company divided by total equity both prefer stock and common stock) * EPS and DPS are listed on the page of the income statement, the section of Per Share Items Your hand-in shall include a cover sheet and the financial ratios you completed. The assignment is due on March 12 (Thursday)