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

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