Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

Need an valuation of Johnson and Johnson co similar to the example provided in the attachment. I will need this ASAP

image text in transcribed 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

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

Information Technology Auditing

Authors: James A. Hall

4th edition

1133949886, 978-1305445154, 1305445155, 978-1133949886

More Books

Students also viewed these Accounting questions