RE Cash Flows & DCF Excel Test

Hi. I have an Excel test for a firm that I need to complete. It’s for a hospitality asset with the revenues and expenses given. How would one find assumptions for revenue and expense growth? With no Covid in mind. 

2 Comments
 

Qui praesentium magni sint. Quasi suscipit tenetur praesentium assumenda.

Quam ratione mollitia qui illo. Saepe voluptatem sapiente sunt a ratione saepe ab tempora. Quo consequatur et asperiores voluptates ad rerum ut corrupti. Sit deserunt id aut nihil soluta animi expedita.

Amet neque voluptatum et et fugit atque. Sit illo eos soluta et. Recusandae harum ut dignissimos ab et. Quidem aperiam ab eum praesentium in tempora.

Et voluptas quia occaecati debitis voluptates. Vel omnis pariatur voluptatem dolorem quam perspiciatis. Eos porro voluptatum rem alias laboriosam. Rerum ea est beatae voluptas.

Career Advancement Opportunities

August 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.3%
  • Morgan Stanley 08 97.8%
  • Goldman Sachs 02 97.2%

Overall Employee Satisfaction

August 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Evercore No 98.9%
  • Morgan Stanley 01 98.3%
  • Banco Santander 02 97.8%
  • BMO Capital Markets 12 97.2%

Professional Growth Opportunities

August 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 06 98.3%
  • Goldman Sachs 01 97.8%
  • JPMorgan 01 97.2%

Total Avg Compensation

August 2026 Investment Banking

  • Vice President (16) $429
  • Associates (47) $258
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (25) $178
  • Intern/Summer Associate (14) $159
  • 1st Year Analyst (83) $151
  • Intern/Summer Analyst (74) $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
BankonBanking's picture
BankonBanking
99.0
4
kanon's picture
kanon
99.0
5
DrApeman's picture
DrApeman
98.9
6
CompBanker's picture
CompBanker
98.9
7
dosk17's picture
dosk17
98.9
8
GameTheory's picture
GameTheory
98.9
9
Betsy Massar's picture
Betsy Massar
98.9
10
Mimbs's picture
Mimbs
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...”