Question

In: Finance

Exercise 3.21 DISCOUNTED PAYBACK Your company is considering a high-risk project that could yield strong revenues...

Exercise 3.21 DISCOUNTED PAYBACK

Your company is considering a high-risk project that could yield strong revenues but will involve a significant up-front investment. Because of this risk, top management is naturally concerned about how long it is likely to take to pay off that investment so that they can begin to realize profits. This project will require an investment of $200,000 and your five-year projection for inflows is: Year 1 – $50,000, Year 2 – $75,000, Year 3 – $125,000, Year 4 – $200,000, and Year 5 – $250,000. Your firm’s required rate of return is 18%. How long will it take to pay back your initial investment?

(Show all work)

Solutions

Expert Solution

Discounted Payback Period for the Project

- The Payback Period Method refers to the period in which the proposed project will generate the cash inflows to recover the Initial Investment costs. It considers only three components such as Initial Investment costs, Economic life of the project and the annual cash inflows

- Payback period is the number of years taken to recover the total amount of money invested in the project. If the payback period is less than the enterprises required number of years, then the project should be accepted, Else it is rejected

Year

Cash Flows ($)

Present Value Factor at 18%

Discounted Cash Flow ($)

Cumulative net discounted Cash flow ($)

0

-2,00,000

1.000000

-2,00,000

-2,00,000

1

50,000

0.847458

42,373

-1,57,627

2

75,000

0.718184

53,864

-1,03,763

3

1,25,000

0.608631

76,079

-27,684

4

2,00,000

0.515789

1,03,158

75,473

5

2,50,000

0.437109

1,09,277

1,84,751

Discounted Payback Period = Years before full recover + (Unrecovered cash inflow at start of the year/cash flow during the year)

= 3.00 Years + ($27,684 / $103,158)

= 3.00 Years + 0.27 Years

= 3.27 Years

“Hence, it will take 3.27 Years to pay back the initial investment”

NOTE    

The Formula for calculating the Present Value Factor is [1/(1 + r)n], Where “r” is the Discount/Interest Rate and “n” is the number of years.


Related Solutions

Your company is considering investing in a new project and wants to know the discounted payback...
Your company is considering investing in a new project and wants to know the discounted payback period. The initial investment in the project is​ $12,000 and the expected annual profit is​ $2,800 per year. You also expect to have to have to overhaul the equipment every 4​ years, which will cost​ $600 (that​ is, in years​ 4, 8,​ 12, etc. The project will also make the​ $2,800 profit in those​ years). Given an interest rate of​ 8%, what is the...
​(Discounted payback period​) You are considering a project with the following cash​ flows: YEAR   PROJECT CASH...
​(Discounted payback period​) You are considering a project with the following cash​ flows: YEAR   PROJECT CASH FLOW 0   -40,000 1   15,000 2   15,000 3   15,000 4   15,000 If the appropriate discount rate is 12 ​percent, what is the​ project's discounted payback​ period? The​ project's discounted payback period is ___ years.  ​(Round to two decimal​ places.)
​(Discounted payback period​) ​ Gio's Restaurants is considering a project with the following expected cash​ flows:...
​(Discounted payback period​) ​ Gio's Restaurants is considering a project with the following expected cash​ flows: Year Project Cash Flow​ (millions) 0 ​$(240​) 1 100 2 75 3 100 4 110 If the​ project's appropriate discount rate is 11 ​percent, what is the​ project's discounted payback​ period? The​ project's discounted payback period is nothing years.  ​(Round to two decimal​ places.)
(Discounted payback period​) ​ Gio's Restaurants is considering a project with the following expected cash​ flows:...
(Discounted payback period​) ​ Gio's Restaurants is considering a project with the following expected cash​ flows: Year Project Cash Flow​ (millions) 0 ​$(150​) 1 90 2 70 3 90 4 100 If the​ project's appropriate discount rate is 12 ​percent, what is the​ project's discounted payback​ period? The​ project's discounted payback period is nothing years.  ​(Round to two decimal​ places.)
Problem 13-8 Discounted Payback (LG13-2) Compute the discounted payback statistic for Project D if the appropriate...
Problem 13-8 Discounted Payback (LG13-2) Compute the discounted payback statistic for Project D if the appropriate cost of capital is 11 percent and the maximum allowable discounted payback is four years. (Do not round intermediate calculations and round your final answer to 2 decimal places. If the project does not pay back, then enter a "0" (zero).) Project D Time: 0 1 2 3 4 5 Cash flow: –$12,800 $3,530 $4,540 $1,880 $0 $1,360 Problem 13-8 Discounted Payback (LG13-2) Compute...
(Discounted payback period​)​ Gio's Restaurants is considering a project with the following expected free cash​ flows:...
(Discounted payback period​)​ Gio's Restaurants is considering a project with the following expected free cash​ flows: LOADING... . If the​ project's appropriate discount rate is 9 ​percent, what is the​ project's discounted payback​ period? The​ project's discounted payback period is nothing years.YEAR PROJECT CASH FLOW 0 -150 1 85 2 80 3 80 4 100
​(Discounted payback period​)​ Gio's Restaurants is considering a project with the following expected cash​ flows:  0...
​(Discounted payback period​)​ Gio's Restaurants is considering a project with the following expected cash​ flows:  0 - 210 million    1        95 million    2        75 million    3        95 million    4      90 million If the​ project's appropriate discount rate is 11 ​percent, what is the​ project's discounted payback​ period? The​ project's discounted payback period is _____years.
Calculate the Payback Period and Discounted Payback Period for the following project: 1. An initial investment...
Calculate the Payback Period and Discounted Payback Period for the following project: 1. An initial investment of $20,000 with expected after-tax operating cash flows of $125,000 per year for each of the next 3 years. However, in preparation for its termination at the end of year 3, an additional investment of $350,000 must be made at the end of Year 2. Please show all work in excel.
1. Given the following set of cash flows for a project, calculate the Payback, Discounted Payback...
1. Given the following set of cash flows for a project, calculate the Payback, Discounted Payback and Accounting Rate of Return. Assume a cost of capital of 10%. Assuming that this is an independent project, should the project be accepted? Why or why not? Year                Cash Flow                 Net Profit                   Depreciation 0                    -$125,000 1                    $22,000                     $15,000                      $10,000 2                    $58,000                     $43,000                      $25,000 3                    -$30,000                   $24,000                      $21,000 4                    $35,000                     $28,000                      $18,000 5                    $28,000                     $20,000                      $15,000 6                    $60,000                      $52,000                      $11,000 And now Construct an...
Using the company, or industry, that your team project is focused on, how could strong team...
Using the company, or industry, that your team project is focused on, how could strong team cohesion at the firm both enhance and hinder performance. Also, does your chosen firm have any particular ethical considerations or worries that may impact teams? Lastly, can you provide an example of a team you were on that excelled, or a team you participated on that was a failure? Why so?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT