What you'll learn

How to use Excel financial function for analyzing loans

Learn Excel Financial Functions

How to Calculate EMI

How to Calculate Refinancing Scenario

How to Calculate Internal Rate of Return

How to Analyze Loan Consolidation

How to Generate Loan Amortization Schedule

Requirements

Basic Understanding of Excel

Description

Welcome Everyone

We are going to build excel model based on the financial functions, these spreadsheets are available as s. You can 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.

Who this course is for:

This course is highly recommended for everyone.

Who has loan

Who is planning to take loan

Who want to learn Excel Financial Function



DOWNLOAD
uploadgig


rapidgator


nitroflare