Data Analysis Databases

MODELLING TECHNIQUES FOR FINANCE DUE DATE: 15 APRIL 2021 COMPANY NAME: SONIC HEALTHCARE LTD (SHL)Question 1 Find at least 5 years of financial information for your task firm (Sonic Healthcare Ltd) and download all the data you need for an equity valuation from Data Analysis databases. 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 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)Write up a 3500 word count report based on your findings. Note that all questions must be calculated using excel and the excel spreed sheet should be submitted as part of the Assignment.( all calculations should be made in the excel spread sheet and named accordingly eg sheet 1 for question 1) and also the report should be paragraphed accordingly with the respective question numbers.) Referencing You must correctly use the Harvard style of referencing in this assessment.For more information on Data Analysis Databases read this:https://en.wikipedia.org/wiki/Data_analysis      

Don't use plagiarized sources. Get Your Custom Essay on
Data Analysis Databases
Just from $13/Page
Order Essay
Acme Writers
Calculate your paper price
Pages (550 words)
Approximate price: -

Why Work with Us

Top Quality and Well-Researched Papers

We always make sure that writers follow all your instructions precisely. You can choose your academic level: high school, college/university or professional, and we will assign a writer who has a respective degree.

Professional and Experienced Academic Writers

We have a team of professional writers with experience in academic and business writing. Many are native speakers and able to perform any task for which you need help.

Free Unlimited Revisions

If you think we missed something, send your order for a free revision. You have 10 days to submit the order for review after you have received the final document. You can do this yourself after logging into your personal account or by contacting our support.

Prompt Delivery and 100% Money-Back-Guarantee

All papers are always delivered on time. In case we need more time to master your paper, we may contact you regarding the deadline extension. In case you cannot provide us with more time, a 100% refund is guaranteed.

Original & Confidential

We use several writing tools checks to ensure that all documents you receive are free from plagiarism. Our editors carefully review all quotations in the text. We also promise maximum confidentiality in all of our services.

24/7 Customer Support

Our support agents are available 24 hours a day 7 days a week and committed to providing you with the best customer experience. Get in touch whenever you need any assistance.

Try it now!

Calculate the price of your order

Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

No need to work on your paper at night. Sleep tight, we will cover your back. We offer all kinds of writing services.

Essays

Essay Writing Service

No matter what kind of academic paper you need and how urgent you need it, you are welcome to choose your academic level and the type of your paper at an affordable price. We take care of all your paper needs and give a 24/7 customer care support system.

Admissions

Admission Essays & Business Writing Help

An admission essay is an essay or other written statement by a candidate, often a potential student enrolling in a college, university, or graduate school. You can be rest assurred that through our service we will write the best admission essay for you.

Reviews

Editing Support

Our academic writers and editors make the necessary changes to your paper so that it is polished. We also format your document by correctly quoting the sources and creating reference lists in the formats APA, Harvard, MLA, Chicago / Turabian.

Reviews

Revision Support

If you think your paper could be improved, you can request a review. In this case, your paper will be checked by the writer or assigned to an editor. You can use this option as many times as you see fit. This is free because we want you to be completely satisfied with the service offered.