The project will last for 8 years, beginning in 2011 (year 0) and ending in 2019 (year 8). Depreciation is straight line to zero, and taxation (at the time) is 35% in the United States. In any year with a negative EBIT, there is no tax. The capital investment for the fibre line project is $350,000,000 (invested in year 0), including costs of amplification sites, earthmoving equipment, easements etc. Working capital is expected to be $60,000,000, returned at the end of the project. A 24 hours a day, 7 days a week maintenance team is required to ensure 99.99% operational capacity, costing $60 million per year, and increasing at 3% per year. The project success hinges on access to the fibre ports in the exchanges, they know this and charge $50,000,000 per year (combined), declining by 5% p.a. as demand declines. A team of surveyors and builders who inspected the 1400 km path cost $1.5 million. At the end of the project, the technology is obsolete for its purpose in investment banking, but it can be sold to a telecom provider (contributing to the revenue for year 8) for $127,000,000. Revenue is subscription based at $3,600,000 per year, per subscription. In year 1 there will be 200 subscriptions, year 2 is 150, year 3 is 100, year 4 is 50. In year 5, 6, 7, 8 only 20 subscriptions are taken in per year. The all-important discount rate is 14.5%.

Question: What is the NPV and IRR using excel?