Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

What is your estimate of present value of the equity of company (rounded to the nearest integer)? B D E F G H 1 J

What is your estimate of present value of the equity of company (rounded to the nearest integer)?

image text in transcribed

B D E F G H 1 J K L M N 0 Q 1 1 Year 1 3 6 9 11 15 2 0.15 4 0.15 5 0.15 7 0.1 8 0.1 10 0.1 12 0.05 13 0.05 141 0.05 2 0.15 0.1 0.1 0.05 0.05 3 4 70 80 80 80 80 90 90 5 Revenue Growth Revenue ($) Costs (% Revenues) Depreciation and Amortization Interest Expense Capital Expenditure (% Revenues) Change in NWC (NWC(n)-NWC(n-1)) Change in Debt 80,000,000 70 250,000 150,000 2 100,000 100,000 90 500,000 260,000 500,000 270,000 500,000 280,000 90 500,000 290,000 6 70 250,000 170.000 2 150,000 300,000 250,000 160,000 2 125.000 200,000 70 250,000 180,000 2 175,000 300,000 70 250.000 190,000 2 200,000 300,000 80 300,000 210,000 1.5 225,000 300,000 300,000 200,000 1.5 225,000 300,000 7 300,000 220,000 1.5 225,000 300,000 300,000 230,000 1.5 225,000 300,000 90 500,000 250,000 1 200,000 300,000 300,000 240,000 1.5 225,000 300,000 1 1 1 1 8 175,000 300,000 150,000 300,000 125,000 200,000 100,000 100,000 9 10 11 12 13 Tax Rate RF beta Market Risk Premium Growth in FCFE after Y15 (in perpetuity) 40% 4% 1.8 8% 3% 14 15 B D E F G H 1 J K L M N 0 Q 1 1 Year 1 3 6 9 11 15 2 0.15 4 0.15 5 0.15 7 0.1 8 0.1 10 0.1 12 0.05 13 0.05 141 0.05 2 0.15 0.1 0.1 0.05 0.05 3 4 70 80 80 80 80 90 90 5 Revenue Growth Revenue ($) Costs (% Revenues) Depreciation and Amortization Interest Expense Capital Expenditure (% Revenues) Change in NWC (NWC(n)-NWC(n-1)) Change in Debt 80,000,000 70 250,000 150,000 2 100,000 100,000 90 500,000 260,000 500,000 270,000 500,000 280,000 90 500,000 290,000 6 70 250,000 170.000 2 150,000 300,000 250,000 160,000 2 125.000 200,000 70 250,000 180,000 2 175,000 300,000 70 250.000 190,000 2 200,000 300,000 80 300,000 210,000 1.5 225,000 300,000 300,000 200,000 1.5 225,000 300,000 7 300,000 220,000 1.5 225,000 300,000 300,000 230,000 1.5 225,000 300,000 90 500,000 250,000 1 200,000 300,000 300,000 240,000 1.5 225,000 300,000 1 1 1 1 8 175,000 300,000 150,000 300,000 125,000 200,000 100,000 100,000 9 10 11 12 13 Tax Rate RF beta Market Risk Premium Growth in FCFE after Y15 (in perpetuity) 40% 4% 1.8 8% 3% 14 15

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

Options Futures And Other Derivatives

Authors: John C. Hull

9th Edition

0133456315, 9780133456318

More Books

Students also viewed these Finance questions