RATIO ANALYSIS ASSIGNMENT
FINANCIAL ANALYSIS ASSIGNMENT
Each team (or individual) will perform a financial analysis of the assigned company. The
analysis will consist of ratios, common size statements, and percentage change statements. Financial statements will include balance sheet, income/expense, and statement of cash flow. All calculations are to be done using Excel and the quantified information presented in spreadsheet format.
1. Input the financial statements for the three years into a spreadsheet.
2. Using the statement you have prepared, compute as many of the ratios as you can that are in your text on page 136. Based on these ratio values, perform a trend analysis.
3. Prepare common size statements for the three most recent years.
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 processor.
Due date for this assignment is April 1st.
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- financial statement ratio analysis calculator
- financial ratio analysis excel template
- ratio analysis of financial statements
- ratio analysis spreadsheet template
- financial ratio analysis worksheets
- ratio analysis pdf
- ratio analysis accounting pdf download
- financial ratio analysis pdf
- why is ratio analysis important
- financial ratio analysis in healthcare
- financial ratio analysis report template
- balance sheet ratio analysis spreadsheet