Question: Use a spreadsheet and a study period

> How has the capital recovery amount changed for the Lloyd’s protectors with these new estimates?

> With these new estimates, what is the recalculated AW for the Lloyd’s protectors? Use the old first cost and maintenance cost estimates for the first 3 years. If these estimates had been made 3 years ago, would Lloyd’s

> Plot a graph of the newly estimated maintenance costs and repair savings projections, assuming the protectors last for seven more years.

> Economically, what is the best combination of plans for Brad and Sheryl, assuming they both live to be 85 years old?

> Plot the future worth values for all four plans on one spreadsheet graph.

> What is the future worth at 6% per year of each plan at age 85?

> Brad and Sheryl are the same age. Brad determined that most of their investments make an average of 6% per year. With this as the interest rate, the analysis for the four alternatives is possible. Sheryl and Brad plan to answer the following questions, b

> A credit card issued by the GECU credit union has an APR of 16% and an APY of 16.64%. (a) What is the compounding period? (b) Use the EFFECT function to find the compounding period. Answer: 0.1664 = (1 + 0.16/m)m – 1 By trial and error, m= 2 Compound

> Sales of bottled water in the United States totaled 34.0 gallons per person in 2014. Evian, a high-quality natural spring water, costs about 60¢ per bottle, while a local brand of purified municipal water may cost only 25¢ per bottle. On average, a local

> The Premier Car Title Loan Company makes emergency loans of up to $500 for 1 month for a fee of 4% of the loan amount. If a person borrows $500, what is (a) the nominal interest rate per year, and (b) the effective rate per year?

> For an interest rate of 9% per year, compounded every 4 months, determine the nominal interest rate per (a) 8 months, (b) 12 months, and (c) 2 years.

> First Corp Bank advertises interest paid at 2% every 6 months. What is the APR?

> For an interest rate of 1% per quarter, determine the nominal interest rate per (a) semiannual period, (b) year, and, (c) 2 years.

> For an interest rate of 10% per year, compounded quarterly, determine the number of times interest is compounded (a) per quarter, (b) per 6 months, (c) per year, and (d) per 3 years.

> Determine the number of times interest is compounded in a year for the following interest statements: (a) 1% per quarter; (b) 2% per month; and (c) 8% per year, compounded every 2 months.

> Identify the compounding period for the following interest statements: (a) nominal 7% per year, compounded monthly; (b) effective 6.8% per year, compounded monthly; and (c) effective 3.4% per quarter, compounded weekly.

> What is the difference between APR and APY? Which one is used in interest factor formulas, tables, and spreadsheet functions?

> An interest rate of 12% per year, compounded monthly, is nearest to: (a) 12.08% per year (b) 12.28% per year (c) 12.48% per year (d) 12.68% per year

> Some years ago, Penny purchased the car of her dreams for $25,000 by paying 20% down at purchase time and taking a $20,000, 5-year, 6% per year, compounded monthly loan with 60 monthly payments of $386.66 each. She is examining her loan situation and wou

> Identify the compounding period for the following interest statements: (a) 1% per week; (b) 2.5 % per quarter; and (c) 8.5% per year, compounded semiannually.

> When evaluating multiple alternatives or projects, against what must they be compared, if they are (a) independent, and (b) mutually exclusive?

> An engineer deposited her annual bonus of $10,000 into an account that pays interest at 8% per year, compounded semiannually. She withdrew $1000 in months 2, 11, and 23. Now, she wants to know the total value of the account at the end of 3 years. Solve b

> Solve Problem 4.44 using a spreadsheet, which analyzes the loan on a boat purchased by the Fairfold family. Display the answers for parts (a) through(d) below the spreadsheet and indicate the functions that you used to obtain the answers. Problem 4.44 T

> Solve Problem 4.19 by applying the EFFECT function to determine the rates. Problem4.19 Jennifer and Rex both receive a dividend from their 401(k) retirement plan every 6 months. The earning rates for this year have been 5% per year, compounded quarterly

> If you have the annual worth of an alternative with a 5-year life, you can calculate its perpetual annual worth by: (a) no calculation needed. The perpetual annual worth is equal to the annual worth (b) multiplying the annual worth by (A∕P,i,5) (c) divi

> The AW amounts of three revenue alternatives are $−23,000 for alternative A, $−21,600 for B, and $−27,300 for C. On the basis of these AW values, the correct decision is to: (a) select alternative A (b) select alternative B (c) select alternative C (d)

> The future worth of alternative B is closest to: (a) $−85,000 (b) $−750,000 (c) $−850,000 (d) −∞

> All of the following equations for calculating the capitalized cost of alternative B are correct, except: (a) CCB = −750,000 − 10,000/0.10 (b) CCB = −750,000 − 10,000/0.10 + 2,000,0

> The capitalized cost of alternative B is nearest: (a) $−590,000 (b) $−625,000 (c) $−734,000 (d) $−850,000

> The product development group of a high-tech electronics company developed five proposals for new products. The company wants to expand its product offerings, so it will undertake all projects that are economically attractive at the companyâ€&

> The present worth of alternative B is nearest: (a) $−85,000 (b) $−750,000 (c) $−850,000 (d) $−950,000

> Citizens Bank of Toronto advertises an APR of 12% compounded monthly for collateral loans. What is the APY? Also, write the spreadsheet function to display the APY.

> Humana Hospital Corporation installed a new MRI machine at a cost of $750,000 this year in its medical professional clinic in Cedar Park. This state-of-the-art system is expected to be used for 5 years and then sold for $125,000. Humana uses a return req

> You have been asked to compare the alternatives on the basis of a present worth comparison. The PW of alternative A is closest to: (a) $−724,320 (b) $−530,520 (c) $−388,950 (d) $−72,

> An engineer analyzed four independent alternatives by the present worth method. On the basis of her results, the alternative(s) she should select are: (a) Only D (b) Can’t tell from this information (c) All of them (d) None of them

> The capitalized cost of machine Y is closest to: (a) $17,726 (b) $86,590 (c) $177,260 (d) $207,720

> In comparing the alternatives on a future worth basis, the FW of machine X is closest to: (a) $23,160 (b) $40,560 (c) $58,950 (d) $71,860

> In comparing the alternatives on a present worth basis, the PW of machine X is closest to: (a) $23,160 (b) $40,560 (c) $58,950 (d) $72,432

> The cost of maintaining a permanent monument is expected to be $70,000 now and $70,000 every 10 years forever. At an interest rate of 10% per year, the capitalized cost is nearest: (a) $−11,393 (b) $−58,930 (c) $−84,360 (d) $−113,930

> An upgraded version of a CNC machine has a first cost of $200,000, an annual operating cost of $60,000, and a salvage value of $50,000 after its 8-year life. At an interest rate of 10% per year, the capitalized cost is closest to: (a) $−93,116 (b) $−100

> The capitalized cost of an initial investment of $200,000 and annual investments of $30,000 forever at an interest rate of 10% per year is closest to: (a) $−230,000 (b) $−300,000 (c) $−500,000 (d) $−2,300,000

> When comparing mutually exclusive alternatives that have different lives by the present worth method, it is necessary to: (a) Always compare them over a period equal to the life of the longer-lived alternative (b) Always compare them over a time period o

> Western Energy makes quarterly deposits into an account reserved for purchasing new equipment 2 years from now. The interest paid on the deposits is 12% per year, compounded monthly. (a) Identify the interest period, compounding period, and compounding f

> An engineer is trying to decide which process to use to reduce sludge volume prior to disposal. Belt filter presses (BFP) will cost $203,000 to buy and $85,000 per year to operate. Belts will be replaced one time per year at a cost of $5500. Centrifuges

> One way to recover invested capital with interest is to collect the principal P over n years as P∕n and also collect the interest on the unrecovered balance. Assume you borrowed $6000 at 10% per year interest with a repayment period of 3 years to purchas

> The present worth of an alternative that provides infinite service is called its: (a) Net present value (b) Discounted total cost (c) Capitalized cost (d) Perpetual annual cost

> Petrobras, the Brazilian energy company, has identified two alternatives to provide potable water to offshore platforms—purchase and operate the equipment, or contract long term with Manal and Associates, an international oilfield servi

> Hannifin CNG Fuel Dispensers needs to purchase replacement equipment to streamline one of its production lines for a new contract, but may sell the equipment before its expected life is reached at an estimated market value for used equipment. At MARR = 1

> Charlie’s Truck Repair and Service has a new contract that requires him to purchase and maintain new equipment for work on 18-wheeler trucks and heavy road equipment. Two separate vendors have made quotes and estimates for Charlie. Use

> You wish to evaluate four independent projects that all have a 10-year life at MARR = 15% per year. Preliminary estimates for first cost, annual net income, and SV have been made. (a) Accept or reject each project using a present worth analysis. On your

> Leonard Motors is trying to increase its international export business. It is considering several alternatives. Two were available earlier (per Problem 5.11), but a new one has recently been proposed by a potential internationally partnering corporation,

> An automaton asset with a high first cost of $10 million has required capital recovery (CR) of $1,985,000 per year. The correct interpretation of this CR value is that: (a) the owner must pay an additional $1,985,000 each year to retain the asset. (b) e

> Find the F, P, and A values for the negative cash flows shown in the diagram.

> Cost increases imposed by design changes introduced at different times during advancing stages of the product life cycle (PLC) usually rise dramatically as the change is introduced later in the life cycle of the product. Though the numbers vary from one

> Three methods to dispose of nonhazardous waste have been developed—land application, fluidizedbed incineration, and private disposal contract. Use AW analysis and an associated scatter chart of AW versus i values to select the economica

> A company that makes food-friendly silicone (for use in cooking and baking pan coatings) is considering the independent projects shown, all of which can be considered to be viable for only 10 years. If the company’s MARR is 15% per year

> Compare two alternatives, A and B, on the basis of a present worth evaluation using i = 10% per year and a study period of 8 years.

> As you came to work this morning, your department head asked you to perform an analysis of installing MAP/TOP in the manufacturing planning division of the company. (MAP/TOP is a business and manufacturing environment communications integration software

> Problem 6.9 described Google’s rental agreement for an airbase in California. It included the following estimates: P = $1.16 billion; M&O = $0.0063 billion per year; refurbishment cost = $0.0026 billion in year 4; n = 60 years; and i = 15% per year. (a)

> Lotus Development has a software rental plan called SmartSuite that is available on the World Wide Web. A number of programs are available at $2.99 for 48 hours. If a construction company uses the service every week for an average of 48 hours, what is th

> The cost of upgrading a section of Grand Loop Road in Yellowstone National Park is $1.7 million. Resurfacing and other maintenance are expected to cost $350,000 every 3 years. What is the capitalized cost of the road at an interest rate of 6% per year?

> Metropolitan Water Utilities purchases surface water from Elephant Butte Irrigation District at a cost of $100,000 per month in the months of February through September. Instead of paying monthly, the utility makes a single payment of $800,000 at the end

> Northwest Iron and Steel is considering getting involved in electronic commerce. A modest e-commerce package is available for $30,000. The company wants to recover the cost in 2 years. Find the equivalent amount of new revenue that must be realized every

> You plan to deposit $100 per week into a fund that pays interest of 6% per year, compounded quarterly. Identify the interest period, compounding period, and number of times interest is compounded per interest period.

> Determine the capitalized cost of a permanent roadside historical marker that has a first cost of $78,000 and a maintenance cost of $3500 once every 5 years. Use an interest rate of 8% per year.

> Hemisphere, LLC is planning to outsource its 51-person information technology (IT) department to Dyonyx. Hemisphere’s president believes this move will allow access to cutting-edge technologies and skill sets that would be cost prohibitive to obtain on i

> The optical products division of Panasonic is planning a $3.5 million building expansion for manufacturing its powerful Lumix DMC digital zoom camera. If the company uses an interest rate of 16% per year, compounded quarterly for all new investments, wha

> A delivery car had a first cost of $30,000, an annual operating cost of $12,000, and an estimated $4000 salvage value after its 6-year life. Due to an economic slowdown, the car will be retained for only 2 years and must be sold now as a used vehicle. (a

> Radio Frequency Identification (RFID) is a technology used by drivers with “speed passes” at toll booths and ranchers who track livestock from “farm to fork.” Thrift-Mart is implementing the technology to track products within its stores. The RFID-tagged

> Jennifer and Rex both receive a dividend from their 401(k) retirement plan every 6 months. The earning rates for this year have been 5% per year, compounded quarterly for Jennifer, and 4.85% per year, compounded monthly for Rex. Rex felt good about this

> Head & Shoulders shampoo insured a spokesman football player’s long hair for $1 million with Lloyd’s of London. The insurance payout would be triggered if he lost at least 60% of his hair during an on-field event. The insurance company placed the odds of

> In an effort to have enough money to finance his passion for top-level off-road racing, a mechanical engineering graduate decided to sell some of his “toys." At time t = 0, he sold his chopper motorcycle for $18,000. Six months later, he sold his Baja pr

> Pollution control equipment for a pulverized coal cyclone furnace is estimated to cost $190,000 two years from now and an additional $120,000 four years from now. If Monongahela Power wants to set aside enough money now to cover these future costs, how m

> The patriot missile, developed by Lockheed Martin, is designed to detect, identify, and shoot down aircraft and other missiles. The Patriot Advanced Capability- 3 was originally promised to cost $3.9 billion, but due to extra time needed to develop compu

> Identify the following interest rate statements as either nominal or effective: (a) 1.3% per month; (b) 1% per week, compounded weekly; (c) nominal 15% per year, compounded monthly; (d) effective 1.5% per month, compounded daily; and (e) 15% per year, co

> Because testing of nuclear bombs was halted internationally in 1992, the Department of Energy has developed a laser system that allows engineers to simulate (in a laboratory) conditions in a thermonuclear reaction. Due to soaring cost overruns, a congres

> The Terra Max truck currently being manufactured by Oshkosh Truck Co. is a driverless truck that is intended for military use. Such a truck frees personnel to more effectively perform non driving tasks, such as reading maps, scanning for roadside explosi

> A friend tells you she has saved for 7 years and has a present sum of $10,000, which earned at the rate of 8% per year, compounded quarterly. (a) Determine the equivalent amount she had to start with 7 years ago. (b) Write the EFFECT function to find the

> If the VF Corporation deposits $20 million of its retained earnings in an aggressive stock ownership fund for only 1 year, what will be the difference in the total amount accumulated (i.e., F) at 18% per year, compounded monthly versus 18% per year simpl

> A machine used to shread cardboard boxes for composting has a first cost of $10,000, an AOC of $7000 per year, a 3-year life, and no appreciable salvage value. Assume you were told that the service provided by the machine will be needed for only 5 years,

> Videotech specializes in online security software development. It wants to have $65 million available in 3 years to pay stock dividends. How much money must the company set aside now in an account that earns interest at a rate of 12% per year, compounded

> Lennon Hearth Products manufactures glass-door fireplace screens that have two types of mounting brackets for the frame. An L-shaped bracket is used for relatively small fireplace openings and a Ushaped bracket is used for all others. The company include

> Your brother, a new college graduate, wants to be his own boss. He wants to open a restaurant in a small strip center or acquire and operate a food truck, an increasingly popular mode of eating, especially in larger cities. The restaurant space can be re

> In order to find the future worth, F, from a present amount, P, 5 years from now at an interest rate of 12% per year, compounded quarterly, what interest rate must be used in the F∕P factor, (F∕P,i%,n), when n is (a) 5, (b) 10, and (c) 20?

> Eckelberger Products, Inc. makes high-speed recorders with high-speed scanning. The small company has been growing at an average rate of 75% per year for the past 4 years. The CEO asked you to convert the past growth rate into a monthly rate for its annu

> For an APR of 10% per year, if interest is compounded quarterly, determine the nominal rate per (a) 6 months, and (b) 2 years.

> Equipment maintenance costs for manufacturing explosion-proof pressure switches are projected to be $125,000 in year 1 and increase by 3% each year through year 5. What is the equivalent annual worth of the maintenance costs at an interest rate of 10% pe

> It is anticipated that the needs for UPW (ultrapure water) at the new Angular Enterprises site will continue for a long time, as much as 50 years. This is the rationale for using capitalized cost as a basis for the economic decision between desalinated s

> Compare three alternatives on the basis of their capitalized costs at i = 10% per year.

> A medium-size municipality plans to develop a software system to assist in project selection during the next 10 years. A life-cycle cost approach has been used to categorize costs into development, programming, operating, and support costs for each alter

> For the cash flows shown, determine the equivalent uniform annual worth in years 1 through 5 at an interest rate of 18% per year, compounded monthly.

> The cost associated with maintaining rural highways follows a predictable pattern. There are usually no costs for the first 3 years, but thereafter maintenance is required for restriping, weed control, light replacement, shoulder repairs, etc. For one se

> A company that makes modular bevel gear drives with a tight swing ratio for optimizing fork-lift vehicles was told that the interest rate on a loan would be an effective 3.5% per quarter, compounded monthly. The owner, confused by the terminology, asked

> An international textile company’s North America Division must decide which type of fabric cutting machines it will use—straight knife or round knife. The estimates are summarized below. Compare them on the basis of an

> A consulting engineering firm is considering two models of SUVs for the company principals. A GM model will have a first cost of $36,000, an operating cost of $4000, and a salvage value of $15,000 after 3 years. A Ford model will have a first cost of $32

> Two methods can be used for producing solar panels for electric power generation. Method 1 will have an initial cost of $550,000, an AOC of $160,000 per year, and $125,000 salvage value after its 3-year life. Method 2 will cost $830,000 with an AOC of $1

> Polymer Molding, Inc. is considering two processes for manufacturing storm drains. Plan A involves conventional injection molding that will require making a steel mold at a cost of $2 million. The cost for inspecting, maintaining, and cleaning the molds

> Airodyne Wind, Inc. has wind tunnels that can operate vertically or horizontally for evaluating the effects of air flow on a component’s PCB response and reliability. The company expects to build a new tunnel that will be outfitted with multiple sensor p

> The Toro Company is expanding its El Paso, Texas plastic molding plant as it continues to transfer work from Juarez, Mexico contractors. The plant bought a $1.1 million precision injection molding machine to make plastic parts for Toro lawn mowers, trimm

> U.S. Steel is considering a plant expansion to produce austenitic, precipitation hardened, duplex, and martensitic stainless steel round bars that is expected to cost $13 million now and another $10 million 1 year from now. If total operating costs will