Excel for Financial Analysis

Introduction

Welcome to the course

Course Resources

Prerequisites: Excel formulas and functions

Basic Formula Operations

Mathematical Functions

Difference between RANK, RANK.AVG and RANK.EQ

Textual Functions

Logical Functions

Date-Time Functions

Lookup Functions (V Lookup, Hlookup, Index-Match)

Time Value of Money

Excel: Simple Interest and Compound Interest

Net Present Value

Internal Rate of Return

EXCEL: NPV and PV for calculating Present Value

Excel: Internal Rate of Return

Excel: NPV and IRR for particular dates

Analysis of Profit and Loss Statement

Horizontal and Vertical Analysis

Excel: Vertical Analysis

Excel: Horizontal Analysis

Loan Repayment Calculations

Loan Repayment concepts

1 of 5

Previous Lesson

Mathematical Functions

Excel for Financial Analysis Mathematical Functions

Previous Lesson

Login

Accessing this course requires a login. Please enter your credentials below!

Username or Email Address

Password

Remember Me

Lost Your Password?

Register

Don't have an account? Register one!

Register an Account

Username

Email

Registration confirmation will be emailed to you.