to home page  Home   E-Mail  SiteTree (all case studies)    Help (this page)    HomePage    Index (this case study)    AVI    ALTI    Format418    Format417    Format422    Format425    Format420    Format408    Format409    demodata    Format412    Format410    Format402    Format424    Format428    Format401    Format421    Format426    Format404    Format405    Format406    Format413    Format415    Format416    Format429    MV    sitemap    weblinks    whatsnew   

Guggenheim Demo:Trial 8: Table 19, page 113

Schedule C: Residual Values & IROR's

  Trial 1: Table 12, page 106 Trial 2: Table 13, page 107 Trial 3: Table 14, page 108 Trial 4: Table 15, page 109 Trial 5: Table 16, page 110 Trial 6: Table 17, page 111 Trial 7: Table 18, page 112 Trial 8: Table 19, page 113
PROJECT                
165 Capitalized Cost (TCC) 90000 90000 90000 90000 90000 90000 90000 90000
190 Residual Value 90000 90000 90000 90000 90000 90000 90000 90000
195 Land Residual 18000 18000 18000 18000 18000 18000 18000 18000
670 Mtge Amortization 29869 29869 29869 29869 29869 29869 29869 29869
710 Depreciation 49205 49205 49205 49205 49205 49205 49205 49205
                 
Developer                
1 196 Equity Residual 60131 60131 60131 60131 60131 60131 60131 60131
1 916 Pre-Tax Present Value 12840 12840 12840 12840 12840 12840 12840 12840
1 926 Pre-Tax Net Cash 67607 67607 67607 67607 67607 67607 67607 67607
                 
Lender                
2 670 Mtge Amortization 29869 29869 29869 29869 29869 29869 29869 29869
2 916 Pre-Tax Present Value -10279 -10279 -10279 -10279 -10279 -10279 -10279 -10279
2 926 Pre-Tax Net Cash 40109 40109 40109 40109 40109 40109 40109 40109
                 
Investor                
3 916 Pre-Tax Present Value -45000 -45000 -45000 -45000 -45000 -45000 -45000 -45000
3 926 Pre-Tax Net Cash -50400 -50400 -50400 -50400 -50400 -50400 -50400 -50400
                 
All Participants                
99 916 Pre-Tax Present Value -42440 -42440 -42440 -42440 -42440 -42440 -42440 -42440
99 926 Pre-Tax Net Cash 57316 57316 57316 57316 57316 57316 57316 57316
                 
Developer                
1 936 IROR Pre-Tax                
1 938 FMRR Pre-Tax                
                 
Lender                
2 936 IROR Pre-Tax 7.45 7.45 7.45 7.45 7.45 7.45 7.45 7.45
2 938 FMRR Pre-Tax 8.3 8.3 8.3 8.3 8.3 8.3 8.3 8.3
                 
Investor                
3 936 IROR Pre-Tax                
3 938 FMRR Pre-Tax                
                 
All Participants                
99 936 IROR Pre-Tax 4.25 4.25 4.25 4.25 4.25 4.25 4.25 4.25
99 938 FMRR Pre-Tax 5.91 5.91 5.91 5.91 5.91 5.91 5.91 5.91



 Home   E-Mail  home at CD root