Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Need an valuation of Johnson and Johnson co similar to the example provided in the attachment. I will need this ASAP Page 1 INPUTS FOR
Need an valuation of Johnson and Johnson co similar to the example provided in the attachment. I will need this ASAP
Page 1 INPUTS FOR VALUATION Current Inputs Enter the current revenues of the firm = Enter current capital invested in the firm = Enter the current depreciation = Enter the current capital expenditures for the firm = Enter the change in Working Capital in last year = Enter beginning shareholder's equity Enter the value of current debt outstanding = Enter the number of shares outstanding = $ 12,406 $ 10,000 (Book Value of Equity + Book Value of Debt) $ 233 $ 298 (you might try an average of the prior 3 years) $ 115 (current assets current liabilities for the most recent year) (current assets current liabilities for the prior year) $ 20,000 $ 10,000 1,500.00 High Growth Period Your Inputs Enter the growth rate in revenues for the next 5 years = 25.00% What will all operating expenses be as a % of revenues in the fifth year? 70.00% (Operating expenses include depreciation: This is equal to (1Pretax Operating Margin)) How much debt do you plan to use in financing investments? Enter the growth rate in capital expenditures & depreciation Enter working capital as a percent of revenues Enter the tax rate that you have on corporate income What beta do you want to use to calculate cost of equity = 50% (you might try an average of the prior 3 years) 25.00% (you might try an average of the prior 3 years) 7.50% (current assets current liabilities) / Revenues 36.00% (you might try an average of the prior 3 years) 1.25 Enter the current long term bond rate = 6.50%
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