Hey guys - a few posts ago there was someone who used the attached model case study for critique. I did this relatively quickly during my down time - so I'm sure there are errors to be caught. However, I feel that I have done enough modeling and underwriting to have a decent grasp of how to complete the exercise, and wanted to share for others. Only reason I used this PGIM copy was that it has been shared on this forum before, and appears readily available to the public.
Note that I used a macro for the goal seek question. To replicate this macro, you can use the excel goal seek took...the inputs are built out in cells B40 and B41. ALSO - I use 2016 excel...looks like the attachments are only for excel 97-03 (.xls)??? Anyway, this might all blow up for someone who doesn't have the compatibility. I tried to save as .xls, but it gave me a bunch of compatibility errors. Not sure why as they are all just basic formulas, but formatting might get jacked up...
TO BE CLEAR - this template is currently used by PGIM for potential analysts during their interview process. I have a few contacts within Pru, and they have seen this model. Not that anyone would, but to prevent anyone from taking this exact template/example and submitting it for potential job offer, I wanted to mention this and prevent any potential issues.
I have a few other models/case study examples...I will submit them as well when I have time.
Thanks !!
| Attachment | Size |
|---|---|
| MF case study from PGIM 262 KB | 262 KB |
