Explore

Loan Analysis using Excel Financial Functions

1 hour on-demand video

$ 12.99

Save Course

Go to Course

Brief Introduction

A comprehensive, in Depth Course about Excel Financial Functions related to Loans with Working Models and Demo

Description

Welcome Everyone

In this course we are going to learn financial functions in excel and their use in day to day life. We are going to build excel model based on the financial functions, these spreadsheets are available as downloads. You can download and modify these spreadsheets according to your situation to calculate your scenario.

We are going to learn following functions

1. PMT – Payment

2. IPMT – Interest Payments

3. PPMT – Principal Payments

4. CUMIPMT – Cumulative Interest Payments

5. CUMPRINC – Cumulative Principal Payments

6. IRR- Internal rate of return

After learning these financial functions, we are going to use apply these functions to calculate day to day loan scenarios

Examples

1. Calculate Loan EMI

2. Calculate Refinancing and cash out refinancing

3. Loan points and recovery period

4. Consolidation of loans

5. Amortization of Loan

6. Interest Rate Calculations

Hope you will be able to make educated financial decisions about various loans after the course.

Requirements

Requirements
Basic Understanding of Excel

Recommended for you

Data Analysis Essentials Using Excel

Learn to apply the important concepts and techniques of data analysis using Excel. Ibadullah Khalil - 5 Stars “A great instructor and guide for the course....

Save Course