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)  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
If these two projects are mutually exclusive, which project should the company accept based on the NPV, IRR, MIRR, payback, and discounted payback period for each project?
Considering the following projects.ProjectYear01234ACash flows-$100$35$35$35$35BCash flows-$100$60$50$40$30Project A has WACC = 6.00% while project B has WACC = 8.50%.If these two projects are mutually exclusive, which project should the company accept based on the NPV, IRR, MIRR, payback, and discounted payback period for each project?Would your decision (Your answer from part A) change if these two projects were independent?
Discounted Cash Flow Analysis (Model) Excel Case: Your employer is considering a capital project that involves...
Discounted Cash Flow Analysis (Model) Excel Case: Your employer is considering a capital project that involves installing a new manufacturing facility(to manufacture a new product) at a cost of $30,800,000. The facility will be built on land that was purchased in 2018 for $1,250,000. If the facility is not built on this land, the land will remain unused. The new manufacturing facility, if built, will be depreciated on a straight-line basis over five years, to a salvage value of $2,000,000....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT