A 1 234 56989 B Reset Parameters $70 7% 7 8 20 Your answer Correct Answer 16 Instructions: Build a model to calculate the present value of receiving 7 cash flows of $70. Assume cash flows start in period 8 and only occur in even years. Hint: Use EVEN to determine which years are even vs odd. Assume a discount rate of 7%. Allow your model to accommodate up to 25 periods. Use your model to answer the following questions: How many years have a cash flow of $0? What is the present value of all cash flows? What is the present value of $1 in year 20? Cash Flow Discount Rate Periods Starting Period Lookup Year 10 11 17 12 18 13 14 Year Cash Flow Present Value of $1 Present Value of Cash Flow 15 1 2 16 17 3 4 18 5 19 6 20 7 21 8 22 9 23 10 24 25 11 12 18 $197.06 $0.26 +

A 1 234 56989 B Reset Parameters $70 7% 7 8 20 Your answer Correct Answer 16 Instructions: Build a model to calculate the present value of receiving 7 cash flows of $70. Assume cash flows start in period 8 and only occur in even years. Hint: Use EVEN to determine which years are even vs odd. Assume a discount rate of 7%. Allow your model to accommodate up to 25 periods. Use your model to answer the following questions: How many years have a cash flow of $0? What is the present value of all cash flows? What is the present value of $1 in year 20? Cash Flow Discount Rate Periods Starting Period Lookup Year 10 11 17 12 18 13 14 Year Cash Flow Present Value of $1 Present Value of Cash Flow 15 1 2 16 17 3 4 18 5 19 6 20 7 21 8 22 9 23 10 24 25 11 12 18 $197.06 $0.26 +

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

n.com Connect (i) Consider the following cash flows: Year Cash Flow 0 -$29,600 1 14,100 2 14,800 3 11,200 a. What is the profitability index for the cash flows if the relevant discount rate is 11 percent? Note: Do not round intermediate calculations and round your answer to 3 decimal places, e.g., 32.161 b. What is the profitability index if the discount rate is 16 percent? Note: Do not round intermediate calculations and round your answer to 3 decimal places, e.g., 32.161. c. What is the profitability index if the discount rate is 23 percent? Note: Do not round intermediate calculations and round your answer to 3 decimal places, e.g., 32.161. a. Profitability index b. Profitability index c. Profitability index.
Consider the following cash flows: Year Cash Flow 0 −$ 29,000 1 14,700 2 14,200 3 10,600 What is the profitability index for the cash flows if the relevant discount rate is 10 percent? Note: Do not round intermediate calculations and round your answer to 3 decimal places, e.g., 32.161. What is the profitability index if the discount rate is 15 percent? Note: Do not round intermediate calculations and round your answer to 3 decimal places, e.g., 32.161. What is the profitability index if the discount rate is 22 percent? Note: Do not round intermediate calculations and round your answer to 3 decimal places, e.g., 32.161.
Consider the following cash flows: Year 0 Cash Flow -$ 5,100 es 01234 1,500 2,600 1,300 1,000 Check my work 4 What is the payback period for the cash flows? Note: Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16. Payback period -32.16 years
Consider the following cash flows: Year Cash Flow 0 -$ 14,800 1 8,400 2 7,600 4,300 a. What is the profitability index for the above set of cash flows if the relevant discount rate is 10 percent? Note: Do not round intermediate calculations and round your answer to 3 decimal places, e.g., 32.161. b. What is the profitability index if the discount rate is 15 percent? Note: Do not round intermediate calculations and round your answer to 3 decimal places, e.g., 32.161. c. What is the profitability index if the discount rate is 22 percent? Note: Do not round intermediate calculations and round your answer to 3 decimal places, e.g., 32.161. a. Profitability index b. Profitability index c. Profitability index
Consider the following cash flows: Year 0 1 2 3 4 Cash Flow -$ 8,000 2,250 5,300 2,050 1,750 What is the payback period for the cash flows? Note: Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16. Payback period years M Prev 1 of 5 Next > tubi
%24 What is the present value of a $1,000 payment made in five years when the discount rate is 10 percent? (Do not round Intermedlate calculatlons. Round your enswer to 2 declmal places.) Present value र् ( Prev 37 of 40 Next > ype here to search DELL F2 F4 F5 F7 F8 F11 F12 KA #3 V %
Consider the following cash flows: Year Cash Flow 0 1 2 3 $19,400 10,400 9,320 6,900 What is the IRR of the above set of cash flows? (Do not round Intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.) Internal rate of return 4 Prev
Year Cash Flow 0 -$ 17,400 1 9,700 8,600 5,100 2 3 a. What is the profitability index for the set of cash flows if the relevant discount rate is 11 percent? (Do not round intermediate calculations and round your answer to 3 decimal places, e.g., 32.161.) b. What is the profitability index for the set of cash flows if the relevant discount rate is 16 percent? (Do not round intermediate calculations and round your answer to 3 decimal places, e.g., 32.161.) c. What is the profitability index for the set of cash flows if the relevant discount rate is 23 percent? (Do not round intermediate calculations and round your answer to 3 decimal places, e.g., 32.161.) a. Profitability index b. Profitability index c. Profitability index
Uneven Cash Flow Stream Year Cash Stream A Cash Stream B 1 $100 $300 2 400 400 3 400 400 4 400 400 5 300 100 What is the value of each cash flow stream at a 0% interest rate? Round your answers to the nearest cent.Stream A $ _______Stream B $ _______
Mendez Company has identified an investment project with the following cash flows. Year Cash Flow 1 2 3 $780 1,050 1,310 1,425 a. If the discount rate is 8 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 17 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 25 percent? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) a. Present value at 8% b. Present value at 17% c. Present value at 25%
What is the present value of an investment with the following cash flows? Year 1 $14,000 Year 2 $20, 000 Year 3 $30,000 Year 4. $ 43,000 Year 5. $ 57,000 Use a 7% discount rate, and round your answer to the nearest $1. a. $128, 487 b. $107, 328 c. $112, 346 d. $ 153, 272
Mendez Company has identified an investment project with the following cash flows. Year Cash Flow 1 $ 1,150 2 1,030 3 1,520 4 1,880 If the discount rate is 11 percent, what is the present value of these cash flows? Note: Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16. What is the present value at 16 percent? Note: Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16. What is the present value at 22 percent? Note: Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.

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