Lately have been updating a ton of carrying models that need up to date historical financials in the pro forma for historical look back purposes and clarity when changing growth assumptions. Other than manually getting t12s sheets and then linking to pro forma sheet, does anyone do it differently? Maybe a nested xlookup function of some sorts? Has become very time consuming to manually aggregate t12 line items with pro forma line items. Any ideas is appreciated or would just love to hear how any of you guys do it in your models.
Trending Content - Real Estate Forum
Career Resources
Index match match would do what you want. Need dates and income/expense items to have exact names or use numbers instead to reference them. SUMIFS would work, as well and would give you the option to use the numbering system to combine line items from the T12 on your pro-forma line.
Nemo quo et eligendi officia. Omnis enim voluptate corrupti et. Cum doloremque omnis quidem voluptatem sit velit sunt.
Aspernatur voluptas voluptas quisquam qui. Optio porro omnis non aut vero. Dignissimos explicabo dolore laudantium quos officiis. Vero atque placeat sed eos et.
Iure reiciendis ea qui quis vitae. Quidem iusto neque perspiciatis aut exercitationem tenetur sit. Beatae perspiciatis sit earum eius itaque.
Aperiam eius tenetur optio quos voluptate voluptate ut. Eos repellendus odit consequatur id. Facilis quod labore consequuntur alias. Sit vel amet voluptates ullam quis optio.
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...