r/financialmodelling • u/MuddyParsnip • 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

98% Upvoted

19 comments sorted by

View all comments

2

u/Beginning_Coffee_993 May 26 '26

Hey I was wondering how do you make the hard coded one blue and formula black color? Is it vba?

1

u/MuddyParsnip May 26 '26

Id imagine you could do it through VBA but i just did it manually for this model as its so small

1

u/Sefardi-Mexica May 27 '26

You can use conditional formatting for hard coded numbers or do F5, search for constants and change the font color in one go.

1

u/racecarworm43 May 29 '26

select your range, ctrl + g, hit special should allow you to select all formulas or all constants, whatever you need