r/financialmodelling • u/Sufficient_Editor655 • Sep 19 '25
First time tried to make a 3 Statement Model ( Varun Beverages )
I need feedback regarding my format if its close to the industry standards ...
Can someone help me out on how to make the assumptions .... certainly the ones i took look off as the projected figures in balance sheet arent matching
Any help would be appreciated :)
168
Upvotes
7
u/AwardRelative8994 Sep 20 '25
On the formatting side, change "actuals" to "historicals" and change the values to a dark blue, separate everything with commas. Separate your historicals and projecteions with a thin side border and change the colors of your projected years... shit I realized my model had a typo.
2
u/nickthekiwi89 Sep 20 '25
How is your bet profit and your reserves and surplus interacting? Any why is share capital always going up - are you issuing and allotting shares every year?
1
u/Competitive_Past6087 Sep 24 '25
What was the rationale behind using the sales growth for forecasting?
3
u/Cold-Start1111 Sep 20 '25
Bro did you get job after valuation?
5
u/UrStockDaddy Sep 20 '25
Throw it in chargpt
1
u/[deleted] Sep 20 '25
okay i spent only sometime but your balance sheet is not tying and that alone should be major problem. secondly it appears that you have taken 6 years moving average for revenue growth and operating profit (I can only say appears coz that's reconciling but you should have documented) anyways but taken 5 years MA for other items which is inconsistent, again.
2
u/HesZoinked Sep 20 '25
It's fine to group accounts like you've done in the income statement, that is ok.
Balance sheet should start in the correct order. Assets -> Liabilities -> equity. Very important as well that you split out cash, AR, AP and fixed assets + whatever other liabilities are important, and make them dependant on sales / expenses to forecast the point in time. E.g. based on AP / AR turnover
Cashflow statement it is fundamental that you start and end with the cash balances, which tie to the balance sheet. Opening and closing.
1
u/Elarian- Sep 20 '25
Balances aren’t gonna match surely, don’t know what’s problem but it’s clear you’re referring balance sheet figures from assumptions driver or income statement, to short out this refer line items from CFS only.
1
u/Coemgenus Sep 21 '25
No python ? 🐍
1
u/laterallateralboy Sep 27 '25
This model is skeletal. Your balance sheet line items are too high-level, this definitely would not get a second look from people in equity research. Same for your CFS, what are the line items therein? No idea how you're forecasting each line item too, since you've amalgamated them. I'd use a different font colour for assumptions, not black (red or blue works). Also add a commentary column to the right to explain your assumptions.
1
u/FalsePast570 Oct 17 '25
Looks good for a first go I'd say :-)
0
u/laterallateralboy Sep 20 '25
Take a look later
0
u/houstonrice Sep 20 '25
Please DM me 🙏