finance technical assignment

I have already done part 1 and part 2 of the project in the excel spreadhseet attached. Now, I need only part 3 and part 5 for which instructions are provided below.