A new project will require development costs of $150 million at time zero, $225 million at the end of year 1. Revenues are expected to start at year three at $50 million per year, escalating by 8% each of years 4 through 10, then hold constant at the 10 year rate for the rest of the project, (years 10 through 15). There is a total equipment replacement cost required at the end of year 8 for $250 million and reclamation of $115 million, both occurring at the end of year 15. Assuming a 15% minimum rate of return.

-calculate dual rate of return

-calculate npv

-using "what if" analysis in excel, what does the revenue escalation rate have to be for the project to generate at 15% rate of return?

please show excel formulas.