A123456989BReset Parameters$707%7820Your answerCorrect Answer16Instructions: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 FlowDiscount RatePeriodsStarting PeriodLookup Year10111712181314YearCash FlowPresent Value of $1Present Value of Cash Flow151216173418519620721822923102425111218$197.06$0.26+

The objective of the question is to calculate the present value of future cash flows, determine the…

Answered: A 1 234 56989 B Reset Parameters $70 7%…

Corporate Fin Focused Approach

5th Edition

ISBN:9781285660516

Author:EHRHARDT

Publisher:EHRHARDT

Chapter7: Valuation Of Stocks And Corporations

Section: Chapter Questions

Problem 23SP

See similar textbooks

Similar questions

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
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.
Uneven Cash Flow Stream Find the present values of the following cash flow streams. The appropriate interest rate is 6%. Round your answers to the nearest cent. (Note that, when working with the calculator's cash flow register, you must enter CF0 = 0. ) Year Cash Stream A Cash Stream B 1 $100 $300 2 400 400 3 400 400 4 400 400 5 300 100 Stream A $ _______Stream B $ _______
Single Cash Flow Present Value Inputs Single Cash Flow $1,000 Discount Rate/Period 6% Number of Periods 5 Present Value using a Time Line Period 1 2 3 4 Cash Flows Present Value of Each Cash Flow Present Value Present Value using the Formula Present Value Present Value using the PV Function Present Value
Consider the following cash flows: Year Cash Flow 0 -$ 29,500 1 14,200 2 3 14,700 11,100 a. 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. 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 Cash Flow 0 −$28,300 1 15,400 2 13,500 3 9,900 a. What is the profitability index for the cash flows if the relevant discount rate is 9 percent? (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 14 percent? (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 25 percent? (Do not round intermediate calculations and round your answer to 3 decimal places, e.g., 32.161.)
What is the profitability index for the following set of cash flows if the relevant discount rate is 10 percent? What if the discount rate is 15 percent? If it is 22 percent? Year 0 Year 1 Year 2 Year 3 Discount rate Discount rate Discount rate $ $ DELLI $ $ (15,300) 9,400 7,600 4,300 10% 15% 22% Complete the following analysis. Do not hard code values in your calculations. You must use the built-in Excel function to answer this question. Profitability index at 10 percent
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.
500 Calculate the value of X to suit this cash flow diagram with i = 9%. X is an end of period payment. Provide modified cash flow diagram(s) necessary for your solution, and show all work. 400 300 200 100 2.
1. Discounted Payback (DCPB) and IRR analysis. Use the cash flow situation (table below) to answer. a. Determine the DCPB based on a MARR rate of 8.0% b. Determine the IRR Year Cash Flow (in $1000's) 0 1 -5500 +1500 2 +1800 3 +1500 4 +1800 5 6 +1500 +1800 7 +1500
Consider the following cash flows: Year Cash Flow -$29,900 13,800 15,100 11,500 1 2 3 a. What is the profitability index for the cash flows if the relevant discount rate is 8 percent? (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 13 percent? (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 20 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
Determine the rate of return for the cash flows shown in the diagram. Use trial and error (start with two trials with 5% and 10% interest rates) and then use interpolation (or more trials) to approximate the result. Roh?? S7000 1- ? Year 590 s90 s90 sz00 sz00 sz00 $3000

SEE MORE QUESTIONS

Recommended textbooks for you

Corporate Fin Focused Approach

Finance

ISBN:

9781285660516

Author:

EHRHARDT

Publisher:

Cengage

Corporate Fin Focused Approach

Finance

ISBN:

9781285660516

Author:

EHRHARDT

Publisher:

Cengage

SEE MORE TEXTBOOKS