Finance & Accounting Online Course by Udemy, On Sale Here
A comprehensive, in Depth Course about Excel Financial Functions related to Loans with Working Models and Demo
An excellent training about Finance
Loan Analysis using Excel Financial Functions
Welcome EveryoneIn 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 functions1. PMT Payment2. IPMT Interest Payments3. PPMT Principal Payments4. CUMIPMT Cumulative Interest Payments5. CUMPRINC Cumulative Principal Payments6. IRR- Internal rate of returnAfter learning these financial functions, we are going to use apply these functions to calculate day to day loan scenariosExamples1. Calculate Loan EMI2. Calculate Refinancing and cash out refinancing3. Loan points and recovery period4. Consolidation of loans5. Amortization of Loan6. Interest Rate CalculationsHope you will be able to make educated financial decisions about various loans after the course.
Udemy is the leading global marketplace for learning and instruction
By connecting students all over the world to the best instructors, Udemy is helping individuals reach their goals and pursue their dreams.
Study anytime, anywhere.
Reviews
There are no reviews yet.