Following is information on two alternative investment projects being considered by Tiger Company. The company requires a 4% return from its investments. Project X1 Project X2 Initial investment $ (120,000) $ (200,000) Net cash flows in: Year 1 45,000 90,000 Year 2 55,500 80,000 Year 3 80,500 70,000 Compute the internal rate of return for each of the projects using Excel functions. Based on internal rate of return, indicate whether each project is acceptable.

Following is information on two alternative investment projects being considered by Tiger Company. The company requires a 4% return from its investments. Project X1 Project X2 Initial investment $ (120,000) $ (200,000) Net cash flows in: Year 1 45,000 90,000 Year 2 55,500 80,000 Year 3 80,500 70,000 Compute the internal rate of return for each of the projects using Excel functions. Based on internal rate of return, indicate whether each project is acceptable.

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

Following is information on two alternative investments. Beachside Resort is considering building a new pool or spa. The company requires a 10% return from its investments. Initial investment Net cash flows in: Year 1 40,000 Year 2 56,000 Year 3 80,295 Year 4 90,400 Year 5 65,000 Compute the internal rate of return for each of the projects using excel functions. (Round your answers to 2 decimal places.) Pool Spa IRR Pool Spa $ (160,000) $ (105,000) % % 32,000 50,000 66,000 72,000 24,000
Below are four cases that you will have to solve using Excel spreadsheets. 2nd case The COMPETIDORA SA company has the possibility of investing in three different projects . The projections show us the following information on which a decision must be made: PROJECT X Y Initial Z$310,000 It is requested: investment $180,000 $250,000 Year 1 cash flows $50,000 $80,000 $150,000 1. Determine the internal rate of return. 2. Determine the present value. Year 2 cash flows 3. Determine the recovery period. 4. Define which is the most viable project. $70,000 $80,000 $120,000 The discount rate for the project will be 9% and the investors propose a MARR of 22%. Year 3 cash flows $80,000 $80,000 $100,000 Year 4 cash flows $100,000 $80,000
Salsa Company is considering an investment in technology to improve its operations. The investment costs $250,000 and will yield the following net cash flows. Management requires a 7% return on Investments. (PV of $1, FV of $1, PVA of $1, and FVA of $1) (Use appropriate factor(s) from the tables provided.) Year Net cash Flow 1 $ 48,400 2 52,500 3 76,200 4 94,700 5 125,100 Required: 1. Determine the payback period for this Investment. 2. Determine the break-even time for this Investment. 3. Determine the net present value for this Investment. 4. Should management invest in this project based on net present value? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Determine the break-even time for this investment. (Enter cash outflows with a minus sign. Round your break-even time answer to 1 decimal place.) 1 at 7% Year Net Cash Flows Present Value of Present Value of Net Cash Flows per Year Initial investment $ (250,000) Year 1…
Perez Company is considering an investment of $20,957 that provides net cash flows of $6,900 annually for four years. (a) What is the internal rate of return of this investment? (PV of $1, FV of $1, PVA of $1, and FVA of $1) Note: Use appropriate factor(s) from the tables provided. Round your present value factor to 4 decimals. (b) The hurdle rate is 9%. Should the company invest in this project on the basis of internal rate of return? Complete this question by entering your answers in the tabs below. Required A Required B What is the internal rate of return of this investment? Present value factor Internal rate of return % Required A Required B
Morrisey Company has two investment opportunities. Both investments cost $6,900 and will provide the same total future cash inflows. The cash receipt schedule for each investment is given below: Investment I Investment II Period 1 $ 1,950 $ 1,950 Period 2 1,950 3,140 Period 3 2,950 4,330 Period 4 5,520 2,950 Total $12,370 $12,370 What is the net present value of Investment Il assuming an 12% minimum rate of return? (PV of $1 and PVA of $1) (Use appropriate factor(s) from the tables provided. Do not round your intermediate calculations. Round your answer to the nearest whole dollar.) Multiple Choice $2,301 $9,201 $12,370 $(8,903)
Duo Corporation is evaluating a project with the following cash flows. The company uses a discount rate of 10 percent and a reinvestment rate of 7 percent on all of its projects. Year 0 1 Cash Flow -$ 15,400 6,500 7,700 7,300 6,100 -3,500 Calculate the MIRR of the project using all three methods with these interest rates. Note: Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16. Discounting approach Reinvestment approach Combination approach % % %
A company is considering a $150,000 investment in machinery with the following net cash flows. The company requires a 10% return on its investments. (PV of $1. EV of $1. PVA of $1, and EVA of $1) (Use appropriate factor(s) from the tables provided.) Year Year 1 $10,000 Year 1 Year 2 Year 3 Year 4 Year 5 Net cash flows (a) Compute the net present value of this investment. (b) Should the machinery be purchased? Complete this question by entering your answers in the tabs below. Totals Initial investment Net present value Year 2 $25,000 Year 3 $50,000 Required A Required B Compute the net present value of this investment. (Round your present value factor to 4 decimals. Round your final answers to the nearest whole dollar) Net Cash Flows Year 4 $37,500 Present Value Present Value of Factor Net Cash Flows
Please slove the question shown in the image. Calculating the rate of return on investment. Please show basic steps of how you derived the answer.
Salsa Company is considering an investment in technology to improve its operations. The investment costs $241,000 and will yield the following net cash flows. Management requires a 10% return on investments. (PV of $1, FV of $1, PVA of $1, and FVA of $1) Note: Use appropriate factor(s) from the tables provided. Year Net cash Flow 1 $ 48, 200 2 53,900 3 76, 400 4 95,500 5 126,500 Required: Determine the payback period for this investment. Determine the break - even time for this investment. Determine the net present value for this investment. Should management invest in this project based on net present value?
Below are information relating to three (3) possible projects. Evaluate the projects by filling up the blanks provided for the final answers. Show computations in the yellow pad. Net Cash outlay Annual net cash inflows Annual depreciation expense Expected recovery period Cost of capital Discounted payback period Internal rate of return (approximate) Net Present Value (NPV) Simple Accounting Rate of Return Ranking May P300,000 50,000 20,000 10 years 16% June P120,000 35,000 18,000 6 years 18% Dianay P150,000 55,000 25,000 5 years 22%
Dogwood Company is considering a capital investment in machinery: (Click the icon to view the data.) 8. Calculate the payback. 9. Calculate the ARR. Round the percentage to two decimal places. 10. Based on your answers to the above questions, should Dogwood invest in the machinery? 8. Calculate the payback. Amount invested Expected annual net cash inflow Payback 1,500,000 24 500,000 3 years 9. Calculate the ARR. Round the percentage to two decimal places. Average annual operating income Average amount invested ARR Data Table Initial investment $ 1,500,000 Residual value 350,000 Expected annual net cash inflows 500,000 Expected useful life 4 years Required rate of return 15%
Vikrambhai

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

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

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