Question

In: Finance

a. Search Yahoo Finance or any other credible source to retrieve the most recent income statement...

a. Search Yahoo Finance or any other credible source to retrieve the most recent income statement and balance sheet for a major leveraged corporation. Provide these statements in proper format. Also, retrieve the data on the company's stock annual rate of return for the past 20 years. In addition, retrieve annual rate of return of a major financial index. Present this data as well. Using the data on company's stock rate of return and the index's rate of return estimate beta of the corporation. Make sure to adjust this value to obtain leveraged beta. Compare this value with the value stated by the source. Retrieve the risk-free rate of return as the annual interest rate of US treasuries. Based on these values estimate the expected annual rate of return of the corporation's security. Using the financial statements mentioned above estimate the annual rate of interest paid by the corporation (cost of debt). Also, find the tax rate and capitalization ratio (proportions among equity and debt). Using these values that you have found estimate the annual weighted cost of capital (WACC) of the corporation.

b. Suppose that the corporation is offered an investment which has the following cash flows.

Year

Cash flow

0

-$10,000.000

1

$1,500,000

2

$1,500,000

3

$1,500,000

4

$1,500,000

5

$1,500,000

6

$1,500,000

7

$1,500,000

8

$1,500,000

9

$1,500,000

10

$1,500,000

Based on WACC, Is this investment viable?

For each part above state the problem before answering the questions, provide clear justifications, explain your work in detail, and cite all references used for development of the content.

Solutions

Expert Solution

The beta calculation is shown below

The source specifies a beta of 0.64

The risk free rate represented by 30 year yield of US treasuries is 2.86% and equity premium is 5.54% so the expected return = Rf + beta*(Rm-Rf)

= 2.86%+0.19*(5.54%)=3.91%

As per financial statement, the cost of debt is 3.09% (calculated using interest expense/average debt)

Tax rate = 16% for period ending Jan 2017 & 20% for Jan 2016

The debt/equity ratio is 0.38 for Jan 2017

So WACC = 0.72*3.91%+0.28*(1-20%)*3.09%

WACC = 3.50%

For the investment having cash flow

Year Cash flow
0 -10000000
1 1500000
2 1500000
3 1500000
4 1500000
5 1500000
6 1500000
7 1500000
8 1500000
9 1500000
10 1500000

The IRR is 8.14% which is more than WACC and hence proposal is acceptable


Related Solutions

1. Go to Yahoo! Finance or another source and pick a stock to track for the...
1. Go to Yahoo! Finance or another source and pick a stock to track for the last year. Discuss the performance of the stock over the last year and offer your thoughts being specific about why the stock has done well or not. 2. What are some reasons that a company might choose common stock as means of financing their business rather than using debt? Also comment on why a company might choose debt over common stock.
1. Go to Yahoo! Finance or another source and pick a stock to track for the...
1. Go to Yahoo! Finance or another source and pick a stock to track for the last year. Discuss the performance of the stock over the last year(2018) and offer your thoughts being specific about why the stock has done well or not. 2. What are some reasons that a company might choose common stock as means of financing their business rather than using debt? Also comment on why a company might choose debt over common stock.
Examine a BALANCE SHEET from Wal Mart found on Yahoo Finance and/or INCOME STATEMENT then CALCULATE...
Examine a BALANCE SHEET from Wal Mart found on Yahoo Finance and/or INCOME STATEMENT then CALCULATE and EXPLAIN: ROI, Acid Ratio (Current Ratio), and Debt to Equity Ratio. [Please show your work to get partial credit]
Why is access to YouTube by other search engines such as Yahoo and Bing relevant to...
Why is access to YouTube by other search engines such as Yahoo and Bing relevant to the question of whether Google has a monopoly in the Internet search engine market?
Go to Yahoo Finance and enter SBUX in the search bar to access the financial statements...
Go to Yahoo Finance and enter SBUX in the search bar to access the financial statements for Starbucks. Access the two most recent income statements and balance sheets that are provided, and prepare horizontal and vertical analyses of both. Income Statement All numbers in thousands Revenue 10/1/2017 10/2/2016 9/27/2015 Total Revenue 22,386,800 21,315,900 19,162,700 Cost of Revenue 9,038,200 8,511,100 7,787,500 Gross Profit 13,348,600 12,804,800 11,375,200 Operating Expenses Research Development - - - Selling General and Administrative 8,440,400 7,970,300 7,130,200 Non...
Go to Yahoo Finance and enter SBUX in the search bar to access the financial statements...
Go to Yahoo Finance and enter SBUX in the search bar to access the financial statements for Starbucks. Access the two most recent income statements and balance sheets that are provided, and prepare horizontal and vertical analyses of both. In approximately 250-500 words, summarize the findings from your horizontal and vertical analyses. Submit your assignment in an Excel workbook.
Select one of the following companies, and use yahoo finance (or an alternate similar source) to...
Select one of the following companies, and use yahoo finance (or an alternate similar source) to locate and review the balance sheet, income statement and statement of cash flows from the past fiscal reporting year. This assignment should be prepared professionally and formatted well, and include proper citations for sources used. FOUR CHOICES ONLY I tried to select some good ones: • Adidas (manufacturing – sports mgmt) • Urban Outfitters (merchandising) • Sony Music Entertainment (for our music industry group)...
Go to Yahoo! Finance, linked in Resources. Find a stock beginning with the letter 'G' Search...
Go to Yahoo! Finance, linked in Resources. Find a stock beginning with the letter 'G' Search your chosen stock. When you find it, click on the Historical Data tab to access historical stock price. Gather five years of daily adjusted stock price data by selecting the appropriate dates through the Time Period link. Be sure the end date includes days in this course (Sept 28). Click on the Download Data link to save the data to your computer. The file...
Go to any financial information website such as Yahoo Finance and find the beta coefficient of...
Go to any financial information website such as Yahoo Finance and find the beta coefficient of any stock you choose. Complete the following tasks. Name the stock. Using the beta and the capital asset pricing model formula calculate the expected return if the current risk-free rate is 2% and the market’s is expected return is 5%. Your stock has recently returned 6% and you expect this rate of return to continue into the future. Is this an acceptable rate of...
Please find any two articles from any source (google or any other source, please mention the...
Please find any two articles from any source (google or any other source, please mention the source), each of which satisfies one of the criteria below. Do not use two articles with the same analytical technique. The article uses correlation or multiple regression. The article uses a cluster analysis. Describe the purpose of each of the two articles. Explain how the complex analysis used satisfies this purpose, and what it demonstrates. The limit is one page (300 words) per article.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT