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

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
Get step-by-step solutions from verified subject matter experts
