13. 6.13 PPG manufactures an epoxy amine that is used to protect the contents of polyethylene terephthalate (PET) containers from reacting with oxygen. The cash flows (in $ millions) associated with the process are shown below. Determine the rate of return using

(a) tabulated factors, and

(b) a spreadsheet.

(c) (Spreadsheet exercise) Demonstrate the use of GOAL SEEK to find i* if the IRR function were not available.

Table Summary: Table divided into 3 columns summarizes revenue generated within a period of six years. The column headers are marked as:

column 1, Year; column 2, Cost in dollars; column 3, Revenue in dollars.

Year Cost, $ Revenue, $

0 −10 —

1 −4 2 2 −4 3 3 −4 9 4 −3 9 5 −3 9 6 −3 9