Purchase Solution

Corporate Valuation, Value-Based Management

Not what you're looking for?

Ask Custom Question

I am stumped and need some help. I would like you to do the entire problem but PLEASE show all your work so I can understand what is necessary to learn to do this. The word doc is the problem and the Excel doc is the template I would like it finished in.

Start with the partial model in the file Ch13 P11 Build a Model.xls on the textbook's Web site. The Henley Corporation is a privately held company specializing in lawn care products and services. The most recent financial statements are shown below. Income Statement for the Year Ending December 31 (Millions of Dollars Except for Per Share
Data)

a. Forecast the parts of the income statement and balance sheet that are necessary for calculating free cash flow.
b. Calculate free cash flow for each projected year. Also calculate the growth rates of free cash flow each year to ensure that there is constant growth (that is, the same as the constant growth rate in sales) by the end of the forecast period.
c. Calculate operating profitability (OP = NOPAT/Sales), capital requirements (CR = Operating capital/Sales), and expected return on invested capital (EROIC = Expected NOPAT/Operating capital at beginning of year). Based on the spread between EROIC and WACC, do you think that the company will have a positive Market Value Added (MVA = Market value of company ? Book value of company = Value of operations ? Operating capital)?
d. Calculate the value of operations and MVA. (Hint: First calculate the horizon value at the end of the forecast period, which is equal to the value of operations at the end of the forecast period.) Assume that the annual growth rate beyond the horizon is 6%.
e. Calculate the price per share of common equity as of 12/31/2010.

Purchase this Solution

Solution Summary

I used formula so you can see how I arrived at the answers. If you are confused about anything, please let me know.

Purchase this Solution


Free BrainMass Quizzes
Operations Management

This quiz tests a student's knowledge about Operations Management

Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking