USING JOHNSON AND JOHNSON AS THE COMPANY..... Create the sales growth forecast based on the past 5-10 years, which should use multiple methods, such as arithmetic, geometric, regression methods. Excel forms should be used so that it's clear for everyone to see the work." Johnson & Johnson Annual Revenue(Millions of US $) 2023 $85,159 2022 $79,990 2021 $78,740 2020 $82,584 2019 $82,059 2018 $81,581 2017 $76,450 2016 $71,890 2015 $70,074 2014 $74,331 2013 $71,312 2012 $67,224

USING JOHNSON AND JOHNSON AS THE COMPANY..... Create the sales growth forecast based on the past 5-10 years, which should use multiple methods, such as arithmetic, geometric, regression methods. Excel forms should be used so that it's clear for everyone to see the work." Johnson & Johnson Annual Revenue(Millions of US $) 2023 $85,159 2022 $79,990 2021 $78,740 2020 $82,584 2019 $82,059 2018 $81,581 2017 $76,450 2016 $71,890 2015 $70,074 2014 $74,331 2013 $71,312 2012 $67,224

Financial Reporting, Financial Statement Analysis and Valuation

8th Edition

ISBN:9781285190907

Author:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw

Publisher:James M. Wahlen, Stephen P. Baginski, Mark Bradshaw

Chapter10: Forecasting Financial Statement

Section: Chapter Questions

Problem 3QE

See similar textbooks

Johnson & Johnson Annual Revenue (Millions of US $)
2023	$85,159
2022	$79,990
2021	$78,740
2020	$82,584
2019	$82,059
2018	$81,581
2017	$76,450
2016	$71,890
2015	$70,074
2014	$74,331
2013	$71,312
2012	$67,224

Similar questions

ClapTrap is a rapidly growing image messaging company. The company's growth strategy requires rapid reinvestment currently, with dividend payouts increasing as growth opportunities gradually disappear. You have the following financial information about ClapTrap: Earnings in the most recently concluded fiscal year were $$6.286.28. The company will retain all its earnings this year (from t=00 to t=11 ), reinvesting in new projects with a return on new investment of 44.044.0%. The next year (from t=11 to t=22 ), the company will retain 85.085.0% of its earnings. Return on new investment is expected to be 30.030.0%. In the following year (from t=22 to t=33 ), the company will retain 69.069.0% of its earnings with an expected return on new investment of 20.020.0%. The company will then enter a period of stable growth, retaining 49.049.0% of its earnings in perpetuity. a) What are the expected dividends per share for each period from t=11 to t=33 ? The expected dividends per share for…
Ricardo Entertainment recently reported the following income statement:Sales 12,000,000Cost of goods sold 7,500,000EBIT 4,500,000Interest 1,500,000EBT 3,000,000Taxes (40%) 1,200,000Net income 1,800,000The company’s CFO, Fred Mertz, wants to see a 25 percent increase in net income over the next year.In other words, his target for next year’s net income is $2,250,000. Mertz has made the followingobservations: Ricardo’s operating margin (EBIT/Sales) was 37.5 percent this past year. Mertz expects thatnext year this margin will increase to 40 percent. Ricardo’s interest expense is expected to remain constant. Ricardo’s tax rate is expected to remain at 40 percent.On the basis of these numbers, what is the percentage increase in sales that Ricardo needs in order tomeet Mertz’s target for net income?
Consider the following scenario: Green Caterpillar Garden Supplies Inc.’s income statement reports data for its first year of operation. The firm’s CEO would like sales to increase by 25% next year. 1. Green Caterpillar is able to achieve this level of increased sales, but its interest costs increase from 10% to 15% of earnings before interest and taxes (EBIT). 2. The company’s operating costs (excluding depreciation and amortization) remain at 60% of net sales, and its depreciation and amortization expenses remain constant from year to year. 3. The company’s tax rate remains constant at 25% of its pre-tax income or earnings before taxes (EBT). 4. In Year 2, Green Caterpillar expects to pay $100,000 and $1,759,500 of preferred and common stock dividends, respectively. A. Complete the Year 2 income statement data for Green Caterpillar, then answer the questions that follow. Be sure to round each dollar value to the nearest whole dollar. Green Caterpillar…
Consider the following scenario: Fuzzy Button Clothing Company’s income statement reports data for its first year of operation. The firm’s CEO would like sales to increase by 25% next year. 1. Fuzzy Button is able to achieve this level of increased sales, but its interest costs increase from 10% to 15% of earnings before interest and taxes (EBIT). 2. The company’s operating costs (excluding depreciation and amortization) remain at 70.00% of net sales, and its depreciation and amortization expenses remain constant from year to year. 3. The company’s tax rate remains constant at 40% of its pre-tax income or earnings before taxes (EBT). 4. In Year 2, Fuzzy Button expects to pay $100,000 and $896,963 of preferred and common stock dividends, respectively. Complete the Year 2 income statement data for Fuzzy Button, then answer the questions that follow. Round each dollar value to the nearest whole dollar.
A company’s data of year wise profit is provided; you have to find out how much profit the company should earn in year 2022 to get total profit of 25000? Use goal seek to solve this problem. Show all formulas used in Excel Take the screen shot of the goal seek window when display result. Year Profit 2019 5000 2000 6000 2021 7000 2022 Total Profit 18000
Using AFN formula in financial forecasting approach, given the following accounting information assuming that the firm's profit margin remains constant and the company is at full capacity. Sales = 6,000,000 Percentage increase projected for next year sales = 20% Net income this year = 600,000 Retention ratio = 50% Accounts Payabale = 1,100,000 Notes Payable = 180,000 Accrued expenses = 500,000 Projected excess funds available next year is = 200,000 Spontaneous liabilities increase is?
Using AFN formula in financial forecasting approach, given the following accounting information assuming that the firm's profit margin remains constant and the company is at full capacity. Sales = 6,000,000 Percentage increase projected for next year sales = 20% Net income this year = 600,000 Retention ratio = 50% Accounts Payabale = 1,100,000 Notes Payable = 180,000 Accrued expenses = 500,000 Projected excess funds available next year is = 200,000 Total assets amounted to?
Mars Corporation is interested in estimating the expected rate of sales growth sustainability and additional financing needed to support improvements fast sales next year. Last year, revenue was $5.5 million; net profit is $500,000; investment in assets is $2,500,000; payables and accruals are $1,000,000; and shareholder equity at the end of the year is $1,500,000 (that is, the equity at the beginning of the year of $1,000,000 plus retained earnings of $500,000). The business does not pay dividends and does not expect to pay dividends in the future. a. Estimate sustainable sales growth rate for Mars Corporation based on the information provided in this issue. Include also the interpretation of the results of your calculations at point a.
Mars Corporation is interested in estimating the expected rate of sales growth sustainability and additional financing needed to support improvements fast sales next year. Last year, revenue was $5.5 million; net profit is $500,000; investment in assets is $2,500,000; payables and accruals are $1,000,000; and shareholder equity at the end of the year is $1,500,000 (that is, the equity at the beginning of the year of $1,000,000 plus retained earnings of $500,000). The business does not pay dividends and does not expect to pay dividends in the future. b. Calculate the net profit of Mars Corporation with the condition of the net profit margin is 5 percent. What is the value of equity at the end? Also calculate the new sustainable sales growth. Give your opinion
Mars Corporation is interested in estimating the expected rate of sales growth sustainability and additional financing needed to support improvements fast sales next year. Last year, revenue was $5.5 million; net profit is $500,000; investment in assets is $2,500,000; payables and accruals are $1,000,000; and shareholder equity at the end of the year is $1,500,000 (that is, the equity at the beginning of the year of $1,000,000 plus retained earnings of $500,000). The business does not pay dividends and does not expect to pay dividends in the future. c. Compute forecasted sales and changes in sales first. What is your estimate of the funds additions needed next year to support the upgrade sales by 20 percent? Also include the interpretation of the results of the calculations you at this point C. d. Compute forecasted sales if sales growth which is expected to be around 45 percent. What is your estimate of the extra funds needed if the expected sales growth is about 45 percent? Give…
Mars Corporation is interested in estimating the expected rate of sales growth sustainability and additional financing needed to support improvements fast sales next year. Last year, revenue was $5.5 million; net profit is $500,000; investment in assets is $2,500,000; payables and accruals are $1,000,000; and shareholder equity at the end of the year is $1,500,000 (that is, the equity at the beginning of the year of $1,000,000 plus retained earnings of $500,000). The business does not pay dividends and does not expect to pay dividends in the future. a.Compute forecasted sales and changes in sales first. What is your estimate of the funds additions needed next year to support the upgrade sales by 20 percent? Also include the interpretation of the results of the calculations
Which of the following is the best example of a well-stated financial objective? A) Increase market share by 3% annually for the next 3 years. B) Gradually boost market share from 10% to 15% over the next several years. C) Boost revenues by a percentage greater than the industry average. D) Achieve lower costs than any other industry competitor. E) Increase earnings per share by 15% annually.