15 Excel Financial Functions Everyone Should Know!

Here are the top 15 financial functions in Excel as part of our Excel basics series, including popular functions like excel pv. This excel tutorial includes step-by-step demonstrations to help beginners understand excel formulas and apply these essential financial tools, with excel tips to improve your workflow. See how to use excel for beginners to get started in excel finance.

UPDATED VIDEO: Top 15 Financial Functions in Excel: Step By Step Examples    • 15 Essential Excel Financial Functions to ...  

Top 15 Financial Functions in Excel https://finallylearn.com/top-15-finan...

1 – FV - future value
2 – FVSCHEDULE - future value schedule
3 – PV - present value
4 – NPV - net present value (NPV)
5 – XNPV - net present value of a cash flow schedule
6 – PMT - payment
7 – PPMT - the principal of a payment
8 – IRR - internal rate of return (IRR)
9 – MIRR - modified internal rate of return (MIRR)
10 – XIRR - internal rate of return for a cash flow schedule
11 – NPER - number of periods
12 – RATE - interest rate
13 – EFFECT - effective annual interest rate
14 – NOMINAL - nominal interest rate
15 – SLN - straight line depreciation


__________

MENTIONED IN THIS VIDEO

► Time Value of Money Using Excel with 10 Examples    • Master TIME VALUE of Money in EXCEL with T...  
📂 Download the Excel file at Finally Learn: Excel Basics Lesson 6: Time Value of Money https://finallylearn.com/excel-basics...
🖥 Original Article from Wall Street Mojo: Top 15 Financial Functions in Excel https://www.wallstreetmojo.com/financ...

__________

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
02:46 1 – Future value - FV
07:19 2 – Future value schedule - FVSCHEDULE
08:29 3 – Present value - PV
12:08 4 – Net present value - NPV
15:18 5 – Net present value for irregular time periods - XNPV
17:00 6 – Payment - PMT
19:31 7 – Principal payment - PPMT
22:00 8 – Internal Rate of Return - IRR
25:00 9 – Modified Internal Rate of Return - MIRR
27:37 10 – XIRR
29:29 11 – Number of periods - NPER
30:54 12 – Interest rate - RATE
32:44 13 – Effective interest rate - EFFECT
33:58 14 – Nominal interest rate - NOMINAL
34:58 15 – Straight line depreciation - SLN


__________

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


117 subscribers 10/19/2020

   • 15 Excel Financial Functions Everyone Shou...