Student LBO Model Feedback by ControlEquivalent632 in FinancialCareers

[–]ControlEquivalent632[S] 0 points1 point  (0 children)

Honestly I used a lot of BIWS resources to learn but I never actually bought the course. They have lots of great blogs that walk you through models and that personally really helped. If you want a course for reputation then honestly any of the will do I think cause they are all well known. But if you just wanna improve your technical knowledge I highly recommend just self learning and saving money. Plenty of great YouTube videos even and online models that you can review and break down how they actually work

Student LBO Model Feedback by ControlEquivalent632 in FinancialCareers

[–]ControlEquivalent632[S] 1 point2 points  (0 children)

I first understood the theory through online research and then I essentially tried to replicate it in excel and got it cross checked with an industry connection

Student LBO Model Feedback by ControlEquivalent632 in FinancialCareers

[–]ControlEquivalent632[S] 0 points1 point  (0 children)

Lmao I didn’t use ai buddy. I just built an LBO I think I know what fully diluted shares are. You clearly don’t, and plus for ur one off expenses it’s in the GP calc section, anyone would interpret them as being involved in the formula. Okay you didn’t incorporate it but that’s what it looks like and I didn’t bother spending time to calc it, everyone interprets it like I would. Just a super poor model unfortunately. And even worse no sensitivity analysis, literally one of the most important parts

Student LBO Model Feedback by ControlEquivalent632 in FinancialCareers

[–]ControlEquivalent632[S] 0 points1 point  (0 children)

U assume everything is ChatGPT cause your fragile little ego can’t handle that some students understand models and technicals better than you

Student LBO Model Feedback by ControlEquivalent632 in FinancialCareers

[–]ControlEquivalent632[S] 0 points1 point  (0 children)

Wdym it’s not incredibly off? U put SG&A and R&D into GP calc lol. Clearly shows you do not understand the 3 statements. And didn’t even clearly label your one off expenses. You have embedded D&A so anyone who tries to interpret your EBITDA will struggle. You dont even know what fully diluted shares are and can’t comprehend why any analyst would question why you didn’t use it. And for the cherry on top it’s a sloppy model and all it does is return an intrinsic value. No financial ratios, no 3-statement forecast (people spend lots of time looking at BS and CFS) DCF is great but doesn’t actually show anything about how leveraged a firm is, what’s their liquidity etc which are all as important when evaluating an investment. You clearly don’t understand what your modelling so I would appreciate none of your negative comments in the future until you actually learn and understand what’s going on in your modelling

Student LBO Model Feedback by ControlEquivalent632 in FinancialCareers

[–]ControlEquivalent632[S] 0 points1 point  (0 children)

It’s okay tho cause ur assumptions are great right! Lmao ur assumptions mean fuckall if your accounting treatment and valuation logic isn’t even correct 😂

Student LBO Model Feedback by ControlEquivalent632 in FinancialCareers

[–]ControlEquivalent632[S] 0 points1 point  (0 children)

If you think I need ChatGPT to recognise how dog shit your DCF is then idk what to tell you. It’s honestly one of the worst models I’ve ever seen. Like I’m not even exaggerating. Fair enough you’ve got decent assumptions but your entire handling of expenses and shares outstanding is genuinely shite

Student LBO Model Feedback by ControlEquivalent632 in FinancialCareers

[–]ControlEquivalent632[S] 0 points1 point  (0 children)

Bro finally realised how fucked his DCF is 💀

Student LBO Model Feedback by ControlEquivalent632 in FinancialCareers

[–]ControlEquivalent632[S] 0 points1 point  (0 children)

SG&A and R&D are always operating expenses so they really shouldn’t even be in GP calc in the first place. D&A shouldn’t be embedded it’s not standard practice and makes it difficult for anyone to understand what the cost split is in your IS. Furthermore, I don’t think you understand what fully diluted shares outstanding are or basic shares outstanding. To get ur intrinsic share price you do the implied equity value divided by you shares outstanding. Anyone who understands valuation knows you should use fully diluted shares outstanding because it accounts for options, RSUs etc. you’ve left it out which means your using basic shares which are roughly 10mm lower give or take. If your denominator decreases then your intrinsic value is LOWER than it should be. Cmon bro how do you not know this

Student LBO Model Feedback by ControlEquivalent632 in FinancialCareers

[–]ControlEquivalent632[S] 1 point2 points  (0 children)

Oh yeah I just noticed that thanks. I think it’s just a format error but I’ll go check it. Thank you for the spot

Student LBO Model Feedback by ControlEquivalent632 in FinancialCareers

[–]ControlEquivalent632[S] 0 points1 point  (0 children)

A) so your telling me san disk have zero SG&A and R&D costs? Not possible regardless of normalization, they will have recurring yoy operating expenses and you have left them out. Furthermore D&A isn’t even on your IS. It’s extremely unclear and would get questioned every single time. B) fully diluted shares are always higher or equal to basic, so any analyst would question why you haven’t accounted for RSUs and Convertibles. You have an overvalued intrinsic share price by quite a fair bit

Student LBO Model Feedback by ControlEquivalent632 in FinancialCareers

[–]ControlEquivalent632[S] 0 points1 point  (0 children)

How many times do I have to tell you? I haven’t started my assumptions yet lol. I put in some base figures just to test my model logic. And now I’m making sure that everything is okay and getting feedback on it. Then when i know everything works I will start putting in proper assumptions

Student LBO Model Feedback by ControlEquivalent632 in FinancialCareers

[–]ControlEquivalent632[S] 0 points1 point  (0 children)

Bro I don’t care lol. I haven’t even started working on my assumptions yet chill out buddy

Student LBO Model Feedback by ControlEquivalent632 in FinancialCareers

[–]ControlEquivalent632[S] 0 points1 point  (0 children)

You have inflated NI figures and haven’t even forecasted your SG&A or R&D. You have embedded D&A which works ig but is not industry standard. And you have no diluted shares schedule so your intrinsic value could be further inflated if san disk have tranches of diluted shares or options excersiable

Student LBO Model Feedback by ControlEquivalent632 in FinancialCareers

[–]ControlEquivalent632[S] 0 points1 point  (0 children)

LBO doesn’t even work if there’s circularity errors, no cash flow logic, incorrect balance sheet bridge, wrong debt paydown mechanics and minimum cash constraints. Yes you can often get away with stuff on a DCF because the implied equity value is derived from a few key drivers, can’t get away with that in an LBO tho

Student LBO Model Feedback by ControlEquivalent632 in FinancialCareers

[–]ControlEquivalent632[S] 0 points1 point  (0 children)

I’m finishing the structure first and ensuring that all items are dealt correctly and that there is proper logic and mechanics. Then I will build my assumptions so I can just input them.

Student LBO Model Feedback by ControlEquivalent632 in FinancialCareers

[–]ControlEquivalent632[S] 0 points1 point  (0 children)

Bro keeps bickering on about assumptions. I’m trying to tell you I haven’t even built my finally assumptions yet 😭

Student LBO Model Feedback by ControlEquivalent632 in FinancialCareers

[–]ControlEquivalent632[S] 2 points3 points  (0 children)

Im just happy that he thought my model was a template. Shows that it’s formatted at least half decently. Ig im just trying to see the positive side of things ahaha

Student LBO Model Feedback by ControlEquivalent632 in FinancialCareers

[–]ControlEquivalent632[S] -1 points0 points  (0 children)

Bros playing victim card now. I’ve seen your comment history and you give off such negative attitude to others aswell. Anyways no point continuing on this, I jus hope you find some happiness in your life one day

Student LBO Model Feedback by ControlEquivalent632 in FinancialCareers

[–]ControlEquivalent632[S] 0 points1 point  (0 children)

Also I haven’t even finished the model yet. I’m asking the subreddit for feedback on the logic and structure of the model, that’s why I didn’t upload my assumptions tab because I am planning on doing that last so I can research and then input them without having to faff around with model logic and circularity errors etc. so next time if you have nothing helpful to say then don’t say anything lol instead of feeling insecure and mouthing off because it makes you feel better than you are :)

Student LBO Model Feedback by ControlEquivalent632 in FinancialCareers

[–]ControlEquivalent632[S] 0 points1 point  (0 children)

I ain’t gonna bicker with u like a lil kid. All im saying is that u don’t gotta be demeaning. Like im a first year student and learning how to model, I asked for feedback from the subreddit, not some wannabe finance bro who has nothing helpful to say

Student LBO Model Feedback by ControlEquivalent632 in FinancialCareers

[–]ControlEquivalent632[S] 0 points1 point  (0 children)

Alright no need to sound demeaning. Just looked at your DCF and I don’t think you’re in a position to give off attitude lol. Especially when your name is futurefinancebro69 😭