i need this one question completed in excel. i will pay $10 and need it in 24 hours.

Project Description:

hastings estimates that if it acquires vandell, interest payments will be $1,500,000
per year for 3 years, after which the current target capital structure of 30% debt
will be maintained. interest in the fourth year will be $1.472 million, after which
interest and the tax shield will grow at 5%. synergies will cause the free cash flows
to be $2.5 million, $2.9 million, $3.4 million, and $3.57 million in years 1 through 4,
respectively, after which the free cash flows will grow at a 5% rate. what is the
unlevered value of vandell, and what is the value of its tax shields? what is the per
share value of vandell to hastings corporation? assume that vandell now has
$10.82 million in debt.
Skills Required:
Project Stats:

Price Type: Negotiable

Total Proposals: 5
1 Current viewersl
13 Total views
Project posted by:


Proposals Reputation Price offered