Comments (35)

 
May 14, 2020 - 10:04am

From a quick skim through, all Excel. The most complex stuff I saw are waterfalls, base year stop recoveries (super easy to model in Excel), and % chance of renewal.

Argus modelling tests are actually quite rare from what I know.

 
May 15, 2020 - 12:51pm

Could someone comment here solutions they're getting that he says are correct?

Array
 
May 17, 2020 - 12:08am

no, mechanically it would be either a negative cash flow in month 1 and 15 or year 1 and 2 respectively. But if the NCF for those periods is negative you would need a cash flow reserve that would be capitalized in the sources and uses to either meet a hurle requirement or the dscr requirement. Happy to explain further.

 
Feb 5, 2021 - 11:19am

Hi All ~ if anyone has the unofficial answer keys from personal attempts, would love to connect to cross check my attempts / understanding (I'm a newbie to RE modeling). Please PM!

Start Discussion

Popular Content See all

LETS FKING GO BOYS
+133IBby Intern in Corporate Finance">Intern in CorpFin
You Did it Citi
+120OFFby 2nd Year Analyst in Investment Banking - Industry/Coverage">Analyst 2 in IB - Ind
HELP: Sticky Situation with Boss
+113OFFby 2nd Year Analyst in Investment Banking - Mergers and Acquisitions">Analyst 2 in IB-M&A
Idgaf anymore
+31IBby 1st Year Analyst in Investment Banking - Industry/Coverage">Analyst 1 in IB - Ind
Anyone else just want out of this shit?
+29IBby 2nd Year Analyst in Investment Banking - Generalist">Analyst 2 in IB - Gen
Evercore Target Schools?
+26BSCHby Prospective Monkey in Investment Banking - Mergers and Acquisitions">Prospect in IB-M&A
To Snitch or not to Snitch?
+20OFFby 2nd Year Analyst in Investment Banking - Industry/Coverage">Analyst 2 in IB - Ind

Total Avg Compensation

March 2021 Investment Banking

  • Director/MD (9) $911
  • Vice President (31) $349
  • Associates (162) $231
  • 2nd Year Analyst (97) $151
  • Intern/Summer Associate (92) $144
  • 3rd+ Year Analyst (23) $145
  • 1st Year Analyst (370) $131
  • Intern/Summer Analyst (306) $82

Leaderboard See all

1
LonLonMilk's picture
LonLonMilk
98.5
2
Jamoldo's picture
Jamoldo
98.4
3
Secyh62's picture
Secyh62
98.3
4
redever's picture
redever
97.8
5
CompBanker's picture
CompBanker
97.8
6
frgna's picture
frgna
97.6
7
Addinator's picture
Addinator
97.6
8
NuckFuts's picture
NuckFuts
97.5
9
Edifice's picture
Edifice
97.5
10
bolo up's picture
bolo up
97.5