Time Value of Money Using Excel - 10 Examples

Published: 14 October 2020
on channel: Finally Learn

33,339

550

This video shows common time value of money problems using Excel. Calculate the growth of investments, interest rates and car payments with the Excel financial functions.

Time Value of Money - A dollar today is worth more than a dollar in the future. There are two reasons this is true:
1. Inflation - prices rise and a dollar loses its value
2. Interest - dollars can earn interest over time

This video calculates the following time value of money variables in Excel.

💲 Future Value (FV) - a lump sum at the end of the problem
💲 Present Value (PV) - a lump sum at the beginning of the problem
💲 Payment (PMT) - a stream of equal payments over consistent periods, also called an annuity, the payments could be positive or negative
💲 Interest Rate (I/Y or RATE) - the annual interest rate
💲 Periods (N or NPER) - the number of periods, could be years, half-years, quarters, or months

__________

BOOK AN APPOINTMENT WITH ME

Book a coaching or tutoring appointment with Jeff Mankin

💻 https://finallylearn.com/book-a-coach...

__________

MENTIONED IN THIS VIDEO

✅ Download the Excel file, see Excel Basics Lesson 6: Time Value of Money
https://finallylearn.com/excel-basics...

👩‍💻 Excel Basics for Beginners Playlist:    • Data Analysis with Excel
👩‍💻 Time Value of Money Using BA II Plus with 10 Examples    • Time Value of Money Using BA II Plus ...

__________

LEARN MORE

✅ Subscribe to Finally Learn https://www.youtube.com/finallylearn?...
🖥 Visit Finally Learn: https://finallylearn.com/welcome/
💵 Time Value of Money Playlist:    • Time Value of Money
👩‍💻 Excel Basics for Beginners Playlist:    • Data Analysis with Excel
📚 Intermediate Accounting Chapters. https://finallylearn.com/intermediate...
📕 Intermediate Accounting I Playlist:    • Intermediate Accounting 1
📗 Intermediate Accounting II Playlist:    • Intermediate Accounting 2

__________

BOOKS I RECOMMEND

📕 The Little Book of Common Sense Investing (Jack Bogle is the father of index fund investing) https://amzn.to/3cOIHi2
📗 A Random Walk Down Wall Street (Burton Malkiel's book on why index funds beat the investing pros) https://amzn.to/3mt6OpX
📘 The Boglehead's Guide to the Three-Fund Portfolio (Simplifying your portfolio with just three funds) https://amzn.to/3cOeEas

__________

SAY HI ON SOCIAL

🖥 Website: https://www.finallylearn.com
📸 Instagram:   / finallylearn
📰 Twitter:   / finallylearn
🖥 YouTube:    / finallylearn

__________

MY GEAR

🎙 Microphone https://amzn.to/39Dd7Sm
💻 Laptop https://amzn.to/2PVacxz
💼 Laptop Backpack https://amzn.to/2OnqkHI
💵 Financial Calculator https://amzn.to/3duFvY0
🎧 Earbuds https://amzn.to/2PzHNx9
📓 Journal Notebook https://amzn.to/3f4jrUX
🖊 Archival Ink Pens https://amzn.to/3tBHCiY

__________

CHAPTERS

00:00 Time Value of Money Explained
03:37 Time Value of Money Variables
06:19 Excel vs TI BA II Plus Calculator
07:02 Solve for Future Value FV
14:13 Solve for Present Value PV
18:24 Solve for Payment PMT
24:04 Solve for Interest Rate RATE
28:15 Solve for Period NPER or N

__________

DISCLAIMERS & DISCLOSURES

This content is for education and entertainment purposes only. Finally Learn does not provide accounting, tax, financial planning, or investment advice. The information is being presented without consideration of the investment objectives, risk tolerance, or financial circumstances of any specific investor and might not be suitable for all investors. Past performance is not indicative of future results. All investing involves risk, including the possible loss of principal.

This description contains affiliate links that allow you to find the items mentioned in this video and support the channel at no cost to you. Finally Learn is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to www.amazon.com. Thank you for your support!

#finallylearn #jeffmankin

108 Subscribers 10/13/2020

Watch video Time Value of Money Using Excel - 10 Examples online, duration hours minute second in high quality that is uploaded to the channel Finally Learn 14 October 2020. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 33,339 times and liked it 550 visitors.