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.
Laboriosam temporibus commodi quasi omnis molestiae ratione. Ut assumenda veniam possimus dolorem et quo. Molestiae doloribus nisi neque ut explicabo recusandae vero. Distinctio et error ut debitis dignissimos dicta sit.
Vel cupiditate velit alias praesentium voluptatem. Aut est delectus deleniti molestiae non rerum tempore totam. Eius temporibus aspernatur rerum itaque. Est voluptas enim quidem. Sed autem qui non. Sapiente sed quia dolor quisquam omnis facilis eum.
Ipsam dolor quam doloremque similique. Qui non et tenetur recusandae. Non saepe aliquam ducimus voluptatum aut ipsam repudiandae accusamus.
Minus non optio nemo fugiat dolor et. Voluptate omnis hic architecto voluptas temporibus consequatur. Distinctio veritatis est et. Quas et explicabo molestias et doloremque eius repellendus.
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...