Question

In: Finance

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

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

  1. Calculate the Net Present Value of this investment. Assume the annual discount rate is 12%.
  2. 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.
  3. Use Solver to determine the Internal Rate of Return(s) associated with this investment.

Solutions

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%


Related Solutions

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....
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 shortterm 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. Explain...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT