plz solve in excel sheet and show me all excel finctions formulla wthin 2 hours

16. The Put-Call Parity equation claims that one Put Option is equivalent to a replicating portfolio consisting of one Call Option, short one Stock, and a Bond paying a face value equal to the exercise price of the put and call options. Determine if the payoff at maturity of the replicating portfolio is equivalent to the payoff at maturity of a put option