Question

Net present value Using a cost of capital of 14%, calculate the net present value for the project shown in the following tabl

0 0
Add a comment Improve this question Transcribed image text
Answer #1

013 fx =SUM(D2:012) в C 1 year Cash flows pv@14% Present value 2 0 $ (1,140.00) 1.0000 $ (1,140.00) 3 1 $ 83.00 0.8772 $ 4 2

D13 fic =SUM(D2:012) B Cash flows -1140 pv@14% 1 year 20 31 42 53 95 64 Present value =B2*C2 =B3*C3 =B4*04 =B5*C5 =B6*C6 =B7*

Add a comment
Know the answer?
Add Answer to:
Net present value Using a cost of capital of 14%, calculate the net present value for...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • can someone help me answer this question ? Net present value using a cost of capital...

    can someone help me answer this question ? Net present value using a cost of capital of 13%, calculate the net present value for the project shown in the following table and indicate whether it is acceptable, The net present value (NPV) of the project is (Round to the nearest cent.) i Data Table (Click on the icon located on the top-right comer of the data table below in order to copy its contents into a spreadsheet.) $760,000 Initial investment...

  • Net present value   Using a cost of capital of 10​%, calculate the net present value for...

    Net present value   Using a cost of capital of 10​%, calculate the net present value for the project shown in the following table and indicate whether it is​ acceptable. Initial investment            $-1,150 Year       Cash inflows 1              $80 2              $135 3              $190 4              $255 5              $315 6              $380 7              $275 8              $100 9              $45 10           $25

  • Internal rate of return For the project shown in the following table, B: , calculate the...

    Internal rate of return For the project shown in the following table, B: , calculate the internal rate of return (IRR). Then indicate, for the project, the maximum cost of capital that the firm could have and still find the IRR acceptable. The project's IRR is %. (Round to two decimal places.) Data Table (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) Initial investment (CF)...

  • Internal rate of return For the project shown in the following table, , calculate the internal...

    Internal rate of return For the project shown in the following table, , calculate the internal rate of return (IRR). Then indicate, for the project, the maximum cost of capital that the firm could have and still find the IRR acceptable. The project's IRR is 9.55 %. (Round to two decimal places.) The maximum cost of capital that the firm could have and still find the IRR acceptable is %. (Round to two decimal places.) Data Table (Click on the...

  • Internal rate of return For the project shown in the following table. B. calculate the internal...

    Internal rate of return For the project shown in the following table. B. calculate the internal rate of return (IRR). Then indicate, for the project, the maximum cost of capital that the first could have and still find the IRR acceptable. The project's IRR is %. (Round to two decimal places.) i Data Table (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) Initial Investment (CF)...

  • Please round to the nearest two decimals (: calculate the internal rate of return (IRR). Then...

    Please round to the nearest two decimals (: calculate the internal rate of return (IRR). Then indicate, for the project, the maximum cost of capital that the firm could have and still find the IRR Internal rate of return For the project shown in the following table, acceptable Data Table The project's IRR is% Round to two decimal places.) (Click on the icon located on the top-right corner of the data table below in order to copy its contents into...

  • Internal rate of return For the project shown in the following table, EEB, calculate the internal...

    Internal rate of return For the project shown in the following table, EEB, calculate the internal rate of return (IRR). Then indicate, for the project, the maximum cost of capital that the firm could have and still find the IRR acceptable. The project's IRR is D96. (Round to two decimal places.) Data Table Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) Initial investment (CFo) $110,000...

  • Then indicate, for the pro ect the maxim um cost Internal rate of return For the...

    Then indicate, for the pro ect the maxim um cost Internal rate of return For the project shown in he following table,囲 of capital that the frm could have and still ind the IRR acceptable The projects IRR is 1% (Round to two decimal places) inn m cala late the internal rate Data Table (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet) Initial investment (CFO...

  • NPV, with rankings Botany Bay, Inc., a maker of casual clothing, is considering four projects shown in the following ta...

    NPV, with rankings Botany Bay, Inc., a maker of casual clothing, is considering four projects shown in the following table, B: Because of past financial difficulties, the company has a high cost of capital at 14.7%. a. Calculate the NPV of each project, using a cost of capital of 14.7%. b. Rank acceptable projects by NPV. c. Calculate the IRR of each project and use it to determine the highest cost of capital at which all of the projects would...

  • Net present value. Lepton Industries has a project with the following projected cash flows: a. Using...

    Net present value. Lepton Industries has a project with the following projected cash flows: a. Using a discount rate of 10% for this project and the NPV model, determine whether the company should accept or reject this project. b. Should the company accept or reject it using a discount rate of 17%? c. Should the company accept or reject it using a discount rate of 20%? a. Using a discount rate of 10%, this project should be V. (Select from...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT