Time Value of Money with Excel

A Practitioner's Approach

Created by: Yelamanchili Rama Krishna
Professor, ICFAI Business School (IBS-Hyd), IFHE, University

What Will I 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

Requirements

• Acumen to learn corporate finance / financial management.

Target audience

• 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