See attached doc. Please help to find solution of these questions. Need to include excel calculations and formula to each question. the correct answer is on the bottom of the doc. need to find step by...

1 answer below »
See attached doc. Please help to find solution of these questions. Need to include excel calculations and formula to each question. the correct answer is on the bottom of the doc. need to find step by step how those answers comes from (in excel Spread sheet). Thanks

Answered 1 days AfterJun 26, 2022

Answer To: See attached doc. Please help to find solution of these questions. Need to include excel...

Prateek answered on Jun 27 2022
79 Votes
Sheet1
    Q1
    C0    -283
    C1    234
    C2    336
    C3    97
    r    12.70%
    NPV    256.94
    Q2
    Probab    Return
    32%    -
0.39%
    30%    6.53%
    38%    0.01%
    Expected Return    1.84%
    Q3
    Beta    1.5
    r    11.99%
    Rf    2.80%
    MRP    6%
    Q4
    Flotation Cost    5%
    P0    21.24    1.062
    Dividend    1.3
    Dividend Yield    6.12%
    R    11%
    Q5
    PV FC    157
    FV P    747
    MIRR    68.19%
    Q6
    Par Value    1000
    Interest    12.86
    Debt Cost    1.29%
    Q7
    Current Shares    10,000,000.00
    Price Per Share    20.90
    Rights...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here