Question

In: Finance

A five-year project, if undertaken, will require an initial investment of $95,000. The expected cash flows...

A five-year project, if undertaken, will require an initial investment of $95,000. The expected cash flows are:

Year 1:                        $12,000

Year 2:                        $39,000

Year 3:                        $39,000

Year 4:                        $30,000

Year 5:                        $18,000

If the appropriate discount rate for this project is 15 percent, what is the value of this project today?

Relevant time for $12,000:?

Relevant time for $39,000:?

Relevant time for second $39,000:?

Relevant time for $30,000:?

Relevant time for $18,000:?

Relevant rate:?

Value of $12,000:?

Value of $39,000:?

Value of second $39,000:?

Value of $30,000:?

Value of $18,000:?

Total value:?

Compared to the initial investment, should this project be undertaken?

Solutions

Expert Solution

1.The value of the project today is calculated by computing the net present value.

Net present value can be solved using a financial calculator. The steps to solve on the financial calculator:

  • Press the CF button.
  • CF0= -$95,000. Indicate the initial cash flow by a negative sign since it is a cash outflow.  
  • Cash flow for each year should be entered.
  • Press Enter and down arrow after inputting each cash flow.
  • After entering the last cash flow cash flow, press the NPV button and enter the discount rate of 15%.
  • Press enter after that. Press the down arrow and CPT buttons to get the net present value.  

Net present value at 15% discount rate is -$3,330.70.

2.The relevant rate is calculating by computing the internal rate of return.

Internal rate of return can be calculated using a financial calculator by inputting the below:

  • Press the CF button.
  • CF0= -$95,000. The initial cash flow is indicated by a negative sign since it is a cash outflow.  
  • Cash flow for each of the fifteen years should be entered.
  • Press Enter and down arrow after inputting each cash flow.
  • After entering the last cash flow cash flow, press the IRR and CPT button to get the IRR of the project.

The IRR of the project is 13.56%.

3.The project should not be undertaken since it generates a negative net present value.

In case of any query, kindly comment on the solution.


Related Solutions

You are evaluating a project with the following cash flows: initial investment is $-23, and the  expected...
You are evaluating a project with the following cash flows: initial investment is $-23, and the  expected cash flows for years 1 - 3 are $12, $9 and $8 (all cash flows are in millions of dollars). What is this projects NPV? The company's WACC is 9%. Express your answer in millions of dollars, rounded to 2 decimals and without the dollar sign. So, if your answer is 23.5678, just enter 23.57.
You are evaluating a project (initial investment is $41,000) that is expected to produce cash flows...
You are evaluating a project (initial investment is $41,000) that is expected to produce cash flows of $5,000 each year for the next ten years and $7,000 each year for the following ten years. The IRR of this project is 12%. The firm’s WACC is 8%. What is the project’s NPV?
Assume a $95,000 investment and the following cash flows for two alternatives: Year Investment A Investment...
Assume a $95,000 investment and the following cash flows for two alternatives: Year Investment A Investment B 1 $25,000 $30,000 2 15,000 30,000 3 30,000 40,000 4 30,000 — 5 20,000 — Calculate the payback period for investment A and investment B. Show calculation. (Do not round intermediate calculations. Round the final answers to 2 decimal places.) Payback period   Investment A years   Investment B years
Assume a $95,000 investment and the following cash flows for two alternatives. Year Investment A Investment...
Assume a $95,000 investment and the following cash flows for two alternatives. Year Investment A Investment B 1 $ 35,000 $ 40,000 2 30,000 35,000 3 20,000 25,000 4 20,000 — 5 20,000 — a. Calculate the payback for investment A and B. (Round your answers to 2 decimal places.)    b. Which investment would you select under the payback method?    Investment A Investment B c. If the inflow in the fifth year for Investment A was $20,000,000 instead...
Given the following, calculate the cash flows for the project. Initial investment $365,000 Expected life is...
Given the following, calculate the cash flows for the project. Initial investment $365,000 Expected life is 5 years First Year Revenues: 245,000 First Year Expenses: $70,000 Growth for revenue and expenses: 3 percent per year Straight Line Depreciation over 5 years Salvage Value: $45,000 One-time net working capital investment of $10,000 required at the start of the project This investment is recovered at the end of the project The tax rate is 34 percent Answer the following: What are the...
The table below gives the initial investment and expected cash flows over the next five years...
The table below gives the initial investment and expected cash flows over the next five years for two different projects. Assume that the industry you are in expects a return of 10%, which you use as the discount rate in net present value (NPV) calculations and as the required rate of return for purposes of deciding on projects. Also, assume that management only wants to invest in projects that pay off within four years. For each project, compute the payback...
A five-year project requires an investment of -172 and has the following cash flows in years...
A five-year project requires an investment of -172 and has the following cash flows in years 1 through 5, respectively (all cash flows in dollars): 135, -95, 238, -75, and 118. Without actually calculating any IRR, what is the maximum possible value any of the real IRRs could have? Give your answer as a percent with two decimals; e.g., 23.24
A five-year project requires an investment of -255 and has the following cash flows in years...
A five-year project requires an investment of -255 and has the following cash flows in years 1 through 5, respectively (all cash flows in dollars): 159, 83, 243, 125, and 172. Without actually calculating any IRR, what is the maximum possible value any of the real IRRs could have? Give your answer as a percent with two decimals; e.g., 23.24
A five-year project requires an investment of -177 and has the following cash flows in years...
A five-year project requires an investment of -177 and has the following cash flows in years 1 through 5, respectively (all cash flows in dollars): 116, -109, 267, 2, and 108. Without actually calculating any IRR, what is the maximum possible value any of the real IRRs could have? Give your answer as a percent with two decimals; e.g., 23.24 The answer is 150.85. I would like to understand why. Thanks!
You are considering a project with an initial cash outlay of ​$72,000 and expected cash flows...
You are considering a project with an initial cash outlay of ​$72,000 and expected cash flows of ​$22,320 at the end of each year for six years. The discount rate for this project is 10.5 percent. a.  What are the​ project's payback and discounted payback​ periods? b.  What is the​ project's NPV? c.  What is the​ project's PI? d.  What is the​ project's IRR? a.  The payback period of the project is nothing years.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT