Group Project FNBSLW 735 As the final project for our course, you are expected to evaluate P&G’s performance and determine the value of the company. Please go to SEC website and download most recent...

1 answer below »
https://idp.uww.edu/idp/profile/SAML2/Redirect/SSO?execution=e1s1
Painterc16password Sarahismylove1!
So I attached a screenshot. In that screenshot it shows everybody's part broken down into 7 sections. I am supposed to do parts 2 and 3. I attached everything here that he is talking about also in that screenshot.


Group Project FNBSLW 735 As the final project for our course, you are expected to evaluate P&G’s performance and determine the value of the company. Please go to SEC website and download most recent financial statements as the “template” and build your valuation analysis based on the template. You may search and use more relevant information of the company in addition to the financial statement data on SEC’s website. You are expected to apply what you’ve 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. You are required to write a formal report of your valuation analysis. The report should not exceed ten pages, double spaced, with font size 12 (excluding tables and figures). You may include tables and figures in the text or as an appendix. The quality of writing is paramount. Please make sure the paper reads cohesively and follows a consistent format. 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 and identify trends. 3. Economy, Industry, and Firm Analysis: discuss the outlook for the economy, industry, and the company. How will the economy affect your company? 4. Pro Forma Analysis (assumption development for the list of inputs, pro forma analysis, etc.): develop assumptions and carry out pro forma for the next five years. 5. Firm valuation: apply various methods discussed in the class to determine the value of the firm. 6. Risk Analysis (scenario and sensitivity analyses): use break-even sensitivety analysis to identify top 5 value drivers from the list of inputs, and develop best, worst, and expected scenarios (based on the top 5 value drivers) and analyze how firm value is impacted by the drivers and different scenarios. 7. Conclusion: provide your recommandtion for the final valuation of the firm. Each group should submit only one copy of the finished written report and the supporting excel file. Please make sure to review my instruction video under this module for additional directions. Have fun! PowerPoint Presentation Slide Number 1 Guideline for risk analysis 1. You may use the risk analysis model in module 3 (Better Buy) as the guide. Make sure to cover break even analysis, table tables, and scenario analysis. You are encouraged to conduct a Monte Carlo simulation although it is not required. 2. Identify top three value drivers. Since we don’t have initial investment in our analysis, you may use $260 billion (roughly 80% of enterprise value on Oct/2020) as initial investment to get the critical value (refer to table 3-2 on page 61) 3. You may use the three value drivers to define scenarios for your scenario analysis.
Answered 6 days AfterMay 03, 2021

Answer To: Group Project FNBSLW 735 As the final project for our course, you are expected to evaluate P&G’s...

Himanshu answered on May 10 2021
127 Votes
2.
Financial Analysis
Financial analysis is the method of assessing the success and suitability of companies, programmes, budgets, and other financial transactions. Financial analysis is commonly used to determine whether an enterprise is stable, viable, liquid, or productive enough to justify monetary investment (P&G)
The Procter & Gamble Company (PG)
    Share price
    $135.15
    Market Capitalization
    330 Billion
    EPS

    5.44
    Price to Earnings Ratio
    24.85
Share Performance (Trend)
Liquidity ratio
    Years
    2020
    2019
    2018
    2017
    2016
    Current Ratio
    0.84
    0.74
    0.82
    0.87
    1.09
    Quick Ratio
    0.61
    0.50
    0.58
    0.64
    0.57
    Cash Ratio
    0.48
    0.33
    0.41
    0.49
    0.42
A liquidity ratio tests the willingness of a business to pay its short-term debt obligations. Three major liquidity ratios are the current ratio, a quick ratio and a money ratio. Until deciding a firm, investors and borrowers would like to see a liquidity level of 1.0. As illustrated above, the level of liquidity of companies is in fact below 1, which in the near future implies a certain caution.
Solvency Ratio
    Years
    2020
    2019
    2018
    2017
    2016
    Debt to Equity
    0.75
    0.64
    0.60
    0.57
    0.53
    Debt to Capital
    0.43
    0.39
    0.37
    0.36
    0.35
    Debt to Assets
    0.29
    0.26
    0.26
    0.26
    0.24
    Financial Leverage
    2.59
    2.44
    2.26
    2.18
    2.22
To measure a firm's readiness to render its long-term commitments, the debts ratios are implemented. An investor can understand the potential of an enterprise by reading a solvency rate to meet its debt commitments.
Profitability Ratio
    Years
    2020
    2019
    2018
    2017
    2016
    Gross Profit
    50.32%
    48.63%
    48.73%
    49.99%
    49.60%
    Operating Margin
    22.14%
    8.11%
    20.52%
    21.45%
    20.58%
    Net Profit
    18.36%
    5.76%
    14.59%
    23.56%
    16.09%
In addition to its sales and other expenses associated with income generation in the period set, the profitability ratio is used to measure the company's capacity to gain profit. This ratio shows the real result of the company. The profits of the business are consistent according to the survey, which is a positive indicator (Yahoo Finance)
3.
Economic Analysis
The Procter & Gamble Company has evolved to become one of the world's largest consumer goods industries. Procter & Gamble's performance on the market of consumer products is closely linked to the markets where it operates. The effect of economic trends and challenges on the restricted or the macro-environment is determined by this aspect of the economic assessment process. In the case of Procter & Gamble, the following economic external considerations stand out:
· The emerging economies are expanding at a rapid pace (opportunity)
· Increasing discretionary income (opportunity)
· The bulk of emerging markets' economies are stable (opportunity)
The opportunity associated with emerging markets' rapid growth rate supports Procter & Gamble's future growth. Additionally, the firm has the potential to expand as disposable income levels rise. This economic external influence leads to consumers' increased buying power for manufactured products from companies such as Procter & Gamble. Furthermore, the bulk of emerging markets' resilience leads to the significant stability of P&G's remote or macro-environment. According to this part of the economic analysis, the Procter & Gamble Company has growth opportunities.
Industry Analysis
Analysis of the Industry Procter & Gamble Company is the world's leading consumer packaged products (CPG) company in the personal product market. The CPG market is very competitive. P&G's main rivals, such as Kimberly-Clark Corp., Colgate-Palmolive Co., Johnson and Johnson, Avon Consumer Co., and Unilever, are similarly diversified across several sub-sectors. Companies that operate in several industries must focus on brand equity and product creativity to capture market share (Owler)
Model of Five Forces The five forces model is used in every sector to determine the policy, viability, and strength of that industry. The five forces model identifies the valuable parts of the CPG industry by using factors such as competition among incumbent companies, threat of new entrants, threat of replacement goods, customer...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here