Modeling Structured Finance Cash Flows with Microsoft Excel
...
Introduction T he basic idea behind any financial model is to bring order and understanding to the numerous variables and comple ...
2 MODELING STRUCTURED FINANCE CASH FLOWS WITH MICROSOFT EXCEL â– Infrastructure (toll road, airport, etc.) â– Resources (oil, timber ...
Introduction 3 the deal on his or her own. A law firm may want to know if a certain legal structure works in practice. All of th ...
4 MODELING STRUCTURED FINANCE CASH FLOWS WITH MICROSOFT EXCEL 1.Basic global inputs such as dates and timing. 2.Common asset inp ...
Introduction 5 cash flow structure chapters. The idea to understand is that the model being created often has a dynamic cash flo ...
6 MODELING STRUCTURED FINANCE CASH FLOWS WITH MICROSOFT EXCEL Obtain All Necessary Information The more information available to ...
Introduction 7 Test Model The final step is to test the model. This goes beyond the tests that were set up in the basic framewor ...
8 MODELING STRUCTURED FINANCE CASH FLOWS WITH MICROSOFT EXCEL working Project Model Builder —ProjectModelBuilderComplete Model.x ...
CHAPTER CHAPTER 1 Dates and Timing T he importance of dates and timing could not resonate more strongly than in the field of fin ...
10 MODELING STRUCTURED FINANCE CASH FLOWS WITH MICROSOFT EXCEL FIGURE 1.1 Notice that there are only 256 columns on a sheet, end ...
Dates and Timing 11 Day-Count Systems: 30/360 versus Actual/360 versus Actual/365 Day-count systems evolved due to the nuances o ...
12 MODELING STRUCTURED FINANCE CASH FLOWS WITH MICROSOFT EXCEL FIGURE 1.2 A different fraction of time exists for the period Jan ...
Dates and Timing 13 FIGURE 1.3 Basic inputs for dates and timing. 3.Moving under the transaction name in cell B3, input the titl ...
14 MODELING STRUCTURED FINANCE CASH FLOWS WITH MICROSOFT EXCEL terms because there are many functions in Excel that can adjust d ...
Dates and Timing 15 FIGURE 1.4 Time will progress vertically in this model. FIGURE 1.5 The beginning of the dates and timing sec ...
16 MODELING STRUCTURED FINANCE CASH FLOWS WITH MICROSOFT EXCEL of these cells, left click and hold down the small square on the ...
Dates and Timing 17 year. As mentioned earlier, depending on the type of day count system that is selected there can be varying ...
18 MODELING STRUCTURED FINANCE CASH FLOWS WITH MICROSOFT EXCEL FIGURE 1.6 The completed dates and timing section on the Cash Flo ...
Dates and Timing 19 FIGURE 1.7 The active cell is C4 which shows the value in the Formula Bar and the cell name in the Name Box. ...
«
1
2
3
4
5
6
7
8
9
10
»
Free download pdf
