Question

In: Finance

Estimate the firm's stock price using the information below You may use the time value of...

Estimate the firm's stock price using the information below
You may use the time value of money formula or the Excel NPV function
Beta 1.24
rf 1%
MRP 5%
SHOW EQUATIONS USED IN EXCEL
Time Dividend ($) Div growth (g)
0 5.00
1 0%
2 9%
3 7%
4 5%
5 3%
6 2% per year, forever
7
8
9
10

Solutions

Expert Solution


Related Solutions

Using the schedule of cash flows and other information below, estimate the firm's value of operations...
Using the schedule of cash flows and other information below, estimate the firm's value of operations by discounting the cash flows back to the present (time value of money formula) Compute the value of operations a second way by using the NPV formula in Excel FCFF See cash flow schedule WACC 18% Debt 75 million Number of shares 100 million show excel formulas Time FCFF, millions 0 1 -2 2 10 3 18 4 30 5 52 6 56 7...
Use the below data to estimate the price elasticity of demand for retail gasoline using a...
Use the below data to estimate the price elasticity of demand for retail gasoline using a log-linear model to identify how different factors may impact the price elasticity of demand for gasoline: Gasoline Sales (in thousands of gal) Prices (in $/gal) # of vehicles sold (in millions) Income Per Capita Month 1             19,492 $            2.31 17.026 $             45,404 Month 2             20,134 $            2.52 17.773 $             45,490 Month 3             20,049 $            2.80 17.049 $             45,453 Month 4            ...
USE THE INFORMATION BELOW FOR PROBLEMS 1-4 An analyst wishes to estimate the share price for...
USE THE INFORMATION BELOW FOR PROBLEMS 1-4 An analyst wishes to estimate the share price for Ashley Corporation. The following information is made available: Estimated profit margin = 15% Total asset turnover = 2 Financial leverage = 1.2 Estimated dividend payout ratio = 75% Required rate of return = 14% Estimated EPS = $2.50 1. Calculate the firm's ROE. 2. Calculate the firm's sustainable growth rate. 3. Calculate the firm’s P/E multiple. 4. Calculate the firm’s estimated share price. USE...
Use below-given dataset: Stock Price 20 Exercise Price 32 Time to Maturity in years 1 Risk...
Use below-given dataset: Stock Price 20 Exercise Price 32 Time to Maturity in years 1 Risk Free Rate 8% Volatility 30% A) Calculate Call and Put Price. (2.5+2.5=5) Greeks are given below: Call Put Delta 0.1251 -0.8749 Gamma 0.0343 0.0343 Theta -0.0022 0.0043 Vega 0.0412 0.0412 Rho 0.0217 -0.2737 B) Interpret the GREEKS in detail. (3*5=15)
Use below-given dataset: Stock Price 40 Exercise Price 35 Time to Maturity in years 0.25 Risk...
Use below-given dataset: Stock Price 40 Exercise Price 35 Time to Maturity in years 0.25 Risk Free Rate 6% Volatility 40% A) Calculate Call and Put Price. (2.5+2.5=5) Greeks are given below: Call Put Delta 0.8003 -0.1997 Gamma 0.0350 0.0350 Theta -0.0165 -0.0108 Vega 0.0559 0.0559 Rho 0.0638 -0.0224 B) Interpret the GREEKS in detail. (3*5=15)
• Using the “Ask” as the price of the option, calculate intrinsic value and time value...
• Using the “Ask” as the price of the option, calculate intrinsic value and time value for each call and put option. CALL OPTIONS PUT OPTIONS Open Int Vol Change Last Bid Ask Intrinsic Time Stock Price Strike Intrinsic Time Bid Ask Last Change Vol Open Int 0 0 0 74 98.8 100.5 $479.93 380 0.03 0.16 0.15 0 0 1,135 0 0 0 68.01 89.9 90.55 $479.93 390 0.1 0.15 0.23 0 0 418 41 14 4.16 81.2 80...
A researcher obtained the ordinary least squares (OLS) estimates for a Ghanaian firm's stock price using...
A researcher obtained the ordinary least squares (OLS) estimates for a Ghanaian firm's stock price using 120 observations from 1980 ml to 1989 m 12 (All variables in logarithms) as: In St = 0.87 -054 In pt + 0.65 In yt + 0.34 In rt - 0.32 In mt Standard errors: pt = (1.06) yt = (0.24) rt = (0.12) mt = (0.24) Adjusted R2=0.34, RSS = 1.24, F1154 =3.75 St are the log of the stock price, pt is...
If, using the one-period model, you calculate a fair price (present value) of a stock to...
If, using the one-period model, you calculate a fair price (present value) of a stock to be $25/share, but the same stock is currently trading at $29.00/share on Nasdaq what should you do Buy the stock as the present value of the stock is lower than the current stock price Sell the stock as the present value is higher than the current stock price Sell the stock as the present value is lower than the current stock price Buy the...
Question 13 Given the information below, calculate the firm's cost of equity for use in its...
Question 13 Given the information below, calculate the firm's cost of equity for use in its calculation of its Weighted Average Cost of Capital. Assume that your firm has made the decision to weight the Capital Asset Pricing Model as 40% and the Constant Growth Dividend Discount Model as 60% in its calculations. Your answer: Given Information: Firm's Beta 0.81 Last Dividend Paid $0.45 10-Year Treasury Yield 2.15% Expected Dividend Growth Rate 4.20% Market Risk Premium 5.50% Current Stock Price...
Using the data in the table​ below, estimate the demand function for cod.                                                                                                                           ​Price, dollars...
Using the data in the table​ below, estimate the demand function for cod.                                                                                                                           ​Price, dollars per pound ​Quantity, thousand pounds per day 1.90 1.5 1.35 2.2 1.25 4.4 1.20 5.9 0.95 6.5 0.85 7.0 0.73 8.8 Using the Excel trendline option to estimate a linear demand​ function, the linear demand function is Qequals=12.53 minus 6.25 p12.53−6.25p. Suppose the quantity in the first row of the table were 22 instead of 1.5. The linear demand function would now be Qequals=nothingminus−nothingp....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT