Maintain existing ms excel based models covering analytics risk data integrity reporting cashflow waterfalls etc and present banalysisb discuss output…