Choose your own company and repeat the analysis from Problems 1 and 2. You can get the data from MSN Money at https://money.msn.com/ investing. To retrieve the data for your company, go to the Stocks area and enter the ticker symbol. Finally, choose Financials and then the statement type.
a. On the page that appears, click on the link for the Income Statement and copy the data to a new worksheet. Reformat the data so that it is more readable, and insert formulas in place of the numbers where possible.
b. Repeat part a for the Balance Sheet.
c. Create a common-size income statement and balance sheet based on the data from parts a and b.