Submission An electronic copy of the assignment (one copy per student including one Word and one Excel file) has to be uploaded to Assignment folders at the online unit site. Please only upload one Word file with all eight questions and one Excel file with all supporting data and analysis. Please provide all explanations or answers to the questions in the Word file. Use Getformula or FormulaText in the Excel file to indicate all the formulas you have used in completing this assignment. Referencing You must correctly use the Harvard style of referencing in this assessment. Please read the following instructions carefully. The following table lists 10 of the top50 publicly-traded firms in Australia. Please choose one firm from the list and answer the following 8 questions. Sonic Healthcare Ltd – SHL Question 1 Find at least 5 years of financial information for your task firm and download all the data you need for an equity valuation from DatAnalysis databases available at Library. All the other information or data should be downloaded from reliable data sources. For example, you need financial data, stock prices, firms’ annual reports, risk free rate of returns, and stock market risk premium, etc. You need clearly explain your data sources, timeline of the data, and data items used in your calculations. You are required to submit your data in Excel format as part of your project. (4 marks) Choose an appropriate Discounted Cash Flow model and explain why you choose this specific valuation model for the firm in your report. (1 mark) Question 2 Estimate the discount rate or rates to use in the valuation. Your estimation Excel files should be submitted as part of your project. (3 marks) In the report you need to briefly explain how you calculate the discount rate(s) including the model you used for the calculations. (2 marks) Discount rate is Weighted Average Cost of Capital. This section should also include information about how you estimate your betas, risk free rates, expected returns on the market index, and debt-equity ratio. Question 3 Define the value driver of your valuation. Calculate the converting ratios of financial variables to the value driver. (3 marks) You also need to analyze your firm and decide an appropriate fixed-asset model and the PLUG for your modelling template. Explain the reasons for your choices. (2 marks) Question 4 Build your pro forma model and forecast your future financial ratios and free cash flows. (3 marks) You need to explain how you decide your short-term growth rate, the length of forecast period, and the stable growth period. (2 marks) Compute the current cash flows from financial statements. Estimate the future earnings and cash flows on the firm being valued. Estimate when the firm will reach “stable growth” and what characteristics (risk & cash flow) it will have when it does. Question 5 Estimate the fundamental value of the firm’s equity. (2 marks) Explain why your estimated share value might differ from the trading price observed in the stock exchange. Please discuss whether there are possible ways to improve the precision of your estimation. Use a Data Table to conduct a sensitivity analysis along two dimensions, growth rate and discount rate and discuss the findings of your sensitivity analysis. (3 marks) Question 6 Use Search Tool at DatAnalysis to construct a sample of firms (at least 10 firms) within the same Global Industry Classification Standard (GICS) Industry as your task firm. If the GICS Industry has limited number of firms, you can either use GICS Industry Group or GICS Sector to enlarge your selection sample. (5 marks) Question 7 Construct a table with Price to Book (PB) ratios and all the fundamental variables that define the PB ratios for all these firms in the GICS group, including your task firm. (5 marks) Question 8 Compare the PB ratio of your task firm with those comparable firms in the same industry. Is your firm over-valued or under-valued and why? You need to use all the financial information collected to justify your arguments. (5 marks)
- Use the internet to investigate Russian and American cooperative involvement with the International Space Station. What have both countries contr
- Name and describe at least two non-traditional healing systems Discuss the interface between religion and mental health Religion, Healing and
- Watch and annotate the videos of one peer as assigned by your instructor on InTASC Standards 1, 2, and 3 of the Clinical Practice Rubric. * Use t
- Discuss some of the elements in women?s approach to power, negotiation, and risk-taking that may lead to them earning less than men in similar jo
- Explain how your organizational design and culture could be implemented at your workplace or organization. Explain how your design will improve
- You need to develop a specific activity that is for the vignette that you chose. You also have to list all the rules, all the consequences, and all the materia
- The student will provide a description of the administration, logistics, and planning for a sport ministry project of the student?s choice. The portfolio must
- For this assignment, you have just been hired as the new Head Coach (of your particular sport) at Amos University! First…Your Bad News You have inherited a t
- The CEO of your organization wants to improve employee morale. Recently, she went to a conference at which she heard people talking about ?open-book management
- Maya has just been hired as the chief executive officer (CEO) to turn around Phoenix Solutions, a once-thriving tech company now struggling with declining reve