Discount rate and your y-axis net present value of cash flow

Assignment Help Financial Management

Reference no: EM131820465

1. Begin by plotting how the NPV of the project changes with different discount rates (table given below). Note that you'll have to find the NPV of the project first using a discount rate of your choosing. Use a data table to create this plot. Have your discount rates range from 0% to 60% in increments of 2%. Make sure all of the numbers in the data table have the proper format (e.g. decimal places and %/$).

Please label your x-axis "Discount Rate" and your y-axis "Net Present Value of Cash Flows". Title your graph "NPV Calculation". There should be no legend on the graph. Remove the grid lines. Remove any markers (the dots on the line).

2) How many IRRs does this project have?

Please show it on excel

Reference no: EM131820465

Questions Cloud

Prepare a tabular summary of the effects of the actions : Prepare a tabular summary of the effects of the alternative actions on the company's stockholders' equity and outstanding shares.

What were the total dividends paid to shareholders : What were the total dividends paid to shareholders during the most recent year?

How much free cash flow does lopez expect : Computing free cash flow Shauna Lopez Company expects the following for 2016: Net cash provided by operating activities of $144,000.

Discuss bricks-and-mortar stores have over online stores : What advantages do bricks-and-mortar stores have over online stores. Can Amazon replicate these advantages. Why or why not

Discount rate and your y-axis net present value of cash flow : Begin by plotting how the NPV of the project changes with different discount rates. "Discount Rate" and your y-axis "Net Present Value of Cash Flows".

Complete a comparative ethical analysis of georges situation : The purpose of this paper is to complete a comparative ethical analysis of George's situation and decision from the perspective of two worldviews .

What is the probability that a randomly selected : What is the probability that a randomly selected capsule contains less than 4.9 mg of vitamin E? at least 5.2 mg?

Calculate the company free cash flow : Zedek Corporation had net cash flows from operating activities during the past year of $216,000. Calculate the company's free cash flow

Prepare the company statement of cash flows : Preparing a statement of cash flows using the direct method Green Bean, Inc. began 2016 with cash of $57,000. During the year, Green Bean earned revenue.

User Account

All Pages