WK7Phase3599
See Attached
a year ago
10
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! |