Question

In: Finance

An investment has the following cash flows: August 12, 2008 $ -1000 February 21, 2009 &

An investment has the following cash flows:

August 12, 2008 $ -1000

February 21, 2009 $ +100

October 7, 2010 $ +200

April 25, 2011 $ +900

May 18, 2012 $ +600

July 29, 2013 $ +300

November 12, 2014 $ +600

August 12, 2015 $ +900

June 30, 2016 $ -2800

Calculate the Net Present Value of this investment. Assume the annual discount rate is 14%.
Create a data table and graph illustrating the impact of the discount rate on the Net Present Value of this investment. Include a title and label the axes for the graph.
Use Solver to determine the Internal Rate of Return(s) associated with this investment.

Expert Solution

Answer a)

Answer b)

Answer c) Using solver getting the feasible solution ,

Solver parameter as

outcome for solver as: 18%.

jeff jeffy answered 1 month ago

An investment has the following cash flows: August 12, 2008 $ -700 February 21, 2009 $ ...

An investment has the following cash flows: August 12, 2008 $ -700 February 21, 2009 $ +200 October 7, 2010 $ +500 April 25, 2011 $ +400 May 18, 2012 $ +300 July 29, 2013 $ +600 November 12, 2014 $ +400 August 12, 2015 $ -1800 Calculate the Net Present Value of this investment. Assume the annual discount rate is 12%. Create a data table and graph illustrating the impact of the discount rate on the Net Present...

A). You are evaluating a project with the following cash flows: initial investment is $-12, and...

A). You are evaluating a project with the following cash flows: initial investment is $-12, and the expected cash flows for years 1 - 3 are $10, $11 and $17 (all cash flows are in millions of dollars). What is this projects NPV? The company's WACC is 10%. B). You are evaluating a project with an initial investment of $16.9 million dollars, and expected cash flows of $7 million dollars each for years 1-3. What is the project's simple payback?...

PV of a Growing Annuity An investment offers the following cash flows: $1000 in one year,...

PV of a Growing Annuity An investment offers the following cash flows: $1000 in one year, followed by 9 more annual payments (years 2-10) that grow at a rate of 7% per year. If your opportunity cost is 8% per year, the PV today of this stream of cash flows is $______________. Margin of error for correct responses: +/- $.05.

In periods 0-4, a project has the following cash flows: -3,000, 1000, 1000, 2,438, 500. Its...

In periods 0-4, a project has the following cash flows: -3,000, 1000, 1000, 2,438, 500. Its cost of capital is 10 percent. What is the projects DISCOUNTED payback period?

In periods 0-4, a project has the following cash flows: -3,000, 1000, 1000, 2,390, 500. Its...

In periods 0-4, a project has the following cash flows: -3,000, 1000, 1000, 2,390, 500. Its cost of capital is 10 percent. What is the projects DISCOUNTED payback period?

Newman Medical Clinic has budgeted the following cash flows. January February March Cash receipts $ 106,000...

Newman Medical Clinic has budgeted the following cash flows. January February March Cash receipts $ 106,000 $ 112,000 $ 132,000 Cash payments For inventory purchases 93,000 75,000 88,000 For S&A expenses 34,000 35,000 30,000 Newman Medical had a cash balance of $11,000 on January 1. The company desires to maintain a cash cushion of $5,000. Funds are assumed to be borrowed, in increments of $1,000, and repaid on the last day of each month; the interest rate is 1 percent...

Thornton Medical Clinic has budgeted the following cash flows: January February March Cash receipts $ 116,000...

Thornton Medical Clinic has budgeted the following cash flows: January February March Cash receipts $ 116,000 $ 122,000 $ 142,000 Cash payments For inventory purchases 98,000 80,000 93,000 For S&A expenses 39,000 40,000 35,000 Thornton Medical had a cash balance of $16,000 on January 1. The company desires to maintain a cash cushion of $9,000. Funds are assumed to be borrowed, in increments of $1,000, and repaid on the last day of each month; the interest rate is 2 percent...

Newman Medical Clinic has budgeted the following cash flows. January February March Cash receipts $ 101,000...

Newman Medical Clinic has budgeted the following cash flows. January February March Cash receipts $ 101,000 $ 107,000 $ 127,000 Cash payments For inventory purchases 90,500 72,500 85,500 For S&A expenses 31,500 32,500 27,500 Newman Medical had a cash balance of $8,500 on January 1. The company desires to maintain a cash cushion of $6,000. Funds are assumed to be borrowed, in increments of $1,000, and repaid on the last day of each month; the interest rate is 2 percent...

A real estate investment has the following expected cash flows: Year Cash Flows 1 $7,000 2...

A real estate investment has the following expected cash flows: Year Cash Flows 1 $7,000 2 17,000 3 22,000 4 22,000 The discount rate is 11 percent. What is the investment’s present value? Round it to two decimal places, i.e., 1234.45.

Seaborn Co. has identified an investment project with the following cash flows.

Seaborn Co. has identified an investment project with the following cash flows. Year Cash Flow 1 $800 2 1,000 3 1,330 4 1,160 Required: (a) If the discount rate is 10 percent, what is the present value of these cash flows? (Click to select) 3,679.79 3,268.96 3,424.40 4,290.00 3,345.26 (b) What is the present value at 18 percent? (Click to select) 2,746.13 3,308.65 4,290.00 3,635.58 2,803.94 (c) What is the present value at 28 percent? (Click to select) 2,345.12 2,259.53 ...