Calculate the npv of the cash flows expected in 2006

Reference no: EM13234868

Calculate the NPV of the cash flows expected in 2006-2010 using only the 2005 Cost of Capital (don't worry about increasing costs of capital).

Calculate the NPV of the cash flows using the CASH FLOW figures at the bottom of the spreadsheet, these are the future values cash inflows.

Is the NPV positive or negative? Should the project be accepted? Why or why not based on NPV?

Show your calculations

What would be some of questions you may ask regarding the economic assumptions made during your calculations of NPV and regarding the expansion effort?

Year 2005 2006 2007 2008 2009 2010

T= 0 1 2 3 4 5

Risk Free Rate 2.25% 2.50% 2.75% 3.00% 3.25% 3.25%

Cost of Capital 6.00% 7.00% 8.00% 9.00% 10.00% 11.00%

(US$ millions, incremental)

Net Sales 30 35 40 45 50

Selling, General & Admin -20 -18 -15 -12 -12

Depreciation -10 -10 -10 -10 -10

Interest Expense -2 -2 -2 -2 -2

Income before Taxes -2 5 13 21 26

Income Taxes 1 -2 -5 -8 -10

Net Income -1 3 8 13 16

capital Investment -50

Addback Noncash 10 10 10 10 10

Cash Flow -50 8.76 13.10 18.06 23.02 26.12

Reference no: EM13234868

Questions Cloud

Should the firm shut down immediately when total cost fixed : For both sets of calculations, compare the firm's output price and the calculated average variable cost and average total cost. Should the firm shutdown immediately when the total fixed cost equals $1,000,000

Measure employee morale : What measures can be taken to assess the morale of current employees and how likely they are to leave or stay and describe at least 3 methods you could use to measure employee morale

Write for loops to produce the following output : Write for loops to produce the following output

Find the final temperature of the ball : A copper ball with a radius of 1.5cm is heated until its diameter has increased by 0.17mm .Assuming an initial temperature of 21?C

Calculate the npv of the cash flows expected in 2006 : Calculate the NPV of the cash flows expected in 2006-2010 using only the 2005 Cost of Capital Calculate the NPV of the cash flows using the CASH FLOW figures at the bottom of the spreadsheet

Compute the capability index for the process : A process that produces computer chips has a mean of .04 defective chip and a standard deviation of .003 chip. The allowable variation is from .03 to .05 defective.

Write piece of code uses a loop to compute and precending : The Fibonacci numbers are a sequence of integers in which the first two elements are 1, and each following element is the sum of the two preceding elements

Should that hacker be prosecuted and sent to jail : If an extremely intelligent hacker is caught by a law enforcement agency, should that hacker be prosecuted and sent to jail? Is there perhaps a way that the hacker might be "turned" for the good of the digital world? What would that be?

Explain mechanism that shows why p-chlorotoluene reacts : propes a mechanism that shows why P-chlorotoluene reacts with sodium amide in liquid NH3 At -33C to give a 1:1 mixture of P-toluidine and m-toluidine

User Account

All Pages