I. Search Yahoo Finance, http://www.bloomberg.com or any other credible source to retrieve the most recent income statement and balance sheet for a major leveraged corporation. II. Provide these statements in proper format. III. Also, retrieve the data
I’m working on a Excel question and need guidance to help me study.
I. Search Yahoo Finance, http://www.bloomberg.com or any other credible source to retrieve the most recent income statement and balance sheet for a major leveraged corporation.
II. Provide these statements in proper format.
III. Also, retrieve the data on the company’s stock annual rate of return for the past 10 years.
IV. In addition, retrieve annual rate of return of a major financial index. Present this data as well.
V. 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.
VI. Suppose that the corporation is offered an investment which has the following cash flows.
In million doll.
|
Year |
0 |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
|
Cash flow |
-$10 |
$1,5 |
$1,5 |
$1,5 |
$1,5 |
$1,5 |
$1,5 |
$1,5 |
$1,5 |
$1,5 |
$1,5 |
- 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.
ORDER YOUR ORIGINAL PAPER
Request for a custom paper or place a new order
THE BEST CUSTOM ESSAY WRITING SERVICE AT YOUR FINGERTIPS
Forget All Your Assignment & Essay Related Worries By Simply Filling Order Form
