Solve the problem using EXCEL and use the information from the picture attached

$3$ Problem $3$

Consider a forward contract with price $F_T$ and delivery at time $T,$ a European call option with

strike price $K$ and expiration at time $T,$ and a European put option with strike price $K$ and

expiration at time $T.$ Let $S_T$ be the price of the underlying asset at time $T,$ i$.$e$.,$ at the expiration

of the forward and options contracts.

Write the expression for the payoff function of a long forward contract at time $T$ as a function

of $S_T$

Write the expression for the payoff function of a short forward contract at time $T$ as a function

of $S_T$

Write the expression for the payoff function of a short European put option contract at time

$T$ as a function of $S_T$

Write the expression for the payoff function of a long European put option contract at time

$T$ as a function of $S_T$

Write the expression for the payoff function of a short European call option contract at time

$T$ as a function of $S_T$

Write the expression for the payoff function of a long European cal option contract at time

$T$ as a function of $S_T$

In separate graphs, draw the payoff function for each of the above contracts as a function of

$S_T.$