(Continued on next page) Financial Statement Analysis and EPS Forecasting Report Assignment First, choose a publicly traded company to analyze this semester. Choosing a US company which has been...

1 answer below »

View more »
Answered 1 days AfterMar 03, 2021

Answer To: (Continued on next page) Financial Statement Analysis and EPS Forecasting Report Assignment First,...

Himanshu answered on Mar 05 2021
158 Votes
Income StatementwithProjection
            The Procter & Gamble Company (PG)                    SHARE PRICE        $ 122.15
                                Share Outstanding        2.46B
                                Dividend Paid        0.791
        INCOME STATEMENT                            EPS    5.13            COMMON SIZE STATEMENT                Horizontal Analysis of Income Statement                    Projected Income Statement
                Projected EPS            7.51
        Years    Current    6/29/2020    6/29/2019    6/29/2018    6/29/2017                TTM    2020    2019    2018    2017        TTM    2020    2019    2018        2022
        Total Revenue    73,975,000    70,950,000    67,684,000    66,832,000    65,058,000                100%    100%    100%    100%    100%        4%    5%    1%    3%        76,395,937
        Cost of Revenue    36,053,000    35,250,000    34,768,000    34,268,000    32,535,000                49%    50%    51%    51%    50%        2%    1%    1%    5%        36,994,885
        Gross Profit    37,922,000    35,700,000    32,916,000    32,564,000    32,523,000                51%    50%    49%    49%    50%        6%    8%    1%    0%        39,428,356
        Operating Expense    20,327,000    19,994,000    19,084,000    18,853,000    18,568,000                27%    28%    28%    28%    29%        2%    5%    1%    2%        20,794,219
        Operating Income    17,595,000    15,706,000    13,832,000    13,711,000    13,955,000                24%    22%    20%    21%    21%        12%    14%    1%    -2%        18,681,912
        Net Non Operating Interest Income Expense    -456,000    -310,000    -289,000    -259,000    -294,000                -1%    -0%    -0%    -0%    -0%        47%    7%    12%    -12%        -517,607
        Interest Income Non Operating    80,000    155,000    220,000    247,000    171,000                0%    0%    0%    0%    0%        -48%    -30%    -11%    44%        71,116
        Interest Expense Non Operating    536,000    465,000    509,000    506,000    465,000                1%    1%    1%    1%    1%        15%    -9%    1%    9%        557,486
        Other Income Expense    -6,000    438,000    -7,474,000    -126,000    -404,000                -0%    1%    -11%    -0%            -101%    -106%    5832%    -69%        -89,336
        Special Income Charges    -    0    -8,345,000    -    0                                0%
        Other Non Operating Income Expenses    -6,000    438,000    871,000    -126,000    -404,000                -0%    1%    1%    -0%    -1%        -101%    -50%    -791%    -69%        9,167
        Pretax Income    17,133,000    15,834,000    6,069,000    13,326,000    13,257,000                23%    22%    9%    20%    20%        8%    161%    -54%    1%        22,065,871
        Tax Provision    3,195,000    2,731,000    2,103,000    3,465,000    3,063,000                4%    4%    3%    5%    5%        17%    30%    -39%    13%        3,360,096
        Net Income Common Stockholders    13,582,000    12,764,000    3,634,000    9,485,000    15,079,000                18%    18%    5%    14%    23%        6%    251%    -62%    -37%        18,976,164
        Net Income    13,848,000    13,027,000    3,897,000    9,750,000    15,326,000                19%    18%    6%    15%    24%        6%    234%    -60%    -36%        18,839,224
        Preferred Stock Dividends    266,000    263,000    263,000    265,000    247,000                0%    0%    0%    0%    0%        1%    0%    -1%    7%        271,103
        Average Dilution Earnings    266,000    263,000    -    265,000    247,000                0%    0%        0%    0%        1%            7%        277,209
        Diluted NI Available to Com Stockholders    13,848,000    13,027,000    3,634,000    9,750,000    15,326,000                19%    18%    5%    15%    24%        6%    258%    -63%    -36%        19,583,391
        Basic EPS    -    0    0    0    0                    0%    0%    0%    0%            240%    -61%    -34%
        Diluted EPS    -    0    0    0    0                    0%    0%    0%    0%            257%    -62%    -34%
        Basic Average Shares    -    2,539,376    2,687,586    2,529,300    2,642,414                    4%    4%    4%    4%            -6%    6%    -4%        2,509,435
        Diluted Average Shares    -    2,625,800    2,687,586    2,656,700    2,740,400                    4%    4%    4%    4%            -2%    1%    -3%        2,589,120
        Total Operating Income as...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
April
January
February
March
April
May
June
July
August
September
October
November
December
2025
2025
2026
2027
SunMonTueWedThuFriSat
30
31
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
1
2
3
00:00
00:30
01:00
01:30
02:00
02:30
03:00
03:30
04:00
04:30
05:00
05:30
06:00
06:30
07:00
07:30
08:00
08:30
09:00
09:30
10:00
10:30
11:00
11:30
12:00
12:30
13:00
13:30
14:00
14:30
15:00
15:30
16:00
16:30
17:00
17:30
18:00
18:30
19:00
19:30
20:00
20:30
21:00
21:30
22:00
22:30
23:00
23:30