Anderson International Limited is evaluating a project in Erewhon. The project will create the following cash flows:

Year Cash Flow

0-$1,320,000

1495,000

2560,000

3455,000

4410,000

All cash flows will occur in Erewhon and are expressed in dollars. In an attempt to improve its economy, the Erewhonian government has declared that all cash flows created by a foreign company are "blocked" and must be reinvested with the government for one year. The reinvestment rate for these funds is 3 percent.

If Anderson uses a required return of14 percent on this project, what are the NPV and IRR of the project?(Anegative answershould be indicated by a minus sign. Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16. Enter your IRR as a percent.)

I have attempted this many times but my answer is not matching the correct answer. Please provide a detailed spreadsheet or some sort of explanation.