Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please solve questions with Excel ABC Company is going through a period of fast growth. You want to know the current value of the stock
Please solve questions with Excel
ABC Company is going through a period of fast growth. You want to know the current value of the stock price and have gathered the following information current stock price Market Return Risk Free Rate Beta of ABC Number of Shares Initial Growth Rate (for the first 4 years) Second growth rate (perpetual): Most Recent Dividend Tax Rate $12 7% 1.5% 1.2 1,000,000 20% 3% $1.5 30% 28,000 Number of Bonds Bond Details Coupon rate Initial yield to maturity Settlement date Maturity date Face value # of coupons per year 3% 6% 1/1/2020 1/1/2024 100 4 Cost of Debt 6% Information from most recent BS and IS to calculate FCFF and FCFE Decrease in debt (10,000) EBIT 1,600,000 depreciation 5,000 interest exp 11,000 Capital expenditure 48,000 Increase in NWC 1,500 Current Market Price for a single bond Bond Price: Cost of Equity Cost of Equity: WACC Market Value of Debt: Market Value of Equity: Market Value of Firm: Weight of Debt: Weight of Equity: WACC: FCFF & FCFE FCFF: FCFE: Estimate the stock price using Constant Growth Model model and Most Recent Dividend information {use perpetual growth rate 3% } Stock Price: Estimate the stock price using Constant Growth model and FCFE{use perpetual growth rate 3%} Market Value of Equity: Stock Price: Estimate the stock price using Constant Growth model and FCFF {use perpetual growth rate 3%} Market Value of Firm: Market value of Equity: Stock Price: ABC Company is going through a period of fast growth. You want to know the current value of the stock price and have gathered the following information current stock price Market Return Risk Free Rate Beta of ABC Number of Shares Initial Growth Rate (for the first 4 years) Second growth rate (perpetual): Most Recent Dividend Tax Rate $12 7% 1.5% 1.2 1,000,000 20% 3% $1.5 30% 28,000 Number of Bonds Bond Details Coupon rate Initial yield to maturity Settlement date Maturity date Face value # of coupons per year 3% 6% 1/1/2020 1/1/2024 100 4 Cost of Debt 6% Information from most recent BS and IS to calculate FCFF and FCFE Decrease in debt (10,000) EBIT 1,600,000 depreciation 5,000 interest exp 11,000 Capital expenditure 48,000 Increase in NWC 1,500 Current Market Price for a single bond Bond Price: Cost of Equity Cost of Equity: WACC Market Value of Debt: Market Value of Equity: Market Value of Firm: Weight of Debt: Weight of Equity: WACC: FCFF & FCFE FCFF: FCFE: Estimate the stock price using Constant Growth Model model and Most Recent Dividend information {use perpetual growth rate 3% } Stock Price: Estimate the stock price using Constant Growth model and FCFE{use perpetual growth rate 3%} Market Value of Equity: Stock Price: Estimate the stock price using Constant Growth model and FCFF {use perpetual growth rate 3%} Market Value of Firm: Market value of Equity: Stock PriceStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started