Calculate the daily market return over the last five years

Assignment Help Financial Management
Reference no: EM131169072

Assignment

Question 1 Risk and Return

Calculate the following using the data from Yahoo Finance (https://au.finance.yahoo.com/) for the company you selected for Question 1 of Assignment .

1. Calculate the daily market return over the last five years from the daily prices, calculate the monthly returns from the daily returns, and calculate the yearly returns from the monthly returns.

2. Calculate the total risk (i.e. yearly standard deviation of the daily returns).

3. Calculate the yearly systematic / market risk using the daily returns of the stock and daily return of the market index.

4. Calculate the unsystematic risk / firm specific risk. Suggest whether this company is a good investment. Answer the following questions while making your suggestion.

a) What is the basis for selection of this stock if you suggest this as a good investment?

b) Would you invest all your money into this stock? If not, why not? How will you address this concern?

Question 2 Capital Budgeting

ABC Ltd. would like to set up a new expansion plant. Currently, ABC has an option to buy an existing building at a cost of AUD 24 000. Necessary equipment for the plant will cost AUD 16 000, including installation costs. The economic life of the equipment and building are 5
and 40 years, respectively. The project also requires an initial investment of AUD 12 000 in net working capital. The initial working capital investment will be made at the time of the purchase of the building and equipment.

The project's estimated economic life is four years. At the end of that time, the building is expected to have a market value of AUD 15 000 and a book value of AUD 21 600, whereas the equipment is expected to have a market value of AUD 4 000 and a book value of AUD 3
200.

Annual sales will be AUD 80 000. The production department has estimated that variable manufacturing costs will total 60% of sales and that fixed overhead costs, excluding depreciation, will be AUD 10 000 a year. Depreciation expense will be determined for the year using straight line depreciation method.

ABC's tax rate is 40%; its cost of capital is 12%; and, for capital budgeting purposes, the company's policy is to assume that operating cash flows occur at the end of each year. The plant will begin operations immediately after the investment is made, and the first operating cash flows will occur exactly one year later.

Requirements:

1. Compute the initial investment outlay, operating cash flow over the project's life, and the terminal-year cash flows for ABC's expansion project.

2. Determine whether the project should be accepted using NPV analysis.

3. Do the sensitivity analysis using different levels of change (e.g. 2%, 5% and 10% increase and decrease) of each of the key inputs (e.g., sales, variable costs and cost of capital)

4. Identify the most sensitive factor

5. Perform the scenario analysis

Return and Risk Calculation

1. Calculation of daily market returns for the company selected for Module 1 assignment for over 5 years What is daily market return?
A: Percentage change in prices over one day holding period.
How to calculate?

Rt=((Pt-Pt-1)/Pt-1)
Where,

Rt = Return today
Pt = Price today
Pt-1= Price yesterday

Alternatively:

Rt= ln(Pt/Pt-1)

Where,

ln = Natural logarithm

What is the source of market price data?
A: yahoo finance

2. Calculation of monthly market returns from the daily market returns.

How to calculate monthly returns from daily returns?

A: Demonstrated in the "return calculation.xlsx" file available under key resources.

Step 1: Add 1 to the daily returns calculated using either Equation (1) or Equation (2)

Step 2: Use the product function in Excel (i.e., = PRODUCT (select the daily returns in a month)

Step 3: Subtract 1 from the product (I have combined step 2 and step 3 in my calculations)

3. Calculation of yearly market returns from the monthly market returns.

How to calculate yearly market returns from the monthly market returns?

A: Please follow the steps below.

Step 1: Add 1 to the monthly returns

Step 2: Use the product function in Excel (i.e., = PRODUCT (select the 12 monthly returns in a year)

Step 3: Subtract 1 from the product (I have combined step 2 and step 3 in my calculations)

4. Should I do calculations for five years in one file?

A: For simplicity, it is better to do the calculations for each year separately (so five files for five years). I am, however, happy if you can do all calculations in one file.

5. Calculate yearly standard deviation (i.e. total risk) of the daily returns.

How to calculate standard deviation of the daily returns?

A: Please use the Excel formula (=STDEV.S (select the range of daily returns))

6. Calculate yearly market risk (or systematic risk).

A: It is a yearly calculation using the daily returns of the company and daily returns of the market

Steps in Excel:

i) Data>Analysis>Regression (if you do not find analysis tab under Data, please add the analysis tool pack from options)

ii) Select the range of stock return as Y inputs

iii) Select the range of market returns as X inputs

iv) Tick the label box

v)Select a cell for the output range

vi) Click OK

vii) The coefficient of the market return is the systematic risk (commonly known as beta). Please ignore the other statistics.

SUMMARY OUTPUT




Regression Statistics

Multiple R

0.2154

R Square

0.0464

Adjusted R Square

0.0426

Standard Error

0.0265

Observations

252

ANOVA







 

df

SS

MS

F

Significance F


Regression

1

0.0085

0.0085

12.1683

0.0006


Residual

250

0.1753

0.0007




Total

251

0.1838


 

 









 

Coefficients

Standard Error

t Stat

P-value

Lower 95%

Upper 95%

Intercept

-0.0015

0.0017

-0.8779

0.3808

-0.0048

0.0018

Market return

0.5428

0.1556

3.4883

0.0006

0.2364

0.8493


7. How to calculate the daily market returns?

Step 1: Please use the daily price of a market index (i.e., ASX All Ordinaries or ASX S&P200)

Step 2: Use either Equation (1) or Equation (2) to calculate the daily market retruns.

8. How to calculate the unsystematic risk (or firm specific risk)?

Step 1: Use the following model to calculate the daily fitted returns (or forecasted returns) of the stock of the company

E(Ri)= α +β Rm

Where,

α = Intercept
β = Coefficient of X Variable 1 (i.e., beta)
Rm = Daily market return

Step 2: Calculate the residuals (i.e., actual return minus expected return) for every day.
ε=Ri-E( Ri )

Step 3: Calculate the yearly standard deviation of the daily residuals. This is defined as the unsystematic risk.

Reference no: EM131169072

Questions Cloud

What are the roles of remaining open-minded : Voting can change the future of a generation or a nation. For that reason, voting is most effective when it is thoughtful rather than mechanical. What are the roles of remaining open-minded, being informed, and engaging in political dialogue in m..
What is an appropriate sample space for this experiment : QUALITY CONTROL As part of a quality-control procedure, an inspector at Bristol Farms randomly selects ten eggs from each consignment of eggs he receives and records the number of broken eggs.
Who does undervalued and overvalued currency tend to hurt : Who does undervalued and overvalued currency tend to hurt? Why would overvalued currency concerns receive more attention than undervalued currency concerns?
How strong is paine argument : Explore Thomas Paine's theory (in "Common Sense") concerning the idea that mankind is naturally equal and that government should reflect this state of equality. How strong is Paine's argument? Is this a reasonable idea that can be applied in the..
Calculate the daily market return over the last five years : Calculate the daily market return over the last five years from the daily prices, calculate the monthly returns from the daily returns.
Differences affect legal structure accountability governance : The nonprofit organization in the United States differs from the for profit organization in several important ways. These differences affect the legal structure, accountability, governance, leadership, development and management functions of the ..
Is this a matter of civil rights : The second part of the bill maintained that cities like Charlotte could not enact their own anti-discrimination policies. Was this act justified? Is this a matter of civil rights? Do states or national governments have the right to establish anti-..
Check the beam for deflections : Check the beam for deflections. If the beam is unsatisfactory, redesign it so that it meets both flexural strength and deflections requirements.
Do agree with princeton professor keeanga-yamahtta taylor : On the background of the sit-in and one piece that is very critical of it. Do you agree with Princeton professor Keeanga-Yamahtta Taylor's view that the sit-in seemed cynical? (If you do, make sure you precisely outline why you agree, maybe you ag..

Reviews

Write a Review

 

Financial Management Questions & Answers

  What is the market value of the bond

A fourteen-year bond, with par value equals $1,000, pays 10% annually. If similar bonds are currently yielding 9% annually, what is the market value of the bond? Use semi-annual analysis.

  Issued perpetual preferred stock

Ezzell Corporation issued perpetual preferred stock with a 10% annual dividend. The stock currently yields 10%, and its par value is $100. What is the stock's value? Suppose interest rates rise and pull the preferred stock's yield up to 15%.

  Capital structures-What is the break-even EBIT

Kyle Corporation is comparing two different capital structures, an all-equity plan (Plan I) and a levered plan (Plan II). Under Plan I, Kyle would have 765,000 shares of stock outstanding. Under Plan II, there would be 515,000 shares of stock outstan..

  Expand your business by building a new manufacturing plant

You’re trying to determine whether to expand your business by building a new manufacturing plant. The plant has an installation cost of $11.8 million, which will be depreciated straight-line to zero over its four-year life.

  Find the duration of the remaining half of the portfolio

The duration of the portfolio is 8.75 years. A quarter of that portfolio is invested in a bond with a 5 year duration. Another quarter of the portfolio is invested in a bond with 10 year duration. Find the duration of the remaining half of the portfo..

  Bonds outstanding with six months left to maturity

Badger Corp. has an issue of 6% bonds outstanding with 6 months left to maturity. The bonds are currently priced at $1003. The firm's marginal tax rate is 40%. The estimated risk premium between the company's stock and bond returns is 6%. The firm's ..

  Large electric utility is looking to fix its cost of gas

Entergy, a large electric utility is looking to fix its cost of gas purchases over the next 3 years. Entergy currently buys gas in the spot market at the Henry Hub spot price. Describe the flow of payments if both parties agree to the swap terms.

  Frequent criticism of the management of publicly

A frequent criticism of the management of publicly-owned American companies is that they are too short-term oriented, too focused on fast returns, and that this negatively impacts their long term capital budgeting. How do we keep an emphasis on the "..

  Calculate the worst-case and best-case NPV

We are evaluating a project that costs $829,000, has an nine-year life, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the project. Sales are projected at 113,000 units per year. Calculate the best-case N..

  Analysis of alternatives

Assume that Wal-Mart Stores, Inc. has decided to surface and maintain for 10 years a vacant lot next to one of its stores to serve as a parking lot for customers. Management is considering the following bids involving two different qualities of surfa..

  What is approximate expected percentage change in currencies

What is the approximate expected percentage change in the value of each of these currencies against the dollar over the next year, when applying PPP to the inflation level of each of these currencies versus the dollar?

  Movements in cross exchange rates

Movements in Cross exchange rates last year a dollar was equal to 7 Swedish kronor, and a polish zloty was equal to $.40. Today, the dollar is equal to 8 Swedish kronor, and a polish zloty is equal to $.44. By what percentage did the cross exchange r..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd