PIMCO or other REPE excel test


Saw someone asking about PIMCO's position recently. I got an excel assessment test from PIMCO HR which seems weird to me because it's just one hour and HR asked me to return the assessment to her when I'm done. I asked what kind of the assessment would be - math or RE modelling but she ignored me. I guess it's a quick excel formula test but I would like to get more info about it. Did anyone take this "assessment" before? What should I expect here? Does it include VBA?

I appreciate any information here.

Real Estate Modeling Course

  • Real-life RE Modeling Tests from actual Interviews
  • Various asset classes including multi-family, commercial and more
  • Huge discount - until more tests and cases added

Comments (13)

Most Helpful
Aug 14, 2021 - 12:02pm

Analyst 3+ in RE - Comm, bummer your thread hasn't had a response yet. Maybe one of these threads could point you in the right direction:

More suggestions...

If those topics were completely useless, don't blame me, blame my programmers...

Aug 17, 2021 - 9:47am

If it's only an hour I'd assume it's either extremely basic excel capabilities (can you write the basic formulas to accomplish a task related to basic financial concepts) or modeling a property's cash flow with assumptions already built out.

The chances of VBA being involved are slim to none. Never heard of a CRE firm testing VBA. I've written maybe 5 lines of unique code in my career and it wasn't a requirement for the task.

  • Analyst 2 in RE - Comm
Aug 17, 2021 - 11:50am

I have taken a number of excel modeling tests and not one had anything regarding VBA. 

VBA is often a skill set people acquire later on to just make their own day to day easier and swing their dick to their manager how amazing they are at excel when in reality no one cares if you know it or not (unless you're in pure data analytics with a F500).

Learn More

300+ video lessons across 6 modeling courses taught by elite practitioners at the top investment banks and private equity funds -- Excel Modeling -- Financial Statement Modeling -- M&A Modeling -- LBO Modeling -- DCF and Valuation Modeling -- ALL INCLUDED + 2 Huge Bonuses.

Learn more
  • Analyst 3+ in RE - Res
Sep 15, 2021 - 7:54pm

How was this? I have a similar one coming up. Also if you made it in the process hwo did it go? Strange they are still recruiting for this. 

  • Analyst 2 in RE - Comm
Nov 22, 2021 - 5:32pm

Bump… do you have any info after taking test?

Nov 26, 2021 - 12:42pm

Nihil sit minima eum est. Est voluptas ipsa dolores. Sint dolorum cumque quidem possimus. Amet molestiae omnis odit assumenda debitis sit.

Maiores eum dolorem quod accusamus. Et explicabo et quis ex. Omnis sequi molestiae perspiciatis ut similique. Qui suscipit et natus. Sed ipsum voluptatem quis quas consequuntur. Deleniti eius harum qui ut. Et veniam ut voluptatem omnis.

Sint expedita ut ipsum autem quis voluptas. Sunt commodi rerum eligendi quia aut. Nisi eum quidem ducimus repudiandae autem autem. Cumque dolores quia eum quos fugit. Quia cupiditate qui vel a eum dolor voluptate.

Qui dicta voluptatem quis ut sunt. Ut labore voluptatem facilis voluptatum quia vitae. Debitis hic eligendi corporis harum aut veritatis sit. Accusamus voluptatem accusantium iste aut et quisquam fugit itaque. Doloribus doloribus aliquam ad est placeat.

Start Discussion

Total Avg Compensation

November 2021 Investment Banking

  • Director/MD (10) $853
  • Vice President (40) $360
  • Associates (236) $235
  • 2nd Year Analyst (144) $156
  • 3rd+ Year Analyst (34) $154
  • Intern/Summer Associate (107) $146
  • 1st Year Analyst (514) $136
  • Intern/Summer Analyst (394) $84