Question

In: Finance

​(NPV with varying required rates of return​) Gubanich Sportswear is considering building a new factory to...

​(NPV with varying required rates of return​) Gubanich Sportswear is considering building a new factory to produce aluminum baseball bats. This project would require an initial cash outlay of 4,000,000 and would generate annual free cash inflows of 1,200,000 per year for 7 years. Calculate the​ project's NPV ​given:

a. A required rate of return of 9 percent

b. A required rate of return of 11 percent

c. A required rate of return of 15 percent

d. A required rate of return of 17 percent

Solutions

Expert Solution

Net Present value (NPV) is the present value of future cash inflows minus the initial investment

Here, since the cash flows are equal every year, so it is an annuity. We have to find present value of the annuity of $1200000 after 7 years. We will use the present value of annuity table to find the required NPV.

(a) At rate of 9%

Present value of future cash flows = $1200000 * PVA (9%, 7 Years)

where, PVA (9%, 7 years) is the present value of $1 annuity at 9% for 7 years. ( since the annual payments are of equal amount of $1200000, so it will be an annuity and we will use the present value of annuity table).

From the table the value of PVA (9%, 7 Years) is 5.0330

Putting this value in the above equation, we get,

Present value of future cash flows = $1200000 * 5.0330 = $6039600

Initial investment (given) = $4000000

Net Present value (NPV) = Present value of future cash inflows - initial investment

Net Present value (NPV) = $6039600 - $4000000 = $2039600

(b) At rate of 11%

Present value of future cash flows = $1200000 * PVA (11%, 7 Years)

where, PVA (11%, 7 years) is the present value of $1 annuity at 11% for 7 years. ( since the annual payments are of equal amount of $1200000, so it will be an annuity and we will use the present value of annuity table).

From the table the value of PVA (11%, 7 Years) is 4.7122

Putting this value in the above equation, we get,

Present value of future cash flows = $1200000 * 4.7122 = $5654640

Initial investment (given) = $4000000

Net Present value (NPV) = Present value of future cash inflows - initial investment

Net Present value (NPV) = $5654640 - $4000000 = $1654640

(c) At rate of 15%

Present value of future cash flows = $1200000 * PVA (15%, 7 Years)

where, PVA (15%, 7 years) is the present value of $1 annuity at 15% for 7 years. ( since the annual payments are of equal amount of $1200000, so it will be an annuity and we will use the present value of annuity table).

From the table the value of PVA (15%, 7 Years) is 4.1604

Putting this value in the above equation, we get,

Present value of future cash flows = $1200000 * 4.1604 = $4992480

Initial investment (given) = $4000000

Net Present value (NPV) = Present value of future cash inflows - initial investment

Net Present value (NPV) = $4992480 - $4000000 = $992480

(d) At rate of 17%

Present value of future cash flows = $1200000 * PVA (17%, 7 Years)

where, PVA (17%, 7 years) is the present value of $1 annuity at 17% for 7 years. ( since the annual payments are of equal amount of $1200000, so it will be an annuity and we will use the present value of annuity table).

From the table the value of PVA (17%, 7 Years) is 3.92

Putting this value in the above equation, we get,

Present value of future cash flows = $1200000 * 3.92 = $4704000

Initial investment (given) = $4000000

Net Present value (NPV) = Present value of future cash inflows - initial investment

Net Present value (NPV) = $4704000 - $4000000 = $704000


Related Solutions

(NPV with varying required rates of return) Gubanich Sportswear is considering building a new factory to...
(NPV with varying required rates of return) Gubanich Sportswear is considering building a new factory to produce aluminum baseball bats. This project would require an initial cash outlay of $4,000,000 and would generate annual free cash inflows of $1,100,000 per year for 8 years. Calculate the project's NPV given: a. A required rate of return of 9 percent b. A required rate of return of 11 percent c. A required rate of return of 15 percent d. A required rate...
​(NPV with varying required rates of return​) Gubanich Sportswear is considering building a new factory to...
​(NPV with varying required rates of return​) Gubanich Sportswear is considering building a new factory to produce aluminum baseball bats. This project would require an initial cash outlay of ​$6,000,000 and would generate annual free cash inflows of ​$1,000,000 per year for 6 years. Calculate the​ project's NPV ​given: a. A required rate of return of 9 percent _____ b. A required rate of return of 11 percent ____ c. A required rate of return of 14 percent ______ d....
​(NPV with varying required rates of return​) Gubanich Sportswear is considering building a new factory to...
​(NPV with varying required rates of return​) Gubanich Sportswear is considering building a new factory to produce aluminum baseball bats. This project would require an initial cash outlay of ​$4,000,000 and would generate annual free cash inflows of ​$1,200,000 per year for 8 years. Calculate the​ project's NPV ​given: a. A required rate of return of 8 percent b. A required rate of return of 11 percent c. A required rate of return of 15 percent d. A required rate...
Gubanich Sportswear is considering building a new factory to produce aluminum baseball bats. This project would...
Gubanich Sportswear is considering building a new factory to produce aluminum baseball bats. This project would require an initial cash outlay of ​$5,000,000 and would generate annual free cash inflows of ​$1,100,000 per year for 6 years. Calculate the​ project's NPV ​given: a. A required rate of return of 9 percent b. A required rate of return of 11 percent c. A required rate of return of 13 percent d. A required rate of return of 18 percent
Gubanich Sportswear is considering building a new factory to produce aluminum baseball bats. This project would...
Gubanich Sportswear is considering building a new factory to produce aluminum baseball bats. This project would require an initial cash outlay of ​$5,000,000 and would generate annual free cash inflows of ​$1,100,000 per year for 7 years. Calculate the​ project's NPV ​given needs 7% needs 8% needs 13% needs 10% percentages need to be calculated with problem..
​(NPV with varying required rates of return​) Big​ Steve's, a maker of swizzle​ sticks, is considering...
​(NPV with varying required rates of return​) Big​ Steve's, a maker of swizzle​ sticks, is considering the purchase of a new plastic stamping machine. This investment requires an initial outlay of ​$130,000 and will generate free cash inflows of $ 18,000 per year for 12 years. a. If the required rate of return is 7 ​percent, what is the​ project's NPV​? b. If the required rate of return is 20 ​percent, what is the​ project's NPV​? c. Would the project...
​(NPV with varying required rates of return​) Big​ Steve's, a maker of swizzle​ sticks, is considering...
​(NPV with varying required rates of return​) Big​ Steve's, a maker of swizzle​ sticks, is considering the purchase of a new plastic stamping machine. This investment requires an initial outlay of ​$150,000 and will generate free cash inflows of $ 18,500 per year for 13 years. a. If the required rate of return is 5 ​percent, what is the​ project's NPV​? b. If the required rate of return is 16 ​percent, what is the​ project's NPV​? c. Would the project...
(NPV with varying required rates of return​) Big​ Steve's, a maker of swizzle​ sticks, is considering...
(NPV with varying required rates of return​) Big​ Steve's, a maker of swizzle​ sticks, is considering the purchase of a new plastic stamping machine. This investment requires an initial outlay of ​$100,000 and will generate free cash inflows of $18,000 per year for 15 years. a. If the required rate of return is 5 ​percent, what is the​ project's NPV​? b. If the required rate of return is 20 percent, what is the​ project's NPV​? c. Would the project be...
1) Dowling Sportswear is considering building a new factory to produce aluminum baseball bats. This project...
1) Dowling Sportswear is considering building a new factory to produce aluminum baseball bats. This project would require an initial cash outlay of 5,500,000 and would generate annual net cash inflows of $1,200,000 per year for 6 years. Calculate the project's NPV using a discount rate of 8 percent. If the discount rate is 8 percent, then the project's NPV is?   2 Big Steve's, makers of swizzle sticks, is considering the purchase of a new plastic stamping machine. This investment...
NPV for varying capital cost rates. (using excel) Your small medical practice is evaluating a new...
NPV for varying capital cost rates. (using excel) Your small medical practice is evaluating a new diagnostic testing machine. The purchase requires an initial investment of $25,000 and will generate cash inflows of $5,000 per year for eight years. For each of the required rates of return listed (1) calculate the net present value, (2) indicate whether to accept or reject the machine, and (3) briefly explain your decisions. The cost of capital is 10%. The cost of capital is...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT