Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

explanations, please! Q1. Sensitivity Analysis a. [2pts] Create a 1-variable Data table where the input is the sales growth rate, and the output is the

image text in transcribed
explanations, please!
Q1. Sensitivity Analysis a. [2pts] Create a 1-variable Data table where the input is the sales growth rate, and the output is the NPV. The sales growth rate should increase from 7.5% to 12% with a constant increment of 0.5%. Assume no correlation between any value drivers. b. [2 pts] Create a 2-variable Data table where the inputs are the sales growth rate and the discount rate, and the output is the NPV. The sales growth rate should increase from 7.5\% to 12% with a constant increment of 0.5% and the discount rate should have the following yalues: 11%,11.5%,12%,12.75%,13.25%,14%,14.5%. Assume no correlation between any value drivers. Do you have any negative NPVs? If so, how many cases? Q2. Simulation [3 pts] Now report the distribution of the internal rate of return of the project (the name of the distribution that fits the outcome the best based on AIC). Also, report the major statistics mean, min, max, standard deviation, and the graph of the distribution. Finally, report the probability that the internal rate of return of the project is great than 15\%. (Choose your own number of simulation iterations. Assume no correlation between any value drivers. Further assume there is no "decision" variable, i.e., no need to utilize the "BisksimTable" function.)

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

Venture Capital Valuation

Authors: Lorenzo Carver

1st Edition

0470908289, 978-0470908280

More Books

Students also viewed these Finance questions

Question

9. How do epinephrine and cortisol enhance memory storage?

Answered: 1 week ago

Question

How can the Internet be helpful in a job search? (Objective 2)

Answered: 1 week ago