Reflection Paper (stages 3 of the project)

Financial Research Project 21





Financial Research Project

Student’s Name

Institutional Affiliation

Background and Industry

Campbell Soup Company is also known as Campbell’s. The company is based in the United States. It is involved in the canning of soup and other related products. The company deals with provision of soups, snacks and beverages. Most of its income however comes from the sale of soup. The company has currently managed to sell its products in over 120 countries. The company is in the food processing industry. The company has been operations since 1869.

Common Size Analysis

Campbell Soup

Income Statement (Values in Millions)

Period Ending:

7/31/2016

8/2/2015

8/3/2014

Total Revenue

$7,961,000

100%

$8,082,000

100%

$8,268,000

100%

Cost of Revenue

$5,181,000

65%

$5,300,000

66%

$5,297,000

64%

Gross Profit

$2,780,000

35%

$2,782,000

34%

$2,971,000

36%

Operating Expenses

Research and Development

$124,000

2%

$117,000

1%

$122,000

1%

Sales, General and Admin.

$1,665,000

21%

$1,509,000

19%

$1,527,000

18%

Non-Recurring Items

$31,000

0%

$102,000

1%

$55,000

1%

Other Operating Items

$0

0%

$0

0%

$0

0%

Operating Income

$960,000

12%

$1,054,000

13%

$1,267,000

15%

Add'l income/expense items

$4,000

0%

$3,000

0%

$3,000

0%

Earnings Before Interest and Tax

$964,000

12%

$1,057,000

13%

$1,270,000

15%

Interest Expense

$115,000

1%

$108,000

1%

$122,000

1%

Earnings Before Tax

$849,000

11%

$949,000

12%

$1,148,000

14%

Income Tax

$286,000

4%

$283,000

4%

$374,000

5%

Minority Interest

$0

0%

$0

0%

$11,000

0%

Equity Earnings/Loss Unconsolidated Subsidiary

$0

0%

$0

0%

$0

0%

Net Income-Cont. Operations

$563,000

7%

$666,000

8%

$774,000

9%

Net Income

$563,000

7%

$666,000

8%

$866,000

10%

Campbell Soup

Balance Sheet (Values in 000's)

Period Ending:

7/31/2016

8/2/2015

8/3/2014

Current Assets

Cash and Cash Equivalents

$296,000

4%

$253,000

3%

$232,000

3%

Short-Term Investments

$0

0%

$0

0%

$0

0%

Net Receivables

$626,000

8%

$647,000

8%

$670,000

8%

Inventory

$940,000

12%

$995,000

12%

$1,016,000

13%

Other Current Assets

$46,000

1%

$198,000

2%

$182,000

2%

Total Current Assets

$1,908,000

24%

$2,093,000

26%

$2,100,000

26%

Long-Term Assets

Long-Term Investments

$0

0%

$0

0%

$0

0%

Fixed Assets

$2,407,000

31%

$2,347,000

29%

$2,318,000

29%

Goodwill

$2,263,000

29%

$2,344,000

29%

$2,433,000

30%

Intangible Assets

$1,152,000

15%

$1,205,000

15%

$1,175,000

14%

Other Assets

$107,000

1%

$88,000

1%

$87,000

1%

Deferred Asset Charges

$0

0%

$0

0%

$0

0%

Total Assets

$7,837,000

100%

$8,077,000

100%

$8,113,000

100%

Current Liabilities

Accounts Payable

$1,336,000

17%

$1,263,000

16%

$1,218,000

15%

Short-Term Debt / Current Portion of Long-Term Debt

$1,219,000

16%

$1,543,000

19%

$1,771,000

22%

Other Current Liabilities

$0

0%

$0

0%

$0

0%

Total Current Liabilities

$2,555,000

33%

$2,806,000

35%

$2,989,000

37%

Long-Term Debt

$2,314,000

30%

$2,539,000

31%

$2,244,000

28%

Other Liabilities

$1,039,000

13%

$850,000

11%

$729,000

9%

Deferred Liability Charges

$396,000

5%

$505,000

6%

$548,000

7%

Misc. Stocks

$0

0%

$0

0%

$0

0%

Minority Interest

$8,000

0%

($4,000)

0%

($12,000)

0%

Total Liabilities

$6,312,000

81%

$6,696,000

83%

$6,498,000

80%

Stock Holders’ Equity

Common Stocks

$12,000

0%

$12,000

0%

$12,000

0%

Capital Surplus

$354,000

5%

$339,000

4%

$330,000

4%

Retained Earnings

$1,927,000

25%

$1,754,000

22%

$2,198,000

27%

Treasury Stock

($664,000)

-8%

($556,000)

-7%

($356,000)

-4%

Other Equity

($104,000)

-1%

($168,000)

-2%

($569,000)

-7%

Total Equity

$1,525,000

19%

$1,381,000

17%

$1,615,000

20%

Total Liabilities & Equity

$7,837,000

100%

$8,077,000

100%

$8,113,000

100%

The company has been going through some tough times. This is evidence by the fact that the percentage of the net income since 2014 has been declining. The company had a net income percentage of 10% in 2014, 8% in 2015 and 7% in 2016. The company’s costs of goods sold does not have the same percentage changes as the net income. The company’s operating costs have been increasing over the last three years. This evident from the constant decrease of the earnings before interest and tax. It is therefore clear that the company needs to control its costs especially the operating costs in order to maintain its profitability.

The balance sheet does not show any issues that raises any concern. The company has maintained small changes in all its accounts. The changes in the percentage value of the accounts changes with a slight one percent change. There are no large changes that can cause concern. The major change in comparison to the rest is the decrease of the retained earnings of the company in 2015 and an increase in 2016 which is a good sign. There percentage of the total liabilities on the three-year period is high. The company has around 80% of its assets being financed by liability (White, Braentner & Towery, 1993). 

The income statement mainly raises concern on the decrease in the company’s profitability. The company is also being financed too much by debt which can be risky. From the interest expense however, it is clear that the company can comfortably be able to pay off its debt. The company is stable enough and can be able to pay of its debt. The company needs to make its profitability to be stable in positive and not negative growth.

Percentage Change Analysis

Campbell Soup

Income Statement (Values in Millions)

Period Ending:

7/31/2016

Percent Increase (Decrease)

8/2/2015

Percent Increase (Decrease)

8/3/2014

Total Revenue

$7,961,000

-4%

$8,082,000

-2%

$8,268,000

Cost of Revenue

$5,181,000

-2%

$5,300,000

0%

$5,297,000

Gross Profit

$2,780,000

-6%

$2,782,000

-6%

$2,971,000

Operating Expenses

Research and Development

$124,000

2%

$117,000

-4%

$122,000

Sales, General and Admin.

$1,665,000

9%

$1,509,000

-1%

$1,527,000

Non-Recurring Items

$31,000

-44%

$102,000

85%

$55,000

Other Operating Items

$0

$0

$0

Operating Income

$960,000

-24%

$1,054,000

-17%

$1,267,000

Add'l income/expense items

$4,000

33%

$3,000

0%

$3,000

Earnings Before Interest and Tax

$964,000

-24%

$1,057,000

-17%

$1,270,000

Interest Expense

$115,000

-6%

$108,000

-11%

$122,000

Earnings Before Tax

$849,000

-26%

$949,000

-17%

$1,148,000

Income Tax

$286,000

-24%

$283,000

-24%

$374,000

Minority Interest

$0

-100%

$0

-100%

$11,000

Equity Earnings/Loss Unconsolidated Subsidiary

$0

$0

$0

Net Income-Cont. Operations

$563,000

-27%

$666,000

-14%

$774,000

Net Income

$563,000

-35%

$666,000

-23%

$866,000

Campbell Soup

Balance Sheet (Values in 000's)

Period Ending:

7/31/2016

Percent Increase (Decrease)

8/2/2015

Percent Increase (Decrease)

8/3/2014

Current Assets

Cash and Cash Equivalents

$296,000

28%

$253,000

9%

$232,000

Short-Term Investments

$0

$0

$0

Net Receivables

$626,000

-7%

$647,000

-3%

$670,000

Inventory

$940,000

-7%

$995,000

-2%

$1,016,000

Other Current Assets

$46,000

-75%

$198,000

9%

$182,000

Total Current Assets

$1,908,000

-9%

$2,093,000

0%

$2,100,000

Long-Term Assets

Long-Term Investments

$0

$0

$0

Fixed Assets

$2,407,000

4%

$2,347,000

1%

$2,318,000

Goodwill

$2,263,000

-7%

$2,344,000

-4%

$2,433,000

Intangible Assets

$1,152,000

-2%

$1,205,000

3%

$1,175,000

Other Assets

$107,000

23%

$88,000

1%

$87,000

Deferred Asset Charges

$0

$0

$0

Total Assets

$7,837,000

-3%

$8,077,000

0%

$8,113,000

Current Liabilities

Accounts Payable

$1,336,000

10%

$1,263,000

4%

$1,218,000

Short-Term Debt / Current Portion of Long-Term Debt

$1,219,000

-31%

$1,543,000

-13%

$1,771,000

Other Current Liabilities

$0

$0

$0

Total Current Liabilities

$2,555,000

-15%

$2,806,000

-6%

$2,989,000

Long-Term Debt

$2,314,000

3%

$2,539,000

13%

$2,244,000

Other Liabilities

$1,039,000

43%

$850,000

17%

$729,000

Deferred Liability Charges

$396,000

-28%

$505,000

-8%

$548,000

Misc. Stocks

$0

$0

$0

Minority Interest

$8,000

-167%

($4,000)

-67%

($12,000)

Total Liabilities

$6,312,000

-3%

$6,696,000

3%

$6,498,000

Stock Holders’ Equity

Common Stocks

$12,000

0%

$12,000

0%

$12,000

Capital Surplus

$354,000

7%

$339,000

3%

$330,000

Retained Earnings

$1,927,000

-12%

$1,754,000

-20%

$2,198,000

Treasury Stock

($664,000)

87%

($556,000)

56%

($356,000)

Other Equity

($104,000)

-82%

($168,000)

-70%

($569,000)

Total Equity

$1,525,000

-6%

$1,381,000

-14%

$1,615,000

Total Liabilities & Equity

$7,837,000

-3%

$8,077,000

0%

$8,113,000

As 2014 as the base year, the trend that can be seen from the analysis above is a poor one. The company’s sales have reduced over the last two years. In 2015 the decrease was 2% and in 2016 the decrease was 4%. This raises concern that the company’s market share has been reducing over the years. The company need to carry out marketing activities that are meant to increase its revenues.

The company has increased some of its expenses and reduced others. The company in 2016 increased its expenditure in research and development. The company increased its expenditure on sales, general and administration. The percentage increase is 9% which is worrying. Despite the company reducing its revenues, it accrued a lot of operating expenses and thus there was huge decrease in the company’s operating income in 2016 in comparison to 2014 (White, Braentner & Towery, 1993). 

The company’s current assets reduced considerably in 2016 in comparison to 2014. The company decreased the amount of short-term debt that it took in 2016 and 2015. The company’s total liabilities however slightly reduced by 3% in 2016 while in 2015 it had increased with the same percentage. The company tried to reduce its debt financing. Equity financing also reduced its more in 2015 and less in 2016. The company’s value of its total assets and the equity and liabilities amount reduced by 3%.

Financial Ratio Analysis

Financial Ratio Analysis

Ratio

2016

2015

2014

Current Ratio

75%

75%

70%

Quick Ratio

38%

39%

36%

Days Inventory

68.09

69.48

65.97

Receivables Turnover

13.45

13.17

12.67

Gross Profit Margin

35%

34%

36%

Net Profit Margin

7%

8%

10%

ROA

7.07%

8.53%

9.95%

ROE

37%

48%

54%

Reflection Paper (stages 3 of the project) 1

In the above ratio analysis, two ratios are used to determine the liquidity of the company. These are the current ratio and quick ratio. The current ratio is the ratio of a company’s current assets to its current liabilities. The quick ratio is the ratio of a company’s most liquid asset which include current assets less inventory to its current liabilities. the ratios are used to show the ability of a company to meets its short-term liabilities using its current assets. The company has low liquidity. This is a problem as the company will have difficulty when paying for its obligations. The company needs to increase the money that it takes from operations and increase its accounts receivable. The company has been able to maintain its liquidity over the last year with small differences between the years. Its quick ratio increased slightly in 2015 but decreased slightly in 2016.

The profitability ratio that were used in this scenario were the gross margin ratio and net margin. The gross profit margin ratio is a ratio of gross profit to revenues. The net margin ratio is a ratio of net income to total revenues. The company’s gross margin decreased slightly in 2015 and increased in 2016. The company’s net margin ratio has however been decreasing since 2014. The difference between the ratios is a clear sign that the company accrues too much operating costs and its operating costs have been increasing over the last 3 years. The company’s profitability has reduced which is a sign that the company should reduce its expenses and increase its revenues for it to increase its growth (Bodie, 2013). 

The days inventory turnover shows the period of time it takes for the company’s inventory to be sold. The company takes around 60 days to sell its inventory. This is a long time which the company has to maintain its inventory. this leaves chances of loss of inventory due to storage. The receivables turnover ratio is used to determine the ability of a company in managing its account receivables. The company receives its account receivable about 13 times per year. This means that the company collects accounts receivable in less than a month. The company however needs to improve in order to improve its liquidity.

Return on Assets (ROA), is a ratio of net income to total assets. Return on Equity (ROE), is the ratio of net income to total equity. The returns on investment has been reducing over the last three years. The company needs to improve on its net earnings through increasing its revenues and reducing its expenses. An increase in its net earnings will in turn increase the return on the investment made by the company. the company needs to generate more earnings from the assets that it as (Bodie, 2013). 

In order to improve the company’s Cash Conversion Cycle (CCC), the company needs to convince their suppliers to increase the period of time within which the company is expected to meet its obligations. These would increase the time that accounts payable are settled. The management would also need to reduce the period of time that the customers takes to pay the company. this can be done by giving the customers incentive such as discounts for them to pay within a shorter period of time. The company would also need to send invoices to the customers within a short period of time (Lewis, 2017).

The company would also need to improve its efficiency. The company should improve its efficiency in the billing and invoicing process. These will contribute to faster time for the company to receive the cash that is owed to it. The company also needs to manage its inventory. The company should manage its inventory such as it does not keep too much inventory. inventory ties up capital for a long period of time.

Return on Equity

ROE = Net profit margin x Total assets turnover x Equity multiplier

2016

Net profit Margin = 7%

Total Asset Turnover = 1.02

Equity Multiplier = 5.14

= 7% * 1.02 * 5.14

=36.70%

2015

Net profit Margin = 8%

Total Asset Turnover = 1.00

Equity Multiplier = 5.85

= 8% * 1.00 * 5.85

= 46.8%

2014

Net profit Margin = 10%

Total Asset Turnover = 1.02

Equity Multiplier = 5.02

= 10% * 1.02 * 5.02

= 51.20%

DuPont Analysis is of the view that the return on equity is affected by three aspects. The first is the net margin, the second is the asset turnover ratio which in this we use the total asset turnover and the third is the equity multiplier.

The company’s return on assets has been deteriorating over the three years. The company’s net margin can be seen to be the most troubled aspect of the company. In 2014, the net margin was 10% and yet by 2016 the company had a net margin ratio of 7%. The company’s operations need to improve. The company’s net margin has been decreasing over the last three years. The company needs to work on its operations (Wahlen, Baginski & Bradshaw, 2014). 

The company can work on its operations by increasing its revenues through carrying out more marketing in order for the product to reach more of their customers. The company also needs to reduce its expenses. In this case, the company should try to increase its operating activities. By reducing the expenses and increasing the revenues, the company will achieve better net margin ratio.

References

Bodie, Z. (2013). Investments. McGraw-Hill.

Lewis, J., (2017). How Can a Company Shorten Its Cash Cycle? Hearst Newspapers, LLC.

Wahlen, J., Baginski, S., & Bradshaw, M. (2014). Financial reporting, financial statement analysis and valuation. Nelson Education.

White, B., Braentner, L., & Towery, E. (1993). Financial Statement Analysis. New York: Wiley.