Essentials Of Investments
11th Edition
ISBN: 9781260013924
Author: Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher: Mcgraw-hill Education,
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Discount Rate | 12% | |
Investment Project | Cash Flow | Total Net Cash Flow |
Initial Investment | $ (8,000) | ? |
Year 1 | $ 800 | ? |
Year 2 | $ 900 | ? |
Year 3 | $ 1,500 | ? |
Year 4 | $ 1,800 | ? |
Year 5 | $ 3,200 | |
$ ? | ||
Estimated Payback Period | ? | |
Estimate the total net cash flows, NPV of Investment and Estimated Payback Period using the excel's formula.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by stepSolved in 2 steps with 2 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Similar questions
- ems with IRR Suppose you are offered a project with the following cash flows: Year Cash Flows 0 $ 8,900 1 -4,600 2 -3,300 3 -2,400 4 -1,700 a. What is the IRR of this offer? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) IRR % b. If the appropriate discount rate is 11 percent, should you accept this offer? O Reject Accept c. If the appropriate discount rate is 23 Sercent, should you accept this offer? 3 Percent, should you accept this offer? O Accept O Reject d-1. What is the NPV of the offer if the appropriate discount rate is 11 percent? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) d-2. What is the NPV of the offer if the appropriate discount rate is 23 percent? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)arrow_forwardThere is a project with the following cash flows : Year Cash Flow 0 −$ 23,350 1 6,300 2 7,400 3 8,450 4 7,350 5 5,900 What is the payback period?arrow_forwardNikul Don't upload image pleasearrow_forward
- 3. Compute for the following: Required: Payback period, payback reciprocal, accounting rate of return, Net present value and profitability index Total investment. P 200,000 Cost of capital 10% Net income P 15,000 for 8 years P 80,000 Cash inflowarrow_forwardConsider the following two mutually exclusive projects: Year Cash Flow (A) Cash Flow (B) 0 −$29,000 −$29000 1 14,400 4,300 2 12,300 9,800 3 9,200 15,200 4 5,100 16,800 a) What is the Internal Rate of Return (IRR) for each of these projects? b) Using the IRR decision rule, which project should the company accept? c) If the required return is 11 percent, what is the Net Present Value (NV) for each of these projects? d) Using the NPV decision rule, which project should the company accept? e) Why do you think the NPV and IRR rules do not agree on same project approval/rejection direction?arrow_forwardRefer to two projects with the following cash flows: Year Project A Project B 0 -$110 -$110 1 45 55 2 45 55 3 45 55 4 45 If the opportunity cost of capital is 11%, what is the profitability index for each project?arrow_forward
- Projection of yearl cashflow Year Cashflow($) 0 (239000.00) 1 3789.00 2 47675.00 3 122097.00 4 407968.00 5 453324.00 Given that the discount rate is 10% What is the projects discounted payback period? Calculate for Net Present Value? Calculate Internal Rate of Return?arrow_forwardConsider the following two projects: Project Year 0 Year 1 Cash Flow Cash Flow A B - 100 -73 40 30 OA. 2.7 years OB. 2 years OC. 2.3 years D. 2.5 years Year 2 Cash Flow 50 30 The payback period for project A is closest to Year 3 Cash Flow 40 30 *** Year 4 Cash Flow N/A 30 Discount Rate 0.1 0.1arrow_forwardtime value of money practice example: Please show calcualtions/steps (excell or other format): a) Calculate PB, DPB, NPV, IRR and PI for the following project: - discount rate of 12% - initial investment = 750,000 - ncf yr 1 = 150,000 - ncf yr 2 = 300,000 - ncf yr 3 = 400,000 - ncf yr 4 = 250,000 - ncf yr 5 = 100,000arrow_forward
- 3) Consider the following two projects: Net Cash Flow Each Period Initial Outlay 1 2 3 4 Project A $4,000,000 $2,003,000 $2,003,000 $2,003,000 $2,003,000 Project B $4,000,000 0 0 0 $11,000,000 Calculate the net present value of each of the above projects, assuming a 14 percent discount rate. What is the internal rate of return for each of the above projects? Compare and explain the conflicting rankings of the NPVs and IRRs obtained in parts a and b above. If 14 percent is the required rate of return, and these projects are independent, what decision should be made? If 14 percent is the required rate of return, and the projects are mutually exclusive, what decision should be made?arrow_forwardThere is a project with the following cash flows : Year 0 1 2 1345 Cash Flow -$ 23,350 6,300 7,400 8,450 7,350 5,900 What is the payback period?arrow_forwardWhat is the NPV of the estimated cash flows for the following project using a Weighted Average Cost of Capital of 7.0%? Year 0 1 2 3 Cash Flow -140 50 70 90 Group of answer choices 47.54 38.63 59.94 70.00 41.34arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
- Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningCorporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan ProfessorPublisher:McGraw-Hill Education
Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,
Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education