AIG interview question

Excel Model Case Study on large credit loan