A project has the following cash flows:YearCash Flow-$ 18,7009,40010,4006,500a. What is the NPV at a discount rate of zero percent? (Do not round intermediatecalculations and round your answer to the nearest whole number, e.g., 32.)b. What is the NPV at a discount rate of 10 percent? (Do not round intermediatecalculations and round your answer to 2 decimal places, e.g., 32.16.)c. What is the NPV at a discount rate of 20 percent? (Do not round intermediatecalculations and round your answer to 2 decimal places, e.g., 32.16.)d. What is the NPV at a discount rate of 30 percent? (A negative answer should beindicated by a minus sign. Do not round intermediate calculations and round youranswer to 2 decimal places, e.g., 32.16.)a. NPVb. NPVc. NPVd. NPVo123

Year Cash flow 0 -18700 1 9400 2 10400 3 6500

Answered: A project has the following cash flows:…

Essentials Of Investments

11th Edition

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Chapter1: Investments: Background And Issues

Section: Chapter Questions

Problem 1PS

See similar textbooks

Similar questions

Mendez Company has identified an investment project with the following cash flows. Year 1 Cash Flow $870 1,230 234 1,490 1,650 a. If the discount rate is 10 percent, what is the present value of these cash flows? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. What is the present value at 20 percent? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) c. What is the present value at 30 percent? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) a. Present value at 10% b. Present value at 20% c. Present value at 30%
Wells, Inc., has identified an investment project with the following cash flows. Cash Flow $ 950 1,180 1,400 2,140 Year 1 ~34 2 a. If the discount rate is 8 percent, what is the future value of these cash flows in Year 4? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. What is the future value at an interest rate of 11 percent? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) c. What is the future value at an interest rate of 24 percent? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) a. Future value at 8 percent b. Future value at 11 percent Future value at 24 percent c.
Fox Co. has identified an investment project with the following cash flows. Year Cash Flow 1 S 1,090 2 940 3 1, 490 4 1,850 a. If the discount rate is 12 percent, what is the present value of these cash flows? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. What is the present value at 15 percent? (Do not round intermediate calculations and round your answer to 2 decimal places, e. g., 32.16.) c. What is the present value at 21 percent? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)
A project that will provide annual cash flows of $2,600 for nine years costs $10,700 today? a. At a required return 12%, what is the NPV of the project? (DO NOT ROUND INTERMEDIATE CALCULATIONS AND ROUND YOUR ANSWER TO 2 DECIMAL PLACES) b. At a required return of 28%, what is the NPV of the project? (DO NOT ROUND INTERMEDIATE CALCULATIONS AND ROUND YOUR ANSWER TO 2 DECIMAL PLACES) c. At what discount rate would be indifferent between accepting the project and rejecting it? (DO NOT ROUND INTERMEDIATE CALCULATIONS AND ROUND YOUR ANSWER TO 2 DECIMAL PLACES) Could someone please help me solve this in excel?
Consider the following two projects: Project Year 0 Year 1 Year 2 Year 3 Year 4 Discount Cash Flow Cash Flow Cash Flow Cash Flow Cash Flow Rate A B -100 -73 40 30 50 50 N/A 0.11 30 30 30 0.11 The payback period for project A is closest to A. 2.4 years B. 2.2 years ○ C. 2 years OD. 2.6 years
A project has the following cash flows: Year Cash Flows 0 -$ 10,900 1 3 4 1234 4,630 6,640 4,160 -1,800 Assuming the appropriate interest rate is 7 percent, what is the MIRR for this project using the discounting approach? Multiple Choice 9.94% 14.08% 12.55% 8.29% 10.76%
Consider the following information: Cash Flows ($) Project C0 C1 C2 C3 C4 A –5,300 1,300 1,300 2,700 0 B –700 0 600 2,300 3,300 C –5,200 3,400 1,700 800 300 a. What is the payback period on each of the above projects? (Round your answers to 2 decimal places.) b. Given that you wish to use the payback rule with a cutoff period of two years, which projects would you accept?multiple choice 1 Project A Project B and Project C Project A and Project B Project A, Project B, and Project C Project C Project A and Project C Project B None c. If you use a cutoff period of three years, which projects would you accept?multiple choice 2 Project A, Project B, and Project C Project A Project B Project A and Project C Project C Project A and Project B Project B and Project C d. If the opportunity cost of capital is 10%, which projects have positive NPVs?multiple choice 3 Project B Project C Project A,…
Consider the following two mutually exclusive projects: Year Cash Flow Cash Flow (X) (Y) 0 -$20,800 -$20,800 1 9,050 10,500 2 9,500 8,000 3 9,000 8,900 IRR Project X: 15.49% Project Y: 15.69% What is the crossover rate for these two projects? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) Crossover rate ______%
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.)
A project has the following cash flows: Year Cash Flow 0 $ 37,000 1 -18,000 227,000 What is the IRR for this project? (Round the final answer to 2 decimal places.) IRR % What is the NPV of this project, if the required return is 11% ? ( Negative answer should be indicated by a minus sign. Do not round intermediate calculations. Round the final answer to 2 decimal places. Omit $ sign in your response.) NPV $ What is the NPV of the project if the required return is 0% ? ( Negative answer should be indicated by a minus sign. Omit $ sign in your response.) NPV $ What is the NPV of the project if the required return is 22 % ? (Do not round intermediate calculations. Round the final answer to 2 decimal places. Omit $ sign in your response.) NPV $
Consider the following two mutually exclusive projects: Year Cash Flow (X) Cash Flow (Y)0-$19.100-$ 19,100 18,625 9,650 2 8,650 7,575 3 8,575 8,475 Calculate the IRR for each project. (Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16.) What is the crossover rate for these two projects? (Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g.. 32.16.) What is the NPV of Projects X and Y at discount rates of 0 percent, 15 percent, and 25 percent?
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

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

Essentials Of Investments

Finance

ISBN:

9781260013924

Author:

Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:

Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:

9781260013962

Author:

BREALEY

Publisher:

RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:

9781337909730

Author:

Brigham

Publisher:

Cengage

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

SEE MORE TEXTBOOKS