Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help with this MIRR formula excel please write down the formula please Discount rate 0.095 (initial discount rate 4. This set of cash flows

Please help with this MIRR formula excel please write down the formula please

image text in transcribed

Discount rate 0.095 (initial discount rate 4. This set of cash flows relates to a potential project your firm is evaluating. Your "hurdle rate" or the minimum rate of return you must earn is 9.5% Period FV (+) 3 0 5,431,732 3,720,364 2,548, 195 a. calculate the MIRR in E25 and leave the formula intact. Copy and paste this initial answer as a value into cell (E26). Cash Flows Negatives PV (-) Positives 0 (4,000,000) (4,000,000.0) (4,000,000.0) 1 2,400,000 2,400,000 2 1,800,000 1,800,000 3 1,350,000 1,350,000 4 (4,050,000) (4,050,000.0) (2,817,075.9) 5 2,400,000 2,400,000 6 1.800.000 1,800,000 7 1,350,000 1,350,000 8 (3,600,000) (3,600,000.0) (1,741,765.0) 9 (1,500,000) (1,500,000.0) (662,772.1) 10 4,079,768 4,079,768 (9,221,612.9) 3,778,173 2,587,790 1,772,459 b. what would be the maximum price you would pay in period one (instead of the - 4,000,000) to achieve 12% MIRR? Leave that value in your model in cell E11 and copy to E27 4,079,768 23.918.480.01 tulations. You have reached the end CERCETATENEO LOS are beint When YOL TRAisties with Po SENESTE TEST te Part a - MIRR MIRR Payment 1 first part (leave formula intact) Paste as value

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Experiences With Financial Liberalization

Authors: K. L. Gupta

1st Edition

079239853X, 978-0792398530

More Books

Students also viewed these Finance questions