Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started