PRACTICE QUESTION 1 PT.1: From Coca-Cola’s 10k you have the following information. Prepare a common size...
|
PRACTICE QUESTION 1 PT.1: From Coca-Cola’s 10k you have the following information. Prepare a common size balance sheet. SHOW YOUR WORK! Balance Sheet 2019 2018 2019 2018 (in millions) Common Common Size % ? Size %? Long term debt 27,516 28,782 _______ _______ Other liabilities 37,787 35,376 _______ _______ Total Liabilities 65,283 64,158 _______ _______ Total Equity 21,098 19,058 _______ _______ |
||||
PRACTICE QUESTION 1 PT. 2: Prom the following information, extracted the following from Coca Cola’s 10-K, prepare an indexed comparison of the years. SHOW YOUR WORK!
(In millions)
Year Ended December 31, 2019 2018 2017 2016 2015
Net operating revenues 37,266 34,300 36,212 41,863 44,294
Index number _____ _____ _____ _____ _____
Homework Answers
Answer
1
| Common size | ||||
| Particulars | 2019 | 2018 | 2019 | 2018 |
| Long term debt | $ 27,516 | $ 28,782 | 31.9% | 34.6% |
| Other liabilities | $ 37,787 | $ 35,376 | 43.7% | 42.5% |
| Total liabilities | $ 65,283 | $ 64,158 | 75.6% | 77.1% |
| Total equity | $ 21,098 | $ 19,058 | 24.4% | 22.9% |
| Total liabilities and equity | $ 86,381 | $ 83,216 | 100.0% | 100.0% |
Long term debt
2019=27,516/86,831=31.95
2018=28,782/83,216=34.6%
Other liabilities
2019=37,787/86,831
2018=35376/83216
Total liabilities
2019=65283/86381
2018=64158/83216
Total equity
2019=21,098/86381
2018=19,058/83,216
Same formula is used for others.
2
Index number 100 is assumed to be appointed to 2015 Revenue
Index number for 2016=Base index number*2016 Revenue/2015 Revenue
=100*41,863/44,294
Index number for 2016=94.51
Index number for 2017=Base index number*Revenue 2017/Revenue 2015
=100*36,212/44,294
Index number for 2017=81.75
Index number for 2018=Base index number*Revenue 2018/Revenue 2015
=100*34,300/44,294
Index number for 2018=77.44
Index number for 2019=Base index number*Revenue 2019/Revenue 2015
=100*37,266/44,294
Index number for 2019=84.13
Add Answer to:
PRACTICE QUESTION 1 PT.1: From Coca-Cola’s 10k you have the
following information. Prepare a common size...
Prom the following information, extracted the following from Coca Cola's 10-K, prepare an indexed comparison of...
Prom the following information, extracted the following from Coca Cola's 10-K, prepare an indexed comparison of the years. (In millions) Year Ended December 31, 2019 2018 2017 2016 2015 Net operating revenues 37,266 34,300 36,212 41,863 44,294 Index number
Bethesda Mining Company reports the following balance sheet information. Prepare the 2018 and 2019 common-size balance...
Bethesda Mining Company reports the following balance sheet information. Prepare the 2018 and 2019 common-size balance sheets for the company. (Do not round Intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) 2019 BETHESDA MINING COMPANY Balance Sheets as of December 31, 2018 and 2019 2018 Assets Current assets Cash 21,182 Accounts receivable 51,036 Inventory 120.589 Total 192,807 Fixed assets Net plant and equipment $ 775,925 Total assets $ 968,732 $ Liabilities and...
Were the dividends on common stock and/or preferred stock? What was the amount of each? Did...
Were the dividends on common stock and/or preferred stock? What
was the amount of each?
Did Retained Earnings change for any reasons other than net
income or dividends? Explain.
What classes of stock does your company have?
How many shares of each class of stock are authorized, how many
are issued, and how many are outstanding?
Does your company have any treasury stock? How many shares and
what dollar amount?
What is the par or stated value of each of...
Questions: What was the $value of gross trade receivables for 2019 and 2018? What was the...
Questions: What was the $value of gross trade receivables for
2019 and 2018?
What was the receivables turnover for 2019?
Compute the changes in cash, cash equivalents and receivables
from 2018 to 2019.
Please indicate the sheet the answer same from than you so
much.
THE COCA-COLA COMPANY AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF INCOME (In millions except per share data) 2019 2018 2017 S 37,266 14,619 22,647 12,103 34,300 $ 13,067 21,233 11,002 1,079 9,152 689 950 36,212 13,721 22,491...
Project The required tasks are detailed below: (1) Prepare vertical common-size income statements and balance sheets...
Project The required tasks are detailed below: (1) Prepare vertical common-size income statements and balance sheets for both companies. Note: Use "Total Sales" and "Total Assets" as the denominators for income statement and balance sheet, respectively. Compute for 2018, 2017, and 2016. (2) Prepare horizontal analysis on income statements and balance sheets for both companies. (3) Prepare ratio analyses (for 2018, 2017, and 2016) for both companies. You should include the following ratios in your computations: Profitability ratios o Gross...
Prom the following information, extracted the following from Coca Cola's 10-K, prepare an indexed comparison of the years. (In millions) Year Ended December 31, 2019 2018 2017 2016 2015 Net operating revenues 37,266 34,300 36,212 41,863 44,294 Index number
Bethesda Mining Company reports the following balance sheet information. Prepare the 2018 and 2019 common-size balance sheets for the company. (Do not round Intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) 2019 BETHESDA MINING COMPANY Balance Sheets as of December 31, 2018 and 2019 2018 Assets Current assets Cash 21,182 Accounts receivable 51,036 Inventory 120.589 Total 192,807 Fixed assets Net plant and equipment $ 775,925 Total assets $ 968,732 $ Liabilities and...
Were the dividends on common stock and/or preferred stock? What
was the amount of each?
Did Retained Earnings change for any reasons other than net
income or dividends? Explain.
What classes of stock does your company have?
How many shares of each class of stock are authorized, how many
are issued, and how many are outstanding?
Does your company have any treasury stock? How many shares and
what dollar amount?
What is the par or stated value of each of...
Questions: What was the $value of gross trade receivables for
2019 and 2018?
What was the receivables turnover for 2019?
Compute the changes in cash, cash equivalents and receivables
from 2018 to 2019.
Please indicate the sheet the answer same from than you so
much.
THE COCA-COLA COMPANY AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF INCOME (In millions except per share data) 2019 2018 2017 S 37,266 14,619 22,647 12,103 34,300 $ 13,067 21,233 11,002 1,079 9,152 689 950 36,212 13,721 22,491...
Project The required tasks are detailed below: (1) Prepare vertical common-size income statements and balance sheets for both companies. Note: Use "Total Sales" and "Total Assets" as the denominators for income statement and balance sheet, respectively. Compute for 2018, 2017, and 2016. (2) Prepare horizontal analysis on income statements and balance sheets for both companies. (3) Prepare ratio analyses (for 2018, 2017, and 2016) for both companies. You should include the following ratios in your computations: Profitability ratios o Gross...
Most questions answered within 3 hours.
-
Assume Kw = 1.01 ✕ 10−14
For pure water, we can calculate [H3O+ ] = [OH...
asked 38 minutes ago -
Suppose that on a temperature scale X, water boils at 203.0°X
and freezes at -105.7°X. What...
asked 1 hour ago -
BaS crystallizes in a cubic unit cell with S2- ions on each
corner and each face....
asked 1 hour ago -
A. 0≤P(Oi)≤10≤P(Oi)≤1 for each i
B. P(Oi)≤0P(Oi)≤0
C. P(Oi)=1+P(OCi)P(Oi)=1+P(OiC)
D. P(Oi)≥1P(Oi)≥1
If an experiment consists of...
asked 3 hours ago -
A battery has an emf of 9.20V and an internal resistance of 1.20
ohm. a)What resistance...
asked 3 hours ago -
The area of an elastic circular loop decreases at a constant
rate, dA/dt = −6.60×10−3 m2/s...
asked 4 hours ago -
The denaturation of proteins can be described by the
equilibrium
F⇌U
where F and U represent...
asked 6 hours ago -
Please answer what the maximum and minimum force is, and the
angle on the ion is...
asked 6 hours ago -
implement a program that reads a number of rows and a symbol.
The program will draw...
asked 6 hours ago -
Assume that when adults with smartphones are randomly selected,
45% use them in meetings or classes....
asked 6 hours ago -
Determine the number of formula units of
Na2SO4 and moles of oxygen contained in 8.11
moles...
asked 6 hours ago -
Explain in steps on the following code
What would be the output when executed
using System;...
asked 6 hours ago