In cell c8 create a formula using the fv function – In the realm of financial calculations, the FV function stands tall, empowering users to peer into the future and…