Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed 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 IRR

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

The True Value Of Bitcoin Revealed

Authors: Satoshi Nakaloco

1st Edition

More Books

Students also viewed these Finance questions