Join Jim Stice for an in-depth discussion in this video Practicing using business calculators and Excel, part of Using the Time Value of Money to Make Financial Decisions.
- Let's practice using a business calculator…and an Excel spreadsheet.…Now, you shouldn't view this as a spectator exercise.…Find yourself a business calculator…an Excel spreadsheet, some sort of online template,…or use your telephone.…Practice along with me with some sort of device.…Let us suppose that I'm going to invest $100…at an interest rate of 5% compounded annually.…I want to know how much my investment…will be worth in the future.…With my business calculator…I will do the following steps:…First, of course, I would clear my calculator's memory.…
Then I would press -100 and hit PV…to input that number into the calculator.…This is the value of my investment today.…The minus sign, the negative sign,…indicates that I'm paying $100 out of my pocket.…In terms of keystroke order, most business calculators…have you input 100 and then hit the minus key.…Press 5 and hit the interest rate key.…This is the interest rate.…Then press 1 and hit N.…My investment is for just one year.…And finally, press FV.…
This will tell me what my investment will be worth…
Jim Stice
Earl Kay Stice
Released
4/6/2015Learn more about interest rates and investments in the Stices' Finance Fundamentals course.
Skill Level Appropriate for all
Duration
Views
-
Introduction
-
Welcome1m 45s
-
-
1. Time Value of Money Overview
-
The time value of candy1m 49s
-
-
2. Examples: Impact of Interest Rate and Compounding Period
-
Example: Compounding period4m 32s
-
3. Doing Time Value of Money Computations
-
Car salesperson1m 47s
-
Computing a car payment12m 1s
-
Computing a house payment5m 56s
-
-
4. Savings and Retirement
-
Start saving early2m 11s
-
Growth in savings11m 8s
-
Saving for retirement6m 30s
-
-
Conclusion
-
Conclusion3m 7s
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Practicing using business calculators and Excel