Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I am doing a project oon f Stock Valuation where we select a company and do the stock valuation analysis for upcoming 7 years. I

I am doing a project oon f "Stock Valuation" where we select a company and do the stock valuation analysis for upcoming 7 years.

I was following professors instruction solving this, but at the ending part, some of my values started getting negative in value.

Current Enteprise Value is negative and the final Stock price is also negative (-48.929504) Can it be negative? Did I make any error or mistake on any part or my calculation is correct?

P.s forumula I used in Stock Price is =(B72-B74)/B75

image text in transcribed

FCF Forecast 0 1 2 3 4 5 6 7 365,817,000 15.43% Year Sales Growth vs prior year EBIT Income Tax PPE Deprecitation Net Working Capital Ratio Change in PPE Change in NWC Free Cash Flow 0.276 0.146 0.349 0.113 109,723,000 422,262,563 15.43% 116,408,448 16,946,844 147,212,192 16,703,270 54,139,766 37,489,192 44,784,766 33,890,916 487,417,677 15.43% 134,370,272 19,561,742 169,927,033 19,280,584 62,493,532 22,714,841 8,353,766 103,020,507 562,626,224 15.43% 155,103,605 22,580,118 196,146,775 22,255,578 72,136,284 26,219,741 9,642,752 118,916,572 649,439,450 15.43% 179,036,091 26,064,231 226,412,222 25,689,614 83,266,913 30,265,447 11,130,629 137,265,399 749,647,958 22.66% 206,661,360 30,085,942 261,347,628 29,653,521 96,114,997 34,935,406 12,848,085 158,445,450 919,543,935 22.66% 253,497,923 36,904,449 320,577,978 36,374,028 117,897,957 59,230,350 21,782.960 171,954,192 1,127,944,177 22.66% 310,949,260 45,268,265 393,231,959 44,617,632 144,617,684 72,653,982 26,719,727 210,924,919 0.128 9,355,000 WACC Enterprise value for 5 years 9.01% -1,423,485,233 Year 1 Year 2 Year 3 Year 4 Year 5 PV cash flow (by 5 years ) 31,089,731 86,694,392 91,800,144 97,206,592 102,931,446 Current Enteprise Value -515,021,154 Total Liability Shares Outstanding Stock Price 287,912,000 16,410,000 -48.929504

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_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

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

Get Started

Recommended Textbook for

Comparative Public Budgeting

Authors: George M Guess

2nd Edition

1316648109, 978-1316648100

More Books

Students also viewed these Finance questions