Challenge MCT Question
Many of the solution is hardcoded, very hard to follow, can you link the solution to the actual question if you're using it.
** Next time put in the link in there! https://www.osfi-bsif.gc.ca/en/guidance/guidance-library/minimum-capital-test-guideline-2024#Toc-4.2
1) Where exactly are you getting the risk factors from in grey:
I don't see it in the reading either, only 10% for auto..
Comments
2) Earthquake Reserve Component and Earthquake Reserve
I've linked most of what I could and the hard coded numbers are those where it was difficult to link to specific cells.
1) Next time, can you put the link in there for quick reference. https://www.osfi-bsif.gc.ca/en/guidance/guidance-library/minimum-capital-test-guideline-2024#Toc-4.2
2) As an example, I spent so much time trying to figure out where you are getting 63 mill from? and then the 20 - 2.5%?
i) the 63, my 'guess' is that it is the 45 + 18.
How can you say you tried your best trying to link answer to questions when majority isn't.
ii) so the 20% is taken out of that .2 * (A +B + C+D) calc and then added to the 2.5% as credit risk, hence 17.5 net difference..
Why can't this be explained clearly in the spreadsheet?
2) Creating a long question takes time and many iterations and what seems like adequate commentary to me might not seem adequate to others. We'll add some commentary on question f)