Index 559
Rounding numbers
to nearest cent, 175, 178, 184,
213–214
to nearest whole number, 362
to nearest dollar, 375
spreadsheet settings for, 13
Rows, in budget matrix, 496
Royalties, payment by, 303–309
Rule of 72, 160, 167
S
Sacrifice sale, 218
Safe deposit boxes, 131
Safety data, automobile, 268–273
Salaries. See Employment
Sales taxes, 219, 328, 335
Savings
bank accounts for, 114, 131–136
in cash flow analysis, 509
in retirement planning, 438–446
Savitch, Jessica, 352, 361
Scale drawings, floor plans as, 394
Scatterplots
of exponential decay, 252
of hybrid car sales, 282
linear regression for, 70–74
loan length versus balance, 190
for rate of failures, 108
square footage versus rent, 387
trends shown on, 64–69, 231
Schedules A and B, for income taxes,
365–376
Seasons, utility bill variation by, 485
Sectors, of circles, 499
Security deposit, for leases, 387
Self-employment, 439
Selling automobiles, 224–230
Semiannual compounding, 137
Semimonthly paychecks, 296–297
Semi-retired people, 438
Shadow skid marks, in car
accidents, 274
Shareholders
defined, 4
dividends for, 51–56
stock splits and, 45
See also Stock market
Shares of stock, 4, 45, 47–48. See also
Stock market
Shubert Theater (Minneapolis,
MN), 383
Shulman, Morton, 143, 148
Simple interest, 131
Simple moving averages (SMA),
22–28
Singer, June, 259, 265
Single checking accounts, 117
Single deposit investment, future
value of, 156
Single deposit investment, present
value of, 161–163
Single-family homes, 384
Single life annuity, in retirement
plans, 457
Single tax filing status, 329, 340
Skewed data, 225
Skid distance, 275
Skid marks, in car accidents, 274
Skid speed formula, 275–276
Skills and Strategies feature
auto insurance costs, 239–240
average daily balance, 206–208
breakeven analysis, 92–94
budget matrices, charts, and
graphs, 498–503
buying and selling cars, 219–221
capital gains and losses, 36–37
car price negotiations, 225–226
cash flow analysis, 509–517
commissions, royalties, and piece-
work pay, 304–306
compound interest, 138–140,
144–145
continuous compounding, 151–153
correlation coefficient, 72
credit card statements, 202–203
depositing money, 118
dividends, 52–53
driving data, 260–264
electronic utility costs, 490–493
employee benefits, 311–313
employment search, 291–293
expense and revenue functions,
87–89
exponential depreciation, 253–256
finance charges on credit cards,
195–196
floor plans, 394–397
frequency distribution, 232–235
future value of investments,
157–158
home ownership costs, 402–407
homeowner’s insurance, 401
home purchase costs, 413–419
installment plans, 175–176
interest rates, 132–134
life insurance, 465–468
line of best fit, 71–72
loan calculations, 188–190
loan payments, 183–184
mathematical modeling, 104–105
Medicare, 317–318
pay periods and hourly rates,
297–299
pay stubs, Form W-2, and Form
1099, 345–348
pension benefits, 458–460
present and future values of retire-
ment accounts, 439–443
present value of investments,
162–164
profit, 99–100
profitability, 81–83
ratios and percents, 5
reaction and braking distances,
269–271
reconciling bank statements,
124–126
rentals, co-ops, and condomini-
ums, 423–427
renting and purchasing housing,
385–390
scatterplots, 65–67
simple moving average, 23
skid and yaw formulas, 275–277
Social Security, 317–318, 448–452
stock bar chart, 17
stockbroker fees, 41
stock data, 10
stock splits, 46
stock ticker information, 30
straight line depreciation, 246–248
supply and demand, 76–77
tax form 1040 and Schedules A
and B, 366–374
tax forms 1040EZ and 1040A,
353–360
tax schedules, 336
tax tables, schedules, and
worksheets, 329–331
utility expenses and measure-
ment, 483–485
/ (Slash), as division symbol, 12
Slaughter, Louise, 199, 204
Sliding paid vacation, 314
Slope
of depreciation lines, 245–247
of linear regression line, 71
Social Security tax rate, 318
in tax equation, 338
Slow moving averages, 26
Smoothing stock data, 22–28
Social Security Act of 1935, 447
Social Security benefits
applications on, 453–455
baby boomer generation and, 437
maximum taxable income for,
447–448
paycheck deductions for, 316–320
statement of, 449–450
taxable portion of, 451–452
Social Security number, 316
Sole owner checking accounts, 117
Sole proprietorship, 4
Sony Corporation of America, 63
Southern Copper, Inc., 60
Speedometer, 259, 271
Spending, consumer, 520
Split functions, 219–221
Splits, stock, 45–50
Spreadsheets
amortization table on, 415–417
for ARMs, 419
for breakeven analysis, 94
for cash flow, 509–515
on consumer credit, 179
as electronic matrix, 496
future value of investments
on, 160
to reconcile bank statements, 126
rent versus buy decision, 424–425
simple moving averages on, 25–26
for stock data, 12–13
for tax computation, 342
yields on, 55
Square footage, of apartments, 387
Square roots, in skid speed
formula, 275
Standard deduction, for income
taxes, 359
Starting balance, on bank state-
ments, 123, 140
Statement, credit card, 200–205
49657_13_index_p552-560.indd 55949657_13_index_p552-560.indd 559 12/26/09 12:06:19 PM12/26/09 12:06:19 PM