Murphy Toys Inc., a U.S.-based MNC, has screened several targets. Based on economic and political considerations, only one eligible target remains in Malaysia. Murphy would like you to value this target and has provided you with the following information:

Murphy expects to keep the target for three years, at which time it expects to sell the firm for 280 million Malaysian ringgit (MYR) after any taxes.

Murphy expects a strong Malaysian economy. The estimates for revenue for the next year are MYR200 million. Revenues are expected to increase by 8% in each of the following two years.

Cost of goods sold is expected to be 50% of revenue.

Selling and administrative expenses are expected to be MYR30 million in each of the next three years.

The Malaysian tax rate on the target's earnings is expected to be 25 percent.

Depreciation expenses are expected to be MYR22 million per year for each of the next three years.

The target will need to reinvest MYR6 million in cash each year to support existing operations.

The target's stock price is currently MYR32 per share. The target has 8.5 million shares outstanding.

Any remaining cash flows will be remitted by the target to Murphy Inc. Murphy uses the prevailing exchange rate of the Malaysian ringgit as the expected exchange rate for the next three years. This exchange rate is currently $.27.

Murphy’s required rate of return on similar projects is 18 percent.

a) Prepare a worksheet to estimate the value of the Malaysian target based on the information provided. Structure it to look like Exhibit 15.2 in the text.