The Mathematics of Money

202 CHAPTER 4 SUMMARY Topic Key Ideas, Formulas, and Techniques Examples Annuities, Their Uses, and Te rminology, pp. 141–143 An ...

Copyright © 2008, The McGraw-Hill Companies, Inc. Topic Key Ideas, Formulas, and Techniques Examples Finding Loan Payments, pp. ...

204 The following exercises are a mixture of problems primarily from the topics covered in Chapter 4. One of the objectives of t ...

Copyright © 2008, The McGraw-Hill Companies, Inc. The Ampersand Corporation borrowed $2,500,000 from a group of private investo ...

206 Chapter 4 Annuities Aaron would like to have $2,000,000 when he retires 42 years from now. How much should he set aside eac ...

Copyright © 2008, The McGraw-Hill Companies, Inc. Daniel and Shauri have a 30-year mortgage. They borrowed $177,259 and their ...

208 Learning Objectives LO 1 Create basic spreadsheets as tools for fi nancial calculations. LO 2 Use spreadsheets to fi nd futu ...

Copyright © 2008, The McGraw-Hill Companies, Inc. A group of cells that falls into a line horizontally is called a row, a group ...

210 Chapter 5 Spreadsheets Now that we have discussed some of the basics behind this spreadsheet example, let’s start off by rec ...

Copyright © 2008, The McGraw-Hill Companies, Inc. With the mouse, click on cell A1 and hold the button down when you do. Then wi ...

212 Chapter 5 Spreadsheets Edit Paste (or click on the paste icon.) You should see the correct amounts now in the product sales ...

Copyright © 2008, The McGraw-Hill Companies, Inc. Here is where using formulas in a spreadsheet really pays off. Fortunately, si ...

214 Chapter 5 Spreadsheets formatted to give dollars and cents instead of showing values rounded to whole dollars. The end resul ...

Copyright © 2008, The McGraw-Hill Companies, Inc. gross pay amounts could have any extra decimal places in it. Of course, it doe ...

216 Chapter 5 Spreadsheets Since Tom’s starting balance was $5,000, we will enter 5000 in cell B2. The interest he earned in the ...

Copyright © 2008, The McGraw-Hill Companies, Inc. Example 5.1.4 To m deposited $5,000 at 7% compounded annually for 40 years. Us ...

218 Chapter 5 Spreadsheets you may already know some yourself if you have used Excel before. As with formatting, though, our goa ...

Copyright © 2008, The McGraw-Hill Companies, Inc. Exercises 5 to 8 all are based on the following scenario. Each problem in this ...

220 Chapter 5 Spreadsheets Calculate the future value for Exercise 11, using the compound interest formula. Does the answer agr ...

Copyright © 2008, The McGraw-Hill Companies, Inc. 5.2 Finding Future Values with Spreadsheets Spreadsheets can be effectively us ...