ill be $77,000 in five years. The computer will replacies are $122,000. The machine will also immediatel-97,000. This amount of net working capital will needate tax rate is 22 percent. The appropriate discounte NPV of this project. (Do not round intermediate caes, e.g., 32.16.)w work using Excel and show Formulas. Thank you

NPV Calculation with Excel FormulasThis scenario can be analyzed using Excel's Net Present Value…

Answered: ill be $77,000 in five years. The…

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

Pl Need answer in hand written. Not in excel sheet. For a project with: F.C. = JD 4000 Extra cost at the end of the 4 year = 2500 Annual income = 2000 n= 5 years a) Calculate the IRR (i*) b) is it acceptable, if MARR=10% per year?
Find the future value of a five-year $124,000 investment that pays 8.75 percent and that has the following compounding periods: (Do not round intermediate calculations, round final answers to 2 decimal places, e.g. 15.25.) Excel Template(Note: This template includes the problem statement as it appears in your textbook. The problem assigned to you here may have different values. When using this template, copy the problem statement from this screen for easy reference to the values you’ve been given here, and be sure to update any values that may have been pre-entered in the template based on the textbook version of the problem.) Value of investment after 5 years a. Quarterly $ b. Monthly $ c. Daily $ d. Continuous $
Consider a project lasting one year only. The initial outlay is $1,000 and the expected inflow is $1,290. The opportunity cost of capital is r = 0.29. The borrowing rate is rD calculations. Round your answers to 2 decimal places. Leave no cells blank - be certain to enter "O" wherever required.) 0.21. (Do not round intermediate 0.08, and the tax shield per dollar of interest is Tc a. What is the project's base-case NPV? Base-case NPV b. What is its APV if the firm borrows 39% of the project's required investment? Adjusted present value
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,000
Crane Company is considering three long-term capital investment proposals. Each investment has a useful life of 5 years. Relevant data on each project are as follows. Project Bono Project Edge Project Clayton Capital investment $164,000 $180,500 $204,000 Annual net income: Year 1 14,420 18,540 27,810 2 14,420 17,510 23,690 14,420 16,480 21,630 4 14,420 12,360 13,390 14,420 9,270 12,360 Total $72,100 $74,160 $98,880 Depreciation is computed by the straight-line method with no salvage value. The company's cost of capital is 15%. (Assume that cash flows occur evenly throughout the year.) Click here to view the factor table. Compute the cash payback period for each project. (Round answers to 2 decimal places, e.g. 10.50.) Project Bono years Project Edge years Project Clayton years
Find the future value of a five-year $96,000 investment that pays 5.50 percent and that has the following compounding periods: (Do- not round intermediate calculations, round final answers to 2 decimal places, e.g. 15.25.) Excel Template (Note: This template includes the problem statement as it appears in your textbook. The problem assigned to you here may have different values. When using this template, copy the problem statement from this screen for easy reference to the values you've been given here, and be sure to update any values that may have been pre-entered in the template based on the textbook version of the problem.) Value of investment after 5 years a. Quarterly b. Monthly c. Daily $ d. Continuous $ 129821 125232 129730
An interior design studio is trying to choose between the following two mutually exclusive design projects: Year 0 1 2 3 Cash Flow Cash Flow (0) -$64,000 31,000 31,000 31,000 a-1 If the required return is 10 percent, what is the profitability index for both projects? (Round your answers to 3 decimal places. (e.g., 32.161)) Project I Project II -$18,000 9,700 9,700 9,700 Profitability Index a-2 If the company applies the profitability index decision rule, which project should the firm accept? O Project I O Project II Project I Project II b-1 What is the NPV for both projects? (Round your answers to 2 decimal places. (e.g., 32.16)) O Project I Project II NPV b-2lf the company applies the NPV decision rule, which project should it take?
Do the following problems. You must show your work.c) Find the IRR and MIRR of the following project and make your decision. Assume that the project's cost of capital (or WACC) is 4%. Project X that costs $30 million is expected to generate $13m per year for 3 years. Is this project acceptable?
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
(c) Compute the annual rate of return for each project. (Hint: Use average annual net income in your computation.) (Round answers to 2 decimal places, e.g. 10.50%.) Annual rate of return Project Bono % Project Edge % Project Clayton %
Crane Company is considering three long-term capital investment proposals. Each investment has a useful life of 5 years. Relevant data on each project are as follows. Project Bono Project Edge Project Clayton Capital investment $164,000 $180,500 $204,000 Annual net income: Year 1 14,420 18,540 27,810 2 14,420 17,510 23,690 3 14,420 16,480 21,630 4 14,420 12,360 13,390 5 14,420 9,270 12,360 Total $72,100 $74,160 $98,880 Depreciation is computed by the straight-line method with no salvage value. The company's cost of capital is 15%. (Assume that cash flows occur evenly throughout the year.)
The Michner Corporation is trying to choose between the following two mutually exclusive design projects: Cash Flow (II) -$ 51,000 12,300 32,500 23,500 Year 0 1 2 3 Cash Flow (I) -$ 85,000 34,900 45,000 28,000 a-1. If the required return is 10 percent, what is the profitability index for each project? Note: Do not round intermediate calculations and round your answers to 3 decimal places, e.g., 32.161. a-2. If the company applies the profitability index decision rule, which project should it take? b-1. If the required return is 10 percent, what is the NPV for each project? Note: Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16. b-2. If the company applies the net present value decision rule, which project should it take? a-1. Project I Project II a-2. b-1. Project I Project II b-2. Answer is not complete. Project II Project I 1.058

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