Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can someone show me how to reproduce this graph in excel step by step please. Use the given parameters. This is a sensitivity analysis. 2.
Can someone show me how to reproduce this graph in excel step by step please. Use the given parameters. This is a sensitivity analysis.
2. (10 Marks) Sensititivity for Price of Monoclonal Antibodies (MAB) Price of MAB: 9,200 USD/kg, 9,300 USD/kg, 9,400 USD/kg and 9,500 USD/kg. Sheet "Economic Inputs" in red highlight. Calculate and produce one chart with two axis: Net Present Value (NPV) and Interest Rate on Return (IRR). Paste the chart here. What is the approximate price of MAB that provides our cut off IRR of 20%? $9275 NPV Sensititivity for Price of Monoclonal Antibodies (MAB) $80,000,000.00 60.00% $70,000,000.00 50.00% $60,000,000.00 40.00% $50,000,000.00 30.00% $40,000,000.00 $30,000,000.00 20.00% $20,000,000.00 10.00% $10,000,000.00 0.00% $0.00 -10.00% $9,200 $9,300 $9,400 $9,500 Price IRR NPV IRR 2. (10 Marks) Sensititivity for Price of Monoclonal Antibodies (MAB) Price of MAB: 9,200 USD/kg, 9,300 USD/kg, 9,400 USD/kg and 9,500 USD/kg. Sheet "Economic Inputs" in red highlight. Calculate and produce one chart with two axis: Net Present Value (NPV) and Interest Rate on Return (IRR). Paste the chart here. What is the approximate price of MAB that provides our cut off IRR of 20%? $9275 NPV Sensititivity for Price of Monoclonal Antibodies (MAB) $80,000,000.00 60.00% $70,000,000.00 50.00% $60,000,000.00 40.00% $50,000,000.00 30.00% $40,000,000.00 $30,000,000.00 20.00% $20,000,000.00 10.00% $10,000,000.00 0.00% $0.00 -10.00% $9,200 $9,300 $9,400 $9,500 Price IRR NPV IRRStep 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