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

1. Braun Industries is considering an investment project which has the following cash flows: Year project...

1. Braun Industries is considering an investment project which has the following cash flows: Year project cash flows 0 -$1000 1 500 2 600 3 700 4 400 The company’s WACC is 10 percent. What is the project’s payback, discounted payback, internal rate of return, modified internal rate of return, and net present value? show work.

Brawn Industries is considering an investment project that has the following cash flows: YEAR CASH FLOW...

Brawn Industries is considering an investment project that 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%. What is the projects regular payback, IRR, and NPV? (You must show your work) Group of answer choices

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

Question