Improving Decision Making: Using Spreadsheet Software for Capital Budgeting for
a New CAD System
Software skills: Spreadsheet formulas and functions
Business skills: Capital budgeting
Your company would like to invest in a new computer-aided-design (CAD) system
that requires purchasing hardware, software, and networking technology, as well as
expenditures for installation, training, and support. The Laudon Web site,
MyMISlab, for Chapter 14 contains tables showing each cost component for the new
system as well as annual maintenance costs over a five-year period. It also features a
Learning Track on capital budgeting models. You believe the new system will
produce annual savings by reducing the amount of labor required to generate
designs and design specifications, thus increasing your firm’s cash flow. Using the
data provided in these tables, create a worksheet that calculates the costs and
benefits of the investment over a five-year period and analyze the investment using
the four capital budgeting models presented in this chapter’s Learning Track. Is
this investment worthwhile? Why or why not?
Improving Decision Making: Using Web Tools for Buying and Financing a Home
You have found a new job in Denver, Colorado and would like to purchase a home
in that area. Ideally, you would like to find a single-family house with at least three
bedrooms and one bathroom that costs between $150,000 and $225,000 and finance
it with a 30-year fixed rate mortgage. You can afford a down payment that is 20