Question

In: Finance

show Excel ( show all work including formulars ) You are considering an investment in the...

show Excel ( show all work including formulars )

You are considering an investment in the stock market and have identified two potential stocks, they are Westpac Banking Corp. (ASX: WBC) and Singapore Airlines Ltd. (SGX: C6L). The historical prices for the past 10 years are shown in the table below.

in the table below.

Year

ASX: WBC

SGX: C6L

2009

23.70

13.82

2010

22.85

14.76

2011

21.01

11.1

2012

27.85

10.99

2013

30.66

9.59

2014

34.23

12.65

2015

30.85

11.03

2016

31.71

9.9

2017

30.96

11.31

2018

24.55

9.65

1. Which stocks would you prefer to own? Would everyone make the same choice? Explain your answer(s).

2. Calculate the correlation coefficient between the two stocks. Does it appear that a portfolio consisting of WBC and C6L would provide good diversification? Explain your answer(s).

3. Calculate the expected (annual) return if you owned a portfolio consisting of 50% in WBC and 50% in C6L. Would you prefer the portfolio to owning either of the stocks alone?

Solutions

Expert Solution

1. Answer

Particulars Stock ASX WBC Stock : SGX C6L
Expected Return 27.837 11.48
Risk ( Standard Deviation) 4.27 1.66

Stock ASX WBC is having an higher return with higher Risk where as Stock SGX C6L is having lower return for lower risk...

So risk lovers will take Stock WBC we as lover neutrals will take Stock C6L...

Other wise we can find risk coefficient ….

Particulars Stock WBC Stock C6L
Expected Return 27.837 11.48
Risk ( Standard Deviation) 4.27 1.66
Return/risk 6.519 6.915

So even risk efficient is Same for both stock .

It defines the return taken for each % of risk …..In both stock it is around so it depends upon the person taking the risk to select any stock.

2. Correlation already as given above it is -0.32

So risk decreases when we investment in both security as portfolio ..I.e if one stock return fall other Stock return gains so rsik of over all portfolio reduces ,..... It is an good diversification since risk reduces.. as correlation is negative …

3. Expected return of portfolio is (0.5*23.7837)+(0.5*11.48) = 17.63185

Expected risk is = 4.11....

I would prefer this portfolio when compared to alone stock since getting More return and risk low …

And even it depends upon person /… since efficient frontiner at here ..

Formulas for Risk of portfolios is .

and given all formulas used...

First one is calculating SD of single stock

Next one is for Portfolio...


Related Solutions

SHOW WORK ON EXCEL: You are considering an investment that will pay you $12,000 the first...
SHOW WORK ON EXCEL: You are considering an investment that will pay you $12,000 the first year, $13,000 the second year, $17,000 the third year, $19,000 the fourth year, $23,000 the fifth year, and $28,000 the sixth year (all payments are at the end of each year). What is the maximum you would be willing to pay for this investment if your opportunity cost is 11%?
show Excel ( show all work including formulars ) As a senior analyst for the company...
show Excel ( show all work including formulars ) As a senior analyst for the company you have been asked to evaluate a new IT software project. The company has just paid a consulting firm $50,000 for a test marketing analysis. After looking at the project plan, you anticipate that the project will need to acquire computer hardware for a cost of $400,000. The Australian Taxation Office rules allow an effective life for the computer hardware of five years. The...
Solve in Excel. Show formulas A) You are considering an investment that will pay you $12,000...
Solve in Excel. Show formulas A) You are considering an investment that will pay you $12,000 the first year, $13,000 the second year, $17,000 the third year, $19,000 the fourth year, $23,000 the fifth year, and $28,000 the sixth year (all payments are at the end of each year). What is the maximum you would pay for this investment if your opportunity cost is 12%? B) You are considering an investment that will pay you $12,000 the first year, $13,000...
PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a...
PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a polling station at an average of 4 per minute (Poisson) where the service rate is 50 per hour (Poisson). a. What is the average number of voters in the system with 5 voter booths? (10 pts) b. What is the minimum number of voting booths needed to keep the average time in the system under three minutes? (10 pts) PLEASE SHOW ALL WORK IN...
( show all work including formulars ) as a senior analyst for the company you have...
( show all work including formulars ) as a senior analyst for the company you have ... Question: Show Excel ( show all work including formulars ) As a senior analyst for the company you have bee... show Excel ( show all work including formulars ) As a senior analyst for the company you have been asked to evaluate a new IT software project. The company has just paid a consulting firm $50,000 for a test marketing analysis. After looking...
Please show work step by step, NO EXCEL. Thank you! The investment is $1,000,000, which is...
Please show work step by step, NO EXCEL. Thank you! The investment is $1,000,000, which is depreciated straight line to a zero salvage value over a 10 year life. The asset will be worthless in 10 years. The project will generate, annually, revenues of $800,000, cash operating expenses of $500,000, and depreciation of $100,000. The tax rate is 30%, and the cost of capital is 10%. a. what are the annual cash flow and the NPV? b. what would be...
Show Work, Please. Excel Preferably. Suppose you are considering investing in a new business that will...
Show Work, Please. Excel Preferably. Suppose you are considering investing in a new business that will cost $10 million. A bank is willing to lend you $7 million for the purchase with equity holders having to provide the remainder of the funds. the terms of the loan are: a 20-year loan with yearly payments at a fixed rate of 3%. You will sell the business after year 8. You estimate the business will have the following profits in years 1-8:...
Show work (excel if possible but show formulas you used in excel): If I buy a...
Show work (excel if possible but show formulas you used in excel): If I buy a new car and pay $399 a month for 5 years and the maintenance costs are $50 the first year and increase by $200 a year for each year after that, how much money would I have to barrow today at a nominal interest rate of 9% to cover my monthly payment and my yearly maintenance bill?
Show work (excel if possible but show formulas you used in excel): If I buy a...
Show work (excel if possible but show formulas you used in excel): If I buy a new car and pay $399 a month for 5 years and the maintenance costs are $50 the first year and increase by $200 a year for each year after that, how much money would I have to barrow today at a nominal interest rate of 9% to cover my monthly payment and my yearly maintenance bill?
Please show all work in order to get credit on an excel file. If you provide...
Please show all work in order to get credit on an excel file. If you provide only the answers without showing your work, I will not be able to provide any credit if your answer is wrong. Petrus has an opportunity to make two investments, but he can only afford to make one of them. Each one costs $ 25,000,000. The first investment can be sold in 14 years for $ 98,500,000 and has no periodic cash flow. The second...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT