1. You find the following quotation for a stock: Stock (ticker) Div Yld% PE (ttm) High (ttm) Low (ttm) Volume (100) Last Change AAPL XXXXXXXXXX XXXXXXXXXX, XXXXXXXXXX a. What was the most recent...

1 answer below »

View more »
Answered Same DayApr 08, 2021

Answer To: 1. You find the following quotation for a stock: Stock (ticker) Div Yld% PE (ttm) High (ttm) Low...

Kushal answered on Apr 09 2021
142 Votes
Sheet1
        1
            Stock (ticker)    Div    Yld%    PE    High    Low    Volume    Last    Change
                        (ttm)    (ttm)    (ttm)    -100
            AAPL.    2.92.    1.56.    18.17.    207.4    177.14.    28,443.00    193.47    2.85
            1    Most recent Stock price            193.47
            2    Day before stock price            188.1088964511
        2    Stock (ticker)    Div    Yld%    PE    High    
Low    Volume    Last    Change
                        (ttm)    (ttm)    (ttm)    -100
            AAPL.    2.92    1.56    18.17    218.5    188.24    25,118.00    204.57    3.32
            1    Market Capitalization            No information aroudn outstanding shares given
            2    Shares traded on reported day            25,118.00
        3    Forever 21
            D1    2.56
            Growth    9%
            Required rate    14%        Share price=    D1/(Rate - growth Rate)
            Share price    51.2
        4    Apple
                Q1    Q2    Q3    Q4    Q1
            Dividends    3.82    4.202    4.6222    5.08442    5.592862
            Terminal Value                    141.2197655
            Total cash flwos        4.202    4.6222    5.08442    146.8126275
            Dividend Growht Rate    10%
            Requred Rate of Return    5%
            tereminal growth Rate    1%
            Share Price Apple    $133.37
        5
                    Nestle    Pepsico
                Dr Pepper
            P/E ratio    22.07    23.31    21.37
            Cocacola EPS    1.2
            1    Intrinsic Value based on lwest EPS                25.644
            2    Intrinsic Value based on highest EPS                27.972
            3    Intrinsic Value based on average EPS                26.7
        6    C
            Immediately at the current market price
        7    C,D
            Dealers bid ask spread
            Broker's commission
        8    Stock    Beginning price: P0    Ending price: P1    Dividend payment: D1
            A    22.38    17.06    2.6
            B    101.74    111.92    5.25
            C    4.25    5.58    0.14
                        Total return
            A            -12.15%
            B            15.17%
            C            34.59%
        9    Date    Stock price    dividend
            1-Feb    20.28    0
            4-Jan    20.44    0.65
            7-Jan    18.86    0.65
            10-Jan    20.69    0.65
            1-Feb    20.88    0.65
                Price return    Dividend yield
                2.96%    12.45%
            Total return    15.41%
        10    Asset class    Return            1    Excess return for corporate bOnds                4.90%
            T-bills    1.40%            2    Excess return for Small company stocks                13.70%
            Corporate bonds    6.30%            3    Excess return for large copany stocks                9.30%
            Small company stocks    15.10%
            Large company stocks    10.70%
        11    Buy price    100.00
            Sale Price    105.00
            Dividend    2.00
                Price return    Dividend yield
                5.00%    2.00%
            Total return    7.00%
        12    A,C,D
            a. the difference between the expected rate of return on an asset and the risk-free rate
            c. the reward for bearing risk
            d. normally positive for risky assets
        13    Asset class    Exp. return
            T-bills    2.60%            1    Risk premium for corporate bOnds                2.30%
            Corporate bonds    4.90%            2    Risk premium for Small company stocks                14.50%
            Small company stocks    17.10%            3    Risk premium for large copany stocks                10.90%
            Large company stocks    13.50%
        14    Year    1    2    3    4
            Return    7%    13%    3%    6.00%
            Inested amount    4000
            Amoutn after 4 years    5280.38152
            Geometric return    7.19%
        15    Year    1    2    3
            Rate of return    4.60%    5.70%    1.40%
            Arithmatic return    3.90%
        16
            Year (t)    RA,t    RB,t
            2016    0.02    0.02            Average annual...
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