Your friend offers you an investment opportunity. If you give him $1,200 today, his project will provide you with the following cash flows in Years 1-4: $100, $200, $600, $550. You required 10% return on investments of this risk level. Alternatively, you can invest your $1,200 in the money market fund at 4% today. Which of the two options is a better investment opportunity? Q4. There are two different ways to answers the question (both lead to the same conclusion). Show the complete formula (not the calculator shortcuts) with all the necessary terms that you would use to solve the problem as if you didn't have a financial calculator on hand. Q5. Circle the better investment opportunity: Friend's project / Money market fund

Your friend offers you an investment opportunity. If you give him $1,200 today, his project will provide you with the following cash flows in Years 1-4: $100, $200, $600, $550. You required 10% return on investments of this risk level. Alternatively, you can invest your $1,200 in the money market fund at 4% today. Which of the two options is a better investment opportunity? Q4. There are two different ways to answers the question (both lead to the same conclusion). Show the complete formula (not the calculator shortcuts) with all the necessary terms that you would use to solve the problem as if you didn't have a financial calculator on hand. Q5. Circle the better investment opportunity: Friend's project / Money market fund

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

(Related to Checkpoint 6.6) (Present value of annuities and complex cash flows) You are given three investment alternatives to analyze. The cash flows from these three investments are as follows: € 12 X End of Year 1 2 S 3 4 5 6 7 8 7 N example # 3 a. What is the present value of investment A at an annual discount rate of 25 percent? $(Round to the nearest cent.) E D A $12,000 12,000 12,000 12,000 12,000 30 F3 Get more help. C $ 4 Investment Alternatives DOD 888 F4 R F V de s % B 5 $12,000 12,000 12,000 12,000 F5 T G 6 B C $12,000 60,000 MacBook Air F6 Y H & 7 N 44 U J 8 PII Fa 1 M - a K MOSISO DD F9 O < مه 26 -0 L command F10 P . V : ; Clear all 4 FU { I option [ +11 = ? 1 " I Final check 419) F12 } 1 delete retu
You are evaluating five different investments, all of which involve an upfront outlay of cash. Each investment will provide a single cash payment back to you in the future. Details of each investment appears here: Calculate the IRR of each investment. State your answer to the nearest basis point (i.e., the nearest 1/100th of 1%, such as 3.76%). The yield for investment A is The yield for investment B is The yield for investment C is The yield for investment D is The yield for investment E is %. (Round to two decimal places.) %. (Round to two decimal places.) %. (Round to two decimal places.) %. (Round to two decimal places.) %. (Round to two decimal places.) C Data table Investment A B с D E Initial Investment $1,600 $10,000 $600 $3,400 $5,200 Future Value Print $3,120 $15,775 $2,923 $4,526 $8,789 End of Year 10 11 16 Done 3 (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) 12 D X
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
Suppose your firm is considering investing in a project with the cash flows shown below, that the required rate of return on projects of this risk class is 11 percent, and that the maximum allowable payback and discounted payback statistics for your company are 3 and 3.5 years, respectively. Time: Cash flow: 0 1 -$233,000 $65,600 MIRR 2 $83,800 % 4 $140,800 $121,800 Use the MIRR decision rule to evaluate this project. Note: Do not round intermediate calculations and round your final answer to 2 decimal places. 5 $81,000
Please double check your work !! the answer is not 50.55 or 37.52 % You are considering an investment project with the cash flows of -300 (the initial cash flow), 800 (cash flow at year 1), -200 (cash flow at year 2). Given the discount rate of 10%, compute the Modified Internal Rate of Return (MIRR) using the discountingapproach. 50.55% 19.72% 71.94% 37.52%
Suppose your firm is considering investing in a project with the cash flows shown below, that the required rate of return on projects of this risk class is 7 percent, and that the maximum allowable payback and discounted payback statistics for the project are 3.5 and 4.5 years, respectively. Time: Cash flow: 0 2 3 4 5 -$5,400 $1,600 $2,800 $2,000 $2,000 $1,800 Use the MIRR decision rule to evaluate this project. (Do not round intermediate calculations and round your final answer to 2 decimal places.) 6 $1,600
Consider an investment where the cash flows are: – $946.21 at time t = 0 (negative since this is your initial investment) $377 at time t = 1 in years $204 at time t = 2 in years $499 at time t = 3 in years (a) Use Excel's "Solver" to find the internal rate of return (IRR) of this investment. Take a screen shot showing Solver open with your entries for the function clearly visible. Paste the screen shot into an application (like Paint), and save it as a (.png) file. Upload your screenshot below. (b) What is the value of IRR found by Solver?
You are choosing between two projects. The cash flows for the projects are given in the following table ( $ million ) : What are the IRRs of the two projects? If your discount rate is 5.4 % , what are the NPVs of the two projects? Why do IRR and NPV rank the two projects differently?
Suppose your firm is considering investing in a project with the cash flows shown below, that the required rate of return on projects of this risk class is 8 percent, and that the maximum allowable payback and discounted payback statistics for the project are 3.5 and 4.5 years, respectively. Time: Cash flow: 0 4 -$5,000 $1,200 $2,400 $1,600 $1,600 $1,400 Use the IRR decision rule to evaluate this project. (Do not round intermediate calculations and round your final onswer to 2 decimal places.) Answer is complete but not entirely correct. IRR 6 $1,200 14.00 %
Suppose your firm is considering investing in a project with the cash flows shown below, that the required rate of return on projects of this risk class is 7 percent, and that the maximum allowable payback and discounted payback statistics for the project are 3.5 and 4.5 years, respectively. Time: 1 2 3 4 Cash flow: -$5,000 $1,270 $2,470 $1,670 $1,670 5 6 $1,470 $1,270 Use the Pl decision rule to evaluate this project. (Do not round intermediate calculations and round your final answer to 2 decimal places.) PI Should it be accepted or rejected? O rejected O accepted
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
(Click on the following icon in order to copy its contents into a spreadsheet.) Year 1 Year 2 Year 3 Year 0 -$50 -$101 $26 $20 $22 $22 $39 $49 Project A B Year 4 $16 $62 You are choosing between two projects. The cash flows for the projects are given in the following table ($ million): a. What are the IRRs of the two projects? b. If your discount rate is 5.2%, what are the NPVs of the two projects? c. Why do IRR and NPV rank the two projects differently?

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