Colonel Motors (C) Separated Edison (S) Expected Return 10% 8% Standard Deviation 6% 3% Please represent graphically all potential combinations of stocks C and S, if the correlation coefficient between the returns of stocks C and S is: A) 1 B) 0 C) -1 Please report these investment opportunity sets in the corresponding Excel sheets.
Q: Dpn't provide handwritten solution ... The Taylors have purchased a $300,000 house. They made an…
A: Variables in the question:Purchase price of house= $300,000Initial down payment=$10,000Rate=7% per…
Q: Rubble, Inc. produced 1,140 backpacks, the company's product in 2020. The standard cost was 4 yards…
A: Direct materials cost variance is the difference between the standard cost of materials used for…
Q: For a 30-year house mortgage of $75,000 at 4.6% interest, find the following. (Round your final…
A: Loan amortization refers to the repayment of the loan amount. In the process of amortization…
Q: A contract requires lease payments of $700 at the beginning of every month for 4 years. a. what is…
A: Present value is the equivalent value today of the future payments based on the time and interest…
Q: Suppose most investors expect the inflation rate to be 5% next year, 6% the following year, and 7%…
A: Interest rate = real risk free rate + average inflation + MRP (maturity risk premium)
Q: ork for a few years, and then start your grad school when you turn 26. To save up ough for your grad…
A: In financial planning the future value of deposits must be equal to present value of deposits so…
Q: Explain the difference between public and private companies.
A: A business can be run in the form of several different legal entities that are allowed by law. So a…
Q: A professor has two daughters that he hopes will one day go to college. Currently, in-state students…
A: Financial planning is required for the payments required in the future and proper planning for…
Q: Ocean power technologies $300 million common equity 12.2 million shares of common stock outstanding…
A: Market Value Added (MVA) means the difference between the market value of a firm and its common…
Q: Investment B: -$1 million The timeline of an investment is A. 0.184 OB. 0.167 OC. 0.67 OD. 0.418
A: Profitability index is the most used capital budgeting method based on the time value of money and…
Q: What is the expected return for the following portfolio? (State your answer in percent with two…
A: Expected return of portfolio comprising of multiple different securities is computed as…
Q: 4000 3500 3000 2500 2000 1500 1000 500 0 ARITHMETICI $0.00 1 • Solve for the Present Value. • N =…
A: The PV of an investment refers to the combined value of the cash flows assuming that they are…
Q: On July 6, 2018 a sum of $36,700.00 was deposited into an account. What would be the future value of…
A: Given information,Present value:Number of days: Rate: Compounding frequency: Annual To…
Q: 6. Assume the annual effective interest rate is i = 2%. An individual wants to invest a capital of…
A: Present value is an estimate of the present value of future cash values that may be received at a…
Q: Why is it important for a firm to know how to determine their cost of capital?
A: Cost of capital is the cost that a business incurs for financing its business, operations and…
Q: Exercise_04 1) You are owed payments of $400 due today, $500 due in five months, and $618 due in one…
A: Present value is an estimate of the present value of future cash values that may be received at a…
Q: London purchased a piece of real estate last year for $81,800. The real estate is now worth…
A: Beginning value = $81,800Ending value = $104,600Total required return = 0.22 The formula for…
Q: DVANTAGES AND DISADVANTAGES OF NPV?
A: NPV is the most used method of capital budgeting and is based on the time value of money and can be…
Q: Foreign Exchange Risk and the Cost of Borrowing Swiss Francs. The chapter demonstrated that a firm…
A: Variables in the question:Value of debt principal=SF1.3 millionTime=1 yearInitial spot rate:…
Q: You deposit $87000 into an account which pays 4% compounded quarterly. You leave the money in the…
A: Compound = Quarterly = 4Present Value = pv = $87,000Interest Rate = r = 4 / 4 = 1%Time = t = 10 * 4…
Q: A 5-year Treasury bond has a 4.9% yield. A 10-year Treasury bond yields 6.1%, and a 10-year…
A: Corporate bonds are issued by private companies and hence are quite risky and hence the required…
Q: Find the amount in the account after 5 years 6 months.
A: We can determine the amount after 5.5 years using the FV of annuity formula below:In the formula PMT…
Q: Bandon Manufacturing intends to issue callable, perpetual bonds with annual coupon payments and a…
A: The coupon rate refers to the rate at which the bond issuer will pay interest on the bond at equal…
Q: A pension fund manager is considering three mutual funds. The first is a stock fund, the second is a…
A: The minimum variance portfolio is the portfolio consisting of risky assets where the investor…
Q: Jack Fraizer has the opportunity to invest in a project. The cost of the project is R8 million, with…
A: Pay-Back(PB) Period shows time period required to fully recover initial outlay through successive…
Q: What is locals net profit margin?
A: Net profit margin =
Q: Your older sister deposited $15,000 today at 17.5 percent interest for 20 years. You would like to…
A: Future Value = Present Value * (1 + Interest Rate)^time
Q: Derek borrows $40,041.00 to buy a car. He will make monthly payments for 6 years. The car loan has…
A: Time value of money (TVM) means that the amount of money received in the present period will have…
Q: m has just issued five-year floating-rate notes indexed to six-month U.S. dollar LIBOR plus 1/4…
A: LIBOR is a benchmark rate. The rate at which the global banks lend to one another.
Q: Derek currently has $14,618.00 in an account that pays 6.00%. He will withdraw $5,134.00 every other…
A: Savings Accounts is a deposit facility offered by commercial banks. It allows accountholders to…
Q: Yesterday Sandi sold 1,000 shares of stock that she owned for $45 per share. When she purchased the…
A: Here,Number of Shares is 1,000Current Price of Share is $45Purchase Price of Share is $50Dividend…
Q: Assessing credit risk using cash flow forecasts (LO 7-7) Randall Manufacturing has requested a $2…
A: Variables in the question:Four year term loan=$2,000,000Cost to replace wornout manufacturing…
Q: An analyst at a company notes that its cost of debt is far below that of equity. He concludes that…
A: The balance between equity and debt in a company's capital structure is a fundamental aspect of…
Q: Marc has purchased a new car for $15,000. He paid $2,500 as down payment and he paid the balance by…
A: Here,Purchase Price of Car is $15,000Down Payment is $2,000Therefore, Loan Amount (PV) is:Interest…
Q: you buy a store worth $250,000 with 20 percent down. The balance is to be paid off with equal annual…
A: Purchase Price of Store = $250,000Down Payment rate = 20%Time = t = 30 YearsInterest Rate = r = 9%
Q: Cornell Enterprises is considering a project that has the following cash flow and WACC data. What is…
A: Npv is also known as Net Present value . It is a capital budgeting technique which helps in decision…
Q: You purchased 100 stocks 3 months ago at $50 per share. Today you received a dividend payment of…
A: Holding period return is the amount of gain or loss during the period in which stock is held for the…
Q: Given the information below for Seger Corporation, compute the expected share price at the end of…
A: Years201620172018201920202021Price88.6094.5093.2090.70112.20127.60EPS2.553.264.064.767.208.20CFPS7.4…
Q: Your firm needs a machine which costs $280,000, and requires $43,000 in maintenance for each year of…
A: After Tax salvage value is that amount which is received by the investor from selling the assets…
Q: Ralph wants to quit his job and move to Hawaii on December 25, 2015. Once there, he anticipates that…
A: 1.Present value of annuity .PV = A * wherePV = Present value of annuity .A = Periodic withdrwalsr =…
Q: You decide to save $6800 by making semiannual deposits for 5 years into an account which pays 3%…
A: Compound = Semiannually = 2Future Value after 10 years = fv $6800Number of Deposit = n = 5 * 2 =…
Q: What is the cost of capital?
A: In finance we often hear the word “cost of capital”. This is very important term and we finds its…
Q: Assume you have a balance of $1000 on a credit card with an APR of 24%, or 2% per month. You start…
A: By using credit cards, people usually spend more money and people who actually pay their credit…
Q: Thorpe Mfg., Inc., is currently operating at only 81 percent of fixed asset capacity. Current sales…
A: Current operating capacity=81%Current sales=$740,000Fixed Assets=$600,000Projected…
Q: A sum of $10,000 now (time 0) is equivalent to the following cash flow diagram. What is the value of…
A: The PV of an investment refers to the combined value of the cash flows discounted to the present at…
Q: Lauren wants to buy a car that costs $27,000. She has $22,000 in her bank account currently. If the…
A: Simple interest on a loan is a type of interest that is calculated based only on the principal…
Q: Company Z has developed an air pollution control system that can reduce emissions from its…
A: Annual cost savings denote the expenditure value that the company has cut short per year by…
Q: Sterling Optical and Royal Optical both make glass frames and each is able to generate earnings…
A: 1.EPS means Earnings per shareEPS = 2. P/E ratio means price earnings ratio.P/E ratio = whereMPS =…
Q: Dear Financial Adviser, My spouse and I are each 62 and hope to retire in three years. After…
A:
Q: A callable bond has a yield to call (YTC) of 5%, and a non-callable bond has a yield to maturity…
A: When a company provides a debt security bond with an additional feature that allows it to redeem it…
Step by step
Solved in 3 steps with 15 images
- Consider information given in the table below and answers the question asked thereafter: State Probability return on stock A Return on stock B A 0.15 10% 9% B 0.15 6% 15% C 0.10 20% 10% D 0.18 5% -8% E 0.12 -10% 20% F 0.30 8% 5% Calculate covariance and coefficient of correlation between the returns of thestocks A and B.v. Now suppose you have $100,000 to invest and you want to a hold a portfoliocomprising of $45,000 invested in stock A and remaining amount in stock B.Calculate risk and return of your portfolio.The following questions are based on the given information from table of probabilitydistributions of returns on investment individual shares and portfolio below:Table 3: Probability distributions of returns on investment for individual shares and portfolio. State ofEconomy Probabilityof theStates Return onShare A(rA) Return onShare B(rB) Return on Portfolio AB(rAB)1 0.20 15% -5% 5%2 0.20 -5% 15% 5%3 0.20 5% 25% 15%4 0.20 35% 5% 20%5 0.20 25% 35% 30% Given: By using the above information, demonstrate the rate of risk (variance and standarddeviation) for each of:(i) Share A (ii) Share B (iii) Portfolio A and BPLEASE ANSWER ALL THE QUESTIONS Question 1 Fill the parts in the above table that are shaded in yellow. You will notice that there are nine line items. Question 2 Using the data generated in the previous question (Question 1);a) Plot the Security Market Line (SML) b) Superimpose the CAPM’s required return on the SML c) Indicate which investments will plot on, above and below the SML? d) If an investment’s expected return (mean return) does not plot on the SML, what does it show? Identify undervalued/overvalued investments from the graph Question 3 From the information generated in the previous two questions; a) Identify two investment alternatives that can be combined in a portfolio. Assume a 50-50 investment allocation in each investment alternative. b) Compute the expected return of the portfolio thus formed. c) Compute the portfolio’s beta. Is the portfolio aggressive or defensive?
- A 1 Data for Two Stocks 2 3 B C D E F G H J K 2. Use the Excel file Data for Two Stocks to determine the following: a. Using EXCEL's Data Table Feature, create a one-way data table that determines the different means and standard deviations for portfolios consisting of combinations of Stock A and Stock B by varying the correlation coefficient value between Stock A and Stock B through the full range of possible correlation coefficient values. Use increments of 0.10 for the possible correlation coefficient values. b. Graph the correlation coefficients, the means, and the standard deviations of the portfolios from the one-way data table. Be sure to include a title for the graph and label the axes. c. Use Excel's Text Box Feature to explain how the portfolio means are affected by changing the correlation coefficient values. d. Use Excel's Text Box Feature to explain how the portfolio standard deviations are affected by changing the correlation coefficient values. 4 5 Expected return A B…Given the returns and probabilities for the three possible states listed below, calculate the covariance between the returns of Stock A and Stock B. For convenience, assume that the expected returns of Stock A and Stock B are 8.10 percent and 11.60 percent, respectively. (Round answer to 4 decimal places, e.g. 0.0768.) Good OK Poor Covariance Probability 0.22 0.60 0.18 Return on Stock A 0.30 0.10 -0.25 Return on Stock B 0.50 0.10 -0.30financial advisor evaluates four stocks for inclusion in an investor's portfolio. A orrelation matrix showing each stock's correlation with the other stocks is shown below Stock ALK CMN BTY DLE ALK 0.40 0.58 1.00 -0.25 BTY 0.40 1.00 0.16 -0.04 CMN -.25 .16 1.00 .37 DLE .58 .04 .37 1.00 f the goal is to reduce the investor's overall portfolio risk, which two stocks should the advisor recommend? a. ALK and DLE b. ALK and CMN c. BTY and DLE BTY and CM
- Astromet is financed entirely by common stock and has a beta of 1.20. The firm pays no taxes. The stock has a price-earnings multiple of 11.0 and is priced to offer a 10.9% expected return. The company decides to repurchase half the common stock and substitute an equal value of debt. Assume that the debt yields a risk-free 4.6%. Calculate the following: Required: a. The beta of the common stock after the refinancing b. The required return and risk premium on the common stock before the refinancing c. The required return and risk premium on the common stock after the refinancing d. The required return on the debt e. The required return on the company (i.e, stock and debt combined) after the refinancing If EBIT remains constant: f. What is the percentage increase in earnings per share after the refinancing? g-1. What is the new price-earnings multiple? g-2. Has anything happened to the stock price? Complete this question by entering your answers in the tabs below. Reg A to E Reg F to G2…Calculate the standard deviation of a portfolio with 0.24 invested in Asset A, 0.33 invested in Asset B, and the rest invested in Asset C. Express your answer as a decimal with four digits after the decimal point (e.g., 0.1234, not 12,34%). Std Dev(A) = 0.43, Std Devirg) = 0.67. Std Dev(rc)=0.53 Correlation(A) =-0.24, Correlation(Arc)-0.32, Correlationirere)=0.09 Type your answer.....Compute the VaR(95%) and ES(95%) of the portfolio managed by Absolute Asset Management if its returns, r, follow the distribution specified below: = 1 10 - |r 100| – 10Question 1Fill the parts in the above table that are shaded in yellow. You will notice that there are nineline items. Question 2 Using the data generated in the previous question (Question 1)a) Plot the Security Market Line b) Superimpose the CAPM’s required return on the SML c) Indicate which investments will plot on, above and below the SML?d) If an investment’s expected return (mean return) does not plot on the SML, what doesit show? Identify undervalued/overvalued investments from the graphKindly answer 11 and 12 Using the stock price data for any two companies provided below carry out the following tasks: 1.Compute, for each asset: i.Total Returns ii.Expected returns iii.standard deviation iv.Correlation Coefficient 2.Construct the variance-covariance matrix 3.Construct equally weighted portfolio and calculate Expected Return, Standard Deviation and Sharpe ratio. 4.Reconstruct equally weighted portfolio and calculate Expected Return, Standard Deviation and Sharpe ratio. 5.Use Solver to determine optimal risky portfolio. 6.Create hypothetical portfolios (commencing from Weight A=0 and weight B=100) 7.Calculate Expected return and Standard Deviation for all the above combinations 8.Graph the efficient frontier 9.Graph the optimal portfolio 10.Assuming that the investors prefers lower level of risk than what a portfolio of risky assets offer, introduce a risk free asset in the portfolio with a return of 3% 11.Using hypothetical weights (A= Portfolio of Risky Assets, B= 1…K (Expected rate of return and risk) Syntex, Inc. is considering an investment in one of two common stocks. Given the information that follows, which investment is better, based on the risk (as measured by the standard deviation) and return? Common Stock A Probability 0.20 0.60 0.20 Common Stock B Return 13% 17% 18% Probability 0.10 0.40 0.40 0.10 (Click on the icon in order to copy its contents into a spreadsheet.) Return -7% 5% 16% 21% www a. Given the information in the table, the expected rate of return for stock A is 16.40 %. (Round to two decimal places.) The standard deviation of stock A is 1.74 %. (Round to two decimal places.) b. The expected rate of return for stock B is 9.8 %. (Round to two decimal places.) The standard deviation for stock B is 6.12 %. (Round to two decimal places.)SEE MORE QUESTIONS