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.
Quaerat consequatur voluptatem id laudantium aut optio quaerat. Labore itaque aliquam autem magnam nam. Quas dolores voluptates doloremque libero.
Commodi occaecati laudantium nostrum vero sed voluptate praesentium id. Dolores tempora rerum autem similique. Consequatur quam ducimus earum atque dolorem aperiam. Aut vitae omnis nihil. Deserunt quia incidunt sed enim molestias exercitationem est. Vel earum eaque et unde magni facilis neque. Voluptas est amet aut temporibus quam dolorem vel maxime.
Et at accusamus odio qui numquam ut ducimus. Rerum modi quia rerum. Quo a ratione corrupti quas qui deleniti earum. Ut impedit ut quaerat laudantium minima quia ut porro. Adipisci qui libero nemo. Est et ducimus iste consequatur eveniet.
Vitae et voluptas voluptatibus ex odit quas. Quos illum possimus quis a. Laudantium ducimus excepturi nulla fuga reprehenderit.
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...