Time Value of Money with Excel

Description

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.

What You Will Learn!

• 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

Who Should Attend!

• Undergraduate, graduate, post graduate, and doctoral students of Corporate Finance, Investments, Financial Management
• Individuals seeking career banks, consulting companies, project management
• Students of CFA, CA, CS, ICWAI
• Investment advisors, wealth managers, personal financers, personal finance, wealth management

TAKE THIS COURSE