Introductory financial economics with spreadsheets

Cover......Page 1
Half Title......Page 2
Title Page......Page 4
Copyright Page......Page 5
Table of Contents......Page 6
Preface......Page 10
Dedication......Page 11
Acknowledgements......Page 12
part 1: Spreadsheets and Budgets......Page 14
  1.1:The Essenceof Spreadsheets......Page 15
  1.2:The Backgroundof Spreadsheets......Page 16
  1.3:The Spreadsheet atStartup......Page 17
  1.4:A Travel Expense Claim......Page 19
  1.5:Formulas......Page 20
  1.6: File Operations......Page 21
  Assignments......Page 23
  2.1:A SimpleBudgetSpreadsheet......Page 26
  2.2:Changing Columns and Rows......Page 28
  2.4: Cell Formatting......Page 30
  2.5: Moving and Copying......Page 33
  2.6: Copying Formulas......Page 37
  Exercises......Page 38
  Assignments......Page 39
  3.1: Case Study Data and Requirements......Page 42
  3.2: Spreadsheet Organization......Page 43
  3.3: Workbook and Sheets......Page 45
  3.4: Building the Project Budget Spreadsheet......Page 46
  3.5: Cell and Range Names......Page 48
  3.6: Printing the Spreadsheet......Page 49
  3.8: Data and Results......Page 50
  Assignments......Page 52
  4.2: The Simple Column Chart......Page 54
  4.3: Group Column Charts......Page 59
  4.4: Bar Charts......Page 61
  4.5: Line Charts......Page 62
  4.6: Scatter Charts......Page 65
  4.7: Pie Charts......Page 66
  Assignments......Page 67
part 2: Basic Concepts of Financial Economics......Page 70
  5.1: Simple Interest......Page 71
  5.2: Compound Interest......Page 72
  5.3: The Effect of Changing the Compounding Period......Page 75
   5.4.1: Explicit Spreadsheet Calculation......Page 78
   5.4.2: Algebraic Calculation......Page 79
   5.4.3: Spreadsheet Formula Calculation......Page 80
   5.5.2: Creative Copying......Page 81
    5.5.2.3: Arithmetic and Geometric Series......Page 83
  Assignments......Page 84
  6.1: Loans with One Repayment......Page 85
  6.2: Loans with Constant Repayments......Page 87
  6.3: Loans with Constant Total Payments......Page 88
  6.4: Mortgage loans......Page 89
  6.5: Monthly Mortgage Payments......Page 93
  6.6: The Term of a Mortgage Loan......Page 94
  Assignments......Page 97
  7.1: Discounting and Present Value......Page 99
  7.2: The Present Value of Study Allowances and Annuities......Page 101
  7.3: Overview of Constant Cash Flows, and Related Formulas and Contracts......Page 105
  7.4: Retirement Pensions......Page 107
  Assignments......Page 111
part 3:ProjectEvaluation......Page 114
  8.1: Introduction......Page 115
  8.2: The Net Present Value of a Cash Flow......Page 116
  8.3: Application to a Real Estate Project......Page 117
  8.4: The Appropriate Interest Rate for Discount Purposes......Page 119
  8.5: The Internal Rate of Return......Page 120
  Assignments......Page 122
  9.1: Discounted Cash Flow......Page 126
  9.2: Cash Balances......Page 128
  9.3: Project Financing......Page 129
  Assignments......Page 132
  10.1: Sensitivity Analysis......Page 134
  10.2: The Data, Table Command......Page 137
  10.3: Sensitivity Analysis Using the Data, Table Command......Page 140
  10.4: Loans and Sensitivity Analysis......Page 143
  Assignments......Page 146
  11.1: Oil and Gas Production......Page 150
  11.2: Revenues and Costs......Page 151
  11.3: An Oil Prospect Evaluation......Page 153
  Exercises......Page 158
part 4: Database Management Applications......Page 160
  12.1: Introduction......Page 161
  12.2: Data Form: A Database Editing Tool......Page 162
  12.3: Sorting Data......Page 163
  12.4: Filtering Records......Page 165
  12.5: Criteria Range and Advanced Filter......Page 167
  Assignment......Page 170
  13.1: The Paste Function Menu......Page 171
  13.2: The VLOOKUP Function......Page 173
  13.3: Looking Up Database Information......Page 174
  13.4: A Lookup for a Pricing Schedule......Page 175
  13.5: Piecewise Linear Functions and Income Tax......Page 176
  Assignments......Page 178
  14.1: Frequency Distributions for Values......Page 179
   14.1.1: Bin Range......Page 180
   14.1.2: The Histogram Add-In......Page 181
   14.1.3: The Frequency Function......Page 182
  14.2: Rank and Percentrank......Page 184
  14.3: The Median, Quartiles, and Percentiles......Page 185
  14.4: Percentile Based Groups......Page 187
  14.5: Frequency Distributions for Labels......Page 188
  Assignment......Page 189
  15.1: Gas Holdings and Statistical Functions......Page 191
  15.2: Database Statistical Functions......Page 193
  15.3: Label Frequency Distribution......Page 195
  15.4: A Comparison of Averages......Page 197
  15.5: Derivation of the Gas Supply Curve......Page 198
  Assignments......Page 201
  16.1: Date and Time Functions......Page 203
  16.2: Investment Evaluation for Non-Integral Periods......Page 204
  16.3: Final Holdings for Investment Portfolio......Page 206
  16.4: Evaluation of the Investment Portfolio......Page 208
  Assignments......Page 211
Index......Page 215