Cost of Capital, Capital Structure, and Capital Budgeting Analysis - McKesson Corporation In this project, you are supposed to be a financial manager to apply the knowledge learn from Financial Manage

1.0 – Cover PageCost of Capital, Capital Structure, and Capital Budgeting Analysis - McKesson Corporation In this project, you are supposed to be a financial manager to apply the knowledge learn from Financial Manage 1

Financial Analysis Report

McKesson Corporation

Financial Management, FINC 6352 - 15408

Prof. Yixi Ning

Friday, July 29, 2022

Group 13

Analyst:

Erica Newman, Vannesa Dickson, & Rita Rhodes-Cotton

source: videoblocks.com

1.1– Table of Contents

1.0 – Executive Summary 2

2.0 – Financial Ratio Analysis 4

4.0 – Weighted Average Cost of Capital (WACC) 14

5.0 – Cash Flow Estimation 19

6.0 – Capital Budgeting Analysis 22

7.0 – Project Recommendation 24

References 25

Appendix 27


1.0 – Executive Summary

McKesson Corporation is one of the oldest and largest healthcare companies in North America offering products and services to the U.S., Canada, and internationally abroad. As a provider of pharmaceutical and medical supplies that serves leading healthcare plans, about 96%, American hospitals, upwards of 50%, and doctors, by over 20%, our team will evaluate McKesson’s business success and provide a detailed business analysis highlighting their estimated cost of debt, cost of preferred stock, cost of common equity, capital structure, and their WACC, weighted average cost of capital.

Key Metrics

Sector Healthcare

Industry Pharmaceutical

Share Price

(06/30/22) $329.53

Target Price $395

Upside +20.69%

52 Week Share $186.61 -

Price Range: $339.94

Exchange Traded NYSE

Ticker MCK

Dividend Yield 0.5763%

Annual Dividend $1.88

# Shares Out 212m

Key Ratio (As of 01 June 2022)

Market Cap 31.35B

EPS $7.23

P/E 41.40

Beta (5-year avg.) 0.66

Peer Companies:

Cardinal Health, Inc. (NYSE:CAH);

AmerisourceBergen

Corporation (NYSE:ABC)

Analysts

Erica Newman

Vannesa Dickson

Rita Rhodescotton

“McKesson operates it business in four segments, U.S. Pharmaceutical, Prescription Technology Solutions (RxTS), Medical-Surgical Solutions, and International” (Mergent, 2022) that role into primary segments of McKesson Distribution Solutions and McKesson Technology Solutions. Founded in 1833 as a Manhattan drugstore and later headquarter in San Francisco through a hostile takeover, McKesson Corporation is now headquartered in Irving, TX. Over the years, McKesson has maintained the continued improvement of its efficient operations through an initiative of cutting costs, divestment of non-essential businesses, establish service agreement partnerships with Walmart while expanding its size in the market through acquisitions between 2016 and 2018, like the acquisition of All Scripts Healthcare Solutions Inc. (Mergent, 2022).

Key investment rational and insights into McKesson’s operational and financial efficiencies, show an overall positive capital structure which is reflective of exceptional stewardship of capital by corporate governance, while also maintaining a strategy of appropriately managing risks in the industry, and using its capital to advance investment in diversified business segments. McKesson’s Market Cap is $46.90 billion as of June 30, 2022,

with a share price that is valued at $329.53 and well under its target share price of $395.00, which is undervalued by 20.7%. With these noted factors, this sets McKesson apart from its competitors as a great buy recommendation for potential investors.

In consideration of taking on a new project, our analysis and evaluation of McKesson made key assumptions upon viewing industry risk, especially considering the impact of Covid 19 on all distribution and supply chain efforts of most industries. With McKesson’s after-tax cost of debt of 0.00% and average cost of equity of 0.00%, we determined a WACC of 0.00% for McKesson. Although McKesson experienced a downturn in growth due to the pandemic in 2020 and 2021, we believe McKesson will sustain its earnings and cash flow growth considering the highly visible demand for healthcare services and products. Withstanding the industry risks we believe investing in a new project would be viable and one that investors should want to buy McKesson as it shows a conservative growth rate of 0.00% (2018-2020) and a 0.00% (2021-2028) that were used to determine its intrinsic value.

1.1 – Company Overview

As one of Fortune 500’s 9th ranked companies, McKesson Corporation is a leading and global pharmaceutical drug distributor and information technology company. McKesson delivers a comprehensive selection of prescription and generic pharmaceuticals, health and beauty care products, as well as medical supplies and surgical equipment and technology services to customers. (Staff, 2022). Founded in 1833, by John McKesson, and based in Texas with over 30 distribution centers in US, Canada, and Europe, the company has over the year’s diversified it’s healthcare services through strategic growth strategies via acquisitions or business ventures that expanded or complemented their business structure.

Through diversification, 80% of McKesson Corporation’s revenue comes from US Pharmaceuticals, 15% is generated from the international distribution and wholesale services in Europe and Canada, with the remaining 5% generated from Medical-Surgical Solutions and RxTS services (D&B Hoovers, 2022). Of note, sales to McKesson's ten largest customers account for approximately 52% of total revenues. Sales to its largest customer, CVS Health Corporation (CVS), account for approximately 21% of total revenues. McKesson’s overall financial performance reflects an 11% increase in total revenue in 2022 to $264B from 238B in 2021. Bouncing back from a net loss of $4.3B in 2021, mainly due to the impact of Covid on distribution channels and the economy, the company had a remarkable 130% increase in net income to $1.3B in 2022. See Figure 1.1

Figure 1.1McKesson Revenue by Segment & Net Income

Source: McKesson 10K 2022

2.0 – Financial Ratio Analysis

“Financial ratio analysis compares the results in different line items of the financial statements. The analysis of these ratios is designed to draw conclusions regarding the financial performance, liquidity, leverage, and asset usage of a business (Bragg, 2022)”. Ratio analysis are mainly used by business managers to fairly compare between a company and industry across time. The data contained in financial statements, the balance sheet, income statement, and statement of cash flows, are used by managers to gain information from financial ratios to make rational financial decisions that improves financial strength, profitability, efficiency, management effectiveness, and valuation, for the business and influence potential investors. Financial ratio analysis and interpretation is used to evaluate six main areas of interest to managers and investors; liquidity, coverage, solvency, profitability, efficiency, and market prospects (GoCardless, 2021). The results can be compared to industry averages and to the results of benchmark companies, to see how a business is performing in comparison to other organizations (GoCardless, 2021).

Our analysis of McKesson Corporation’s Key financial ratios will review the past 5 years and their most current year for their financial stability and growth while also displaying a comparison to their top two competitors, Amerisourcebergen Corporation (ABC) and Cardinal Health, Inc. (CAH). See Table 2.0.

Cost of Capital, Capital Structure, and Capital Budgeting Analysis - McKesson Corporation In this project, you are supposed to be a financial manager to apply the knowledge learn from Financial Manage 2

Compared to its industry peers historically, McKesson has consistently held the most growth in profitability and stability. However, with its distribution greatly impacted by the pandemic, McKesson has experienced an extreme decline in ROE and EPS, with similar effects felt by its peers Amerisourcebergen Corporation (ABC) and Cardinal Health, Inc. (CAH) See Figure 2.0 Over a 5year period, McKesson’s revenue growth has lagged 13% behind its peer ABC, but well ahead of CAH with a 27% revenue growth overall. Although ROE was negative for all, McKesson has the largest ROC growth of its peers averaging 119% while it lags behind ABC and CAH in Total Debt / Equity. All hope is not lost as McKesson EPS skyrocket back to its norms with an EPS of 7.23 in 2022. Although slightly outperformed by ABC with and EPS of 8.2, McKesson is doing well as the economy recovers.

Figure 2.0.1 McKesson Peer Industry Benchmarks

Cost of Capital, Capital Structure, and Capital Budgeting Analysis - McKesson Corporation In this project, you are supposed to be a financial manager to apply the knowledge learn from Financial Manage 3

Source: D&B Hoovers

2.1 – Liquidity Ratios

“Liquidity analysis is used to analyze a company’s abilities to meet its immediate debt obligations out of its current assets. The two key financial ratios used to analyze liquidity are current ratio and quick ratio (GoCardless, 2021)”. The current ratio is sometimes referred to as the working capital ratio while the acid test ratio is defined as the quick ratio. Each of these ratios use balance sheet line items that take into account current assets, current liabilities, and inventories as a measure to determine a margin of safety in a firm’s accessibility to funds to readily pay current debt without seeking external sources in the event of an unforeseen event. As a financial metric, liquidity ratios speak to a firm’s ability to pay short term debt obligations.

McKesson has consistently and relatively held a healthy posture of liquidity similar to that of its peers ABC, CAH, and the S&P Healthcare Sector HCX, with a Current Ratio averaging ~1 or below and a Quick Ratio ~.58 and below over the past 5 years. The gift of having such financial flexibility has enabled McKesson to efficiently and effectively make use of on hand cash and short-term obligations to champion key acquisitions from 2018 to present that helped to diversify its product offerings and business lines over the years. For example, in 2018, McKesson completed its acquisitions of intraFUSION, Inc., BDI Pharma, LLC, and Uniprix Group for net cash consideration of $485,000,000, which was funded from cash on hand. Although McKesson Management has had great success being great stewards of its free cash flow over the years, they must remain cautious considering a slight dip in both current and quick ratios in 2021 going into 2022 due to the impact of Covid on the overall global economy.

Figure 2.1 Liquidity Ratios

Cost of Capital, Capital Structure, and Capital Budgeting Analysis - McKesson Corporation In this project, you are supposed to be a financial manager to apply the knowledge learn from Financial Manage 4

Source: D&B Hoovers

2.2 – Asset Management Ratios

Asset Management Ratios or activity ratios are considered efficiency ratios that measure how efficiently a firm’s management is using its assets to generate sales and maximize profit (Calrson, 2020). A firm’s management uses four key ratios to evaluate an entity’s efficiency: Inventory Turnover, Days Sales Outstanding, Fixed Asset Turnover, and Total Asset Turnover. These activity ratios provide a gauge of a company’s operations by determining average number of days it takes to collect on customer accounts; the average number of days to pay vendors; the effectiveness of a firm’s asset mix to generate sales. Typically, a higher ratio number is preferred as it reflects greater efficiency in turning over assets, inventory, and receivables.

In the case of McKesson, their 5-year trend reflects an overall steady and efficient stewardship of the company’s inventory, receivables, and assets even though it appears that McKesson encountered a decline in fixed asset turnover between 2019- 2021 as seen in Figure 2.2 below. This decline can be attributed to the impact of the coronavirus pandemic on the overall economy, industry, and the supply chain distribution. Despite the drop, McKesson appears to be on the upswing back to its normal asset turnover levels into 2022. Considering McKesson’s Pharmaceutical Distribution business line, it is very important to operate with low cost of goods sold and highly efficient inventory management driving even better margins. As for McKesson’s efficiency compared to its industry peers in 2022, McKesson, in general, appears to not be as efficient as ABC, in the areas of Inventory Turnover and Days Sales Outstanding with lower ratios of 13.2 and 23.2 respectively compared to ABC topping out at higher ratios of 14.8 for inventory and 27.3 for Days Sales Outstanding. However, McKesson’s efficiency in managing Total Asset turnover is steady with its peers while Fixed Asset turnover far greatly exceeds the efficiency of its peers in generating sales from its property, plant, and equipment with a ratio of 72.5.

Figure 2. 2 Asset Management Ratios

Cost of Capital, Capital Structure, and Capital Budgeting Analysis - McKesson Corporation In this project, you are supposed to be a financial manager to apply the knowledge learn from Financial Manage 5

Source: D&B Hoovers

2.3 – Debt Management Ratios

“Debt Management ratios include solvency and coverage ratios that allow financial managers to appraise the position of a firm with regard to the debt financing, or financial leverage as well as coverage of debt obligations used to finance their operations. The solvency ratios gauge how much debt financing the firm uses as compared to either its retained earnings or equity financing (Calrson, 2020)”. Coverage ratios measure the degree to which a company can cover financial debt obligations and related costs. These ratios complement solvency ratios allowing managers to view a complete picture of the company’s debt position.

Key debt solvency ratios include debt-to-assets, long-term debt-to-assets, and debt-to-equity ratios. Debt coverage ratios include times interest earned and debt service coverage ratios which measure how well an entity can cover total debt and interest payments on debt. A good debt ratio is typically below 1.0, but it also depends on the type of business and industry. A debt ratio that is 2.0 or higher is seen as risky while a negative debt ratio is seen as very risky and may indicate a risk of bankruptcy for the company.

McKesson’s 5-year trend of its debt ratio or debt-to-asset ratio reflects a constant and steady debt-to-asset ratio that averages about ~.14 with .12 identified for 2022. In comparison to industry peers ABC and CAH, McKesson’s debt ratio is in sync. However, when looking at McKesson’s long-term debt ratio and debt-to-equity ratio trend over the last 5 years, it has been on the decline, so much so it has declined to less than zero since 2021. This decline is indicative of the impact of the Covid pandemic on the healthcare services and distribution industry and signals issues with the company’s current financing. Compared to its peer’s ABC with a debt-to- equity ratio of 28.58 and CAH with a debt-to-equity ratio of 3.0, McKesson debt-to-equity ratios presents a risk to its shareholders. See Figure 2.3.1 With that said, McKesson, who has always been a great steward managing its financial operations may need to consider a reorganization of or sell off of some of its non-performing assets. To that effect, in 2022, McKesson sold off its European assets and is currently lining up to have a stronger concentration of is business mostly in the US and Canadian markets. A few key sales include, sell of its 30% interest in the German pharmaceutical wholesale joint venture to Walgreens Boots Alliance; sale of its Austrian business to Quadrifolia Management GmbH for approximately $276,000,000; and the sale of its retail and distribution businesses in the U.K (Mergent, 2022).

Although McKesson’s debt-equity ratios were in decline ending 2021, their ability to cover interest obligations and payout dividends bounced back by year-end 2022. With a TIE coverage of 11.83 in line with the industry and peer ABC 13.70 but above that of CAH, McKesson has clearly taken their financial stewardship to test by improving their financial position. With an industry dividend payout of 59.9, McKesson’s 25.21 shareholder payout ratio is far behind compared to its peer’s payout, ABC 21.98 and CAH 49.71. See Figure 2.3.1

Figure 2.3.1 Debt Management Ratios

Cost of Capital, Capital Structure, and Capital Budgeting Analysis - McKesson Corporation In this project, you are supposed to be a financial manager to apply the knowledge learn from Financial Manage 6

Cost of Capital, Capital Structure, and Capital Budgeting Analysis - McKesson Corporation In this project, you are supposed to be a financial manager to apply the knowledge learn from Financial Manage 7

Source: D&B Hoovers & Gurufocus

2.4 – Profitability Ratios

Profitability analysis is used to analyze a company’s ability to make money from its sales or operations, balance sheet assets, or shareholder’s equity and are the summary ratios that sum up the effects of liquidity management, asset management, and debt management on the firm (Calrson, 2020). There are four essential financial ratios used to analyze profitability, net profit margin, return on total assets (ROA), basic earning power, and return on equity (ROE). As an indicator of how efficient a company generates profit and value for its shareholders, high ratio results are most favorable.

Although McKesson’s profit margin has trended down over the past 5 years to 0.98%, their operating profit margin is slightly ahead of the overall industry of only 0.86%. In comparison to its immediate peers however, McKesson is lagging behind ABC and CAH, each with an operating profit margin of 1.35% and 1.10% respectively. McKesson’s Net Profit Margin earnings have been relatively low compared to the industry. The impact of the coronavirus pandemic clearly impacted McKesson’s net profit margin earnings in 2021 with a negative net profit margin of -1.91%, however, they were able to recover in 2022 to 0.58%. Although McKesson’s traditionally dominating share of the market and size have enabled it to gain negotiating advantages with manufactures and customers, their usual differentiating factor of minimizing operating costs and costs of goods sold were challenged. The overall industry maintained a net profit margin of 0.76% which is greater than McKesson. In particular, industry peer ABC’s net profit margin of 0.90% in 2022 is far ahead of McKesson while CAH is slightly below at 0.38%. See Figure 2.4.1

Figure 2.4.1 Profit Margin Ratios

Cost of Capital, Capital Structure, and Capital Budgeting Analysis - McKesson Corporation In this project, you are supposed to be a financial manager to apply the knowledge learn from Financial Manage 8

Source: D&B Hoovers & Gurufocus

As for McKesson’s Return on Assets (ROA) and Return on Equity (ROE), McKesson has traditionally sored over its peers. As a measure of McKesson’s management effectiveness, over the past 5 years, their ROA and ROE ratios have trended upward, (ROA 0.11% (2018) to 1.51% (2020) & ROE 1.34% (2018) to 11.56% (2020), with the exception of the impact of Covid in 2021 which declined to -7.41%(ROA) and -108.80%(ROE). As of year-end 2022, McKesson financial managers have gotten to work by effectively increasing their ROA to 1.74% which is in sync with overall industry, but lagging behind peer ABC whose ROA is 3.3% and well ahead of CAH’s negative ROA of -2.22% as of 2022. It appears that McKesson is not alone in recovering from the impact of the pandemic on the economy as its immediate peers ABC and CAH each have negative ROEs that are below zero. See Figure 2.4.2

Figure 2.4.2 ROA & ROE Ratios

Cost of Capital, Capital Structure, and Capital Budgeting Analysis - McKesson Corporation In this project, you are supposed to be a financial manager to apply the knowledge learn from Financial Manage 9

Source: D&B Hoovers & Gurufocus

2.5 – Market Value Ratios

Market value ratios shows how much investors are willing to pay for the stock, how well the business generates cash flow, and gives the financial managers an indicator of how investors view the value of the company. Three common ratios used for this evaluation are P/E Ratio, P/Cash Flow Ratio, and Market/ Book Ratio.

Over the past 5 years, McKesson when compared to its peers has shown growth in profitability and consistency, although fluctuated. The impact of the coronavirus on the global economy and healthcare industry has greatly impacted that growth and has forced financial managers to tighten their stewardship of the company’s finances while still maintaining the confidence of investors. Although ABC has shown the greatest revenue growth over the past 5 years compared to McKesson and CAH, McKesson has taken steps to bounce back in 2022 with P/E ratio of 42.35 which is well ahead of the overall industry and its peers ABC with only a P/E ratio of 18.9 and CAH below zero for 2022. In regards to EPS, McKesson’s performance over it peers ABC and CAH is greater.


Figure 2.5 Market Value & Per Share Valuation Ratios

Cost of Capital, Capital Structure, and Capital Budgeting Analysis - McKesson Corporation In this project, you are supposed to be a financial manager to apply the knowledge learn from Financial Manage 10

Cost of Capital, Capital Structure, and Capital Budgeting Analysis - McKesson Corporation In this project, you are supposed to be a financial manager to apply the knowledge learn from Financial Manage 11

Source: D&B Hoovers & Gurufocus

3.0 – Estimated Capital Structure

The capital structure of an organization refers to the mix of debt and/or equity used to finance its operations and assets. A debt-to-equity ratio or a debt-to-capital ratio are widely used to define the financial structure of a corporation. A company's operations, capital expenditures, acquisitions, and other investments are financed by debt and equity capital. Managers will balance the two to create the appropriate capital structure regardless of whether businesses choose to finance their operations with debt or equity. The debt-to-equity ratio that results in the company having the lowest weighted average cost of capital is often used to determine the ideal capital structure for corporations.

McKesson has a low net debt to EBITDA ratio of only 0.20. Additionally, its EBIT more than 15.2 times exceeds its interest expense. We therefore have a casual attitude toward its extremely prudent use of debt. Another positive development is that McKesson's EBIT increased by 11% over the previous year, further enhancing its capacity to control debt. When examining debt levels, it makes sense to start with the balance sheet. However, future earnings will ultimately determine McKesson's capacity to maintain a healthy balance sheet going forward (Pettit, 2003). The last point is that a business can only pay off debt with actual cash, not accounting earnings. The next natural step is to determine what percentage of that EBIT is actually matched by free cash flow. Fortunately, for any shareholders, during the past three years, McKesson has generated more free cash flow than EBIT. We experience the same kind of excitement as the crowd at a Daft Punk concert when there is that kind of significant cash conversion. The chart below shows that McKesson had US$7.07b in debt in March 2021.

Figure 3.0 McKesson Debt Equity

Cost of Capital, Capital Structure, and Capital Budgeting Analysis - McKesson Corporation In this project, you are supposed to be a financial manager to apply the knowledge learn from Financial Manage 12

3.1 – Capital Structure Estimation Analysis

The ratio of debt to equity used by a corporation to finance both its current operations and potential future expansion is known as its capital structure. Equity capital derives from both ownership shares in and claims on a company's future cash flows and profitability (Exley, 2006). Debt examples include things like loans and bond issuances, whereas equity examples include things like common stock, preferred stock, and retained earnings. Additionally regarded as a component of the capital structure is short-term debt. A firm funds its overall operations and expansion through its capital structure. Borrowed funds that must be repaid to the lender, frequently with interest charges, constitute debt. Without the need to recoup any investment, equity is the right to ownership in the business.

The ideal capital structure of McKesson Corporation is between 30 and 49 percent, and to be prudent, medium company risk is taken into account. Given that it has been largely stable and falls within the desirable range, the target capital structure is estimated to be 45.7 percent using the average of the last 8 years. It looks as if management might be keeping its capital structure conservative when compared to its rivals in order to be on the lookout for potential acquisition opportunities in the future.

4.0 – Weighted Average Cost of Capital (WACC)


When analyzing the financial position of McKesson Corporation, it is paramount to note the Weighted Average Cost of Capital (WACC). Frank & Shen (2016) defines WACC as an average capital from all sources like common stock, bonds, preferred stock, and debts. McKesson Corporation always uses it to find the financial cash flows by using various components. The thing that should be deduced from this analysis is to see whether McKesson Corp should reject or accept the proposed project, which will rely on the ability of the company to finance itself to remain profitable. The tables below show that McKesson Corp has a 3.04% after-tax cost of debt. Also, the table shows the cost of equity shown as 19.50%. The analysis utilized two approaches to determine the cost of equity: CAPM and Bond-yield-plus-premium. The WACC was found to be 5.5%, which is the highest because of the lower weighted debt.

4.1 – McKesson WACC % Calculation

The weighted average cost of capital is the amount that a company anticipates charging on average to all of the holders of its securities in order to fund its assets. The firm's cost of capital is another name for the WACC. In general, debt and equity are used to finance a company's assets. The WACC is the sum of the expenses of these funding sources, each of which is weighted according to how frequently it would be appropriate to employ them in a particular circumstance. The amount of interest the corporation is required to pay on each dollar of funding can be determined using a weighted average.

WACC= E / (E + D)* Cost of Equity + D / E + D)*Cost of Debt * (1 - Tax Rate)

Mostly because raising capital is costly. A corporation is making excess returns if it achieves a higher ROIC percentage than it costs it to raise the cash required for that investment. As growth accelerates, the value of a company that anticipates making positive surplus returns on new investments will rise, as opposed to a company that generates returns that fall short of its cost of capital and loses value over time.

4.2 (4.1.2) – Component Cost of Debt Estimation

The effective interest rate that a business pays on its debt, such as bonds and loans, is known as the cost of debt. The two primary elements of a company's capital structure are stock and debt. Calculating the cost of debt requires determining the average interest rate paid on all of a company's liabilities (Banerjee, 1999).

The cost of debt after tax shows that that interest is tax-deductible.

4.3 (4.1.3) – YTM –Yield to Maturity Approach

Based on a bond's current market price, the yield is determined using the Yield to Maturity formula. The yield to maturity is used by debt funds to calculate returns. However, it modifies in reaction to altering market conditions. The YTM of an open-ended Debt Fund differs from the scheme's real returns as a result in practice.

YTM = before tax cost of debt which is 3.07%.

Table 4.3 - YTM - Yield to Maturity Approach

Coupon

30%

Face Value

$260

Present value

$24,686,415

No of years

11

Yield to Maturity

18.18%








4.4 (4.1.4) – Before-Tax Component Cost of Debt

Cost of debt is the price incurred by a corporation when obtaining finance through debt instruments like taking out a bank loan or issuing bonds. It can be stated more simply as the actual interest rate a business pays on its present debt.

Pretax is equal to YTM, which is 3.07%. There are two ways to calculate the debt's before-tax cost: the yield-to-mature (YTM) strategy (Le, 2021).

4.5 (4.1.5) – After-Tax Component Cost of Debt

The interest paid on the loan less any income tax savings from deducting interest payments are the debt's after-tax costs. The cost of debt multiplied by the effective tax rate, which is divided by one, yields the cost of debt after taxes for a given company.

After-tax cost of debt = Before-tax cost of debt x (100% - incremental tax rate).

Table 4.5 - After-Tax Component Cost of Debt

Annual Interest Expense

$7,070,000,000.00

Total Debt

$217,000,000.00

Tax Rate

1.07%

Pretax Cost of Debt

3.07%

After-Tax Cost of Debt

3.04%

Preferred Stock

0.00%








4.6 (4.1.6) – Component Cost of Preferred Stock Estimation

Table 4.6 - Component Cost of Preferred Stock Estimation

Annual dividends

1.88

Current Share Price

326.19

Cost of Preferred Stock

1%





4.7 – CAPM Cost of Equity

The cost of equity using CAPM is calculated as

=Risk free-rate interest + Beta (expected return – risk free-rate of interest)

Table 4.8 – CAPM Cost of Equity

 

Risk-Free Rate of Interest

4%

equity beta

Expected Return

19.50%

Cost of Equity

19.50%



4.7.1(4.3) – Bond Yield plus Risk Premium Cost of Equity

Using the bond yield plus risk premium strategy, we can also estimate the value of an asset, in this case, the publicly traded stock of a corporation. By multiplying the yield to maturity of the company's long-term debt by the equity risk premium, BYPRP enables us to calculate the needed return on an equity.

Some auditors analyze the company’s cost of equity, which adds a judgment risk premium between 3% and 5% to the cost of debt. The cost of debt of McKesson Corp is 3.04%, risk premium of 4%

Table 4.7.1 - Bond-Yield-Plus-Risk-Premium

Cost of Debt

3.04%

Risk premium

4.00%

Cost of Equity

7.04%





4.7.2(4.4) – Average Cost of Equity

Cost of Equity = Risk-Free Rate of Return + Beta × (Market Rate of Return – Risk-Free Rate of Return).

The estimated cost that businesses should pay their shareholders when assessing existing investments and upcoming expenses is known as the "Average Cost of Equity."

Table 4.7.2 - Average Cost of Equity

CAPM

19.50%

Bond Yield Plus Risk Premium

7.04%

Average Cost of Equity

13.27%



4.7.3(4.5) – DCF Cost of Equity

In this case, the DFL was not applied in the calculation of cost of equity because McKesson Corporation does not pay dividends.

4.8 (4.6)– Weighted Average Cost of Capital (WACC)

WACC can be calculated using the following formula:

WACC= e (Market Weight of Common Equity)*(Average Cost of Equity) + (Market Weight of Debt) * (Cost of Debt) * (1 - Effective Tax Rate).

Table 4.9 - Weighted Average Cost of Capital

Weight of debt

83%

Preferred stock

0%

Cost of debt

3.04%

Market weight of the preferred stock

0%

The average cost of equity

13.27%

Weighted of equity

17%

Value of equity

1,446,000,000

Tax rate

1.07%

WACC

4.75%




5.0 – Cash Flow Estimation


We will review a new project that McKesson is considering to assess the Cash Flow Estimation. The project will run for 11 years and will require an initial $800 million investment in equipment and $35 million for shipping and installation costs. The fixed assets will fall in line with the 10-year MACRS depreciation and the salvage value will be 15% of the purchase price. The number of units expected to be sold is 2.5 million and the expected annual sales growth rate is 5%. The expected sales price is $318 per unit with an estimated variable cost of $268 per unit in the first year and the following years are adjusted with an estimated annual inflation rate of 8.3%. The required NOWC, or net operating working capital is 13.8% of sales. See tables below for more detail. The expected cash flow after 11 years is $XX million.

5.1 – Depreciation Basis

As stated above the project's initial investment is $800 million to purchase equipment, plus an additional $35 million for shipping and installation. The project’s depreciation basis is $835 million.

Table 5.1 – Depreciation Basis

Purchase Cost

$800,000,000

+ Shipping & Installation Cost

$35,000,000

Depreciation Basis

$835,000,000

Source calculated data: New Project Investment Scenario

5.2 Annual Depreciation of the New Project

Using the 10-year class of investment for MACRS depreciation percentages with an initial basis of $835 million, after 11 years the value falls to $27.4 million.

Table 5.2 Annual Depreciation Expense

Year

1

2

3

4

5

6

Initial Basis

$835,000,000

MACRS%

10.00%

18.00%

14.40%

11.52%

9.22%

7.37%

Depreciation

$83,500,000

$150,300,000

$120,240,000

$96,192,000

$76,987,000

$61,539,500

Year

7

8

9

10

11

Initial Basis

MACRS%

6.55%

6.55%

6.56%

6.55%

3.28%

Depreciation

$54,692,500

$54,692,500

$54,776,000

$54,692,500

$27,388,000

Source calculated data: New Project Investment Scenario


Table 5.2- Annual Depreciation Expense

Year

Initial Basis

MACRS

Depreciation

$835,000,000

10.00%

$ 83,500,000.00

$835,000,000

18.00%

$150,300,000.00

$835,000,000

14.40%

$120,240,000.00

$835,000,000

11.52%

$96,192,000.00

$835,000,000

9.22%

$76,987,000.00

$835,000,000

7.37%

$61,539,500.00

$835,000,000

6.55%

$54,692,500.00

$835,000,000

6.55%

$54,692,500.00

$835,000,000

6.56%

$54,776,000.00

10

$835,000,000

6.55%

$54,692,500.00

11

$835,000,000

3.28%

$27,388,000.00

Source calculated data: New Project Investment Scenario

5.3 Annual Cash Flow Estimate

Table 5.3.1 - Annual Sales and Costs

Year

Units

Unit Price

Unit Cost

Total Sales

Total Costs

2,500,000

$318

$268

$795,000,000

$670,000,000

2,625,000

$344

$290

$904,034,250

$761,890,500

2,756,250

$373

$314

$1,028,022,547

$866,383,782

2,894,063

$404

$340

$1,169,015,840

$985,208,318

3,038,766

$437

$369

$1,329,346,362

$1,120,329,639

3,190,704

$474

$399

$1,511,666,216

$1,273,982,849

3,350,239

$513

$432

$1,718,991,237

$1,448,709,596

3,517,751

$556

$468

$1,954,750,885

$1,647,400,117

3,693,639

$602

$507

$2,222,844,969

$1,873,341,043

10

3,878,321

$652

$549

$2,527,708,157

$2,130,269,767

11

4,072,237

$706

$595

$2,874,383,331

$2,422,436,266

Source calculated data New Project Investment Scenario

Table 5.3.2 Operating Cash Flows

Year

Sales

Costs

Depreciation

EBIT

Taxes

NOPAT

+ Depreciation

Net Op. CF

$ 795,000,000

$ 670,000,000

$ 83,500,000

$ 41,500,000

$ 8,715,000

$ 32,785,000

$ 83,500,000

$ 116,285,000

$ 904,034,250

$ 761,890,500

$ 150,300,000

$ (8,156,250)

$ (1,712,812)

$ (6,443,437)

$ 150,300,000

$ 143,856,563

$ 1,028,022,547

$ 866,383,782

$ 120,240,000

$ 41,398,765

$ 8,693,741

$ 32,705,025

$ 120,240,000

$ 152,945,025

$ 1,169,015,840

$ 985,208,318

$ 96,192,000

$ 87,615,522

$18,399,260

$ 69,216,262

$ 96,192,000

$ 165,408,262

$ 1,329,346,362

$ 1,120,329,639

$ 76,987,000

$132,029,724

$27,726,242

$ 104,303,482

$ 76,987,000

$ 181,290,482

$ 1,511,666,216

$ 1,273,982,849

$ 61,539,500

$176,143,867

$36,990,212

$ 139,153,655

$ 61,539,500

$ 200,693,155

$ 1,718,991,237

$ 1,448,709,596

$ 54,692,500

$215,589,141

$45,273,720

$ 170,315,421

$ 54,692,500

$ 225,007,921

$ 1,954,750,885

$ 1,647,400,117

$ 54,692,500

$252,658,268

$53,058,236

$ 199,600,032

$ 54,692,500

$ 254,292,532

$ 2,222,844,969

$ 1,873,341,043

$ 54,776,000

$294,727,926

$61,892,864

$ 232,835,062

$ 54,776,000

$ 287,611,062

10

$ 2,527,708,157

$ 2,130,269,767

$ 54,692,500

$342,745,889

$71,976,637

$ 270,769,253

$ 54,692,500

$ 325,461,753

11

$ 2,874,383,331

$ 2,422,436,266

$ 27,388,000

$424,559,065

$89,157,404

$ 335,401,661

$ 27,388,000

$ 362,789,661

Source calculated data: New Project Investment Scenario

Table 5.3.3 - Cash Flows due to Investments in Net Operating Working Capital (NOWC)

Year

Sales

NOWC (% of Sales)

CF due to Investment in NOWC

$ -

$ 109,710,000

$ (109,710,000)

$ 795,000,000

$ 124,756,727

$ (15,046,727)

$ 904,034,250

$ 141,867,112

$ (17,110,385)

$ 1,028,022,547

$ 161,324,186

$ (19,457,074)

$ 1,169,015,840

$ 183,449,798

$ (22,125,612)

$ 1,329,346,362

$ 208,609,938

$ (25,160,140)

$ 1,511,666,216

$ 237,220,791

$ (28,610,853)

$ 1,718,991,237

$ 269,755,622

$ (32,534,831)

$ 1,954,750,885

$ 306,752,606

$ (36,996,984)

$ 2,222,844,969

$ 348,823,726

$ (42,071,120)

10

$ 2,527,708,157

$ 396,664,900

$ (47,841,174)

11

$ 2,874,383,331

$ -

$ 396,664,900

Source calculated data: New Project Investment Scenario

5.4 – Timeline of Cash Flows




.














6.0 – Capital Budgeting Analysis


6.1 Capital Budgeting Analysis Techniques









6.2 Net Present Value 6.3 – Internal Rate of Return









6.4 Modified Internal Rate of Return

6.5 – Profitability Index




6.4 Payback Period and Discounted Payback Period 6.5 – Payback for Project 6.4 – Discounted Payback 6.5 – Sensitivity Analysis











7.0 – Project Recommendation


McKesson, as the biggest pharmaceutical distributor dominating performance over its peer industry players in years past, has had to weather the storm of its share of obstacles similar to that of its industry peers. In recent years, the impact of the global coronavirus epidemic shut and slowed down the global supply chain, stalled distribution, and forced systemic issues such as drug price deflation, inflation, as well as increased peer industry competition. The company’s efforts to streamline operations by divestment of assets that are not core and accelerating cost cuts as well as investment in strategic growth strategies of acquiring key assets that expanded or complemented their business structure has paid off by boosting revenue growth in 2022.

Taking into account McKesson’s financial health based our 5-year financial ratio analysis and benchmark comparison calculations; estimated capital structure and cost of debt; and calculated WACC, our team was analyzed McKesson’s position to take on an investment in a new project that could strategically grow revenue and generate a positive return on investment. With a revenue growth strategy that effectively managed its assets, the company has produced a positive ROI of 4.04% percent and operating ROA of 4.04% percent in 2022. These results compare well with industry peers ABC and CAH, but do reflect that careful consideration should be taken when investing in new projects. However, with McKesson’s dominance in the industry, a new investment project would do well to continue to boost its lead in the industry above its peers. (UPDATE with results of WACC, cashflow forecasts, NPV and future NPV, and sensitivity analysis)





References


Banerjee, S., Heshmati, A., & Wihlborg, C. (1999). The dynamics of capital structure. New York University-Salomon Center-Leonard N. Stern School of Business. 

Bragg, S. (2022, May 28). Financial ratio analysis. AccountingTools. Retrieved 22–07-13, from https://www.accountingtools.com/articles/financial-ratio-analysis.html

Calrson, R. (2020, November 11). What Is Financial Ratio Analysis? The Balance Small Business. Retrieved July 14, 2022, from https://www.thebalancesmb.com/what-is-financial-ratio-analysis-393186

D&B Hoovers. (2022). D&B Hoovers. McKesson Corporation. Retrieved June 29, 2022, from https://app-avention-com.ruby.uhv.edu/company/business/databases/d-b-hoovers

Exley, C. J., & Smith, A. D. (2006). The cost of capital for financial firms. British Actuarial Journal, 12(1), 229-283. 

Frank, M. Z., & Shen, T. (2016). Investment and the weighted average cost of capital. Journal of Financial Economics, 119(2). https://doi.org/10.1016/j.jfineco.2015.09.001

GoCardless. (2021, January 13). What is financial ratio analysis? Retrieved July 13, 2022, from https://gocardless.com/en-us/guides/posts/what-is-financial-ratio-analysis/

Le, H. T. T., Vo, X. V., & Vo, T. T. (2021). Accruals quality and the cost of debt: Evidence from Vietnam. International Review of Financial Analysis | Vol 76 | Retrieved June 30, 2022, from https://www.sciencedirect.com/journal/international-review-of-financial-analysis/vol/76/suppl/C 

Merchant Online. (2022). Merchant Online. McKesson Corporation. Retrieved June 29, 2022, from https://app-avention-com.ruby.uhv.edu/company/business/databases/merchent

Pettit, J. (2003). Healthcare Cost of Capital Handbook. Available at SSRN:  https://ssrn.com/abstract=463020 

Staff, F. (2022, May 21). McKesson. Fortune. Retrieved July 10, 2022, from https://fortune.com/company/mckesson/fortune500/ 





Appendix

Annual Income Statement (Standardized)

Financials In: USD

Millions

Except for share items (millions and per share items (actual units)

 

31-Mar-2022

31-Mar-2021

31-Mar-2020

31-Mar-2019

31-Mar-2018

Period Length

12 Months

12 Months

12 Months

12 Months

12 Months

UpdateDate

Filed 09-May-2022

Filed 09-May-2022

Filed 09-May-2022

Filed 12-May-2021

Filed 22-May-2020

Filed Currency

USD

USD

USD

USD

USD

Exchange Rate (Period Average)

Auditor

Deloitte & Touche LLP

Deloitte & Touche LLP

Deloitte & Touche LLP

Deloitte & Touche LLP

Deloitte & Touche LLP

Auditor Opinion

Unqualified

Unqualified with Explanation

Unqualified with Explanation

Unqualified

Unqualified

 

 

 

Operating Revenue

263,966

238,228

231,051

214,319

208,357

Total Revenue

263,966

238,228

231,051

214,319

208,357

Cost of Revenue

250,836

226,080

219,028

202,565

197,173

Gross Profit

13,130

12,148

12,023

11,754

11,184

Selling, General and Administrative Expenses

10,537

8,849

9,182

8,437

8,138

Research and Development

-

-

-

-

125

Total Operating Expense

10,537

8,849

9,182

8,437

8,263

Operating Income

2,593

3,299

2,841

3,317

2,921

Interest Income - Non-Operating

10

12

49

39

48

Interest Expense - Non-Operating

178

217

249

264

283

Net Non-Operating Interest Income (Expense)

(168)

(205)

(200)

(225)

(235)

Restructuring and M&A

245

219

156

352

530

Impairment of Capital Assets

36

184

114

2,042

1,738

Gain on Sale of Business

-

-

-

56

152

Other Special Charges

460

7,936

209

37

122

Special Income (Charges)

(741)

(8,339)

(479)

(2,375)

(2,238)

Gain on Sale of Security

141

181

53

66

32

Earnings from Equity Interest

-

-

(1,108)

(194)

(248)

Other Non-Operating Income (Expenses)

103

30

37

21

7

Other Income (Expense)

(497)

(8,128)

(1,497)

(2,482)

(2,447)

Income Before Tax

1,928

(5,034)

1,144

610

239

31-Mar-2022

31-Mar-2021

31-Mar-2020

31-Mar-2019

31-Mar-2018

Total Income Tax

636

(695)

18

356

(53)

Income After Tax

1,292

(4,339)

1,126

254

292

Net Income from Continuing Operations

1,292

(4,339)

1,126

254

292

Discontinued Operations

(5)

(1)

(6)

1

5

Minority Interest

(173)

(199)

(220)

(221)

(230)

Net Income

1,114

(4,539)

900

34

67

Net Income Available to Common Stockholders

1,114

(4,539)

900

34

67

Basic EPS

7

(28)

5

0

0

Basic EPS from Continuing Operations

7

(28)

5

0

0

Basic EPS from Discontinued Operations

(0)

-

(0)

-

0

Diluted EPS

7

(28)

5

0

0

Diluted EPS from Continuing Operations

7

(28)

5

0

0

Diluted EPS from Discontinued Operations

(0)

-

(0)

-

0

Basic Average Shares

152

161

181

196

208

Diluted Average Shares

154

161

182

197

209

Interest Income

10

12

49

39

48

Interest Expense

178

217

249

264

283

Net Interest Income

(168)

(205)

(200)

(225)

(235)

Net Income Including Non-Controlling Interests

1,287

(4,340)

1,120

255

297

Net Income from Continuing and Discontinued Operations

1,114

(4,539)

900

34

67

Normalized Income

1,521

2,494

1,325

1,719

1,778

Basic EPS from Continuing & Discontinued Operations

7

(28)

5

0

0

Diluted EPS from Continuing & Discontinued Operations

7

(28)

5

0

0

Dividends per Share

2

2

2

2

1

Net Income Before Extraord Items

1,119

(4,538)

906

33

62

Total Unusual Items

(600)

(8,158)

(426)

(2,309)

(2,206)

Total Unusual Items Excluding Goodwill

(600)

(8,158)

(426)

(2,309)

(2,206)

Tax Rate

0

0

0

0

0

Tax Effect of Unusual Items

(198)

(1,126)

(7)

(623)

(490)

Basic Normalized EPS

10

16

7

9

9

Diluted Normalized EPS

10

16

7

9

9

31-Mar-2022

31-Mar-2021

31-Mar-2020

31-Mar-2019

31-Mar-2018

EBITDA

2,866

(3,930)

2,315

1,823

1,473

Normalized EBITDA

3,466

4,228

2,741

4,132

3,679

Reconciled Cost of Revenue

250,836

226,080

219,028

202,565

197,173

Reconciled Depreciation

760

887

922

949

951

EBIT

2,106

(4,817)

1,393

874

522

© 2022 Morningstar. All Rights Reserved.

Published by Dun & Bradstreet, Inc., July 2022.

Annual Balance Sheet (Standardized)

Financials In: USD

Millions

Except for share items (millions and per share items (actual units)

 

31-Mar-2022

31-Mar-2021

31-Mar-2020

31-Mar-2019

31-Mar-2018

Update Date

Filed 09-May-2022

Filed 09-May-2022

Filed 09-May-2022

Filed 12-May-2021

Filed 22-May-2020

Filed Currency

USD

USD

USD

USD

USD

Exchange Rate

Auditor

Deloitte & Touche LLP

Deloitte & Touche LLP

Deloitte & Touche LLP

Deloitte & Touche LLP

Deloitte & Touche LLP

Auditor Opinion

Unqualified

Unqualified with Explanation

Unqualified with Explanation

Unqualified

Unqualified

 

 

 

Cash and Cash Equivalents

3,532

6,278

4,015

2,981

2,672

Cash, Cash Equivalents and Short-Term Investments

3,532

6,278

4,015

2,981

2,672

Accounts Receivable

16,438

17,106

17,201

14,941

14,349

Other Receivables

2,289

2,325

3,014

3,584

3,578

Receivables Adjustments

(144)

(250)

(265)

(279)

(216)

Total Receivables

18,583

19,181

19,950

18,246

17,711

Total Inventory

18,702

19,246

16,734

16,709

16,310

Assets Held For Sale - Current

4,516

12

906

-

-

Prepaid Assets

898

665

617

529

443

Total Current Assets

46,231

45,382

42,222

38,465

37,136

Land and Improvements

104

156

151

172

187

Buildings and Improvements

1,331

1,745

1,604

4,154

3,746

Machinery and Equipment

2,338

2,512

2,308

-

-

Construction in Progress

313

382

131

-

-

Other Property/Plant/Equipment

1,548

2,100

1,886

-

-

Property/Plant/Equipment - Gross

5,634

6,895

6,080

4,326

3,933

Accumulated Depreciation

(1,994)

(2,214)

(1,829)

(1,778)

(1,469)

Property/Plant/Equipment - Net

3,640

4,681

4,251

2,548

2,464

Goodwill

9,451

9,493

9,360

9,358

10,924

Other Intangible Assets

2,059

2,878

3,156

3,689

4,102

Goodwill and Other Intangible Assets

11,510

12,371

12,516

13,047

15,026

Investments in Joint Ventures at Cost

-

-

-

3,513

3,728

Long-Term Equity Investments

-

-

-

3,513

3,728

Long-Term Investments

-

-

-

3,513

3,728

Other Long-Term Assets

1,917

2,581

2,258

2,099

2,027

Total Non-Current Assets

17,067

19,633

19,025

21,207

23,245

Total Assets

63,298

65,015

61,247

59,672

60,381

31-Mar-2022

31-Mar-2021

31-Mar-2020

31-Mar-2019

31-Mar-2018

Accounts Payable

38,086

38,975

37,195

33,853

32,177

Payables

38,086

38,975

37,195

33,853

32,177

Accrued Expenses

4,543

3,987

3,340

3,443

3,379

Other Short-Term Borrowings

799

742

1,052

330

-

Current Debt

799

742

1,052

330

1,129

Current Capital Lease Obligation

297

390

354

-

-

Current Debt and Capital Lease Obligation

1,096

1,132

1,406

330

1,129

Other Current liabilities

4,741

9

683

-

-

Total Current Liabilities

48,466

44,103

42,624

37,626

36,685

Long-Term Debt

5,080

6,406

6,335

7,265

6,751

Long-Term Capital Lease Obligation

1,366

1,867

1,660

-

-

Long-Term Debt and Capital Lease Obligation

6,446

8,273

7,995

7,265

6,751

Deferred Taxes - Non-Current Liabilities

1,418

1,411

2,255

2,998

2,804

Non-Current Deferred Liabilities

1,418

1,411

2,255

2,998

2,804

Other Long-Term Liabilities

8,760

9,782

1,662

2,103

2,625

Total Non-Current Liabilities

16,624

19,466

11,912

12,366

12,180

Total Liabilities

65,090

63,569

54,536

49,992

48,865

Common Stock

2

2

2

3

3

Capital Stock

2

2

2

3

3

Retained Earnings (Accumulated Deficit)

9,030

8,202

13,022

12,409

12,986

Additional Paid-In Capital

7,275

6,925

6,663

6,435

6,188

Treasury Stock

(17,045)

(13,670)

(12,892)

(8,902)

(7,655)

Gains (Losses) Not Affecting Retained Earnings

(1,534)

(1,480)

(1,703)

(1,849)

(1,717)

Other Equity

-

-

-

(2)

(1)

Stockholders' Equity

(2,272)

(21)

5,092

8,094

9,804

Minority Interest

480

1,467

1,619

1,586

1,712

Total Equity

(1,792)

1,446

6,711

9,680

11,516

Total Liabilities and Shareholders’ Equity

63,298

65,015

61,247

59,672

60,381

Net Tangible Assets

(13,782)

(12,392)

(7,424)

(4,953)

(5,222)

Working Capital

(2,235)

1,279

(402)

839

451

Invested Capital

3,607

7,127

12,479

15,689

17,684

31-Mar-2022

31-Mar-2021

31-Mar-2020

31-Mar-2019

31-Mar-2018

Capital Lease Obligations

1,663

2,257

2,014

-

-

Total Debt

7,542

9,405

9,401

7,595

7,880

Net Debt

2,347

870

3,372

4,614

5,208

Total Capitalization

2,808

6,385

11,427

15,359

16,555

Common Stock Equity

(2,272)

(21)

5,092

8,094

9,804

Total Common Shares Outstanding

145

158

162

190

202

Treasury Shares Number

130

115

110

81

73

Shares Issued

275

273

272

271

275

Tangible Book Value

(13,782)

(12,392)

(7,424)

(4,953)

(5,222)

Employees

75,000

76,000

80,000

80,000

78,000

© 2022 Morningstar. All Rights Reserved.

Published by Dun & Bradstreet, Inc., July 2022.

Annual Cash Flows (Standardized)

Financials In: USD

Millions

Except for share items (millions and per share items (actual units)

 

31-Mar-2022

31-Mar-2021

31-Mar-2020

31-Mar-2019

31-Mar-2018

Period Length

12 Months

12 Months

12 Months

12 Months

12 Months

Update Date

Filed 09-May-2022

Filed 09-May-2022

Filed 09-May-2022

Filed 12-May-2021

Filed 22-May-2020

Filed Currency

USD

USD

USD

USD

USD

Exchange Rate (Period Average)

Auditor

Deloitte & Touche LLP

Deloitte & Touche LLP

Deloitte & Touche LLP

Deloitte & Touche LLP

Deloitte & Touche LLP

Auditor Opinion

Unqualified

Unqualified with Explanation

Unqualified with Explanation

Unqualified

Unqualified

Net Income from Continuing Operations

1,287

(4,340)

1,120

255

297

Gain (Loss) on Sale of Business

(132)

(9)

33

(86)

(169)

Equity in Net Earnings (Loss)

-

-

1,084

194

248

Operating Gains (Losses)

(132)

(9)

1,117

108

79

Depreciation

279

321

321

317

303

Amortization of Intangibles

481

566

601

632

648

Amortization

481

566

601

632

648

Depreciation and Amortization

760

887

922

949

951

Depreciation, Amortization and Depletion

760

887

922

949

951

Deferred Income Tax

34

(908)

(342)

189

(868)

Deferred Taxes

34

(908)

(342)

189

(868)

Asset Impairment Charge

175

242

139

2,079

2,217

Other Non-Cash Items

2,228

484

729

(90)

10

Receivables

(1,843)

1,145

(2,494)

(967)

1,175

Inventories

(1,169)

(2,276)

(376)

(368)

(458)

Payables

2,802

1,267

3,952

1,976

271

Payables/Accrued

2,802

1,267

3,952

1,976

271

Other Current Liabilities

(157)

7,705

(377)

-

-

Other Working Capital

449

345

(16)

(95)

671

Changes in Working Capital

82

8,186

689

546

1,659

Cash from Operating Activities

4,434

4,542

4,374

4,036

4,345

31-Mar-2022

31-Mar-2021

31-Mar-2020

31-Mar-2019

31-Mar-2018

Capital Expenditure

(147)

(190)

(144)

(131)

(175)

Purchase of Property/Plant/Equipment

(388)

(451)

(362)

(426)

(405)

Net Purchase (Sale) of Property/Plant/Equipment

(388)

(451)

(362)

(426)

(405)

Acquisition of Business

(6)

(35)

(133)

(905)

(2,893)

Sale of Business

578

400

37

101

500

Net Acquisition (Sale) of Business

572

365

(96)

(804)

(2,393)

Other Investing Cash Flow

(126)

(139)

23

(20)

(20)

Cash from Investing Activities

(89)

(415)

(579)

(1,381)

(2,993)

Short-Term Debt Issued

11,192

6,323

21,437

37,265

20,542

Short-Term Debt Reduction

(11,192)

(6,323)

(21,437)

(37,268)

(20,725)

Short-Term Debt, Net

-

-

-

(3)

(183)

Long-Term Debt Issued

498

500

-

1,099

1,522

Long-Term Debt Reduction

(1,648)

(1,040)

(298)

(1,112)

(2,287)

Long-Term Debt, Net

(1,150)

(540)

(298)

(13)

(765)

Issuance (Retirement) of Debt, Net

(1,150)

(540)

(298)

(16)

(948)

Sale/Issuance of Common

220

92

113

75

132

Repurchase/Retirement of Common

(3,516)

(742)

(1,934)

(1,639)

(1,709)

Common Stock, Net

(3,296)

(650)

(1,821)

(1,564)

(1,577)

Total Cash Dividends Paid

(277)

(276)

(294)

(292)

(262)

Other Financing Cash Flow

(1,598)

(227)

(321)

(355)

(297)

Cash from Financing Activities

(6,321)

(1,693)

(2,734)

(2,227)

(3,084)

Other Cash Adjustment Inside Change in Cash

(540)

-

-

-

-

Net Cash - Beginning Balance

6,396

4,023

2,981

2,672

4,254

Net Change in Cash

(2,516)

2,434

1,061

428

(1,732)

Foreign Exchange Effects

55

(61)

(19)

(119)

150

Net Cash - Ending Balance

3,935

6,396

4,023

2,981

2,672

Capital Expenditures

(535)

(641)

(506)

(557)

(580)

Issuance of Capital Stock

220

92

113

75

132

Total Debt Issued

11,690

6,823

21,437

38,364

22,064

31-Mar-2022

31-Mar-2021

31-Mar-2020

31-Mar-2019

31-Mar-2018

Total Debt Reduction

(12,840)

(7,363)

(21,735)

(38,380)

(23,012)

Repurchase of Capital Stock

(3,516)

(742)

(1,934)

(1,639)

(1,709)

Cash Taxes Paid

359

379

368

262

144

Cash Interest Paid

186

220

235

383

298

Free Cash Flow

3,899

3,901

3,868

3,479

3,765

© 2022 Morningstar. All Rights Reserved.

Published by Dun & Bradstreet, Inc., July 2022.