Brief Introduction
A Practitioner's ApproachDescription
Many Banks, NBFCs, Hire-Purchase Companies, Leasing Companies recruit thousands of candidates with thorough knowledge in time value of money concepts and expertise in MS-Excel as Personal Banker, Credit Analyst, Loan Officer, Product Manager (Loan) etc. Search job portals with these designations, for your surprise you find thousands of openings at any given point of time. In this course you will learn practical applications of time value of money like savings growth, recurring deposits, pension funds, EMI calculation, Loan Schedules, sinking fund etc.
This course introduces you to the concepts of time value of money and shows you how to perform important calculations life future value, future value of annuity, present value, present value of annuity using Microsoft Excel. In this course, you will develop a solid understanding of the time value of money that prepare you to make smart business decisions.
Requirements
- Requirements
- Acumen to learn corporate finance / financial management.
Knowledge
- Learn how to calculate Loan Amortization schedule from borrower's perspective
- Learn how to calculate Loan Amortization schedule from lender's perspective
- Learn how to perform time value of money analysis using Excel
- Learn how to calculate Cumulative interest, Cumulative principal, interest of specific period, principal of specific period
- Learn the value of money after you move it forward or backward in time through compounding and discounting
- Use these concepts as a foundation for making capital investment decisions
- Learn how to use MS-Excel to solve time-value-of-money problems
- Gain the knowledge of present value, future value, present value annuity, and future value annuity to make better investment decisions
- Compute rates of return, interest rates and know their use in making financial decisions;
- Learn when to apply a simple interest calculation versus a compound interest
- Learn calculation of future value and present value of an amount using multiple compounding periods
- Understand how borrowing and lending really works.
- Make planning decisions in the present, based on the accurate calculation of cash flow projections
- Learn how to use a cash-flow timeline to conceptualize time-value-of-money problems
Rama Krishna Yelamanchili
4 Raiting
Microsoft Excel : Get All You Need To Know And Do!
- 5
-
![]()
![]()
![]()
![]()
![]()
Microsoft Excel: From Beginner to Advanced! A complete template with additional formulas for Mac and PC added for easier use! Loads of practice exercises!...
Budget Video Production
- 4.9
-
![]()
![]()
![]()
![]()
![]()
Master video production, make videos easily, learn video editing with Ken and Tosh Lubek, award-winning broadcaster. Here's what people say about this practical and enjoyable course:...
Pinterest Marketing: Get MASSIVE Sales & Traffic Fast!
- 3.5
-
![]()
![]()
![]()
![]()
![]()
Get more traffic, leads and sales for your business by following this step-by-step Pinterest marketing strategy! *Course fully updated as of February 2015....
Digital Marketing Course 2021: Be a Digital Marketing Nomad
- 4.5
-
![]()
![]()
![]()
![]()
![]()
Learn Digital Marketing, Copywriting, Ads, SEO, Video Creation. Become a Digital Marketing Nomad. Freelance and Travel. What is Digital Marketing? What is Social Media?...
