Question

In: Finance

YMCMB Inc. is evaluating an equipment that costs $60,000. The expected benefits per year are expected...

YMCMB Inc. is evaluating an equipment that costs $60,000. The expected benefits per year are expected to be $19,500 while costs are expected to be $9,500. This equipment should have a useful life of 10 years and the company’s WACC is 7%. Calculate the firm’s NPV and IRR. Should YMCMB buy this equipment? (Hint: find the cash flows first, then calculate the firm’s NPV).

Solutions

Expert Solution

Use IRR function in Excel

IRR = 10.558%

NPV = 10,235.82

(see table below)

Discount rate 7.0000%
Cash flows Year Discounted CF= cash flows/(1+rate)^year Cumulative cash flow
             (60,000.000) 0                           (60,000.00)                       (60,000.00)
               10,000.000 1                               9,345.79                       (50,654.21)
               10,000.000 2                               8,734.39                     (41,919.818)
               10,000.000 3                               8,162.98                     (33,756.840)
               10,000.000 4                               7,628.95                     (26,127.887)
               10,000.000 5                               7,129.86                       (18,998.03)
               10,000.000 6                               6,663.42                     (12,334.603)
               10,000.000 7                               6,227.50                          (6,107.11)
               10,000.000 8                               5,820.09                             (287.01)
               10,000.000 9                               5,439.34                            5,152.32
               10,000.000 10                               5,083.49                          10,235.82

Related Solutions

Project L costs $60,000, its expected cash inflows are $8,000 per year for 8 years, and...
Project L costs $60,000, its expected cash inflows are $8,000 per year for 8 years, and its WACC is 13%. What is the project's MIRR? Round your answer to two decimal places. Do not round your intermediate calculations.
Payback period A) Project L costs $60,000, its expected cash inflows are $13,000 per year for...
Payback period A) Project L costs $60,000, its expected cash inflows are $13,000 per year for 12 years, and its WACC is 9%. What is the project's payback? Round your answer to two decimal places. B) A project has annual cash flows of $6,000 for the next 10 years and then $9,500 each year for the following 10 years. The IRR of this 20-year project is 13.03%. If the firm's WACC is 8%, what is the project's NPV? Round your...
1. Project L costs $60,000, its expected cash inflows are $13,000 per year for 11 years,...
1. Project L costs $60,000, its expected cash inflows are $13,000 per year for 11 years, and its WACC is 14%. What is the project's NPV? 2. Project L costs $46,352.00, its expected cash inflows are $11,000 per year for 8 years, and its WACC is 13%. What is the project's IRR? 3. Project L costs $75,000, its expected cash inflows are $14,000 per year for 8 years, and its WACC is 14%. What is the project's MIRR? 4. Project...
Heels, a shoe manufacturer, is evaluating the costs and benefits of new equipment that would custom...
Heels, a shoe manufacturer, is evaluating the costs and benefits of new equipment that would custom fit each pair of athletic shoes. The customer would have his or her foot scanned by digital computer equipment; this information would be used to cut the raw materials to provide the customer a perfect fit. The new equipment costs $111,000 and is expected to generate an additional $44,000 in cash flows for 5 years. A bank will make a $111,000 loan to the...
Heels, a shoe manufacturer, is evaluating the costs and benefits of new equipment that would custom...
Heels, a shoe manufacturer, is evaluating the costs and benefits of new equipment that would custom fit each pair of athletic shoes. The customer would have his or her foot scanned by digital computer equipment; this information would be used to cut the raw materials to provide the customer a perfect fit. The new equipment costs $109,000 and is expected to generate an additional $42,000 in cash flows for 5 years. A bank will make a $109,000 loan to the...
Project P costs $15,000 and is expected to produce benefits (cash flows) of $4,500 per year...
Project P costs $15,000 and is expected to produce benefits (cash flows) of $4,500 per year for five years. Project Q costs $37,500 and is expected to produce cash flows of $11,100 per year for five years. Calculate each project’s (a) net present value (NPV), (b) internal rate of return (IRR), and (c) modified internal rate of return (MIRR). The firm’s required rate of return is 14 percent. If the projects are independent, which project (s) should be selected? If...
Project P costs $15,000 and is expected to produce benefits (cash flows) of $4,500 per year...
Project P costs $15,000 and is expected to produce benefits (cash flows) of $4,500 per year for five years. Project Q costs $37,500 and is expected to produce cash flows of $11,100 per year for five years. Calculate each project’s (a) net present value (NPV), (b) internal rate of return (IRR), and (c) mod- ified internal rate of return (MIRR). The firm’s required rate of return is 14 percent.  Compute the (a) NPV, (b) IRR, (c) MIRR, and (d) discounted payback...
Sonoco Inc is evaluating a 4-year project that requires $118,000 of new equipment. This equipment will...
Sonoco Inc is evaluating a 4-year project that requires $118,000 of new equipment. This equipment will be depreciated straight-line to a zero-book value over the life of the project. This project is expected to generate operating cash flows of $39,000 per year for four years. At the beginning of the project, inventory will be lowered by $9,000, accounts receivable will increase by $14,000, and accounts payable will increase by $11,000. At the end of the project, net working capital will...
Cutter Enterprises purchased equipment for $60,000 on January 1, 2018. The equipment is expected to have...
Cutter Enterprises purchased equipment for $60,000 on January 1, 2018. The equipment is expected to have a five-year life and a residual value of $3,600. Using the sum-of-the-years'-digits method, depreciation for 2018 and book value at December 31, 2018, would be: (Do not round depreciation rate per year)
Cutter Enterprises purchased equipment for $60,000 on January 1, 2021. The equipment is expected to have...
Cutter Enterprises purchased equipment for $60,000 on January 1, 2021. The equipment is expected to have a five-year life and a residual value of $5,400. Using the double-declining-balance method, the book value at December 31, 2022, would be:
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT