This paper circulates around the core theme of Yahoo!Finance database and perform elements of securities analysis involving a select group of together with its essential aspects. It has been reviewed and purchased by the majority of students thus, this paper is rated 4.8 out of 5 points by the students. In addition to this, the price of this paper commences from £ 99. To get this paper written from the scratch, order this assignment now. 100% confidential, 100% plagiarism-free.
Yahoo!Finance database and perform elements of securities analysis involving a select group of… 1 answer below » Yahoo!Finance database and perform elements of securities analysis involving a select group of companies. Company – Proctor and Gamble Financial Analysis Exercise IV Part A: Weighted Average Cost of Capital (WACC) Worksheet Here again is the formula for WACC. For simplicity the term for preferred stock has been removed: 1. Go to http://thatswacc.com/ and enter the ticker symbol for the stock you selected and click on the tab entitled “Calculate WACC.” 2. Complete the following table. Document Preview: View complete question » Yahoo!Finance database and perform elements of securities analysis involving a select group of companies. Company – Proctor and Gamble Financial Analysis Exercise IV Part A: Weighted Average Cost of Capital (WACC) Worksheet Here again is the formula for WACC. For simplicity the term for preferred stock has been removed: 1. Go to http://thatswacc.com/ and enter the ticker symbol for the stock you selected and click on the tab entitled “Calculate WACC.” 2. Complete the following table. Document Preview: Yahoo!Finance database and perform elements of securities analysis involving a select group of companies. Company – Proctor and Gamble Financial Analysis Exercise IV Part A: Weighted Average Cost of Capital (WACC) Worksheet Here again is the formula for WACC. For simplicity the term for preferred stock has been removed: 1. Go to http://thatswacc.com/ and enter the ticker symbol for the stock you selected and click on the tab entitled “Calculate WACC.” 2. Complete the following table. Cost of debt, iD Corporate tax rate, TC Total debt, D Total equity, E Total value of the firm, V Beta, ß Return on the market, iM Risk-free rate, iF WACC Per http://thatswacc.com/faccs.php the components of the WACC equation are calculated using the following financial data: From the balance sheet: Period ending Last Fiscal Year Last Fiscal Year -1 Last Fiscal Year -2 Short term debt + Current portion of long term debt (CMLTD) Long Term Debt Total debt, D From the income statement: Period ending Last Fiscal Year Interest expense Income before tax Last Fiscal Year -1 Last Fiscal Year -2 Income tax Other data: Firm’s current market capitalization (intraday sock price · shares outstanding) Firm’s beta, ß Return on the market, iM Assume 11% Risk-free rate, iF Assume 3% The calculations in the table are based on the following: 1. Total debt, D, is the sum of Short term debt + CMLTD + Long Term Debt 2. Total equity, E, is the firm’s current market capitalization = current stock price times the number of shares outstanding 3. Total value of the firm, V, equals Total debt, D, + Total equity, E 4. Cost of debt, iD, = Interest pd in most recent fiscal yr/(Sum of total debt in last two fiscal yrs/2) 1.i. = Interest expense/Average debt 5. Corporate tax, Tc, the firm’s corporate tax rate = Sum of prior three fiscal yrs’ Income tax expense/ Prior three yrs’ Income before tax 6. Firm’s cost of equity, (Source: http://thatswacc.com/faccs.php) Financial Analysis Exercise IV Part B: Dividend Payout and… Attachments: Q..docx Q.-Attachment….docx View less » Sep 11 2015 01:24 PM
