Question
5. An investment has the following cash flows: July 12, 2008 $ -600 January 21, 2009...
5. An investment has the following cash flows: July 12, 2008 $ -600 January 21, 2009 $ +200 March 7, 2010 $ +300 June 25, 2011 $ +400 September 18, 2012 $ +800 March 29, 2015 $ +200 September 30, 2017 $ -2,000
a. Calculate the Net Present Value of this investment. Assume the annual discount rate is 15%.
b. 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.
c. Use Solver to determine the Internal Rate of Return(s) associated with this investment.
Homework Answers
Answer #1
Not the answer you're looking for?
Similar Questions
Date Cash Flow July 13,2008 -1100 Jan 26, 2009 200 March 9, 2010 200 June 25,...
Date
Cash Flow
July 13,2008
-1100
Jan 26, 2009
200
March 9, 2010
200
June 25, 2011
700
Sept 18, 2012
800
March 29,2013
200
June 10, 2014
500
July 15, 2015
900
Sept 29,2016
200
Sept 30,2017
-2800
1. Use Solver on EXCEL to determine the Internal Rate of
Return(s) associated with this investment.
Show all formulas and on solver please identify the
i. Set Objective (Cell)
ii. To Value
iii. By Changing Variables Cell
iv. Subject to (if...
Today is January 1, 2010. Find the net present value of a project for which the...
Today is January 1, 2010. Find the net present value of
a project for which the initial investment of $1,160 is made today,
and expected cash inflows are on January 1 in the years 2011, 2012,
2013, 2014, 2015. The first of these will be $300, and each one
thereafter will be $90 higher than the preceding one. The
risk-adjusted discount rate for this project is 13.0%, compounded
annually. Round your answer to the nearest cent.
Fuente, Inc., has identified an investment project with the following cash flows. Year Cash Flow 1...
Fuente, Inc., has identified an investment project with the
following cash flows.
Year Cash Flow
1 $675
2 800
3 1,100
4 1,425
a. If the discount rate is 12 percent, what is the future value
of these cash flows in year 4? b. What is the future value at a
discount rate of 20 percent? c. What is the future value at
discount rate of 29 percent?
Problem 12-21 Preference Ranking of Investment Projects [LO12-5] The management of Revco Products is exploring four...
Problem 12-21 Preference Ranking of Investment Projects
[LO12-5]
The management of Revco Products is exploring four different
investment opportunities. Information on the four projects under
study follows:
Project Number
1
2
3
4
Investment required
$
(400,000
)
$
(350,000
)
$
(250,000
)
$
(370,000
)
Present value of cash inflows at a 10% discount rate
447,930
490,619
261,279
410,433
Net present value
$
47,930
$
140,619
$
11,279
$
40,433
Life of the project
6 years
12 years...
McCann Co. has identified an investment project with the following cash flows. Year & Cash Flow...
McCann Co. has identified an investment project with the
following cash flows. Year & Cash Flow YR 1 - $800 YR 2 -
$1,090 YR 3 - $1,340 YR 4 - $1,180
a. If the discount rate is 11 percent, what is the present value
of these cash flows?
b. What is the present value at 19 percent?
c. What is the present value at 28 percent?
Braun Industries is considering an investment project which has the following cash flows: Year Cash Flow...
Braun Industries is considering an investment project which has
the following cash flows: Year Cash Flow 0 -$1,000 1 400 2 300 3
500 4 400 The company's WACC is 10 percent. What is the project's
payback, internal rate of return, and net present value? Select
one: a. Payback = 2.6, IRR = 21.22%, NPV = $300. b. Payback = 2.6,
IRR = 21.22%, NPV = $260. c. Payback = 2.4, IRR = 10.00%, NPV =
$600. d. Payback =...
Calendar Year 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015...
Calendar Year
2002
2003
2004
2005
2006
2007
2008
2009
2010
2011
2012
2013
2014
2015
2016
2017
2018
2019
2020
2021
Project Year
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
Cash Flow from Investing
Signature bonus
Exploration & Predevelopment
55.00
45.00
Upstream Development
30.00
85.00
90.00
20.00
15.00
5.00
2.00
2.00
2.00
2.00
...
A project has the following projected cash flows Year 0- R280,000( investment) Year 1 R70,000 Year...
A
project has the following projected cash flows
Year 0- R280,000( investment)
Year 1 R70,000
Year 2 R100,000
Year 3 R130,000
a) Assuming a discount rate of 10% what is the Net Present
Value (NPV) of this project over the 3 year period?
b) Based on your answer above, should the project be
recommended for acceptance?
c) would your answer to b above change if the discount rate
was 5%? Why?
d) what do you understand by the term nominal...
1- In the previous 5 years, Google paid an annual dividend as follows: Year Dividends 2011...
1- In the previous 5 years, Google paid an annual dividend as
follows:
Year Dividends
2011 - 2.7
2010- 2.5
2009- 2.2
2008- 1.8
2007- 1.5
Google is expected to pay a dividends of $3 in the next year
(2012). What is the cost of equity of Google if its current stock
price is $90?
2- As a technology-based firm, Google has a high beta of 1.4. if
the risk-free rate of return is 5% and the market risk premium...
Forecasting and Estimating Share Value Using the DCF Model Following are the income statement and balance...
Forecasting and Estimating Share Value Using the DCF Model
Following are the income statement and balance sheet for Intel
Corporation.
INTEL CORPORATION
Consolidated Statements of Income
Year Ended (In millions)
Dec. 25, 2010
Dec. 26, 2009
Dec. 27, 2008
Net revenue
$ 43,623
$ 35,127
$ 37,586
Cost of sales
15,132
15,566
16,742
Gross margin
28,491
19,561
20,844
Research and development
6,576
5,653
5,722
Marketing, general and administrative
6,309
7,931
5,452
Restructuring and asset impairment charges
--
231
710
Amortization...
ADVERTISEMENT
Need Online Homework Help?
Get Answers For Free
Most questions answered within 1 hours.
ADVERTISEMENT
Active Questions
asked 12 minutes ago
asked 29 minutes ago
asked 34 minutes ago
asked 44 minutes ago
asked 51 minutes ago
asked 57 minutes ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago
asked 1 hour ago