Thanks for watching guys!! I know this video was looong but I hope you still enjoyed it :) Lmk if there are any other videos you would like to see from me🎉
Firstly, my sincere gratitude for the thorough and detailed content! Sencondly, I would like to take the oppotunity to ask if you could do a video of excel best practices while financial modeling? Please allow me to add am exemaple to help bring some color to my sugestion: cells in green are inputs, add a column for the unit used in the line, add a column for totals, etc...
Thank you so much! I'm happy you enjoyed it🤗 would love to share the model here too, I just don't know how. But if you type your email in the comments here, I'll send it to that🙌
Hello, thanks for the video. If I need to create DCF model (for potential investors) and our company (E-Commerce, IT SturpUp) doesn't use any loans, operates only according to the own cash flows and money (i.e. there's exist value of equity, but value of Debt = 0), how to calculate WACC and what's the better way in such case? Thanks
thank you so much!!🤗 I made two COGS lines and two revenue lines just for breakdown if someone wanted that (for example revenue and COGS from two different regions or something). Not sure that I understand your question, what do you mean? :D
@@pearlstella I have assumed that the cost of project through time is related to inflation rate of the economy (= interest rate), so should we multiply cost of project (=COGS) to interest rate?
Thanks so much Karan!🤗 It's tough to set a salary range for analyst jobs because it depends on so many things (country, city, company, # of work hours, years of experience). I think for corporate finance analyst jobs at bigger companies in big cities in the US, I would say the typical salary range is 80k-120k, maybe 100k-180k for senior analysts, all before tax. Tax % also depends on where you live (income, state, city, country) but 30% in taxes if this is your salary in the US would be a reasonable estimate
@@pearlstella Thanks for replying. I am a bit confused whether I should join data science or finance. any advice? I think DS is better short term but long term pay and career growth finance wins?
thank you 🤝
Thanks for watching guys!! I know this video was looong but I hope you still enjoyed it :) Lmk if there are any other videos you would like to see from me🎉
Thank you for the time and effort you put for this video,
thank you! your comment made my day🤗
This video is awesome. Super helpful!
Thank you! So happy you found it helpful🤗
Finallyyyy we want moooooooooreee
haha thank you so much!! You'll get more too😉
Firstly, my sincere gratitude for the thorough and detailed content! Sencondly, I would like to take the oppotunity to ask if you could do a video of excel best practices while financial modeling?
Please allow me to add am exemaple to help bring some color to my sugestion: cells in green are inputs, add a column for the unit used in the line, add a column for totals, etc...
Great content!
Thanks so much!
Hello there, why you disapear for a long time 😂😂 thanks for sharing, Ramadan Kareem 🌙🙏
haha I know!! These videos just take a long time to make and it's tough when I'm working long hours too, but doing what I can😃🙌 Ramadan Kareem🎉
Can you make a video on some important excel formulas we can use while creating a DCF?
that's a great idea, thank you! and yep definitely🤗
Can you please send me the excel sheet of DFC
That is excellent video thanks for sharing. Keep going . one note I wish you could share a copy of the DCF model here since I don't have Instagram
Thank you so much! I'm happy you enjoyed it🤗 would love to share the model here too, I just don't know how. But if you type your email in the comments here, I'll send it to that🙌
Hello, thanks for the video. If I need to create DCF model (for potential investors) and our company (E-Commerce, IT SturpUp) doesn't use any loans, operates only according to the own cash flows and money (i.e. there's exist value of equity, but value of Debt = 0), how to calculate WACC and what's the better way in such case? Thanks
tbh this was a awesome video, just a quick question, in the project DCF tab, why you don't multiple IR rate in the COGS 1 & 2 cells?
thank you so much!!🤗 I made two COGS lines and two revenue lines just for breakdown if someone wanted that (for example revenue and COGS from two different regions or something). Not sure that I understand your question, what do you mean? :D
@@pearlstella I have assumed that the cost of project through time is related to inflation rate of the economy (= interest rate), so should we multiply cost of project (=COGS) to interest rate?
Hey great video. Whats the salary range for analyst jobs? 100-125k$? And especially after tax how much is left😂
Thanks so much Karan!🤗 It's tough to set a salary range for analyst jobs because it depends on so many things (country, city, company, # of work hours, years of experience). I think for corporate finance analyst jobs at bigger companies in big cities in the US, I would say the typical salary range is 80k-120k, maybe 100k-180k for senior analysts, all before tax. Tax % also depends on where you live (income, state, city, country) but 30% in taxes if this is your salary in the US would be a reasonable estimate
@@pearlstella Thanks for replying. I am a bit confused whether I should join data science or finance. any advice? I think DS is better short term but long term pay and career growth finance wins?
i wish i could meet u
Learnt a lot from this. Thank you for sharing. Can one reach out to you via email?
I'm so happy to hear that, thank you!! Absolutely, you can email me at pearlstellayt@gmail.com 🤗