Stock Valuation Template

Please answer fast I give you upvote

1 Free Cash Flow Valuation Model 2 3 INPUTS (In millions) 4 5 6 Free cash flow 7 Marketable securities 8 Notes payable 9 Long-term bonds 10 Preferred stock 11 WACC 12 Number of shares of stock 13 B Current 0 $40 $120 $360 $60 13.00% 25 1 D E F Year Projected 2 3 4 -$15.0 $15.0 $50.0 $54.0 14 a. Calculating the estimated horizon value (i.e., the value of operations at the end of the forecast 15 period immediately after the Year-4 free cash flow) 16 Constant long-term growth rate 17 Horizon value at Year 4 18 million Formulas #N/A #N/A 19 b. Calculating the present value of the horizon value, the present value of the free cash flows, 20 and the estimated Year-0 value of operations 21 Present value of HV 22 Present value of FCF 23 Value of operations 24 million #N/A million million #N/A #N/A 25 c. Calculating the estimated Year-0 price per share of common equity 26 Value of operations 27 + Value of marketable securities 28 Total intrinsic value 29 Value of total debt 30 - Value of…

SNL1

aa.3

Please fast step by step full solution

son.4

X8

Nikul

Baghiben

Sh11

I need this question financial accounting

naran

do not provide image in solution

Destin Company Information: Total Assets $940,000 Total Liabilities $600,000 Cost of debt 5.8% Risk-free rate 1.97% Beta 0.89 Market Return 10%   A) Using CAPM, what is cost of equity? (so you are not confused, the opportunity cost of using equity is the return we were expecting to receive on the equity).  a)8.03% b)7.77% c) 9.12% d) 8.9% B) What is Destin's Weighted Average Cost of Capital? a) 6.22% b) 5.89% c) 6.07% d) 5.72%

answer quickly

What's the equation in excel and answer?

Financial Accounting Question please solve this problem

vipul

You've collected the following information from your favorite financial website. 52-Week Price Hi 77.40 56.01 130.93 50.24 35.00 Lo 10.43 33.62 69.50 13.95 Manta Energy .80 20.74 Winter Sports .32 Stock (Dividend) a. Highest dividend yield b. Lowest dividend yield Acevedo .36 Georgette, Incorporated 1.74 YBM 2.00 ** Dividend Yield % PE Ratio Close Price Net Change 2.6 6 -.24 -.01 10 10 3.07 6 -.26 28 18 Find the quote for the Georgette, Incorporated. Assume that the dividend is constant. a. What was the highest dividend yield over the past year? Note: Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16. b. What was the lowest dividend yield over the past year? Note: Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16. % % 2.2 5.2 1.5 13.90 40.63 88.97 15.43 22 4

Baghiben

Want to this question answer financial accounting

X7

1 You've collected the following information from your favorite financial website. 52-Week Price Lo 10.43 Acevedo .36 Hi 77.40 55.81 130.93 50.42 35.00 Stock (Dividend) Required retum 33.42 Georgette, Incorporated 1.54 YBM 2.00 69.50 14.13 Manta Energy .98 20.74 Winter Sports.32 Dividend PE Ratio. Yield % 2,65 3.8 2.2 6.3 1.5 6 10 10 6 28 Close Price: Net Change 13.90 40.43 88.97 15.61 77 According to your research, the growth rate in dividends for Manta Energy for the previous 10 years has been negative 13 percent. If investors feel this growth rate will continue, what is the required return for the stock? Note: A negative answer should be indicated by a minus sign. Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16. -24 -.01 3.07 -.26 18

ff2

Given Investment E(R) σ Stock A $15,000 10% 10% Stock B $5,000 5% 25% Total $20,000 and Corr(AB) = PAB = −0.25. Find the Covariance between returns of A and B -0.00525 O 0.0625 -0.00625 0.00625 -0.0625

A share just paid a dividend of... Please solve this financial accounting problem