Question

In: Finance

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

The cost of capital is 14%.

Solutions

Expert Solution

If the cost of capital is 10%.

Net Present Value [NPV]

Net Present Value [NPV] = Present Value of cash inflows – Initial Investments

= $5,000 [PVIFA 10%, 8 Years] - 25,000

= [ $5,000 x 5.334926] -25,000

= $ 26,674.63 - 25,000

= $1,674.63 [ Positive NPV ]

Accept / Reject Decision

The Project Should be accepted, Since the Net Present Value [NPV] is Positive $1,674.63

If the cost of capital is 12%.

Net Present Value [NPV]

Net Present Value [NPV] = Present Value of cash inflows – Initial Investments

= $5,000 [PVIFA 12%, 8 Years] - 25,000

= [ $5,000 x 4.9676397] -25,000

= $24,838.20 - 25,000

= ($161.80) [ Negative NPV ]

Accept / Reject Decision

The Project Should not be accepted, Project Should be Rejected, Since the Net Present Value [ NPV] is Negative ($161.80)

If the cost of capital is 14%.

Net Present Value [NPV]

Net Present Value [NPV] = Present Value of cash inflows – Initial Investments

= $5,000 [PVIFA 14%, 8 Years] - 25,000

= [ $5,000 x 4.63886] -25,000

= $23,194.32 - 25,000

= ($1,805.68) [ Negative NPV ]

Accept / Reject Decision

The Project Should not be accepted, Project Should be Rejected, Since the Net Present Value [ NPV] is Negative ($1,805.68)


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 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​) 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...
Show work in excel and explain why used the rates you did. Cost of capital 11.0%...
Show work in excel and explain why used the rates you did. Cost of capital 11.0% Cost of borrowing 11.0% Return for typical investments 13.0% Calculate the project’s MIRR?
You are evaluating a small project for your company. The idea is to introduce a new,...
You are evaluating a small project for your company. The idea is to introduce a new, but short lived, new product. Sales over the 6 year useful life of the project will be 100,000 units, 120,000 units, 110,000 units, 100,000 units, 70,000 units and 70,000 in each of the 6 years. The price will fluctuate each year, with the pattern being $16, $18, $17, $14, $14 and $14. The cash operating expenses will be, on a per unit basis, $7,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT