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,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 of return of 16 percent
Solutions
Expert Solution
NPV = 
Rt / ( 1 +
i)t , t varies from 1 to n
where
Rt = Cash flow netted (Inflow - Outflow) during the period "t"
i = Discount rate
t = number of periods
Hence, we can use the above formula to construct following table:
| Case A | ||||||||
| Discount Rate (r) | 9% | |||||||
| years | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
| Cash-Outflows | 40,00,000 | |||||||
| Cash-Inflows | 10,00,000 | 10,00,000 | 10,00,000 | 10,00,000 | 10,00,000 | 10,00,000 | 10,00,000 | |
| Net Cashflows (Inflow - Outflow) | -40,00,000 | 10,00,000 | 10,00,000 | 10,00,000 | 10,00,000 | 10,00,000 | 10,00,000 | 10,00,000 |
|
Discounted Cashflow = Net CF / (1+r)^years |
-40,00,000 | 9,17,431 | 8,41,680 | 7,72,183 | 7,08,425 | 6,49,931 | 5,96,267 | 5,47,034 |
| NPV = sum of all discounted CF | 10,32,953 |
| Case B | ||||||||
| Discount Rate (r) | 11% | |||||||
| years | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
| Cash-Outflows | 40,00,000 | |||||||
| Cash-Inflows | 10,00,000 | 10,00,000 | 10,00,000 | 10,00,000 | 10,00,000 | 10,00,000 | 10,00,000 | |
| Net Cashflows (Inflow - Outflow) | -40,00,000 | 10,00,000 | 10,00,000 | 10,00,000 | 10,00,000 | 10,00,000 | 10,00,000 | 10,00,000 |
|
Discounted Cashflow = Net CF / (1+r)^years |
-40,00,000 | 9,00,901 | 8,11,622 | 7,31,191 | 6,58,731 | 5,93,451 | 5,34,641 | 4,81,658 |
| NPV = sum of all discounted CF | 7,12,196 |
| Case C |
| Discount Rate (r) | 15% | |||||||
| years | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
| Cash-Outflows | 40,00,000 | |||||||
| Cash-Inflows | 10,00,000 | 10,00,000 | 10,00,000 | 10,00,000 | 10,00,000 | 10,00,000 | 10,00,000 | |
| Net Cashflows (Inflow - Outflow) | -40,00,000 | 10,00,000 | 10,00,000 | 10,00,000 | 10,00,000 | 10,00,000 | 10,00,000 | 10,00,000 |
|
Discounted Cashflow = Net CF / (1+r)^years |
-40,00,000 | 8,69,565 | 7,56,144 | 6,57,516 | 5,71,753 | 4,97,177 | 4,32,328 | 3,75,937 |
| NPV = sum of all discounted CF | 1,60,420 |
| Case D | ||||||||
| Discount Rate (r) | 16% | |||||||
| years | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
| Cash-Outflows | 40,00,000 | |||||||
| Cash-Inflows | 10,00,000 | 10,00,000 | 10,00,000 | 10,00,000 | 10,00,000 | 10,00,000 | 10,00,000 | |
| Net Cashflows (Inflow - Outflow) | -40,00,000 | 10,00,000 | 10,00,000 | 10,00,000 | 10,00,000 | 10,00,000 | 10,00,000 | 10,00,000 |
|
Discounted Cashflow = Net CF / (1+r)^years |
-40,00,000 | 8,62,069 | 7,43,163 | 6,40,658 | 5,52,291 | 4,76,113 | 4,10,442 | 3,53,830 |
| NPV = sum of all discounted CF | 38,565 |
jeff jeffy answered 4 months agoRelated 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 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...
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...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- 1. Show the steps in merging A and B into C where A= 8, 12, 19,...
- 1. Given the following information, determine the beta coefficient for Stock L that is consistent with...
- Generate the first ten rows of Pascal triangle using MATLAB. Post code in the response
- Describe “downsizing” and explain the use of “ombudspersons” and “alternative dispute” resolution. Give some incidents and...
- You are the chairman of the board of directors for an innovative technology company, and you...
- Describe how common law has influenced the development of health care in the 21st century. Provide...
- 1. For each of the following lists, perform a bubble sort, and show the list after...
ADVERTISEMENT