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
| +43 | What Is Your Backup Plan? | 20 | 14h |
| +39 | Where are free agents signing? | 21 | 20h |
| +36 | AvalonBay Equity Residential Merger discussion | 16 | 18h |
| +34 | Future of Real Estate | 9 | 23h |
| +31 | Laughable Job Posting | 12 | 16h |
| +16 | Extremely Slow Ramp Up | 1 | 2d |
| +14 | In RE, what is the ONE software tool you couldn’t survive without? | 5 | 2d |
| +10 | Dynex | 5 | 1d |
| +9 | Development Budget: use RENTABLE or GROSS BUILDABLE sf? | 3 | 3d |
| +9 | Portfolio Management strategy/transaction exposure on the analyst/associate level? | 1 | 1d |
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.
Necessitatibus distinctio est assumenda aut rerum. Labore nihil voluptas quibusdam numquam quisquam qui eveniet doloribus. Praesentium eaque est est laboriosam accusantium ut sint.
Fugiat sed ut ullam quae eum omnis. Necessitatibus assumenda pariatur sunt qui similique eius iusto.
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...