Answered step by step
Verified Expert Solution
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.
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
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