Page 46 - Preserve at Tech Investor Quarterly Report Academic Year 2021-2022 Quarter 2
P. 46

Ruston Properties I, LLC
    The Preserve at Tech
                                                                                    Financial Analysis Report
                                                                                         Managed by RISE Residential
                                                                                          As of January 31, 2022

                                        08/31/2021 09/30/2021 10/31/2021 11/30/2021 12/31/2021 01/31/2022 02/28/2022 03/31/2022 04/30/2022 05/31/2022 06/30/2022 07/31/2022  Total  Original
                                              Actual    Actual    Actual     Actual    Actual     Actual   Budget     Budget    Budget     Budget    Budget    Budget    Act/Bud    Budget   Variance
     REVENUE

       GROSS RENTAL INCOME                358,680    361,429   359,732    361,254   360,948   366,275    358,680   358,680    358,680   358,680   358,680    358,680  4,320,398  4,369,581  (49,183)
       COST OF LEASING                    (183,320)  (130,485)  (112,618)  (115,609)  (109,488)  (115,020)  (116,312)  (116,312)  (116,312)  (116,312)  (116,312)  (116,312) (1,464,410) (1,545,063)  80,653
       NET RENTAL INCOME                  175,360    230,944   247,114    245,645   251,460   251,255    242,368   242,368    242,368   242,368   242,368    242,368  2,855,988  2,824,518   31,470

       OTHER INCOME                         5,494     12,809    40,340     16,805    21,598    22,322     14,352    14,602     14,637    15,102    16,602     16,637   211,300    159,832    51,468
     TOTAL INCOME                         180,854    243,753   287,454    262,450   273,058   273,577    256,720   256,970    257,005   257,470   258,970    259,005  3,067,288  2,984,350   82,938

     CONTROLLABLE EXPENSES
       PAYROLL OFFICE                      13,197     12,976    12,133     13,370    11,300    11,202     18,572    13,372     13,372    18,572    13,872     13,872   165,814    182,125   (16,310)
       PAYROLL MAINTENANCE                    611      7,229     7,985      7,325     7,649     6,922     11,007    11,007     11,007    11,007    11,507     11,507   104,761    119,217   (14,457)
       PAYROLL RELATED EXPENSES             2,958      3,907     3,899      4,159     3,896     2,944      5,553     4,833      4,833     5,553     4,972      4,972    52,478     60,512    (8,034)
       TOTAL PAYROLL                       16,766     24,112    24,017     24,854    22,845    21,068     35,132    29,212     29,212    35,132    30,351     30,351   323,053    361,854   (38,801)

       GENERAL & ADMINISTRATIVE            10,420      9,647    10,122      8,074     8,799    10,385      9,776    12,081      9,876     9,276    11,451      9,526   119,435    129,783   (10,348)
       PROFESSIONAL FEES                      666       667      1,677       696       667        667       667        667       667       667        666       666      9,040      8,000     1,040
       CONTRACT SERVICES                    4,507     13,294    17,290     21,226     5,988    13,348     14,725    16,725     14,725    14,725    14,725     14,725   166,002    208,280   (42,278)
       TURNOVER EXPENSE                     4,893         0         66       762       164         80       260        260       260       610        260      2,110     9,725      9,470      255
       REPAIRS & MAINTENANCE               13,178       343      5,725      2,696     1,417     1,113      2,793       375      3,386      967        686      7,875    40,556     33,967     6,589
       MARKETING & LEASING                 52,150      5,053    13,411      5,437    12,277     6,077      6,502    10,825     13,952    14,552    11,125     10,502   161,860    169,123    (7,263)
       UTILITIES                           30,379     29,028    19,750     18,662    17,864    16,818     33,190    33,190     33,190    33,190    33,190     33,190   331,644    388,216   (56,572)
       MANAGEMENT FEES                      6,330      8,374     8,967      9,156    10,711     9,195      8,985     8,994      8,995     9,012     9,064      9,066   106,845    104,452     2,394

     TOTAL CONTROLLABLE EXPENSES          139,289     90,518   101,025     91,563    80,732    78,751    112,030   112,329    114,263   118,131   111,518    118,011  1,268,160  1,413,145  (144,984)

     CONTROLLABLE CASH FLOW                41,565    153,236   186,429    170,887   192,326   194,826    144,690   144,641    142,742   139,339   147,452    140,994  1,799,128  1,571,205  227,923
     TAXES & INSURANCE                     20,772     21,401    25,990     25,990   (42,708)   26,065     21,402    21,401     21,401    21,401    21,402     21,401   205,921    256,816   (50,895)

     NET OPERATING INCOME                  20,793    131,835   160,439    144,897   235,034   168,761    123,288   123,240    121,341   117,938   126,050    119,593  1,593,208  1,314,389  278,819
     CASH FLOW BEFORE DEBT SERVICE         20,793    131,835   160,439    144,897   235,034   168,761    123,288   123,240    121,341   117,938   126,050    119,593  1,593,208  1,314,389  278,819

     DEBT SERVICE                               0         0     61,439     64,294    61,764    63,824     69,613    69,614     69,614    69,613    69,613     69,613   669,001    696,136   (27,135)
     CASH FLOW AFTER DEBT SERVICE          20,793    131,835    99,000     80,603   173,270   104,937     53,675    53,626     51,727    48,325    56,437     49,980   924,206    618,253   305,953

     EXTRAORDINARY EXPENSE                      0         0          0       949         0          0         0          0         0         0          0         0        949         0       949
     CAPITAL EXPENDITURES                       0      3,963         0         0         0          0         0      5,000         0         0          0         0      8,963     10,100    (1,137)


                                                                                                                                                                                                  Page 22
   41   42   43   44   45   46   47   48   49   50   51