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.

Office spreadsheet icon copy_of_val_w_3_errors.xls1.14 MB

Comments (26)

Mar 2, 2016

What bank was this for?

Mar 2, 2016

MM Bank

Mar 3, 2016

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

Mar 29, 2016

Could you also PM me please? thanks

May 12, 2016

What are some of the changes you would make to the model to have it fit more in line with what you would make? Or would you just make it in a completely different way?

May 12, 2016

completely different

May 23, 2016

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

May 25, 2016

Hi, Qureshi,

Could you please Dm me the model ?


May 25, 2016

Hi, Qureshi,

Could you please Dm me the model as well. I'd love to see if my output matches yours


Apr 25, 2018

@Qureshi Could you also PM me? Thank you!

Mar 29, 2016

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

Mar 30, 2016

just update your post with the edited model and the comments in a word doc it will be easier for others

May 1, 2016

Also interested. Could you pm me aswell? Thankkyou

May 8, 2016

Qureshi - mind PM'ing me as well? Thank you.

May 1, 2016

Interested as well, Can you pm updated model. thanks


May 1, 2016

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

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

May 10, 2016

anyone who wants me to PM the model corrections ask @IronCondorGorilla it his/her to give, first try to solve it on your own and if you have something you need some help with, I will give you a few hints, solving it on your own will give you practice

May 20, 2016

Hi guys. Can someone help me with this? I fixed the few things in the IS but more importantly how do I fix the circularity?

Thx in advance!!!!

May 25, 2016

Can someone pm me the solution? Just want to double check. Thanks

May 25, 2016
Dec 19, 2017