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

Expert Solution

Use NPV function in EXCEL to find the NPV

=NPV(rate,Year1 to Year6 cashflows)-Year0 cashflow

a. =NPV(9%,Year1 to Year6 cashflows)-5000000=-$65489.6

b. =NPV(11%,Year1 to Year6 cashflows)-5000000=-$346408.4

c. =NPV(13%,Year1 to Year6 cashflows)-5000000=-$602695.2

d.=NPV(18%,Year1 to Year6 cashflows)-5000000=-$1152637.2

		Cashflows
	Year0	-5000000
	Year1	1100000
	Year2	1100000
	Year3	1100000
	Year4	1100000
	Year5	1100000
	Year6	1100000
9%	NPV	-65489.6
11%	NPV	-346408.4
13%	NPV	-602695.2
18%	NPV	-1152637.2

jeff jeffy answered 3 years ago

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..

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...

A) A company is considering building a new factory to produce aluminum baseball bats. this project...

A) A company 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 $900,000 per year for seven years. calculate the projects NPVE using a discount rate of 8%. B) The same company is considering to expand. The expidenture requires $9,500,000 on new service equipment I would generate annual net cash inflows from reduced costs of operations that equal 4 million...

(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 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...

(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...

(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,000,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...

(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 8 percent b. A required rate of return of 10 percent c. A required rate of return of 14 percent d. A required rate...

ABC Company is considering the possibility of building an additional factory that would produce a new...

ABC Company is considering the possibility of building an additional factory that would produce a new addition to their product line. The company is currently considering two options. The first is a small facility that it could build at a cost of $6 million. If demand for new products is low, the company expects to receive $10 million in discounted revenues (present value of future revenues) with the small facility. On the other hand, if demand is high, it expects...

Question

Gubanich Sportswear is considering building a new factory to produce aluminum baseball bats. This project would...

Solutions

Expert Solution

Related Solutions

Gubanich Sportswear is considering building a new factory to produce aluminum baseball bats. This project would...

1) Dowling Sportswear is considering building a new factory to produce aluminum baseball bats. This project...

A) A company is considering building a new factory to produce aluminum baseball bats. this project...

(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...

(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...

(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...

ABC Company is considering the possibility of building an additional factory that would produce a new...