Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need help filling out the yellow lines with some assumptions. 2 4 6 7 8 9 10 11 12 13 14 15 16 17 18

Need help filling out the yellow lines with some assumptions.

image text in transcribed

2 4 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 Revenue (Sales) growth rate COGS/Revenue SG&A expense/Revenue Interest Expense Goodwill & Indefinite Lived Intangible Asset Impairment Charges (income statement) (We assume it is O for the forecast period since 2019 is one-time activity) Tax rate (Income Taxes on Continuing Operations/Earnings from Continuing Operations before Income Taxes) Investment Income, Interest Other Nonoperating Income (Expense) Net Earnings/(Loss) from Discontinued Operations Dividend paid Net Earnings Attributable to Noncontrolling Interest WACC 6.5% c D Template for Valuation of P&G (fill in all the cells highlighted in YELLOW) Assumptions Cash/Revenue Accounts Receivable/Revenue Inventory/Revenue Prepaid Expense and Other Assets, Current Goodwill Intangible Assets, Net (Excluding Goodwill) Other Assets, Noncurrent NPPE/Revenue Accounts Payable/Revenue Accrued Liability, Current/Revenue Debt, Current/Revenue Deferred Income Tax Liabilities, Net Other Liabilities, Noncurrent Additional Paid in Capital Reserve For ESOP Debt Retirement Accumulated Other Comprehensive Income (Loss), Net of Tax Treasury Stock, Value Stockholders' Equity Attributable to Noncontrolling Interest Preferred Stock, Stated Value, Issued Depreciation/Fixed Assets (at t-1)

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_2

Step: 3

blur-text-image_3

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

Renewable Energy Finance Funding The Future Of Energy

Authors: Charles W Donovan

2nd Edition

1786348594, 9781786348593

More Books

Students also viewed these Finance questions