Below are the pictures needed to do Assignment. In all fairness, the assignment should cover the three important areas discussed: bond duration, stock valuation, and derivatives.

Please fill in the cells indicated in red, bold font.

Yields on the Horizontal and Prices on the Vertical Axis. onal to the Slope of the Diagram in 2. Plot Duration against Yields on the Horizontal, underneaththe first diINPUTS Scenario: Status Quo WACC = 11 509% Projections Year 2015 2020 2021 2027 ZOZE 2024 FCF $30.00 $92.40 $131.87 $209.74 $220.23 7 + FCP2020 FCF2021 FCP2022 FCP2023 FOR2024 L. HV = Vop (2024) (1+WACO)1 (1+WACC)2 (1+WACC]3|(1+WACC)+ (1+WACC]S FOF2024(1+gl] (WACC- BL) .L $231 $74 0.065 PVS of FORS $136 $3 SSE PV of HV $2.064 53 SSE Vop = $2 524 (1+WACC)S Note: Numbers are reported as rounded values for clarity, but are calculated using Excel's full precision. Thus, Intermediate calculations using the figure's rounded values will be Inexact.1) Assume the Free Cash Flows as Given 2) Change the Necessary Values to Formulas so that the Sheet Calculates 3) Find the Growth Rate that Makes Vop equal to $3,000.00 hint: Under Data, select What If Analysis, Goal Seek Set Cell B24 to Value $3,000 by Changing 85. The Sheet must automatically calculate for Goak Seek to work.Strike price: X = 537.00 Current stock price: P = $40.00 Up factor for stock price: u = 1.25 Down factor for stock price: d = 0.80 Up option payoff: Cu = MAX[0,F(0)-X] = 1) Fill-In with a Formula Down option payoff. Cd =MAX[0,F(d)-X] = 2) Fill-In with a Formula Number of shares of stock In portfolio: Ns = (Cu - cd) / F(u-d) = 3) Fill-In with a Formula Stock price = F(ME $50.00 Fortfolio's stock payoff: = P(u] (Ns] = 4) Fill-In with a Formula current subtract option's payoff: Cu = 5) Fill-In with a Formula stock price Portfolio's net payoff = P(u]Ns - Cu = 6) Fill-In with a Formula $40 Stock price = P (d)= $32.00 Portfolio's stock payoff: = F(d) (Ns] = 7) Fill-In with a Formula Subtract option's payoff: cd = 8) Fill-In with a Formula Portfolio's net payoff = P[d]Ns - cd = 9) Fill-In with a Formula Frequency compounded in year: Nominal risk-free rate, rR.F: Years to end of binomial period: Jupots to PV function: N= 1625 =([Frequency) DYR = 0.021920% = Rrf/ Frequency PMT = Alternatively, you can use the present value equation and adjust for the frequency of compounding: VC = NS (F) . Present value of riskless payoff Vc = 10) Find the Value of the CallN 10 5% Yields Prices Duration PV 3% 8.27 1. Fill the cells highlighted. PMT 50.00 49% 3.19 2. Insert a Scatter Diagram with 5 1,000.00 5% 8.11 3. Duration is Roughly Proportio 69% 8.02 9/16/2021 7% 7.93 9/15/2031 89% 7.84 9% 7.75 10% 7.66 11% 7.56 12% 7.47