no excel workings please

A US chemical producer was about to modify an existing plant to produce a specialty product, polyzone, which was in short supply on world markets. The table below shows a simplified version of management's analysis (Figures are in R millions except as noted) Investment Production, millions of pounds per year Spread, R per pound Net Revenues 100 5 1.20 0 10 1.20 40 1.20 1.10 0.95 0.90 Production costs Transport 2020202020 Other costs Cash Flow Additional information 1. There is no inflation and no taxes. 2. There is no salvage value for plant and equipment after 10 years 3. Production capacity is 80 million pounds per year. 4. Production costs are R0.375 per pound after start up (R0.75 per pound in year 2 when production is only 40 million pounds) 5. Transportation costs are RO 10 per pound 6. Cost of capital is 8% Required 1. Complete the table by computing the net revenues, production costs, transport costs, and cash flows. [5 marks] [10 marks] 2 Calculate the Net Present Value of the project