50.1K

Verified Solution

Link Copied!

Each individual will perform a financial analysis of a company of your choice.

The analysis will consist of ratios, common size statements, and percentage change statements. Financial statements will include balance sheet, income statement (income/expense), and statement of cash flow. All calculations are to be done using Excel and the quantified information presented in spreadsheet format.

1- Download the financial statements for three years (income statement) and two years (balance sheet and cash flows) into a spreadsheet.

2- Using the statement you have downloaded, compute as many of the ratios as you can

3- Prepare common size statements for the most recent years. For the statement of cash flows use total sales as your denominator.

4- Prepare percentage change statements for the last two years by using the three-year data for your balance sheet and income statement data. (Not required for Statement of Cash Flows).

5- Written Report to Accompany Spreadsheet Output: Prepare a summary report that includes a basic profile of the company and identifies its chief competitors. Summarize your spreadsheet results, evaluating ratios for liquidity, asset management, debt, and profitability. Your summary should be in paragraph form using a word document.

Answer & Explanation Solved by verified expert

See Answer