Johnson & Johnson (JNJ) Financial Forecast Calculator
Interactive 5-year forecast and DCF for Johnson & Johnson. Adjust revenue growth, gross margin, capex intensity, WACC, and terminal growth - see revenue, free cash flow, and enterprise value update in real time. Seeded from Johnson & Johnson’s most recent SEC filings.
Assumptions
Need this as an Excel model?
Keep iterating on the Johnson & Johnson forecast in Excel. The downloadable sample has every assumption you see here plus a fully integrated income statement, balance sheet, cash flow, and debt schedule - five years of SEC historicals and live formulas in a fully editable workbook.
Other Healthcare forecasts
Run the same calculator on a peer.
Frequently asked
What is Johnson & Johnson's primary business focus?+
Johnson & Johnson is a diversified global healthcare leader specializing in the research, development, manufacture, and sale of pharmaceutical products and medical devices. Its business is divided into Innovative Medicine, focusing on therapies like immunology and oncology, and MedTech, providing products for surgery, orthopaedics, and vision.
What are the main revenue drivers for Johnson & Johnson?+
Johnson & Johnson's revenue is primarily driven by its Innovative Medicine segment, which focuses on intellectual property-heavy pharmaceuticals, and its manufacturing-intensive MedTech segment. Growth is expected from new pipeline assets and recent MedTech acquisitions, which are key to managing the revenue transition from legacy blockbusters.
What is Johnson & Johnson's typical capital expenditure as a percentage of revenue?+
Johnson & Johnson's capital expenditure typically ranges from 3% to 4.5% of revenue. Approximately 60% of this capex is allocated to growth initiatives, such as expanding biologic manufacturing capacity and developing robotic surgery facilities, while the remaining 40% is for maintenance.
How do Johnson & Johnson's intangible assets impact its balance sheet?+
Goodwill and intangible assets represent over 40% of Johnson & Johnson's total assets, reflecting its history of large acquisitions. This significant component is crucial for equity valuation and scenario planning, especially when considering the impact of M&A on the company's financial structure.
What is the purpose of the downloadable Excel financial model for Johnson & Johnson?+
The downloadable Excel model serves as a comprehensive equity valuation and scenario planning tool for equity research analysts covering Johnson & Johnson. It specifically focuses on analyzing the revenue transition from legacy blockbuster drugs facing loss of exclusivity to new pipeline assets and recent MedTech acquisitions.
How has Johnson & Johnson's business structure changed recently?+
Johnson & Johnson recently spun off its Consumer Health segment, Kenvue, in 2023, streamlining its focus on pharmaceuticals and medical devices. The company has also made significant acquisitions, including Abiomed, Shockwave Medical, V-Wave, and Halda Therapeutics, to strengthen its MedTech and pharmaceutical portfolios.
Have more financial modelling questions? Contact us
