Excel case study | Accounting homework help

I have uploaded an excel file that is the assignment you are to work on.

Also I have uploaded a word document that contains videos and hints about how to solve the excel file, I included a few pictures of the excel financial functions that you are expected to use while solving the excel file.