Financial Analysis Using Excel

Lesson 1 Analyzing a Potential Investment
5 Topics
Lesson 1.1 Net Present Value (NPV) and Internal Rate of Return (IRR)
Lesson 1.2 Future Value and Present Value
Lesson 1.3 Depreciation
Lesson 1.4 Break even point of prospective investments
Lesson 1.5 Sensitivity Analysis using Scenario Manager
Lesson 2 Setting up an Integrated Budgets Based Upon a Series of Assumptions
5 Topics
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
Lesson 3 Creating Pro-Forma Financial Statements from your Budgets
5 Topics
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
Lesson 4 Analyzing Financial Ratios, Contribution Margin & Breakeven Point
3 Topics
Lesson 4.1 Financial Ratios
Lesson 4.2 Analyzing Changes in Pro-Forma Statement
Lesson 4.3 Contribution Analysis and Breakeven Point
Previous Lesson
Next Lesson

Lesson 2 Setting up an Integrated Budgets Based Upon a Series of Assumptions

Financial Analysis Using Excel Lesson 2 Setting up an Integrated Budgets Based Upon a Series of Assumptions
Lesson Content
0% Complete 0/5 Steps
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
Previous Lesson
Back to Course
Next Lesson
Login
Accessing this course requires a login. Please enter your credentials below!

Lost Your Password?
Register
Don't have an account? Register one!
Register an Account

Registration confirmation will be emailed to you.