You currently work as a team at a major investment bank and have been tasked by the Investment Management Division (IMD) to analyse a stock that will be incorporated into a portfolio with other assets from the same market. You will need to prepare a professional business report that will be submitted to the Investment Management Division (IMD) that answers the questions proposed in this investment brief as well as a final recommendation.

Stock Details [10 marks]

1. Select a publicly listed company that is a constituent of S&P/ASX 300 index (Australia), that has at least 10 consecutive years (from 1 July 2012 to 30 June 2022) of dividend history. The selected company cannot be one which is listed on the last page of the Assignment instructions. Describe the company that you have chosen, so that the IMD has a comprehensive understanding of its operations and risks. (Ifthe company did not pay dividendsin 2020 due to COVID-19 but paid dividendsin every other year, including 2021 and 2022, this will be allowed) (1 mark)

2. List the Global Industry Classification Standard (GICS) sector, industry, and sub-industry for your chosen company. List one other public company that is in the same sub-industry as your chosen company and briefly describe its operations. This competitor does not have to be listed in any of the indices nor is subject to the restrictions in Task 1. (1 mark)

3. Present a table of a current “stock quote” with the following characteristics: (1)Current Price (2) 52 Week Range (3) Market Cap (4) Beta (5) P/E Ratio (6) EPS (7) Earnings Date (8) Forward Dividend and Yield, (9) Ex-Dividend Date, and (10) 1 year Target Estimate for both your chosen company and competitor. Define and interpret the following four measures including Market Cap, Beta, EPS and forward dividend yield. Compare and discuss the differences that you observe between the two companies in respects of the four measures including Market Cap, Beta, EPS and Forward Dividend Yield. Note you should consider the comparability of the measures. (4 marks)

4. Define and interpret the P/E ratio. Compare the P/E ratios of your chosen company and the competitor to the average P/E ratio of the industry of your chosen company. Compare these number with the average P/E ratio of your chosen stock market index as well. Discuss in detail. (4 marks)

Summary Statistics and Risk Characterisation [30 marks]

5. List the current Government bond rates of the following maturities: (i) 1-year, (ii) 5-year, (iii) 10-year, (iv) 20-year, and (v) 30-year in a table. Graph the 10-year government bond rate1 over the time period from January2012 to the most recent month with data available. How has the 10-year rate changed over this period? Why do you think this has occurred? Do you think the 10-year rate will go up or down in the future? Discuss with references to the appropriate academic literature. (5 marks)

6. Calculate the annual returns (from Jul 1st to June 30th for each financial year) for the market index for the last: (i) 5-year period, (ii) 10- year period, and (iii) 20-year period. Calculate the average annual return and standard deviation of annual returns over these 3 time periods using both the arithmetic and geometric averages (for the standard deviation, you can use just the arithmetic average). Display the results in a table. How have these values changed overtime? What do these changes mean for the average investor? Discuss in detail. (5 marks)

7. Calculate the annual return (for each financial year) of your chosen company from July 1st 2012-June 30th 2022. Annualise all dividends paid out2. Calculate the average annual return and standard deviation of annual returns for the whole period using both the arithmetic and geometric averages (for the standard deviation, you can use just the arithmetic average). Display the results in a table. How has your company performed over this period? Do the arithmetic and geometric averages differ for your company? Why or why not? Interpret these numbers for your manager. (5 marks)

8. Calculate the annualbeta for your chosen company returns using themeasures that you generated in Tasks 6 and 7. Report the formula that you followed to calculate the annual beta and explain how each variable in the formula is measured. Compare your calculated annual beta with the beta found in your stock quote. Are these values the same or different? Explain and discuss why they may be similar and/or different. (5marks)

9. Using the Capital Asset Pricing Model (CAPM), calculate the required rate of return on equity for your chosen company. Select one of the different government bond rates in part(7), as proxiesfor the risk-free rate. Select one of the annual return (i.e. arithmetic average and geometric average) calculations calculated in part (6), as a proxy for the expected market returns and justify your choice. Discuss how appropriate your choices are as proxies for the theoretical values in the CAPM equation. (10 marks)

Growth Rates and Valuation [30 marks]

10. Estimate the growth rate of your chosen company’s cash flows by using the following three methods: 

(a) Calculate and list the annual growth rates for dividends from July 2012- June 2022 (For any financial years within your sample with anomalous dividend growth rates discusswhy thismight have occurred. If your company did not pay dividendsin 2020 due to COVID-19 just use the dividends in the prior year as a proxy). Calculate the arithmetic and geometric average annual growth rate of dividends over this period. Also calculate the arithmetic and geometric average annual growth rate of dividends for the subperiod between June 2012- July 2019 (pre-COVID-19) and compare the values.Do you think your company’s dividends will grow at these rates for the foreseeable future? Explain in detail why or why not. (5 marks)

(b) Calculate and list the annual growth rates for net income from July 2012- June 2022 (For any financial years within your sample with anomalous net income growth rates discuss why this might have occurred). Calculate the arithmetic and geometric average annual growth rate of net income over this period. Also calculate the arithmetic and geometric average annual growth rate of net income for the subperiod between July 2012- June 2019 (pre- COVID-19) and compare the values. Do you think your company’s netincome will grow at these rates for the foreseeable future? Explain in detail why or why not. (5 marks)

(c) Using the formula g = b * ROE, calculate and list the growth rates, plowback ratios, and ROE for the time period between July 2012- June 2022 (For any financial years within your sample with anomalous plowback ratios and/or ROE discuss why this might have occurred). Calculate the arithmetic and geometric average annual growth rate over this period (remove any rates that are negative from your sample). Also calculate the arithmetic and geometric average annual growth rate for the subperiod between July 2012- June 2019 (pre-COVID-19) and compare the values (remove any rates that are negative from your sample). Do you think this method of calculating growth rates is useful for valuation? Explain in detail why or why not. (5 marks)

11. Using the Discounted Cash Flow (DCF) models you have learnt in FINC5001, determine the intrinsic value of your chosen company using the required rate of return from Task 9 and (a) growth rate(s) (from Task 10). Justify the choices and assumptions you have made in undertaking this calculation in detail and why you did not choose any other values instead. Discuss why you chose your valuation model and its key assumptions and why you believe your chosen rates satisfy these assumptions. When do you think the GGM is preferred to a two-stage or multi-stage growth model and why? Explain. (If you make deviations from the choices in Task 9 and/or Task 10, clearly justify why you made these changes and why these new values are more sensible for this analysis). (10 marks)

12. The values that you have utilised in part (11) represent only one possible set of choices for a valuation model. Determine the intrinsic value of your chosen company using a range of values (+1% and -1% for your growth rates and +1% and -1% for your discount rate). You should have a total of 9 intrinsic value calculations like the table below: For example, the top left slot would calculate an intrinsic value using both a growth rate and required rate of return that is 1% higher than your chosen rates in part (11) (for any negative calculations just put N/A). (5 marks)

Recommendation [20 marks]

13. Using the DCF analyses performed in Tasks 1-12, make a detailed recommendation for your chosen company as to whether to buy, sell or hold this stock. Along with your valuation model, you should use any relevant information about your chosen company, competitors, its industry, and the economic outlook to justify your recommendation. Detail the limitations of your analysis and assumptions as well as incorporate the sensitivity analysis done in Task 12 and what this analysis adds to your valuation. A well- justified recommendation properly connects outside information on how it relates to your valuation model via dividends, cash flows, growth rates, discount rates, and other financial factors. Remember, you are trying to present a report that convinces the IMD that you have done a thorough and detailed analysis of your chosen company. The recommendation must be cohesive and consistent with the analyses performed in the sections above.

Presentation and overall style of the report [10 marks]

Marking Criteria

The criteria below will be followed when marking each part of the assignment:

1. The extent and quality of critical reasoning/critical thinking.

2. The demonstration of knowledge of relevant theory.

3. The successful usage and interpretation of relevant data.

4. The extent to which the work is clearly and concisely presented.

Weight of Final Mark: This assignment will be marked out of 100 marks and will be scaled to

account for 20% of course total mark.

Formatting and Presentation:

1. The number of pages allowed ranges from a minimum of 15 to a maximum of 20, with

1.5 line spacing and a font size of 12 Arial or Calibri. It should have normal-sized

(2.54cm) margins on all sides. Please number the pages of your report. Marks will be

reduced by 5 for each page you exceed the lower and the upper page limit. For example,

your mark will be reduced by 10 if the report is of a length of 22 pages or 13 pages. You

will be penalised for inappropriate formatting.

2. Text presented in tables and graphs do not need to follow this formatting requirement.

However, these will still need to be professionally presented in the report.

3. Ensure you use proper academic referencing in supporting the ideas and discussion

within your report. All reports must include a list of references in academic form using

the APA 7th method. Further information on the APA referencing style can be found

here: https://libguides.library.usyd.edu.au/citation/apa7. Failing to reference your

sources may be subject to further actions according to the University of Sydney Code

of Conduct and will be dealt with by the School.

https://www.sydney.edu.au/students/academic-dishonesty.html

4. Pay particular attention to presentation. A component of your mark will be based on

presentation. Avoid overdoing formatting and ensure that the report is very clear,

logical, and professional. Pay attention to grammar. Clear and logical presentation is a

major challenge in report preparation.

5. Preparing a concise report poses a major challenge. Brevity and conciseness are key

ingredients of a highly successful report. Every part of the report should somehow add

to the end result; otherwise, it is superfluous and distracting.

6. Use headings in the report to separate key ideas. Using paragraphs will also assist with

structuring ideas.

7. The report must be submitted as a PDF document. You must submit the report

electronically via the Turnitin link on Canvas. Excel spreadsheets with all your

calculations must be submitted as a .xlsx workbook. You must submit two files

electronically via the link on Canvas.

What is included in the 15-20 page limit?

1. Report body

2. Tables

3. Diagrams

What is excluded from the 15-20 page limit?

1. Title page

2. Table of contents

3. Executive summary

4. Reference list

5. Appendices (For each set of data used in the report, present a screenshot of this data

in the Appendix)

Submission:

1. The only acceptable form of submission is electronic via the submission link in the unit’s

Canvas site. Hardcopy and email submissions will NOT be accepted. Late submissions

will be penalized according to assessment policy. All submission will be checked through

TURNITIN for similarity with external sources.

2. Submission format: Each group can only submit ONE project report. The group leader

(as decided in your group meeting) is required to submit the assignment. (DO NOT

submit if you are not the group leader). It is imperative that your project report is

submitted in ONE document. Only a PDF format document will be accepted, and it is

your responsibility to ensure all pages correctly display your original content. Missing or

distorted figures and formulas will result in lower marks.

3. Cover page: Ensure the Student Identification Number (SID) of EACH student is on the

cover page of your assignment. The name of student must NOT show up on the

assignment to ensure the anonymous marking requirement. The cover page should be

submitted with the assignment in a single file (as the front page).

4. Document name: Your project PDF file must be named in the following format:

FINC5001_Groupnumber_2022.PDF Example: FINC5001_Group23_2022.PDF and your

Excel file must be named in the consistent way such as FINC5001_Group23_2022.xlsx.

Group work ethics:

1. Every group member is expected to be actively engaged in the whole process of group

assignment. Though it is hard to divide the work completely equally, “free-riding”

practice will not be tolerated.

2. From week 7 to week 11, you are expected to meet at least four times to discuss the

assignment tasks and to update your group members on your progress. At your first

group meeting, please decide who will be the group leader. The group leader will be

responsible for coordinating the work of the group and submitting the group report by

the deadline.

3. Each group member will complete the Peer Performance Assessment Form (to be

released on Canvas as a separate assignment approaching the due date) and submit the

form separately online. Due to the limited marking time, we must give all group

members the same mark based on group performance. However, free-riders will be

penalised and the information you provide on the Peer Assessment Form will be used to

determine whether a group member has made a reasonable contribution to the group’s

work.

Data:

1. Yahoo Finance (https://au.finance.yahoo.com/) is a great place to download free data

including price history, price quotes, financials, etc. of companies listed on the major

stock exchanges.

2. The Reserve Bank of Australia (RBA) publishes economic and financial data on its

website. (https://www.rba.gov.au/statistics/)

3. DatAnalysis Premium (Morningstar): Provides fundamental equity data for listed and

delisted companies including revenue and expense breakdowns, financial ratios, growth

rates, balance sheet and cashflow data, director buying and selling announcements,

company appointments and resignations, merger and acquisition activity and annual

reports. All data can be downloaded to Microsoft Excel. Search for the key word

“DatAnalysis premium” on University Library homepage and you will see the link to the

database.

4. ProQuest: A major full-text database covering humanities, social sciences, education,

health and medical, science and technology and business and management. This is a

good database for academic references.

(http://ezproxy.library.usyd.edu.au/login?url=https://search.proquest.com/pqcentral/

advanced ?accountid=14757)

5. Google Scholar: An important searching engine for scholarly publications. Read this

instruction regarding how to link Google Scholar with the Library’s research databases

to find full-text articles. https://usyd.libanswers.com/faq/241096

List of Prohibited Australian-listed Stocks:

1. Australia and New Zealand Banking Group Ltd. (ANZ)

2. Commonwealth Bank of Australia (CBA)

3. Domino’s Pizza Enterprises Ltd (DMP)

4. Telstra Corporation Ltd (TLS)

5. Wesfarmers Ltd (WES)

6. Woolworths Group Ltd (WOW)

担心学业？你还有其他选择！

KJEssay 学年守护计划！

我们是全网首家积极根据新政策优化应对方案的论文服务机构！

全面升级给你最好的防护！

1、远程代劳，资料下载，作业提交，有需要全程代劳！

KJEssay已对目前主流的教学系统Blackboard、ReCap，以及各校的ePortfolio，对全体老师做过专项培训，这方面有困难的学生，可直接授意老师代劳，我们将为你全面服务！

2、考核考试，老师提前充分备考，同程协助，助力满分！

KJEssay 保障学业提供全面服务！专业老师团队先学习了解课程内容，做充足应对，设计方案，

考试时，老师，专业应急团队，客服，同时待命！

老师快速反应，迅速做出最佳答案以及思路！

应急团队集思广益可对重难点迅速突破！

客服居中，全面负责协调沟通，提高效率！

给予及时而效率的全面帮助！

3、远程上课，录屏打卡课程讨论一个不落！

针对目前在线网课，KJEssay做出专项研究，对包括Autodesk、Azure、Skype、Zoom等视频教学软件有着充分熟悉。上网打卡一个不落。

4、保障隐私安全，全程一人全面追踪服务！所有人均签有隐私合同！

全面服务将主要安排在一位老师全面负责，做好对信息情况的充足了解掌握，不假他手！更因为全程彻底的参与，对情况以及考试有更彻底的把握！更能依据情况做出应对！也更易获取更高分！

客服以及第三方，时刻追踪，定期反馈情况。

5、一举一动全面反馈！时刻监控，看得到的全过程！24小时客服待命！

我们一直把沟通反馈，放在重中之重！尤其是代理服务，最了解的肯定还是客户，所以KJEssay会反馈所有的情况，没有客户允许下，不擅专！不乱动！

以最安全的形式，保障拿到最好的成绩！

在上半年的全面代理中,现已取得了优异的成绩与效果。

新学期，我们应对留学网课，更有经验，更加从容！

关于KJEssay

我们是KJEssay，31639人的选择！

现在就可联系我们

微信->添加朋友->添加企业微信联系人：13262280223

官网：https://www.kjessay.com

邮箱：kaijiewrite@163.com  service@kjessay.com

WhatsApp：+44 7410496844（推荐添加）

QQ：1483266981

立即联系我们参与活动吧~