Financial Analysis, Modeling & Forecasting with Microsoft Excel (Advanced)

Financial Analysis, Modeling & Forecasting with Microsoft Excel (Advanced)

OBJECTIVES:

1. Describe the role data forecasting plays inorganizational planning.
2. Identify the positive and negative aspects of dataforecasting.
3. Create formula-based data forecasts.
4. Define best, middle, and worst case scenario data.
5. Establish target values using Goal Seek.
6. Calculate moving averages.
7. Chart moving averages interactively.
8. Calculate Net Present Value and Internal Rate ofReturn.
9. Define and solve problems in Solver.

PROGRAM TOPICS:

The course will address:

• Writing formulas 25
• Copying / cutting andpasting formulae 36
• Paste special 53
• Inserting functions 62
• Tracing cell references& debugging formula errors 77
• Loan repayments 90
• Discount cash flows 103
• Securities functions 121
• Functions for basicstatistics 152
• Other mathematics &statistics functions 172
• Logical & informationfunctions 190
• “ smart “ nested functionthat respond to formula result
• Enhancing excel 220
• The solver tool forconstrained linear optimization 227
• “ if – then “ analysisscenarios and goal seek 236 

WHO SHOULD ATTEND?

This course is designed forMicrosoft Excel users, including project managers, financial analysts,accountants, business owners, and other business professionals who have avested interest in forecasting trends at the corporate levels. This audienceuses Excel on a regular basis and has no difficulty creating formulas, charts,and cell formats.