Disclosure: when you buy through links on our site, we may earn an affiliate commission.

Loan Analysis using Excel Financial Functions

A comprehensive, in Depth Course about Excel Financial Functions related to Loans with Working Models and Demo
(3 reviews)
14 students
Created by


CourseMarks Score®







Platform: Udemy
Video: 49m
Language: English
Next start: On Demand

Table of contents


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
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.

You will 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


• Basic Understanding of Excel

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
Oracle Application Technical Subject Matter Expert
My name is Shailendra Kumar, I have extensive experience in the field of Oracle Application as technical engineer. Specialized as an Oracle Application consultant has extensive experience in design, development, and implementation of Oracle e-Business Suite. I have worked on many Oracle Application projects including implementation, upgrade and integration.
I have extensive experience in study and audit of existing business process, collection of functional and technical requirements, client and user interaction, GAP Analysis; technical data mapping analysis and technical design documentation. I have worked with E-Business Suite Releases 11.0.3 through Release 12.2.7

Browse all courses by on Coursemarks.
Platform: Udemy
Video: 49m
Language: English
Next start: On Demand

Students are also interested in