Hello, if you have any need, please feel free to consult us, this is my wechat: wx91due
ACCT6003 Fundamental Analysis for Equity Investment
Final Take-Home Project
The Final Take-Home Project is worth 40 marks.
The final take-home project instructions have been released on the 11th of September 2023, thus giving you ample time (9.5 weeks) to work on the final assessment.
Deadline
The deadline for submissions is 11:59pm, Friday 17 November 2023. Every day that passes from the due date will attract a penalty as per standard University policy, as follows:
• Deduction of 5% of the maximum mark for failing to submit by 11:59pm every day that passes after the due date. This is equivalent to a penalty of 2 marks per day.
• After ten calendar days late, a mark of zero will be awarded.
Project overview
You have been randomly assigned a company that is currently listed on the ASX, and you are asked to act as a sell-side analyst who applies fundamental analysis for equity investment to estimate the intrinsic value of this company.
You are required to make an investment recommendation on whether to buy or not to buy the stock of your assigned company.
Your investment recommendation must also include a discussion on the investment horizon, for how long one should buy-and-hold before the price is corrected upwards, or how even long one could short-sell this stock before the price starts falling.
You are required to go through everything that you have learned in ACCT6003 to identify the most appropriate types of analyses and approaches that would help you appraise the value of the company that you have been assigned. Different companies may require different types of analyses and approaches and would certainly require different inputs.
Assigned company
The list of assigned companies is provided on Canvas in the page ‘Final take-home project’ and in the file acct6003_company_list.csv. Each company is assigned using an SID number. Search by SID number to find out your assigned company. All companies have been randomly assigned.
The companies have been selected based on the following criteria:
• It is a publicly traded company that is currently listed on the Australian Stock Exchange.
• It is not on the ASX100 index (see www.asx100.com), as determined as at 10 Sep 2023.
• It is not a company that is discussed in case studies or lecture slides (i.e. not Vista Group, Fortescue Metals, Qantas, Woolworths, Humm Group).
• It is not a financial company (e.g. bank, credit institution, insurance).
• It is not a stapled security, a trust, a managed fund or investment group.
• It is not a holdings company (i.e. holding stock from many other companies).
• It is not an estate management company.
• It is not a regulated utility company (e.g. energy supplier, water company, public transport).
• It is not an energy, oil or gas exploration and extraction company.
• It is not a mining company.
• It did not have suspended trading at the time of selection.
• The company was listed on the ASX before 1 January 2019.
• Its market capitalisation as at 10 September 2023 was greater than AU$50 million.
• Its stock has been actively traded for the last year.
By applying the above filters, this leaves only medium-sized companies that are not too complex and have straightforward industrial operations. In case we missed something, you are required to check that your company satisfies the above criteria and let us know if you suspect a violation.
Mergers
An additional condition that is difficult to identify without close examination of the ASX announcements is that the assigned company should not have merged with another company during the last 2 years, because then its operational profile could have changed dramatically. Note that it is not a problem if your company has acquired smaller companies.
You are required to closely examine the company that you have been assigned to learn whether there have been any significant mergers in the last two years. If there is a merger, then please get in touch with the Unit coordinator to discuss the issue and the potential allocation of another company.
The only way to find out conclusively this information is to search the ASX announcements of this company for the last two years. Go to https://www2.asx.com.au/ and search for your company’s ticker, and then click on “See all announcements” .
Takeover target
In addition, you should also find out that your company is a current takeover target from another larger company. This information would also be posted on the ASX noticeboard. If you find that your company is going through a process of selling the shares to another larger company, then again get in touch with the Unit coordinator to discuss the issue and the potential allocation of another company.
DO NOT get in touch if your company has acquired other smaller companies, this is not a problem at all. Most companies have acquisitions, and these are a normal part of a operational growth strategy. In fact, you should treat acquisitions as an important source of information for understanding prospective growth in earnings.
Financial year-end
The 2023 annual reports should already be available for most companies because most have a 30th of June financial year end. If the 2023 annual report is not available for your company, then this might be because the company has a late financial year end date. You are required to go to the company’s most recent annual report and find out the financial year-end. If the financial-year end is other than the 30th of June then please get in touch with the Unit Coordinator.
Excel template
On Canvas, you will also be provided with an Excel valuation spreadsheet guideline to help you develop the valuation analysis using the Residual Operating Income (ReOI) model. Do not attempt any cash-based valuation or the generic RIV valuation. Apply only the ReOI model. We will discuss the ReOI model from week 9 onward.
Note that the Excel template is just a guideline on how to approach the valuation exercise. It lists the necessary types of analysis that must be completed as you prepare for the ReOI valuation. Fell free to change the Excel template to suit your analysis.
Note that you can form expectations using information from any relevant source. The information may be drawn from past annual reports, the annual reports of competitors, company announcements, related financial news posted on ASX or other financial news outlets, historical data analysis on past financial statements using data from databases, macroeconomic information related to the company’s business environment and industry, socioeconomic information, demographics, natural events and more. See the relevant Canvas announcement on which are considered as credible sources of information. Make sure to reference all sources used.
You can choose any finite forecast horizon and any terminal year as you see appropriate, but you are required to justify your choice using evidence.
You are required to use the Weighted Average Cost of Capital (WACC) as the discount rate for the ReOI valuation. The cost of equity component should be calculated using the Capital Asset Pricing Model (CAPM). If the CAPM does not yield a reasonable estimate, then you must explain why this is so and apply an alternative qualitative estimate as you judge to be right. As for the cost of debt, you can use any reasonable approach as discussed in the lectures and the workshops.
Assessment criteria
There is not one correct answer, and you are not assessed on the accuracy of the valuation. No one knows what the correct valuation of a company is. All valuations are intrinsic opinions. You will be assessed on your ability to:
(i) Apply residual operating income valuation.
(ii) Identify and justify key factors that drive equity value within the context of the company that you have been assigned.
(iii)Analyse informative quantitative and qualitative data, including financials, news, industry and economy data, historical financial data, annual report information, macroeconomic data and any other useful information.
(iv) Provide evidence-based convincing argumentation for justifying the forecasts, the WACC calculations, and the valuation model.
(v) Explain the limitations of your analysis and the sensitivity of key assumptions.
(vi) Produce an investment recommendation with a recommended investment horizon.
(vii) Present a quality professional report with supporting documentation (e.g. tables, graphs, references).
General advice
Do not fiddle around with the data. To run a valuation analysis, first perform fundamental analysis and business analysis, then forecast and then decide on model parameters. Adjust the valuation only if you have made a computational error or have discovered new information, but not because it did not give you the answer that you thought it would.
Use the word limit wisely. Report only what is absolutely useful and is important for documenting and explaining the analysis. Any general introductions, generic definitions or superfluous explanations about theoretical concepts will attract negative marking. We know the theory already. Go straight to the analysis. Assume that the reader is an expert financial manager who wants to read a concise evidence-backed valuation analysis so that s/he can decide whether to buy or sell.
Submission
Your submission should take the form of a concisely presented professionally report of maximum 3,000 words. The word count excludes the reference list and any appendices.
You are required to submit both the Word file and the Excel valuation file in TurnitIn on Canvas. The Excel file should contain all calculations used in the valuation report. You may want to create multiple worktabs to hold different calculations.
You should not identify your names on the Word report or the Excel file. Marking will be anonymous. You should only identify yourself through the selected company and your SID. Name the files acct6003_final_project_SID.docx and acct6003_final_project_SID.xlsx, by substituting SID with your personal student identifier.
Queries
Any queries about the final take-home project must be posted on Canvas so that all students will benefit equally from the answers.
Report structure and marking criteria
The report should start by offering a very brief executive summary of only a couple of sentences. The Executive summary should identify the company, the valuation date, the traded price on that date, the intrinsic price that was calculated, the investment recommendation and the investment horizon. Then, the report must contain seven sections enumerated using the exact headings as described below.
Here is an example of a report structure. Under each section, we also describe what is expected to be developed as part of the valuation report and how marks will be allocated.
Example Valuation report for ABC Ltd
Executive summary
As at 9th of June 2023, ABC Ltd traded at $4.47 p/share on the ASX. This valuation report estimates an intrinsic equity value of $7.23 p/share and recommends to BUY the share of ABC. The price is estimated to continue rising during the next 36 months.
Section 1. Business Fundamentals
In this section, you are required to demonstrate solid understanding of business fundamentals, the industry, and the relevant operational environment of the company. You are required to identify the business model, business strategy, competitors, and key competitive threats. You must identify and discuss how the company captures economic value and the key drivers of the company’s current position and performance using judgment, evidence, and data analysis. The lessons learned from the lecture of Week 1 and the Week 2 Assignment can help you complete this task. [9 marks]
Section 2. Accounting analysis and earnings quality
You are required to discuss the analysis of earnings quality, the identification of key reporting targets for this company, and any suspicious events or red flags from financials that may be alarming. You are encouraged to apply accounting adjustments where necessary. You must demonstrate an in-depth understanding of the key accounting policies for this company, the accounting flexibility and compare accounting judgment across direct competitors. The lessons learned from the lecture of Week 2, the Week 3 Assignment, and the Week 4 Assignment can help you complete this task. [6 marks]
Section 3. Reformulation of statements
You are required reformulate the income statements and balance sheet statements informing financial ratio analysis, for at least 5 years if statements are available. You must provide an appropriate and clear presentation in the Excel file to enable the examination of the reformulation, including notes for documenting the sources of information and any assumptions made. In the Word file, you are required to discuss the most important signals obtained that are a direct result of the reformulation of the statements. The lessons learned from the Week 7 lecture, the Week 8 lecture, and the Week 9 Assignment can help you complete this task [3 marks]
Section 4. Financial analysis
You are required to present convincing evidence-based arguments using data and theory and involving detailed application of financial ratio analysis in order to inform prospective analysis of performance, liquidity, solvency, efficiency, and all inputs relevant to equity valuation. Your focus must be provided convincing arguments that justify your prospective analysis. The lessons learned from the Week 9 lecture, the Week 10 lecture, the Week 10 Assignment and the Week 11 Assignment can help you complete this task. [9 marks]
Section 5. Credit analysis
You are required to analyse the credit risk, creditworthiness, liquidity and insolvency of our company. You must provide a focused appraisal from a credit analyst perspective discussing capital structure, leverage strategy, cost of debt, cash management, and anything else that would interest a credit analyst. The lessons learned from the Week 11 lecture and the Week 12 Assignment can help you complete this task. [4 marks]
Section 6. Cost of capital
You are required to estimate the cost of equity using CAPM, the cost of debt, and the cost of operations using the WACC. You must estimate CAPM using raw market data and the cost of debt using available information. All calculations must be reported in the Excel file In the Word report, you are required to briefly discuss the underlying uncertainty and appropriateness of your calculated cost of capital. The lessons learned from the Week 5 Assignment and the Week 6 Assignment can help you complete this task.c [4 marks]
Section 7. Limitations and sensitivity analysis
You are required to provide a critical discussion of the key limitations of your analysis and assumptions (not of the theory or the model). You are required to carry reasonable sensitivity analysis of the limitations and stress-testing the key assumptions that drive valuation. The sensitivity analysis should stress-test those assumptions that are most uncertain. The lessons learned from the Week 4 lecture, the Week 5 Assignment and the Week 6 Assignment can help you complete this task. [3 marks]
Reference list
Here type-in the reference list.
Appendix
In the appendix you can include lengthy tables or figures that are only supportive to the discussion presented in the main text. However, make sure that if you include an appendix then you will refer to the appendix material in the main text and explain why this appendix is important. If you include an appendix and do not explain its significance in supporting your arguments then we will simply ignore it.
The remaining [2 marks] are allocated to the presentation of a quality professional report, including the effective use of tables and graphs, quality references and properly cited sources, easy-to-read report, and professional use of language with non-superfluous or speculative arguments lacking evidence. You are encouraged to use small tables and graphs to support your analysis in the valuation report.