need the excel answer with decimals. Would be great to understand how the PV for each year is calculated.

Anderson International Limited is evaluating a project in Erewhon. The project will create the following caslh flows: Year Cash Flow 0 1,170,000 345,000 410,000 305,000 260,000 4 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 is3 percent If Anderson uses a required return of 7 percent on this project, what are the NPV and IRR of the project? retum of 7 percent on this