Who can help me to answer this question?
Estimating the inputs using the Black-Scholes option pricing model in the option analysis of the investment timing option Option analysis involves gathering significant amounts of information, synthesizing the data, and using the data in models applied option analysis. Consider the case of RTE Com Inc.: RTE Com Inc. is considering a project for a new cloud-based online storage system for companies and individuals to back up their data. The cost of the project is $55 million, but the future cash flows depend on how this new cloud-based online storage will compete with existing companies that offer online data backup. The company believes that this project has a strong selling feature but is uncertain that it would earn cash flows as projected. The team proposing this project has come up with the following data: Demand Probability Annual Cash Flow High 0.40 $50 million Average 0.40 $35 million Low 0.20 $15 million Project's cost of capital 13% Life of project Three years 52-week Treasury note 5% The project team also noted that the company has an option to wait for one year in order to see its competitors' positions and observe how the market responds. This will help in getting more information about market demand and in figuring out which set of cash flows will occur. Analysts used different approaches to evaluate the project, but the management team insists that the Black-Scholes option pricing model (OPM) will help them make a more informed decision. The model requires five inputs: (1) the risk-free rate; (2) the time until the option expires; (3) the strike price; (4) the current price of the stock, which in this case would be a proxy for the value of the underlying asset; and (5) the variance of the project's expected return. You need to calculate both the value of the underlying asset in the project and its rate of return. For RTE Com Inc., the underlying asset is the project itself. The current value of the project will be the value of its expected cash flows. Present Future Based on the data given, calculate the value of the project, its return, and the standard deviation of the returns (using the direct method) if the company decides to wait for a year. (Cash flow values in the table are in millions. Round your answers to two decimal places). Now: Yr. Yr. Yr. Yr. PV Cash flows PV Cash flows Return = (PV Cash Flows, - Price Yearo ) / Price Yearo Probability (P;) x Probability (P j) x PV Cash flows, Yr. O Pj 1 2 3 4 (t=1) (t=0) Return 7 $ 47.224 $ 6.268 $ 41.792 High 0.40 $50 $50 $50 $118.06 $104.48 1 4 7 2 0.40 Average $35 $35 $35 $82.64 $73.13 5 8. 8 $ 29.252 $33.056 $ 41.792 3 Low 0.20 $15 $15 $15 $35.42 $31.34 6 9 Expected return 1 50.00 % 52.72 % 6.89 % -54.18% 21.0840% -10.8360% 2.7560% 39.3600% (t=1): 9 2.7560% 21.0840% 39.3600% -10.8360% 6. $ 6.268 $ 41.792 $ 7.084 4 38.84 % 45.25 % 13.00 % 41.92 % 47.23 % 35.42 % 39.36 % 37.39 % Standard deviation of 2 6.89 % 15.00 % -54.18 % 52.72 % returns: 2.7560% 21.0840% 39.3600% -10.8360% 5 Expected Value of $ 69.58 $ 58.04 $ 87.36 $ 65.71 PVs (t=1): 3 52.71 % 35.00 % 6.89 % -54.18 % Expected Value of $ 85.04 $ 65.71 $ 69.58 $77.31 PVs (t=0): Analysts will use these values in the Black-Scholes model, which is represented by the following formula: V = P[N(d)]- Xe-TRIN(d2)] Based on the data collected and results from the calculations, estimate the input values to be used in the Black-Scholes OPM: TRF = Risk-Free Interest Rate % 5 % 6 year 6 % 13 year 3 year 1 year 2 = 35 Million 15 Million 13 Million 55 Million t = X = = Time until Option Expires $ 85.04 = Cost to Implement the Project $ 65.71 = Current Value of the Project $ 69.58 $ 77.31 = Variance of the Project's Rate of Return P 37.39 % 15.49 % 39.36 % 13.94 % 02 = Nd1 = Cumulative Normal Distribution Function of di = N ({In ( ) + [rrf + ( )]t} / (01/2)) Nd2 = Cumulative Normal Distribution Function of d2 = N (d1 - ). IRF = Risk-Free Interest Rate Alx - P t = Time until Option Er.pires 02 X = Cost to Implement the Project = X1o = Current Value of the Project 0 = Variance of the Project's Rate of Return = P Ndi = Cumulative Normal Distribution Function of di = N ({In ( ) + [rre + C)]} / (op!'29) Nd2 = Cumulative Normal Distribution Function of d2 = N (d1 - ) IRF = Risk-Free Interest Rate (Xt12) t = Time until Option Expires X = Cost to Implement the Project (*) 8| P = Current Value of the Project = (ot1/2) 62 = Variance of the Project's Rate of Return = (Pt 12 ) Nd1 = Cumulative Normal Distribution Function of di = N ({In ( ) + [rRF + C)]t} / (01/2)) Nd2 = Cumulative Normal Distribution Function of d2 = N (d - Estimating the inputs using the Black-Scholes option pricing model in the option analysis of the investment timing option Option analysis involves gathering significant amounts of information, synthesizing the data, and using the data in models applied option analysis. Consider the case of RTE Com Inc.: RTE Com Inc. is considering a project for a new cloud-based online storage system for companies and individuals to back up their data. The cost of the project is $55 million, but the future cash flows depend on how this new cloud-based online storage will compete with existing companies that offer online data backup. The company believes that this project has a strong selling feature but is uncertain that it would earn cash flows as projected. The team proposing this project has come up with the following data: Demand Probability Annual Cash Flow High 0.40 $50 million Average 0.40 $35 million Low 0.20 $15 million Project's cost of capital 13% Life of project Three years 52-week Treasury note 5% The project team also noted that the company has an option to wait for one year in order to see its competitors' positions and observe how the market responds. This will help in getting more information about market demand and in figuring out which set of cash flows will occur. Analysts used different approaches to evaluate the project, but the management team insists that the Black-Scholes option pricing model (OPM) will help them make a more informed decision. The model requires five inputs: (1) the risk-free rate; (2) the time until the option expires; (3) the strike price; (4) the current price of the stock, which in this case would be a proxy for the value of the underlying asset; and (5) the variance of the project's expected return. You need to calculate both the value of the underlying asset in the project and its rate of return. For RTE Com Inc., the underlying asset is the project itself. The current value of the project will be the value of its expected cash flows. Present Future Based on the data given, calculate the value of the project, its return, and the standard deviation of the returns (using the direct method) if the company decides to wait for a year. (Cash flow values in the table are in millions. Round your answers to two decimal places). Now: Yr. Yr. Yr. Yr. PV Cash flows PV Cash flows Return = (PV Cash Flows, - Price Yearo ) / Price Yearo Probability (P;) x Probability (P j) x PV Cash flows, Yr. O Pj 1 2 3 4 (t=1) (t=0) Return 7 $ 47.224 $ 6.268 $ 41.792 High 0.40 $50 $50 $50 $118.06 $104.48 1 4 7 2 0.40 Average $35 $35 $35 $82.64 $73.13 5 8. 8 $ 29.252 $33.056 $ 41.792 3 Low 0.20 $15 $15 $15 $35.42 $31.34 6 9 Expected return 1 50.00 % 52.72 % 6.89 % -54.18% 21.0840% -10.8360% 2.7560% 39.3600% (t=1): 9 2.7560% 21.0840% 39.3600% -10.8360% 6. $ 6.268 $ 41.792 $ 7.084 4 38.84 % 45.25 % 13.00 % 41.92 % 47.23 % 35.42 % 39.36 % 37.39 % Standard deviation of 2 6.89 % 15.00 % -54.18 % 52.72 % returns: 2.7560% 21.0840% 39.3600% -10.8360% 5 Expected Value of $ 69.58 $ 58.04 $ 87.36 $ 65.71 PVs (t=1): 3 52.71 % 35.00 % 6.89 % -54.18 % Expected Value of $ 85.04 $ 65.71 $ 69.58 $77.31 PVs (t=0): Analysts will use these values in the Black-Scholes model, which is represented by the following formula: V = P[N(d)]- Xe-TRIN(d2)] Based on the data collected and results from the calculations, estimate the input values to be used in the Black-Scholes OPM: TRF = Risk-Free Interest Rate % 5 % 6 year 6 % 13 year 3 year 1 year 2 = 35 Million 15 Million 13 Million 55 Million t = X = = Time until Option Expires $ 85.04 = Cost to Implement the Project $ 65.71 = Current Value of the Project $ 69.58 $ 77.31 = Variance of the Project's Rate of Return P 37.39 % 15.49 % 39.36 % 13.94 % 02 = Nd1 = Cumulative Normal Distribution Function of di = N ({In ( ) + [rrf + ( )]t} / (01/2)) Nd2 = Cumulative Normal Distribution Function of d2 = N (d1 - ). IRF = Risk-Free Interest Rate Alx - P t = Time until Option Er.pires 02 X = Cost to Implement the Project = X1o = Current Value of the Project 0 = Variance of the Project's Rate of Return = P Ndi = Cumulative Normal Distribution Function of di = N ({In ( ) + [rre + C)]} / (op!'29) Nd2 = Cumulative Normal Distribution Function of d2 = N (d1 - ) IRF = Risk-Free Interest Rate (Xt12) t = Time until Option Expires X = Cost to Implement the Project (*) 8| P = Current Value of the Project = (ot1/2) 62 = Variance of the Project's Rate of Return = (Pt 12 ) Nd1 = Cumulative Normal Distribution Function of di = N ({In ( ) + [rRF + C)]t} / (01/2)) Nd2 = Cumulative Normal Distribution Function of d2 = N (d
