Question

In: Finance

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 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

1) Net Present Value or NPV, is the present value of money given the discounting rate, in our case 12% p.a.

Year	Cashflows	Discounting Factors @12%	Discounted Cash Flows
2008	-700	0.893	-625.000
2009	200	0.797	159.439
2010	500	0.712	355.890
2011	400	0.636	254.207
2012	300	0.567	170.228
2013	600	0.507	303.979
2014	400	0.452	180.940
2015	-1800	0.404	-726.990
		NPV = Total of Discounted Cash Flows	72.693

The NPV is 72.693, which is positive, hence the project should be undertaken.

2) The impact of Different Discount Rates on NPV, with data table and graph.

Annual Discounting Rate	NPV
4%	₹ 7.75
5%	₹ 24.49
6%	₹ 38.10
7%	₹ 48.97
8%	₹ 57.44
9%	₹ 63.79
10%	₹ 68.30
11%	₹ 71.20
12%	₹ 72.69
13%	₹ 72.97
14%	₹ 72.19
15%	₹ 70.49
16%	₹ 68.01
17%	₹ 64.86
18%	₹ 61.14

It can be seen that NPV increases with the increasing discounting rates and reaches maximum at 13% and then begins to fall.

3) Internal Rate of Return

Internal rate of return is the rate at which the NPV of the investment is Zero.

From above graph we know that at a rate below 4% the NPV will be zero. By using the solver we determine that the IRR for this investment will be approximately, 3.596%

jeff jeffy answered 2 years ago

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...

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?...

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 ...

A company has 2 investment opportunities with the following cash flows: &n

A company has 2 investment opportunities with the following cash flows: Year 1 Year 2 Year 3 Investment A $1,500 $1,250 $1,800 Investment B $1,500 $1,500 $1,500 If a company can earn 5% in other investments, what is the present value of investments A and B? Investment A = $4,084.50 Investment B = $4,117.20 Investment A = $4,084.50 Investment B = $4,084.50 Investment A = $4,117.20 Investment B = $4,084.50 Investment A = $4,275 Investment B =...

A real estate investment has the following expected cash flows: Year

A real estate investment has the following expected cash flows: Year Cash Flows 1 $9,000 2 13,000 3 18,000 4 25,000 The discount rate is 12 percent. What is the investment’s present value? Round your answer to 2 decimal places; for example 2345.25.

3) Between February 2008 and Summer 2009, the Fed supplemented its open market operations with a...

3) Between February 2008 and Summer 2009, the Fed supplemented its open market operations with a greatly expanded program of direct lending (both overnight and short term 28 and 84 day loans) to commercial banks, investment banks, brokerage and primary dealer units of bank holding companies. It also agreed to accept a wider range of short-term securities (instead of accepting only T-Bills) as collateral on these loans and even initiated a program to buy commercial paper from money market funds....