Cost-Benefit Analysis ===================== What is the current value of a future sum? The answer to this question helps to decide whether an investment is worth the sacrifice. Present Value of a Future Sum ----------------------------- We need to make an investment decision. We assume that any investment * requires sacrificing current resources, and * has an expected return. Then the question is: *Is the investment worth it?* The main tool to make investment decisions in a cost benefit analysis is a :index:`reverse interest` calculation. To introduce the present value of a future sum, consider the following two problems. 1. In ten years we will inherit :math:`\$100,000`. Assuming :math:`5\%` rate with continuous compounding, how much can we borrow today? 2. The lottery (or an insurance settlement) offers 1. either to pay half of the prize :math:`p` now, that is :math:`p/2`; or 2. installments of :math:`p/25` for 25 years. What should the interest rate be to break even? To solve these two problems, we need to answer the following. 1. What is the present value of :math:`\$100,000` in ten years? 2. What is the present value of receiving 25 yearly installments? Let us do an example of a reverse interest calculation: *What is the present value of* :math:`\$3,000` *in five years, assuming an annual interest rate of* :math:`8\%?` .. math:: \begin{array}{rcl} \$2,042(1.08) & = & \$2,205 \\ \$2,205(1.08) & = & \$2,381 \\ \$2,381(1.08) & = & \$2,572 \\ \$2,572(1.08) & = & \$2,778 \\ \$2,778(1.08) & = & \$3,000 \end{array} We can interpret the middle number in the above sequence in two ways: .. math:: \$2,572 = \underbrace{\$2,042(1+0.08)^3}_{ \begin{array}{c} \mbox{value of investment} \\ \mbox{after 3 years} \\ \end{array}} = \underbrace{\$3,000(1+0.08)^{-2}}_{ \begin{array}{c} \mbox{value of investment} \\ \mbox{2 years before} \\ \end{array}} The anser to the reverse interest question is then :math:`\$3,000 (1 + 0.08)^{-5} = \$2,042`, rounded to nearest :math:`\$`. Let us return to the first problem, on borrowing against an inheritance: *In ten years we will inherit* :math:`\$100,000`. *Assuming* :math:`5\%` *rate with continuous compounding, how much can we borrow today?* We start with some notations: * :math:`t = 10` is the number of years in the future. * :math:`P = 100000` is value of the inheritance. * :math:`r = 0.05` is the interest rate. * :math:`L` is the amount of the loan. With continuous interest compounding at rate :math:`r`, the loan amount :math:`L` equals :math:`P` after :math:`t` years: .. math:: L e^{r t} = P \quad \mbox{or} \quad L = P e^{-r t}. :math:`L = \$100,000 e^{-0.5} = \$60,653.07` is the highest amount of the loan. After these examples, we are ready to formulate the present value of future money. .. topic:: Definition of Present Value of Future Money. The formula for the *present value* :math:`P_0` of some future money :math:`P`, paid :math:`N` years in the future is .. math:: P_0 = P e^{-r N}, where the interest rate :math:`r` is called the *discount rate*. We apply this formula to considering payout options. The lottery (or an insurance settlement) offers 1. either to pay half of the prize :math:`p` now, that is :math:`p/2`; or 2. installments of :math:`p/25` for 25 years. What should the interest rate be to break even? What is the present value of the 25 installments? Let :math:`r` be the interest rate, using continuous compounding: .. math:: \underbrace{~~~~\frac{p}{25}~~~~}_{\mbox{1st installment}} + \underbrace{\frac{p}{25} e^{-r}}_{\mbox{in 1 year}} + \underbrace{\frac{p}{25} e^{-2r}}_{\mbox{in 2 years}} + \cdots + \underbrace{\frac{p}{25} e^{-24r}}_{\mbox{in 24 years}}. We will arrive at a nonlinear equation. The sum of the 25 installments equals: .. math:: \frac{p}{25} \left( 1 + e^{-r} + e^{-2r} + \cdots + e^{-24r} \right) = \frac{p}{25} \left( \frac{1 - e^{-25 r}}{1 - e^{-r}} \right). The alternative option is to receive a lump sum of :math:`p/2`. The break even point is defined by .. math:: \frac{p}{25} \left( \frac{1 - e^{-25 r}}{1 - e^{-r}} \right) = \frac{p}{2} which simplifies into .. math:: 1 - e^{-25 r} = 12.5 \left( 1 - e^{-r} \right) so the break even point does not depend on the prize :math:`p`. Returning to the original question. The lottery (or an insurance settlement) offers 1. either to pay half of the prize :math:`p` now, that is :math:`p/2`; or 2. installments of :math:`p/25` for 25 years. What should the interest rate be to break even? Solving the nonlinear equation with ``NLsolve`` package in Julia leads to the break even rate of :math:`6.74\%`. Naturally, the higher the interest rate, the smaller the present value of the future money. The Julia package ``NLsolve`` provides a nonlinear solver, its use to compute the break even rate is shown below: :: using NLsolve """ function f!(F, x) defines F[1] as the input to nlsolve. """ function f!(F, x) r = x[1] F[1] = 1 - exp(-25*r) - 12.5*(1 - exp(-r)) end sol = nlsolve(f!, [0.05]) Printing ``sol`` shows the following: :: Results of Nonlinear Solver Algorithm * Algorithm: Trust-region with dogleg and autoscaling * Starting Point: [0.05] * Zero: [0.0673745373743581] * Inf-norm of residuals: 0.000000 * Iterations: 4 * Convergence: true * |x - x'| < 0.0e+00: false * |f(x)| < 1.0e-08: true * Function Calls (f): 5 * Jacobian Calls (df/dx): 5 We verify with the evaluation of ``sol.zero[1]`` using ``f(r) = 1 - exp(-25*r) - 12.5*(1 - exp(-r))``. Life Cycle Savings ------------------ We apply the present value of future money to justify equipment purchases. Consider the purchase of newer, more efficient equipment. * The purchase requires a present sum of money, a cost. * The purchase represents a saving, or a benefit. The cost occurs now, the benefit later. Compute the justification for the purchase of the new equipment. The approach to justify equipment purchases is called *discounted cash flow analysis.* 1. For each year of the projected life of the equipment, compute :math:`+` the projected savings, :math:`-` less costs for that year. This gives the yearly *net cash flow*. 2. Discount the yearly net cash flow back to the present value. 3. Compute the *life cycle saving*: :math:`+` all net cash flow present values over the lifetime, :math:`-` less the first costs. The important notions in a :index:`discounted cash flow analysis` are :index:`first costs`, :index:`return on investment`, and :index:`payback period` formally defined below. .. topic:: Definition of first costs, return on investment, payback period. * The *first costs* are the costs for the new equipment. * The *return on investment* is the discount rate that yields zero life cycle savings. * The *payback period* is the time before the accumulating present value of the net savings surpasses the initial investment. We decide to invest in better equipment, which costs :math:`q`. The investment will save us :math:`p` over :math:`n` years. We compute the present value of :math:`p` at discount rate :math:`r`: .. math:: p \left( \frac{ 1 - e^{-r~\!n}}{1 - e^{-r}} \right) against the cost :math:`q` of the investment. .. topic:: Definition of the discount rate. The *discount rate* :math:`r = d - i`, consists of * :math:`d` is the interest rate of a safe investment, * :math:`i` is the inflation rate. The definitions will be illustrated by a numerical example. We consider the purchase of new equipment: 1. The life span of the equipment is 12 years. 2. Each year, the new equipment will save :math:`\$1052`. 3. We use a discount rate :math:`r = d - i = 0.02`. How much may the equipment cost to justify the purchase? To answer this question, we use a dataframe, shown in :numref:`figDiscountedCashFlow` assuming the equipment costs :math:`\$10,000`. .. _figDiscountedCashFlow: .. figure:: ./figDiscountedCashFlow.png :align: center A dataframe to compute a discounted cash flow. From :numref:`figDiscountedCashFlow` we see that in the eleventh year, we have recovered the cost of the investment, under the assumption that its purchase costed :math:`\$10,000`. Proposals of Project Topics --------------------------- 1. Is a doctoral degree financially worthwhile? Is four years of study beyond the master's to obtain a doctoral degree financially worthwhile? Consider the following questions: * Does the added income throughout the career pay back 1. the cost of the education, and 2. the loss of income during the four years of study? * Is there is a difference between academia and industry? 2. Use public transport or your own car? For the daily commute, compare the cost of using public transport versus using your own car. * In your study consider the normal life span of a car. * The cost of public transport includes a fixed fare, subject to annual fare hikes. * The cost of a car includes not only the purchase price, but also taxes, insurance, fuel, repairs, and depreciation cost. Consider the following questions: * What is the total saving of using public transport? * Explain how the annual increase in saving could be used to justify an annual fare hike, that is then also fair... Exercises --------- 1. Consider again the payout example of the lottery. Assuming the installment increases by :math:`3\%` each year, at which rate does the break even point then occur? 2. Consider the payout plan of the lottery from the state's perspective. What is the purchase price of :math:`q` of an annuity that 1. pays out :math:`p/25` for 25 years to the winner, 2. the remaining balance on the annuity grows at rate :math:`r` annually. 3. Consider the numerical example on the discounted cash flow analysis, 1. assuming :math:`\$7,000` as the purchase cost, and 2. inflation rate at :math:`i = 3\%`. What is the return on investment for this problem? 4. Consider again the numerical example on the discounted cash flow analysis, assuming the cost of the equipment is borrowed 1. with a :math:`15\%` down payment, 2. at an interest rate of :math:`5\%`, compounded continuously, 3. with a loan over 12 years. Under these conditions of the loan, how much may the equipment cost to justify the purchase? Bibliography ------------ 1. Charles R. MacCluer, Chapter 7 of *Industrial Mathematics. Modeling in Industry, Science, and Government*, Prentice Hall, 2000. 2. Peter Eichhorn and Ian Towers: *Principles of Management: Efficiency and Effectiveness in the Private and Public Sector*. Springer, 2018.