Winston Clinic is evaluating a project that costs $50,000 and has expected net cash inflows of...

Free

80.2K

Verified Solution

Question

Finance

Winston Clinic is evaluating a project that costs $50,000 andhas expected net cash inflows of $12,000 per year for eight years.The first inflow occurs one year after the cost outflow, and theproject has a cost of capital of 12%. What is the project’s MIRR?(hint: remember to put the answer as a percentage). Choice: 13.9%Choice: 14.5% Choice: 5.80% Choice: 22.1%

Answer & Explanation Solved by verified expert
3.8 Ratings (588 Votes)

14.5%

Year Cash flows
0 $       -50,000
1             12,000
2             12,000
3             12,000
4             12,000
5             12,000
6             12,000
7             12,000
8             12,000
Cost of capital 12%
MIRR =MIRR(values,finance rate,reinvestment rate)
=MIRR(B2:B10,B12,B12)
14.5%
B2:B10 is the range of cash flows and B12 is the cost of capital and reinvestment rate.

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

Transcribed Image Text

Winston Clinic is evaluating a project that costs $50,000 andhas expected net cash inflows of $12,000 per year for eight years.The first inflow occurs one year after the cost outflow, and theproject has a cost of capital of 12%. What is the project’s MIRR?(hint: remember to put the answer as a percentage). Choice: 13.9%Choice: 14.5% Choice: 5.80% Choice: 22.1%

Other questions asked by students