### Discounted Payback Period Analysis for Sigma's ProjectThe conventional payback period ignores the time value of money, causing concern for Cute Camel's CFO. To address this, you are required to compute Sigma's discounted payback period, assuming a 9% cost of capital. Complete the following table with the 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, ensure the entire table is complete. (Note: If your answer is negative, use a minus sign.)| | Year 0 | Year 1 | Year 2 | Year 3 ||--------------------|-----------|-----------|-----------|-----------|| **Cash flow** | -$5,000,000 | $2,000,000 | $4,250,000 | $1,750,000 || **Discounted cash flow** | $ | $ | $ | $ || **Cumulative discounted cash flow** | $ | $ | $ | $ || **Discounted payback period:** | | | | |#### Conceptual Questions1. **Which version of a project’s payback period should the CFO use when evaluating Project Sigma, given its theoretical superiority?** - The regular payback period - The discounted payback period2. **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.**3. **How much value in this example does the discounted payback period method fail to recognize due to this theoretical deficiency?** - $4,928,461 - $3,186,183 - $1,763,323 - $1,351,321### Explanation of the Table and Questions#### Table Description- **Cash Flow (Row 1):** The initial and projected cash flows for Years 0 to 3.- **Discounted Cash Flow (Row 2):** The cash flows adjusted for the 9% cost of capital, representing the present value of future cash flows.- **Cumulative Discounted Cash Flow (Row 3):** The sum of the discounted cash flows over time, which helps determine when the initial investment is

Discounted cash flow (DCF) is a financial valuation method used to estimate the value of an…

Answered: The conventional payback period ignores…

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

Provide correct solution
Can someone please help me to solve the following question showing all work and formulas neatly. And please show the cash flow diagram as well. PLEASE ANS THANK YOU!!!!!
Suppose the management of a firm is trying to allocate liquid assets to two accounts, one of which is riskless but pays no interest, while the other offers a risky return. Assume the rate of return r on the second account is uniformly distributed over the range [-0.5, 0.5]. Let R denote the amount currently available for allocation to the two accounts, and S denote the amount invested in the risky asset. Suppose management would like to make the next period investment value as large as possible but subject to the condition that R + Sr not fall below 95% of the original value of R too often so that if the investment falls below 95% of its original value, it should not do so more than 25% of the time. Calculate the ratio of investment and the amount available, that is, a = R
Consider two assets with the following cash flow streams: Asset A generates $4 at t=1, $3 at t=2, and $10 at t=3. Asset B generates $2 at t=1, $X at t=2, and $10 at t=3. Suppose X=6 and the interest rate r is constant. For r=0.1, calculate the present value of the two assets. Determine the set of all interest rates {r} such that asset A is more valuable than asset Draw the present value of the assets as a function of the interest rate. Suppose r=0.2. Find the value X such that the present value of asset B is 12. Suppose the (one-period) interest rates are variable and given as follows: r01=0.1,r12=0.2, r23=0.3. Calculate the yield to maturity of asset A. (You can use Excel or ascientific calculator to find the solution numerically.)
Solve the following problems without using any software, do everything in digital format, explain the formulas, substitutions and result 1. A company has in its portfolio of assets 10 promissory notes of $ 200 each, with monthly maturities at the end of the month. The company needs liquidity and plans to sell them to a bank, which has accepted the transaction with an interest rate of 24% per year (2% per month). What amount will the company receive if the operation is carried out? In other words, what is the present value of these notes?
Find the present values of the following cash flow streams. The appropriate interest rate is 9%. (Hint: It is fairly easy to work this problem dealing with the individual cash flows. However, if you have a financial calculator, read the section of the manual that describes how to enter cash flows such as the ones in this problem. This will take a little time, but the investment will pay huge dividends throughout the course. Note that, when working with the calculator's cash flow register, you must enter CF0 = 0. Note also that it is quite easy to work the problem with Excel, using procedures described in the Ch04 Tool Kit.xlsx.) Do not round intermediate calculations. Round your answers to the nearest cent. Year Cash Stream A Cash Stream B 1 $100 $200 2 400 400 3 400 400 4 400 400 5 200 100 Stream A: $ Stream B: $ What is the value of each cash flow stream at a 0% interest rate? Round your answers to the nearest dollar. Stream A $ Stream B $
Suppose that LilyMac Photography has annual sales of $233,000, cost of goods sold of $168,000, average inventories of $4,800, average accounts receivable of $25,600, and an average accounts payable balance of $7,300.Assuming that all of LilyMac’s sales are on credit, what will be the firm’s cash cycle? (Use 365 days a year. Do not round intermediate calculations. Round your final answer to 2 decimal places.)
Uneven Cash Flow Stream Find the present values of the following cash flow streams. The appropriate interest rate is 12%. (Hint: It is fairly easy to work this problem dealing with the individual cash flows. However, if you have a financial calculator, read the section of the manual that describes how to enter cash flows such as the ones in this problem. This will take a little time, but the investment will pay huge dividends throughout the course. Note that, when working with the calculator's cash flow register, you must enter CF0 = 0. Note also that it is quite easy to work the problem with Excel, using procedures described in the Ch04 Tool Kit.xlsx.) Do not round intermediate calculations. Round your answers to the nearest cent. Year Cash Stream A Cash Stream B 1 $100 $250 2 400 400 3 400 400 4 400 400 5 250 100 Stream A: $ Stream B: $ What is the value of each cash flow stream at a 0% interest rate? Round your answers to the nearest dollar. Stream…
Nelto deposits $2,500 in a bank account that pays 3% interest compounded quarterly. Two years later, how much do they have in their bank account? C 1 t=0 n Cash Flow Diagram ….....…... Time Value of Money (TVM) Framework PV PMT FV type How to compute using Excel? -function( rate, nper, pmt, [PV]. [type]) n CPT
Find the present values of the following cash flow streams. The appropriate interest rate is 6%. (Hint: It is fairly easy to work this problem dealing with the individual cash flows. However, if you have a financial calculator, read the section of the manual that describes how to enter cash flows such as the ones in this problem. This will take a little time, but the investment will pay huge dividends throughout the course. Note that, when working with the calculator's cash flow register, you must enter CF0 = 0. Note also that it is quite easy to work the problem with Excel, using procedures described in the Ch04 Tool Kit.xlsx.) Do not round intermediate calculations. Round your answers to the nearest cent. Year Cash Stream A Cash Stream B 1 $100 $250 2 400 400 3 400 400 4 400 400 5 250 100 Stream A: $ Stream B: $ What is the value of each cash flow stream at a 0% interest rate? Round your answers to the nearest dollar. Stream A $ Stream B $
2
Please give me full explanation Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.

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

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