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.)
(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.
(Discounted payback period) Gio's Restaurants is considering a project with the following expected cash​ flows (see...
(Discounted payback period) Gio's Restaurants is considering a project with the following expected cash​ flows (see below). If the​ project's appropriate discount rate is 12 percent, what is the​ project's discounted payback​ period? Year Project Cash Flow 0 $(150) Million 1 $95 Million 2 $65 Million 3 $95 Million 4 $110 Million The​ project's discounted payback period is ____years. ​(Round to two decimal​ places.)
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?
​(Discounted payback​ period)  The Callaway Cattle Company is considering the construction of a new feed handling...
​(Discounted payback​ period)  The Callaway Cattle Company is considering the construction of a new feed handling system for its feed lot in​ Abilene, Kansas. The new system will provide annual labor savings and reduced waste totaling $190,000 while the initial investment is only ​$510,000. ​ Callaway's management has used a simple payback method for evaluating new investments in the past but plans to calculate the discounted payback to analyze the investment. Where the appropriate discount rate for this type of...
The table below lists the projects that your company is considering to invest: Project   Payback Period...
The table below lists the projects that your company is considering to invest: Project   Payback Period (Years)   NPV (USD)   IRR (%) A   4.7   53000   15.44 B   2.1   17000   17.76 C   4.7   18000   16.75 D   4.4   14000   17.05 E   2.8   14000   17.15 The required return is 14.6 percent. Which project should be accepted if they are mutually exclusive?        E        D        C        B        A
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT