Operating Forecast table adapted for Visualization Purposes

Mortgage Table Adapted for Visualization Purposes

Effective Gross Income

Total Operating Expenses

Net Operating Income

Distributable FCF

Net FCF from Operations

FCF from Refinance/Sale

Income and Expenses Over Years

FCF Distribution Over Years

Interest Expense and Principal Repayment

Starting and Ending Balance

Operating Forecast Summary

      year       Units Upgraded  Effective Gross Income 
 Min.   : 1.00   Min.   : 0.0    Min.   : 110000        
 1st Qu.: 3.25   1st Qu.: 0.0    1st Qu.: 910175        
 Median : 5.50   Median : 0.0    Median : 951658        
 Mean   : 5.50   Mean   : 6.2    Mean   : 825310        
 3rd Qu.: 7.75   3rd Qu.: 0.0    3rd Qu.: 995007        
 Max.   :10.00   Max.   :54.0    Max.   :1040304        
                                                        
 Total Operating Expenses  Net Operating Income  Net FCF from Operations 
 Min.   :    0             Min.   :110000        Min.   :-43378          
 1st Qu.:40334             1st Qu.:869841        1st Qu.:766356          
 Median :43692             Median :907967        Median :830144          
 Mean   :37879             Mean   :787431        Mean   :706696          
 3rd Qu.:47279             3rd Qu.:947728        3rd Qu.:898291          
 Max.   :51113             Max.   :989191        Max.   :971149          
                                                                         
 FCF from Refinance/Sale  FCF Reinvestment for Capex Distributable FCF 
 Min.   :-207244          Min.   : NA                Min.   : 34591    
 1st Qu.:-188408          1st Qu.: NA                1st Qu.:610692    
 Median :-176773          Median : NA                Median :658880    
 Mean   :-175605          Mean   :NaN                Mean   :568060    
 3rd Qu.:-162410          3rd Qu.: NA                3rd Qu.:709883    
 Max.   :-141468          Max.   : NA                Max.   :763905    
                          NA's   :10                                   

Mortgage Summary

   month_year         Interest.Expense Starting.Balance  Principal.Repayment
 Min.   :2019-05-01   Min.   :  62     Min.   :  17608   Min.   :11561      
 1st Qu.:2021-10-24   1st Qu.:1820     1st Qu.: 513958   1st Qu.:12844      
 Median :2024-04-16   Median :3402     Median : 960759   Median :14268      
 Mean   :2024-04-16   Mean   :3295     Mean   : 930487   Mean   :14375      
 3rd Qu.:2026-10-08   3rd Qu.:4827     3rd Qu.:1362955   3rd Qu.:15850      
 Max.   :2029-04-01   Max.   :6109     Max.   :1725000   Max.   :17608      
 Ending.Balance   
 Min.   :      0  
 1st Qu.: 498108  
 Median : 946491  
 Mean   : 916112  
 3rd Qu.:1350112  
 Max.   :1713439