List
of
Examples
15
Bonds and Notes
111
Price and Yield of a Bond
112
A Bond with a Call Feature
113
A Zero-Coupon Bond
215
Yield to Maturity and Yield to Call
217
Price and Yield of a Discounted Note
Depreciation
117
Declining-Balance
Depreciation
118
ACRS
Deductions
120
Partial-Year
Depreciation
Running Total and Statistical Calculations
125
Updating a Checkbook
128
Mean, Median, and Standard Deviation
134
Curve
Fitting
138
Weighted
Mean
218
A Moving Average in Manufacturing
220
Expected Throws of a Die (
2
χ
)
Time, Alarms, and Date Arithmetic
144
Setting the Date and Time
148
Clearing and Setting an Appointment
151
Calculating the Number of Days between Two Dates
152
Determining a Future Date
How to Use the Equation Solver
159
Return on Equity
166
Sales
Forecasts
172
Using a Solver Function (USPV)
175
Nested IF Functions
181
Using Guesses to Find a Solution Iteratively
Printing
189
Trace-Printing an Arithmetic Calculation