1 Financial Ratio Analysis Case Study (30 Points Possible) For this case study, you will choose two publicly traded firms that compete in the same industry and complete financial ratio analysis on both. Based on the ratios you calculate, you will compose a detailed memo addressed to the instructor summarizing your analysis and recommendation for which company would be the better stock pick long term. The deliverables for this assignment are a spreadsheet with your financial ratio calculations and a written memo. Spreadsheet (15 points possible) Your spreadsheet should include the following items: 3 years of Balance Sheet and Income Statement data for both companies (financial information can be pulled from www.sec.gov or other financial websites) Prepare a common size income statement and balance sheet for each Calculate 3 years of financial ratios for both companies (must calculate sales and net income growth rates from year to year and all the ratios on the Ratio Formulas document on canvas under Files)