Loan Analysis using Excel Financial Functions

Genre: eLearning | MP4 | Video: h264, 1280x720 | Audio: aac, 48000 Hz Language: English | VTT | Size: 474 MB | Duration: 9 sections | 11 lectures | (49m) 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 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. 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 Buy Premium From My Links To Get Resumable Support,Max Speed & Support Me Download now LINK

Download now LINK