Project Help, Corporate Finance

Assignment Help:
1. Use the bond price, yield-to-maturity, and quantity available you collected for each bond in Component 2 for this project to estimate an average current bond price and an average YTM for all your company’s bonds. Use the “weighted average” approach we discussed in class.
a. For the average bond price, use the quantity available variable as a substitute for the FMV to calculate the weights.
b. For the average YTM (pre-tax cost of debt), use the product of the current price and quantity available from 1a as an estimate of FMV to calculate the weights.
2. Remembering that bond prices are quoted as a percent of par value and that the value of bonds on the balance sheet are the par values, use your weighted average bond price from question 1 to estimate the FMV of the company’s outstanding bonds. For this question, you must add the current portion of long-term debt to the long-term debt value to use as your par value.
If your balance sheet indicates a zero balance for preferred stock at the end of the most recent fiscal year, skip questions 3–4.

3.Go to the lookup page from Preferred-Stock.com (https://www.preferred-stock.com/lookup.php) to find as much publicly available information about your company’s preferred stocks as possible. Remember, you may need to try several shortened spellings of your company’s name to find all of them. For each preferred stock issue you locate, click on the symbol in the first column and record each share’s latest price, number of shares (an “M”is used for “million”), and indicated annual dividend. Also, click on the IPO Prospectus Supplement to get the liquidation preference in the equivalent amount per depositary share (to ensure consistency with the share price).

4. Use the information you collected in question 4 as follows.
a. Multiply the latest price by the number of shares to get the FMV of each issue. Add all these values together.

b. Multiply the indicated annual dividend by the number of shares to get total dividends to pay.
Add all these values together.

c. Divide the sum in 4b by the sum in 4a to estimate the average cost of preferred equity.

d. Multiply the liquidation preference by the number of shares to get a total liquidation preference for each issue. Add all these values together.

e. Divide the sum in 4a by the sum in 4b, then multiply this ratio by the value of preferred stock found in the statement of shareholders’ equity to get an overall FMV for your company’s referred stock.

5. Use the Capital Asset Pricing Model to estimate the cost of common equity.

a. Get the risk-free rate from the 3 month treasury yield on FINRA’s bonds page.

b. Get the market return from the S&P 500 index (found here: https://www.google.com/finance?q=INDEXSP%3A.INX&ei=hsY5U-CYF4etqgG4Nw). Use basic time value of money functions (on your calculator orMBA508PROJECTCOMPONENT3WEIGHTEDAVERAGECOST OFCAPITALExcel) to calculate various estimates of the historical return using the closing price from the last date in your most recent fiscal year as a future value and the following older prices as the present value:

i. Three months prior (n = 0.25)
ii. Twelve months prior (n = 1)
iii. Two years prior (n = 2)
iv. Three years prior (n = 3)
v. Five years prior (n = 5)
vi. Ten years prior (n = 10)
vii. The oldest price available, from January 2, 1970 (use the YEARFRAC function in Excel to get n to two decimal places)

c.Get beta by entering your company’s ticker symbol in the search box at the top of the Google Finance home page.

d. Use each of the seven market returns as part of CAPM to estimate the company’s cost of common equity. Do any patterns emerge? Are any of them close to the required return you calculated in question 7 of Component 2?

e. Now choose any of the eight returns to use as your cost of equity. Justify this choice.

f. Also obtain the market capitalization from the same page where you found beta (a “B” is used for “billion”) to estimate the FMV of common equity.

6.Calculate your company’s weighted average cost of capital using the following seven items you found earlier in this project:
a. The FMVs of debt, preferred stock, and common equity.
b. The costs of debt, preferred stock, and common equity.
c. The corporate tax rate (used in Component 1 to calculate after-tax operating income).

Related Discussions:- Project Help

Merger and aquisition, It is given that company A will acquire company B wi...

It is given that company A will acquire company B with shares of common stock. Present earnings of A is rs. 20 million and of company B is rs. 5 million. Earning price per share of

Find the expected return and standard deviation, Question: (a) You are...

Question: (a) You are given the following information on two risky assets A and B. E(X) = 25% E(Y) = 30% Var (X) = 16% Var (Y) = 49% The correlation matr

Npv, An investment under consideration has a payback of seven years and a c...

An investment under consideration has a payback of seven years and a cost of $320,000. If the required return is 12 percent, What is the worst-case NPV? Explain...

NPV Best Case/Worst Case, Ask que We are evaluating a project that costs $8...

Ask que We are evaluating a project that costs $800,000, has an eight-year life, and has no salvage value. Assume that depreciation is straight-line to zero over the life of the pr

WACC, The total book value of WTC’s equity is $40 million and book value pe...

The total book value of WTC’s equity is $40 million and book value per share outstanding is $12. The stock of WTC is currently selling for a price of $35 per share and the beta of

What is in store for banking consolidation, What is in store for banking co...

What is in store for banking consolidation? A: Merger activity is a natural process by which companies make themselves more efficient and better able to compete for customers.

Sensitivity analysis, NPV calculation if we have Initial investment 60000,l...

NPV calculation if we have Initial investment 60000,life is 3 year, net working capital is 15000, sale is 75000 per year, variable cost is 1000 per year, fixed cost is 5000 per yea

Estimate the dollar-equivalent or adjusted rate of return, In January 2009 ...

In January 2009 you bought a German stock portfolio for 6,000,000 Euros and sold it in December 2009 for 7,000,000 Euros.  Assume that over the same period the dollar's exchange ra

Analyse, Hi There; I’m looking for people who can complete three assignment...

Hi There; I’m looking for people who can complete three assignments for me. I’m looking for someone who can analyse three different empirical studies regarding stock or financial m

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd