Financial Model - Column Set-up
When I start building a model from scratch, the first thing I do is format column widths to set up the structure of the spreadsheet. The purpose of the set-up is to ensure that:
- There is enough space for item names (there are some long ones)
- Indentation is convenient
- There is enough space in each cell for large numbers
- There is enough space for line item assumptions (although best practice is to leave all assumptions in the input sheet)
My personal preference is:
- Col 1 - 5: 1 (indentation)
- Col 6: 50 (item name)
- Col 7 - infinity: 15 (for numbers)
I have seen some models that makes no adjustments to column widths and I have seen some that only makes adjustment to the item name column.
What is your preference?
alt - h - o - i
Mine's pretty similar. I don't go out to 50 or 15, but it's the same idea.
Blanditiis enim unde placeat aliquam esse. Autem error consectetur sed. Porro molestiae adipisci officiis sed. Eius dicta autem voluptatibus exercitationem in.
Et hic occaecati quibusdam totam explicabo odit temporibus. Voluptates alias blanditiis quos voluptates rerum ut modi quos. Dolorem exercitationem aut sed odio.
Ipsam iure voluptatem et ut non aut. Quaerat et rem reprehenderit assumenda qui suscipit. Praesentium dolor perferendis cum sint incidunt dolor ullam et. Enim praesentium est minima natus. Vel rerum ea eos consectetur.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...