Why You Need to know the Time Value of Money Formula (Excel NPV)

Video quality	The size	Download

Information Why You Need to know the Time Value of Money Formula (Excel NPV)

Title	:	Why You Need to know the Time Value of Money Formula (Excel NPV)
Lasting	:	13.49
Date of publication	:
Views	:	86 rb

If you'd like to get 2 months of free Skillshare classes: sklsh/xelplus7brI hope you enjoyed this tutorial where we explore some of Excel's time value of money functions
Comment from : Leila Gharani

Is it possible do something like this over the period of a year rather than 4 years? so payments would be on a monthly basis rather than yearly?
Comment from : MrCharlieUK

If there a way you cab create a video that uses goal seek to derive at the rate using the npv function?
Comment from : Joda

سلامممنون بابت مطالب کاربدی که مطرح می کنید
Comment from : Alireza Lashgari

Absolutely brilliant suite of videos! Since I discovered Leila’s videos, I’ve been trying to learn the tips and tricks in Excel Your explanations of some basics accounting and investment analysis are so clear and easy to understand brbrAlso CONGRATULATIONS on getting 2m followers too! I remember you were on about 12m when I came across your videos That was only a few months ago!
Comment from : Dennis Tam

Very well done Madam
Comment from : cfaprashant

Do you want to me my mum ?🥺
Comment from : Alex Christian Takam

WELL PRESENTED THANKS
Comment from : Ilaitia Toroki

This is the best explanation I've ever heard, never understood this before Thanks!
Comment from : Peter Asteberg

Hi LeilabrbrI have question- could you help me in creating a worksheet, which will copy a cell value from sheet 1 to sheet 2 automatically and when I add sheet 3 it will automatically copy the cell value from sheet 2 brbrFor example I have cell value of 300 in cell C5 Now when I add a sheet c5 gets copied to a1 from sheet1 Next when I add Sheet 3 the cell value of c5 which can be 500 in sheet 2 should get copied to sheet 3 in cell a1 automatically as 500
Comment from : Anurag Verma

concise & clear
Comment from : Alexander Wassie

Thanks Leila! Thumbs up!!
Comment from : Wayne Edmondson

You explain this better than my accounting books and teachers
Comment from : ICallItFutile

Thank you a million :)
Comment from : United Pens

thanks a lot for excellent explanation great
Comment from : sachin kishore

Simple and clear as usual, thanks Leila!
Comment from : Tarek Alsherif

Good Work! Great content
Comment from : Kazmin

Hi, loved your video! Do you have any teaching videos that do not start from Year 0 or Year 1 but rather problems based on years (for example 3 to 8 or 5 to 10 etc etc)?
Comment from : Stress Boy

thanks
Comment from : hossein hosseinpoor

Its incredible how easy it is to understand and how difficult some teachers make it look
Comment from : Nico 12

Another excellent video I am embarrassed to keep on saying how good your videos are People will think I'm just a fan without a real background in business to be a real judge of the quality of the presentation Just so you know, I have over 40 years as a senior executive in billion-dollar companies, and I have personally done thousands of presentations in Excel, Powerpoint, pertaining to various subjects including finance When I say I think your presentations are excellent, I do mean excellent I wish I had your training when I was in business Thank you for all of your videos
Comment from : denconstutube

Last 2 videos you left reproduction list initial topic, basic accountant
Comment from : PropertyX

Excellent, thanks Leila
Comment from : Ken O

Leila is an excellent teacher
Comment from : Gary Bowen

I'm confused with the last example Shouldn't minimum return be the profit that will be made by machines in 4 years?brbrIf yes, 6 is not discount rate Discount rate is missingbrAlso, 6 of 50 000$ is 3000$, which means that the goal is still not reachedbrbrI think that to fulfill the "minimum return" requirement, there is a formula missing comparing NPV and expected return And an actual discount rate is missingbrbrPlease correct me if I'm wrong, I'm not in accounting, I'm an engineer Just interested in variety of topics, so trying to understand :-)
Comment from : Marko Vrbos

Good thing there are like you here in YT discussing these things in a very knowledgeable and clear way! :)brMaybe you can add to your next video about WACC, NPV, IRR, FV and Ratio analysis This will be good for MBA and accounting students like me!brbrThank you very much! Much support! <3
Comment from : Melvin T

May I request permission to use some of your visuals I am a CPA from the Philippines I will just indicate (Courtesy of: Leila Gharani) Thank you
Comment from : RADELPCPA _PH

Thanks You are doing a great job Could you please make a video showing how to make coupon schedule of bond investment quickly?
Comment from : Labonna Saha

Fantastic video, Leila Thanks to it's simplicity I have finally grasped the concept of NPV!!!!
Comment from : PaulTrz

Excellent video and explanations The authors of Accounting text books should watch this video and learn to present in a clear manner
Comment from : Mike Hoffman

Thanks Ma'am
Comment from : taizoon dean

Would be useful to elaborating XNPV too, it is more accurate and useful
Comment from : EricaSeeling

Leila, you are amazing in explaining Excel in such a clear and easy manner!
Comment from : EricaSeeling

You should considering lecturingcombining content with tools great value
Comment from : Jason Ipfatsiong

Amazing!!!!!!!!!!!!!!!
Comment from : Lucy Ene

NPV reminds me, "A bird in the hand (right now) is worth more than two in the bush" brWonderfully explained Even the non finance guys can easily follow this
Comment from : Sachin Vartak

This took my back to my Series 7 and 66 Usually I get simple Excel tips, but wow this a great refresher
Comment from : Sons of Eden

I just love the way you explain You make excel so easy Thanks
Comment from : S M

Hey Leila! This series is truly useful! Please keep going
Comment from : Erf A

NPV, PBP, IRR, BCR all are essential for time value of moneybrIt's our request that you'll make some tutorial for those
Comment from : Md Niaz Omar Torabee

Hey Leila! I absolutely love your work I have improved my excel skills significantly through your tutorials I would love to see your videos on some more financial excel functions like PPMT, IPMT and other advanced finance functions Really need it Thank you so much for all the lectures delivered till now Cheers! :)
Comment from : Vansh Sethi

You present D4 as a cell but change it to $D$4 without explanation Can you elaborate?brThanks
Comment from : Enrique Sanchez

Thank you Laila for the efforts
Comment from : Amine

you are amazing !!!! Thank you for all this info
Comment from : Mohamed El Khateeb

That's so handy when calculating my payments to my divorced wifejust kidding
Comment from : Kim Fuck U

This is a boom!!!
Comment from : Olushola Afolabi

Hello Leila! Thank you for your great content Your videos and clarity on explaining the concepts is greatbrKeep on the good work!
Comment from : Marcos Reis

As always: very good explained One critical point: in the first "manual" solution, this is only valid if all the amounts are the same (in this case 2700), but the second formula also is valid if the numbers are different, so that's why I always would recommend the CF/(1+)^n formula Another issue is that the NPV is confusing: the economic NPV is the "Excel NPV" - initial investment To make your next video: NPV requires constant time intervals (like one year), but did you try XNPV ? You can enter any dates !!
Comment from : Bart Titulaer ExcelBart

I have started following Leila just for pleasure and I think I will finish up as a finance professional at the end :D Thank you again
Comment from : Yavuz Selim KAÇAR

Great job Leila Gharani
Comment from : Abdul Wakeel

This is too much for my simple mind to take in I HATE MATH I would rather take $10,000 today and get the $800 with my work paychecks Now if you said I could get $80,000 in 4 years, I would say I have a ton of patience and I could wait and just live off of my work paychecks
Comment from : Paul Rivera

Leila is the best instructor that I have ever had to pleasure of learning from I just love her
Comment from : UXO22

The caveat to what seems to be a clear business decision is that $9,574 right now is better than getting zero right now
Comment from : Graph Guy

In 10 minutes you just explained this much better than my corporate finance classes during my MBA 🤦‍♂️🤦‍♂️
Comment from : Ashkan Ahmadi

Isn't this compound Interesting??
Comment from : Azhar Ali

Got clarity on the concept and excel functionalityThanks
Comment from : kranthi madanu

Dear Mam, Please Help me to set entry timebrWhen a data input/entry in any sell in excel is made,br its date and time will be automatically entered in a sell plz help me the solution
Comment from : Ali Ahamed Chowdhury

Explanation is Cristal clear Thank you 😊
Comment from : Nirmal Ama

Excellent video! 👍
Comment from : TheTraffic247

Thanks mambrTell about employee daily attandence for the excel sheet vlookup formula
Comment from : sulaiman sait

Danke Liebe Leila, die schönste Erklärung des Kapitalwerts, Viele Liebe Grüsse 🤗
Comment from : Katerina

Great video, time value of money is a key concept in finance Could you make a video about how to calculate the discount rate in case we don't deal with a company? Keep up the great work :D
Comment from : Dark Shinigami

Huh should be a dollar today is worth less than a dollar tomorrow
Comment from : Stars Withlove

I appreciate you Leila, you are an amazing teacher The way that you explain along with visual features, make learning sweet and easy
Comment from : Farzan Moha

This is part of project management and management accounts part of mba finance and bbm (economics honors)
Comment from : Deependra Gupta

Great video, the only thing I didn't get is how we ended up with 10800 and why is not considered as changing variable Why changing only the percentage not the 10800
Comment from : Martin Stoilov

This video is very informative It is too important in Financial Management
Comment from : Leila Tavakoli

You are good in explanation!
Comment from : Sachin Pesalangan

Just when you need the information 🤩
Comment from : Alan Leong

How can I show on charts ❓ is it possible
Comment from : Sahil Khan

💲
Comment from : Ace Hardy

I love this video! I watch almost every video from you and this is my bread and butter I have a degree in finance and I work in asset management TVM of money should be taught in every high school as a mandatory part of a personal finance course The world would be a lot better if people knew how to manage personal finances
Comment from : Supernova

Ms G, nice job as always Your knowledge of Excel is the cake; your clear, concise presentation is the icing on that cake Thank you
Comment from : Joe Curtis

brilliant explanation
Comment from : Theo Wemer

Hi brI was wondering what would you like to see ms team add to Excel?brOr do you think Excel has reached its limitbrThanks
Comment from : zander

I enjoyed it
Comment from : Rasoul Khoshravan

iLove the clarity and simplicity and variety of this NPV video/i TᕼᗩᑎK YOᑌ!
Comment from : james perry

Another great video Thanks!
Comment from : Claire Dyard

Very nice! Including IRR would have rounded this out nicely
Comment from : sjn 72

So well explained I used this formula (with a financial calculator) to beat up on my car finance guy and got super low rates Glad you are explaining this Leila, excellent job once again ⏳💰
Comment from : Betterifitsfree

Important stuff they don’t teach in school
Comment from : Ian Tan

One of the greatest functions ever : )
Comment from : ExcelIsFun

Great video as always!👍
Comment from : tn kwok

Could you break down the XNPV function as you did here?
Comment from : Fowmy A

Someone help me understand why would money have less value in the future? Is inflation always a case? Does this apply to Companies or could this work for a friend-to-friend loan? Where do Discount Rates come from?brbrThis is really cool
Comment from : Robert Long

Very useful for personal finance thanks
Comment from : Rahul Jauhari

Another fantastic learning opportunity, great Video!
Comment from : Junior DelGiorno

❤❤
Comment from : Shree Ganeshaay Namah

Beautiful
Comment from : Amit sg vlog

In transport economics we have "money value of time" 😊
Comment from : Yulin Liu

i don't get it, 5 from 2700 is 135 mean it should be 2565 but your calculation makes it 2571
Comment from : Mohamed Montaser

[15865] Of course i love y'r flyx! (from the first one i watch'd over a year ago - i waz hook'd! &, i have no right to complain; but, i couldn't locate to workbook @ the workbook link? i really love this Accounting/Economix series
Comment from : __