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
Related questions
Concept explainers
Question
thumb_up100%
A project with a 3 year life and a cost of Rs. 100,000 generates revenue of Rs. 25,000 in year 1, Rs. 45,000 in year 2, and Rs. 65, 000 in year 3. If the discount rate is 8%, what is the NPV of the project?
Use excel functions
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps with 1 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
- Below are four cases that you will have to solve using Excel spreadsheets. 1st case The company COMERCIAL SA has two investment alternatives that present the following information: PROJECT A B It is requested Initial investment. $25,000 $22,000 Cash flows year 1 1. Determine the internal rate of return. 2. Determine the present value. $7,000 $12,000 The discount rate for the project will be 10% and the MARR will be 20%. 3. Determine the recovery period. 4. Define which is the most viable project. Year 2 cash flows $15,000 $8,000 Year 3 cash flows $18,000 $12,000arrow_forward(Click on the following icon in order to copy its contents into a spreadsheet.) Year 1 Year 2 Year 3 Year 0 -$50 -$101 $26 $20 $22 $22 $39 $49 Project A B Year 4 $16 $62 You are choosing between two projects. The cash flows for the projects are given in the following table ($ million): a. What are the IRRs of the two projects? b. If your discount rate is 5.2%, what are the NPVs of the two projects? c. Why do IRR and NPV rank the two projects differently?arrow_forwardCalculate the payback period, the discounted payback period and the NPV for the following project using a rate of 5%. Time Cash Flow 0 - $53,000 1 $ 21,000 2 $ 21,000 3 $ 21,000 NPV = Payback = Discounted Payback =arrow_forward
- Calculate the payback period, the discounted payback period and the NPV for the following project using a rate of 5%. Time Cash Flow 0 - $63,000 $ 21,000 $ 21,000 $ 21,000 $ 21,000 Payback = Discounted Payback =arrow_forwardA. Calculate the profitability index for project X. B. Calculate the profitability for project Y C. Using the NPV method combined with the PI aporoach, which project would you select? Use a discount rate of 13 percentarrow_forwardThree alternatives have the following cost and annual benefit data associated with them: The loan payments are calculated using an interest rate of 10%, a life equal to the life of the machine, and a down payment of 30%. Use a MARR of 12% and determine which machine, if any, should be purchased. Use incremental rate of return for your analysis. Do not forget to use DN in the analysis.arrow_forward
- time 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_forwardA2. (PaybackandNPV)Threeprojectshavethecashflowsgivenhere.Thecostofcapitalis10%. a. Calculate the paybacks for all three projects. Rank the projects from best to worst based on their paybacks. Calculate the NPVs for all three projects. Rank the projects from best to worst based on their NPVs c. Why are these two sets of rankings different? YEAR 0 1 2 3 4 5Project 1 −10 4 3 2 1 5 Project 2 −10 1 2 3 4 5 Project 3 −10 4 3 2 1 10arrow_forwardThe following two alternatives are given. Data A B. First Cost $8,200 $5,600 Annual Cost $1,000 $800 Annual Benefit $2,700 $2,100 Life, Years 7. Salvage Value $2,800 $1,000 Assume that MARR is 15%. Use the incremental rate of return analysis to determine which alternative (A or B) one should choose. Find the AIRR, or a range of AIRR. O 10% O 10-12% O 12-15% O > 15%arrow_forward
- Problem 4. Which project would you select on the basis of rate of return, assuming MARR =15%. Please use excel spreadsheet to answer.arrow_forwardYou are evaluating two different systems: System A costs $45,000, has a three year life and costs $5,000 per year to operate. System B costs $65,000, has a five year life and costs $4,000 per year to operate. If the required rate of return is 8%, which system would you prefer? I Next Slidearrow_forward(4) Evaluate the ROI.arrow_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 Learning
Corporate 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