Description

Financial Analysis Using Excel – Interactive Training

Take your Excel spreadsheet program to next level by learning how to analyze your investment and make sound financial decision. There’s no better way to explore the features and learn how to use them and  learn from a trusted Excel trainer. Reading about how to use Excel is boring and doesn’t do justice to the power that the program offers. You’ll read, hear and click the lessons by following the clear narrated step-by-step instructions!

Product Features

Level: Intermediate to Advanced

Prerequisite; Need Excel Basic Training before taking this Course

Analyzing a Potential Investment

Lesson 1-1 Net Present Value (NPV) and Internal Rate of Return (IRR)

Lesson 1-2 Future Value and Present Value

Lesson 1-3Depreciation

Lesson 1-4 Break even point of prospective investments

Lesson 1-5 Sensitivity Analysis using Scenario Manager

Setting up an Integrated Budgets Based Upon a Series of Assumptions

Lesson 2-1 Cash Budget

Lesson 2-2 Cost of Good Solds (COGS)

Lesson 2-3 Inventory & Purchases

Lesson 2-4 Labor Cost for fixed Cost

Lesson 2-5 Operating Expenses

Creating Pro-Forma Financial Statements from your Budgets

Lesson 3-1 Pro-forma financial statements

Lesson 3-2 Capital Budget/Purchases

Lesson 3-3 Cash Flow Budget

Lesson 3-4 Balance Sheet

Lesson 3-5 Statement of Cash Flow

Analyzing Financial Ratios, Contribution Margin & Breakeven Point

 Lesson 4-1 Financial Ratios

 Lesson 4-2 Analyzing changes in Pro-Forma Statement

 Lesson 4-3 Contribution Analysis and Breakeven point

Content: CD-ROM

System Requirement;

Windows PC with CD or DVD-ROM Drive