HW 3
docx
keyboard_arrow_up
School
St. John's University *
*We aren’t endorsed by this school
Course
604
Subject
Finance
Date
Apr 3, 2024
Type
docx
Pages
4
Uploaded by AgentDove1165
Syed Shah Ismail Hussain,
Mushu@udel.edu
CASH FLOW METRIC ANALYSIS OF PROCTER & GAMBLE CO
CONCLUSION: Overall, the company demonstrates positive trends in key financial metrics
such as Free Cash Flow and Dividends per Share, indicating healthy cash flow generation and a
commitment to shareholder returns. However, there are fluctuations in other metrics like
Accruals and operational cash flow generation, which may require further investigation to
understand underlying factors. Overall, the company's performance appears stable, with potential
areas for improvement in expense management and operational efficiency.
A) ACCRUALS
- The company started in 2020 with a significant accrual of -$4.3 billion, suggesting high
expenses, including operational costs and depreciation.
- Accruals decreased slightly to -$4.019 billion in 2021, indicating potential improvements in
cost management or operational stability.
- There was a significant drop to -$1.93 billion in 2022, signaling major improvements in
managing expenses or operational efficiency.
- Accruals increased slightly to -$2.11 billion in 2023, potentially reflecting increased business
activities or changes in accounting practices.
This analysis highlights the fluctuations in accruals over the four-year period, indicating changes
in the company's financial performance and operational efficiency.
B) ACCRUALS / TOTAL ASSETS
- The ratio of accruals to total assets was -3.6% in the first year. This negative percentage
suggests that the absolute value of the accruals was larger than 3.6% of the total assets. This
could indicate a relatively high level of accruals compared to the size of the company's total
assets.
- In the second year, this ratio improved slightly to -3.4%, still indicating a negative impact on
assets from accruals but with a slight decrease compared to the previous year.
- By the third year, the ratio further improved to -1.6%, showing a smaller negative impact of
accruals on total assets. This indicates potential efficiency in managing accruals relative to the
company's asset base.
- In the fourth year, the ratio remained relatively stable at -1.7%, indicating a continued moderate
negative impact of accruals on total assets.
Overall, while the company still had negative accruals relative to total assets throughout the
period, there was a gradual improvement in managing this ratio, suggesting potential
enhancements in financial efficiency and asset management over time.
C) FREE CASH FLOW
- In 2020, the company's free cash flow was $14.33 billion, showing positive cash generation
after accounting for capital expenditures.
- In 2021, free cash flow increased to $15.584 billion, indicating improved cash generation
compared to the previous year.
- For the year 2022, free cash flow slightly decreased to $13.567 billion, though still substantial,
reflecting some fluctuations in cash generation.
- By 2023, free cash flow increased again to $13.786 billion, suggesting a recovery or
stabilization in cash generation compared to the previous year.
This analysis provides insights into the company's cash generation trends over the four-year
period, indicating fluctuations but generally positive free cash flow.
D) FCF / WEIGHTED-AVERAGE BASIC SHARES OUTSTANDING
- In 2020, FCF per Weighted-Average Basic Share Outstanding was $5.76. This indicates the
amount of free cash flow generated per share in 2020.
- In 2021FCF per Weighted-Average Basic Share Outstanding increased to $6.32. This shows
an improvement in the amount of free cash flow generated per share compared to the previous
year.
- In 2022, FCF per Weighted-Average Basic Share Outstanding decreased to $5.63. This
indicates a decline in the amount of free cash flow generated per share compared to the previous
year.
- In 2023, FCF per Weighted-Average Basic Share Outstanding increased to $5.82. This shows
a recovery or improvement in the amount of free cash flow generated per share compared to the
previous year.
Each point represents the FCF per share for each respective year, showing fluctuations in cash
flow generation relative to the number of shares outstanding over the four-year period.
E) CFFO / WEIGHTED-AVERAGE BASIC SHARES OUTSTANDING
Certainly, here's the expanded analysis with each year included in line:
- In 2020, the Cash Flow From Operations (CFFO) per Weighted-Average Basic Share
Outstanding was $7.00. This indicates the amount of cash flow from operations generated per
share during that year.
- Moving to 2021, there was an improvement as CFFO per Weighted-Average Basic Share
Outstanding increased to $7.45. This suggests that the company generated more cash flow from
operations per share compared to the previous year.
- However, in 2022, there was a decrease in CFFO per Weighted-Average Basic Share
Outstanding, dropping to $6.94. This indicates a decline in the amount of cash flow from
operations generated per share compared to 2021.
- Looking at 2023, there was a recovery as CFFO per Weighted-Average Basic Share
Outstanding increased to $7.11. This shows an improvement in the amount of cash flow from
operations generated per share compared to the previous year.
This analysis provides insights into the fluctuations of cash flow from operations per share over
the four-year period, indicating changes in the company's operational performance and
efficiency.
F) DIVIDENDS / WEIGHTED-AVERAGE BASIC SHARES OUTSTANDING
Certainly, let's analyze the Dividends per Weighted-Average Basic Shares Outstanding for each
year from 2020 to 2023:
- In 2020, the Dividends per Weighted-Average Basic Shares Outstanding were $3.13. This
indicates the amount of dividends distributed per share during that year.
- For the year 2021, the Dividends per Weighted-Average Basic Shares Outstanding increased to
$3.35. This suggests an increase in the dividends distributed per share compared to the previous
year.
- Moving to 2022, the Dividends per Weighted-Average Basic Shares Outstanding further
increased to $3.64. This indicates continued growth in dividends distributed per share compared
to the previous years.
- Finally, in 2023, the Dividends per Weighted-Average Basic Shares Outstanding increased
again to $3.80. This shows a continued trend of growth in dividends distributed per share
compared to the previous years.
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
Overall, this analysis highlights the increasing trend in dividends distributed per share over the
four-year period, indicating a potential commitment to returning value to shareholders by the
company.
Related Documents
Related Questions
Solve this financial accounting problem
arrow_forward
Financial Statement Analysis tells you if your company is on the right track. Are you growing, making more money? Find out why the Liquidity, Leverage, Profitability, and Cash Flow Ratios are so important to a company's survival? List at least '1' for each category, describing how it is calculated, and what it means.
arrow_forward
What comment can be made on this or what can be added?
The Weighted Average Cost of Capital (WACC) is a financial analytical tool that is essentially a calculation utilizing a company's market value of equity, debt, and tax rate. This allows both the company and investors an estimated net value of the company and can give indications of the value of the company moving forward. The WACC is especially important for a company to understand because the WACC is a good indication of the success or failure of a company's current investment strategy and if favorable, can assist a company when it comes to purchases of sales or other acquisitions
arrow_forward
The quality of earnings concept indicates thata. stockholders want the corporation to earn enough income to be able to pay its debts.b. net income is the best measure of the results of operations.c. continuing operations and one-time transactions are of equal importance.d. income from continuing operations is a more relevant predictor of future performancethan income from one-time transactions
arrow_forward
Profitability Ratios:
a. Measure the short-term ability of the company to pay its maturing obligations and to meet unexpected needs for cash.
b. Measure the ability of the company to survive over a long period of time.
c. Measure the income or operating success of a company for a given period of time.
arrow_forward
The DuPont equation shows the relationships among asset management, debt management, and ratios. Management can use the DuPont equation to analyze ways of improving the firm's performance. Its equation is:
Ratio analysis is important to understand and interpret financial statements; however, sound financial analysis involves more than just calculating and interpreting numbers. factors also need to be considered.
Quantitative Problem: Rosnan Industries' 2022 and 2021 balance sheets and income statements are shown below.
Balance Sheets
2022
2021
Assets
Cash and equivalents
$
70
$
55
Accounts receivable
275
300
Inventories
375
350
Total current assets
$
720
$
705
Net plant and equipment
2,000
1,490
Total assets
$
2,720
$
2,195
Liabilities and Equity
Accounts payable
$
150
$
85
Accruals
75
50…
arrow_forward
A trend analysis indicates a firm's performance ____.
a.over time
b.more accurately than any other type of analysis
c.at one given point in time
d.without relying on financial ratios
arrow_forward
Which of the following statements about earnings per share (EPS) is
correct?
Multiple Choice
EPS is an indicator of how well a company will
perform in the future.
Net income in dollar amount is a better measure
to use in comparing different companies.
EPS can be used to compare companies of
different sizes.
EPS is expected to remain constant over a
period of time.
arrow_forward
I want Answer of this Question
arrow_forward
Emerson Electric is engaged in design, manufacture, and
sale of a broad range of electrical, electromechanical,
and electronic products and systems. The following shows
Emerson's net income and net income before extraordinary
items for the past 20 years (in millions):
Net
Year Income
Y1 $201.0
Y2
237.7
Y3
273.3
Y4 300.1
Y5
302.9
Y6 349.2
Y7
401.1
Net Income
before
Extraordinary
Items
$201.0
237.7
273.3
300.1
302.9
349.2
401.1
Net
Year Income
Y8 $408.9
Y9
467.2
Y10 528.8
Y11 588.0
Y12 613.2
Y13
631.9
Y14 662.9
Net Income
before
Extraordinary
Items
$408.9
467.2
528.8
588.0
613.2
631.9
662.9
Emerson Electric
Net
Year Income
Net Income
before
Extraordinary
Items
Y15 $708.1
Y16
Y17
Y18 1,018.5
Y19
1,121.9
Y20 1,228.6 1,228.6
788.5
907.7
$ 708.1
904.4
929.0
1,018.5
1,121.9
Emerson has achieved consistent earnings growth for more than 160 straight quarters (more than
40 years).
PROBLEM 2-14
Earnings
Management
Strategies
arrow_forward
Indicate whether the following are true or false.
Financial statement analysis is used by insiders and outsiders to identify strengths and weaknesses.
Time series analysis compares one firm to another.
If you want to determine the gross profit earned on each dollar of sales, use the operating profit margin ratio.
The earnings per share ratio is used to predict the amount of cash dividends.
Discounted cash flow values an asset based on the future value of cash flows associated with that asset
arrow_forward
Define profitability raitos return on assets and return on equity.
According to the following metrics: ROA Return on Assets: 14%; ROE Return on Equity: 305%. What is the profitability the of example company? Why or why not is this company profitable?
arrow_forward
According to the textbook: Return on Equity (ROE) is a measure of how the stockholders fared during the year. Because benefiting shareholders is our goal, ROE is, in an accounting sense, the true bottom-line measure of performance. Breaking ROE into its constituent parts, by using the DuPont identity, identifies a firm’s operating efficiency, asset use, and financial leverage. However, these measures rely upon accounting data that may or may not be useful. Why would a firm have a negative ROE? Should investors buy stocks that have negative ROEs? What do you see as an alternative measure of how a firm benefits its shareholders?
arrow_forward
I need help with questions 1-6
arrow_forward
Solve this accounting question
arrow_forward
5. Profitability ratios
Profitability ratios help in the analysis of the combined impact of liquidity ratios, asset management ratios, and debt management ratios on the
operating performance of a firm.
Your boss has asked you to calculate the profitability ratios of Diusitech Inc. and make comments on its second-year performance as compared with its
first-year performance.
The following shows Diusitech Inc.'s income statement for the last two years. The company had assets of $4,700 million in the first year and $7,518
million in the second year. Common equity was equal to $2,500 million in the first year, and the company distributed 100% of its earnings out as
dividends during the first and the second years. In addition, the firm did not issue new stock during either year.
Diusitech Inc. Income Statement For the Year Ending on December 31 (Millions of dollars)
Year 2 Year 1
2,540
2,000
1,610
1,495
127
80
1,737
803
80
723
181
542
Net Sales
Operating costs except depreciation and…
arrow_forward
EBITDA is one indicator of a firm's financial performance and is used as aproxy for the earning potential of a firm.1) Explain why EBITDA can be used to analyze and compare profitability amongfirms in different industries and even in different countries. 2) Explain what is the EV multiple. And then explain why it is analogous to thepayback period in finance or managerial accounting
arrow_forward
Guide Questions:
1. Is ABC, Inc. profitable?
2. Is the company's financial performance improving based on the two year data presented?
3. Is the company heavily financed by debt or equity?
4. Provide interpretation of the Horizontal and Vertical Analysis and Ratio Analysis (A).
5. From the computation (A), assuming that there is no pandemic, How do you see ABC, INC.? Is it profitable? Good for long term investment? Short term investment? Is the company still existing?
arrow_forward
Using the data in the following table for a number of firms in the same industry, dothe following:•a. Compute the total asset turnover, the net profit margin, the equity multiplier, andthe return on equity for each firm.b. Evaluate each firm’s performance by comparing the firms with one another.Which firm or firms appear to be having problems? What corrective actionwould you suggest the poorer performing firms take? Finally, what additional data would you want to have on hand when conducting youranalyses?Firm
(in million Dollars
A
B
C
D
Sales
$20
$10
$15
$25
Net Income after sales
3
0.5
2.25
3
Total Assets
15
7.5
15
24
Stockholders’ Equity
10
5
14
10
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:9781337514835
Author:MOYER
Publisher:CENGAGE LEARNING - CONSIGNMENT
Related Questions
- Solve this financial accounting problemarrow_forwardFinancial Statement Analysis tells you if your company is on the right track. Are you growing, making more money? Find out why the Liquidity, Leverage, Profitability, and Cash Flow Ratios are so important to a company's survival? List at least '1' for each category, describing how it is calculated, and what it means.arrow_forwardWhat comment can be made on this or what can be added? The Weighted Average Cost of Capital (WACC) is a financial analytical tool that is essentially a calculation utilizing a company's market value of equity, debt, and tax rate. This allows both the company and investors an estimated net value of the company and can give indications of the value of the company moving forward. The WACC is especially important for a company to understand because the WACC is a good indication of the success or failure of a company's current investment strategy and if favorable, can assist a company when it comes to purchases of sales or other acquisitionsarrow_forward
- The quality of earnings concept indicates thata. stockholders want the corporation to earn enough income to be able to pay its debts.b. net income is the best measure of the results of operations.c. continuing operations and one-time transactions are of equal importance.d. income from continuing operations is a more relevant predictor of future performancethan income from one-time transactionsarrow_forwardProfitability Ratios: a. Measure the short-term ability of the company to pay its maturing obligations and to meet unexpected needs for cash. b. Measure the ability of the company to survive over a long period of time. c. Measure the income or operating success of a company for a given period of time.arrow_forwardThe DuPont equation shows the relationships among asset management, debt management, and ratios. Management can use the DuPont equation to analyze ways of improving the firm's performance. Its equation is: Ratio analysis is important to understand and interpret financial statements; however, sound financial analysis involves more than just calculating and interpreting numbers. factors also need to be considered. Quantitative Problem: Rosnan Industries' 2022 and 2021 balance sheets and income statements are shown below. Balance Sheets 2022 2021 Assets Cash and equivalents $ 70 $ 55 Accounts receivable 275 300 Inventories 375 350 Total current assets $ 720 $ 705 Net plant and equipment 2,000 1,490 Total assets $ 2,720 $ 2,195 Liabilities and Equity Accounts payable $ 150 $ 85 Accruals 75 50…arrow_forward
- A trend analysis indicates a firm's performance ____. a.over time b.more accurately than any other type of analysis c.at one given point in time d.without relying on financial ratiosarrow_forwardWhich of the following statements about earnings per share (EPS) is correct? Multiple Choice EPS is an indicator of how well a company will perform in the future. Net income in dollar amount is a better measure to use in comparing different companies. EPS can be used to compare companies of different sizes. EPS is expected to remain constant over a period of time.arrow_forwardI want Answer of this Questionarrow_forward
- Emerson Electric is engaged in design, manufacture, and sale of a broad range of electrical, electromechanical, and electronic products and systems. The following shows Emerson's net income and net income before extraordinary items for the past 20 years (in millions): Net Year Income Y1 $201.0 Y2 237.7 Y3 273.3 Y4 300.1 Y5 302.9 Y6 349.2 Y7 401.1 Net Income before Extraordinary Items $201.0 237.7 273.3 300.1 302.9 349.2 401.1 Net Year Income Y8 $408.9 Y9 467.2 Y10 528.8 Y11 588.0 Y12 613.2 Y13 631.9 Y14 662.9 Net Income before Extraordinary Items $408.9 467.2 528.8 588.0 613.2 631.9 662.9 Emerson Electric Net Year Income Net Income before Extraordinary Items Y15 $708.1 Y16 Y17 Y18 1,018.5 Y19 1,121.9 Y20 1,228.6 1,228.6 788.5 907.7 $ 708.1 904.4 929.0 1,018.5 1,121.9 Emerson has achieved consistent earnings growth for more than 160 straight quarters (more than 40 years). PROBLEM 2-14 Earnings Management Strategiesarrow_forwardIndicate whether the following are true or false. Financial statement analysis is used by insiders and outsiders to identify strengths and weaknesses. Time series analysis compares one firm to another. If you want to determine the gross profit earned on each dollar of sales, use the operating profit margin ratio. The earnings per share ratio is used to predict the amount of cash dividends. Discounted cash flow values an asset based on the future value of cash flows associated with that assetarrow_forwardDefine profitability raitos return on assets and return on equity. According to the following metrics: ROA Return on Assets: 14%; ROE Return on Equity: 305%. What is the profitability the of example company? Why or why not is this company profitable?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- EBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENT

EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:9781337514835
Author:MOYER
Publisher:CENGAGE LEARNING - CONSIGNMENT