Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

f. What is the regular payback period for these two projects? Project A Time period 0 1 2 3 4 5 6 7 Cash flow

f. What is the regular payback period for these two projects?
Project A
Time period 0 1 2 3 4 5 6 7
Cash flow (375) (300) (200) (100) 600 $600 $926 ($200)
Cumulative cash flow -$375 -$675 -$875 -$975 -$375 $225 $1,151 $951
Intermediate calculation for payback 100.000 100.000 100.000 100.000 100.000 62.50
Payback using intermediate calculations 4.62 years
Project B
Time period 0 1 2 3 4 5 6 7
Cash flow -$575 $190 $190 $190 $190 $190 $190 $0
Cumulative cash flow -$575 -$385 -$195 -$5 $185 $375 $565 $565
Intermediate calculation for payback 100.000 100.000 100.000 100.000
Payback using intermediate calculations
Payback using PERCENTRANK Ok because cash flows follow normal pattern.
g. At a cost of capital of 12%, what is the discounted payback period for these two projects?
WACC = 12%
Project A
Time period 0 1 2 3 4 5 6 7
Cash flow -$375 -$300 -$200 -$100 $600 $600 $926 -$200
Disc. cash flow
Disc. cum. cash flow
Intermediate calculation for payback
Payback using intermediate calculations
Project B
Time period 0 1 2 3 4 5 6 7
Cash flow
Disc. cash flow
Disc. cum. cash flow
Intermediate calculation for payback
Payback using intermediate calculations
Discounted Payback using PERCENTRANK 3.98 Ok because cash flows follow normal pattern.
h. What is the profitability index for each project if the cost of capital is 12%?
PV of future cash flows for A: $601.96
PI of A: 1.61
PV of future cash flows for B: $781.17
PI of B: 1.36

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions