Briefly describe how Medicare pays for the following: a. Inpatient services b. Physician services

Based on the same company chosen in the group report, perform financial analysis and prospective analysis as if you were a business analyst. Specifically, reformat the companys financial statements for the past five years; analyse key ratios and cash flows to evaluate current and past performance of the company; forecast future financial performance of the company for the next five years and beyond; apply valuation models to estimate the companys intrinsic value; perform sensitivity analysis on key forecasting assumptions, and discuss potential opportunities and challenges for the company

View complete question Based on the same company chosen in the group report, perform financial analysis and prospective analysis as if you were a business analyst. Specifically, reformat the companys financial statements for the past five years; analyse key ratios and cash flows to evaluate current and past performance of the company; forecast future financial performance of the company for the next five years and beyond; apply valuation models to estimate the companys intrinsic value; perform sensitivity analysis on key forecasting assumptions, and discuss potential opportunities and challenges for the company to improve value. Detailed requirements are as follows: Reformatting (4 marks): Prepare detailed past five years reformatted financial statements in an excel spreadsheet and provide as an appendix in the report. Ratio and cash flow analysis (8 marks): Perform DuPont analysis. Calculate and discuss key ratios such as ROE, RNOA, PM, ATO, FLEV and NBC. Break down and analyse PM and ATO ratios in further details. Identify and discuss significant expense items that have caused major changes in profit margin. Identify and discuss major assets or liabilities whose turnover ratios have contributed to the overall change in assets efficiency. Briefly describe the ratios trend. The analysis should elaborate on the economic, industry and business factors that drive the changes in ratios. The discussion should consistently reflect the same firm fundamentals identified in the group report. Calculate other relevant liquidity, solvency and cash flow ratios that are not covered in DuPont analysis. Analyse financial risk and cash flow management of the company based on these ratios. Forecasting (8 marks): Prepare your forecasts in an excel spreadsheet following a 10-step forecasting template. The forecasting table should include your specific forecasts for the next five years as well as the long-term forecast beyond the five-year forecast horizon. The forecasting table should be included as an appendix in the report. 20/07/2020 Explain the reasons for your initial forecast assumptions, i.e. assumptions for sales growth, ATO, PM, net dividend payout ratio, cost of debt and cost of equity. Valuation (4 marks): Apply four valuation models, i.e. dividend discount model, residual income model, residual operating income model and free cash flow model, to estimate the intrinsic value of the company. Provide calculations and results of four valuation models in a table and include it as an appendix in the report. Compare and discuss the estimates obtained from the four models. Compare the estimates with the actual share price observed in the stock market when valuation is performed and conclude whether the firm is currently overvalued or undervalued. Sensitivity Analysis (4 marks): Adjust your initial forecast assumptions to reflect your optimistic and pessimistic forecasts for sales growth, ATO, PM, net dividend payout ratio, cost of debt and cost of equity. Recalculate the estimated share value from residual operating income model only. Provide the sensitivity analysis results in a table. Explain how optimistic and pessimistic forecasts for the various assumptions are chosen. Identify and discuss the key assumptions that valuation is most sensitive to. Based on sensitivity analysis and the key factors that have significant impact on valuation, discuss potential opportunities and challenges for the company to maintain or improve value. Overall Report Quality (2 marks): The report should be readily comprehensible, condensed and within the word limit. Information should be collected from various reliable sources to inform analysis and references are properly cited. Tables and graphs should be used to effectively present information.

View less

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more