Must use Excel

For this problem set, we are not going to give you the exact answer but a range within which the correct answer can be found. For example, if the problem was “How much is 20 plus 50?” we would say, “The correct answer is between 65 and 75” and you would need to specify the exact answer of “70.”

- The corporate treasurer of Rollinsford Company expects the company to grow at 3% in the future, and debt securities at 4% interest (tax rate = 35%) to be a cheaper option to finance the growth. The current market price per share of its common stock is $39, and the expected dividend in one year is $1.50 per share. Calculate the cost of the company’s retained earnings and check if the treasurer’s assumption is correct.

Range: the cost of debt is somewhere between 2% and 5%. Please specify the exact answer. The cost of retained earnings is somewhere between 6.0% and 8%. Please specify the exact answer.

Point value: 5%

2-A The risk-free rate on 30 year U.S. Treasury bonds is 3.25% and the expected rate of return on the overall stock market is 12%. The company has a beta of 1.6. What is the cost of equity? Range: Between 14% and 22%

Point Value 3%

2-B Les argues that the 10 year note is a better risk free rate at 2%. He also argues that the stock market is too high and the expected return is really only 5%. Assume that he is correct. The company has a beta of 1.6. What is the cost of equity?

Range: Between 4% and 9%

Point Value 7%

- A company, West Berwick Enterprises, has a capital structure as follows: Total Capital $1,000,000

Debt $400,000 Preferred Stock $100,000 Common Equity $500,000

What would be the minimum expected return from a new capital investment project to satisfy the suppliers of the capital? Assume the applicable tax rate is 40%, interest on debt is 7%, flotation cost per share of preferred stock is $0.75, and flotation cost per share of common stock is $4. The preferred and common stocks are selling in the market for $26 and $143 a share respectively, and they are expected to pay a dividend of $1.50 and $4.50, respectively, in one year. The company’s dividends are expected to grow at 7% per year. The firm would like to maintain the existing capital structure to finance the new project.

Range: Between 4% and 9%

Point Value 15%

4.. West Berwick is considering two projects for a new investment, but it can afford only one. It has determined that the appropriate discount rate is 7.39%. Please answer the following questions based on the data below:

Net Cash Flow

Year

Project A Project B

0 -$4,000,000 -$5,000,000

1 $800,000 $1,900,000

2 $1,000,000 $1,700,000

3 $1,200,000 $1,400,000

4 $1,400,000 $900,000

5 $1,600,000 $300,000

4-A Calculate the payback period for each project.

Range: For Project A, the answer is somewhere between 2 and 5 years. Please specify the exact answer. For Project B The answer is somewhere between 2 and 5 years. Please specify the exact answer.

Point Value 6%

4-B Calculate the net present value for each project.

Range: For Project A The answer is somewhere between $600,000 and $800,000. Please specify the exact answer. For Project B The answer is somewhere between $100,000 and $400,000. Please specify the exact answer.

Point Value 6%

4-C Which project do you think will be approved, if only one project can be approved? Why?

Range: Project A or Project B Specify your choice

Point Value 3%

4-D What if the required rate of return was 10%?

Range: For Project A, the answer is somewhere between $300,000 and $500,000. Please specify the exact answer. For Project B, the answer is somewhere between $14,000 and $16,000. Please specify the exact answer.

Point Value 6%

4-E What is the Internal rate of return?

Range: For Project A, the answer is somewhere between 11% and 15%. Please specify the exact answer. For Project B, the answer is somewhere between 7% and 13%. Please specify the exact answer.

Point Value 6%

4-F. Which is the best to use for deciding: Payback, NPV or IRR? Why?

Answer: Give your answer

Point Value 8

- A corporate bond has a face value of $1,000 and an annual coupon interest rate of 7%. Interest is paid annually. 10 years of the life of the bond remain. The current market price of the bond is $1232. To the nearest 1/100 0f 1 percent, what is the yield to maturity (YTM) of the bond today? Range: The answer is somewhere between 2% and 7%. Please specify the exact answer.

6-A Kennebunk Manufacturing is expected to pay a dividend of $8 per share next year. The dividend growth rate is expected to continue to be 3%. Required rate of return is 7%. What should be the current market price per share?

Range: The answer is somewhere between $65 and $400. Please specify the exact answer.

Point Value 6

6-B. If you buy the stock in Kennebunk (above) at $185 and the stock price grows at the expected rate, What would be your percent return after one year?

Range: The answer is somewhere between 4% and 9%. Please specify the exact answer.

Point Value 6

- On January 15, 2013, A common stock sells for $82 per share, has a growth rate of 7% and a dividend that was just paid of $3.82 in December 2012. What is the annual percent yield per share?

Range: The answer is somewhere between 10% and 13%. Please specify the exact answer.

Point Value 6

- 8. A corporate bond has a face value of $1,000 and an annual coupon interest rate of 6%. Interest is paid annually. 12 years of the life of the bond remain. The current market price of the bond is $1,127, and it will mature at $1,000. To the 1/10 percent, what is the yield to maturity (YTM) of the bond today?

Range: The answer is somewhere between 2% and 6%. Please specify the exact answer.

Basic features

- Free title page and bibliography
- Unlimited revisions
- Plagiarism-free guarantee
- Money-back guarantee
- 24/7 support

On-demand options

- Writer’s samples
- Part-by-part delivery
- Overnight delivery
- Copies of used sources
- Expert Proofreading

Paper format

- 275 words per page
- 12 pt Arial/Times New Roman
- Double line spacing
- Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Delivering a high-quality product at a reasonable price is not enough anymore.

That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more
The price is based on these factors:

Academic level

Number of pages

Urgency