Use the Microsoft Excel Model in a File Folder Entitled

question 81

Essay

Use the Microsoft Excel model in a file folder entitled Target Valuation Model on the companion site to this book to address the following questions. The model already contains data and an estimate of Life Tech’s enterprise and equity valuations based on this data and a set of assumptions about the planning period spanning 2014 through 2018, as well as the years beyond. In answering the following questions, assume the valuation provided in this model represents the firm’s base case and reflects what the firm could do if it continued the business strategy in effect in 2012.
-Given the results of the model from questions (1) and (2), assume Mr. Lucier and the Life Tech board increased their target debt to equity ratio from 30 percent to 75 percent. Recalculate the firm's weighted average cost of capital assuming that none of the assumptions about the cost of capital made in the base case have changed, with the exception of the levered beta. (Hint: The levered beta needs to be unlevered and then relevered to reflect the new debt to equity ratio). Without undoing the assumption changes made in questions (1) and (2), use your new estimate of the firm's WACC during the planning period to calculate Life Tech's enterprise and equity values given on the Valuation Worksheet. Briefly explain why the change in the debt to equity ratio affected firm value.

---

Definitions:

Team Sports

Sports that involve players working together towards a common objective, typically involving competitive play against another team.

Organized Sports

structured physical activities, usually competitive, that are governed by a set of rules and organized by leagues, clubs, or associations.

Middle Childhood

A developmental stage that encompasses the period from around 6 to 12 years of age, when children are typically in elementary school.

Adolescence

The transitional developmental phase between childhood and adulthood, characterized by significant physical, psychological, and social changes.