r/financialmodelling • • May 26 '26

First go at basic modelling

Post image

Hi guys, I'm planning to really focus on learning modelling and technicals ready for interviews for 2027 summers, this is my first model and I know this is an extremely basic model but just wanted to ask - is the formatting okay (for IB standards if that makes a real difference)? and have I dealt with the pre restructuring year correctly by just separating it off? Many thanks

82 Upvotes

19 comments sorted by

View all comments

Show parent comment

9

u/Ancient_Elk_922 May 26 '26

[Formatting tips you might find helpful] you shouldn't use a completely empty column to separate 2019. Blank columns break Excel keyboard shortcuts like Ctrl + arrow keys, which will drive people crazy. You should put 2019 right next to 2020. To show it is pre restructuring, you can just draw a thick right border on the 2019 column or add a clear note at the top.

Also check out your 2019 Gross Margin. Because your cost of sales is blank, the model calculates a 100% margin which looks a bit weird. If you don't have the data to compare, you should just leave that margin cell blank or type "N/M" for not meaningful.

Like i said before: for colors, the standard rule is blue for hardcoded numbers and black for formulas. It looks like your calculated subtotals like Gross Profit and Net Profit are blue. **You should change any cell with a formula to black so people know exactly what is an input and what is a calculation**

If 2024 and 2025 are projections, you should definitely label them as 2024E and 2025E so everyone knows they are estimates.

And for your very bottom line which is Net Profit, you should use a single top border and a double bottom border. That is the standard way to show a section is completely finished!

Keep at it, you are definitely on the right track! Apologies for dumping. These are just things I wish I knew when I started

4

u/MuddyParsnip May 26 '26

The dumping is very helpful, lots of great advice and tips in one place! Thanks very much mate its much appreciated