Question

The company has been growing steadily over the past 5 years, and the financials and future...

The company has been growing steadily over the past 5 years, and the financials and future prospects look good. Your CEO has asked you to run the numbers. After doing some digging into the business, you have gathered information on the following:

  • The estimated purchase price for the equipment required to move the operation in-house would be $750,000. Additional net working capital to support production (in the form of cash used in Inventory, AR net of AP) would be needed in the amount of $35,000 per year starting in year 0 and through all years of the project to support production as raw materials will be required in year o and all years to run the new equipment and produce components to replace those purchased from the vendor..

  • The current spending on this component (i.e. annual spend pool) is $1,200,000. The estimated cash flow savings of bringing the process in-house is 20% or annual savings of $240,000. This includes the additional labor and overhead costs required.

  • Finally, the equipment required is anticipated to have a somewhat short useful life, as a new wave of technology is on the horizon. Therefore, it is anticipated that the equipment will be sold after the end of the project (the last year of generated cash flow) for $50,000. (i.e. the terminal value).

As part of your research, you have sought input from a number of stakeholders. Each has raised important points to consider in your analysis and recommendation. Some of the points and assumptions are purely financial. Others touch on additional concerns and opportunities.

Question:

Eva from Engineering believes we use a higher Discount Rate because of the risk of this type of project. As such, she is recommending a 5-year project life and flat annual savings. Eva suggests that even though the equipment is brand new, the updated production process could have a negative impact on other parts of the overall manufacturing costs. She argues that, while it is difficult to quantify the potential negative impacts, to account for the risk, a 12% discount rate should be used. Being an engineer, Eva feels that the stated terminal value is low based on her experience, and is recommending a $75,000 terminal value,

Using the data presented above (and ignoring the extraneous information), for this profit and supply chain improvement project, calculate each of the following (where applicable):

  • Nominal Payback

  • Discounted Payback

  • Net Present Value

  • Internal Rate of Return

Homework Answers

Answer #1
Year 0 1 2 3 4 5
1.Purchase price of the Eqpt. -750000
2.NWC reqd.& recovered -35000 35000
3.Salvage value of the Eqpt. 75000
4.Annual savings 240000 240000 240000 240000 240000
5. Total FCFs(sum 1 to 4) -785000 240000 240000 240000 240000 350000
6. PV F at 12%(1/1.12^yr.n) 1 0.89286 0.79719 0.71178 0.63552 0.56743
7.PV at 12%(5*6) -785000 214285.71 191326.53 170827.26 152524.34 198599.40
8.NPV(sum of row 7) 142563.24 (Ans.iii)
9.IRR(of FCF row 5) 18.72% (Ans.iv)
10.Nominal payback period(NPBP)
Cumulative nominal FCFs -785000 -545000 -305000 -65000 175000 525000
NPBP=
3+(65000/240000)= 3.27 Years (Ans.i)
11. Discounted Payback period(DPBP)
Cumulative disounted FCFs -785000 -570714.29 -379387.76 -208560.50 -56036.16 142563.24
DPBP=
4+(56063.16/198599.40)= 4.28 Years (Ans.ii)
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Based on the following: The estimated purchase price for the equipment required to move the operation...
Based on the following: The estimated purchase price for the equipment required to move the operation in-house would be $500,000. Additional net working capital to support production (in the form of cash used in Inventory, AR net of AP) would be needed in the amount of $25,000 per year starting in year 0 and through all 5 years of the project to support production. The current spending on this component (i.e. annual spend pool) is $875,000. The estimated cash flow...
The estimated purchase price for the equipment required to move the operation in-house would be $750,000....
The estimated purchase price for the equipment required to move the operation in-house would be $750,000. Additional net working capital to support production (in the form of cash used in Inventory, AR net of AP) would be needed in the amount of $35,000 per year starting in year 0 and through all years of the project to support production as raw materials will be required in year o and all years to run the new equipment and produce components to...
Case Analysis 2: The CEO of Dynamic Manufacturing was at a conference and talked to a...
Case Analysis 2: The CEO of Dynamic Manufacturing was at a conference and talked to a supplier about a new piece of equipment for its production process that she believes will produce ongoing cost savings. As the Operations Manager, your CEO has asked for your perspective on whether or not to purchase the machinery. After talking to the supplier and meeting with your Engineers and Financial Analysts, you’ve gathered the following pieces of data: • Cost of Machine: $140,000 •...
Q) Your corporation is considering replacing older equipment.  The old machine is fully depreciated and cost  $53,633.00  seven years...
Q) Your corporation is considering replacing older equipment.  The old machine is fully depreciated and cost  $53,633.00  seven years ago.  The old equipment currently has no market value. The new equipment cost $55,937.00 .  The new equipment will be depreciated to zero using straight-line depreciation for the four-year life of the project. At the end of the project the equipment is expected to have a salvage value of $14,087.00 .  The new equipment is expected to save the firm $15,718.00  annually by increasing efficiency and cost savings.  The...
A proposed investment has a project life of four years. The necessary equipment will cost of...
A proposed investment has a project life of four years. The necessary equipment will cost of $1,200, and have a useful life of 4 years. The cost will be depreciated straight-line to a zero salvage value, but will have a market worth $500 at the end of the project’s life. Cash sales will be $2,190 per year for four years and cash costs will run $670 per year. Fixed cost is $176 per year. The firm will also need to...
Read Book Company is the manufacturer of exercise machines and is considering producing a new line...
Read Book Company is the manufacturer of exercise machines and is considering producing a new line of equipment in an effort to increase its market share.   The new production line will cost $850,000 for manufacturing the parts and an additional $280,000 is needed for installation. The equipment falls into the MACRS 3-yr class, and would be sold after four years for $350,000. The equipment line will generate additional annual revenues of $600,000, and will have additional annual operating expenses of...
You are considering launching a new product, and you believe you can sell 5000 these per...
You are considering launching a new product, and you believe you can sell 5000 these per year for 5 years after which time this product line will shut down. The product would sell for $100 each, with variable costs of $60 for each one produced, and annual fixed costs associated with production would be $100,000. In addition, there would be a $250000 initial expenditure associated with the purchase of new production equipment. It is assumed this initial expenditure will be...
In-Class Illustration #1 Norman, general manager of the XYZ subsidiary of Innovation Inc., is considering the...
In-Class Illustration #1 Norman, general manager of the XYZ subsidiary of Innovation Inc., is considering the purchase of new industrial equipment to improve efficiency at its Cordoba plant. The equipment has an estimated useful life of five years. The estimated cash flows for the equipment are shown in the table that follows, with no anticipated change in working capital. Innovation has a 12% required rate of return. Assume amortization is calculated on a straight line basis. Assume all cash flows...
Focus Drilling Supplies has been growing steadily over the last 20 years. With increased exploration in...
Focus Drilling Supplies has been growing steadily over the last 20 years. With increased exploration in the mining sector, the company has decided to expand their facilities for supplies and custom drill bit production to meet the increased demand. The expansion will occur over 4 years and is expected to require $2.8 million. Management has developed a payment plan for carrying out this expansion. The plan requires a cash input of $300,000 now, $700,000 one year from now, $800,000 two...
The Gabriel Co. is considering a 7-year project that would require a cash outlay of $140,000...
The Gabriel Co. is considering a 7-year project that would require a cash outlay of $140,000 for machinery and an additional $30,000 for working capital that would be released at the end of the project. The equipment would be depreciated evenly over the 7 years and have a salvage value of $ 7,000 at the end of 7 years. The project would generate before tax annual cash inflows of $41,500. The tax rate is 20% and the company's discount rate...