Question
As the final project for our course, you are expected to evaluate P&Gs performance and determine a valuation for the company. P&Gs annual report (filed
As the final project for our course, you are expected to evaluate P&Gs performance and determine a valuation for the company. P&Gs annual report (filed August 2019) can be downloaded from the SEC website. Please build your financial analysis based on the template we used for Assignment 1. The report should not exceed 10 pages, double spaced, with font size 12 (excluding tables and figures). You may include tables and figures in the text or as appendix. The quality of writing is very important. Please make sure the paper reads cohesively and follow consistent format. Misspelling will result in point reductions. You may research on the company in addition to the financial statement data on SECs website. You are expected to apply what youve learned in this course to the best of your ability. Essential components include pro forma analysis (cash flow estimations), risk analysis, discounted cash flow and relative valuation methods, etc. Please refer to the suggested content listed below. You may modify the structure of your paper as long as essential components are included.1.Introduction: start with a brief firm introduction and address major strengths and challenges facing the company. 2.Recent Financial Performance: conduct ratio analyses (including common size financial statement analysis) and identify trends. 3.Economy, Industry, and Firm Analysis: discuss outlook for the economy, industry, and the company. How will the economy affect your company?4.Forecast Firm Value (assumption development, pro forma analysis, discounted cash flow analysis): develop assumptions based on your analysis in previous sections and carry out pro forma for the next five years. You need to determine a terminal value to incorporate the value of the company comes from future cash flows (from year 6 to infinity). The terminal value can be determined by market comparables, such as EBITDA multiple. Apply discounted cash flow approach to determine the firm value (NPV).5.Risk Analysis (scenario and sensitivity analyses): develop possible scenarios and see how the firm value might be affected; conduct sensitivity analysis to find breakeven points for key value drivers. 6.Conclusion: provide a range for the firm value. Each group should submit only one copy of the finished written report and the supporting excel file.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started