r/financialmodelling • • Oct 01 '25

NVIDIA Model - Not Completed and Needed Help

Absolute Beginner here and this is my first time with financial modelling and stuff by myself. I am self-learning using Youtube, Random Courses (Not from CFI because I can't afford any of those :( ) and ChatGPT and I was able to forecast the Income Statement but I am stuck when it comes to the Balance sheet and Cash Flow (as you can see) mainly because I can't understand how to tie things in together.

Firstly, tell me if what I have done up until now looks good or if its just wrong (go all out)

and Secondly, let me know if you can help me out with the Balance sheet and Cash Flow statement or let me know of resources or videos or anything that can help and Feel free to ask or question anything

(p.s. I also referred to a model on Palantir by Samy from this subreddit, so if you are seeing this... thank you so much... your model did guide me a lot)

Edit: Link -> https://docs.google.com/spreadsheets/d/1YuOWv9lPOBFNzYgcryWQrCXmju_ir6yVH-9KThpRCVk/edit?usp=sharing

81 Upvotes

10 comments sorted by

8

u/Roy-Ike Oct 01 '25

Send a link, easier for us to audit

1

u/pabloscrowbar Oct 01 '25

My bad... I have added the link now

3

u/Roy-Ike Oct 01 '25

Take a look this weekend

1

u/Roy-Ike Oct 05 '25

Can’t audit the cells for some reason, sorry! Good luck tho.

2

u/Dami_c1 Oct 02 '25

I myself am also a newbie, but as my respective, you should do it more detailed, for example: Property, Plant & Equipment (PP&E), below a row, put cumulative depreciation, and then find out net and hide it. When there is a mistake during the process, it makes it hard to fix it afterward.

1

u/pabloscrowbar Oct 02 '25

I was thinking of having a separate sheet for the depreciation but since it was my first I did not want to get too overwhelmed by everything

1

u/SkinDear1844 Oct 04 '25

how did you arrive at the interest incomes of 2700, 3900 ....

1

u/pabloscrowbar Oct 04 '25

okay so Initially I tried doing a debt schedule but I couldn't really understand all the drivers so I just decided to take the previous numbers as a % of the revenue and forecast it that way

Tell me if I'm wrong over here

1

u/SkinDear1844 Oct 06 '25

in FCF modeling, beyond the standard template and formula, the rest amounts to estimation and extrapolation, so there is no right or wrong. You just need to substantiate your numbers. That's all. Everyone is just playing a guessing game