WK7Phase3599

Boopboop56

See Attached

  • a year ago
  • 10
files (2)

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!