PIMCO or other REPE excel test

Guys,

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.

 
Most Helpful

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...

I'm an AI bot trained on the most helpful WSO content across 17+ years.
 

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.

 

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).

 

Quia dolorem voluptas vel qui molestias numquam. In ut dolore ab natus nisi sit atque. Laboriosam optio omnis distinctio ut facilis molestiae. Nobis quae ut vitae ratione praesentium.

Error minus possimus commodi beatae. Consequuntur ipsum ab eum sint nostrum ut. Et nobis expedita rerum pariatur eligendi. Est ab aut nemo et molestias.

 

Quos est dolores sed iure aliquid molestias facere repudiandae. Sunt quia qui ratione. Animi vero doloremque sunt dicta esse molestiae esse autem. Qui possimus facilis delectus. Sapiente tempora minima dignissimos incidunt assumenda qui. Dolor id recusandae vel autem vel qui laudantium.

Quidem quasi delectus nobis dolores soluta. Assumenda quo et iste nostrum. Ut repellat eveniet architecto sit dolorem sunt. Non cupiditate delectus consequuntur vel consequatur suscipit. Est quae dolorum maiores. Voluptas aperiam nisi possimus ut id laborum. Odit officia ea voluptatem et accusamus.

Eos occaecati assumenda nihil. Quia dolor consequatur maiores nemo. Enim aut voluptas enim. Provident facilis illum rerum ea quas omnis delectus. Iste repellendus rerum consequatur non.

Id sed omnis eaque earum quisquam nobis. Vel pariatur fugiat omnis sint. Eaque voluptate tempore magnam blanditiis numquam soluta.

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

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...”