a practical guide to modelling uncertainty with Microsoft Excel
نام نخستين پديدآور
Alastair L. Day.
وضعیت ویراست
وضعيت ويراست
2nd ed
وضعیت نشر و پخش و غیره
محل نشرو پخش و غیره
Harlow
نام ناشر، پخش کننده و غيره
Financial Times/Prentice Hall
تاریخ نشرو بخش و غیره
2009
مشخصات ظاهری
نام خاص و کميت اثر
(text (XVIII, 390 p.))
يادداشت کلی
متن يادداشت
1st ed. 2003.
یادداشتهای مربوط به مندرجات
متن يادداشت
Conventions Overview 1 Introduction Scope of the book Example model Objectives of risk modelling Summary 2 Review of model design Introduction Design objectives Common errors Excel features Formats Number formats Lines and borders Colour and patterns Specific colour for inputs and results Data validation Controls combo boxes and buttons Conditional formatting Use of functions and types of functions Add-ins for more functions Text and updated labels Recording a version number, author, etc. Using names Pasting a names table Comment cells Graphics Dynamic graphs to plot individual series Data tables Scenarios Spreadsheet auditing Summary 3 Risk and uncertainty Introduction Risk Uncertainty Response to risk Methods Summary 4 Project finance Introduction Requirements Advantages Risks Risk analysis Risk mitigation Financial model Inputs Sensitivity and cost of capital Construction, borrowing and output Accounting schedules Management analysis and summaries Summary 5 Simulation Introduction Building blocks Procedure Real estate example Summary 6 Financial analysis Introduction Process Environment Industry Financial statements Profit and loss Balance sheet Operating efficiency Profitability Financial structure Core ratios Market ratios Trend analysis Cash flow Forecasts Financial analysis Summary 7 Credit risk Cash flow Cover ratios Sustainability Beaver's model Bathory model Z scores Springate analysis Logit analysis H-Factor model Ratings agency Summary References 8 Valuation Introduction Inputs Cash flow Capital structure Valuation and returns Sensitivity analysis Management summary Summary 9 Bonds Introduction Bond prices Interest rates Yield Duration and maturity Convexity Comparison Summary 10 Options Introduction Options Options example Options hedging strategy Black Scholes Simulation options pricing Binomial model Summary 11 Real options Introduction Project Option to delay Option to abandon Option to expand Summary 12 Equities Introduction Historic data Returns summary Simulation Portfolio Summary References 13 Risk adjusted returns Introduction Economic capital Risk-adjusted return on capital (RAROC) Summary 14 Value at risk Introduction Single asset model Two assets Three asset portfolio Summary 15 Credit value at risk Introduction Portfolio approach Overview of components Single asset Two-bond portfolio Simulation Summary Appendix: software installation and licence Index
موضوع (اسم عام یاعبارت اسمی عام)
موضوع مستند نشده
Microsoft Excel.
موضوع مستند نشده
Risicobeheersing.
موضوع مستند نشده
Wiskundige modellen.
رده بندی کنگره
شماره رده
HF5548
.
4
.
M523
نشانه اثر
A437
2009
نام شخص به منزله سر شناسه - (مسئولیت معنوی درجه اول )