Course Objective:
To equip Financial Analysts with relevant tools in Excel for Financial Statement Analysis and Interpretation

Course Outline:

• Basic Financial Statements

• Building the Income Statement

• Common-Size Income Statements

• The Custom View Manager

• Macros and the Custom View Manager

• Building the Balance Sheet

• Common-Size Balance Sheet

• Building a Statement of Cash Flows with ease

• Excel's Outliner

• Evaluating Performance with Financial Ratios

• Building the Ratios Worksheet

• Building an Expert System