Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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 Price

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_step_2

Step: 3

blur-text-image_step3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions

Question

Binomial distributions have two parameters. Name them.

Answered: 1 week ago