This is your second interview with a prestigious brokerage firm for a job as an equity analyst. You survived the morning interviews with the department manager and the Vice President of Equity. Everything has gone well. They want to test your ability as an analyst. You are seated in a room with a computer and a list with the names of two companies $$ Ford $($ticker F$)$ and Microsoft $($ticker MSFT$).$

You have to complete the following tasks:

Download the annual income statements, balance sheets, and cashflow statements for the last four fiscal years from Market Watch $($www$.$morningstar.com Links to an external site.$)$ Enter each company$$s stock symbol and then go to $$financials$$ and then $$All Financials.$$ Export the statements to Excel by right$-$clicking while the cursor is inside each statement.

Obtain industry averages for each firm from Reuters.com and include the industry norms in the excel file as well.

Your excel file should have two worksheets, one for Ford and one for Microsoft. Your worksheet should include the income statement, balance sheet, and your calculations of the financial ratios shown in the table below.