9. Evaluate the stock price of Goldman Sachs using two techniques. DDM . Relative Valuation Create a nice formatted table in Excel that shows all the steps/work. Copy and paste the table into your professional Word Document 1. To calculate g use two methods. 1. Use ROE X (1-payout ratio). 2. Go to yahoo finance enter GS. Click on the "Analysts" link. Use next 5 years growth estimate. To find the data go to yahoo finance. Enter GS for the ticker. Click on statistics. Choose the go you think is the most appropriate to use. To calculate r use the CAPM, 10 year Treasury yield + beta" (7.6%). Use the forwarded annual dividend rate. 2. To use the relative valuation approach use google finance. Use the P/E. P/BV, and P/S ratios of the related companies. 3. Determine if GS over or under valued using both techniques. 10. Use put-call ratio Determine if GS's put/call parity holds. Go to yahoo finance. Enter GS in ticker search box. Click on options. Find the date that is closes to one year from today. Find the call and put premium for a strike price that is close to GS's current price, . Find the yield on a one year Treasury bill. Determine if the put/call parity holds using the equation ity A 1) MacBook Pro e G Search or type URL 9. Evaluate the stock price of Goldman Sachs using two techniques. DDM . Relative Valuation Create a nice formatted table in Excel that shows all the steps/work. Copy and paste the table into your professional Word Document 1. To calculate g use two methods. 1. Use ROE X (1-payout ratio). 2. Go to yahoo finance enter GS. Click on the "Analysts" link. Use next 5 years growth estimate. To find the data go to yahoo finance. Enter GS for the ticker. Click on statistics. Choose the go you think is the most appropriate to use. To calculate r use the CAPM, 10 year Treasury yield + beta" (7.6%). Use the forwarded annual dividend rate. 2. To use the relative valuation approach use google finance. Use the P/E. P/BV, and P/S ratios of the related companies. 3. Determine if GS over or under valued using both techniques. 10. Use put-call ratio Determine if GS's put/call parity holds. Go to yahoo finance. Enter GS in ticker search box. Click on options. Find the date that is closes to one year from today. Find the call and put premium for a strike price that is close to GS's current price, . Find the yield on a one year Treasury bill. Determine if the put/call parity holds using the equation ity A 1) MacBook Pro e G Search or type URL