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, halfyears, quarters, or months

__________


BOOK AN APPOINTMENT WITH ME

Book a coaching or tutoring appointment with Jeff Mankin

https://finallylearn.com/bookacoach...

__________

MENTIONED IN THIS VIDEO

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

‍ 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 ThreeFund 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