ACC 318 Module Three Assignment
docx
keyboard_arrow_up
School
Southern New Hampshire University *
*We aren’t endorsed by this school
Course
318
Subject
Accounting
Date
Apr 3, 2024
Type
docx
Pages
2
Uploaded by DrAlpaca4232
ACC 318 Module Three Assignment Template
Complete this template by replacing the bracketed text with the relevant information.
Operating Activities
1.
Identify the method of computing net cash
provided by each company's operating activities.
The Coca-Cola Company and PepsiCo, inc. utilize the indirect method for computing net cash for operating activities. 2.
Calculate the amounts of cash
provided by operating activities reported by each company in 2020.
The amount of cash for PepsiCo, Inc., provided by operating activities is $10,613,000.
The amount of cash for The Coca-Cola Company, provided by operating activities is $9,844,000.
3.
Explain the two companies’ trends in net cash provided by operating activities over the period 2018 to 2020. PepsiCo, Inc.:
From 2018-2020 the trend in net cash provided by operating activities has increased. In 2018, the net cash was $9,415,000. In 2019, the net cash increased to $9,649,000. For the year 2020, it
increased close to a million with $10,613,000. However, in the year 2020, the company didn’t receive net tax related to the TCJ Act or any income regarding net tax benefits related to international reorganizations. My interpretation of this is due to the Covid-19 pandemic. The Coca-Cola Company:
From the year 2018-2020, the trend in net cash provided by operating activities is different from
PepsiCo, Inc. The company's net cash from operation reached its peak in 2019 with $10,471,000.
For the year 2018, the net cash was reported as $7,627,000. Then in 2020, the net cash decreased from $10,471,000 to $9,844,000.
Investing Activities
1.
Identify the most significant item
in the investing activities section reported by each company in
2020.
PepsiCo, Inc.: The most significant item in investing activities reported was Acquisitions, net of cash acquired, and investments in noncontrolled affiliates with a total paid out of $6,372,000.
The Coca-Cola Company: The most significant item in investing activities reported was proceeds from disposals of investments with a total cash inflow of $13,835,000.
Financing Activities
1.
Identify the most significant item
in the financing activities section
reported by each company in
2020.
PepsiCo, Inc.: The most significant item in financing activities reported was proceeds from issuances of long-term debt with a total cash inflow of $13,809,000.
The Coca-Cola Company: The most significant item in financing activities reported was payments of debt with a total cash outflow of $28,796,000.
Depreciation and Amortization
1.
Identify what activity
would depreciation and amortization be reported on in each company’s statement of cash flow using the indirect method.
Depreciation and amortization would be reported under operating activities of the statement of cash flows using the indirect method.
2.
Explain why each company reported on depreciation and amortization where they did in their statement of cash flows.
Both companies reported depreciation and amortization directly under net income/consolidated
net income in the operating activities section of the statement of cash flows. The reason the company reported depreciation and amortization here is because this account is an expense, which takes away from net income but does not take away from both companies' actual cash amount.
3.
Identify the amount of depreciation and amortization for each company.
PepsiCo. Inc: $2,548,000
The Coca-Cola Company: $1,536,000
Statement of Cash Flows and Ratios
1.
Compute the current cash debt coverage for each company.
PepsiCo. Inc:
current cash debt coverage = 4.47
The Coca-Cola Company:
current cash debt coverage = 0.67
2.
Compute the
cash debt coverage for each company.
PepsiCo. Inc
: cash debt coverage = 0.13
The Coca-Cola company:
current cash debt coverage = 0.14
3.
Explain what conclusions can be drawn from the current cash debt coverage ratio and the cash debt coverage ratio. Address the following questions in your response:
A.
What conclusions can be drawn from the current cash debt coverage ratio?
B.
What conclusions can be drawn from the cash debt coverage ratio?
A.
Regarding the current cash debt coverage ratio, PepsiCo. Inc. can cover its current debt 4.47 times over. PepsiCo is in a financially stable condition for current cash to debt. The Coca-
Cola company, however, cannot even cover its current debt 1 times over since the ratio is less than 1. Regarding their current financial condition, they have more liabilities than cash inflow.
B.
In terms of current and long-term liabilities, The Coca-Cola company is in a better financial situation than PepsiCo Inc. However, not by much. The Coca-Cola Company is only higher by one and both companies cannot cover total liabilities with their current cash inflow.
References
Include any references used to complete this assignment. This section is for the full citation. Sources should be cited using APA style.
John Wiley & Sons, Inc. (2022). Intermediate Accounting
(18th ed.). Wiley.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Documents
Related Questions
21
arrow_forward
Don't give answer in image format
arrow_forward
Highlight the Net cash provided by Operating Activities for the Statement of Cash Flows
Highlight the Net cash provided by Financing Activities for the Statement of Cash Flows
Highlight the net change in cash for the period on the Statement of Cash Flows
arrow_forward
Extract from the statement of financial position as at 30 June 2021
30 June 2021
30 June 2020
R
R
Inventories
302 000
292 000
Trade receivables
690 000
720 000
Trade payables
400 000
385 000
Taxation payable
75 000
60 000
Prepaid expenses
8 000
2 000
Accrued expenses
84 000
88 000
Required:
Prepare only the "Cash generated by operations" section of the statement of cash flows
for the year ended 30 June 2021, using the indirect method
arrow_forward
Could you please explain to me how the cash balances are calculated????
Pro Forma Cash Flow
Cash Received
Cash from Operations
Cash Sales
$24,198
$100,099
$122,460
Cash from Receivables
$46,108
$217,218
$342,905
Subtotal Cash from Operations
$70,306
$317,317
$465,366
Additional Cash Received
Sales Tax, VAT, HST/GST Received
$0
$0
$0
New Current Borrowing
$0
$0
$0
New Other Liabilities (interest-free)
$0
$0
$0
New Long-term Liabilities
$0
$40,000
$0
Sales of Other Current Assets
$0
$0
$0
Sales of Long-term Assets
$0
$0
$0
New Investment Received
$0
$0
$0
Subtotal Cash Received
$70,306
$357,317
$465,366
Expenditures
Year 1
Year 2
Year 3
Expenditures from Operations
Cash Spending
$167,000
$225,200
$229,200
Bill Payments
$75,294
$124,114
$152,785
Subtotal Spent on Operations
$242,294
$349,314
$381,985
Additional Cash Spent
Sales Tax, VAT, HST/GST Paid Out
$0
$0
$0…
arrow_forward
Calculate cash balances based on the information provided in the chart below and show me how you did it
Pro Forma Cash Flow
Cash Received
Cash from Operations
Cash Sales
$24,198
$100,099
$122,460
Cash from Receivables
$46,108
$217,218
$342,905
Subtotal Cash from Operations
$70,306
$317,317
$465,366
Additional Cash Received
Sales Tax, VAT, HST/GST Received
$0
$0
$0
New Current Borrowing
$0
$0
$0
New Other Liabilities (interest-free)
$0
$0
$0
New Long-term Liabilities
$0
$40,000
$0
Sales of Other Current Assets
$0
$0
$0
Sales of Long-term Assets
$0
$0
$0
New Investment Received
$0
$0
$0
Subtotal Cash Received
$70,306
$357,317
$465,366
Expenditures
Year 1
Year 2
Year 3
Expenditures from Operations
Cash Spending
$167,000
$225,200
$229,200
Bill Payments
$75,294
$124,114
$152,785
Subtotal Spent on Operations
$242,294
$349,314
$381,985
Additional Cash Spent
Sales Tax,…
arrow_forward
Please do not give solution in image format thanku
arrow_forward
Complete the statement of cash flows for Year 2021 using the indirect method by filing in the spaces.
arrow_forward
Section V: SCF Question 3
Identify the following sections of the McDonald's SCF and record the amounts. Check
the math by summing to the cash balance at end of year. Verify that the ending cash
balance reported on the SCF is the same as reported on the balance sheet for the current
year,
Section
Current
Prior Year
Second
Prior Year
Year
Cash provided by operations?
Click here to
Click here to
Click here to
enter text.
enter text.
enter text.
Cash used for investing activities?
Click here to
Click here to
Click here to
enter text.
enter text.
enter text.
Cash used for financing activities?
Click here to
Click here to
Click here to
enter text.
enter text.
enter text.
Cash and equivalents balance at end of
year?
Click here to
Click here to
Click here to
enter text.
enter text.
enter text.
D Focus
lish (United States)
arrow_forward
Question 13
Prepare a statement of cash flows in good form assuming that Avatar Company uses the indirect method.
Please refer to the following information for the year 2021.
Avatar Company
Balance Sheet
December 31, 2021
2021
2020
Change
Cash
$21,000
$18,000
$3,000
Accounts receivable
31,000
35,000
(4,000)
Inventory
53,000
25,000
28,000
Property, Plant & Equipment (net)
120,000
90,000
30,000
Total assets
$225,000
$168,000
$57,000
Accounts payable
$4,000
$6,000
$(2,000)
Accrued liabilities
2,000
1,000
1,000
Long-term notes payable
84,000
90,000
(6,000)
Total liabilities
$90,000
$97,000
$(7,000)…
arrow_forward
23. Help me selecting the right answer. Thank you
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning

Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning

Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning

Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Related Questions
- 21arrow_forwardDon't give answer in image formatarrow_forwardHighlight the Net cash provided by Operating Activities for the Statement of Cash Flows Highlight the Net cash provided by Financing Activities for the Statement of Cash Flows Highlight the net change in cash for the period on the Statement of Cash Flowsarrow_forward
- Extract from the statement of financial position as at 30 June 2021 30 June 2021 30 June 2020 R R Inventories 302 000 292 000 Trade receivables 690 000 720 000 Trade payables 400 000 385 000 Taxation payable 75 000 60 000 Prepaid expenses 8 000 2 000 Accrued expenses 84 000 88 000 Required: Prepare only the "Cash generated by operations" section of the statement of cash flows for the year ended 30 June 2021, using the indirect methodarrow_forwardCould you please explain to me how the cash balances are calculated???? Pro Forma Cash Flow Cash Received Cash from Operations Cash Sales $24,198 $100,099 $122,460 Cash from Receivables $46,108 $217,218 $342,905 Subtotal Cash from Operations $70,306 $317,317 $465,366 Additional Cash Received Sales Tax, VAT, HST/GST Received $0 $0 $0 New Current Borrowing $0 $0 $0 New Other Liabilities (interest-free) $0 $0 $0 New Long-term Liabilities $0 $40,000 $0 Sales of Other Current Assets $0 $0 $0 Sales of Long-term Assets $0 $0 $0 New Investment Received $0 $0 $0 Subtotal Cash Received $70,306 $357,317 $465,366 Expenditures Year 1 Year 2 Year 3 Expenditures from Operations Cash Spending $167,000 $225,200 $229,200 Bill Payments $75,294 $124,114 $152,785 Subtotal Spent on Operations $242,294 $349,314 $381,985 Additional Cash Spent Sales Tax, VAT, HST/GST Paid Out $0 $0 $0…arrow_forwardCalculate cash balances based on the information provided in the chart below and show me how you did it Pro Forma Cash Flow Cash Received Cash from Operations Cash Sales $24,198 $100,099 $122,460 Cash from Receivables $46,108 $217,218 $342,905 Subtotal Cash from Operations $70,306 $317,317 $465,366 Additional Cash Received Sales Tax, VAT, HST/GST Received $0 $0 $0 New Current Borrowing $0 $0 $0 New Other Liabilities (interest-free) $0 $0 $0 New Long-term Liabilities $0 $40,000 $0 Sales of Other Current Assets $0 $0 $0 Sales of Long-term Assets $0 $0 $0 New Investment Received $0 $0 $0 Subtotal Cash Received $70,306 $357,317 $465,366 Expenditures Year 1 Year 2 Year 3 Expenditures from Operations Cash Spending $167,000 $225,200 $229,200 Bill Payments $75,294 $124,114 $152,785 Subtotal Spent on Operations $242,294 $349,314 $381,985 Additional Cash Spent Sales Tax,…arrow_forward
- Please do not give solution in image format thankuarrow_forwardComplete the statement of cash flows for Year 2021 using the indirect method by filing in the spaces.arrow_forwardSection V: SCF Question 3 Identify the following sections of the McDonald's SCF and record the amounts. Check the math by summing to the cash balance at end of year. Verify that the ending cash balance reported on the SCF is the same as reported on the balance sheet for the current year, Section Current Prior Year Second Prior Year Year Cash provided by operations? Click here to Click here to Click here to enter text. enter text. enter text. Cash used for investing activities? Click here to Click here to Click here to enter text. enter text. enter text. Cash used for financing activities? Click here to Click here to Click here to enter text. enter text. enter text. Cash and equivalents balance at end of year? Click here to Click here to Click here to enter text. enter text. enter text. D Focus lish (United States)arrow_forward
- Question 13 Prepare a statement of cash flows in good form assuming that Avatar Company uses the indirect method. Please refer to the following information for the year 2021. Avatar Company Balance Sheet December 31, 2021 2021 2020 Change Cash $21,000 $18,000 $3,000 Accounts receivable 31,000 35,000 (4,000) Inventory 53,000 25,000 28,000 Property, Plant & Equipment (net) 120,000 90,000 30,000 Total assets $225,000 $168,000 $57,000 Accounts payable $4,000 $6,000 $(2,000) Accrued liabilities 2,000 1,000 1,000 Long-term notes payable 84,000 90,000 (6,000) Total liabilities $90,000 $97,000 $(7,000)…arrow_forward23. Help me selecting the right answer. Thank youarrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage LearningIntermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage LearningCornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
- Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning

Financial Accounting: The Impact on Decision Make...
Accounting
ISBN:9781305654174
Author:Gary A. Porter, Curtis L. Norton
Publisher:Cengage Learning

Intermediate Accounting: Reporting And Analysis
Accounting
ISBN:9781337788281
Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach
Publisher:Cengage Learning

Cornerstones of Financial Accounting
Accounting
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Cengage Learning

Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning