please show how to calculate in excel , i know answers i want to know...

60.1K

Verified Solution

Question

Accounting

image
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.)

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students