Rolling Up Multiple Asset Models

WSO - how do you guys usually go about rolling up the cash flows for a portfolio?

Often times our models are so complex that it doesn't make sense to just build the proforma in another tab, rather, we have individual worksheets for each asset and then link to the other worksheet for the rollup.

Is there a better way to do this?

 

I think what you're doing is fine. Some people might advise against having links in a workbook, but personally I haven't had issues with it.

But you're right is all properties aren't working off the same chart of accounts it can be difficult. However, I find the best way is to have a "consolidated CF" tab which will have a line item for each peculiarity, should it exist. That way whoever is looking at the tab will be able to see that. Of course for additional detail they just scroll to the individual property tab.

Not a helpful answer really, but simply, yes what you're doing is likely the best bet.

 

They all have to be open or it doesn’t work. I’ve tried to do this, and make them dynamic so you can turn on/off linked cash flows but I’ve come to conclusion that one has to write a macro to automatically update. And that’s where my skills end.

 

You can make it dynamic try this cell (A1): =if(vupdate = ON, indirect(address(blah)), A1). It's a circular reference so you have to toggle iter calcs but it's just self referring (excel stores A1 value in short term memory before updating it so the initial value is never lost).

I think that should do it on the dynamic side. I always just keep the workbooks open so the links update so as to reflect the most recent pro formas in any roll up.

 

Deserunt id est culpa labore eveniet. Vero adipisci molestiae a ab. Ratione mollitia ut voluptates cupiditate et nesciunt ut qui.

Commodi aut impedit magnam doloremque culpa quia ea id. In sint voluptates velit non quos molestiae a.

Career Advancement Opportunities

March 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. (++) 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

March 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

March 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

March 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (86) $261
  • 3rd+ Year Analyst (13) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (202) $159
  • Intern/Summer Analyst (144) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
dosk17's picture
dosk17
98.9
6
DrApeman's picture
DrApeman
98.9
7
kanon's picture
kanon
98.9
8
CompBanker's picture
CompBanker
98.9
9
GameTheory's picture
GameTheory
98.9
10
Jamoldo's picture
Jamoldo
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”