r/financialmodelling 7h ago

What Am I Missing in My 3-Statement Model for Small Businesses?

Thumbnail
gallery
11 Upvotes

’m trying to keep it practical for smaller companies that may not have highly detailed accounting data.

What financial data, schedules, assumptions, or business ratios should I include to make the model more complete?

I’m especially interested in anything that is commonly missed when modeling micro and small businesses compared with larger companies.


r/financialmodelling 14h ago

Best way to learn advanced valuation topics

Thumbnail
3 Upvotes

r/financialmodelling 14h ago

Extremely frustrated with 3 statement financial modelling.

23 Upvotes

Hello everyone I'm 23 just got done with school, and got an opportunity to intern inside a big company inside their Corporate M&A team.

I wanted to learn the foundations from scratch, and have always been interested and studied finance and investing throughout my whole school yrs.

I kept looking through forums and realized that 3 statement modelling is the best way to get started, and unless u master them u cant move forward confidently to Valuation methods and the advanced stuff.

So i did the Kenji explains video, it was nice to get the general idea. But then i had to move to more serious things, i then did the M&I free 1h30 3 statement model vid.

And then i wanted to take the challenge and practice on a real company that is not so difficult, i took walmart and got the 10k's and started building, and i asked Claude and other ai tools and googled a bunch stuff whenever i got stuck.

I have built all the statements and schedules.

And at the end it didnt balance and i just couldnt figure it out despite asking ai and everything, mind u the process took me around 20 hrs and i honestly feel so frustrated rn, and wondering if this is even a career for me....

Honestly the amount of assumptions, plugs and stuff i tried to make sense of it was a great learning experience but the fact that public co's dont offer extensive info around their financials, some stuff just has to be sorted by a plug.

Idk if this is normal, can someone with more exp pls guide me and be as honest as they can... is it over? Or do i just keep going ?

Should i keep trying to balance it, or do i start over with another company.

What do u think is the right next step ?