Question
Asked Nov 7, 2019
59 views

Judson's cost of capital is 12%, what is the DISCOUNTED Payback Period for the project?

Year Cash Flow in $
0 ($1000)
1 400
2 400
3 600
check_circle

Expert Answer

Step 1

Discounted payback period is calculated by finding the present value of all the cash flows and then using the cumulative cash flow method to determine the number of years it will take to repay the investment.

Please refer to the whiteboard for the calculation

help_outline

Image Transcriptionclose

A В C Е 1 Year Cash Flows Preset Value facor@12% Discounted Cash Flow (B C) Cumulative Cash Flow O S-1,000.00 -1,000.00 S 357.142857142857 S -642.857142857143 318.877551020408S 427.068148688047 S 1S 0.892857142857143 S 0.797193877551020 $ 0.711780247813411 $ -1,000.00 2 400.00 3 2S 3 S 400.00 -323.979591836735 4 600.00 103.0885568513 12

fullscreen
Step 2

Excel Workings:

help_outline

Image Transcriptionclose

A В C D Е 1 Year Cash Flows Preset Value facor@12% Discounted Cash Flow (B C) Cumulative Cash Flow =B2*C2 |-Bз*С3 ЕB4*C4 =B5*C5 -1000 400 400 600 1/1.12 0 - 1 / 1.12 1 - 1 / 1.12 2 - 1 / 1.12 3 =D2 =E2+D3 =E3+D4 -E4+D5 2 0 3 1 4 2 5 3

fullscreen
Step 3

Last Period with negative discounted cumulative cash flow is “A”.

Absolute value of the discounted cumulative cash flow at the end of pe...

help_outline

Image Transcriptionclose

Discounted Payback period = A+ 323.979591836735 2 427.068148688047 2+0.758613333333333 2.758613333333333 or 2.76 years

fullscreen

Want to see the full answer?

See Solution

Check out a sample Q&A here.

Want to see this answer and more?

Solutions are written by subject experts who are available 24/7. Questions are typically answered within 1 hour.*

See Solution
*Response times may vary by subject and question.
Tagged in

Business

Finance

Capital Budgeting

Related Finance Q&A

Find answers to questions asked by student like you
Show more Q&A
add
question_answer

Q: Finance Question

A: Future value of a stream of annuity is given by the expression shown on the white board. Symbols hav...

question_answer

Q: If $10,000 is invested in a certain business at the start of the year, the investor will receive $3,...

A: Computation of present value:Hence, the present value is $1,151.30.

question_answer

Q: Suppose a very large multi-Billion dollar, well known privately held company named Private Co. has d...

A: Required rate of return can be described as the lowest return which an investor is ready to receive ...

question_answer

Q: The past five monthly returns for PG&E are −3.55 percent, 4.83 percent, 4.15 percent, 7.04 perce...

A: Calculation of Standard Deviation of PG&E’s monthly return using STDEV.S function of excel:To op...

question_answer

Q: VMX is a newer company that produces cooling products for CPUS. The company has an estimated beta of...

A: Capital asset pricing model can be used to study the how systematic risk on a particular asset is li...

question_answer

Q: your firm has a debt-equity ratio of .75. your pre tax cost of debt is 8.5% and your unlevered equit...

A: Computation of the cost of levered equity:Hence, the levered cost of equity is 19.88%.

question_answer

Q: I need help with this problem.

A: Cost of Equipment = $5 BillionNumber of Life of Equipment = 5 YearsScrap Value of Equipment on 4th Y...

question_answer

Q: Spacefood Products will pay a dividend of $2.15 per share this year. It is expected that this divide...

A: Expected Divided (D1) = $2.15Cost of Equity (Ke) = 14%Growth Rate (g) = 6% Calculation of Current Va...

question_answer

Q: You decide to discount a$5250, 345-day note at 3% to your bank at a discount rate of 4.5% on day 210...

A: Calculation of Proceeds:Assuming there are 360 days in a year.The proceeds are $5,309.80.Excel Sprea...