St. Paul Co. does business in the United States and New Zealand. In attempting to assess its economic exposure, it compiled the following information.

a. St. Pauls U.S. sales are somewhat affected by the value of the New Zealand dollar (NZD), because it faces competition from New Zealand exporters. It forecasts the U.S. sales based on the following three exchange rate scenarios:

Revenue from U.S. Business

Exchange Rate of NZD (in millions)

.48 USD/NZD USD 100

.50 USD/NZD USD 105

.54 USD/NZD USD 110

b. Its New Zealand dollar revenues on sales to New Zealand invoiced in New Zealand dollars are expected to be NZD 600 million.

c. Its anticipated cost of goods sold is estimated at USD 200 million from the purchase of U.S. materials and NZD 100 million from the purchase of New Zealand materials.

d. Fixed operating expenses are estimated at USD 30 million.

Variable operating expenses are estimated at 20 percent of total sales (after including New Zealand sales, translated to a dollar amount).

f. Interest expense is estimated at USD 20 million on existing U.S. loans, and the company has no existing New Zealand loans.

Create a forecasted income statement for St. Paul Co. under each of the three exchange rate scenarios. Explain how St. Paul's projected earnings before taxes are affected by possible exchange rate movements. Explain how it can restructure its operations to reduce the sensitivity of its earnings to exchange rate movements without reducing its volume of business in New Zealand.