The cash flows associated with an investment project are as follows: Year Project Y (200 000) 100 000 100 000 120 000 110 000 1 2 3 4 The discount rate is 8 percent. What's the discount payback period of the projects? (compile a spreadsheet) Calculate NPV, PI of a projects Calculate IRR of a projects Should the firm accept the project? a) b) c) d)

The cash flows associated with an investment project are as follows: Year Project Y (200 000) 100 000 100 000 120 000 110 000 1 2 3 4 The discount rate is 8 percent. What's the discount payback period of the projects? (compile a spreadsheet) Calculate NPV, PI of a projects Calculate IRR of a projects Should the firm accept the project? a) b) c) d)

Intermediate Financial Management (MindTap Course List)

13th Edition

ISBN:9781337395083

Author:Eugene F. Brigham, Phillip R. Daves

Publisher:Eugene F. Brigham, Phillip R. Daves

Chapter12: Capital Budgeting: Decision Criteria

Section: Chapter Questions

Problem 13P

See similar textbooks

Similar questions

Start with the partial model in the file Ch10 P23 Build a Model.xlsx on the textbooks Web site. Gardial Fisheries is considering two mutually exclusive investments. The projects expected net cash flows are as follows: a. If each projects cost of capital is 12%, which project should be selected? If the cost of capital is 18%, what project is the proper choice? b. Construct NPV profiles for Projects A and B. c. What is each projects IRR? d. What is the crossover rate, and what is its significance? e. What is each projects MIRR at a cost of capital of 12%? At r = 18%? (Hint: Consider Period 7 as the end of Project Bs life.) f. What is the regular payback period for these two projects? g. At a cost of capital of 12%, what is the discounted payback period for these two projects? h. What is the profitability index for each project if the cost of capital is 12%?
The cash flows associated with an investment project are as follows: Year Project Y 0 (40 000) 1 10000 2 10000 3 15000 4 20000 The required return is 5 percent. Reinvestment rate 6%. What’s the discount payback period of the projects? (compile a spreadsheet) Calculate NPV, PI, IRR , MIRR of a projects Should the firm accept the project?
A project has the following cash flows set out below. What is the profitability index of this project if the relevant discount rate is 2 percent? Enter your final answer to two decimal places. Year Cash flow 0 -1,745 1 537 2 2,066 3 3,912
*** By using the following table format, calculate: (a) Calculate the, the Payback Period, and the net Present Value of for each project. Calculation of Payback Period for each project: CUMULATIVE CASH FLOWS Project A Project B Project C £ £ £ Year 1 Year 2 Year 3 Year 4 Year 5 Payback Period (years and months) Calculation of Net Present Value for each project: Discount Factors Project A Project B Project C CF DCF CF DCF CF DCF £ £ £ £ £ £ Year 1 Year 2 Year 3 Year 4 Year 5 Total DCF Initial investment Net present value b) For each of the above methods of project appraisal recommend which project should be taken up. c) Using all the information gathered from the above techniques which…
You identify an investment project with the following cash flows. If the discount rate is 10%, what is the present value of these cash flows? Y1- $500 Y2- $550 Y3- $800 Y4- $450. Please type answer no write by hend.
Consider an investment project with the cash flows given in the table below. Compute the IRR for this investment. Is the project acceptable at MARR = 10%? The IRR for this project is %. (Round to one decimal place.) n 0 1 2 3 Cash Flow -$35,000 15,000 14,520 13,990
Profitability index. Given the discount rate and the future cash flow of each project listed in the following table, . use the Pl to determine which projects the company should accept. What is the Pl of project A? i Data Table (Round to two decimal places.) (Click on the following icon o in order to copy its contents into a spreadsheet.) Cash Flow Project A -%241,900,000 $150,000 $350,000 Project B Year 0 $2,300,000 $1,150,000 $950 000 $750,000 $550,000 Year 1 Year 2 Year 3 $550,000 Year 4 $750,000 $950,000 4% Year 5 $350.000 Discount rate 18% Print Done
Project Y has following cash flows: C0 = -800, C1 = +6,000, and C2 = -6,000. Calculate the IRRs for the project: For what range of discount rates does the project have positive NPV (Plot a graph with NPV on the vertical axis and discount rate on the horizontal axis).
You've estimated the following cash flows (in $) for a project: A B 1 Year Cash flow 2 0 -3,000 3 1 900 4 2 1,300 5 3 1,606 The required return is 8.5%. 1. What is the IRR for the project? 2. What is the NPV of the project? 3. What should you do? Check all that apply: Accept the project based on its IRR Accept the project based on its NPV Reject the project based on its IRR Reject the project based on its NPV
Calculate the net present value of the following project for discount rates of 10,20 and 40 percent. Based on the NPVs you obtain, under which discount rates do you accept this project? Show your calculations. Cash Flows ($) Year 1 -7000 Year 2 4000 Year 3 19,000 NPV formula: NPV=sum_(t=0)^(n)(EATCF)/((1+k)^(t)) dution:-
Consider the following two mutually exclusive projects: Year Cash Flow (A) Cash Flow (B) -$ 15,456 5,225 8,223 13,013 8,705 0 1 234 -$ 276,363 26,400 51,000 57,000 402,000 Whichever project you choose, if any, you require a 6 percent return on your investment. a. What is the payback period for Project A? Payback period b. What is the payback period for Project B? Payback period c. What is the discounted payback period for Project A? Discounted payback period
You are considering a project that has the following cash flow data. What is the project's payback? Year 0 1 2 3 Cash Flow -900 350 450 550 Group of answer choices 2.40 1.53 1.96 2.18 2.62