[Solved] WK7Phase3599

Assignment Prompt & Instructions

See Attached

– ## 5yearprojectiontemplateJohnsonJohnson.docx

– ## JohnsonJohnsonCase_Financial_Statement_Template.xlsx

**## 5yearprojectiontemplateJohnsonJohnson.docx**

Five Year Projections- Johnson & Johnson Corporation

Used this template on what needed for the 5 year projection.

**Years: 2024 2025 2026 2027 2028**

**Income Statement**
**Net sales**
**Cost of goods sold**
**Net Operating Income**
**Operating expenses Net Income**

**Net Income**

**Cash Flow Statement**

**Beginning balance**
**Cash inflow $**
**Cash outflow**

**Ending Cash Balance $**

**Balance Sheet**
**Cash $**
**Accounts receivable $**
**Inventory**
**Prepaid expenses $**
**Total Current Assets $**

**Fixed assets $**

**Total Assets $**

**Accounts payable $**

**Short-term notes $**
**Accrued & other liabilities $**
**Total Current Liabilities $0**
**Long-term debt $**
**Other long-term liabilities $**

**Total Long-term Liabilities $**
**Shareholders' equity $**

**Total Liabilities and Equity $**

This worksheet estimates the key financial figures for a company over five years. The projections include abbreviated income and

**## JohnsonJohnsonCase_Financial_Statement_Template.xlsx**

## Company Financial Analysis

| | | | | | |
| — | — | — | — | — | — |
| Johnson & Johnson Case Financial Statement Template |
| (data in thousands [000s], excluding per share data and financial ratios) |
| | FY 2023 | FY 2022 | FY 2021 | FY 2020 | FY 2019 |
| Revenue |
| Cost of Revenue | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Gross Profit |
| Gross Profit Margin | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| EBIT |
| Income Tax |
| NOPAT (Net Operating Profit After Taxes) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Net Income (includes discontinued operations) |

| Diluted Weighted Average Shares |
| Dividends per Share |
| Diluted Normalized EPS (continuing operations) |

| Cash Cycle | FY 2023 | FY 2022 | FY 2021 | FY 2020 | FY 2019 |
| Revenue per day | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Accounts Receivable |
| Receivable Days | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Inventory |
| Inventory Days | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Accounts Payable |
| Payable Days | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Cash Cycle (days) | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |

| Key Ratios | FY 2023 | FY 2022 | FY 2021 | FY 2020 | FY 2019 |
| Market Value of Book Equity |
| Price per share | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Earnings per share (continuing operations) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| P/E Ratio | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Return on Invested Capital | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Return on Assets | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Return on Equity | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Return on Revenue | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Total Assets |
| Current Assets |
| Current Liabilities |
| Current Ratio | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Total Debt |
| Debt/Equity Ratio | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Total Equity (book value) |
| Shareholders' Equity (minority interests) |
| Market to Book Value | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |

| Per Employee | FY 2023 | FY 2022 | FY 2021 | FY 2020 | FY 2019 |
| Number of Employees (continuing operations) |
| Revenue | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Net Income | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Market Value | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |

## Key Ratio Comparison

| | | | | |
| — | — | — | — | — |
| Competitor Financial Analysis |
| (data in thousands [000], excluding per share data and financial ratios) |
| FY Year | FY2023 | Ind Avg | Compet | Compet |
| Revenue | $0.00 |
| Cost of Revenue | $0.00 |
| Gross Profit | $0.00 | $0.00 | $0.00 | $0.00 |
| Gross Profit Margin | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| EBIT | $0.00 |
| Income Tax | $0.00 |
| NOPAT (Net Operating Profit After Taxes) | $0.00 | $0.00 | $0.00 | $0.00 |
| Net Income (includes discontinued operations) | $0.00 |

| Diluted Weighted Average Shares | – 0 |
| Dividends per Share | – 0 |
| Diluted Normalized EPS (continuing operations) | – 0 |

| Cash Cycle | FY2023 | Ind Avg | Compet | Compet |
| Revenue per day | – 0 |
| Accounts Receivable | – 0 |
| Receivable Days | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Inventory | – 0 |
| Inventory Days | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Accounts Payable | – 0 |
| Payable Days | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Cash Cycle (days) | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |

| Key Ratios | FY2023 | Ind Avg | Compet | Compet |
| Market Value of Equity | $ – 0 |
| Price per share | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| P/E Ratio | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Return on Invested Capital | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Return on Assets | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Return on Equity | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Return on Revenue | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Total Assets | – 0 |
| Current Assets | – 0 |
| Current Liabilities | – 0 |
| Current Ratio | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Total Debt | – 0 |
| Debt/Equity Ratio | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Total Equity (book value) | – 0 |
| Shareholders' equity (minority interests) | – 0 |
| Market to Book Value | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |

| Per Employee | FY2023 | Ind Avg | Compet | Compet |
| Number of Employees | – 0 |
| Revenue | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Net Income | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Market Value | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |

**## JohnsonJohnsonCase_Financial_Statement_Template.xlsx**

## Company Financial Analysis

| | | | | | |
| — | — | — | — | — | — |
| Johnson & Johnson Case Financial Statement Template |
| (data in thousands [000s], excluding per share data and financial ratios) |
| | FY 2023 | FY 2022 | FY 2021 | FY 2020 | FY 2019 |
| Revenue |
| Cost of Revenue | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Gross Profit |
| Gross Profit Margin | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| EBIT |
| Income Tax |
| NOPAT (Net Operating Profit After Taxes) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Net Income (includes discontinued operations) |

| Diluted Weighted Average Shares |
| Dividends per Share |
| Diluted Normalized EPS (continuing operations) |

| Cash Cycle | FY 2023 | FY 2022 | FY 2021 | FY 2020 | FY 2019 |
| Revenue per day | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Accounts Receivable |
| Receivable Days | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Inventory |
| Inventory Days | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Accounts Payable |
| Payable Days | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Cash Cycle (days) | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |

| Key Ratios | FY 2023 | FY 2022 | FY 2021 | FY 2020 | FY 2019 |
| Market Value of Book Equity |
| Price per share | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Earnings per share (continuing operations) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| P/E Ratio | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Return on Invested Capital | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Return on Assets | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Return on Equity | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Return on Revenue | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Total Assets |
| Current Assets |
| Current Liabilities |
| Current Ratio | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Total Debt |
| Debt/Equity Ratio | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Total Equity (book value) |
| Shareholders' Equity (minority interests) |
| Market to Book Value | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |

| Per Employee | FY 2023 | FY 2022 | FY 2021 | FY 2020 | FY 2019 |
| Number of Employees (continuing operations) |
| Revenue | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Net Income | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Market Value | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |

## Key Ratio Comparison

| | | | | |
| — | — | — | — | — |
| Competitor Financial Analysis |
| (data in thousands [000], excluding per share data and financial ratios) |
| FY Year | FY2023 | Ind Avg | Compet | Compet |
| Revenue | $0.00 |
| Cost of Revenue | $0.00 |
| Gross Profit | $0.00 | $0.00 | $0.00 | $0.00 |
| Gross Profit Margin | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| EBIT | $0.00 |
| Income Tax | $0.00 |
| NOPAT (Net Operating Profit After Taxes) | $0.00 | $0.00 | $0.00 | $0.00 |
| Net Income (includes discontinued operations) | $0.00 |

| Diluted Weighted Average Shares | – 0 |
| Dividends per Share | – 0 |
| Diluted Normalized EPS (continuing operations) | – 0 |

| Cash Cycle | FY2023 | Ind Avg | Compet | Compet |
| Revenue per day | – 0 |
| Accounts Receivable | – 0 |
| Receivable Days | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Inventory | – 0 |
| Inventory Days | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Accounts Payable | – 0 |
| Payable Days | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Cash Cycle (days) | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |

| Key Ratios | FY2023 | Ind Avg | Compet | Compet |
| Market Value of Equity | $ – 0 |
| Price per share | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| P/E Ratio | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Return on Invested Capital | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Return on Assets | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Return on Equity | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Return on Revenue | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Total Assets | – 0 |
| Current Assets | – 0 |
| Current Liabilities | – 0 |
| Current Ratio | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Total Debt | – 0 |
| Debt/Equity Ratio | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Total Equity (book value) | – 0 |
| Shareholders' equity (minority interests) | – 0 |
| Market to Book Value | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |

| Per Employee | FY2023 | Ind Avg | Compet | Compet |
| Number of Employees | – 0 |
| Revenue | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Net Income | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Market Value | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |

**## 5yearprojectiontemplateJohnsonJohnson.docx**

Five Year Projections- Johnson & Johnson Corporation

Used this template on what needed for the 5 year projection.

**Years: 2024 2025 2026 2027 2028**

**Income Statement**
**Net sales**
**Cost of goods sold**
**Net Operating Income**
**Operating expenses Net Income**

**Net Income**

**Cash Flow Statement**

**Beginning balance**
**Cash inflow $**
**Cash outflow**

**Ending Cash Balance $**

**Balance Sheet**
**Cash $**
**Accounts receivable $**
**Inventory**
**Prepaid expenses $**
**Total Current Assets $**

**Fixed assets $**

**Total Assets $**

**Accounts payable $**

**Short-term notes $**
**Accrued & other liabilities $**
**Total Current Liabilities $0**
**Long-term debt $**
**Other long-term liabilities $**

**Total Long-term Liabilities $**
**Shareholders' equity $**

**Total Liabilities and Equity $**

This worksheet estimates the key financial figures for a company over five years. The projections include abbreviated income and

**## JohnsonJohnsonCase_Financial_Statement_Template.xlsx**

## Company Financial Analysis

| | | | | | |
| — | — | — | — | — | — |
| Johnson & Johnson Case Financial Statement Template |
| (data in thousands [000s], excluding per share data and financial ratios) |
| | FY 2023 | FY 2022 | FY 2021 | FY 2020 | FY 2019 |
| Revenue |
| Cost of Revenue | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Gross Profit |
| Gross Profit Margin | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| EBIT |
| Income Tax |
| NOPAT (Net Operating Profit After Taxes) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Net Income (includes discontinued operations) |

| Diluted Weighted Average Shares |
| Dividends per Share |
| Diluted Normalized EPS (continuing operations) |

| Cash Cycle | FY 2023 | FY 2022 | FY 2021 | FY 2020 | FY 2019 |
| Revenue per day | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Accounts Receivable |
| Receivable Days | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Inventory |
| Inventory Days | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Accounts Payable |
| Payable Days | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Cash Cycle (days) | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |

| Key Ratios | FY 2023 | FY 2022 | FY 2021 | FY 2020 | FY 2019 |
| Market Value of Book Equity |
| Price per share | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Earnings per share (continuing operations) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| P/E Ratio | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Return on Invested Capital | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Return on Assets | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Return on Equity | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Return on Revenue | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Total Assets |
| Current Assets |
| Current Liabilities |
| Current Ratio | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Total Debt |
| Debt/Equity Ratio | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Total Equity (book value) |
| Shareholders' Equity (minority interests) |
| Market to Book Value | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |

| Per Employee | FY 2023 | FY 2022 | FY 2021 | FY 2020 | FY 2019 |
| Number of Employees (continuing operations) |
| Revenue | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Net Income | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Market Value | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |

## Key Ratio Comparison

| | | | | |
| — | — | — | — | — |
| Competitor Financial Analysis |
| (data in thousands [000], excluding per share data and financial ratios) |
| FY Year | FY2023 | Ind Avg | Compet | Compet |
| Revenue | $0.00 |
| Cost of Revenue | $0.00 |
| Gross Profit | $0.00 | $0.00 | $0.00 | $0.00 |
| Gross Profit Margin | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| EBIT | $0.00 |
| Income Tax | $0.00 |
| NOPAT (Net Operating Profit After Taxes) | $0.00 | $0.00 | $0.00 | $0.00 |
| Net Income (includes discontinued operations) | $0.00 |

| Diluted Weighted Average Shares | – 0 |
| Dividends per Share | – 0 |
| Diluted Normalized EPS (continuing operations) | – 0 |

| Cash Cycle | FY2023 | Ind Avg | Compet | Compet |
| Revenue per day | – 0 |
| Accounts Receivable | – 0 |
| Receivable Days | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Inventory | – 0 |
| Inventory Days | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Accounts Payable | – 0 |
| Payable Days | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Cash Cycle (days) | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |

| Key Ratios | FY2023 | Ind Avg | Compet | Compet |
| Market Value of Equity | $ – 0 |
| Price per share | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| P/E Ratio | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Return on Invested Capital | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Return on Assets | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Return on Equity | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Return on Revenue | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Total Assets | – 0 |
| Current Assets | – 0 |
| Current Liabilities | – 0 |
| Current Ratio | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Total Debt | – 0 |
| Debt/Equity Ratio | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Total Equity (book value) | – 0 |
| Shareholders' equity (minority interests) | – 0 |
| Market to Book Value | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |

| Per Employee | FY2023 | Ind Avg | Compet | Compet |
| Number of Employees | – 0 |
| Revenue | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Net Income | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Market Value | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |

**## 5yearprojectiontemplateJohnsonJohnson.docx**

Five Year Projections- Johnson & Johnson Corporation

Used this template on what needed for the 5 year projection.

**Years: 2024 2025 2026 2027 2028**

**Income Statement**
**Net sales**
**Cost of goods sold**
**Net Operating Income**
**Operating expenses Net Income**

**Net Income**

**Cash Flow Statement**

**Beginning balance**
**Cash inflow $**
**Cash outflow**

**Ending Cash Balance $**

**Balance Sheet**
**Cash $**
**Accounts receivable $**
**Inventory**
**Prepaid expenses $**
**Total Current Assets $**

**Fixed assets $**

**Total Assets $**

**Accounts payable $**

**Short-term notes $**
**Accrued & other liabilities $**
**Total Current Liabilities $0**
**Long-term debt $**
**Other long-term liabilities $**

**Total Long-term Liabilities $**
**Shareholders' equity $**

**Total Liabilities and Equity $**

This worksheet estimates the key financial figures for a company over five years. The projections include abbreviated income and

**## JohnsonJohnsonCase_Financial_Statement_Template.xlsx**

## Company Financial Analysis

| | | | | | |
| — | — | — | — | — | — |
| Johnson & Johnson Case Financial Statement Template |
| (data in thousands [000s], excluding per share data and financial ratios) |
| | FY 2023 | FY 2022 | FY 2021 | FY 2020 | FY 2019 |
| Revenue |
| Cost of Revenue | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Gross Profit |
| Gross Profit Margin | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| EBIT |
| Income Tax |
| NOPAT (Net Operating Profit After Taxes) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Net Income (includes discontinued operations) |

| Diluted Weighted Average Shares |
| Dividends per Share |
| Diluted Normalized EPS (continuing operations) |

| Cash Cycle | FY 2023 | FY 2022 | FY 2021 | FY 2020 | FY 2019 |
| Revenue per day | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| Accounts Receivable |
| Receivable Days | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Inventory |
| Inventory Days | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Accounts Payable |
| Payable Days | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Cash Cycle (days) | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |

| Key Ratios | FY 2023 | FY 2022 | FY 2021 | FY 2020 | FY 2019 |
| Market Value of Book Equity |
| Price per share | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Earnings per share (continuing operations) | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| P/E Ratio | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Return on Invested Capital | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Return on Assets | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Return on Equity | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Return on Revenue | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Total Assets |
| Current Assets |
| Current Liabilities |
| Current Ratio | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Total Debt |
| Debt/Equity Ratio | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Total Equity (book value) |
| Shareholders' Equity (minority interests) |
| Market to Book Value | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |

| Per Employee | FY 2023 | FY 2022 | FY 2021 | FY 2020 | FY 2019 |
| Number of Employees (continuing operations) |
| Revenue | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Net Income | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Market Value | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |

## Key Ratio Comparison

| | | | | |
| — | — | — | — | — |
| Competitor Financial Analysis |
| (data in thousands [000], excluding per share data and financial ratios) |
| FY Year | FY2023 | Ind Avg | Compet | Compet |
| Revenue | $0.00 |
| Cost of Revenue | $0.00 |
| Gross Profit | $0.00 | $0.00 | $0.00 | $0.00 |
| Gross Profit Margin | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| EBIT | $0.00 |
| Income Tax | $0.00 |
| NOPAT (Net Operating Profit After Taxes) | $0.00 | $0.00 | $0.00 | $0.00 |
| Net Income (includes discontinued operations) | $0.00 |

| Diluted Weighted Average Shares | – 0 |
| Dividends per Share | – 0 |
| Diluted Normalized EPS (continuing operations) | – 0 |

| Cash Cycle | FY2023 | Ind Avg | Compet | Compet |
| Revenue per day | – 0 |
| Accounts Receivable | – 0 |
| Receivable Days | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Inventory | – 0 |
| Inventory Days | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Accounts Payable | – 0 |
| Payable Days | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Cash Cycle (days) | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |

| Key Ratios | FY2023 | Ind Avg | Compet | Compet |
| Market Value of Equity | $ – 0 |
| Price per share | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| P/E Ratio | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Return on Invested Capital | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Return on Assets | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Return on Equity | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Return on Revenue | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Total Assets | – 0 |
| Current Assets | – 0 |
| Current Liabilities | – 0 |
| Current Ratio | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Total Debt | – 0 |
| Debt/Equity Ratio | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Total Equity (book value) | – 0 |
| Shareholders' equity (minority interests) | – 0 |
| Market to Book Value | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |

| Per Employee | FY2023 | Ind Avg | Compet | Compet |
| Number of Employees | – 0 |
| Revenue | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Net Income | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Market Value | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |

– 1
– 2