Lockheed Martin (acquirer) Northrop Grumman (Target Firm)

Perform a financial statement analysis. Submission files: Excel file only. Provide a historical income statement and balance sheet for both target and acquirer. o Download 10 years worth of historical data (12) Create a common size income statement and balance sheet for both target and acquirer. o Include columns reporting 2-year & 10-year averages. (6) Create a percent of sales balance sheet for both target and acquirer. o Only do this for the current assets and current liabilities. o Include columns reporting 2-year & 10-year averages. (12) Create an annual growth rate income statement and balance sheet for both target and acquirer. o Include columns reporting 2-year & 9-year averages.