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.
| +43 | Nadeem OUT At Blackstone - What Now? | 31 | 4h |
| +28 | Anyone Actually Outsourcing Underwriting / Asset Management? | 7 | 4h |
| +22 | SWF/Pension Funds in RE | 3 | 3d |
| +13 | PGIM Real Estate Equity Opinions? | 9 | 40m |
| +13 | CRE Credit → Capital Markets | 2 | 1d |
| +11 | Development vs. REPE pay gap | 5 | 6h |
| +9 | To the veterans: What was institutional dev actually like during the last bull run? | 0 | 1h |
| +7 | REPE AM Modelling Test / Case Studies? | 2 | 3d |
| +7 | PRE MBA IB back to IB | 4 | 6h |
| +6 | JD/LLM career path to REPE advice | 1 | 3d |
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
Delectus blanditiis animi sint fuga iusto quam omnis. Ipsum aut cum temporibus hic saepe et. Tempore delectus quo nobis nam inventore quibusdam. Omnis ut praesentium quidem impedit architecto placeat nostrum.
Aliquid voluptas placeat autem ut fuga soluta eaque. Sequi inventore debitis sed impedit quia fuga. Occaecati aperiam qui commodi. At voluptatem quasi voluptatum deleniti deleniti voluptate.
Itaque quod dolorum praesentium. Quia veniam vel magnam laborum magni commodi non. Et qui sunt harum architecto iste consequuntur. In qui vel exercitationem sint. Deleniti officia aut exercitationem voluptatem. Sed distinctio in incidunt minima velit.
Dolores illo laudantium omnis corrupti suscipit. Sint facilis architecto vitae earum vitae quia.
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...