🚀 Take our Finance & Valuation Course: www.careerprinciples.com/courses/finance-valuation-course
@NEMOSnowtographer
11 ай бұрын
Can i have 20% coupon pls bro?
@lskknl10
11 ай бұрын
Thanks Kenji. Can you make an LBO course please?
@casonalimudgal7986
3 ай бұрын
Hello Kenji, I always found your videos really helpful. Being a Chartered Accountant, still liked your videos a lot and very much knowledgeable. Thanks a lot for sharing .
@aqibaqib9350
10 ай бұрын
hi, I think you missed VLOOKUP and INDEXMATCH formulas which are widely used in Financial Modelling. The formulas you are explained is quite helpful.
@PeterHowe228
16 күн бұрын
I'm having trouble with the XNPV formula when I recreated your chart I got 1,117,844.02 I double and triple checked and everything is the same. Do you know how this could be? Additionally I entered the IRR just like you said and it came back with a number error rather than 16.20%. Can anyone help?
@NguyenTrung-m7s
Ай бұрын
Hi Kenji, that was a good video but why I can not download the Excel file.
@SneakyWoolCloth
4 күн бұрын
Do you also do google sheets?
@haree001
4 ай бұрын
in the choose function, I am unable to select f4 how can I do it in my Excel 2021?
@khato9720
11 ай бұрын
thank you very much, your sharing is very useful
@guslarser
11 ай бұрын
Correct me if I’m wrong but an investment can have 2 IRR values, meaning in the excel formula you should put 0 & 1 right after the *guess option.
@cedricruckaberle3795
7 ай бұрын
Very cool Stuff as always, thanks a lot
@Mr_Clarki
11 ай бұрын
Hey ✋I need t emerge 2 excel sheets in a certain way, pretty hard to explain but would you be willing to help me for a video?
@flex19112
9 ай бұрын
GPT does this to:)
@richc.4672
11 ай бұрын
one of my fav excel channels for sure
@motopelamohapi4152
11 ай бұрын
Thank you.
@user-xh8cb4vm7e
11 ай бұрын
Sir not showing option data types on my excel 2016.
@KenjiExplains
11 ай бұрын
sorry to hear might only be an option for Microsoft 365
@willzinner8813
11 ай бұрын
awesome thakn you
@KenjiExplains
11 ай бұрын
Cheers for watching!
@unlocking_potential123
11 ай бұрын
On point. No BS. just the way I like it. KUDOS
@KenjiExplains
11 ай бұрын
thank you!
@rohitmaurya1103
11 ай бұрын
Extremely helpful 👍
@KenjiExplains
11 ай бұрын
Glad to hear!
@pochreyes
11 ай бұрын
love it! thanks!
@KenjiExplains
11 ай бұрын
You're welcome!
@josephbaba111
11 ай бұрын
Thanks Kenji
@KenjiExplains
11 ай бұрын
thanks for watching!
@amitdhiman7307
11 ай бұрын
Great knowledge
@KenjiExplains
11 ай бұрын
Thanks for watching!
@camlex6310
11 ай бұрын
Super helpful!!!
@KenjiExplains
11 ай бұрын
Glad it was helpful!
@vipuljain6642
11 ай бұрын
Verf useful video thank you sir
@KenjiExplains
11 ай бұрын
Thanks for watching!
@Ismail45
11 ай бұрын
is data types available in excel 2021? i cant find that
@KunikaAg
11 ай бұрын
Me 2
@scwyldspirit
11 ай бұрын
The link isn't working
@federicobonanno633
11 ай бұрын
Hi Kenji, thanks a lot for the video! I downloaded the file and the result of the NPV (XNPV Formula) is $561,688 rather than $454,239 as shown in your video. I am not seeing something here? 🧐
@KenjiExplains
11 ай бұрын
it’s because the npv doesn’t take into consideration dates so it starts counting year 0 as year 1 while the xnpv does take into consideration dates.
@invisiblepeace.5276
11 ай бұрын
Extremely helpful brotha.🎉❤ please create a playlist for data analysis videos. Anyway thanks ❤ 🙏
@joukenienhuis6888
11 ай бұрын
So, if i want to calculate what amount of money my mom needs to have on her bank account now to live at reasonable income out of it per month i could use npv?
@Dulalmahato2011
11 ай бұрын
u missed CAGR
@henrylyimo1864
11 ай бұрын
In the aggregate formula, where did you get number 9?
@markpretty
11 ай бұрын
At around 0:53 in the video, there is a list of options to choose. 9 is the SUM for the aggregate formula (4 is Min, 5 is Max, etc.)
@willzinner8813
11 ай бұрын
hey just trying on excel is the xnpv the same as the npv?
@soniccheese01
11 ай бұрын
npv assumes regular cashflow periods, xnpv works with the dates of the cashflows as these could be irregular
@mrinformer7917
11 ай бұрын
Wait, do you think cryptocurrency will crash? I dont think so. More and more companies are integrating cryptocurrency into their operations: Amazon, Cannafarm Ltd, Burger King, even Starbucks, dude!
Пікірлер: 56