Profile
In this section, you should include the profile of the company as reported by Yahoo! Finance. You may also include some important recent financial news related to the firm.
Dividend Growth
In this section, you should present a graph of the dividends paid by the firm over the last five years and compute the historical annual dividend growth.
Cost of Equity
In this section, you should apply the Capital Asset Pricing Model to compute the cost of equity for your firm.
Stock Valuation
Constant growth
In this subsection, you should apply the Gordon Model for computing the value of the stock.
Non-constant growth
In this subsection, you should apply the non-constant growth (two stage model) for computing the value of the stock.
In both cases, you should assume that the discount rate is equal to the cost of equity computed in section 3.
Tax Rate and Cost of Debt
In this section, you should compute and report the average tax rate and the cost of debt for your firm using data from Yahoo! Finance.
Bond Valuation
In this section you should compute and report the price of the bond for your firm. As the discount rate, you should use the cost of debt computed in 5. You should also plot the bond price vs the required return.
Cost of Capital
In this section, you should compute and report the cost of capital of your firm.
Project Analysis
In this section, you should first compute and report the cash flows for each year of the project and then use the WACC computed in section 7 to give a recommendation about the project using the NPV and IRR rules.
APPENDIX
You should also print the Excel workbook containing all your calculations and submit it as an appendix.
Document Preview:
FINANCIAL REPORT FOR XXXX Profile In this section, you should include the profile of the company as reported by Yahoo! Finance. You may also include some important recent financial news related to the firm. Dividend Growth In this section, you should present a graph of the dividends paid by the firm over the last five years and compute the historical annual dividend growth. Cost of Equity In this section, you should apply the Capital Asset Pricing Model to compute the cost of equity for your firm. Stock Valuation Constant growth In this subsection, you should apply the Gordon Model for computing the value of the stock. Non-constant growth In this subsection, you should apply the non-constant growth (two stage model) for computing the value of the stock. In both cases, you should assume that the discount rate is equal to the cost of equity computed in section 3. Tax Rate and Cost of Debt In this section, you should compute and report the average tax rate and the cost of debt for your firm using data from Yahoo! Finance. Bond Valuation In this section you should compute and report the price of the bond for your firm. As the discount rate, you should use the cost of debt computed in 5. You should also plot the bond price vs the required return. Cost of Capital In this section, you should compute and report the cost of capital of your firm. Project Analysis In this section, you should first compute and report the cash flows for each year of the project and then use the WACC computed in section 7 to give a recommendation about the project using the NPV and IRR rules. APPENDIX You should also print the Excel workbook containing all your calculations and submit it as an appendix. from Yahoo! Finance. Bond Valuation In this section you should compute and report the price of the bond for your firm. As the discount rate, you should use the cost of debt computed in 5. You should also plot the bond price vs the required...