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
| +39 | Being a 100% Disabled Military Vet Pays as Much as RE Analyst Seat | 34 | 41m |
| +22 | Rate Hikes | 14 | 1d |
| +16 | Senior Living Modeling Help | 5 | 5d |
| +12 | Launching a Development Platform in Greece | 2 | 4h |
| +9 | What are the best undergrad schools for placing in real estate finance? | 16 | 1d |
| +9 | REPE Analyst Firm Advice | 3 | 2d |
| +8 | Hard Money Lenders? | 1 | 1d |
| +3 | BGO REPE LDN | 1 | 5d |
| +3 | LIHTC Syndicator Comp | 1 | 4d |
| +2 | Question on being paid a fee for bringing a developer a site | 3 | 23h |
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.
Et voluptatibus aspernatur sit minus consequatur aut nihil est. Molestiae eum fugiat tempora autem in. Facilis quos odit iusto tenetur. Sequi reiciendis iste voluptatem et sed et.
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...