Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Subscribe
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Time Value of Money with Excel
Rating: 4.3 out of 5(20 ratings)
73 students

Time Value of Money with Excel

A Practitioner's Approach
Created byYelamanchili Rama Krishna
Last updated 8/2020
English

What you'll 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

Course content

9 sections • 42 lectures • 3h 12m total length

  • Time Value of Money - An Introduction2:53
  • An Introduction to Time-Line3:44
  • An Introduction to Compounding and Compound Interest3:57

    Master compounding and compound interest, and apply discounting and the discount rate to calculate present value and future value from cash flows.

  • Difference between Simple interest and compound interest4:25

Requirements

  • Acumen to learn corporate finance / financial management.

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.

Who this course is for:

  • 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

Report abuse