Johnson Company is contemplating a project with an investment that costs $1,000,000. The cost of money or discount rate is 10%. What is the NPV and IRR? Based upon the following cash flow data, should the company go ahead with the project? Why or why not? Please explain

You must use your financial calculator to solve this problem or no credit. You must show the sequence of keys used ( i.e. [CPT] [ENTER] [CF], etc.) or no credit. Your answer must reflect 4 decimal places to the right of the decimal point or no credit.

projected net cash flow

year 1-$260,000

year 2-$250,000

year 3-$226,000

year 4-$210,000

year 5-$205,000

year 6-$177,000