Question

You are considering an investment which has the following cash flows. If you require a 10%             return,...

You are considering an investment which has the following cash flows. If you require a 10%             return, what is the NPV?

            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 in excel

Homework Answers

Answer #1

the following is the excel screenshot

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
You are considering an investment opportunity with the following costs and benefits. The applicable interest rate...
You are considering an investment opportunity with the following costs and benefits. The applicable interest rate for this investment opportunity is 7.5% (effective annual rate). Calculate the NPV of this investment opportunity. Round your answer to two decimals (do not include the $-sign in your answer). Investment Opportunity Cash Flows in $ Year 0 1 2 3 4 5 6 7 8 Costs $(14000) $(10,000) $(5,000) $(1,000) $(1,000) $ - $ - $ - $ - Benefits $ - $1,000...
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 =...
You are considering the following two mutually exclusive projects with the following cash flows:                           &nbsp
You are considering the following two mutually exclusive projects with the following cash flows:                                                                                  Project A                                  Project B                                                             Year    Cash Flow                   Year    Cash Flow                                                             0          -$75,000                         0       -$70,000                                                             1          $19,000                         1       $10,000                                                             2          $48,000                         2       $16,000                                                             3          $12,000                         3       $72,000                        Required rate of return                     10 %                                        13 %                             Calculate the NPV, IRR,...
The Colby Corporation has been presented with an investment opportunity, which will yield end-of-year cash flows...
The Colby Corporation has been presented with an investment opportunity, which will yield end-of-year cash flows of $10,000 per year in Years 1 through 3, $15,000 per year in Years 4 through 8, and $20,000 in Years 9 & 10. This investment will cost the firm $50,000 today, and the firm's cost of capital is 9 percent. What is the NPV for this investment? Please show work. Thank you.
You are considering an investment with the following cash flows. If the required rate of return...
You are considering an investment with the following cash flows. If the required rate of return for this investment is 16.5 percent, should you accept the investment based solely on the internal rate of return rule? Why or why not? Year: 0, 1, 2, 3 Cash Flow: -152000, 98,200, 102,300, -4,900 A. Yes; The IRR exceeds the required return. B. Yes; The IRR is less than the required return. C. No; The IRR is less than the required return. D....
You are considering an investment opportunity with the following costs and benefits. The applicable interest rate...
You are considering an investment opportunity with the following costs and benefits. The applicable interest rate for this investment opportunity is 12% (effective annual rate). Calculate the NPV of this investment opportunity. Round your answer to two decimals (do not include the $-sign in your answer). Year 0 1 2 3 4 5 6 Costs $ (10,000) $ (5,000) $ (1,000) $ (1,000) $ (1,000) $ (1,000) $ (1,000) Benefits $ - $ - $ 5,000 $ 7,500 $ 7,500...
   Your firm is considering two projects with the following cash flows. WACC 6% 6% year...
   Your firm is considering two projects with the following cash flows. WACC 6% 6% year Project A Project B 0                              -55,000         -70,000 1                                10,000          10,000 2                                  9,000          10,000 3                                  8,000          10,000 4                                  7,500          10,000 5                                  7,500          10,000 6                                  7,500          10,000 7                                  7,500          10,000 8                                  7,500          12,000 a. Calculate NPV and IRR for both projects NPV IRR b. Do the following 2...
Your company is considering a project which has the expected cash flows as follows. year 0...
Your company is considering a project which has the expected cash flows as follows. year 0 1 2 3 4 5 6 7 8 9 10 cash flow -500 90 100 150 180 190 140 100 80 60 -50 The required return for the project is 15% per annum. (1) What is the NPV? (2) What are 2 IRRs? (3) Draw the NPV profile (4) What are the MIRR? (5) Should your company take this project?
a company is considering investing in a project. The project will require a 10% rate return....
a company is considering investing in a project. The project will require a 10% rate return. The project will require $65,000 investment and provides the following returns: year 1:   $20,000 year 2: $20,000 year 3: $20,000 year 4: $25,000 I)Given that the company needs to make at least 10% return on its project what is the projects NPV for the return on its investment? A) $85,000 B) $20,000 C) Less than $2,000 but more than $1,000 D) less then $1,000...
You are analysing a capital investment project. You forecast the following cash-flows: year 0 1 2...
You are analysing a capital investment project. You forecast the following cash-flows: year 0 1 2 3 4 5 cash flow    +10 +20 -5 -10 0 What is the maximum investment you are willing to make into this project today if your required return is 15% per year (e.g. cost of capital) (Show positive number as an answer. Please round your answer to the nearest full number. For example if your answer for investment is 21.26, show 21 as...