Modeling structured finance cash flows with Microsoft Excel: a step-by-step guide
Saved in:
| Main Author: | |
|---|---|
| Format: | Book |
| Language: | English |
| Published: |
Hoboken, N.J.
Wiley
2007
|
| Series: | Wiley finance series
|
| Subjects: | |
| Online Access: | Table of contents only Inhaltsverzeichnis |
| Physical Description: | XV, 199 S. 1 CD-ROM (12 cm) |
| ISBN: | 0470042907 9780470042908 |
Staff View
MARC
| LEADER | 00000nam a2200000zc 4500 | ||
|---|---|---|---|
| 001 | BV022298238 | ||
| 003 | DE-604 | ||
| 005 | 20160715 | ||
| 007 | t | ||
| 008 | 070305s2007 xxu |||| 00||| eng d | ||
| 010 | |a 2006025757 | ||
| 020 | |a 0470042907 |c paper/cdrom |9 0-470-04290-7 | ||
| 020 | |a 9780470042908 |9 978-0-470-04290-8 | ||
| 035 | |a (OCoLC)71005745 | ||
| 035 | |a (DE-599)BVBBV022298238 | ||
| 040 | |a DE-604 |b ger |e aacr | ||
| 041 | 0 | |a eng | |
| 044 | |a xxu |c US | ||
| 049 | |a DE-20 |a DE-1102 |a DE-1049 |a DE-706 |a DE-945 |a DE-2070s | ||
| 050 | 0 | |a HG4028.C45 | |
| 082 | 0 | |a 658.15/50285554 | |
| 084 | |a QP 720 |0 (DE-625)141929: |2 rvk | ||
| 100 | 1 | |a Allman, Keith A. |d 1977- |e Verfasser |0 (DE-588)173917089 |4 aut | |
| 245 | 1 | 0 | |a Modeling structured finance cash flows with Microsoft Excel |b a step-by-step guide |c Keith A. Allman |
| 264 | 1 | |a Hoboken, N.J. |b Wiley |c 2007 | |
| 300 | |a XV, 199 S. |e 1 CD-ROM (12 cm) | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 490 | 0 | |a Wiley finance series | |
| 630 | 0 | 4 | |a Microsoft Excel (Computer file) |
| 650 | 7 | |a Cash-flow |2 gtt | |
| 650 | 7 | |a Spreadsheets |2 gtt | |
| 650 | 4 | |a Mathematisches Modell | |
| 650 | 4 | |a Cash management |x Mathematical models | |
| 650 | 4 | |a Cash flow |x Mathematical models | |
| 650 | 4 | |a Corporations |x Finance |x Mathematical models | |
| 650 | 0 | 7 | |a EXCEL |0 (DE-588)4138932-3 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Mathematisches Modell |0 (DE-588)4114528-8 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Cash Management |0 (DE-588)4122992-7 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a Cash Management |0 (DE-588)4122992-7 |D s |
| 689 | 0 | 1 | |a Mathematisches Modell |0 (DE-588)4114528-8 |D s |
| 689 | 0 | 2 | |a EXCEL |0 (DE-588)4138932-3 |D s |
| 689 | 0 | |5 DE-604 | |
| 856 | 4 | |u http://www.loc.gov/catdir/toc/ecip0619/2006025757.html |3 Table of contents only | |
| 856 | 4 | 2 | |m HBZ Datenaustausch |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=015508277&sequence=000006&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-015508277 | ||
Record in the Search Index
| _version_ | 1804136314776322048 |
|---|---|
| adam_text | Contents
Preface xi
Acknowledgments xiil
About the Author xv
Introduction 1
The Three Basic Elements of a Cash Flow Model 3
Inputs 3
Cash Flow Structure 4
Outputs 5
The Process of Building a Cash Flow Model 5
Plan and Design 5
Obtain All Necessary Information 6
Construct Basic Framework 6
Develop Advanced Structure 6
Validate Assumptions 6
Test Model 7
How This Book Is Designed 7
CHAPTHM
Dates and riming 9
Time Progression 9
Dates and Timing on the Inputs Sheet 10
Day Count Systems: 30/360 versus Actual/360 versus Actual/365 11
Model Builder 1.1: Inputs Sheet—Dates and Timing 12
Dates and Timing on the Cash Flow Sheet 14
Model Builder 1.2: Cash Flow Sheet—Dates and Timing 15
Toolbox 18
Naming Cells and Ranges 18
Data Validation Lists 19
ED ATE 21
V
yj CONTENTS
CHAPTK2
Asset Cash Flow Generation 28
Loan Level versus Representative Line Amortization 23
How Asset Generation Is Demonstrated in Model Builder 27
Asset Generation on the Inputs Sheet 27
Fixed Rate Amortization Inputs 28
Floating Rate Amortization Inputs 28
Model Builder 2.1: Inputs Sheet Asset Assumptions and the Vectors Sheet 29
Asset Generation on the Cash Flow Sheet 33
Model Builder 2.2: Notional Asset Amortization on the Cash Flow Sheet 33
Toolbox 39
OFFSET 39
MATCH 40
MOD 41
PMT 41
CHAPTB8
Prepayments 43
How Prepayments Are Tracked 43
SMM: Single Monthly Mortality 44
CPR: Conditional Prepayment Rate 44
PSA: Public Securities Association 44
ABS: Absolute Prepayment Speed 45
Historical Prepayment Data Formats 46
Building Prepayment Curves 46
Prepayment Curves in Project Model Builder 47
The Effect of Prepayments on Structured Transactions 48
Model Builder 3.1: Historical Prepayment Analysis and Creating a Projected
Prepayment Curve 48
Model Builder 3.2: Integrating Projected Prepayments in Asset Amortization 53
Toolbox 56
Weighted Averages Using SUMPRODUCT and SUM 56
CHAPTBM
Delinquency, Detautt, and Loss Analysts 59
Delinquencies versus Defaults versus Loss 59
The Importance of Analyzing Delinquency 60
Model Builder 4.1: Building Historical Delinquency Curves 62
Deriving Historical Loss Curves 64
Model Builder 4.2: Building Historical and Projected Loss Curves 67
Analyzing Historical Loss Curves 69
Model Builder 4.2 Continued 69
Contents Vfi
Projecting Loss Curves 70
Model Builder 4.2 Continued 71
Integrating Loss Projections 73
The Effects of Seasoning and Default Timing 75
Model Builder 4.3: Integrating Defaults in Asset Amortization 76
CHAPTHt5
Recoveries 83
Model Builder 5.1: Historical Recovery Analysis 85
Projecting Recoveries in a Cash Flow Model 86
Model Builder 5.2: Integrating Recoveries into Project Model Builder 87
Final Points Regarding Recoveries 88
CHAPTHt 6
Liabilities and the Cash Flow Waterfall 88
Priority of Payments and the Cash Flow Waterfall 89
The Movement of Cash for an Individual Liability 90
Types of Liabilities 91
Fees 91
Model Builder 6.1: Calculating Fees in the Waterfall 91
Interest 94
Model Builder 6.2: Calculating Interest in the Waterfall 95
Principal 100
Model Builder 6.3: Calculating Principal in the Waterfall 100
Understanding Basic Asset and Liability Interactions 105
CHAPTHt 7
Advanced Liability Structures: Triggers, Interest Rate Swaps, and Reserve Accounts 107
Triggers and Their Affect on the Liability Structure 107
Model Builder 7.1: Incorporating Triggers 108
Swaps 113
Model Builder 7.2: Incorporating a Basic Interest Rate Swap 114
Final Notes on Swaps 117
Reserve Accounts 117
Model Builder 7.3: Incorporating a Cash Funded Reserve Account 118
Conclusion of the Cash Flow Waterfall 122
Toolbox 123
AND and OR 123
CHAPTTS8
Analytics and Output Reporting 125
Internal Testing 125
Cash In versus Cash Out 125
Vl CONTENTS
Model Builder 8.1: Cash In versus Cash Out Test 126
Balances at Maturity 128
Model Builder 8.2: Balances at Maturity Tests 128
Asset Principal Check 129
Model Builder 8.3: Asset Principal Check Test 129
Performance Analytics 130
Monthly Yield 130
Model Builder 8.4: Calculating Monthly Yield 130
Calculating the Monthly Yield 132
Bond Equivalent Yield 133
Model Builder 8.5: Calculating Bond Equivalent Yield 133
Modified Duration 133
Model Builder 8.6: Calculating Modified Duration 134
Output Reporting 135
Model Builder 8.7: Creating the Output Report 136
The Importance of Testing and Output 140
Toolbox 140
Conditional Formatting 140
Goal Seek 141
Array Formulas 142
CHAPTER 9
Understanding the Mode) 145
The Complete Model in Review 145
Understanding the Effects of Increased Loss 147
Varying Principal Allocation Methodologies 150
Varying Prepayment Rates 151
Varying Loss Timing 152
Varying Recovery Rate and Lag 152
The Value of a Swap 153
Additional Testing 153
CHAPTHIIO
Automation Using Visual Baste ApplcaUons (VBA) 155
Conventions of This Chapter 155
The Visual Basic Editor 156
The Menu Bar 156
The Project Explorer and the Properties Window 157
VBA Code 157
Simple Automation for Printing and Goal Seek 158
Model Builder 10.1: Automating Print Procedures 158
Model Builder 10.2: Automating Goal Seek to Optimize Advance Rates 161
Contents ix
Understanding Looping to Automate the Analytics Sheet 164
Model Builder 10.3: Automating Goal Seek to Perform Transaction Analytics 164
Automated Scenario Generation 167
Model Builder 10.4: Creating a Transaction Scenario Generator 167
Working with Macros in Excel 173
CHAPTBH1
Conclusion 175
The Investment Banker s Perspective 175
The Investor s Perspective 176
The Issuer s Perspective 176
The Financial Guarantor s Perspective 177
The Big Picture Perspective 177
Appendix: Using This Book with Excel 2007 179
About the CD ROM 188
Index 188
|
| adam_txt |
Contents
Preface xi
Acknowledgments xiil
About the Author xv
Introduction 1
The Three Basic Elements of a Cash Flow Model 3
Inputs 3
Cash Flow Structure 4
Outputs 5
The Process of Building a Cash Flow Model 5
Plan and Design 5
Obtain All Necessary Information 6
Construct Basic Framework 6
Develop Advanced Structure 6
Validate Assumptions 6
Test Model 7
How This Book Is Designed 7
CHAPTHM
Dates and riming 9
Time Progression 9
Dates and Timing on the Inputs Sheet 10
Day Count Systems: 30/360 versus Actual/360 versus Actual/365 11
Model Builder 1.1: Inputs Sheet—Dates and Timing 12
Dates and Timing on the Cash Flow Sheet 14
Model Builder 1.2: Cash Flow Sheet—Dates and Timing 15
Toolbox 18
Naming Cells and Ranges 18
Data Validation Lists 19
ED ATE 21
V
yj CONTENTS
CHAPTK2
Asset Cash Flow Generation 28
Loan Level versus Representative Line Amortization 23
How Asset Generation Is Demonstrated in Model Builder 27
Asset Generation on the Inputs Sheet 27
Fixed Rate Amortization Inputs 28
Floating Rate Amortization Inputs 28
Model Builder 2.1: Inputs Sheet Asset Assumptions and the Vectors Sheet 29
Asset Generation on the Cash Flow Sheet 33
Model Builder 2.2: Notional Asset Amortization on the Cash Flow Sheet 33
Toolbox 39
OFFSET 39
MATCH 40
MOD 41
PMT 41
CHAPTB8
Prepayments 43
How Prepayments Are Tracked 43
SMM: Single Monthly Mortality 44
CPR: Conditional Prepayment Rate 44
PSA: Public Securities Association 44
ABS: Absolute Prepayment Speed 45
Historical Prepayment Data Formats 46
Building Prepayment Curves 46
Prepayment Curves in Project Model Builder 47
The Effect of Prepayments on Structured Transactions 48
Model Builder 3.1: Historical Prepayment Analysis and Creating a Projected
Prepayment Curve 48
Model Builder 3.2: Integrating Projected Prepayments in Asset Amortization 53
Toolbox 56
Weighted Averages Using SUMPRODUCT and SUM 56
CHAPTBM
Delinquency, Detautt, and Loss Analysts 59
Delinquencies versus Defaults versus Loss 59
The Importance of Analyzing Delinquency 60
Model Builder 4.1: Building Historical Delinquency Curves 62
Deriving Historical Loss Curves 64
Model Builder 4.2: Building Historical and Projected Loss Curves 67
Analyzing Historical Loss Curves 69
Model Builder 4.2 Continued 69
Contents Vfi
Projecting Loss Curves 70
Model Builder 4.2 Continued 71
Integrating Loss Projections 73
The Effects of Seasoning and Default Timing 75
Model Builder 4.3: Integrating Defaults in Asset Amortization 76
CHAPTHt5
Recoveries 83
Model Builder 5.1: Historical Recovery Analysis 85
Projecting Recoveries in a Cash Flow Model 86
Model Builder 5.2: Integrating Recoveries into Project Model Builder 87
Final Points Regarding Recoveries 88
CHAPTHt 6
Liabilities and the Cash Flow Waterfall 88
Priority of Payments and the Cash Flow Waterfall 89
The Movement of Cash for an Individual Liability 90
Types of Liabilities 91
Fees 91
Model Builder 6.1: Calculating Fees in the Waterfall 91
Interest 94
Model Builder 6.2: Calculating Interest in the Waterfall 95
Principal 100
Model Builder 6.3: Calculating Principal in the Waterfall 100
Understanding Basic Asset and Liability Interactions 105
CHAPTHt 7
Advanced Liability Structures: Triggers, Interest Rate Swaps, and Reserve Accounts 107
Triggers and Their Affect on the Liability Structure 107
Model Builder 7.1: Incorporating Triggers 108
Swaps 113
Model Builder 7.2: Incorporating a Basic Interest Rate Swap 114
Final Notes on Swaps 117
Reserve Accounts 117
Model Builder 7.3: Incorporating a Cash Funded Reserve Account 118
Conclusion of the Cash Flow Waterfall 122
Toolbox 123
AND and OR 123
CHAPTTS8
Analytics and Output Reporting 125
Internal Testing 125
Cash In versus Cash Out 125
Vl CONTENTS
Model Builder 8.1: Cash In versus Cash Out Test 126
Balances at Maturity 128
Model Builder 8.2: Balances at Maturity Tests 128
Asset Principal Check 129
Model Builder 8.3: Asset Principal Check Test 129
Performance Analytics 130
Monthly Yield 130
Model Builder 8.4: Calculating Monthly Yield 130
Calculating the Monthly Yield 132
Bond Equivalent Yield 133
Model Builder 8.5: Calculating Bond Equivalent Yield 133
Modified Duration 133
Model Builder 8.6: Calculating Modified Duration 134
Output Reporting 135
Model Builder 8.7: Creating the Output Report 136
The Importance of Testing and Output 140
Toolbox 140
Conditional Formatting 140
Goal Seek 141
Array Formulas 142
CHAPTER 9
Understanding the Mode) 145
The Complete Model in Review 145
Understanding the Effects of Increased Loss 147
Varying Principal Allocation Methodologies 150
Varying Prepayment Rates 151
Varying Loss Timing 152
Varying Recovery Rate and Lag 152
The Value of a Swap 153
Additional Testing 153
CHAPTHIIO
Automation Using Visual Baste ApplcaUons (VBA) 155
Conventions of This Chapter 155
The Visual Basic Editor 156
The Menu Bar 156
The Project Explorer and the Properties Window 157
VBA Code 157
Simple Automation for Printing and Goal Seek 158
Model Builder 10.1: Automating Print Procedures 158
Model Builder 10.2: Automating Goal Seek to Optimize Advance Rates 161
Contents ix
Understanding Looping to Automate the Analytics Sheet 164
Model Builder 10.3: Automating Goal Seek to Perform Transaction Analytics 164
Automated Scenario Generation 167
Model Builder 10.4: Creating a Transaction Scenario Generator 167
Working with Macros in Excel 173
CHAPTBH1
Conclusion 175
The Investment Banker's Perspective 175
The Investor's Perspective 176
The Issuer's Perspective 176
The Financial Guarantor's Perspective 177
The Big Picture Perspective 177
Appendix: Using This Book with Excel 2007 179
About the CD ROM 188
Index 188 |
| any_adam_object | 1 |
| any_adam_object_boolean | 1 |
| author | Allman, Keith A. 1977- |
| author_GND | (DE-588)173917089 |
| author_facet | Allman, Keith A. 1977- |
| author_role | aut |
| author_sort | Allman, Keith A. 1977- |
| author_variant | k a a ka kaa |
| building | Verbundindex |
| bvnumber | BV022298238 |
| callnumber-first | H - Social Science |
| callnumber-label | HG4028 |
| callnumber-raw | HG4028.C45 |
| callnumber-search | HG4028.C45 |
| callnumber-sort | HG 44028 C45 |
| callnumber-subject | HG - Finance |
| classification_rvk | QP 720 |
| ctrlnum | (OCoLC)71005745 (DE-599)BVBBV022298238 |
| dewey-full | 658.15/50285554 |
| dewey-hundreds | 600 - Technology (Applied sciences) |
| dewey-ones | 658 - General management |
| dewey-raw | 658.15/50285554 |
| dewey-search | 658.15/50285554 |
| dewey-sort | 3658.15 850285554 |
| dewey-tens | 650 - Management and auxiliary services |
| discipline | Wirtschaftswissenschaften |
| discipline_str_mv | Wirtschaftswissenschaften |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>02099nam a2200529zc 4500</leader><controlfield tag="001">BV022298238</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20160715 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">070305s2007 xxu |||| 00||| eng d</controlfield><datafield tag="010" ind1=" " ind2=" "><subfield code="a">2006025757</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0470042907</subfield><subfield code="c">paper/cdrom</subfield><subfield code="9">0-470-04290-7</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780470042908</subfield><subfield code="9">978-0-470-04290-8</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)71005745</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV022298238</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">aacr</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="044" ind1=" " ind2=" "><subfield code="a">xxu</subfield><subfield code="c">US</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-20</subfield><subfield code="a">DE-1102</subfield><subfield code="a">DE-1049</subfield><subfield code="a">DE-706</subfield><subfield code="a">DE-945</subfield><subfield code="a">DE-2070s</subfield></datafield><datafield tag="050" ind1=" " ind2="0"><subfield code="a">HG4028.C45</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">658.15/50285554</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">QP 720</subfield><subfield code="0">(DE-625)141929:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Allman, Keith A.</subfield><subfield code="d">1977-</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)173917089</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Modeling structured finance cash flows with Microsoft Excel</subfield><subfield code="b">a step-by-step guide</subfield><subfield code="c">Keith A. Allman</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Hoboken, N.J.</subfield><subfield code="b">Wiley</subfield><subfield code="c">2007</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XV, 199 S.</subfield><subfield code="e">1 CD-ROM (12 cm)</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="490" ind1="0" ind2=" "><subfield code="a">Wiley finance series</subfield></datafield><datafield tag="630" ind1="0" ind2="4"><subfield code="a">Microsoft Excel (Computer file)</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Cash-flow</subfield><subfield code="2">gtt</subfield></datafield><datafield tag="650" ind1=" " ind2="7"><subfield code="a">Spreadsheets</subfield><subfield code="2">gtt</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Mathematisches Modell</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Cash management</subfield><subfield code="x">Mathematical models</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Cash flow</subfield><subfield code="x">Mathematical models</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Corporations</subfield><subfield code="x">Finance</subfield><subfield code="x">Mathematical models</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">EXCEL</subfield><subfield code="0">(DE-588)4138932-3</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Mathematisches Modell</subfield><subfield code="0">(DE-588)4114528-8</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Cash Management</subfield><subfield code="0">(DE-588)4122992-7</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">Cash Management</subfield><subfield code="0">(DE-588)4122992-7</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="1"><subfield code="a">Mathematisches Modell</subfield><subfield code="0">(DE-588)4114528-8</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="2"><subfield code="a">EXCEL</subfield><subfield code="0">(DE-588)4138932-3</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="856" ind1="4" ind2=" "><subfield code="u">http://www.loc.gov/catdir/toc/ecip0619/2006025757.html</subfield><subfield code="3">Table of contents only</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">HBZ Datenaustausch</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=015508277&sequence=000006&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-015508277</subfield></datafield></record></collection> |
| id | DE-604.BV022298238 |
| illustrated | Not Illustrated |
| index_date | 2024-07-02T16:54:10Z |
| indexdate | 2024-07-09T20:54:26Z |
| institution | BVB |
| isbn | 0470042907 9780470042908 |
| language | English |
| lccn | 2006025757 |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-015508277 |
| oclc_num | 71005745 |
| open_access_boolean | |
| owner | DE-20 DE-1102 DE-1049 DE-706 DE-945 DE-2070s |
| owner_facet | DE-20 DE-1102 DE-1049 DE-706 DE-945 DE-2070s |
| physical | XV, 199 S. 1 CD-ROM (12 cm) |
| publishDate | 2007 |
| publishDateSearch | 2007 |
| publishDateSort | 2007 |
| publisher | Wiley |
| record_format | marc |
| series2 | Wiley finance series |
| spelling | Allman, Keith A. 1977- Verfasser (DE-588)173917089 aut Modeling structured finance cash flows with Microsoft Excel a step-by-step guide Keith A. Allman Hoboken, N.J. Wiley 2007 XV, 199 S. 1 CD-ROM (12 cm) txt rdacontent n rdamedia nc rdacarrier Wiley finance series Microsoft Excel (Computer file) Cash-flow gtt Spreadsheets gtt Mathematisches Modell Cash management Mathematical models Cash flow Mathematical models Corporations Finance Mathematical models EXCEL (DE-588)4138932-3 gnd rswk-swf Mathematisches Modell (DE-588)4114528-8 gnd rswk-swf Cash Management (DE-588)4122992-7 gnd rswk-swf Cash Management (DE-588)4122992-7 s Mathematisches Modell (DE-588)4114528-8 s EXCEL (DE-588)4138932-3 s DE-604 http://www.loc.gov/catdir/toc/ecip0619/2006025757.html Table of contents only HBZ Datenaustausch application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=015508277&sequence=000006&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Allman, Keith A. 1977- Modeling structured finance cash flows with Microsoft Excel a step-by-step guide Microsoft Excel (Computer file) Cash-flow gtt Spreadsheets gtt Mathematisches Modell Cash management Mathematical models Cash flow Mathematical models Corporations Finance Mathematical models EXCEL (DE-588)4138932-3 gnd Mathematisches Modell (DE-588)4114528-8 gnd Cash Management (DE-588)4122992-7 gnd |
| subject_GND | (DE-588)4138932-3 (DE-588)4114528-8 (DE-588)4122992-7 |
| title | Modeling structured finance cash flows with Microsoft Excel a step-by-step guide |
| title_auth | Modeling structured finance cash flows with Microsoft Excel a step-by-step guide |
| title_exact_search | Modeling structured finance cash flows with Microsoft Excel a step-by-step guide |
| title_exact_search_txtP | Modeling structured finance cash flows with Microsoft Excel a step-by-step guide |
| title_full | Modeling structured finance cash flows with Microsoft Excel a step-by-step guide Keith A. Allman |
| title_fullStr | Modeling structured finance cash flows with Microsoft Excel a step-by-step guide Keith A. Allman |
| title_full_unstemmed | Modeling structured finance cash flows with Microsoft Excel a step-by-step guide Keith A. Allman |
| title_short | Modeling structured finance cash flows with Microsoft Excel |
| title_sort | modeling structured finance cash flows with microsoft excel a step by step guide |
| title_sub | a step-by-step guide |
| topic | Microsoft Excel (Computer file) Cash-flow gtt Spreadsheets gtt Mathematisches Modell Cash management Mathematical models Cash flow Mathematical models Corporations Finance Mathematical models EXCEL (DE-588)4138932-3 gnd Mathematisches Modell (DE-588)4114528-8 gnd Cash Management (DE-588)4122992-7 gnd |
| topic_facet | Microsoft Excel (Computer file) Cash-flow Spreadsheets Mathematisches Modell Cash management Mathematical models Cash flow Mathematical models Corporations Finance Mathematical models EXCEL Cash Management |
| url | http://www.loc.gov/catdir/toc/ecip0619/2006025757.html http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=015508277&sequence=000006&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT allmankeitha modelingstructuredfinancecashflowswithmicrosoftexcelastepbystepguide |