Loan Analysis using Excel Financial Functions
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Brief Introduction
A comprehensive, in Depth Course about Excel Financial Functions related to Loans with Working Models and DemoDescription
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
Data Analyst's Toolbox: Excel to MySQL
- 4.1
-
![]()
![]()
![]()
![]()
![]()
Gain hands-on experience with Excel, Statistics, MySQL and Power BI to drive powerful analysis and communicate insights Gain a competitive advantage in the job market....
The Complete Investor Bootcamp 2021
- 4.4
-
![]()
![]()
![]()
![]()
![]()
The Key to Successful, Profitable, and Sustainable Future? Investing. (Learn How to Make Money in the Stock Market) What are your financial goals?...
Master Excel 2019 PC/Mac with Beginner to Advanced Courses
- 0.0
-
![]()
![]()
![]()
![]()
![]()
Finally master spreadsheets on PC or Mac with Excel, Beginners - Advanced 3 course 2019/365 bundle **This course includes practice exercises and LIFETIME access**...
Introduction to Accounting Data Analytics and Visualization
- 4.8
-
![]()
![]()
![]()
![]()
![]()
Accounting has always been about analytical thinking. From the earliest days of the profession, Luca Pacioli emphasized the importance of math and order for analyzing business transactions....
