I want to make a template in excel that I can feed argus cash flows into for the purpose of valuation/modeling. Does anyone have any tips on how to do this? I'm assuming some INDEX/MATCH should go a long way but want some tips from anyone who has done this before.
| +41 | What Is Your Backup Plan? | 17 | 5h |
| +38 | Where are free agents signing? | 19 | 14h |
| +32 | Future of Real Estate | 9 | 1h |
| +31 | Laughable Job Posting | 11 | 17h |
| +30 | AvalonBay Equity Residential Merger discussion | 12 | 1h |
| +16 | Extremely Slow Ramp Up | 1 | 1d |
| +14 | In RE, what is the ONE software tool you couldn’t survive without? | 5 | 1d |
| +10 | Dynex | 5 | 6h |
| +9 | Development Budget: use RENTABLE or GROSS BUILDABLE sf? | 3 | 3d |
| +6 | Heitman - Chicago | 7 | 3h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
=+IFERROR(INDEX(ArgusInputs!$C$8:$Y$200,MATCH('Cash Flow'!$B25,ArgusInputs!$B$8:$B$200,0),MATCH('Cash Flow'!E$6,ArgusInputs!$C$5:$Y$5,0)),0)
This is my formula, pretty simple IDEX/MATCH/MATCH, but I wrote (asked ChatGPT) to write me a macro that will format the line items that argus spits out, so I dont need to do it manually.
I have also seen adding the CHOOSE Function so you can pick from multiple scenarios.
perfect, glad my intuition seemed okay. Thanks, big help
Recusandae minus perspiciatis facilis. Laboriosam debitis magni ut. Incidunt reprehenderit esse eos perferendis.
Tempore quae maiores distinctio adipisci. Non quidem perspiciatis iste. Rerum iure fuga alias vel enim. Quaerat provident officia sed perferendis aut voluptatem.
Tempore dolorem aut deleniti eius dolores et repudiandae. Ipsum deserunt deserunt voluptas dignissimos placeat. Error dolores qui dignissimos sint quia sit et. Quis rerum id rerum quae. Dolorem vel dolorem et numquam voluptatem ipsum sed. Est blanditiis totam reiciendis itaque rerum non officiis omnis.
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...