Project A as well as project B require an initial investment of $1,050,000, have a 6-year life, and have expected total cash inflows of $1,680,000. Proposal A is expected to provide an annual net cash inflow of $280,000, while the annual net cash inflows for Proposal B are as follows:
Year 1 $350,000
Year 2 $315,000
Year 3 $280,000
Year 4 $280,000
Year 5 $245,000
Year 6 $210,000
Determine the cash payback period for each proposal. Round your answers to two decimal places.
Cash Payback Period
Proposal A
years
Proposal B
years

Proposal A

3.75 years

Proposal B

3.375 years

Explanation:

Proposal A

Payback = 3.75 years

Year     Cash Inflow      Initial Investment Balance   Year Count

0                   0                         1,050,000                        

1                   $280,000           770,000                            1

2                  $280,000           490,000                           2

3                  $280,000           210,000                            3

4                  $280,000           0                                    *3.75

* 1050,0000 / 280,000 = 3.75 years

Proposal B

Payback = 3.375 years

Year     Cash Inflow      Initial Investment Balance   Year Count

0                   0                         1,050,000                        

1                   $350,000           700,000                            1

2                  $3150,000          385,000                           2

3                  $280,000           105,000                            3

4                  $280,000           0                                    *3.375

* ( 3 + ( 105,000 / 280,000 ) ) = 3.75 years