-
- News
- Books
Featured Books
- pcb007 Magazine
Latest Issues
Current IssueThe Growing Industry
In this issue of PCB007 Magazine, we talk with leading economic experts, advocacy specialists in Washington, D.C., and PCB company leadership to get a well-rounded picture of what’s happening in the industry today. Don’t miss it.
The Sustainability Issue
Sustainability is one of the most widely used terms in business today, especially for electronics and manufacturing but what does it mean to you? We explore the environmental, business, and economic impacts.
The Fabricator’s Guide to IPC APEX EXPO
This issue previews many of the important events taking place at this year's show and highlights some changes and opportunities. So, buckle up. We are counting down to IPC APEX EXPO 2024.
- Articles
- Columns
Search Console
- Links
- Events
||| MENU - pcb007 Magazine
Happy’s Essential Skills: Engineering Economics (ROI)
August 10, 2016 | Happy HoldenEstimated reading time: 6 minutes
Engineering economics is fundamental in engineering, especially for manufacturing support. For simplicity, I am using the term here as a process engineer for printed circuit equipment and automation of production. Principles of Engineering Economy[1], written by Stanford University Professor Dr. Grant Ireson, is the text that I used and one of the basics for understanding engineering economics.
Interest Variables
Here are the five primary variables that make up all of the interest formulas for the time value of money:
I = interest rate per period
n = number of interest periods
PV = present sum of money
FV = future sum of money after n periods at i interest
PMT = end of period payment
All of these calculations lend themselves for use in spreadsheets and are found as part of MS Excel.
Interest Formulas
The interest formulas for these calculations are defined and seen below. For some reason, each of these formulas have been given a specific name and abbreviation. Single amounts do not have an apostrophe after the three-letter-acronym (tla). A series of amounts have the apostrophe (‘). The short-cut way of writing this out is to use this form:
(tla-interest rate-period) seen as: (caf’-6%-10)
- Single Payment-Compound Amount Factor (caf’) for future value (FV) based on the present value (PV):
FV=PV(1+i)^n (caf')
- Single Payment-Present Worth Factor (pwf’) for present value (PV) based on the FV
PV=FV[1/(1+i)^n] (pwf')
- Series Sinking fund factor (sff) for series payment (PMT) based on the FV
PMT=FV[i/(1+i)^n-1] (sff)
- Series Compound Recovery Factor (crf) for series payment (PMT) based on the PV
PMT=PV[i(1+i)^n/(1+i)^n-1] (crf)
or PMT=PV[i/{(1+i)^n-1}+i]
- Series Compound Amount Factor (caf) for future value based on the payments
FV=PMT[(1+i)^n-1/i] (caf)
- Series Present Worth Factor (pwf) for PV based on the series of payments
PV=PMT[(1+i)^n-1/i(1+i)^n] (pwf)
Or PV=PMT[1/{i/(1+i)^n-1}+i]
Examples using Three Variables
You can see how all of these financial formulas are related by looking at the examples in Figure 1. We start with just three variables: present value (PV) = $1000; period of 10 years (N); and annual interest rate of 6%.
1. We start with $1000 (PV) and want to know what it is worth after 10 years with an interest rate of 6% per year. The caf’ equation is used: (caf’-6%-10). The future value (FV) is $1791.
2. What if we want to know what the FV would be if we withdraw it six years early? The pwf’ is used: (pwf’-6%-6) and the PV is $1263.
3. What PV would it take seven years earlier to get this $1263? Again, pwf’ is used: (pwf’-6%-7) and a PV of $840 would be required.
4. If we took the $840 and invested it over 10 years what payments would we receive at 6% interest? The crf is used (crf-6%-10) to get a payment (PMT) of $114/period.
5. If instead we made payments of $114 per period for 10 years, what would that be worth now? The caf equation is used (caf-6%-10) and the future value (FV) is $1504.
6. What annual payment is required to get $1504 over seven years? The sff equation is used (sff-6%-7) and PMT would be $179/ year.
7. What present value would $179 in interest income at 6% give us over seven years? The pwf is used (pwf-6%-7) and the V is $1000, the same as we started with.
Figure 1: Seven financial calculations all involving $1000 at 6% interest over various years.
Important Engineering Metrics
- ROI (return on investment) is the equivalent bank interest rate of all the money you spent and all the profits you made over a fixed time span
- NPV (net present value) is the current value of all the cash flows over time assuming cash is worth, x %, say 3 % as an interest rate.
- BET is the breakeven time (or the time to money) before the profits you gain pay for all that you spent to get the profits. Or, how long before you truly make a PROFIT?
- TVM is the time value of money. Because of inflation, future money is worth less than current money, or it is discounted.
- DEPRECIATION is the value of equipment that the government lets you deduct each year as equipment gets older. This encourages you to buy new equipment. Some may be depreciated very fast, perhaps in three years instead of five.
The common practice in equipment justification is to calculate the ROI or the NPV of the cash flows associated with implementing the equipment, including all purchases of equipment, installation, taxes (depreciation), water treatment savings and operating costs against the labor saving, and yield improvement by NOT installing automation.
The rate of return is easiest calculated by Excel. To do it manually requires a trial-and-error calculation of assuming an interest rate (I) over the period of the investment (n) and calculating the compound recovery factors (crf) for each year. When the sum of all the crfs equals the initial investment, then the interest rate is the ROI.
The NPV is easier to calculate. It is the present worth factor (pwf) for all the cash flows each year for the life of the investment using current or future interest rates.
The classical trade-off is between the purchase of an automated system (and its advantages) and the continued increase in direct labor. But quality, process yields and waste water treatment costs also enter into the calculation. Return on investment is the calculation of the equivalent interest rate of all the moneys invested based on all the cash flows over the useful life of the equipment.
Page 1 of 3
Suggested Items
DuPont Showcases AI Innovations Featuring Advanced Interconnects at 2024 International Electronic Circuits Exhibition
05/13/2024 | DuPontDuPont announced it will showcase its comprehensive range of advanced circuit materials and solutions at the 2024 International Electronic Circuits Exhibition in Shanghai. With a product portfolio that includes fine line, signal integrity, power and thermal management, DuPont will exhibit at Booth #8L06 at the National Exhibition and Convention Center (NECC) from May 13 to 15.
MKS’ Atotech to Participate in ECTC
05/10/2024 | MKS’ AtotechAt this year’s 74th IEEE Electronic Components and Technology Conference (ECTC), MKS’ Atotech will present and demonstrate its latest product and service innovations.
The Chemical Connection: Reducing Etch System Water Usage, Part 2
05/02/2024 | Don Ball -- Column: The Chemical ConnectionIn my last column, I reviewed some relatively simple ways to reduce water usage in existing etch systems: cutting down cooling coil water flow, adding chillers to replace plant water for cooling, lowering flow rate nozzles for rinses, etc. This month, I’ll continue with more ways to control water usage in your etcher. Most of these are not easily retrofittable to existing equipment but should be given serious consideration when new equipment is contemplated. With the right combination of add-ons, it is possible to bring the amount of water used in an etch system to almost zero.
Designer’s Notebook: What Designers Need to Know About Manufacturing, Part 2
04/24/2024 | Vern Solberg -- Column: Designer's NotebookThe printed circuit board (PCB) is the primary base element for providing the interconnect platform for mounting and electrically joining electronic components. When assessing PCB design complexity, first consider the component area and board area ratio. If the surface area for the component interface is restricted, it may justify adopting multilayer or multilayer sequential buildup (SBU) PCB fabrication to enable a more efficient sub-surface circuit interconnect.
Insulectro’s 'Storekeepers' Extend Their Welcome to Technology Village at IPC APEX EXPO
04/03/2024 | InsulectroInsulectro, the largest distributor of materials for use in the manufacture of PCBs and printed electronics, welcomes attendees to its TECHNOLOGY VILLAGE during this year’s IPC APEX EXPO at the Anaheim Convention Center, April 9-11, 2024.