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
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?
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
After analysing the financial data of Q-Constructions, you notice that they are trending in the right direction. A new 12-month construction proposal has come to the company worth $1,000,000 and an important question is whether it will be financially viable. They want you to analyse the proposal, in particular, the recommended cash flow schedule and to understand the key financial points during the construction project. The following cash flow schedule is summarised below. To ensure that all upfront and on-going outlay costs are covered in advance, Q-Constructions incur an initial start-up cost of $200,000. The proposal states that they will receive a deposit from the client of 10% of the total project price at the beginning. They then receive four equal instalment payments of 20% of the total project price associated to project milestones from the client at the end of the 2nd, 6th, 8th and 10th month. Finally, they receive the last 10% project milestone on lock-up which occurs at the…
b) Calculate the profitability index (PI) of each project, assess its acceptability, and indicate which project is best using PI.

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