You are considering an investment which has the following cash flows. If you require a 5 year...

You are considering an investment which has the following cash flows. If you require a 5 year payback, should you take the investment?

Year 0 1 2 3 4 5 6

Cash flow -$30,000 $10,000 $5,000 $5,000 $7,500 $10,000 $20,000

please show steps in excel

Expert Solution

jeff jeffy answered 2 years ago

An investment that Kevin is considering offers the following cash flows. Year 1 Initial investment of...

An investment that Kevin is considering offers the following cash flows. Year 1 Initial investment of $10,000 Year 2 Inflow of $2,000 Year 3 Inflow of $1,500 Year 4 Additional investment of $5,000 Year 5 Inflow of $1,200 Year 6 Inflow of $2,200 Year 7 Inflow of 1,500 Year 8 Inflow of $1,000 Year 9 Inflow of $1,200 Year 10 Sale proceeds of $17,000 5. What is the internal rate of return (IRR) that this investment offers if all cash...

A firm is considering an investment project with the following cash flows: Year 0 = -$110,000...

A firm is considering an investment project with the following cash flows: Year 0 = -$110,000 (initial costs); Year 1= $40,000; Year 2 =$90,000; and Year 3 = $30,000; and Year 4 = $60,000. The company has a 10% cost of capital. What is the project’s discounted payback? 1.67 years 1.86 years 1.99 years 2.08 years A firm is considering an investment project with the following cash flows: Year 0 = -$110,000 (initial costs); Year 1= $40,000; Year 2 =$90,000;...

Polk Products is considering an investment project with the following cash flows: Year Cash Flow 0...

Polk Products is considering an investment project with the following cash flows: Year Cash Flow 0 -$100,000 1. 20,000 2. 90,000 3. 30,000 4. 60,000 The company has a 10 percent cost of capital. What is the project's discounted payback? 1.86 years 1.67 years 2.67 years 2.49 years 2.33 years

Determine cash flows, r, and n You are considering an investment that has a payoff of...

Determine cash flows, r, and n You are considering an investment that has a payoff of $4,707.79 in 2 years. If the interest rate is 11.68%, and interest is compounded annually, then what is this investment worth to you today?

Braun Industries is considering an investment project that has the following cash flows: &nbs

Braun Industries is considering an investment project that has the following cash flows: Project Year Cash Flows 0 -$641 1 $421 2 $407 3 $490 The company’s WACC is 10.5 percent. What is the project’s payback, internal rate of return (IRR), and net present value (NPV)?

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.

You are considering a project with the following cash flows: YEAR PROJECT CASH FLOW ...

You are considering a project with the following cash flows: YEAR PROJECT CASH FLOW 0 -60,000 1 25,000 2 25,000 3 25,000 4 25,000 If the appropriate discount rate is 11 percent, what is the project's discounted payback period in years?

You are considering an investment with the following cash flows. Your required return is 8%, you...

You are considering an investment with the following cash flows. Your required return is 8%, you require a payback of 3 years and a discounted payback of 4 years. If your objective is to maximize your wealth, should you take this investment? Year 0 1 2 3 4 5 Cash Flow –$50,000 $20,000 $20,000 $20,000 $20,000 –$50,000 Yes, because the payback is 2.5 years. Yes, because the discounted payback is less than 4 years. Yes, because both the payback and...

- Assume you are considering an investment costing $10,000, for which the future cash flows from...

- Assume you are considering an investment costing $10,000, for which the future cash flows from owning the security depend on the state of the economy as estimated in this table. In any given year the, the investment could produce any one of three possible cash flows, depending on the particular state of the economy. Given this information calculate: Expected Cash Flow Expected rate of return State of the economy Probability of the states Cash flow from the investment %...

Two investment projects which are mutually exclusive both require a $10,000,000 investment. Projected cash flows are:...

Two investment projects which are mutually exclusive both require a $10,000,000 investment. Projected cash flows are: Year Project A Project B 1 $3,500,000 $6,500,000 2 3,500,000 3,000,000 3 3,500,000 3,000,000 4 3,500,000 1,000,000 If your discount rate is 12 percent, net present value each project and indicate which you would choose and why.

Question