Video |
Using the Fixed vs Variable Breakeven Excel Model (12min) |
Cashflow Modeling |
NA |
Intermediate |
Video |
Unique |
Productivity |
Utilities |
Basic |
Video |
The Linear Algebra of Bond Structuring (Intro) (24min) |
Bond Structuring |
NA |
Propellerhead |
Video |
Structure Bonds |
Productivity |
Utilities |
Basic |
PPT Show |
Stage I Outputs |
Debt Profiling |
Stage I |
Basic |
Video |
Simulate Rates |
Productivity |
Utilities |
Basic |
Video |
Rate Modeling for Tax-exempt Capital Structure Analysis (15min) |
Cashflow Modeling |
NA |
Intermediate |
Excel |
PV Savings for Refundings - Single Rate and Zero Methods Compared |
Bond Structuring |
NA |
Intermediate |
Video |
Optimization in Bond Structuring - Intro (13min) |
Bond Structuring |
NA |
Propellerhead |
Video |
Notional |
Productivity |
Utilities |
Basic |
Excel |
Muni Yield Calculation Using Newton's Method |
Bond Structuring |
NA |
Basic |
Video |
Interpolate |
Productivity |
Utilities |
Basic |
Video |
Identifying the Muni Borrower for Debt Profiles (14min) |
Debt Profiling |
Stage I |
Basic |
Video |
How to Enter Bonds, Swaps and Investments in SmartModels |
Cashflow Modeling |
SmartModels |
Basic |
Excel |
Fixed vs Variable Breakeven Analysis |
Cashflow Modeling |
NA |
Basic |
Excel |
Excel Sizing Model - Level Debt Service |
Bond Structuring |
NA |
Intermediate |
Video |
Excel Muni Yield Calculation Using Newton's Method (9min) |
Bond Structuring |
NA |
Basic |
Video |
Entering New Bond Information (7min) |
Bond Structuring |
Structure |
Basic |
Video |
Entering Existing Bond Information (9min) |
Bond Structuring |
Structure |
Basic |
Video |
Entering Basic Date and Bond Info in SmartModels |
Cashflow Modeling |
SmartModels |
Basic |
PPT Show |
Debt Profile Reports |
Debt Profiling |
Stage I |
Basic |
Video |
Cashflow Risk Statistics for Tax-Exempt Risk Management (13min) |
Cashflow Modeling |
NA |
Intermediate |
Excel |
Cashflow Model Example |
Cashflow Modeling |
NA |
Intermediate |
Video |
Building Excel Sizing Model for $100MM Project, 20Y Level Debt Service Muni Bond (17min) |
Bond Structuring |
NA |
Intermediate |
Video |
Bootstrap |
Productivity |
Utilities |
Basic |
Video |
Bond Sizing - Linear Optimization (25min) |
Bond Structuring |
NA |
Propellerhead |
Excel |
Better Debt Service Charts |
Visualization |
NA |
Basic |
Video |
Basic Bond Solutions (17min) |
Bond Structuring |
Structure |
Basic |
Excel |
Banker's Dozen - Debt Profiling Quiz Basic |
Debt Profiling |
NA |
Basic |
Excel |
Banker's Dozen - Debt Profiling Quiz Advanced |
Debt Profiling |
NA |
Intermediate |
Excel |
Banker's Dozen - Basic Quiz on Stage I |
Debt Profiling |
Stage I |
Basic |
Video |
Annualize |
Productivity |
Utilities |
Basic |
PPT Show |
Adding and Modifying Data |
Debt Profiling |
Stage I |
Basic |
PDF |
50 Years of Refunding History Results |
Refunding |
Refund |
Basic |