Question: 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

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

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

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!