Case Study on Corporate Finance for FIN510/FIN205
Case Study on Corporate Finance for FIN510/FIN205
This assignment consists of two parts, total marks 15, weights 15%. This assignment will be due at 11:59PM, Monday 7th October 2024. You will work on the selected public firm listed on the ASX 300 and you will prepare a report based on the research the selected company from the perspective of risk and return relationship of this companys shares.
Word limit 1500 to 3000 words.
This is group assignment You will work in a group of four to five students.
Groups are self-selected.
Submit your response in one Excel file and one Word file. The Excel worksheets should contain the calculations and workings, while the Word file should contain reports where you present the findings, considerations, recommendations, conclusions or any other issues relevant to each task.
Case study report for selected company (Total 15 marks)
The purpose of this case study is to allow students to take some of the main concepts introduced in the course and provide a framework for applying them to a company of their choosing. One of the best ways of learning corporate finance is to apply the models and theories we encounter to the real-world contexts and problems. You will:
Task: Evaluate stock price, and estimate the impact of an important announcement on its stock prices (15 marks);
Scenario
You have recently started an internship position with Griffith Best Equity Management (GEM), a large asset management company with A$750 million Assets Under Management located in Darwin CBD. The companys core investment focuses on domestic share market, however, investments in share markets have provided lower than expected returns in the recent years.
GEMs Chief Investment Officer (CIO) has assigned you to perform an investment appraisal on a single company listed on the ASX300 and provide recommendation if the company analyzed should be included as part of GEMs investment.
Your personal values and experiences are important, you should base your response on the evidence provided in these tasks along with your knowledge gained in the course. It is important that you provide clear evidence of your ability to apply your knowledge of finance as learned in the course to the task. The CIO has requested that your analysis must be up-to-date analysis with at least 3 years of data. Price data should include data to the most recent period.
Your report must address the following issues,:
A brief description of the company analyzed
Analysis of companys share price using
the Dividend Discount Model (1-stage and 2-stage). You will determine if the share price is priced fairly or over/under-valued.
News/Announcement effect on companys share price. You will investigate the speed of share price adjustment to these announcements using graphs. You will discuss the share performance over the last 3 years, showing the major events (announcements) in the life of the company and discuss how these events (announcements) have impacted the share price. One of the events discussed should be from 2024.
On the same chart, present the performance of the major competitor and the market for comparison.
Your current internship position is under 3 months probation period. Upon completing the task on hand, your department secretary will arrange a meeting with CIO to discuss whether you have passed the probation period and be promoted to a Junior Corporate Finance Analyst.
Task: Evaluate stock price, and estimate the impact of an important announcement on its stock prices (15 marks)
Brief description of the company (1 mark)
Evaluate stock price, and estimate the impact of an important announcement on its stock prices
Stock beta: Download 3 years of weekly stock returns and ASX300 market index returns ending August 31 (this is the date you collect data) from Yahoo Finance and estimate the stock beta. Does the estimate of stock beta make sense to you? (The normal range of beta is from 0.5 to 3.) Provide reasoning, why or why not? If not, you have to use the stock beta from Yahoo Finance for the later parts. (3 marks)
Estimate the Cost of equity, using the CAPM return. Assume the market risk premium, Rm-Rf=6%, and use the current 10-year Government bond yield for the risk-free rate. (1 marks)
DPS is the total annual dividend per share paid for the financial year. Based on the previous 5-year pattern of DPS payments, estimate the intrinsic values using 1-stage models (the constant dividend growth model), and the 2-stage non-constant dividend growth model. Please use the 10-year Government bond yield as the Dividend growth rate in the equilibrium stage. You need to choose which model is the most appropriate one to use, and compare the intrinsic value versus the share price as of today (current price). Would you recommend to buy or sell the shares today? Calculate share price by adjusting your beta +-10% of estimated beta values in part (a).
Note: In stock valuation your decisions are based on the estimates of variables and if you make an error in these estimates your decisions can be wrong resulting in significant losses. By considering a range of these estimates you test robustness of your results and as such see how your decisions stack up in case your estimates are incorrect by up to 10%. This is a simple example there are other ways for testing robustness of results statistically.
marks)
You will study an announcement in 2024 from this company from ASX 300 firms (https://www.asx300list.com/). The announcement can be a new product, a scandal, an earnings announcement, a change in strategy, etc. What is your expectation of the market reaction to the announcement, good or bad news? (1 marks)
Cumulative Holding period returns = [(1+r1)(1+r2) (1+r3)( 1+rt)]-1
Note: The holding period return is NOT the usual weekly return you calculated
Choice of Company - You will select a company.
A complete submission to Learnline/SafeAssign consists a Word file, an Excel file, and should include the following:
All input variables, such as risk-free rate, the market risk-premium, dividend growth rate, etc, and
all computations such as the beta estimate, cost of equity, intrinsic value, Analyst Expected Return, RRR, etc. Please put all input variables in an input box.
Font size: 12 of Calibri, Arial or Times New Roman
Margins: minimum 1 cm on the top/bottom and right/left.
NOTE:
If Bloomberg is not available, you may use https://au.finance.yahoo.com/ to download all historical stock price data required.
All submissions need to be clearly structured and calculations need to be clearly laid out.
Dates given are indicative. Use most recent data available at the time of collection of data for your assignment.
Company TPG (2016 Dec.) Example
Assume Rm-Rf=6%, beta=0.547, Rf=2%,
DPS0= $0.2071, P0= $7.41
CAPM R= 2% + 0.547*6% = 5.28%
FYR=201220132014201152016
Dividend=0.07860.10710.13220.1643 0.2071
growth=0.36260.23440.24280.2605
geometric av. growth last 3 years = 0.2458
2-stage DDM model:
g = 0.2459 for 3 years; g =Rf = 2% afterward
Intrinsic value = D1/(1+R) + D2(1+R)2 + (D3+P3)/(1+R)3
= 0.2071*1.2459/1.0528 + 0.2071*1.24592/(1.0528)2 + (0.2071*1.24593 +
0.2071*1.24593*1.02/(0.0528-0.02)) /(1.0528)3
= 11.55vsStock Price___________
=> under-/ over- priced
Appendix 1: 1-stage and 2-stage models on valuation:
TPG
Rf 2% Rm-Rf 6% Beta 0.547 P0 (2016 Dec) 7.41 Target price 10 CAPM (R) 5.28% EPS 0.45 2-stage DDM model: Ex-Div. Date Amount Annual Div. Growth Geom. Avg. Growth
10/17/2016 0.1071 0.2071 0.2605 0.2458
04/18/2016 0.1 10/9/2015 0.0857 0.1643 0.2428 4/10/2015 0.0786 10/10/2014 0.0679 0.1322 0.2344 4/9/2014 0.0643 10/9/2013 0.0571 0.1071 0.3626 4/10/2013 0.05 10/10/2012 0.0393 0.0786 4/11/2012 0.0393 Div. growth rate First 3 years 24.59% Afterward 2% Year 0 1 2 3
DPS 0.2071 0.2580 0.3215 0.4005
P3 12.4554
Intrinsic value= $11.55 1-stage DDM model: Constant growth model g=2% Intrinsic value= $6.44
Excel Layout
-453389187515500556641046945540054114705010150Beta
00Beta
1333533210500-7200901602740Stock
Return
00Stock
Return
Note that this sample used the weekly stock prices-8001001193165Stock Holding Period Return
return
00Stock Holding Period Return
return
-30215018481300
Announcement Effect
Task: Evaluate stock price, and estimate the impact of an important announcement on its stock prices (15 marks)
1. Brief description of the company (1 mark)
2. Evaluate stock price, and estimate the impact of an important announcement on its stock prices
a) Stock beta: Download 3 years of weekly stock returns and ASX300 market index returns ending August 31 (this is the date you collect data) from Yahoo Finance and estimate the stock beta. Does the estimate of stock beta make sense to you? (The normal range of beta is from 0.5 to 3.) Provide reasoning, why or why not? If not, you have to use the stock beta from Yahoo Finance for the later parts. (3 marks)
b) Estimate the Cost of equity, using the CAPM return. Assume the market risk premium, Rm-Rf=6%, and use the current 10-year Government bond yield for the risk-free rate. (1 marks)
c) DPS is the total annual dividend per share paid for the financial year. Based on the previous 5-year pattern of DPS payments, estimate the intrinsic values using 1-stage models (the constant dividend growth model), and the 2-stage non-constant dividend growth model. Please use the 10-year Government bond yield as the Dividend growth rate in the equilibrium stage. You need to choose which model is the most appropriate one to use, and compare the intrinsic value versus the share price as of today (current price). Would you recommend to buy or sell the shares today? Calculate share price by adjusting your beta +-10% of estimated beta values in part (a).
Note: In stock valuation your decisions are based on the estimates of variables and if you make an error in these estimates your decisions can be wrong resulting in significant losses. By considering a range of these estimates you test robustness of your results and as such see how your decisions stack up in case your estimates are incorrect by up to 10%. This is a simple example there are other ways for testing robustness of results statistically.
(10 marks)
d) You will study an announcement in 2024 from this company from ASX 300 firms (https://www.asx300list.com/). The announcement can be a new product, a scandal, an earnings announcement, a change in strategy, etc. What is your expectation of the market reaction to the announcement, good or bad news? (1 marks)
Cumulative Holding period returns = [(1+r1)(1+r2) (1+r3)( 1+rt)]-1
Note: The holding period return is NOT the usual weekly returnyoucalculated