Homework Answers
Please rate thumbs up
Add Answer to:
in
an excel format, can you please solve for the following! thanks
Given the Data Below...
in an excel format, can you please solve the following! thanks! Calculate the weighted Average Cost...
in
an excel format, can you please solve the following!
thanks!
Calculate the weighted Average Cost of Capital Given Rate Below (60 points) Show Work Cost of Capital Weighted Average Bonds Preferred Stock Internal Equity Common Stock % of Equity 25.00% 10.00% 10.00% 55.00% Remember Flotation Costs and Taxes Par Value Market Price Flotation Costs Coupon Rate Maturity $1.001.00 $1.100.00 S100.00 X% 10 years Tax Rate 30.01% Preferred Stock Remember Flotation Costs Dividend Selling Price Flotation Costs $6.00 S85 0...
CAN YOU PLEASE INCLUDE THE FORMULAS USED TO FIND THESE NUMBERS Contact (call, Put, of Futures)...
CAN YOU PLEASE INCLUDE THE FORMULAS
USED TO FIND THESE NUMBERS
Contact (call, Put, of Futures) Strike of Futures Price Premium Paid (Options Only) Futures $25.00 $3.00 $20.00 Spot Price at Expiration Futures Buyer Futures seller Payoff Payoff $15.00 $10.00 $5.00 $0.00 $10,00 $20.00 $17.50 $15.00 $12.50 Buyer payoff Seller payoff $35.00 $32.50 $0.00 $27.56 $25.00 $40.00 ss o $22.50 $37.50 Intristic Value (Options only) N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A...
answer using excel pease You work for a large investment management firm. The analysts with your...
answer using excel pease
You work for a large investment management firm. The analysts with your firm have made the following forecasts for the returns of stock A and stock B: VERY VERY WEAK VERY WEAK WEAK AVERAGE STRONG VERY VERY STRONG Probability 10.00% 15.00% 20.00% 25.00% 20.00% 10.00% 100.0% Stock A 60.00% 40.00% 20.00% 10.00% -15.00% -50.00% Stock B -60.00% -50.00% -15.00% 30.00% 60.00% 90.00% Answer the following questions: a) Calculate the expected returns, variance and the standard deviations...
Please do problem using excel 14 Based on the following data; 15 State of the Economy...
Please do problem using excel
14 Based on the following data; 15 State of the Economy Rate of Return 16 Probablility Stock A Rate of Return Stock 6 % 17 Recession 0.2 20% 12%% Normal Growth 0.65 20% 18 50% 0.15 16% 19 Boom 20 calculate the expected return and the standard deviation of returns for each stock. 21 22 b) calculate the expected return and the standard deviation on the portfolio, where the portfolio is formed by investing 50%...
Please answer(calculations) the above questions through formulas and explain if possible. Please refrain from using Excel...
Please answer(calculations) the above questions
through formulas and explain if possible. Please refrain from using
Excel functions . Thanks.
In (c) there is no need to calculate the jensen alpha.
sorry. only the sharpe ratio is needed.
University = Portfolio | Basis Bond Exercise: Finance. There are a risky assets: Assets Expected Return / X 0.75 Y I 0.7 Risk 0.2 0.4 -0.35 is the correlation between the asset returns. ca) Calculate the expected return and standard deviation of the...
Please use excel. I can learn from that!!! Portfolio analysis - You have been given the...
Please use excel. I can learn from that!!! Portfolio analysis - You have been given the expected return data shown in the first table on three assets - F, G and H, over the period 2016 - 2019. Expected Return Year Asset F Asset G Asset H 2016 11% 12% 9% 2017 12% 11% 10% 2018 13% 10% 11% 2019 14% 9% 12% Using these assets, you have isolated the three investment alternatives shown in the following table: Alternative Investment...
please do the entire thing A B and C, im stuck, thanks! 1. You are given...
please do the entire thing A B and C, im stuck, thanks!
1. You are given the following information: Stock Expected return (in %) o (in %) А 10 10 B The covariance between these returns is 16%. The risk-free rate is 6%. (a) Find the expected return and standard deviation of the following portfolios: i. 50% in A, 50% in B ii. 50% in A, 50% in the risk-free asset iii. 150% in A, financed by borrowing at the...
Please solve it by hand or typing, don't use EXCEL . 1. The following data was...
Please solve it by hand or typing, don't use EXCEL
.
1. The following data was downloaded from Professor Kenneth French's website. The table shows the annual return of the U.S. stock market including NYSE, NASDAQ and Amex over the 10 years. (15pts) Year 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 Return (%) -16.97-15.12-22.47 32.12 11.82 4.34 11.4 263-39 96 3158 1) What would be your expected return of the stock market in 2010 based on the...
Please solve it by hand or typing, don't use EXCEL. 1. The following data was downloaded...
Please solve it by hand or typing, don't use EXCEL.
1. The following data was downloaded from Professor Kenneth French's website. The table shows the annual return of the U.S. stock market including NYSE, NASDAQ and Amex over the 10 years. (15pts) Year 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 Return (%) -16.97-15.12-22.47 32.12 11.82 4.34 11.4 263-39 96 3158 1) What would be your expected return of the stock market in 2010 based on the table?...
Please solve it by hand or typing, don't use EXCEL. 1. The following data was downloaded...
Please solve it by hand or typing, don't use EXCEL.
1. The following data was downloaded from Professor Kenneth French's website. The table shows the annual return of the U.S. stock market including NYSE, NASDAQ and Amex over the 10 years. (15pts) Year 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 Return (%) -16.97-15.12-22.47 32.12 11.82 4.34 11.4 263-39 96 3158 1) What would be your expected return of the stock market in 2010 based on the table?...
in
an excel format, can you please solve the following!
thanks!
Calculate the weighted Average Cost of Capital Given Rate Below (60 points) Show Work Cost of Capital Weighted Average Bonds Preferred Stock Internal Equity Common Stock % of Equity 25.00% 10.00% 10.00% 55.00% Remember Flotation Costs and Taxes Par Value Market Price Flotation Costs Coupon Rate Maturity $1.001.00 $1.100.00 S100.00 X% 10 years Tax Rate 30.01% Preferred Stock Remember Flotation Costs Dividend Selling Price Flotation Costs $6.00 S85 0...
CAN YOU PLEASE INCLUDE THE FORMULAS
USED TO FIND THESE NUMBERS
Contact (call, Put, of Futures) Strike of Futures Price Premium Paid (Options Only) Futures $25.00 $3.00 $20.00 Spot Price at Expiration Futures Buyer Futures seller Payoff Payoff $15.00 $10.00 $5.00 $0.00 $10,00 $20.00 $17.50 $15.00 $12.50 Buyer payoff Seller payoff $35.00 $32.50 $0.00 $27.56 $25.00 $40.00 ss o $22.50 $37.50 Intristic Value (Options only) N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A...
answer using excel pease
You work for a large investment management firm. The analysts with your firm have made the following forecasts for the returns of stock A and stock B: VERY VERY WEAK VERY WEAK WEAK AVERAGE STRONG VERY VERY STRONG Probability 10.00% 15.00% 20.00% 25.00% 20.00% 10.00% 100.0% Stock A 60.00% 40.00% 20.00% 10.00% -15.00% -50.00% Stock B -60.00% -50.00% -15.00% 30.00% 60.00% 90.00% Answer the following questions: a) Calculate the expected returns, variance and the standard deviations...
Please do problem using excel
14 Based on the following data; 15 State of the Economy Rate of Return 16 Probablility Stock A Rate of Return Stock 6 % 17 Recession 0.2 20% 12%% Normal Growth 0.65 20% 18 50% 0.15 16% 19 Boom 20 calculate the expected return and the standard deviation of returns for each stock. 21 22 b) calculate the expected return and the standard deviation on the portfolio, where the portfolio is formed by investing 50%...
Please answer(calculations) the above questions
through formulas and explain if possible. Please refrain from using
Excel functions . Thanks.
In (c) there is no need to calculate the jensen alpha.
sorry. only the sharpe ratio is needed.
University = Portfolio | Basis Bond Exercise: Finance. There are a risky assets: Assets Expected Return / X 0.75 Y I 0.7 Risk 0.2 0.4 -0.35 is the correlation between the asset returns. ca) Calculate the expected return and standard deviation of the...
please do the entire thing A B and C, im stuck, thanks!
1. You are given the following information: Stock Expected return (in %) o (in %) А 10 10 B The covariance between these returns is 16%. The risk-free rate is 6%. (a) Find the expected return and standard deviation of the following portfolios: i. 50% in A, 50% in B ii. 50% in A, 50% in the risk-free asset iii. 150% in A, financed by borrowing at the...
Please solve it by hand or typing, don't use EXCEL
.
1. The following data was downloaded from Professor Kenneth French's website. The table shows the annual return of the U.S. stock market including NYSE, NASDAQ and Amex over the 10 years. (15pts) Year 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 Return (%) -16.97-15.12-22.47 32.12 11.82 4.34 11.4 263-39 96 3158 1) What would be your expected return of the stock market in 2010 based on the...
Please solve it by hand or typing, don't use EXCEL.
1. The following data was downloaded from Professor Kenneth French's website. The table shows the annual return of the U.S. stock market including NYSE, NASDAQ and Amex over the 10 years. (15pts) Year 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 Return (%) -16.97-15.12-22.47 32.12 11.82 4.34 11.4 263-39 96 3158 1) What would be your expected return of the stock market in 2010 based on the table?...
Please solve it by hand or typing, don't use EXCEL.
1. The following data was downloaded from Professor Kenneth French's website. The table shows the annual return of the U.S. stock market including NYSE, NASDAQ and Amex over the 10 years. (15pts) Year 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 Return (%) -16.97-15.12-22.47 32.12 11.82 4.34 11.4 263-39 96 3158 1) What would be your expected return of the stock market in 2010 based on the table?...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago