As we know in excel it includes alot of powerful tools to perform difficult mathematical calculations, including what-if analysis. This feature can help you to…