Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I have entered the formula to find the MIRR, but all I am getting is #VALUES in my answer. What am I doing wrong =(B10;G10;B5:B6)

I have entered the formula to find the MIRR, but all I am getting is #VALUES in my answer. What am I doing wrong

=(B10;G10;B5:B6)

Cost of Capital 12%

Reivestmnet Rate 5.90%

Initial Cost Cashflows at end of relevantyear

Project Erie 0 1 2 3 4 5 MiRR

-12,000 2,360 4,390 1,520 980 1,250 #VALUE!

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals of Corporate Finance

Authors: Richard Brealey, Stewart Myers, Alan Marcus

8th edition

77861620, 978-0077861629

Students also viewed these Finance questions