Question: I need to calculate these problems in excel. I do not know excel. Any guidance would be appreciated. Stock Valuation:A stock has an initial price

I need to calculate these problems in excel. I do not know excel. Any guidance would be appreciated.

  1. Stock Valuation:A stock has an initial price of $100 per share, paid a dividend of $2.00 per share during the year, and had an ending share price of $125. Compute the percentage total return, capital gains yield, and dividend yield.
  2. Total Return:You bought a share of 4% preferred stock for $100 last year. The market price for your stock is now $120. What was your total return for last year?
  3. CAPM:A stock has a beta of 1.20, the expected market rate of return is 12%, and a risk-free rate of 5 percent. What is the expected rate of return of the stock?
  4. WACC:The Corporation has a targeted capital structure of 80% common stock and 20% debt. The cost of equity is 12% and the cost of debt is 7%. The tax rate is 30%. What is the company's weighted average cost of capital (WACC)?
  5. Flotation Costs:Medina Corp. has a debt-equity ratio of .75. The company is considering a new plant that will cost $125 million to build. When the company issues new equity, it incurs a flotation cost of 10%. The flotation cost on new debt is 4%. What is the initial cost of the plant if the company raises all equity externally?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Q:

Please do not write by hand 17. A small town wants to build some new recreational facilities. The proposed facilities include a swimming pool, recreation center, basketball court and baseball field....

Q:

Rate of Return for Stocks and Bonds Purpose of Assignment The purpose of this assignment is to allow the student an opportunity to calculate the rate of return of equity and debt instruments. It...

Q:

Calculate the following problems using Excel or a Word document: Stock Valuation: A stock has an initial price of $100 per share, paid a dividend of $2.00 per share during the year, and had an ending...

Q:

Demonstrate your understanding of financial concepts by completing the following problems. Where appropriate, show or explain your work. You may use Excel to work on the problems. Problem 1....

Q:

INTRODUCTION This project provides an opportunity for students of Intermediate Accounting to utilize financial accounting information in a simulation of a real-world setting. In addition, this...

Q:

HELPPPP Hopper Laboratories Financial Information In 2015 Hopper Labs had total revenues of $110 million dollars, up from only $65 million in 2011. Hopper expects earnings to continue to grow at an...

Q:

*********This assignment was already completed, just need help with corrections********* Assignment attached Faculty comments: ?Calculating Returns Coupon 8.75% Bond Price 1 Year Ago $1,065 Bond...

Q:

Calculate the following problems using Microsoft Excel. The calculations must be done in Excel. You must show your work. If you submit these in Word, you will not receive credit. If you do not show...

Q:

Stock redemption is generally treated as an exchange, in which the stockholders give up their stock in exchange for cash or property. However, the Internal Revenue Code (IRC) does provide...

Q:

1. Calculating Returns Suppose a stock had an initial price of $73 per share , paid a dividend of $1.20 per share during the year and had an ending share price of $82. Compute the percentage total...

Q:

17-19 and 23 ANSWERS FOR 17-19 AND 23 !!! 17,28,19 and 23 carry coupon rates of Connection Example 7-3 (page 195) shave 10 yearst $1.000 Approximately what the follow a. $770 b. $1,150 c. $1,000 hey...

Q:

The R2 value: gives the proportion of variation in the dependent variable that is explained by the independent variable indicates that as the independent variable increases, the intercept does so...

Q:

Consider Figure 5.38. Now we replace the router between subnets I and 2 with a switch S l, and label the router between subnets 2 and 3 as R l. a. Consider sending an IP datagram from Host E to Host...

Q:

Evaluate the definite integral: 0 1 2 e 1 0 x 5 e 4 xdx =

Q:

P Corporation owns all the stock of S and T Corporations, and the three corporations elected to file a consolidated tax return for the prior year. What circumstances would allow the corporations to...

Q:

Russell (birthdate February 2, 1966) and Linda (birthdate August 30, 1971) Long have brought you the following information regarding their income and expenses for the current year. Russell owns and...

Q:

According to the Nuclear Energy Institute (NEI), there were 62 nuclear power plants operating in the United States in 2015. The table at top of the next column lists the 30 states that operate...

Q:

Lew is a practicing CPA who decides to raise bonsai as a business. Lew engages in the activity and has the following revenue and expenses: Sales................................................. $...

Q:

Maggie lost her job in the current year. She paid the expenses of owning her home, interest on the mortgage, and property taxes out of savings. Her tax return shows negative taxable income of...

Q:

Create a 200 word summary on the Juvenile Justice System than and today. Describe The Juvenile system and provide a generalizable definition. Highlight the issues in the Juvenile system and why this...

Q:

Describe the range of ethical and moral issues that arise in management, business and organisations.

Q:

Consolidated financial statements are required in which of the following situations? a. only when a company can exert significant influence over another company b. only when a company acquires goodw...

Q:

Was British Sugar right to forgo the efficiency and cost benefits that could have been gained from a seven-day working week?