JWI530_Week 4 Discussion
docx
keyboard_arrow_up
School
Strayer University *
*We aren’t endorsed by this school
Course
JWI 530
Subject
Finance
Date
Feb 20, 2024
Type
docx
Pages
3
Uploaded by ndcanova
Week 4 Discussion
Cash Flow Statement Analysis
This week we turn to the last of the major financial statements – the Cash Flow Statement.
Note: We want to encourage a rich exchange of information and ideas in this discussion. Please select a Cash Flow Statement line item or ratio based on the first letter of your last name as indicated below.
1.
Locate and post a screen shot of an actual Cash Flow Statement from the latest fiscal year for one of the following companies:
Medtronic
ExxonMobil
Your own Company (or any company you choose)
I selected to analyze ExxonMobil for this post (1).
2.
Pick a Cash Flow Statement line item or ratio from the following list:
Select from Here if Your Last Name
Starts with A-M
Line Item
Select from Here if Your Last Name
Starts with N-Z
Ratio
Net Change in Cash
Cash Flow from Operations
Cash Flow from Investing
Cash Flow from Financing
Capital Expenditures
Dividends Paid
Proceeds from Long Term Debt
Cash Flow Return on Assets
Dividend Payout Ratio
Cap Ex to Depreciation Ratio
Free Cash Flow
I picked to display Cash Flow from Operations (listed as Cash Flows from Operating Activities) on ExxonMobil’s Statement of Cash Flows.
3.
What does this line item or ratio measure and why is it important for Management to understand this number?
The line item – Cash Flow from Operations – measures the operating activities
of the business which excludes investments and financial activities (2).
4.
From the Cash Flow Statement, identify the past 4 years of amounts for your line item or ratio. Share this data with the class using a data table or chart.
Table 1
ExxonMobil Consolidated Statement of Cash Flows
Cash Flows from Operating Activities
2022
2021
2020
2019
Net cash provided by operating activities
76,797
48,129
14,668
29,716
5.
Answer the following questions:
What is the trend for this line item or ratio? The trend is for an increase in cash provided by operating activities.
Has the line item or ratio amount increased or decreased? The line item increased. However, there were some shifts to net cash by operating activities as the below notes indicate (1):
2. Russia In response to Russia’s military action in Ukraine, the Corporation announced in early 2022 that it planned to discontinue operations on the Sakhalin-1 project (“Sakhalin”) and develop steps to exit the venture. In light of this, an impairment assessment was conducted, and management determined that the carrying value of the asset group was not recoverable. As a result, the Corporation’s first-quarter earnings included after-
tax charges of $ 3.4 billion largely representing the full impairment of its operations related to Sakhalin. 9. Property, Plant and Equipment and Asset Retirement Obligations In 2022, the Corporation identified situations where events or changes in circumstances indicated that the carrying value of certain long-lived assets may not be
recoverable and conducted impairment assessments. 5. Cash Flow Information The Consolidated Statement of Cash Flows provides information about changes in cash
and cash equivalents. Highly liquid investments with maturities of three months or less
when acquired are classified as cash equivalents. For 2022, the “Net (gain)/loss on asset sales” on the Consolidated Statement of Cash Flows includes before-tax amounts
from the sale of certain unproved assets in Romania and unconventional assets in Canada and the United States, as well as other smaller divestments. For 2021, the “Net
(gain)/loss on asset sales” line includes before-tax amounts from the sale of non-
operated upstream assets in the United Kingdom Central and Northern North Sea and the sale of ExxonMobil's global Santoprene business. For 2020, the “Depreciation and depletion” and “Deferred income tax charges/(credits)” on the Consolidated Statement of Cash Flows include impacts from asset impairments, primarily in Upstream.
19. Income and Other Taxes
Additional European Taxes on the Energy Sector. On October 6, 2022, European Union (“EU”) Member States adopted an EU Council Regulation which, along with other measures, introduced a new tax described as an emergency intervention to address high energy prices. This regulation imposed a mandatory tax on certain companies active in the crude petroleum, coal, natural gas, and refinery sectors.
Is this a “good" or a “bad” thing for this company?
The increase in net cash is a good thing for the company as it shows the company is managing money well.
What might management do to improve this line item or ratio?
Management might continue to look for other tax incentives as well as other adjustments in their day-to-day operations.
References:
1.
ExxonMobil SEC filings
2.
Accounting Coach
Assignment 1A References:
1.
Planet Fitness 10K 2022
2.
Life Time Fitness 10K 2022
3.
JWI530. Financial Ratios Reference GUIDE
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
Assignment 1: TIME VALUE OF MONEY
Objective: To further understand the concept of the time value of money.
INSTRUCTIONS:
In each problem,
a. Translate data given in problems into their respective graphical representations - i.e. draw
the correct cash flow diagram.
b. Write down all pertinent given information or data on your paper.
c. Calculate answers correctly.
5. A 45-year-old person wants to accumulate $750,000 by age 70. How much will she need
to save each month, starting one month from now, if the interest rate is 0.5% per month?
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
Questions are attached in the screenshot below
greatly appreciate the hlep
thanks
@%12512oo
o--
arrow_forward
Hello teacher please help me this question solution
arrow_forward
Balance Sheet. Use Table 3.2 on page 82 as a guide to create a monthly balance sheet
arrow_forward
Please do not give solution in image format thanku
arrow_forward
help please answer in text form with proper workings and explanation for each and every part and steps with concept and introduction no AI no copy paste remember answer must be in proper format with all working
arrow_forward
question 9
arrow_forward
Please explain it properly
arrow_forward
Options
purhcases
cash disbursements
sales
cash receipts
general
arrow_forward
Personal Financial Statement Project
For the Personal Financial Statement Project:
1. Record the events on the next page in the accompanying
formula worksheet
2. Write out the journal entries for the events on the next page
3. Create the financial statements with the ending information
from the worksheet
4. Once you have your Financial Statements completed,
please make a comment or two in the online text input box
about what the information is telling you
Event List
1. Opened a bank account with previously earned (retained
earnings) money for $100,000
2. Bought a house by paying $75,000 down in cash and taking a
loan of $225,000
3. Bought a vehicle by paying $1,000 down in cash and taking a
loan of $44,000
4. Worked (performed services) to clients for $80,000 cash
5. Paid for materials used (expense) in the services performed
with cash for $50,000
6. Paid for repairs and utilities of the house and vehicle (just
regular expenses) with cash for $8,500
7. During the year, you paid $5,000…
arrow_forward
Question 2
Jordan Inc is trying to prepare a cash reconciliation for the month ended January 31, 2024. At that date,
Jordan's books report a balance of $81,673 in their CIBC Chequing Account, and the balance on their
January bank statement is $107,876. Jordan provides you with (1) the General Ledger which shows all
the changes in the cash account during the year, and (2) a copy of the January bank statement.
CIBC Chequing Account
Description
Opening balance
Payment on account (cheque #1348)
Date
Jan 1
Jan 5
Jan 10
Jan 10
Jan 15
Jan 15
Jan 20
Jan 25
Jan 25
Jan 27
Jan 30
Jan 31
Jan 31
BUS285
Date
January 1
January 1
January 4
January 5
January 11
January 11
Jordan Inc.
General Ledger
Month ended January 31, 2024
Cash out Interac machine
Bank deposit
January 12
January 14
January 15
January 15
January 21
January 25
January 27
January 27
January 31
Interac purchase - Tim Hortons
Transfer to credit card payable
Cash out Interac machine
Payment on account (cheque #1349)
Bank deposit
CIBC…
arrow_forward
January February March Sales $100,000 $121,000 $165,000 Manufacturing costs 42,000 52,000 59,000 Selling and administrative expenses 29,000 33,000 36,000 Capital expenditures 40,000 The
company expects to sell about 15% of its merchandise for cash. Of sales on account, 65% are expected to be collected in full in the month following the sale and the remainder the following month.
Depreciation, insurance, and property tax expense represent $8,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in June, and the annual property taxes are paid
in October. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month. All sales and administrative
expenses are paid in the month incurred. Current assets as of January 1 include cash of $38,000, marketable securities of $54,000, and accounts receivable of $116,000 ($88,000 from December sales
and $28,000 from November…
arrow_forward
Question:
Imagine you are the finance manager of Al Mohsin Company. The company management feels that the
cash management of the company should be made more effective. The following information from the
company's records is available to you:
Miscellaneous
Month
Sales
Purchase
Wages
expenses
February
7,000
8,000
40,000
20,000
1,000
March
55,000
14,000
3,000
April
Мay
28,000
30,000
9,000
2,000
2,000
60,000
74,000
9,000
June
90,000
32,000
8,800
3,500
Additional Information
1. Al Mohsin LLC expects to have RO 8,000 cash balance at the beginning of April.
2. Period of credit allowed by suppliers – 2 months
3. 40% of the total sale is for cash. Half of the credit sale is collected in the next month of sale and
the remaining half in the following month after that.
4. Delay in payment of wages 1/4 month
5. Delay in payment of expenses 1/2 month
6. Income tax to be paid in the month of June RO 1,500.
You are required to :
a. Prepare an estimate of cash position for three months from April to…
arrow_forward
Please do not give solution in image format thanku
arrow_forward
please help me provide complete and correct answer for all requirements with all working for all parts answer in text please answer correct please remember answer all requirements or skip /leave for other expert thanks million thanks
arrow_forward
Please help me
arrow_forward
Cash Flow Statement Use table 3.3 on page 86 as a guide to create a monthly cash flow statement
arrow_forward
General accounting question
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub

Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,

Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Related Questions
- Assignment 1: TIME VALUE OF MONEY Objective: To further understand the concept of the time value of money. INSTRUCTIONS: In each problem, a. Translate data given in problems into their respective graphical representations - i.e. draw the correct cash flow diagram. b. Write down all pertinent given information or data on your paper. c. Calculate answers correctly. 5. A 45-year-old person wants to accumulate $750,000 by age 70. How much will she need to save each month, starting one month from now, if the interest rate is 0.5% per month?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_forwardQuestions are attached in the screenshot below greatly appreciate the hlep thanks @%12512oo o--arrow_forward
- Options purhcases cash disbursements sales cash receipts generalarrow_forwardPersonal Financial Statement Project For the Personal Financial Statement Project: 1. Record the events on the next page in the accompanying formula worksheet 2. Write out the journal entries for the events on the next page 3. Create the financial statements with the ending information from the worksheet 4. Once you have your Financial Statements completed, please make a comment or two in the online text input box about what the information is telling you Event List 1. Opened a bank account with previously earned (retained earnings) money for $100,000 2. Bought a house by paying $75,000 down in cash and taking a loan of $225,000 3. Bought a vehicle by paying $1,000 down in cash and taking a loan of $44,000 4. Worked (performed services) to clients for $80,000 cash 5. Paid for materials used (expense) in the services performed with cash for $50,000 6. Paid for repairs and utilities of the house and vehicle (just regular expenses) with cash for $8,500 7. During the year, you paid $5,000…arrow_forwardQuestion 2 Jordan Inc is trying to prepare a cash reconciliation for the month ended January 31, 2024. At that date, Jordan's books report a balance of $81,673 in their CIBC Chequing Account, and the balance on their January bank statement is $107,876. Jordan provides you with (1) the General Ledger which shows all the changes in the cash account during the year, and (2) a copy of the January bank statement. CIBC Chequing Account Description Opening balance Payment on account (cheque #1348) Date Jan 1 Jan 5 Jan 10 Jan 10 Jan 15 Jan 15 Jan 20 Jan 25 Jan 25 Jan 27 Jan 30 Jan 31 Jan 31 BUS285 Date January 1 January 1 January 4 January 5 January 11 January 11 Jordan Inc. General Ledger Month ended January 31, 2024 Cash out Interac machine Bank deposit January 12 January 14 January 15 January 15 January 21 January 25 January 27 January 27 January 31 Interac purchase - Tim Hortons Transfer to credit card payable Cash out Interac machine Payment on account (cheque #1349) Bank deposit CIBC…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubFinancial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning

Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub

Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,

Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning