Question

A piece of land may be bought for $700,000 to be strip-mined for coal. Annual net income will be $300,000 a year for 10 years. At the end of the 10 years, the surface of the land will be restored as required by a federal law on strip mining. The reclamation will cost $1,500,000 more than the resale value of the land after it is restored. Using a 10% interest rate compounded quarterly, find the present worth of this project (Don't use the $ sign in your answer)

Answer 1

Please refer to below spreadsheet for calculation and answer. Cell reference also provided.

Cell reference -

Hope this will help, please do comment if you need any further explanation. Your feedback would be appreciated.