Year20092010201120122013201420152016Average % (-AVERAGE)SD (%) (-STDEVP)SD (%) (-STDEV.S)PSB20172018Covariance average productof deviationsCOVARCorrelation=Cov/(SDs * SDb)CORREL (=CORREL)Rates of ReturnStock Fund (%) Bond Fund (%)30.175.0832.977.5221.04-8.82-8.105.27-12.8912.20-28.53-7.7922.496.3812.5812.4014.8117.2915.500.51Cov(rs,B)OS XOBSlope (Beta)Deviation from Average ReturnsStock FundBond FundProduct ofDeviationsSquared DeviationStock FundBond FundVariance (n)Formula Calculations.Variance (n-1) Formula Calculations

In the world of finance, beta is a measure of how volatile or systematic a security or investment is…

Year 2009 2010 2011 2012 2013 2014 2015 2016 PSB 2017 2018 Average % (=AVERAGE) SD (%) (=STDEVP) SD (%) (=STDEV.S) Covariance = average product of deviations COVAR Correlation Cov/(SDs SDb) CORREL (=CORREL) Rates of Return Stock Fund (%) Bond Fund (%) 30.17 5.08 32.97 7.52 21.04 -8.82 -8.10 5.27 Cov(rs,B) OS XOB -12.89 -28.53 22.49 12.58 14.81 15.50 12.20 -7.79 6.38 12.40 17.29 0.51 Slope (Beta) Deviation from Average Returns Stock Fund Bond Fund Product of Deviations Squared Deviation Stock Fund Bond Fund Variance (n) Variance (n-1) Formula Calculations Formula Calculations

Year 2009 2010 2011 2012 2013 2014 2015 2016 PSB 2017 2018 Average % (=AVERAGE) SD (%) (=STDEVP) SD (%) (=STDEV.S) Covariance = average product of deviations COVAR Correlation Cov/(SDs SDb) CORREL (=CORREL) Rates of Return Stock Fund (%) Bond Fund (%) 30.17 5.08 32.97 7.52 21.04 -8.82 -8.10 5.27 Cov(rs,B) OS XOB -12.89 -28.53 22.49 12.58 14.81 15.50 12.20 -7.79 6.38 12.40 17.29 0.51 Slope (Beta) Deviation from Average Returns Stock Fund Bond Fund Product of Deviations Squared Deviation Stock Fund Bond Fund Variance (n) Variance (n-1) Formula Calculations Formula Calculations

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

Consider the following table: Scenario Probability Stock FundRate of Return Bond FundRate of Return Severe recession 0.10 −43% −12% Mild recession 0.20 −17.0% 12% Normal growth 0.30 17% 6% Boom 0.40 31% 4% Required: a. Calculate the values of mean return and variance for the stock fund. (Do not round intermediate calculations. Round "Mean return" value to 1 decimal place and "Variance" to 4 decimal places.) b. Calculate the value of the covariance between the stock and bond funds
Please do fast ASAP
Pls help ASAP
Subject:- finance
Lloyd Inc. has sales of $150,000, a net income of $16,500, and the following balance sheet: Cash $17,820 Accounts payable $32,400 Receivables 46,170 Notes payable to bank 9,180 Inventories 153,900 Total current liabilities $41,580 Total current assets $217,890 Long-term debt 38,070 Net fixed assets 52,110 Common equity 190,350 Total assets $270,000 Total liabilities and equity $270,000 The new owner thinks that inventories are excessive and can be lowered to the point where the current ratio is equal to the industry average, 1.75x, without affecting sales or net income. If inventories are sold and not replaced (thus reducing the current ratio to 1.75x); if the funds generated are used to reduce common equity (stock can be repurchased at book value); and if no other changes occur, by how much will the ROE change? Do not round intermediate calculations. Round your answer to two decimal places. % What will be the firm's new quick ratio? Do not round…
None
man.2
3
Consider the following partial attribution showing KAM fund 3Q 2011 performance relative to its benchmark: Portfolio Benchmark Weight Return Weight Return TOTAL 100.00 -18.27 100.00 -18.46 CONSUMER DISCRETIONARY 11.73 -17.01 12.10 -19.76 CONSUMER STAPLES 2.69 -29.02 6.35 -7.35 ENERGY 7.87 -26.87 6.27 -28.51 FINANCIAL SERVICES 18.09 -30.41 31.89 -20.86 HEALTH CARE 5.14 -16.60 6.49 -18.12 MATERIALS & PROCESSING 6.55 -21.85 5.18 -27.25 PRODUCER DURABLES 15.81 -12.90 10.83 -25.66 TECHNOLOGY 11.01 -25.34 6.02 -15.51 UTILITIES 16.49 -3.53 14.87 -3.88 Cash 5.17 0.00 0.23 0.00 i. From the 3Q 2011 partial attribution, state whether the following sectors have positive or negative asset allocation and why - Financial Services, Producer Durables and Technology?
Fund A Fund B Expected Ret. E(r) 13.2% 8.3% Standard Deviation - \sigma 15.5% 14.7% The table above contains expected annual returns for funds A and B. Assuming that the risk free rate is 1.34% and that the correlation of returns between funds A and B is 0.32, calculate the weight of Fund A in the Optimal two - risky asset portfolio comprised of funds A and B. Note: Enter your answer in percentages rounded to the nearest one digit after the decimal point. For example, if the weight of Fund A is 15.437% or 0.15437, enter it as: 15.4
What is the current price per share of the LPEVX mutual fund? 1 2 3 4 5 6 Family/ Fund Symbol NAV Chg YTD % return 3-yr % chg AARP Funds Aggr AAGSX 10.25 0.08 6.2 −1.6 Consrv AACNX 10.55 0.02 4.0 4.0 Mod p AAMDX 10.50 0.05 4.9 1.3 AMF Funds IntMtg ASCPX 4.81 −0.01 0.1 −14.3 LgCpEq IICAX 8.16 0.08 7.5 −2.1 ShtUSGv ASITX 9.36 −0.01 0.2 0.7 UltraShrt p AULTX 5.45 −0.02 3.2 −12.2 UltShrtMtg ASARX 7.39 — 2.4 −4.4 USGvMtg ASMTX 8.64 −0.02 0.2 −0.7 APIEffFrtGrPrim fp APIEffFrtGrPrim fp APITX 8.13 0.10 9.0 −6.5 APIMultIdxPrim APIMultIdxPrim AFMMX 10.98 0.09 4.4 −9.6 AVS LPE Ptf AVS LPE Ptf LPEVX 5.82 −0.01 11.3 NS Aberdeen Fds…
A stock Fund produced the following annualized results: Return = 17.5% Std Dev= 22% Beta = 1.05 Tracking Error vs. S&P 500: 3.2% (annualized) Over the same period, T-Bills returned 5%; the S&P returned 15% and had a std Dev = 25 The Fund's Information Ratio adjusted for beta is: O 0.781 O 0.625 O 0.568 O 0.60 O 1.055

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Foundations Of Finance

Finance

ISBN:

9780134897264

Author:

KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:

Pearson,

Fundamentals of Financial Management (MindTap Cou…

Finance

ISBN:

9781337395250

Author:

Eugene F. Brigham, Joel F. Houston

Publisher:

Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i…

Finance

ISBN:

9780077861759

Author:

Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS