Ktl-icon-tai-lieu

Financial Modeling with Crystal Ball and Excel

Được đăng lên bởi ke-toan
Số trang: 7 trang   |   Lượt xem: 452 lần   |   Lượt tải: 0 lần
Financial Modeling
with Crystal
Ball and Excel

JOHN CHARNES

John Wiley & Sons, Inc.

Financial Modeling
with Crystal
Ball and Excel

Founded in 1807, John Wiley & Sons is the oldest independent publishing company
in the United States. With offices in North America, Europe, Australia and Asia,
Wiley is globally committed to developing and marketing print and electronic
products and services for our customers’ professional and personal knowledge and
understanding.
The Wiley Finance series contains books written specifically for finance and
investment professionals as well as sophisticated individual investors and their
financial advisors. Book topics range from portfolio management to e-commerce,
risk management, financial engineering, valuation and financial instrument analysis,
as well as much more.
For a list of available titles, please visit our Web site at


268
Spreadsheet models (continued)
AppendixA.xls, 206
AsianCall.xls, 181
AsianCallVarReduction.xls, 243,
245–247
AssetOrNothingCall.xls, 179
BatchFit.xls, 68–70
BermuPut.xls, 176
Bernoulli.xls, 36
Binomial.xls, 41
BullSpread.xls, 182, 183
CLT.xls, 48
CVaR.xls, 143–144
CVaRSubadditivity.xls, 145
CorrelatedGBM.xls, 162
DirectSampling.xls, 54
ETFs.xls, 158
EsreyOptions.xls, 180
EuroCall.xls, 172
EuroPut.xls, 172
FiveTosses.xls, 37
InverseTransform.xls, 239
Kurtosis.xls, 18
LCGExamples.xls, 235
LifetimeValueModel.xls, 122
Lognormal.xls, 53, 57, 58, 60
MixtureModel.xls, 51
NPV.xls, 106
NPVModels.xls, 108
Newton.xls, 41–43
Normal.xls, 51
OneYearTreasuryYields.xls, 167
PearsonSpearman.xls, 64, 66
Portfolio.xls, 132
PortfolioVaR.xls, 141
PrincipalProtectedInstrument.xls,
184
Profit.xls, 5
Project.xls, 79–94, 119
RandomWalk.xls, 146–149, 151
RandomWalkWithDrift.xls, 154–156
SPY.xls, 157
SPYwithGBM.xls, 161, 162
ScooterNPV.xls, 111

INDEX

ScooterSimulation.xls, 117, 120
Sengupta.xls, 126, 127
Sengupta2.xls, 128, 129
Sengupta3.xls, 130
TenYearTreasuryYields2005.xls, 164
Triangular.xls, 45
TwoCorrelatedAssets.xls, 71, 72
Uniform.xls, 44
VFH.xls, 174
Standard deviation, 17
Statistical study, 33
Statistics
Coefficient of variability, 19
Kurtosis, 18
Maximum, 20
Mean, 15
Mean standard error, 20, 242
Median, 16
Minimum, 19
Mode, 17
Range, 20
Skewness, 17
Standard deviation, 17
Trials, 15
Variance, 17
Statistics view, 14
Stop on calculation errors, 96
Stop when precision control limits are
reached, 97
Strike price, 169

T
Tail VaR, 142
Tasche, D., 145
Thomas, J. S., 121, 124
Threshold va...
Để xem tài liệu đầy đủ. Xin vui lòng
Financial Modeling with Crystal Ball and Excel - Người đăng: ke-toan
5 Tài liệu rất hay! Được đăng lên bởi - 1 giờ trước Đúng là cái mình đang tìm. Rất hay và bổ ích. Cảm ơn bạn!
7 Vietnamese
Financial Modeling with Crystal Ball and Excel 9 10 99