Group Assignment [Groups can be 1 or 2 person groups] Due Week 10, Monday 14 May, 2018 at 11.45pm This guide is split into five Sections. 1. Overview 2. Submission Details and Issues that will...

1 answer below »


Group Assignment [Groups can be 1 or 2 person groups]



Due Week 10, Monday 14 May, 2018 at 11.45pm



This guide is split into five Sections.



1.
Overview



2.
Submission Details and Issues that will Influence Your Mark



3.
Task Requirements and Marking Rubric



4.
Mark sheet



5.
APA Quick Reference Guide






Section 1: Overview


This is a group assignment. There are two parts.


·Part 1is based on a case study and will assess your research, analytical and written skills as well as your understanding of share valuation techniques. The topic draws from material covered in Week 6 – Chapter 10 Share Valuations. All questions were developed from your prescribed textbook, Managerial Finance – Principles and Applications by Titman et al. (2016).




Important Note: To compete part 1 you will need to purchase a recent copy of the Australian Financial Review [i.e. not less than 3 months old].


·Part 2requires you to consider the approach Warren Buffet uses to do a share valuation


Additional resources may be uploaded to FINC20018


·Part 3requires you to compare Warren Buffet’s approach to share valuation and the share valuation methodology in Chapter 10 and recommend which approach you prefer and why.



Specific task requirements are detailed in Section 3 – Task Requirements and Marking Criteria.



What is a Group?


·For campus students: a group can be agroup of 1 or 2 students.


·For distant learning (FLEX) students: while a group of 1 is likely to be more practical, you also have the option of forming a group of 2 students.


·Important Note 1: Students working as a group,only one memberof the group will submit the assignment online by uploading it in Moodle.






Section 2: Submission Details



Submission Format:You are required to present your response in report format.



Word Limit:The word limit is 1,350 words andexcludestitle and cover pages, table of contents, reference list, and appendix and any other supplementary material or attachments.



Important Note: This word limit and number of reference is based on present recommended School of Business and Law policy for post-graduate students.



Minimum number of references:In total [i.e. for both Part 1, 2 and 3] the minimum number is 5 and must include 5 peer-reviewed articles. You may use well-known newspapers, magazines, and reliable internet and journal sources such as Applied Finance, Financial Analyst Journal, and Journal of Banking & Finance. Wikipedia and Investopedia arenot permittedto be used as sources.



Submission Online:YouMUSTsubmit this assessment online as a word document. We will not accept PDF submissions.



Issues that will affect your marks include:


1.Create your own cover pagefor your Report, butdo not include the Marking Sheet or the marking criteria/rubricsin your report. You grader will take care of this when they grade your paper to provide you feedback on your report. Make sure both student members of you group is added to your cover page.


2.Where copying from other sources results in high percentage similarity, we will deduct marks as shown on the mark-sheet. Therefore, proper use of in-text referencing is important. Avoid direct quotes.


Turnitin checks percentage similarity.



Do not copy the questions from the textbook, as this will increase your percentage similarity.


Under extreme circumstances where high % similarity indicates copying from written works of other students in CQU, other universities or any other institutions world-wide, the assignment will be reviewed by the academic misconduct board. If percentage similarity exceeds 20%, then we will deduct marks based on a progressive scale as determined by the course co-ordinator.


3.A marking rubric is provided in Section 3 and totals 50 marks and will be scaled down to reflect a grade out of 30%.


The assessment is worth 30% total assessment grade.


We record your final grade on Moodle as a percentage of 30%.



4.Penalty for late submission is 5% per calendar day including Saturday and Sunday.






Section 3: Task Requirements


The task is based on a real-world case study and as stated, there are three parts.


You are required to present answers to some questions in a single report.


To demonstrate in-depth of understanding of share valuation techniques, it is expected that you extend your research beyond the prescribed textbook when making comparisons about share valuation techniques.



Section 3: The Case Study


Obtain or purchase a recent [i.e. less than three months old] copy of the newspaper Australian Financial Review or access the information online at this linkhttp://www.afr.com/(you can obtain a free subscription for one month)


Refer to the page that provides details of shares currently traded on The ASX.



TASK 1


Just like an investor, select ten listed ordinary share companies from and create a portfolio. For instance, select 3 shares from list of Information Technology, 4 shares from Energy and 3 from Financials


1.Using equity valuation methods taught in Week 6 and described in Chapter 10 calculate the value of each selected ordinary share investment in terms ofyourrequired rate of return.



Hint: To answer the question, you will need to calculate the value of the companies selected, and to do that you need to demonstrate that you have learnt something about equity valuation. In your analysis, consider valuing the shares using the ordinary share discounted dividend model and then the comparable approach to valuing ordinary shares. Consider the principles that will determine the value of a company in your report.




2.Rank the ten investments in order of desirability. Explain why you have ranked them in this way. [10/40 marks for content and knowledge]



3.Which investment of the ten would you select? Why? [5/40 marks for content and knowledge]




TASK 2


According to Warren Buffet,"Intrinsic value is an estimate rather than a precise figure, and it is additionally an estimate that must be changed if interest rates move or forecasts of future cash flows are revised. Two people looking at the same set of facts, moreover--and this would apply even to Charlie and me--will almost inevitably come up with at least slightly different intrinsic value figures."


Warren Buffet is one of the richest men in the world.


Research and summarise some interesting facts about Warren Buffet that you can relate to the companies you have selected from the Financial Review to analyse. [5/40 for content and knowledge]


There are several YouTube featuring interviews and/or commentary by Warren Buffet about how to invest wisely. Below are three to get you started. Skip the ads, watch them and summarise the key points that he makes in relation to investment.


·Warren Buffet Best Advice on Successful Investing:https://www.youtube.com/watch?v=_5VQPIeZhMc


·Warren Buffet on Why He’ll Never Sell a Share of Coke Stock:https://www.youtube.com/watch?v=4p1_5bZ8I4M


·Warren Buffet Financial Rules to Live By:https://www.youtube.com/watch?v=gUAtVyWS_4Y




TASK 3


·Compare Warren Buffet’s approach to share valuation and the share valuation methodology in Week 6 - Chapter 10 and recommend which approach you prefer withonereason why.[10/40 marks for content and knowledge]







Important Information:


·Response to case study must be in report format and include an executive summary, table of contents, introduction, body with suitable headings and sub-headings, conclusion and wide variety of references.


·Report fonts must be either Arial or Times Roman 12 pt and 1.5 spacing for narrative, 16 pt bold for major headings and 14 pt bold for sub-headings.


·Inclusion of diagrams and tables to support the response is strongly encouraged.


·All supporting material must be properly referenced using APA in-text referencing formats


·Support for the response should draw from the Warren Buffet You Tube clips and/or related websites


·Word count is 1,350 words maximum (i.e. 6 pages maximum) excluding in-text referencing, diagrams and tables.




Important note:There are over 2,000 companies listed on the ASX, thus your graders expect that it is unlikely two groups will be investigating the same list of ten companies. It is the graders expectations, that we see analysis of a variety of different companies from the different groups covering different Financial Review dates.









Section 4: Assignment Questions and Marking Criteria / Rubric



FINC20018 Marketing Rubric



Assessment type: Written Assessment


















Unit code and name








Student ID and name






















































































































































































Key Criteria




Exceeds Expectations



(High Distinction) 85-100%




Exceeds Expectations (Distinction) 75 - 84%




Meets Expectations



(Credit) 65 – 74%




Meets Expectations



(Pass) 50 – 64%




Below Expectations



(Fail) below 50%




Executive Summary



Excellent executive summary; providing a summary of the key problem, key issues with regards to the problem and the recommendations and future practical steps



Good executive summary; providing a summary of the key problem, key issues with regards to the problem and the recommendations and future practical steps



Fair executive summary, providing a summary of the key problem, key issues with regards to the problem and the recommendations and future practical steps



Poor executive summary; providing a summary of the key problem, key issues with regards to the problem and the recommendations and future practical steps



Very poor or non-existent executive summary.




Student achievement



10



8



6



5



3




Introduction and/or purpose



Excellent introduction; providing a very clear purpose, which ensures all areas relevant to the topic are clearly outlined.



Good introduction; providing a mostly clear purpose, which ensures most areas relevant to the topic are clearly outlined.



Fair introduction, addresses some points, lacks some detail; ensures some areas relevant to the topic are outlined.



Poor introduction; addresses limited points, lacks detail; of which few areas are outlined.



Very poor or non-existent introduction.




Student achievement



5



4



3



2



1




Organisation or structure



The ideas are arranged in an extremely logical, structured and coherent manner.



The ideas are arranged in a fairly logical, structured and coherent manner.



The ideas are arranged in a logical, some-what structured and coherent manner.



The ideas appear less logical, structured and presents in fairly incoherent manner.



There is little, if any, coherent structure to the document.




Student achievement



5



4



3



2



1




Content Knowledge (or literature/argument)



Demonstrates a balanced and very high level of detailed knowledge of core concepts by providing a very high level of analysis.



Demonstrates a balanced and high level of knowledge of core concepts by providing a high level of analysis.



Demonstrates a good level of knowledge of some of the core concepts by providing some level of analysis.



Demonstrates limited knowledge of core concepts by providing a limited level of analysis.



Demonstrates little, if any, knowledge of the core concepts with extremely limited, if any, analysis.




Student achievement



40



30



20



10



5




Presentation and quality of writing



Quality of writing at a very high standard. Paragraphs are coherently connected to each other. Correct grammar, spelling and punctuation.



Quality of writing is of a high standard. Paragraphs are mostly well structured. Few grammar, spelling and punctuation mistakes.



Quality of writing is of a good standard. Few grammar, spelling and punctuation mistakes.



Some problems with sentence structure and presentation Frequent grammar, punctuation and spelling mistakes. Use of inappropriate language.



Quality of writing is at a very poor standard so barely understandable. Many spelling mistakes. Little or no evidence of proof reading.




Student achievement



5



4



3



2



1




Recommendations



The assessment presents detailed relevant recommendations supported by sound literature and case study evidence of the ideas presented; drawing clear and well thought-out recommendations.



The assessment presents a fairly detailed relevant recommendations supported by sound literature and case study evidence of the ideas presented; drawing fairly clear and well thought-out recommendations.



The assessment presents a somewhat detailed relevant recommendations supported by sound literature and case study evidence of the ideas presented; providing some evidence of recommendations.



The assessment provides limited detail with no relevant recommendations supported by sound literature and case study evidence of the ideas presented; drawing limited recommendations.



The assessment fails to provide any clear evidence of relevant recommendations; drawing no clear recommendations.




Student achievement



10



8



6



5



3




Conclusion/ summarisation



The assessment presents a detailed and focused summary of the ideas presented; drawing clear and well thought-out conclusions.



The assessment presents a fairly detailed and focused summary of the ideas presented; drawing fairly clear and well thought-out conclusions.



The assessment presents a somewhat detailed and focused summary of the ideas presented; providing some evidence of conclusions.



The assessment provides limited detail with no clear summary of the ideas presented; drawing limited conclusions.



The assessment fails to provide any clear evidence of the ideas presented; drawing no clear conclusions.




Student achievement



5



4



3



2



1




Research (referencing)



Utilises current, appropriate and credible sources from quality peer-reviewed sourcesReferencing accurate– per APA Reference Guide.


Students reference the source of formula, information, arguments, diagrams and/or examples appropriately. HINT: Insert formula reference as a footnote.



Utilises current, appropriate and credible sources.


Students reference the source of formula, information, arguments, diagrams and/or examples appropriately. HINT: Insert formula reference as a footnote



Utilises current, appropriate and credible sources.


Students reference the source of formula, information, arguments, diagrams and/or examples appropriately. HINT: Insert formula reference as a footnote



Utilises few current, appropriate and credible sources.


Students reference the source of formula, information, arguments, diagrams and/or examples appropriately. HINT: Insert formula reference as a footnote



Utilises little, if any, current, appropriate and credible sources.


Students reference the source of formula, information, arguments, diagrams and/or examples appropriately. HINT: Insert formula reference as a footnote




Referencing



20



16



12



8



4




Late assessment penalty






Other penalty






Best aspects of the assessment






Areas where improvement is needed






Final student achievement

















Section 4:






Mark Sheet for Assignment 2





This is not your cover sheet. Do not submit together with your responses.




Name: _________________________ Campus: __________ Student ID: _________



Name: _________________________ Campus: __________ Student ID: _________























































































Question




Max Marks




Student Mark




Less % for



Un-referenced Material/high similarity/late submission




Total Mark




Executive Summary



10
















Introduction and/or purpose



5
















Organisation or structure



5
















Content Knowledge (or literature/argument)



40
















Presentation and quality of writing



5
















Recommendations



10
















Conclusion/ summarisation



5
















Research/Referencing



20
















Total




100
















Converted to




30























Answered Same DayMay 07, 2020FINC20018Central Queensland University

Answer To: Group Assignment [Groups can be 1 or 2 person groups] Due Week 10, Monday 14 May, 2018 at 11.45pm ...

Aarti J answered on May 12 2020
137 Votes

Finance – Stock Valuation
Course Name
Course Date
Student’s Name
Finance – Stock Valuation
Task 1
Stock analysis – Introduction
Stock valuation is an important means for valuing the shares. For the investment purpose, the valuation of shares helps in analysing and deciding whether to invest in the stock or not. For the analysis, 10 stocks from different industries have been analysed. These includes the stock from different sectors which are being traded in the Australian stock exchange.
The ten investments that are used for analysis includes:
    Rio tinto
    Wasfarmers
    ARB corporation
    Qantas airlines
    National australia bank limited
    Woolworths
    Commonwealth bank of australia
    BHP billiton
    ANZ
    Star entertainment
Firstly the required rate of return of the stocks are analysed using the CAPM model
Required rate of return = Risk free rate + beta * (Market return – risk free rate)
The risk free ra
te for the 10 year bond of the Australian market is calculated to be 2.78% and the market rate is assumed to be 12%.
    Stocks
    Beta
    Risk free rate
    Market return
    Required return
    Rio tinto
    0.75
    2.78%
    12%
    9.70%
    Wasfarmers
    0.81
    2.78%
    12%
    10.25%
    ARB corporation
    0.96
    2.78%
    12%
    11.63%
    Qantas airlines
    0.77
    2.78%
    12%
    9.88%
    National australia bank limited
    1.2
    2.78%
    12%
    13.84%
    Woolworths
    0.77
    2.78%
    12%
    9.88%
    Commonwealth bank of australia
    1.15
    2.78%
    12%
    13.38%
    BHP billiton
    1
    2.78%
    12%
    12.00%
    ANZ
    1.4
    2.78%
    12%
    15.69%
    Star entertainment
    1.07
    2.78%
    12%
    12.65%
Now, calculating the intrinsic value of the stock using the Dividend discount model
Value of the stock = D1/(r-g)
    Stocks
    g
    Required return
    D0
    Value
    Rio tinto
    6.57%
    9.70%
    5.22
     $ 178.01
    Wasfarmers
    6.68%
    10.25%
    3.1853
     $ 95.23
    ARB corporation
    2.30%
    11.63%
    0.72
     $ 7.89
    Qantas airlines
    2.39%
    9.88%
    1.4
     $ 19.14
    National australia bank limited
    9.80%
    13.84%
    2.8286
     $ 76.80
    Woolworths
    4.85%
    9.88%
    1.32
     $ 27.52
    Commonwealth bank of australia
    8.50%
    13.38%
    2.857
     $ 63.48
    BHP billiton
    5.94%
    12.00%
    1.836
     $ 32.10
    ANZ
    8.58%
    15.69%
    1.14
     $ 17.41
    Star entertainment
    4.22%
    12.65%
    0.212
     $ 2.62
Comparing the value of the stock using the P/E ratio
Value = P/E ratio * EPS
    Stocks
    P/E
    EPS
    Value
    Rio tinto
    17.23
    4.87
    83.9101
    Wasfarmers
    33.08
    1.33
    43.9964
    ARB corporation
    34.89
    0.62
    21.6318
    Qantas airlines
    11.66
    0.52
    6.0632
    National australia bank limited
    15.02
    1.89
    28.3878
    Woolworths
    20.63
    1.39
    28.6757
    Commonwealth bank of australia
    12.7
    5.55
    70.485
    BHP billiton
    37.64
    0.88
    33.1232
    ANZ
    13.35
    2.11
    28.1685
    Star entertainment
    28.78
    0.19
    5.4682
Ranking:
    Rank
    Stocks
    1
    Rio tinto
    2
    Wasfarmers
    3
    National australia bank limited
    4
    Commonwealth bank of australia
    5
    BHP billiton
    6
    Woolworths
    7
    Qantas airlines
    8
    ANZ
    9
    ARB corporation
    10
    Star entertainment
I would rank Rio Tinto as one of the investment in the company which will give higher returns to the company.
Task 2:
Warren Buffett follows the rules of Benjamin Graham school of valuing the investing. As per Warren, the investors should look for the prices which are low as compared to its intrinsic value. Buffett considers there are different methods to analyse the performance of the company. He prefers different ratios to analyse the performance of the company.
With the help of return on investment or return on equity, the company’s performance and its consistency for profitability can be analysed.
With the help of the debt equity ratio, the investor can analyse if the company has avoided excess debt or not.
With the help of profit margin the company can analyse if the company has been giving high return and able to attain adequate profits or not. If the company has high profits it means that the company is performing well and executing its operations adequately.
Buffett usually considers the company which have been listed for atleast 10 years for the investment. He does not consider the new players in the market. According to him, the value investing requires to test the company over the period of time and how the company has performed over the years. (Matthew J Bekvedere, 2017)
Buffett also takes into consideration differentiation. It tries to see what the company offers, if the company just offers commodity or the products that are offered by its competitor like oil and gas, then he would not consider the company for the investment purposes.
For the investment, according to Buffett, the investor needs to find the company’s intrinsic value which is analysed by using different aspects like earnings, revenues and assets. After analysing the intrinsic value, he compares the intrinsic value with its current market capitalization. If the intrinsic value of the company is 25% higher than its current market capitalization, then it is considered as the company for investment otherwise it is not.
Buffett investing style is considered as one of the most practical and simple analysis where he puts value investing style in investing the stocks rather than the tactical means.
According to Buffett, “Valuations make sense with the interest rates where they are”, low borrowing cost has been a powerful tool to analyze the value of the stock, (CNBC, 2017)
Task 3: Warren Buffett method and stock valuation method
As per the stock valuation, the investors uses different means and different methods for analysing the value of the stock. There are different methods like the dividend discount model which helps in analysing the value of the shares.
With the dividend discount model, the company is able to analyse value of the equity or the price of the stock which can be used to analyse the performance of the stock and compare it with the actual price of the stock. The price of the stock using dividend growth model can be calculated as: Dividend 1 / (rate of return – growth rate)
The required rate of return can also be analysed using the CAPM model. CAPM model is called as the capital asset pricing model. In the CAPM model the cost of equity is calculated as:
Cost of equity = Risk free rate + beta * (Market return – risk free rate)
It helps in calculating the return on the equity considering the risk, risk free rate and market premium. The company having high risk has high beta and higher cost of equity. Similarly an asset with low beta has lower risk.
As per the CAPM model, with the increase in the risk free rate or beta, the investors required rate will increase and the stock price will fall.
In the dividend discount model, the two major factors which affects the price sof the stock includes the required return and the growth rate.
The comparable value of the shares can be calculated using the price earnings ratio and the earnings per share.
Thus the stock valuation methods usually talks about different valuation methods like Dividend discount model and the stock valuation through P/E ratio while Warren Buffett does not rely on these methods and focus on different methods which is based on the historical financial data as well as the other aspects of the company and its working.
Warren Follows four rules for analysing the stocks and investing in them. The first step is vigilant leadership, the second step is long term projects, the third step I stable and understand ability and the last step in to analyse the attractive intrinsic value.
Warren buffet considers different ratios like return on equity, dent to equity, profit margin and other operating and valuation ratios which helps in analysing the performance of the company from different perspectives. He uses the real world and practical aspect to analyse the cost and the value of the stock and its market which is lacked in different stock valuation techniques. With the more practical approach the method that is being adopted by Warren Buffett has been better and helps in analysing the stock of the company more carefully.
References:
Stock valuation, (2018), How to choose the best stock valuation method www.investopedia.com/articles/fundamental-analysis/11/choosing-valuation-methods.asp
Stock value, (2018), Australian Securities Exchange: www.asx.com.au/
Stock value (2018), Yahoo stock valuation: available at:www.au.yahoo.com
Investopedia staff, (2018), Warren buffett: How he does it, available at: https://www.investopedia.com/articles/01/071801.asp
Matthew J Bekvedere, (2017, 3 Oct), Billionaire Warren Buffett says stock valuations make sense with interest rates where they are, available at: https://www.cnbc.com/2017/10/03/billionaire-warren-buffett-says-stock-valuations-make-sense-with-interest-rates-where-they-are.html
Gurufocus, (2013), Warren Bufferr’s Two column valuation method, Available at: https://www.nasdaq.com/article/warren-buffetts-twocolumn-valuation-method-cm247095
Hemmerling Kurtis, (2017), Buffettology: Warren Buffett Quotes & Value Investment Strategy for Stock Picks, available at: https://www.moneycrashers.com/buffettology-warren-buffet-quotes-investment-strategy-stock-picks/
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here