Explore BrainMass
Share

Explore BrainMass

    Calculate the earnings per share, stock price, and more

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    See the >>ATTACHED<< Word document which has all details, questions and screen-shots for the questions.

    Thanks for your help!!

    © BrainMass Inc. brainmass.com October 10, 2019, 2:48 am ad1c9bdddf
    https://brainmass.com/business/net-present-value/earnings-per-share-stock-price-more-394297

    Attachments

    Solution Preview

    1. Which of the following is the correct formula for cell B5 to calculate the earnings per share?

    a. =B2-B3*B2/B4
    b. =(B2-B3)/B4
    c. =B2*(1-B3)/B4
    d. =(B2+B3*B2)/B4
    e. =B2*(1+B3)/B4

    EPS=Earnings before tax*(1-tax)/shares outstanding

    2. What should be the outcome of cell B8? Remember that the basic syntax of the IRR function is: IRR(values,guess)

    a. "Accept"
    b. "Reject"
    c. "Indifferent"
    d. "IRR=30%"
    e. "30%"
    Use Excel function to calculate the IRR of the cash flows. IRR=27% <30%

    3. What is the correct formula to determine the stock price using the earnings model on cell B6?

    a. =B1*B2/B3+(B1*B2*(B4/B3-1))/(B3-B5)
    b. =B1/B3-(B1*(1+B2)*(B4/B3+1))/(B3+B5)
    c. =B1/B3+B1*(1-B2*B4/B3-1)/(B3-B5)
    d. =B1/B3+(B1*(1-B2)*(B4/B3-1))/(B3-B5)
    e. =B1/B3+(B1*(1-B3)*(B2/B3-1))/(B3-B4)

    Use the data to the right for the next two problems

    4. What is the correct formula for cell B5?

    a. =B2*(1-B4)+B3-B1
    b. =B2-B4+B1-B3
    c. =B2*(1-B4)+B1-B3
    d. =B2*(1-B4)-B1+B3
    e. =B2/(1-B4)*B1*B3
    FCF=EBIT*(1-Tax)+Depr.-Investment in Operating assets
    5. What is the free cash flow?
    a. $120,500
    b. $117,550
    c. $ 82,550
    d. $ 74,500

    Use the data to the right for the next two problems
    6. What should be the formula on cell C4 if you want to determine the expected rate of return of security X using the CAPM model?
    a. =B4+C3*D4-B4
    b. =B4+C3*(D4-B4)
    c. =B4-C3*(D4+B4)
    d. =B4+B3*(D4-B4)
    e. =B4+D3*(C4-B4)
    Expected rate of return=Risk free rate+Beta*(Market return-Risk free rate)

    7. What is the expected return?
    a. 18.0%
    b. 10.0%
    c. 13.5%
    d. 6.5%

    8. What is the value of cell B6?
    a. 1586.8
    b. 26.67
    c. 13.2
    d. 40
    e. 80
    Roundup(B1,0) function round 39.67 up to 40

    Use the following information for the next two problems
    PV
    Year Cash Flow Cash Flows
    1 $14,000 $12,726
    2 $14,000 $11,564
    3 $10,000 $7,510
    4 $10,000 $6,830
    5 $8,000 $4,968

    9. What is the NPV of above project if the initial investment was $45,000?
    a. $43,598
    b. $-1,402
    c. $11,000
    d. $56,000
    NPV= -45000+12726+11564+7510+6830+4968= -1402
    10. Calculate the IRR and ...

    Solution Summary

    The expert calculates the earnings per share, stock price and more.

    $2.19