Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Money Markets Handbook A Practitioners Guide

Authors: Moorad Choudhry

1st Edition

0470821507, 978-0470821503

More Books

Students also viewed these Finance questions

Question

The Nature of Nonverbal Communication

Answered: 1 week ago

Question

Functions of Nonverbal Communication

Answered: 1 week ago

Question

Nonverbal Communication Codes

Answered: 1 week ago