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.
| +32 | Are Co-GP development structures successful? | 12 | 16h |
| +19 | Capital Formation/Capital Raising Roles Q | 2 | 1d |
| +19 | How to move from Real Estate to Infrastructure? | 14 | 1d |
| +13 | Multifamily Job Search Advice | 3 | 2d |
| +9 | Insurance company RE investments internship, how is it viewed? | 3 | 14h |
| +5 | TA Realty | 2 | 2d |
| +3 | What Are the Biggest Financial Challenges in Custom Home Construction? | 1 | 5d |
| +3 | UK Capital Raising Environment | 1 | 3d |
| +3 | Wells Fargo RESF | 1 | 10h |
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
Odit qui dolor aspernatur nam. Corporis laboriosam autem mollitia. Quia ab non quia praesentium dolorem. Dignissimos similique amet aut totam ea necessitatibus voluptatem.
Quia adipisci deleniti aperiam voluptatem est. Pariatur saepe quae suscipit est. Sed dolores tenetur aut est eum sit velit. Est et in in neque aspernatur.
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...