Financial statement analysis and common stock valuation

Analysis of Solvency Ratios

Examines Medtronic PLC capital structure in terms of the mix of its financing sources and the ability of the firm to satisfy its longer-term debt and investment obligations.

• Solvency Ratios (Summary)
• Debt to Equity
• Debt to Equity (including Operating Lease Liability)
• Debt to Capital
• Debt to Capital (including Operating Lease Liability)
• Debt to Assets
• Debt to Assets (including Operating Lease Liability)
• Financial Leverage
• Interest Coverage
• Fixed Charge Coverage

Common-Size Balance Sheet: Assets

Assets components shown as percentage of total assets.

Analysis of Geographic Areas

Medtronic PLC operates in 3 regions: Ireland; United States; and Rest of world.

• Area Asset Turnover
• Net sales
• Property, plant, and equipment, net

DuPont Analysis: Disaggregation of ROE, ROA, and Net Profit Margin

An approach to decomposing Medtronic PLC return on equity, return on assets, and net profit margin ratio as the product of other financial ratios.

• Two-Component Disaggregation of ROE
• Three-Component Disaggregation of ROE
• Five-Component Disaggregation of ROE
• Two-Component Disaggregation of ROA
• Four-Component Disaggregation of ROA
• Disaggregation of Net Profit Margin

Analysis of Long-term (Investment) Activity Ratios
Quarterly Data

Measures how efficiently Medtronic PLC generates revenues from its investments in fixed or total assets.

• Long-term Activity Ratios (Summary)
• Net Fixed Asset Turnover
• Total Asset Turnover
• Equity Turnover

Capital Asset Pricing Model (CAPM)

CAPM is a theory concentrated with deriving the expected rates of return on risky assets based on the assets’ systematic risk levels. Systematic risk is the variability of returns that is due to macroeconomic factors that affect all risky assets. It cannot be eliminated by diversification.

• Rates of Return
• Variance and Covariance
• Systematic Risk (β) Estimation
• Expected Rate of Return

Analysis of Reportable Segments

Medtronic PLC operates in 4 segments: Cardiovascular Portfolio; Neuroscience Portfolio; Medical Surgical Portfolio; and Diabetes Operating Unit.

• Segment Profit Margin
• Segment Return on Assets (Segment ROA)
• Segment Asset Turnover
• Net sales
• Segment operating profit
• Total assets

Common-Size Balance Sheet: Liabilities and Stockholders’ Equity
Quarterly Data

Liabilities and stockholders’ equity components shown as percentage of total liabilities and stockholders’ equity.

DuPont Analysis: Disaggregation of ROE, ROA, and Net Profit Margin
Quarterly Data

An approach to decomposing Medtronic PLC return on equity, return on assets, and net profit margin ratio as the product of other financial ratios.

• Two-Component Disaggregation of ROE
• Three-Component Disaggregation of ROE
• Five-Component Disaggregation of ROE
• Two-Component Disaggregation of ROA
• Four-Component Disaggregation of ROA
• Disaggregation of Net Profit Margin

Analysis of Profitability Ratios

Measures the income of Medtronic PLC relative to its revenues and invested capital.

• Profitability Ratios (Summary)
• Gross Profit Margin
• Operating Profit Margin
• Net Profit Margin
• Return on Equity (ROE)
• Return on Assets (ROA)

Balance Sheet: Liabilities and Stockholders’ Equity

The liabilities and stockholders’ equity reports major classes and amounts of external claims on assets and owners’ capital contributions, and other internally generated sources of capital.

Present Value of Free Cash Flow to Equity (FCFE)

The FCFE valuation approach estimates the value of equity as the present value of future FCFE discounted at the required rate of return on equity.

• Intrinsic Stock Value (Valuation Summary)
• Required Rate of Return (r)
• FCFE Growth Rate (g)