Purchase Solution

Calculate the earnings per share, stock price, and more

Not what you're looking for?

Ask Custom Question

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

Thanks for your help!!

Attachments
Purchase this Solution
Solution Summary

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

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 ...

Purchase this Solution
Free BrainMass Quizzes
Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.

Introduction to Finance

This quiz test introductory finance topics.

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

View More Free Quizzes
Related BrainMass Solutions

  • Earnings per Share & P/E Ratio

    The P/E ratio equals the stock price divided by the earnings per share.

  • Mergers and acquisitions

    Calculate the earnings per share and price/earnings ratio for each company C. Calculate the price/earnings ratio used to purchase Mayer Services D. Calculate the postmerger earnings per share for Henry Company. E.

  • EPS on the basis of stock split

    Earnings per share = The par value per share  and the share price decreases with a stock split. and number of shares outstanding will increase. EPS will also decrease as number of shares outstanding will increase by 3 times.

  • Retained Earnings, Treasury Stock, Transaction Analysis

    Sold 140 shares of the preferred stock held in treasury (see D) for $17 per share. f. Declared and issued a 15% stock dividend on the $1 par value common stock when the market price per share was $45. Please find the solutions attached.

  • Cost of Retained Earnings Using Dividend Discount Model

    The company pays out 30 percent of its earnings as dividends per share (DPS), and the company's stock price was $37.50 (at the end of 2012). (a) Calculate the growth rate in dividends (g) over the given period.

  • Cost of preferred stock, cost of equity

    The company pays out 40 percent of it's earnings as dividends, and the stock sells for $36. a. Calculate the past growth rate in earnings. b. Calculate the next expected dividend per share, D1. (D0=0.4($6.50)=$2.60.)

  • Sources of Capital: Owner's equity; EPS

    Calculate the company's basic earnings per share 2. Calculate the company's diluted earnings per share.

  • Stock Price

    (b) If the firm sells the sock for a net price of $23 per share and is able to earn 60% after tax on the proceeds before the end of the year, what will be the earnings per share?

  • Calculate the current price per share for Cali Corporation.

    First, we need to calculate the earnings per share and dividend paid per share.

  • Price of stocks

    Assume the discount rate is 15%. Show in dollars and percent what you would earn if you held this stock for two years. 3) XYZ Corp. has earnings per share of $4, a payout ratio of 50% and a return on equity of 10%.

View More Related Solutions