Conduct sensitivity analysis for variable

Assignment Help Financial Management

Reference no: EM131880204

Blooper’s analysts have come up with the following revised estimates for its magnoosium mine:

Range

Pessimistic Optimistic

Initial investment + 40 % – 20 %

Revenues – 25 % + 25 %

Variable costs + 20 % – 25 %

Fixed cost + 20 % – 30 %

Working capital + 40 % – 45 %

Conduct a sensitivity analysis for each variable and range and compute the NPV for each. Use Spreadsheet 10.1 and accompanying data as a starting point for the analysis. (Do not round intermediate calculations. Negative amounts should be indicated by a minus sign. Enter your answers in thousands rounded to the nearest whole dollar.)

Project NPV

Pessimistic Expected Optimistic

Initial investment

Revenues

Variable costs

Fixed costs

Working capital

Reference no: EM131880204

Questions Cloud

Identify peer-reviewed published research articles : Identify, review, and copy (for submission to course instructor) two peer-reviewed published research articles: one quantitative and one qualitative study.

Should governments be involved in regulating health care : Identify at least two federal and state health care agencies (at least one of each) that regulate quality in health care organizations.

Find maximum number of applications per hour can handled : What is the maximum number of applications per hour that can be handled by the present configuration of the process?

Number of payments including final smaller payment : What is the total number of payments including the final smaller payment?

Conduct sensitivity analysis for variable : Conduct a sensitivity analysis for each variable and range and compute the NPV for each.

Evaluating before bringing to market : Muscle Motors has a new sports car called the SmoMobile® that it is evaluating before bringing to market.

True regarding dark pools : Which of the following is NOT true regarding dark pools? Which of the following is NOT a behavioral bias?

About high frequency traders is true : Which of the following about high frequency traders (HFTs) is TRUE? Which of the following is an explicit transaction cost?

Opportunity between options market and common stock market : You identify an arbitrage opportunity between the options market and the common stock market for TWTR that is expected to produce annual risk-free return of 7 %

User Account

All Pages