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

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
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.
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...
Question 1: Sea Masters Co. has identified an investment project with the following cash flows for...
Question 1: Sea Masters Co. has identified an investment project with the following cash flows for the next 5 years. If the discount rate is 6.7 percent, the present value of these cash flows is $__________. Round it to two decimal places without the $ sign, e.g., 23456.34                         Year           Cash Flows                           1              $21,000                           2 35,000                           3               44,000 4 53,000                           5               77,000 Question 2: The present value of the following cash flow stream is $6,561 when discounted at...
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...