Question

4. Lepton Industries has a project with the following projected cash flows: Initial Cost, Year 0: $468,000 Cash flow year one
0 0
Add a comment Improve this question Transcribed image text
Answer #1
2% 4% 6% 8% 10% 12% 14% 16% 18% 20% 22% 24% 26% 28% 30%
Year 0 -468000 1      -4,68,000.00 1 -468000 1 -4,68,000.00 1 -4,68,000.00 1 -4,68,000.00 1 -4,68,000.00 1 -4,68,000.00 1 -4,68,000.00 1 -4,68,000.00 1 -4,68,000.00 1 -4,68,000.00 1 -4,68,000.00 1 -4,68,000.00 1 -4,68,000.00 1 -4,68,000.00
Year 1 135000      0.9804       1,32,352.94      0.9615 129807.692      0.9434    1,22,460.09      0.9259    1,13,388.97      0.9091    1,03,080.88      0.8929        92,036.50      0.8772        80,733.77      0.8621        69,598.08      0.8475        58,981.42      0.8333        49,151.19      0.8197        40,287.86      0.8065        32,490.21      0.7937        25,785.88      0.7813        20,145.22      0.7692        15,496.32
Year 2 240000      0.9612       2,30,680.51      0.9246 221893.491      0.8900    1,97,484.42      0.8573    1,69,311.06      0.8264    1,39,926.49      0.7972    1,11,548.54      0.7695        85,832.98      0.7432        63,787.89      0.7182        45,811.47      0.6944        31,813.52      0.6719        21,374.31      0.6504        13,901.08      0.6299          8,756.04      0.6104          5,344.26      0.5917          3,162.28
Year 3 185000      0.9423       1,74,329.63      0.8890 164464.326      0.8396    1,38,087.42      0.7938    1,09,618.25      0.7513        82,357.81      0.7118        58,620.66      0.6750        39,567.28      0.6407        25,349.08      0.6086        15,428.23      0.5787          8,928.38      0.5507          4,916.92      0.5245          2,578.86      0.4999          1,289.19      0.4768              614.73      0.4552              279.81
Year 4 135000      0.9238       1,24,719.13      0.8548 115398.566      0.7921        91,406.47      0.7350        67,186.49      0.6830        45,889.27      0.6355        29,163.46      0.5921        17,267.11      0.5523          9,536.47      0.5158          4,918.81      0.4823          2,372.11      0.4514          1,070.77      0.4230              452.91      0.3968              179.69      0.3725                66.94      0.3501                23.44
NPV       1,94,082.21 1,63,564.08        81,438.40        -8,495.24      -96,745.54 -1,76,630.83 -2,44,598.86 -2,99,728.48 -3,42,860.07 -3,75,734.81 -4,00,350.15 -4,18,576.94 -4,31,989.20 -4,41,828.85 -4,49,038.15
IRR is the rate at which NPV become Zero
At 6% NPV = 81438.50
At 8% NPV = -8495.24
Hence IRR = 6% + (81438 / 81438+8495.24 ) x 2 (This 2 is the difference between 8% -6%) 7.81
So IRR is 7.81% approxi
Add a comment
Know the answer?
Add Answer to:
4. Lepton Industries has a project with the following projected cash flows: Initial Cost, Year 0:...
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
  • 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...

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

    Net present value. Lepton Industries has a project with the following projected cash flows: 3: a. Using a discount rate of 12% 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 22%? a. Using a discount rate of 12%, this project should be . (Select...

  • P9-8 (similar to) EQuestion Help Net present value. Lepton Industries has a project with the following...

    P9-8 (similar to) EQuestion Help Net present value. Lepton Industries has a project with the following projected cash flows: a. Using a discount rate of 9% 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 %? . (Select from the drop-down menu.) a....

  • Consider Project Theta, its time line of cash flows, and one of the project IRRs: Year....................0.............1............2............IRR...

    Consider Project Theta, its time line of cash flows, and one of the project IRRs: Year....................0.............1............2............IRR Cash Flow......($200).....$850....($700)......15% What is the best decision for Project Theta (accept or reject) if the project’s required rate of return is 15% and why? a. Accept the project because the payback is short b. Accept the project because the NPV is greater than zero c. Reject the project because the IRR is less than the required rate of return d. Reject the project because...

  • Consider Project Theta, its time line of cash flows, and one of the project IRRs: Year...................0..............1...............2...........IRR...

    Consider Project Theta, its time line of cash flows, and one of the project IRRs: Year...................0..............1...............2...........IRR Cash Flow.....($200).....$850.......($700).......15% What is the best decision for Project Theta (accept or reject) if the project’s required rate of return is 15% and why? a. Reject the project because the NPV is less than zero b. Accept the project because the IRR is greater than zero c. Accept the project because the NPV is greater than zero d. Accept the project because the payback...

  • Internal rate of return and modified internal rate of return. Lepton Industries has three potential​ projects, all with...

    Internal rate of return and modified internal rate of return. Lepton Industries has three potential​ projects, all with an initial cost of ​$1,700,000. Given the discount rate and the future cash flows of each​ project, what are the IRRs and MIRRs of the three projects for Lepton​ Industries?   Cash Flow Project Q Project R Project S   Year 1 ​ $400,000 ​$600,000 ​$900,000   Year 2 ​$400,000 ​$600,000 ​$700,000   Year 3 ​$400,000 ​$600,000 ​$500,000   Year 4 ​$400,000 ​$600,000 ​$300,000   Year 5 ​$400,000...

  • A project has the following expected cash flows: Year 0 Year 1 Year 2 Year 3...

    A project has the following expected cash flows: Year 0 Year 1 Year 2 Year 3 ($1,480) $640 $250 $300 Assume the risk-adjusted discount rate (k)(k) is 7.8%. Based on the IRR rule, should you accept or reject this project? Use Excel or a financial calculator. Cannot be determined. No, the project should be rejected. Yes, the project should be accepted.

  • NPV profile of a project. Given the following cash flow of Project​ L-2, draw the NPV...

    NPV profile of a project. Given the following cash flow of Project​ L-2, draw the NPV profile. Hint​: Be sure to use a discount rate of zero for one intercept ​(y​-axis) and solve for the IRR for the other intercept ​(x​-axis). ​ Year 0​ = -$240,000 Year 1​ = $ 40,000 Year 2​ = $ 79,000 Year 3​ = $ 118,000 Year 4​ = $ 131,000 What is the NPV of Project​ L-2 where zero is the discount​ rate?

  • Suppose you are offered a project with the following payments: Year Cash Flows 0 $ 9,700...

    Suppose you are offered a project with the following payments: Year Cash Flows 0 $ 9,700 1. − 5,200 2. − 3,900 3. − 3,000 4. − 1,600 a. What is the IRR of this offer? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) IRR % b. If the appropriate discount rate is 14 percent, should you accept this offer? Accept Reject c. If the appropriate discount rate is 20...

  • Problems with IRR White Rock Services Inc. has an opportunity to make an investment with the...

    Problems with IRR White Rock Services Inc. has an opportunity to make an investment with the following projected cash flows. Year         Cash Flow 0              $1,680,000 1              -3,885,000 2              2,225,021 a. Calculate the NPV at the following discount rates and plot an NPV profile for this​ investment: 0​%, 5​%, 7.5​%, 10​%, 15%​, 20​%, 22.5​%, 25​%, 30​%. b. What does the NPV profile tell you about this​ investment's IRR? c. If the company follows the IRR decision rule and their cost of...

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