Question 3: An investment yields expected future cash flows of $21.00, $34.00, $40.00, $33.00, and $17.00 in periods 1 through 5, respectively. Set up the CFs in an Excel spreadsheet as for Question 1. For these expected cash flows, the appropriate discount rate is 8.0%. What is the value of this stream of CFs? a. Estimate the PV as the sum of the PVs of each of the CFs. b. Can we use the annuity formula? c. Use the excel built-in function PV.

Question 3: An investment yields expected future cash flows of $21.00, $34.00, $40.00, $33.00, and $17.00 in periods 1 through 5, respectively. Set up the CFs in an Excel spreadsheet as for Question 1. For these expected cash flows, the appropriate discount rate is 8.0%. What is the value of this stream of CFs? a. Estimate the PV as the sum of the PVs of each of the CFs. b. Can we use the annuity formula? c. Use the excel built-in function PV.

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

Assume that an investment is forecasted to produce the following cash flows: a 10% probability of $1475; a 50% probability of $2893; and a 40% probability of $3831. What is the expected amount of cash flow this investment will produce? Instruction: Type ONLY your numerical answer in the unit of dollars
A company wanted to invest in a project which requires an initial investment of ₱10,000 and discounting rate of 10% and will yield yearly cash flows as follows: Year 1, ₱2,000; Year 2, ₱7,000 and Year 3, ₱6,000. So, we will find out the Profitability Index by using the formula, PV of the cash flow = FV/ (1+i) ^n. - Calculate PV of the cash flow for Year 1 of investment. -Calculate PV of the cash flow for Year 2 of investment. -Calculate PV of the cash flow for Year 3 of investment. -How much is the total PV of future cash flow of the investment? -Find the Profitability Index of the investment.
For the given cash flows, suppose the firm uses the NPV decision rule.Year Cash Flow0 −$ 159,0001 57,0002 82,0003 66,000. a. At a required return of 8 percent, what is the NPV of the project. b. At a required return of 19 percent, what is the NPV of the project.
For the cash flows shown, determine: (a) the number of possible i* values (b) the i* value displayed by the IRR function (c) the external rate of return using the MIRR method if ii = 18% per year and ib = 10% per year. Year 0 1 2 3 4 Revenues, $ 0 25,000 19,000 4000 18,000 Costs, $ −6000 −30,000 −7000 −6000 −12,000
Assuming a 1-year, money market account investment at 2.282.28 percent (APY), a 1.391.39 percent inflation rate, a 2525 percent marginal tax bracket, and a constant $50 comma 00050,000 balance, calculate the after-tax rate of return, the real rate of return, and the total monetary return. What are the implications of this result for cash management decisions?
Assuming a 1-year, money market account investment at 2.282.28 percent (APY), a 1.391.39 percent inflation rate, a 2525 percent marginal tax bracket, and a constant $50 comma 00050,000 balance, calculate the after-tax rate of return, the real rate of return, and the total monetary return. What are the implications of this result for cash management decisions? Question content area bottom Part 1 Assuming a 1-year, money market account investment at 2.282.28% (APY), a 2525% marginal tax bracket, and a constant $ 50 comma 000$50,000 balance, the after-tax rate of return is 1.711.71%. (Round to two decimal places.) Part 2 Assuming a 1-year, money market account investment at 2.282.28% (APY), a 2525% marginal tax bracket, and a constant $ 50 comma 000$50,000 balance, the after-tax monetary return is $855855. (Round to the nearest dollar.) Part 3 Given an after-tax return of 1.711.71% and an inflation rate of 1.391.39%, the after-tax real rate…
Assuming a 1-year, money market account investment at 2.282.28 percent (APY), a 1.391.39 percent inflation rate, a 2525 percent marginal tax bracket, and a constant $50 comma 00050,000 balance, calculate the after-tax rate of return, the real rate of return, and the total monetary return. What are the implications of this result for cash management decisions? Question content area bottom Part 1 Assuming a 1-year, money market account investment at 2.282.28% (APY), a 2525% marginal tax bracket, and a constant $ 50 comma 000$50,000 balance, the after-tax rate of return is 1.711.71%. (Round to two decimal places.) Part 2 Assuming a 1-year, money market account investment at 2.282.28% (APY), a 2525% marginal tax bracket, and a constant $ 50 comma 000$50,000 balance, the after-tax monetary return is $855855. (Round to the nearest dollar.) Part 3 Given an after-tax return of 1.711.71% and an inflation rate of 1.391.39%, the after-tax real rate…
Assuming a 1-year, money market account investment at 2.282.28 percent (APY), a 1.391.39 percent inflation rate, a 2525 percent marginal tax bracket, and a constant $50 comma 00050,000 balance, calculate the after-tax rate of return, the real rate of return, and the total monetary return. What are the implications of this result for cash management decisions? Question content area bottom Part 1 Assuming a 1-year, money market account investment at 2.282.28% (APY), a 2525% marginal tax bracket, and a constant $ 50 comma 000$50,000 balance, the after-tax rate of return is 1.711.71%. (Round to two decimal places.) Part 2 Assuming a 1-year, money market account investment at 2.282.28% (APY), a 2525% marginal tax bracket, and a constant $ 50 comma 000$50,000 balance, the after-tax monetary return is $855855. (Round to the nearest dollar.) Part 3 Given an after-tax return of 1.711.71% and an inflation rate of 1.391.39%, the after-tax real rate…
Percentages need to be entered in decimal format, for instance 3% would be entered as .03. West Coast Chemical Company (WCCC) is considering two mutually exclusive investments - Project A and Project B. The projects' expected net cash flows for Years 0-5 are shown in the spreadsheet provided. Based on the information in the spreadsheet, what is the NPV for Project A and Project B based on the required return of 10%? What is each project's IRR? If the required rate of return for each project is 13%, which project should West Coast select? If the required rate of return is 9%, what would be the proper choice? If the required rate of return is 15%, what would be the proper choice? For each scenario, explain why you chose the particular project. Refer to the Model-Generated Data portion of the spreadsheet and identify at what rate the NPV profiles for the two projects cross. The spreadsheet shows that Project A has a large cash flow in Year 5 associated with ending the project.…
Question 31 RWJ 9-8 MC Given the forecast cash flows of the Covina Donuts, what is the profitability index for assuming a discount rate of 14.50? Year Cash Flow 0 -$46,500 1 $12,200 2 $38,400 3 $11,300 Group of answer choices 0.97 1.06 0.93 1.02 Question 32 RWJ 9-1 MCMaria is examining a graph that shows the NPVs of a technology project against different required rates of return. What is this graph called? Group of answer choices Project return vs risk profile Project Rate of return profile IRR profile NPV profile
16. You are considering an investment with the following cash flows: Year Cash Flow 0 -$50,000 1 $ 7,000 2 $ 4,000 3 $9,000 4 $61,000 What is the internal rate of return (IRR) for this investment? SHOW WORK
For the given cash flows, suppose the firm uses the NPV decision rule. Year Cash Flow 0 –$ 148,000 1 64,000 2 75,000 3 59,000 a. At a required return of 12 percent, what is the NPV of the project? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. At a required return of 21 percent, what is the NPV of the project? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.)