Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

Analyzing Coca-Cola's Financials: Balance Sheet & Dividend Discount Models, Study notes of Financial Statement Analysis

An analysis of Coca-Cola's financial statements, focusing on the valuation of marketable securities, fixed assets, and intangible assets like brand name using problems from a financial textbook. It also covers the calculation of financial ratios such as current ratio, quick ratio, and operating income, and discusses the impact of advertising expenses on financial statements.

Typology: Study notes

2021/2022

Uploaded on 09/27/2022

explain
explain 🇺🇸

4

(2)

230 documents

1 / 5

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
CHAPTER 3
UNDERSTANDING FINANCIAL STATEMENTS
Problem 1
a. Marketable securities are valued at book or market, whichever is lower. Hence
marketable securities are probably assessed at close to market value. Near-cash must
also be close to market value. Cash, of course, by definition is at market value.
b. Fixed Assets are valued at historical cost. Hence they were probably purchased for
the gross book value of fixed assets, i.e. 5486+199 = $5685.
From the value of $2016 for accumulated depreciation, we see that about 36.75% of
the value of the depreciable fixed assets has been written off in depreciation. Hence, if
we can assume that Coca-Cola uses straight-line depreciation, about two-fifths of the
life of the estimated life of these assets is over. If we know the average life of assets
in this industry, we can use that to estimate the age of these assets.
c. There are several reasons why current assets are more prominent in Coca-Cola’s
balance sheet than fixed assets. One, there is a large amount of cash and near-cash:
this might be due to impending expansion, perhaps investment in bottling operations.
Two, the Other Assets item includes investment in other Coca-Cola companies,
which are primarily manufacturing operations, such as bottlers. Hence, if the fixed
assets and current assets parts of these investments were included, the ratio of fixed
to current assets would probably be larger.
d. Even though the companies were sold off, Coca-Cola presumably still has some
ownership stake in these companies. To the extent that Coca-Cola does not have a
majority stake in these companies, they would not be consolidated into Coca-Cola’s
balance sheet. If these companies were primarily manufacturing companies, their
relatively large fixed-asset structure would not appear on Coca-Cola’s balance sheet
anymore.
Problem 2
pf3
pf4
pf5

Partial preview of the text

Download Analyzing Coca-Cola's Financials: Balance Sheet & Dividend Discount Models and more Study notes Financial Statement Analysis in PDF only on Docsity!

CHAPTER 3

UNDERSTANDING FINANCIAL STATEMENTS

Problem 1 a. Marketable securities are valued at book or market, whichever is lower. Hence marketable securities are probably assessed at close to market value. Near-cash must also be close to market value. Cash, of course, by definition is at market value. b. Fixed Assets are valued at historical cost. Hence they were probably purchased for the gross book value of fixed assets, i.e. 5486+199 = $5685. From the value of $2016 for accumulated depreciation, we see that about 36.75% of the value of the depreciable fixed assets has been written off in depreciation. Hence, if we can assume that Coca-Cola uses straight-line depreciation, about two-fifths of the life of the estimated life of these assets is over. If we know the average life of assets in this industry, we can use that to estimate the age of these assets. c. There are several reasons why current assets are more prominent in Coca-Cola’s balance sheet than fixed assets. One, there is a large amount of cash and near-cash: this might be due to impending expansion, perhaps investment in bottling operations. Two, the Other Assets item includes investment in other Coca-Cola companies, which are primarily manufacturing operations, such as bottlers. Hence, if the fixed assets and current assets parts of these investments were included, the ratio of fixed to current assets would probably be larger. d. Even though the companies were sold off, Coca-Cola presumably still has some ownership stake in these companies. To the extent that Coca-Cola does not have a majority stake in these companies, they would not be consolidated into Coca-Cola’s balance sheet. If these companies were primarily manufacturing companies, their relatively large fixed-asset structure would not appear on Coca-Cola’s balance sheet anymore.

Problem 2

a. Total interest-bearing debt would equal short-term borrowings plus long-term borrowings, i.e. 4462+687 = 5149m. b. The paid-up capital represents the amount that Coca-Cola originally obtained for the equity that it issued. This amount equals $3060m. c. The larger the amount of time that has elapsed since the equity was originally issued, the greater the proportion of shareholder equity that would be represented by Retained Earnings, particularly for a firm that has plowed back a lot of its earnings into its operations. d. The book value of equity is $8.403 billion, which is much less than the market value of $140 billion. This is because a large portion of Coca-Cola’s market value is the present value of future growth and branc name value. This is not reflected in the book value.

Problem 3 Coca-Cola’s brand name value does not appear in its balance sheet. Even though there is an item called “Non-depreciable Fixed Assets,” it is too small, and cannot represent the brand name value; it’s probably land. One way to adjust the balance sheet to reflect the value of this asset is for Coca-Cola to set up a separate subsidiary that would buy the rights to the brand name. The brand name value would then show up as an asset for the subsidiary, which would then be reflected in Coca-Cola’s balance sheet as well, even if the financial statements were consolidated.

Problem 4 a. The net working capital equals the difference between Current Assets and Current Liabilities, i.e. 6380 - 8640 = - 2260. Non-cash working capital removes Cash and Near Cash from the Current Assets computation and interest-bearing short-term borrowings from the liabilities side. This gives us - 2260 - 1648 + 4462 = 554.

eight years ago would be amortized this period, with one-tenth remaining unamortized, and so on. Let us assume that it is the end of 2000, and we wish to compute the capitalized value of Advertising for 2000 Year expenditure incurred

Amount of Advertising expenditures to be included in Capitalized Advertising Asset for 2000

Amount Amortized this year

Problem 7 The effective tax rate in 1997 was 1926/(5001-258+1312) = 31.81%, while the same quantity for 1998 was 1665/(4967-277+508) = 32.03%, which is almost the same. The difference may reflect differences between the tax and reporting books.

Problem 8 The pre-tax operating margin for 1997 was 5001/18868 or 26.51%, while the number for 1998 was 4967/18813 or 26.40%

The after-tax operating margin was (5001-1926)/18868 = 16.30% for 1997, and (4967- 1665)/18813 or 17.55% for 1998, using actual taxes paid. If we use the marginal tax rate, then the net margin is 26.51(1-0.3181) = 18.08% for 1997, and 26.4(1-0.3203) = 17.94% for 1998. The margins look very similar in both years. There are no strong conclusions you can draw about profitability.

Problem 9 a. The return on equity is defined as Net Income/Book Value of Equity. Using beginning of 1998 value of equity, this was 3533/7274 = 48.57% b. The pre-tax return on capital equals EBIT/Total Capital = 4967/(7274+3875) = 44.55% c. The after-tax return on capital equals 44.55(1-0.3203) = 30.28%

Problem 10 a. The book value of equity at the end of 1999 would be, in millions

Book Value of equity, end of 1998

Less Share repurchase 400 Add Net Income for 1999 150 Less Dividends Paid

Book Value, end of 1999 1200 b. The return on equity, using beginning book value equals 150/1500 = 10% c. The return on equity, using average book value of equity = 150x2/(1500 + 1200) = 11.11%