Create a one-dimensional data table show sensitivity of npv

Assignment Help Finance Basics

Reference no: EM131477337

Question: The example below calculates the NPV and IRR for an investment.

a. Create a one-dimensional data table showing the sensitivity of the NPV and IRR to the year-1 cash flow (currently $10,000). Use a range of $9,000 - $12,000 in increments of $500.

b. Create a two-dimension data table showing the sensitivity of NPV to the year-1 cash flow and to the discount rate. Use the same range for the cash flow as above and use discount rates from 8% to 20%, with increments of 2%.

Reference no: EM131477337

Questions Cloud

Campaign on establishing a new frontier : John F. Kennedy ran his presidential campaign on establishing a "New Frontier." Critics of Kennedy's presidency argued that below the surface of his style

What steps can you take to protect yourself and your company : What steps can you take to protect yourself and your company? Should he have disclosed his ties to Customers-R-Us? Why or why not?

What are your views on the anonymity issue : MGT 304 Human Resource Management - What are the advantages and disadvantages of Johnson & Johnson's 360-degree appraisal?

Roosevelt new deal programs : Choose one of Roosevelt's New Deal programs and write a 500 word essay using proper grammar, spelling, and punctuation.

Create a one-dimensional data table show sensitivity of npv : Create a one-dimensional data table showing the sensitivity of the NPV and IRR to the year-1 cash flow (currently $10,000). Use a range of $9,000 - $12,000.

About future interest rates : What expectations are investors likely to have about future interest rates?

Create a list of what can go wrong during deployment phase : Create a list of what can go wrong during the deployment phase of a project and steps that could have been taken to avoid these problems.

How the subcomponents of the system work together : You need to have some scenarios of how the user may interact with the system and how the subcomponents of the system work together.

Do you think the components of this system are underutilized : What would you do to increase the utilization of these services and attract a greater mix of paying patients?

User Account

All Pages