Excel Modeling Test for Interview

So, I just had a second round interview for a research associate role and then was given a modeling test. I was told to fix three errors in the forecasting period of the IS. At first glance I see four errors in the forecasting periods for Gross Profit as it does not incorporate all 4Qs in FY 2016. Seems too easy that I must be missing something.

Attachment Size
copy_of_val_w_3_errors.xls 1.14 MB 1.14 MB

Comments (26)

 
Mar 3, 2016 - 4:07pm

i will pm you the model with comments ... then you can upload that if you want.. I did not bother to go through the schedules but it is just not the way I would have made the model, i hope this is not the way they actually make the models

 
May 23, 2016 - 10:07am

I identified two errors and was able to make the #VALUE! error dissapear, the model seems to be working OK. However, could you also pm me just for me to check my solving and find out the third error?

"The curious task in economics is to demonstrate to men how little they really know about what they imagine they can design" F.A. Hayek "What can be added to the happiness of a man who is in health, out of debt, and has a clear conscience?" Adam Smith
 
Mar 29, 2016 - 8:15pm

Looks like this RBC, Next time don't publish your model TEST on internet

"The way to make money is to buy when blood is running in the streets." -John D. Rockefeller
 
May 1, 2016 - 4:37pm

Interested as well, Can you pm updated model. thanks

Array
 
May 1, 2016 - 8:11pm

Could you please me the updated model as well? Thank you!

What concert costs 45 cents? 50 Cent feat. Nickelback.

Start Discussion

Popular Content See all

IB Sucks. I'm out
+58IBby 1st Year Analyst in Investment Banking - Generalist">Analyst 1 in IB - Gen
IB is not intellectually challenging
+52IBby Intern in Investment Banking - Mergers and Acquisitions">Intern in IB-M&A
Janet Yellen - Unrealized Capital Gains Tax. WTF
+27OFFby 1st Year Analyst in Investment Banking - Generalist">Analyst 1 in IB - Gen
VP Lying
+23IBby Prospective Monkey in Investment Banking - Mergers and Acquisitions">Prospect in IB-M&A

Total Avg Compensation

January 2021 Investment Banking

  • Director/MD (9) $911
  • Vice President (31) $349
  • Associates (141) $232
  • 2nd Year Analyst (88) $152
  • 3rd+ Year Analyst (19) $150
  • Intern/Summer Associate (91) $144
  • 1st Year Analyst (351) $132
  • Intern/Summer Analyst (299) $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
CompBanker's picture
CompBanker
97.9
5
redever's picture
redever
97.7
6
frgna's picture
frgna
97.6
7
Edifice's picture
Edifice
97.5
8
Addinator's picture
Addinator
97.5
9
bolo up's picture
bolo up
97.5
10
NuckFuts's picture
NuckFuts
97.5