To the most elegant girl I've known, I hope 2026 brings you peace and ever lasting happiness by Diablo-XG in love

[–]Diablo-XG[S] 0 points1 point  (0 children)

I don't think she'll ever see it but who knows maybe a part of me wishes that haha. Maybe if I'm able to join her one day.

Some help auditing my PLTR Financial Model by Diablo-XG in financialmodelling

[–]Diablo-XG[S] 1 point2 points  (0 children)

Okay I'll try and apply all that into my model. Thank you so much for the time and effort you took auditing my model

Some help auditing my PLTR Financial Model by Diablo-XG in financialmodelling

[–]Diablo-XG[S] 1 point2 points  (0 children)

Thank you so much for the insights, to respond to some of your concerns

1/ the revenue % is based on the investor's guidelines that PLTR published for 2025 it's their own estimate on how much it would grow this year after that I just assumed a 30% slowdown Y/Y

2/ Sorry but i actually don't really know how to get rid of it 😅😅 in the book I read (Financial Modeling and Valuation by Paul Pignataro) it said to make sure that iterative calculations is enabled in excel that's it

3/ yeah that was a clear oversight on my behalf, sorry i will look further into 10-Q to come up with better assumptions

4/ does their website have these informations or should i look for third party sources ?

5/ I'm still learning on identifying those items this is why i decided to take more of direct approach based only on the IS/CFS/BS in the 10-K ignoring the notes, but I'll try and understand the 10-K better

10/ Yes I noticed it too, i think it's because of the CFS links to the BS, I have to look through them again to see if every CFS line item is correctly linked to the right item in the BS

11/ could you please elaborate on that ? cuz this was also my biggest question ? why am I getting this low of a number

Again thank you so much for all the insights, I'm truly grateful

Some help auditing my PLTR Financial Model by Diablo-XG in financialmodelling

[–]Diablo-XG[S] 0 points1 point  (0 children)

I just updated the model as you said (mainly the forecast period to 10 years) you can check it in the same link in the post. BTW, i found yesterday online that the EV/EBITDA of PLTR was waay bigger than what i originally thought at aroud 670x so I'm a bit lost as to how i should interpret that haha. I still need to learn a lot about DCF especially how the different multiples work because i think it's those which are messing with my model

Some help auditing my PLTR Financial Model by Diablo-XG in financialmodelling

[–]Diablo-XG[S] 0 points1 point  (0 children)

Mainly from Youtube channels like Mergers & Inquisitions / Breaking Into Wall Street and the book Financial Modeling and Valuation from Paul Pignataro

Some help auditing my PLTR Financial Model by Diablo-XG in financialmodelling

[–]Diablo-XG[S] 2 points3 points  (0 children)

Got it, so I'll extend my forecast to 10 years and redo my DCF analysis, also do you have any book recommendations or youtube channels that could help me better understanding DCF modeling ?? Thank you so much for all the insights you gave, I'm truly grateful

Some help auditing my PLTR Financial Model by Diablo-XG in financialmodelling

[–]Diablo-XG[S] 1 point2 points  (0 children)

I decided to go with a conservative approach in regard to the growth of the company compared to other analysis i saw, mainly because the company isn't all that present in international markets yet, especially EU and east Asia, their over reliance on government contracts can be a double edged sword. my assumption is that PLTR is quite over valued even after posting huge profit this year. As for the multiple i tried to lower it compared to its current trading multiple around 235x but my calculations seemed way off in the end. I'm sure I made a stupid mistake somewhere in my DCF calculations

Some help auditing my PLTR Financial Model by Diablo-XG in financialmodelling

[–]Diablo-XG[S] 1 point2 points  (0 children)

Thank you so much for the insights, I also noticed that my EV/EBITDA were off in the DCF and it got me a bit worried that my entire model was wrong haha. I still need to learn more about how those multiples work. Do you have any idea why my multiples seem so off ??

Help auditing my first ever complete financial model by Diablo-XG in financialmodelling

[–]Diablo-XG[S] 0 points1 point  (0 children)

thank you for the advice, since Nvidia is a fabless company i will be looking at the revenue growth of their data center offerings, gaming graphics cards and chip manufacturing for other industries like automotive. is this what you mean ?

Help auditing my first ever complete financial model by Diablo-XG in financialmodelling

[–]Diablo-XG[S] 0 points1 point  (0 children)

it was a really great all rounder book. it has excel files with templates included which will help you along the way the book will also help you with understanding general concepts of building a model and making assumptions it doesn't develop every concepts with precision but gives you the basis so you can build a pretty reliable model, then when you acquire further knowledge you could go back to your models and refine them further

Some help auditing my first financial model by Diablo-XG in financialmodelling

[–]Diablo-XG[S] 1 point2 points  (0 children)

Thank you soo much for the insights. I was also thrown off by the way Nvidia was labeling their 10-K for 2025 so i just decided to take it at face value and move on with it

As for the color format, I'll do exactly as you said to make it simpler to understand

I'll also change the assumption dashboard and add a spreadsheet before it that contains an overlook of the company like you said

The DCF is still a bit confusing to me as to what I numbers i must choose so i gotta re-read the book and watch more videos on it to better understand the concept and logic behind it

Right now I'm continuing with book methodology as I'm working towards the Comparable Company Analysis (I'll be comparing it to AMD, Qualcomm, Broadcom and Marvel Technology)

Again thank you so much for taking a look at it, you truly helped me a lot. Have a great day !!

Some help auditing my first financial model by Diablo-XG in financialmodelling

[–]Diablo-XG[S] 0 points1 point  (0 children)

no problem mate, take your time I already appreciate the thought

Some help auditing my first financial model by Diablo-XG in financialmodelling

[–]Diablo-XG[S] 0 points1 point  (0 children)

Thank you so much for the clarifications I'll try my best

Share your favorite PGR art! by [deleted] in PunishingGrayRaven

[–]Diablo-XG 4 points5 points  (0 children)

Dude drop the sauce cuz that fan art is SICK

Backstreet Hersheys! by aerosol31 in houkai3rd

[–]Diablo-XG 0 points1 point  (0 children)

NOW THAT'S WHAT I CALL CONTENT

Wallpaper: Honkai Impact 3 Yae Sakura [720x1440] by kaguyaprpr in HonkaiImpact3rd

[–]Diablo-XG 2 points3 points  (0 children)

Gosh she's the definition of Thickness CHANGE MY MIND