600 649 PDF
600 649 PDF
Printed by: 6f37bd28e236046@placeholder.17650.edu. Printing is for personal, private use only. No part of this book
              may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted.
      APPENDIX A
      INTRODUCTION TO SPREADSHEET1S
      Computerized spreadsheets are available nearly everywhere, and they can be easily applied to economic analysis. In fact,
      spreadsheets were originally developed to analyze financial data, an d they are often credited with initiating the explosive
      growth in demand for desktop computing.
         A spreadsheet is a two-dimensional table, whose cells can contain numerical values, labels, or formulas . The software
      automatically updates the table when an entry is changed, and there are powerful tools for copying formulas, creating
      graphs, and formatting results.
1 of 52                                                                                                                     1/25/2020, 11:37 AM
Engineering Economic Analysis - Pages 600 - 649                               https://print.vitalsource.com/print/9780190931940?brand=Yuzu&from=...
     Printed by: 6f37bd28e236046@placeholder.17650.edu. Printing is for personal, private use only. No part of this book
              may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted.
           3. Good habits, like using data blocks, are easy to maintain once they are established.
           4. It makes the assumptions clear if you've estimated a value or for grading.
          In the real world, data blocks are even more impmtant. Most problems are solved more than once, as more and more
      accurate values are estimated. Often the spreadsheet is revised to add other vmiables, time periods, locations, etc. Without
      data blocks, it is hard to change a spreadsheet and the likeHhood of missing a required change skyrockets.
          If you want your formulas to be easier to read, you can name your va1iables. Note : In Excel, the cell's location or name
      is displayed at the left of the fotmula bar. Variable names can be entered here. They will then automatical1y be applied if
      cell addresses are entered by the point and click method. If cell addresses are entered as A2, then A2 is what is displayed.
      To change a displayed A2 to the name of the cell (LoanAmount), the process is to dick on Insert, dick on ame, click on
      Apply, and then select the names to be applied.
      COPY COMMAND
      The copy command and relative/absolute addressing make spreadsheet models easy to build. If the range of ceUs to be
      copied contains only labels., numbers, and functions, then the copy command is easy to use and understand. For example,
      the formuJa =EXP(l.9) would be copied unchanged to a new location. However, ceH addresses are usually part of the
      range being copied, and their absolute and relative addresses are treated differently.
         An absolute address is denoted by adding$ signs before the column and/or row. For example In Figure A-la, $A$4 is
      the absolute address for the interest rate. When an absolute address is copied, the column and/or mw that is fixed is
      copied unchanged. Thus $A$4 is completely fixed, $A4 fixes the column, and A$4 fixes the row. One common use for
      absolute addresses is any data block entry, such as the interest rate. When entering or editing a fmmula, changing between
      A4, $A$4, A$4, $A4, and A4 is most easily done using the F4 key, which scrolls an address through the choices.
         In contrast, a relative address is best interpreted as directions from one cell to another. For example in Figure A- l a, the
      balance due in year t equals the balance due in year t - 1 minus the principal payment in Year t. Specifically for the
      balance due in Year 1, D10 contains =D9-ClO. Fro m cell D lO, cell D9 is one row up and ClO is one column to the left.
      so the fmmula Is really (contents of 1 up) minus (contents of 1 to the left). When a cell containing a relative address is
      copied to a new location, it is these directions that are copied to detetmine any new relative addresses . So if cell D10 is
      copied to cell Fl4, the formula is =F13-E14.
         Thus to calculate a loan repayment schedule, as in Figure A- 1, th e row of formulas js created and then copied for the
      remaining years.
          EXAMPLE A- 1
          Four repayment schedules for a loan of $5000 to be repaid over 5 years at an interest rate of 8% were shown in Table
          3- 1. Use a spreadsheet to calculate the amortization schedule for the constant principal payment option.
          SOLUTION
          The first step is to enter the loan amount, number of periods, and interest rate into a data block in the top left pan of the
          spreadsheet. The next step is to calculate the constant plincipal payment amount, which was given as $1252.28 in
          Table 3-1. The factor approach to finding this value is given in Chapter 3 and the spreadsheet function is exp1ained in
          Chapter 4.
             The next step is to identify the columns for the amortization schedule. These are the year, interest owed, principal
          payment, and balance due. Because some of these labels are wider than a normal column, the cells are fmmatted so that
          the text wraps (row height increases automatically). The initial balance is shown in the Year-o, row.
             Next, the formulas for the first year are written, as shown in Figure A- la. The interest owed (cell BlO) equals the
          interest rate ($A.$4) times the balance due for Year 0 (D9). The principal payment (celJ ClO) equals the annual payment
          ($A.$6) minus the interest owed and paid (BlO). Finally, the balance due (cell D10) equals the balance due for the
          previous year (D9) minus the principal payment (ClO). The results are shown in Figure A- la.
             Now cells Al0 to D lO are selected for Year 1. By dragging down on the right comer of D10, the entire row can be
          copied for Years 2 through S. ·ote that If you use cut and paste, then you must complete the year column separately
          (dragging increments the year, but cutting and pasting does not). The results are shown in Figure A- lb.
2 of 52                                                                                                                         1/25/2020, 11:37 AM
Engineering Economic Analysis - Pages 600 - 649                            https://print.vitalsource.com/print/9780190931940?brand=Yuzu&from=...
     Printed by: 6f37bd28e236046@placeholder.17650.edu. Printing is for personal, private use only. No part of this book
              may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted.
                            A                B                C           D              E
                 1    Entered Data.
                 2              5000   Loan Amount
                 3                 5   Number of Payments
                 4                8%   Interest Rate
                 5    Computed Data
                 6         1.252.28    Loan Payment
                 7
                                         Interest       Principa.l     Balance
                 8         Year           Owed          Payrnent        Due
                 9          0                                          5000:00
                 10         1            400.00          852.28        4147.72      =D9-C10
                 11                     /                     ~
                 12                    ~$A$4*D9                      '"=$A$6- B10
(a
                            A                B                C           D              E
                                         Interest       Principal      Balance
                 8         Year           Owed          Payment         Due
                 9          0                                           5000.00
                 10         1            400.00          852.28        4147.72
                 11         2            331.82          920.46         3227.25
                 12         3            258.18          994.10         2233.15
                 13         4            178.65         1073 .63        1159.52
                 14         5               92. 76      1159.52            0.00     =D13- C14
                 15                     /                     ~
                 16                    ~$A$4*D13                     =$A$6-B1 4
                                                       ( b)
             FIGURE A-1     (a) Year 1 amortization schedule. (b) Completed a:mo1tization schedule.
          This appendix has introduced the basics of spreadsheets. Chapter 2 uses spreadsheets and simple bar charts to draw
      cash flow diagrams. Chapters 4 to 15 each have spreadsheet sections. These are designed to develop spreadsheet
      modeling skills and to reinforce your understanding of engineering economy. As spreadsheet packages are built around
      using the computer mouse to click on cells and items In chaits, there is usually an intuitive connection between what you
      would like to do and how to do it. The best way to learn how to use the spreadsheet package is to simply play around with
      it. In additi on, as you look at the menu chokes , you will find new commands that you hadn ' t thought of but will find
      useful.
3 of 52                                                                                                                    1/25/2020, 11:37 AM
Engineering Economic Analysis - Pages 600 - 649                                https://print.vitalsource.com/print/9780190931940?brand=Yuzu&from=...
     Printed by: 6f37bd28e236046@placeholder.17650.edu. Printing is for personal, private use only. No part of this book
              may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted.
      APPENDIXB
      TIME VALUE OF MONEY
      CALCULATIONS USING SPREADSHEETS
      AND CALCULATORS                                                1
      Spreadsheets and financial calculators are perfect tools for solving economic problems with financial functions that are
      very similar to the engineering economy factors-but more powerful. ow there are even smatt phone apps with the same
      capabilities. Some types of programmable calculators can be used in the FE exam, making interest tables unnecessary.
         This appendix focuses on the use of spreadsheets and cakulators to solve simple time value of money problems.
      Inducled are the fo1lowing topics:
          •   Basics of a 5-Button Spreadsheet Calculator
          •   Spreadsheets, Calculators, and the FE Exam
          •   Additional Spreadsheet and Calculator Capabdities
          •   More Complex Examples
          •   Possible Errors and Their Solutions
                       t
                       P=?
                                                              i
                                                          P = 5000
                                                                         l   A ="(3000   t
                                                                                                                 t
                                                                                                                     A= ?
                                                                                                                          +     t
              B-  P = 1000                                                       B-5
              i=?
                       t
                       0- - 1- -2- -3- -4- -5
                                                         F = JOO
                                                              •
                                                                                 i = 6.25%      A = 450
                                                                                                +
                                                                                         r - - 1- -2 ...
                                                                                                           +_j
                                                                                                                 ,i = ?
                             t         t
                                         A = 250
                                                 +   t        +
                                                                                     P = 2000
          For example B-1, the input variables from the cash flow diagram are placed in cells B2 through F2, with the interest
      rate in cell B2, the number of petiods in cell C2, etc. Cell H2 calculates the PV using the appropriate cell addresses for the
      input variables. The equations used in column Hare shown in column I. Spreadsheets such as Excel and Google docs use
      this type of format; others such as Open Office and Quattro Pro use a slightly different fonnat for equivalent functions.
      Any of the spreadsheet functions may be copied to a new row and then new data can be inserted to solve similar
      problems . Thus, the five annuity functions in Figure B-1 are coJlectively a 5-button financial ca]culator. The same inputs
      may be keyed into a financial or programmable calculator to obtain identica] resu]ts. When using a calculator, it is
      important to enter all variables if you do not know what value was entered last.. You could have an unknown va]ue
      residing in the calculator's memory. Additional examples of using the 5-button spreadsheet calculator can be found in
      Chapters 3 and 4.
4 of 52                                                                                                                             1/25/2020, 11:37 AM
Engineering Economic Analysis - Pages 600 - 649                                https://print.vitalsource.com/print/9780190931940?brand=Yuzu&from=...
     Printed by: 6f37bd28e236046@placeholder.17650.edu. Printing is for personal, private use only. No part of this book
              may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted.
          EXAMPLE B1-B5
          5-BUITON SOLUTION
                                B          C         D
                                t          N       PIT
                              s.,          2        0
                              7.0%         3      -3000
                                           3
FIGURE B-1 Cash flow diagrams and the 5-burton spreadsheet calcularor.
5 of 52                                                                                                                        1/25/2020, 11:37 AM
Engineering Economic Analysis - Pages 600 - 649                            https://print.vitalsource.com/print/9780190931940?brand=Yuzu&from=...
     Printed by: 6f37bd28e236046@placeholder.17650.edu. Printing is for personal, private use only. No part of this book
              may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted.
          The PER function will disp lay the answer in fractional periods; in this case, 5.37 peliods. Using factors to solve for
          the number of periods again requires the use of interpofation or iterative solutions .
          B-5   0 = -2000 + 450(P/A, 6.25%., n)
                (PIA. 6.25%, n) = 2000/450 = 4.444
          This will require interpolation to find two variables, one interpolation to find a set of values for n at 6.25% (because
          there is no 6.25% table available), and another for determining the answer. These will not be performed here, but yield
          an answer of 5.37 periods.
         There are many advantages to using spreadsheets and financial calculators instead of, or in addition to, using the
      interest tables . These include:
           •    Time is saved because problems are entered directly without having to look up factors in tables, then copying those
                factors. Problems are solved with the use of a few key strokes.
           •    There is less chance for error because there are fewer steps. Many errors are made in looking up factors due to
                looking down the wrong column or row. Transcribing errors, or finding a factor but writing it down wrong, are
                minimized.
           •    There is no need to interpoJate when detennining an interest rate or number of pe1iods. This greatly speeds this
                type of calculation.
           •    Students who use a spreadsheet will leave an elecu-onic, srudent accessible paper trail. Once a spreadsheet is
                successfully built, such as the one in Figure B-1, students can access these saved files for studying, performing
                homework. and perhaps during a test. This can aid in students' learning and comprehension by focusing time and
                attention on setting up problems rather than spending time doing financial arithmetic.
                                                     1 + o-nl                                                                 (B-1)
                                      PMT    11 -     i,         + FV(l + i)-     11   +PV   =0
                                              A(P/ A i,n)   + F(P/ F     i,n)   +P =0                                         (B-2)
         Financial calculators use Equation B-3 to solve for the unknown vaiiable . Note that Equation B-3 is written so that i is
      entered as a percentage, so 8 is entered for 8%, which is how the interest rate is entered for financial calculators. How the
      interest rate is entered is the single difference between how spreadsheets and calculators solve time value of money
      problems .
                                      1 (1 i/ 100)-nl
                                 PMT [ - i;lOO                  I+ +FV(l        i/ ]00)-n + PV    =0
                                                                                                                              (B-3)
          Since the factors are all positive, one of PMT, FV, or PV (or A, F, and P) must be different in sign from the other two.
      If tv.ro positive cash flows are entered to solve for the third cash flow, then that third value must be negative to solve the
      equation. These equations are the foundation for the sign conventfon that is used in financial calculators and the
      spreadsheet annuity functions PV, FY, PMT, RATE, and ' PER.
         There are three classes of calculators that are of interest. First, there are many financial or business calculators that
      have buttons labeled i, N, PMT, PV, and FV or equivalents. The button for the uniform series cash flow, A, is labeled
      PMT, because one of the most important uses of these calculators is for calculating loan payments (PM'I). Examples
      include the Texas Instrument BAH Plus and BAH Pius Professional, the Sharp EL-738C, and the Hewlett Packard lObH.
      We no longer recommend the HP 12C for new purchases since when solving for n, the 12C rounds fractional values of n
      up to an integer value (see Example B-8). These calculators also typically have the capability to find the PY of complex
      cash flow patterns, but we suggest using spreadsheets for more complex patterns.
6 of 52                                                                                                                     1/25/2020, 11:37 AM
Engineering Economic Analysis - Pages 600 - 649                             https://print.vitalsource.com/print/9780190931940?brand=Yuzu&from=...
     Printed by: 6f37bd28e236046@placeholder.17650.edu. Printing is for personal, private use only. No part of this book
              may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted.
          Present value    p                      PV             PV
          Puture va]ue     F                      FV             FV
Uniform series A p T p T
         There are also graphing cakulators that have the time va]ue of money cakulations in a menu. There are menu entries
      for i, N, PMT, PV, and FVor equivalents. Example calculators include the Texas Instrument 83 and 84 Plus.
         Finally, there are programmable scientific calculators where Equation B-3 can be entered to create the menu that is
      built into the graphing caku]ators. For example, Chapter 17 of the manuals for the Hewlett Packard 33s and 35s details
      tMs. These chapters use a non-standard notation of B or balance for PY and P or payment for PMT. We suggest using
      standard notation and substituting P for Band A for P. 'ote that on the HP 35s this changes the checksum from 382E to
      8DD6. The HP 33s and HP 35s calculators are currently allowed for use on the Fundamentals of Engineering (FE) exam.
      while the financial and graphing calculators are not.
         There are too many variations of labeling and physical layout of the keys and too many financial calculators for a text
      to provide details. However, the website www.TVMCaks.mm provides good tutorials on financial calculators, and
      calculator manuals are available for download from the manufacturers.
         Some calculators are shipped from the factory with a setting of 12 months per year, so that n will be entered as years
      for loans with monthly payments. We recommend that this be changed to 1 payment per "year or period" and left on this
      setting. Then you know to enter n as the number of petiods or payments, and there is no confusion for prob]ems with
      different length periods.
         Phone apps are now widely available that perform as financia] cakulators, making it possible to cany the capability
      anywhere.
7 of 52                                                                                                                       1/25/2020, 11:37 AM
Engineering Economic Analysis - Pages 600 - 649                                                             https://print.vitalsource.com/print/9780190931940?brand=Yuzu&from=...
     Printed by: 6f37bd28e236046@placeholder.17650.edu. Printing is for personal, private use only. No part of this book
              may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted.
      The following examples demonstrate problems that are more complex, but still make use of the basic spreadsheet annuity
      functions .
            •       Example B-6 requires conversion of annual rates and periods to monthly.
            •       Example B- 7 is a PV problem including an initial payment and a salvage value.
            •       Example B-8 solves a discounted payback problem.
            •       Example B- 9 includes cash flows at the beginning of the period.
            •       Example B- 10 is an EAC problem with multiple cash flows.
            •       Example B- 11 involves the doubling, nipling, and quadrupling of money.
          EXAMPLEB-6
          Kris is buying a used car and needs to find the monthly payment. The loan is for $14,000, and the dealer is willing to
          offer financing for 5 years at 6.5% interest. What is the monthly payment?
          SOLUTION
          First, we need to convert the period and interest rate to months. There are 60 (= 5 x 12) monthly payments at a monthly
          interest rate of 6.5%/12 = 0.5417%. The required monthly payment is $273.93.
                    A        B            C D          E            p     G              H              I
                1 Problem i               n    PMT PV               FV Solve for Answer Ponnul.a
                2 B-6        0.5417% 60                -14000 0        p T       $273.93 =P T(B2,C2,E2,F2)
                3                                                                                       PMT(rate, 11pe1~ pv, [fv], [type])
             This problem can also be solved using a financial or programmable calculator. The keys on most calculators are the
          same as the spreadsheet variables, so Plv!T(i, n, P, F) = PMT(0.5417%, 60, - 14000, 0) = $273.93. ote that the
          calculator requires the same sign convention as spreadsheets.
          EXAMPLEB-7
          Automating a process will cost $8000 now, but it will save $2200 annually for 5 years. The machinery will have a
          salvage value of $1500. What is the present wm1h of the machinery if the interest rate is 10%?
SOLUTION
1500
                                                                            t t too t t
                                                                0- -1- -2- -3- -4- -5
                                                                j
                                                            8000
          Notice that the present value of the future cash flows is negative when the A and F values are entered as positive
          numbers. This comes from so]ving Equation B-1. Since in this case we want the positive PV of the returns to the
          project, we can change the sign of the answer in step 2, subtracting the $8000 initial cash flow to find the PV of $1271.
             Using a calculator, PV (i, n, A, F) = PV (10, 5, 2200, 1500) = -9271.11. The calculator finds the combined present
          worth of the $2200 annual savings and the salvage value of $1500. The initial cash flow of $8000 is subtracted to find
          the PV of $1271. 11. Like the spreadsheet, positive values for A and F produce a negative value for P.
          EXAMPLEB-8
          A firm might purchase a compute1ized quality contro] system. The proposed system wil1 cost $76,000, but is expected
          to save $22,000 each year in reduced ove1time. The firm requires that all cost reduction projects have a discounted
          payback of no more than 4 years with a 10% interest rate. Should the film invest in the new system?
SOLUTION
                 A      B       C D      E                F G          H
             1 Problem i        11   PMT PV               FV SoJve for Answer
            2 B-8       10.0%        22000 -76000 0              PER    4.45
          The time for the system to pay for itself can be found using the PER function; the discounted payback period is 4.45
          years. Because a proposed project can have a discounted payback of no more than 4 years, the project would not be
          approved.
             The problem can also be solved with a calculator using N(i, A, P, F) = N(10%, 22000, - 76000, 0) = 4.45 years.
          Note that th e HP 12C calculator wil1 report 5 years. ln fact, the HP 12C will repmt N = 5 years when the payback
          period .is as small as 4.005 periods.
          EXAMPLEB-9
          Some equipment is needed for a 4-year project. It can be leased for $15,000 annually, or it can be purchased for
          $60,000 at the beginning and sold for $35,000 at the end. What Is the rate of return for owning the equipment rather
          than ]easing it?
          SOLUTION
          Because the lease payments occur at the beginning of each period, [type] is set to any number above O (such as 1) to
          automatically shift the cash flows into beginning rather than end of petfod. This affects only the A and not the F.
                 A      B C D          E          p         G          H
             1 Problem i n PMT         PV         FV        Solve for Answer
            2 B-9           4 15000 -60000 35000 RATE                  23.49%
          A financial calculator must also be shifted into begin rather than end mode, then enter i(n, A, P, F) = i( 4, 15000,
          -60000, 35000) = 23.49%.
             Without knowledge that the rate is nearly 25%, using the tabulated factors would require multiple trial solutions to
          solve the following 3-factor equation.
9 of 52                                                                                                                              1/25/2020, 11:37 AM
Engineering Economic Analysis - Pages 600 - 649                               https://print.vitalsource.com/print/9780190931940?brand=Yuzu&from=...
     Printed by: 6f37bd28e236046@placeholder.17650.edu. Printing is for personal, private use only. No part of this book
              may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted.
       EXAMPLE B -10
       What is the EAC to keep a piece of new equipment operating? The warranty covers repair costs for the first 2 years,
       but expected repair costs are $1500 per year for the rest of the 7-year life. ormal maintenance is expected to cost
       $1800 annually. There is an overhaul costing $8500 at the end of year 4. The firm 's interest rate is 8% .
       SOLUTION
       Whether solved with tables, spreadsheets, or a financial calculator, the first step is to draw the cash flow diagram.
                                             0- -1- -2- -3- -4- -5- -6,____-7
                                                1800
                                                    }        } 1500   1
                                                                       8500
                                                                                    iii
       Let us first solve this with the tabulated factors.
               A           B    C D      E        p      G        H
           1 Problem       i    n PMT PV          FV     Solve for Answer
           2 Repair        8% 5 1500 0                   FV       -8799.9
           3               8% 7          0        -8799.9 I? T    986.,23
           4
           5 Overhaul 8% 4 0                      8500   PV       -6247.75
           6               8% 7          -6247.75 0      PMT      1200.02
           7
           8       aim.           1800                   EAC      $3,986.25
       This is very similar with a financial calculator. For the repair costs, FV(i, n, A, P) = FV (8, 5., 1500, 0) = -8, 799.90.
       Since the i and P values are unchanged, they do not need to be re-entered. The only entry needed is N = 7, since the F
       was just calculated. PMT(i, n, P, F) = PMT(8%, 7, 0, -8799.90) = $986 .23.
           For the overhaul costs the i value need not be re-entered, PV(i, n, A, F) = PV(8%, 4, 0, 8500) = -6, 247.75. Now N
       is changed w 7 and F to 0, then solving for PMT(i, n, P, F) = PMT(8%, 7, -6247.75, 0) = $1200.02.
           Maintenance is $1800 per year..
           Adding the three values is the same as before, and the EAC is $3986.25.
       EXAMPLE B -11
       How long does it take for your money to doub]e if you can eam 7% on your investment? Trip]e? Quadruple?
SOLUTION
10 of 52                                                                                                                       1/25/2020, 11:37 AM
Engineering Economic Analysis - Pages 600 - 649                               https://print.vitalsource.com/print/9780190931940?brand=Yuzu&from=...
     Printed by: 6f37bd28e236046@placeholder.17650.edu. Printing is for personal, private use only. No part of this book
              may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted.
               A        B     C D     E   F    G         H
           1 Problem i       n PMT PV     FV Solve for Answer
           2 B-11       7.0%   0   -1     2        PER   10.24
           3            7.0%   0   -1     3        PER   16.24
           4            7.0%   0   -1     4        PER   20.49
       Using a financial calculator, the setup is similar~ for doubling, 11(i, A, P, F) = n(7, 0, -1, 2) = 10.24.
         The problem can also be solved using functions, but requires interpolation, or can be solved mathematically.
                                               F = P(l +in
                                               2 = 1(1.0?t
                                          ln (2) = n In (1.07)
                                               n = n (2)/ In (1.07) = 0.6931 / 0.06766 =         10.24
       EXAMPLE B -12
       An account having $800,000 will be used to make a series of 20 annual payments of $150,000 each. What interest rate
       is needed to fund the payments?
       SOLUTION
       A simple rate problem can unexpectedly result in an error message, but are usually corrected by inse rting a [guess].
       Notice that the guess does not need to be very accurate.
                   A        B C D         E         F    G       H      I
               1 Problem i n    PMT       PV        FV Solve for Answer Formula
               2 B-12        20 150,000 -800,000 0       RATE    #   M ! =RATE(C2,D2,E2,F2)
               3             20 150,000 -800,000 0       RATE    18.10% =RATE(C3,D3,E3, F3,0,30%)
      NPER
      The function NPER is also iterative- like RATE and IRR. Unf0111.1nately, PER does not have a [guess] option to help .
      NPER sometimes returns an etTor if the value is very large. The answer can sometimes be found by using GOAL SEEK,
      as shown in Example B- 13.
       EXAMPLE B -13
       An account having $600,000 wiH be used to make a series of annual payments of $45,000 each. The account returns
       7.5% per vear. How manv years will oavments be made?
11 of 52                                                                                                                      1/25/2020, 11:37 AM
Engineering Economic Analysis - Pages 600 - 649                                           https://print.vitalsource.com/print/9780190931940?brand=Yuzu&from=...
     Printed by: 6f37bd28e236046@placeholder.17650.edu. Printing is for personal, private use only. No part of this book
              may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted.
       1.;:i,o per j'~dr. nuw IIIdUJ year.; wm !Jd)'meu~ ue           llldU~ r
       SOLUTION
       Using PER returns an error showing that U could not solve the problem. NPER is increasing very rapidly as the
       interest increases by a very small amount. This can be solved by finding a value of n where the PV or FV = 0. GOAL
       SEEK returns a value of 617 plus years. SOLVER can also be used to provide the same answer.
               A       B    C     D       E         F    G                H           I
           1 Problem i      n    PMT      PV        FV Solve fo r Answer Fonnul.a
           2 B-13      8%        45,000 -600,000 0           PER          #      M ! = PER(B2,D2,E2)
           3           8% 617.3 45,000 -600,000 0        fV               0.00%       =fV(B5,C5,D5,E5)
IGoal S@e:k ? X
s~ cell: H3
Toyalue : 0
By £Nnglng cell: CJ
                                                        L___!:             01(
                                                                                  J           Cancel
Wi■j•GU-Ri
      PROBLEMS
      Key to icons:   D = click to reveal answer; (9 = Green, which may include environmental ethics; G= Ethics other than
      green;   = autograded problems that are available online in Dashboard;                           =   The icon indicates that a spreadsheet is
      recommended.
      Present Worth
      B- A p rocess redes1gn wiIJ cost $70,000 now, but it wiIJ save $18,000 annua11y for 6 years . The new machinery will have a saJvage
      1 value of $12,500. What is the present worth o f the machinery, if the in terest rate is 12%?
B- oving to a new faciUty will save 400,000 annually for 20 yea.rs. The cost of building the facility and moving is $2.5 millfon
      •
      2. now. The facility wi11 have a salvage value of $100,000. What is the facili ty's PW, if the interest rate is 12%?
      B- A lottery pays the win ner $1 mjllion in 20 equal annual payments of $50,000. The firs t payment wiH be made at the end of the
      3 second year. What is the p resent worth if the win ner 's annual interest rate is 5.25%?
12 of 52                                                                                                                                   1/25/2020, 11:37 AM
Engineering Economic Analysis - Pages 600 - 649                                       https://print.vitalsource.com/print/9780190931940?brand=Yuzu&from=...
     Printed by: 6f37bd28e236046@placeholder.17650.edu. Printing is for personal, private use only. No part of this book
              may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted.
      B- A new road wiU cost $45 milli.on to build, and $2 mi.lHon annuaUy to maintain and operate over its 50-year li£e. The roadbed and
      6 right-of-way are estimated to have a salvage value of $15 million. If the state highway department uses an interest rate of 5%, what
      I  is the EUAC for the road?
      B- A new car will cost $24,000 to buy and $5500 annually to operate. If it is sold for $9300 after 6 years, what is the EUAC? Assume
      7    that the owner's interest rate is 3% for the time value of money.
      Price of a Bond
      B- A $1000 bond has 15 more years to maturity, an interest rate of 6%, and it pays interest semj-annually. If the current market
      B interest rate is 5%, what is the price of the bond?
      I
      B- A $1000 bond has 12 more years to maturity, an interest rate of 6%, and it pays interest semi-annually. If the current market
      9' interest rate is 8%, what is the price of the bond?
      B- An investor purchased a 10-yea.r, $20,000 corporate bond just over 12 months ago. The bond pays 6.5% interest, due semi-
      10 annually. The current market interest rate for simifar bonds has increased to 7.25%. What price wil.l this bond sell for today?
      I
      Loan Payment
      B-    What is the month]y payment for a 5-year car loan al a nominal interest rate of 8.5%? The 1.oan's initial balanC'e is $16,885.
      11
      B-    A couple is buying a house, but they need a mortgage for $150,000. A 15-year loan can be obtained for 3.25% annual interest.
      12    What is the monthJy payment?
      I
      Number of Periods
      B- A student owing $17,565 on a credit card has decided to use only a debit card jn the future. The nomina.l annual rate on the credit
      13 card is 13.8%. If the student makes monthly payments of $250, how long is it until the credit card is paid off?
      B- A homeowner may .install solar paneJs on the roof of .her house. The total installed cost is $15,000 after federal and state credits.
      14 This solar system will meet the monthly electricity need, which costs $120 per month. The homeowner's interest rate is 3%
      I  annually.
      (9    (a) If electricity prices remain constant, how long will it be until tlh.e system pays fo r itself?
            {b) If electricity prices increase in the future, how will this affect the installation paying for itself?
13 of 52                                                                                                                                1/25/2020, 11:37 AM
Engineering Economic Analysis - Pages 600 - 649                                                                                                                                                                                                https://print.vitalsource.com/print/9780190931940?brand=Yuzu&from=...
     Printed by: 6f37bd28e236046@placeholder.17650.edu. Printing is for personal, private use only. No part of this book
              may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted.
           . ,....., r, •   ..,_ ,.. ,.,_   .__.._,..,.._....,.}   , ., .., ..... . . . . .. ,   .._...., ._.....,.. r   ..,.t:J.'' -   , ....,,..'-"..._ ...,.._ ...,.,....,...'J,,...,OJOJ•   ,   r ... . _....,.., .,._.   .., •• ..._   • ._...,..._   ...,. ,._ • .._ ,.. ..........   ._. • .•   .._. ,..,....,   I."",.....,.,, .._..._.., ,,
      0
      B- A new road wm cost $45 million to build, and $2 million annuaUy to maintain and operate over its 50-year life. The roadbed and
      17 right-of-way are ,estimated to have a salvage va.lue of $15 million. If user benefits are ,estimated at $5.5 mi.Ilion annually, what is
         the rate of return on this road?
      B- Some equi pment is needed for a construction project. It can be leased for $150,000 annually, or it can be pu11chased for $900,000 at
      18 the beginning and sold for $225,.000 at the end of 3 years. What is the rate of return for owning the equipment rather than leasing
      o  it?
14 of 52                                                                                                                                                                                                                                                                                                                                               1/25/2020, 11:37 AM
Engineering Economic Analysis - Pages 600 - 649                 https://print.vitalsource.com/print/9780190931940?brand=Yuzu&from=...
     Printed by: 6f37bd28e236046@placeholder.17650.edu. Printing is for personal, private use only. No part of this book
              may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted.
      APPENDIXC
      COMPOUND INTEREST TABLES
      Values of Int.erest Factors When n Equals Infinity
      Single Paym ent:              Uniform Payment Series:
      (F/P, i,oo)   =oo             (AIF, i,oo) = 0
      (P/F, i,oo) = 0               (AIP, i,oo) = i
      Ari thmetic Gradient Series: {FIA, /,oo) = oo
      (NG, i, oo) = l/i             {PIA, i, oo)   = 1/i
      (PIG, i, oo) = 1//2
                -. -        .,                                                                       -. -    .,
15 of 52                                                                                                          1/25/2020, 11:37 AM
Engineering Economic Analysis - Pages 600 - 649                                    https://print.vitalsource.com/print/9780190931940?brand=Yuzu&from=...
     Printed by: 6f37bd28e236046@placeholder.17650.edu. Printing is for personal, private use only. No part of this book
              may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted.
16 of 52                                                                                                                                        1/25/2020, 11:37 AM
Engineering Economic Analysis - Pages 600 - 649                                  https://print.vitalsource.com/print/9780190931940?brand=Yuzu&from=...
     Printed by: 6f37bd28e236046@placeholder.17650.edu. Printing is for personal, private use only. No part of this book
              may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted.
17 of 52                                                                                                                                     1/25/2020, 11:37 AM
Engineering Economic Analysis - Pages 600 - 649                              https://print.vitalsource.com/print/9780190931940?brand=Yuzu&from=...
     Printed by: 6f37bd28e236046@placeholder.17650.edu. Printing is for personal, private use only. No part of this book
              may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted.
18 of 52                                                                                                                               1/25/2020, 11:37 AM
Engineering Economic Analysis - Pages 600 - 649                                 https://print.vitalsource.com/print/9780190931940?brand=Yuzu&from=...
     Printed by: 6f37bd28e236046@placeholder.17650.edu. Printing is for personal, private use only. No part of this book
              may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted.
19 of 52                                                                                                                                 1/25/2020, 11:37 AM
Engineering Economic Analysis - Pages 600 - 649                                    https://print.vitalsource.com/print/9780190931940?brand=Yuzu&from=...
     Printed by: 6f37bd28e236046@placeholder.17650.edu. Printing is for personal, private use only. No part of this book
              may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted.
20 of 52                                                                                                                                       1/25/2020, 11:37 AM
Engineering Economic Analysis - Pages 600 - 649                                https://print.vitalsource.com/print/9780190931940?brand=Yuzu&from=...
     Printed by: 6f37bd28e236046@placeholder.17650.edu. Printing is for personal, private use only. No part of this book
              may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted.
21 of 52                                                                                                                                   1/25/2020, 11:37 AM
Engineering Economic Analysis - Pages 600 - 649                                     https://print.vitalsource.com/print/9780190931940?brand=Yuzu&from=...
     Printed by: 6f37bd28e236046@placeholder.17650.edu. Printing is for personal, private use only. No part of this book
              may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted.
22 of 52                                                                                                                                         1/25/2020, 11:37 AM
Engineering Economic Analysis - Pages 600 - 649                                  https://print.vitalsource.com/print/9780190931940?brand=Yuzu&from=...
     Printed by: 6f37bd28e236046@placeholder.17650.edu. Printing is for personal, private use only. No part of this book
              may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted.
23 of 52                                                                                                                                 1/25/2020, 11:37 AM
Engineering Economic Analysis - Pages 600 - 649                                  https://print.vitalsource.com/print/9780190931940?brand=Yuzu&from=...
     Printed by: 6f37bd28e236046@placeholder.17650.edu. Printing is for personal, private use only. No part of this book
              may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted.
24 of 52                                                                                                                                  1/25/2020, 11:37 AM
Engineering Economic Analysis - Pages 600 - 649                                   https://print.vitalsource.com/print/9780190931940?brand=Yuzu&from=...
     Printed by: 6f37bd28e236046@placeholder.17650.edu. Printing is for personal, private use only. No part of this book
              may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted.
25 of 52                                                                                                                                    1/25/2020, 11:37 AM
Engineering Economic Analysis - Pages 600 - 649                                 https://print.vitalsource.com/print/9780190931940?brand=Yuzu&from=...
     Printed by: 6f37bd28e236046@placeholder.17650.edu. Printing is for personal, private use only. No part of this book
              may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted.
26 of 52                                                                                                                                   1/25/2020, 11:37 AM
Engineering Economic Analysis - Pages 600 - 649                                  https://print.vitalsource.com/print/9780190931940?brand=Yuzu&from=...
     Printed by: 6f37bd28e236046@placeholder.17650.edu. Printing is for personal, private use only. No part of this book
              may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted.
27 of 52                                                                                                                                   1/25/2020, 11:37 AM
Engineering Economic Analysis - Pages 600 - 649                                https://print.vitalsource.com/print/9780190931940?brand=Yuzu&from=...
     Printed by: 6f37bd28e236046@placeholder.17650.edu. Printing is for personal, private use only. No part of this book
              may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted.
28 of 52                                                                                                                                   1/25/2020, 11:37 AM
Engineering Economic Analysis - Pages 600 - 649                                 https://print.vitalsource.com/print/9780190931940?brand=Yuzu&from=...
     Printed by: 6f37bd28e236046@placeholder.17650.edu. Printing is for personal, private use only. No part of this book
              may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted.
29 of 52                                                                                                                                  1/25/2020, 11:37 AM
Engineering Economic Analysis - Pages 600 - 649                                 https://print.vitalsource.com/print/9780190931940?brand=Yuzu&from=...
     Printed by: 6f37bd28e236046@placeholder.17650.edu. Printing is for personal, private use only. No part of this book
              may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted.
30 of 52                                                                                                                                  1/25/2020, 11:37 AM
Engineering Economic Analysis - Pages 600 - 649                                     https://print.vitalsource.com/print/9780190931940?brand=Yuzu&from=...
     Printed by: 6f37bd28e236046@placeholder.17650.edu. Printing is for personal, private use only. No part of this book
              may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted.
31 of 52                                                                                                                                       1/25/2020, 11:37 AM
Engineering Economic Analysis - Pages 600 - 649                                     https://print.vitalsource.com/print/9780190931940?brand=Yuzu&from=...
     Printed by: 6f37bd28e236046@placeholder.17650.edu. Printing is for personal, private use only. No part of this book
              may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted.
32 of 52                                                                                                                                    1/25/2020, 11:37 AM
Engineering Economic Analysis - Pages 600 - 649                                   https://print.vitalsource.com/print/9780190931940?brand=Yuzu&from=...
     Printed by: 6f37bd28e236046@placeholder.17650.edu. Printing is for personal, private use only. No part of this book
              may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted.
33 of 52                                                                                                                                      1/25/2020, 11:37 AM
Engineering Economic Analysis - Pages 600 - 649                                  https://print.vitalsource.com/print/9780190931940?brand=Yuzu&from=...
     Printed by: 6f37bd28e236046@placeholder.17650.edu. Printing is for personal, private use only. No part of this book
              may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted.
34 of 52                                                                                                                                  1/25/2020, 11:37 AM
Engineering Economic Analysis - Pages 600 - 649                                https://print.vitalsource.com/print/9780190931940?brand=Yuzu&from=...
     Printed by: 6f37bd28e236046@placeholder.17650.edu. Printing is for personal, private use only. No part of this book
              may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted.
35 of 52                                                                                                                                    1/25/2020, 11:37 AM
Engineering Economic Analysis - Pages 600 - 649                                 https://print.vitalsource.com/print/9780190931940?brand=Yuzu&from=...
     Printed by: 6f37bd28e236046@placeholder.17650.edu. Printing is for personal, private use only. No part of this book
              may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted.
36 of 52                                                                                                                               1/25/2020, 11:37 AM
Engineering Economic Analysis - Pages 600 - 649                                  https://print.vitalsource.com/print/9780190931940?brand=Yuzu&from=...
     Printed by: 6f37bd28e236046@placeholder.17650.edu. Printing is for personal, private use only. No part of this book
              may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted.
37 of 52                                                                                                                                     1/25/2020, 11:37 AM
Engineering Economic Analysis - Pages 600 - 649                                   https://print.vitalsource.com/print/9780190931940?brand=Yuzu&from=...
     Printed by: 6f37bd28e236046@placeholder.17650.edu. Printing is for personal, private use only. No part of this book
              may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted.
38 of 52                                                                                                                                 1/25/2020, 11:37 AM
Engineering Economic Analysis - Pages 600 - 649                               https://print.vitalsource.com/print/9780190931940?brand=Yuzu&from=...
     Printed by: 6f37bd28e236046@placeholder.17650.edu. Printing is for personal, private use only. No part of this book
              may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted.
       EXAMPLE 17-1
       For simplicity, assume that Engineered Industries will not pay dividends in 2018 and did not sen any capital
       equipment. It did purchase $400,000 in capital equipment. What can be said about the values on the balance sheet at
       the end of 2018, using the linkages just described?
39 of 52                                                                                                                       1/25/2020, 11:37 AM
Engineering Economic Analysis - Pages 600 - 649                               https://print.vitalsource.com/print/9780190931940?brand=Yuzu&from=...
     Printed by: 6f37bd28e236046@placeholder.17650.edu. Printing is for personal, private use only. No part of this book
              may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted.
       SOLUTION
       First, the net profit of $850,000 will be added to the retained earning~ from the end of 2017 to find the new retained
       earnings at the end of 2018:
                                          RE 12/3 1/ 2011   =   850,000 + $8 745.()00   = $9,595,000
          Second, the plant and equipment assets shown at the end of 2018 would increase from $6,500,000 to $6,900,000.
          Third, the accumulated depreciation would increase by the $450,000 in depreciation shown in the 2018 income
       statement from the $2,350,000 posted in 2017. The new accumulated depreciation on the 2018 balance sheet would be
       $2,800,000. Combined with the change in the amount of capital equipment, the new fixed asset total for 2018 would
       equal:
                                           $335,000 + $6,900 000 - $2,800 000       =     4,435 000
       EXAMPLE 17-2
       Industrial Robots does not manufacture its own motors or computer chips. Its premium product differs from its
       standard product in having heavier-duty motors and more computer chips for greater flexibility.
          As a result. Industrial Robots manufactures a higher fraction of the standard product's value itself, and it purchases a
       higher fraction of the premium product's value. Use the following data to allocate $850,000 in overhead on the basis of
       labor cost and materials cost.
                                IStandard IPremium I
40 of 52                                                                                                                      1/25/2020, 11:37 AM
Engineering Economic Analysis - Pages 600 - 649                                 https://print.vitalsource.com/print/9780190931940?brand=Yuzu&from=...
     Printed by: 6f37bd28e236046@placeholder.17650.edu. Printing is for personal, private use only. No part of this book
              may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted.
                                      Standard Premium
            umber of units p.er year 750             400
           Labor cost (each)          $400           $500
             aterfals cost (each)     50             900
       SOLUTION
       First, the labor and material costs for the standard product, the premium. product, and in total are calculated.
          Then the allocated cost per labor dollar, $1.70, is found by dividing the $850,000 in overhead by the $500,000 in
       total Jabor cost. The allocated cost per material dollar, $1.100324, is found by dividing the $8S0,000 in overhead by the
       $772,500 in materials cost. ow, the $850,000 in allocated overhead is split between the two products using labor costs
       and mate1i.al costs.
          If labor cost is the burden vehicle, then 60% of the $850,000 in overhead is allocated to the standard product. If
       material cost is the burden vehide, then 53.4% is allocated to the standard product. In both cases, the $850,000 has
       been split between the two products. Using total direct costs would produce another overhead allocation between these
       two values. However., for decision making about product mix and product prices, incremental overhead costs must be
       analyzed. AU the aUocation or burden vehicles are based on an average cost of overhead per unit of burden vehicle.
41 of 52                                                                                                                        1/25/2020, 11:37 AM
Engineering Economic Analysis - Pages 600 - 649                                https://print.vitalsource.com/print/9780190931940?brand=Yuzu&from=...
     Printed by: 6f37bd28e236046@placeholder.17650.edu. Printing is for personal, private use only. No part of this book
              may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted.
                              Direct      Direct
                              Labor      Material
Product Cost
      FIGURE 17-4 Activity-based costing versus traclitiona] overhead allocation. (Based on an example by Kim Lascola
      Needy.)
      SUMMARY
      This chapter has provided several key concepts from the accounting field. These provide additional perspective when
      conducting engineering economic analyses. Data from accounting records form the bases for many needed estimates.
      Management decisions rely on both professions to keep the finn profitable.
            Engineering economic analysis: requires the estimation of future costs and benefits. These are often detived from
            histmi cal data. Projects are evaluated over their life cycle using methods such as present worth, equivalent worth,
            and rate of return. The effects of taxes, inflation, and risk and uncertainty may be included. Analyses assist the firm
            in making future dedsions .
            Accounting: determines the economic impact of past business decisions, and thus provides irnpmtant historical data
            for making future ones. Tools such as the balance sheet and income statement capture important measures.
            Management: alJocates constrained resources of the firm to promote economic growth/stability and strategic
            objectives. Management requires data, analysis, and communication from both the engineering economy (future
            view) and accounting (historical view) perspect1ves.
         The primary accounting statements are the balance sheet and the income statement. The balance sheet provides a
      snapshot in time of the financial position of the firm. This tool is based on the fundamental accounting equation: Assets =
      Liabilities - Equity, where assets are items owned by the film and have monetary value, liabilities represent debt
      obligations, and equity is the ownership value in the firm. Financial measures such as cun-ent ratio and quick ratio are
      fmmed from data on the balance sheet.
         The income statement summarizes a firm 's revenue and expenses over an interval of time. This is usually a month,
      quarter, or year. Profit (or Joss) is calculated as: Revenues - Expenses= Profit (or loss) . Economic ti-ends over time, from
      consecutive income statements, provide mot-e Information than one statement evaluated in isolation. Financial measures
      such as profit margin and inte1-est coverage are formed from data from the income statement.
         Films' cost accounting systems collect, analyze, and repmt on operational data. These are used for managing assets
      and operations. A traditional cost accounting method treats the firm's direct and indirect costs differently than an activity-
      based method. The former spreads indirect costs (overhead) over products using very simple assumptions, and the latter
      relates costs to the activities that cause those costs. Fim1s that use traditional methods may not have accurate data for
      make versus buy, product mix, and other operating decisions.
         By understancling accounting principles, engineeting economists are better prepared to perform analyses and improve
      decision making for the finn.
      17- Billy Bob' s Towing and Repak Service has provided the allowing financial information.
      2
                Cas h                    $ 80,000
                Accounts receivable 120,000
                Accounts payable         200,000
                Securities               75,000
                Pans inventories         42,000
                Prepaid expenses         30,000
                Accrued expense          15,000
Determ ine (a) the current ratio, (b) the quick ratio, and (c) the avaifable working capital.
      17- Dete.rmi.ne the cun-ent and q uick ratios for Harbor                          aster Boats, Inc. Does the firm appear to be financially sound?
      3 Harbor Master Boats, Inc.
                Balance Sheet,. January 1, 20XX
                Assets                                     Liabiliti es
                Current asse,ts                            Current liabil.ities
                 Cash                    900,000           Accounts pa)rabl e                 2,400,000
                Accounts receivable 1,100,000              Notes payable                      2,000,000
                Inven tory               2,000,000         Accrued expe-nse                   900,.0 00
                Total current assets     4,000,000         Total current liabi.lities         5,300,000
                Fixed assets                               Long-term debt                     3,000,000
                Land                     300,.0 00         Total liabilities                  8,300,000
                Plant                    2,500,000         Equity
                Equipment                6,000,000         Stock                              2,000,000
                Total fixed assets       8,800,000         Retained eamings                   2,500,000
                                                           Total net worth                    4,500,000
                Total assets             12,800,000 Total liabi.lities and net wonh 12,800,.00 0
      4i•1•1dce)ki
      17- Rapid Delivery's financiaJ information 1ncludes:
      4
                Aci d-test ratio                          1.3867
                Cas h on hand                             $72,000
                Accounts receivable                       102,000
                Market value of securities he ld 34,000
                Inventories                               14 3,000
                Other assets                              16,000
                Fixed assets                              215,000
                Total liabilities                         400,000
43 of 52                                                                                                                                                  1/25/2020, 11:37 AM
Engineering Economic Analysis - Pages 600 - 649                                       https://print.vitalsource.com/print/9780190931940?brand=Yuzu&from=...
     Printed by: 6f37bd28e236046@placeholder.17650.edu. Printing is for personal, private use only. No part of this book
              may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted.
           Determine (a) the current assets,. {b) the current l.iabilities, (c) the total assets, and (d) the owner's equJty.
      Wi•ll'dM§•
      17- The fonowing information has been taken fro m the financial statements avai.lable for the ABC Company.
      5    Accounts payable      $4,000
           Accounts receivable 12,000
           Income ta..xes        6,. 000
           Owner's equity        75,000
           C.ost of goods sold   42,000
           Sel.ling expense      10,000
           Sales revenue         80,000
           Taxes paid for the year equaled $110,000. Determine (a) the net income before taxes, (b) the net profit (loss), (c) the interest
           coverage, and (d) th,e net profit ratio.
      Wi•l•GiM§i
      17- Wheeler Industries had sales of $157M and returns and allowances of $2 1 . . Operating expenses were $48M and non-operating
      7 revenues and expens.es equaled the interest pa.id of $7M. Using the corporate tax rate fro m the TCJA compute the tax paid by
          Wheeler Industries. Consnuct th e income statement.
      Wi•li!iidii
      17- Wheeler industries (prob]em SG17-7) had the following ennies in its baJance sheet at the end of last year.
      8
           Plant and equipment                    $17M
           (less accumulated depreciation) 9M
           Retained earnings                      $80M
           In addition to the income statement data for tMs year in prob lem SGl ?-7, we also know that the finn purchased $5 mill.ion of
           equipment with cash and that depreciation expenses were $4 mjJJion of the $4B million in operating expenses. The £inn paid no
           dividends and sold no stock this year. What are the entries in the balance sheet at the end of this year for:
            {a} Pfant and equipment?
            {b) Accumulated depredatio n?
            {c) Retained eamings?
      Wi•I •G it•ii
      17- Brown Box, Inc., mam1factures shipping boxes for a wide variety of indusnies. Their XLLarge costs:
      9    Direct materials costs $0.85/unit
           Direct labor costs     3,85/un.it
           Overhead for the entire manufacturing plant is $4,000,000 per year, and it is allocated based on direct labor costs. Total dkect
           labor costs are $5,500,000. The demand the XLLarge is 200,000 boxes per year. Determ ine the cost per unit.
      Wffi•Gi 0ii
      17- Abby Man ufacturing produces chHdren's toys and the Dr. Dolittle Farm is a big se11er. Indirect costs of $750 000 are aUocated
      10 based on direct materials cost, wlili.ch total $8,350,000 for the facility. The materials used in Dr. DoUttle Fa.rm cost $7.45 per unit
          The totaJ labor (both direct and indirect) costs $9.35 per unjt. Tlile production scheduJe is 300,00 0 units for the coming year. If
                                      "·            .
44 of 52                                                                                                                                1/25/2020, 11:37 AM
Engineering Economic Analysis - Pages 600 - 649                                  https://print.vitalsource.com/print/9780190931940?brand=Yuzu&from=...
     Printed by: 6f37bd28e236046@placeholder.17650.edu. Printing is for personal, private use only. No part of this book
              may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted.
                      '                  ,                      ..
            Abby desires a 35% profit margin, what should the Farm's wholesa]e price be?
      ►i•il'PiM§•
      17- Denali lndustries makes specialized oil well eq uipme nt. se ~ota] dkect cost as the burden vehicle, and compute the total cost per
      11 unit for each model. Total manufacturing indirect costs are $2,500,000, and there are 1000 unjts manufactured per year for Model
          A, 600 for ode! K,. and 500 for Model T. Use tota.l dkect cost as the burden vehicle, and compute the Iota.I cost per unit for each
          model
            Activity             Model A Mode l K Mode l T
            Direct material cost $800,000 $530,000 $630,000
            Direct labor cost    $500,000 $320,000 $410,000
      PROBLEMS
      Key to icons:    D = dick to reveal answer; e = Green, which may include environmental ethics; CJ = Ethics other than
      green;   = autograded problems that are available online in Dashboard;                  = The icon indicates that a spreadsheet is
      recommended.
      Accounting
      17- Why is it important fo r engineers and managers to understand acco unting principles? arne a few ways that they can do so.
      1
      17- Explain the accounting function within a firm. What does th.is function do, and why is it important? What types of data does it
      2. provide?
      17- anipulation of financial data by the Enron Corporation was revealed in October 2001. Firm executives were sentenced to prison.
      3 Arthur Andersen, which had been one of the "Big 5" accounting firms and Enron's auditor, su.rrendered its licenses to practice as
      G   certified public accountants in August 2002. This and other scandals led to the passage of the fe deraJ Sarbanes-Oxley (SarbOx)
          legislation in July 2002 . What a.re the key components of thi.s law?
      17- How would the informatio n and activities in Figure 17-1 rela~e to potential conhibutions by extemaJ professional services that
      4 firms will often hire
           •(a) consulting eng.ineers?
           (b) management consulting firms?
           ,(c), accounting firms for auditing?
      17- Consider Figure 17- 1 and external professional services that £inns will often hi.re. What ethical questions seem like]y to arise
      5     when a firms hires
      G      •(a) consulting engineers for design?
             (b) management consuHing firms?
             ,(c), acco unting firms for auditing?
      17- Inso]vency or cash flow problems in the U.S. banking industry started the financial CJisis of 2007. Have significant changes in
      6   accounting standards and practices been forced thro ugh legislation? If so, what are these changes?
      17- Accounting and finance are requi red topics for most management degrees, and many engineers do beco me managers during their
      7   careers. After graduation with a B.S. in engineering, what courses are avai.lable to you from your or another nearby university?
      17- Using the table of contents, compare the coverage of this engineering economy text with a text for the inh"Oductory course in
      8 corporate finance (typically a j unior course in BBA programs). What topics do the ~exts have in common? Identify the topics that
          seem to be cove11ed in only one--note which topics for which course.
      Balance Sheet
      17- Develop short definitions for the following terms: balance sheet, income statement, and fundame ntal accounting equation.
      9
      17- Explain the difference between short-term and long-term ]jabilities.
      10
      17- Calculate the equity of the Gravel Conshuction Company if it has 10 million worth of assets. Gravel has $1.3 miJUon in      rnn"l'llt
      11 liabilities and $2.5 million in long-term liabilities.
45 of 52                                                                                                                              1/25/2020, 11:37 AM
Engineering Economic Analysis - Pages 600 - 649                                   https://print.vitalsource.com/print/9780190931940?brand=Yuzu&from=...
     Printed by: 6f37bd28e236046@placeholder.17650.edu. Printing is for personal, private use only. No part of this book
              may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted.
      17- atbach Industries has $930,000 in cuITent assets and $470,000 in fixed assets l.ess $180,000 in accumulated depreciation. The
      12 film's curl'ent liabiUties total $370,000, and the long-term liabilities $115,000.
      0    {a) What is the firm 's equity?
           (b) If the firm's stock and capital surplus total $305,000, what is the value for retained earnings?
      17- CalcTech has $1.3M in current assets and $550,000 in fixed assets less $200,000 in accumulated depreciation . The film's cun--em
      13 liabilities total Sl80,000, and the long-te1m l.iabiUties $205,000.
           (a) What is the firm 's equity?
           (b) If the film's stock and capital surpl us total $202,000, what is the value for retained earnings?
      17- Fi.rst Step Baby Monitor Company has curl'ent assets of $5.5 million and current liabjJities of 2.2 million. Give the company's
      •
      14 working capital and current ratio.
      17- From the following data, taken from the balance sheet of Petra's Widget Factory, dete1mjne the working capital, current ratio, and
      15 quick ratio.
           Cash                                 $110,000
           Net accounts and notes receiva ble 325,000
           Retailers ' inventories              210,000
           Prepaid expenses                     6,000
           Accounts and notes payable           300,000
           (short term)
           Accrued expenses                     187,000
      17- For Gee-Whiz Devices, calculate the following: working capital cun'ent ratio, and quick ratio.
      •
      16    Gee-Whiz Devices Ba lance Sheet Data
           Cash                                 $100,000
           Market securities                    45,000
           Net accounts and notes receivable 150,000
           Retailers ' inventories              200,000
           P1'epaid expenses                    8,000
           Accounts and notes payable           315,000
           (short term)
           Accrued ,expenses                    90,000
      17- Turbo Start has cun'ent assets totaling $1.5 milUon (this includes $500,000 in current inventory) and current Uabilities totaling
      17 $400,000. Find the cunent ratio and quick ratio . Are the ratios at desirable levels? E:xplain.
      17- ,(a) For E:vergreen Environmental Engineering (EEE), determine the working capital, cmTent ratio, and q uick ratio. Evaluate the
      18 company's economic situation wi th 1--espect to its ability to pay off debt
      I    EEE Balance Sheet Data ( lOOlts)
      m    Cash                      $120,000
           Secmities                 40,000
           Accounts J'e,ceivable     110,000
           Inventmies                300,000
           P1'epaid expenses         3,000
           Accounts payable          351,000
           Accrued ,expenses         89,000
           {b) The entries to com plete EEE's balance sheet include:Cons truct EEE's balance sheet
           More EEE Ba lance Sheet Data ($1000s)
           Long-term Uabilities        $220,000
           Land                        25,000
           Plant and eq uipment        510,000
           Accumulated dep1--eciation 210,000
46 of 52                                                                                                                            1/25/2020, 11:37 AM
Engineering Economic Analysis - Pages 600 - 649                                                  https://print.vitalsource.com/print/9780190931940?brand=Yuzu&from=...
     Printed by: 6f37bd28e236046@placeholder.17650.edu. Printing is for personal, private use only. No part of this book
              may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted.
           ] .l""t..LL u u 1u.u1 Lcu ucpl 'C"\.... Lauu1 t   jL   ..1.u,vuu
      •
      2.0
47 of 52                                                                                                                                         1/25/2020, 11:37 AM
Engineering Economic Analysis - Pages 600 - 649                                 https://print.vitalsource.com/print/9780190931940?brand=Yuzu&from=...
     Printed by: 6f37bd28e236046@placeholder.17650.edu. Printing is for personal, private use only. No part of this book
              may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted.
             Assets                             Liabilities
             Cunent ass.e~                  Current [iabili:ties
               Cash             $ 870         Note payable           500
               Accounls           450         Accounts payable       600
                 receivable
               Inventory         1200          Accruals              200
               Prepaid expenses    60          Taxes payable          30
                                              Cllfrent portion       100
             l'olal current assets 2580         long-term debt
               et fixed assets              Total curren t
                Land                1200        liabilities         1430
                Plant and           3800    Long-term debt          2·000
                   equipment                Officer debt             200
                (less             -IOOO       (subordi nated
                   accumulated              Total liabilities       3630
                   depreciation)                Equity
             Otl:ter assets                       Common stock      1670
                Notes receivable     200          Capital surplus    400
                Intangibles          l20          Retained earnings 1200
      17- If a firm has a current ratio less than 2.0 and a quick ratio Jess than 1.0, will the com pany eventually go ban krupt and ou t of
      2.1 business? Explain your answer.
      17- What is the advantage of com paring financial statements across periods or against industry benc-hmarks over lookjng at sta temen ts
      2.2 associated wi th a single date or period?
      Income Staten1ent
      17- LaiJa 's Surveying lnc, had revenues of $1.5 m illion in 2016. Expenses totaled $900,000. What was her net profit (or loss) if the
      2.3 tax rate is 38%?
      17- Bohr Pajnt Company has annual sales of $12 m illion per year. If there is a profit of $5000 per d ay wi th 7 days per week operation,
      24 what is the total yearly business expense? AU cakulations are on a before-tax basis.
      0
      17- For Magdalen Industri es, compute the net in come before taxes and net profi t (or loss). Taxes for the year were $7.5 mJrnon.
      25 ,(a) Calculate net profit for the year.
           ,(b) Construct the income statement.
           ,(c), Calculate the interest coverage and net p rofit ratio. Is the interest coverage acceptable? Explain why or why not.
           Magdalen Industries Income Statement Data ( M)
           Revenues
           Total operating revenue                                    $124
           (incl uding sales of $48 mill.ion)
           Total nonoperating flevenue                                36
           Expens.es
           Total operating expenses                                   70
           Total nonoperating expenses                                35
           (interest payments)
      17- Find the net incom e of Turbo Start (Problem 17-17) g iven the fo llowin~ data from the balance sheet and income statem ent.
48 of 52                                                                                                                                 1/25/2020, 11:37 AM
Engineering Economic Analysis - Pages 600 - 649                                                                                            https://print.vitalsource.com/print/9780190931940?brand=Yuzu&from=...
     Printed by: 6f37bd28e236046@placeholder.17650.edu. Printing is for personal, private use only. No part of this book
              may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted.
      J. l - t' J.111.J Ult' 111:! L lllL1.J H H:! U ! 1 U I U U       ~   Ldll \ r 1 UIJlt'IU .l I - .l I   J g1 V l:!!l   Ult' lUU U W tug Ud.Li:I l[UlU LIit' IJdldllLt' 1i!lt'l:!I i:IIIU HILUU.11:!' Sli:llt'U!t'II L
      •
             J                                                     J
49 of 52                                                                                                                                                                                                                     1/25/2020, 11:37 AM
Engineering Economic Analysis - Pages 600 - 649                                         https://print.vitalsource.com/print/9780190931940?brand=Yuzu&from=...
     Printed by: 6f37bd28e236046@placeholder.17650.edu. Printing is for personal, private use only. No part of this book
              may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted.
              Income Statement f•Dr Andrew's Electronics for Endo( Year 20UJ ($1000s)
              Revenues
              Operating revenues
              Sales                                                                $395
              (minus) Returns                                                      -15
              Total operating revenues                                             380
              Nonoperating rev,enues
              Interest receipts                                                    50
              Stock revenues                                                       25
              Total nonoperating revenues                                          75
              Total revenues, R                                                    455
              Expenses
              Operatin g expenses
              Cost of goods and services sold
              Labor                                                                200
              Materials                                                            34
              Indirect cost                                                        68
              Selling and promotion                                                20
              Depreciation                                                         30
              General and administrative                                           10
              Lease payments                                                       10
              Total operating expenses                                             372
              Nonoperating expenses
              Interest payments                                                    22
              Total nonoperating expenses                                          22
              Total expenses, E                                                    394
              Net income before taxes, R - E                                       61
              Incomes taxes                                                        17
              Net profit (loss) for the year 2010                                  44
50 of 52                                                                                                                                  1/25/2020, 11:37 AM
Engineering Economic Analysis - Pages 600 - 649                                      https://print.vitalsource.com/print/9780190931940?brand=Yuzu&from=...
     Printed by: 6f37bd28e236046@placeholder.17650.edu. Printing is for personal, private use only. No part of this book
              may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted.
      3.2   Plant and equipment                $15 million
      I     (less accumulated depredation) 8 miJUon
            Retained earnings                  00 miJlion
            In addition to the income statement data for this year in Problem 17-25, we also know that the firm purchased $3 mil.lion of
            equipment with cash and that depreciation expenses were $2 million of the $70 million in operating expenses listed in Problem
            17-26. The firm paid no dividends this year.
            What are the entries in the balance sheet at the end of th.is year for
             ,(a) plant and equipmen t?
             ,(b) accumulated depreciation?
             ,(c), retained earnings?
      Allocating Costs
      17- Categ01ize each of the following costs as direct or indirect. Assume that a trad.itional costing system fa .in place.
      3.3 Machine nm costs           Cost to markcet the product
            Machine depreciation       Cost of storage
            Ma terial handling costs   Insurance costs
            Cost of materials          Cost of product sa.les force
            Overtime expenses          Engineering drawings
            Machine operator wages Machine labor
            Utility costs              Cost of tooling and fixtu11es
            Support (administrative)
            staff salaries
      17- RLW-11 Enterprises estimated that indirect manufacturing costs for the year would be $75 million and that 15,000 machine-hours
      34 wouJd be used.
      I      •(a) Compute the predetermined indi.11ect cost applkation rate using machine hours as the burden vehkl,e,.
             ,(b) Determine the totaJ mst of pro duction fo r a product with direct material costs of $2 minion, direct-labor costs of $2 ,5
                  mirnon, and 200 machine-hours.
      17- Phi.Lippe Francois Inc. produces concrete sundials-5000 were produced in a rece11t production run. The run required 1500
      35 machine hours, three "set-ups" of the mixing equipment, and 100 hours of final inspection time. Costs are ,esti.mated as follows:
          $50 per machine hom~ $3000 per "set-up," and $20 per inspection hour. Direct materials and direct labor total $95 per sundial
          Indirect expenses total 45% of the direct material. and labor costs.
             ,(a) Determine the "cost to produce" each unit.
             ,(b) At a 15% profit level what is the unit sa.les price?
             ,(c), With six runs per year what is the total annual profit for tMs product?
      17- LeGarmme Industries ma1 es industrial pipe manufactming equ1pment. Use direct-labor hours as the burden vehicle, and compute
      36 the tota.1 cost per unit for each model given in the ta ble. Total manufacturing indirect costs are $1 ,892 000, and there are 100,000
      I   units manufactu11ed per year for Model S, 50,000 for odel M and 82,250 for Model G,
            Item                   Model s       Model llf    Model G
            Direct-materia.l costs $3,800,000 $1,530,000 $2,105,000
            Direct-labor costs     600,000       380,000      420,000
            Direct-labor hours     64,000        20,000       32,000
      17- Par Golf Equipment Company produces two types of golf bag: the standard and deluxe models. The total 1ndirect cost to be
      37 allocated to the two bags is $35,000. Determine the net revenue that Par Golf can expect from the sale of each bag.
             ,(a) Use direct-labor mst to allocate indirect costs.
             (b) Use direct-materials cost to allocate indirect costs,
51 of 52                                                                                                                                       1/25/2020, 11:37 AM
Engineering Economic Analysis - Pages 600 - 649                                   https://print.vitalsource.com/print/9780190931940?brand=Yuzu&from=...
     Printed by: 6f37bd28e236046@placeholder.17650.edu. Printing is for personal, private use only. No part of this book
              may be reproduced or transmitted without publisher's prior permission. Violators will be prosecuted.
      Minicase
      17- Find a reaJ world example where a finn has included environmental remediation costs on its balance sheet or in a note to the
      38 balance sheet. Briefly descri be what was done. Wha t percentage of tile firm's assets and net profi t a.re these costs?
      CD
      CASES
      The following cases from Cases in Engineering Economy (www.oup.com/us/newnan) are suggested as matched with
      this chapter.
52 of 52 1/25/2020, 11:37 AM