Time Value of Money with Excel
A Practitioner's Approach
4.38 (17 reviews)
61
students
3 hours
content
Aug 2020
last update
$39.99
regular price
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
3368544
udemy ID
7/27/2020
course created date
11/28/2020
course indexed date
Bot
course submited by