The payback period The payback method helps firms establish and identify a maximum acceptable payback period that helps in their capital budgeting decisions. Consider the case of Cold Goose Metal Works Inc.: Cold Goose Metal Works Inc. is a small firm, and several of its managers are worried about how soon the firm will be able to recover its initial investment from Project Delta’s expected future cash flows. To answer this question, Cold Goose’s CFO has asked that you compute the project’s payback period using the following expected net cash flows and assuming that the cash flows are received evenly throughout each year. Complete the following table and compute the project’s conventional payback period. For full credit, complete the entire table. (Note: Round the conventional payback period to two decimal places. If your answer is negative, be sure to use a minus sign in your answer.) Year 0 Year 1 Year 2 Year 3 Expected cash flow -$6,000,000 $2,400,000 $5,100,000 $2,100,000 Cumulative cash flow Conventional payback period: years The conventional payback period ignores the time value of money, and this concerns Cold Goose’s CFO. He has now asked you to compute Delta’s discounted payback period, assuming the company has a 7% cost of capital. Complete the following table and perform any necessary calculations. Round the discounted cash flow values to the nearest whole dollar, and the discounted payback period to two decimal places. For full credit, complete the entire table. (Note: If your answer is negative, be sure to use a minus sign in your answer.) Year 0 Year 1 Year 2 Year 3 Cash flow -$6,000,000 $2,400,000 $5,100,000 $2,100,000 Discounted cash flow Cumulative discounted cash flow Discounted payback period: years Which version of a project’s payback period should the CFO use when evaluating Project Delta, given its theoretical superiority? The discounted payback period The regular payback period One theoretical disadvantage of both payback methods—compared to the net present value method—is that they fail to consider the value of the cash flows beyond the point in time equal to the payback period. How much value in this example does the discounted payback period method fail to recognize due to this theoretical deficiency? $6,168,764 $3,957,217 $2,411,755 $1,714,226 please slove using excel

The payback period The payback method helps firms establish and identify a maximum acceptable payback period that helps in their capital budgeting decisions. Consider the case of Cold Goose Metal Works Inc.: Cold Goose Metal Works Inc. is a small firm, and several of its managers are worried about how soon the firm will be able to recover its initial investment from Project Delta’s expected future cash flows. To answer this question, Cold Goose’s CFO has asked that you compute the project’s payback period using the following expected net cash flows and assuming that the cash flows are received evenly throughout each year. Complete the following table and compute the project’s conventional payback period. For full credit, complete the entire table. (Note: Round the conventional payback period to two decimal places. If your answer is negative, be sure to use a minus sign in your answer.) Year 0 Year 1 Year 2 Year 3 Expected cash flow -$6,000,000 $2,400,000 $5,100,000 $2,100,000 Cumulative cash flow Conventional payback period: years The conventional payback period ignores the time value of money, and this concerns Cold Goose’s CFO. He has now asked you to compute Delta’s discounted payback period, assuming the company has a 7% cost of capital. Complete the following table and perform any necessary calculations. Round the discounted cash flow values to the nearest whole dollar, and the discounted payback period to two decimal places. For full credit, complete the entire table. (Note: If your answer is negative, be sure to use a minus sign in your answer.) Year 0 Year 1 Year 2 Year 3 Cash flow -$6,000,000 $2,400,000 $5,100,000 $2,100,000 Discounted cash flow Cumulative discounted cash flow Discounted payback period: years Which version of a project’s payback period should the CFO use when evaluating Project Delta, given its theoretical superiority? The discounted payback period The regular payback period One theoretical disadvantage of both payback methods—compared to the net present value method—is that they fail to consider the value of the cash flows beyond the point in time equal to the payback period. How much value in this example does the discounted payback period method fail to recognize due to this theoretical deficiency? $6,168,764 $3,957,217 $2,411,755 $1,714,226 please slove using excel

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

The payback period

The payback method helps firms establish and identify a maximum acceptable payback period that helps in their capital budgeting decisions.

Consider the case of Cold Goose Metal Works Inc.:

Cold Goose Metal Works Inc. is a small firm, and several of its managers are worried about how soon the firm will be able to recover its initial investment from Project Delta’s expected future cash flows. To answer this question, Cold Goose’s CFO has asked that you compute the project’s payback period using the following expected net cash flows and assuming that the cash flows are received evenly throughout each year.

Complete the following table and compute the project’s conventional payback period. For full credit, complete the entire table. (Note: Round the conventional payback period to two decimal places. If your answer is negative, be sure to use a minus sign in your answer.)

	Year 0	Year 1	Year 2	Year 3
Expected cash flow	-$6,000,000	$2,400,000	$5,100,000	$2,100,000
Cumulative cash flow
Conventional payback period:	years

The conventional payback period ignores the time value of money, and this concerns Cold Goose’s CFO. He has now asked you to compute Delta’s discounted payback period, assuming the company has a 7% cost of capital. Complete the following table and perform any necessary calculations. Round the discounted cash flow values to the nearest whole dollar, and the discounted payback period to two decimal places. For full credit, complete the entire table. (Note: If your answer is negative, be sure to use a minus sign in your answer.)

	Year 0	Year 1	Year 2	Year 3
Cash flow	-$6,000,000	$2,400,000	$5,100,000	$2,100,000
Discounted cash flow
Cumulative discounted cash flow
Discounted payback period:	years

Which version of a project’s payback period should the CFO use when evaluating Project Delta, given its theoretical superiority?

The discounted payback period

The regular payback period

One theoretical disadvantage of both payback methods—compared to the net present value method—is that they fail to consider the value of the cash flows beyond the point in time equal to the payback period.

How much value in this example does the discounted payback period method fail to recognize due to this theoretical deficiency?

$6,168,764

$3,957,217

$2,411,755

$1,714,226

please slove using excel

Expert Solution