Question: please show how to calculate in excel , i know answers i want to know how to find it in excel thank you Butler International

 please show how to calculate in excel , i know answers
please show how to calculate in excel , i know answers i want to know how to find it in excel thank you

Butler International Limited is evaluating a project in Erewhon. The project will create the following cash flows: Year 0 WN - Cash Flow $1,290,000 465,000 530,000 425,000 380,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 is 3 percent. If the company uses a required return of 12 percent on this project, what are the NPV and IRR of the project? (Negative amounts should be indicated by a minus sign. Do not round intermediate calculations and round your final answers to 2 decimal places, e.g., 32.16. Enter your IRR answer as a percent.)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!