Page 67 - Oxford West Investor Quarterly Report Academic Year 2021-2022 Quarter 2
P. 67
Oxford West Properties I, LLLP
13 Month Trend Report
Managed by RISE Residential
As of December 31, 2021
Prior Year Rolling 12
12/31/2020 12/31/2021 11/30/2021 10/31/2021 09/30/2021 08/31/2021 07/31/2021 06/30/2021 05/31/2021 04/30/2021 03/31/2021 02/28/2021 01/31/2021 Month Total
OTHER FINANCE RELATED
6899 - Other Financial Expense 0 5 0 5 0 0 168 10 10 5 0 0 0 203
TOTAL OTHER FINANCE RELATED 0 5 0 5 0 0 168 10 10 5 0 0 0 203
TOTAL NON-CONTROLLABLE EX- 0 5 0 5 0 0 168 10 10 5 0 0 0 203
PENSES
CASH FLOW BEFORE DEBT SERVICE 159,153 142,283 126,372 140,104 120,859 (51,839) 116,151 122,281 141,482 128,763 162,398 118,772 168,701 1,436,327
DEBT SERVICE
6820 - Interest Expense 116,666 116,666 120,555 116,667 120,556 120,556 116,667 120,556 116,667 120,555 108,888 120,555 120,556 1,419,445
TOTAL DEBT SERVICE 116,666 116,666 120,555 116,667 120,556 120,556 116,667 120,556 116,667 120,555 108,888 120,555 120,556 1,419,445
CASH FLOW AFTER DEBT SERVICE 42,487 25,617 5,817 23,437 303 (172,395) (516) 1,725 24,815 8,208 53,510 (1,783) 48,145 16,883
RESERVES
1320 - Replacement Reserve Fund 9,084 9,084 9,084 (18,464) 9,083 9,083 (85,852) 9,083 9,083 9,083 9,084 9,084 9,083 (13,483)
TOTAL RESERVES 9,084 9,084 9,084 (18,464) 9,083 9,083 (85,852) 9,083 9,083 9,083 9,084 9,084 9,083 (13,483)
CAPITAL EXPENDITURES
1523 - Capital HVAC 0 0 0 0 0 771 772 0 0 0 0 0 0 1,544
1526 - Carpet/Vinyl Replacement 0 0 0 0 0 37,990 0 0 0 0 0 0 5,032 43,021
1533 - Appliances 0 1,858 716 0 1,522 1,048 0 1,175 0 2,651 998 0 1,726 11,694
1551 - Grounds & Landscaping 0 0 0 0 0 0 0 0 0 0 0 0 1,172 1,171
1575 - Plumbing 0 0 0 0 0 4,152 0 0 0 0 2,515 0 0 6,668
1585 - Roof & Gutters 0 0 0 1,300 0 0 0 0 0 0 0 0 725 2,025
TOTAL CAPITAL EXPENDITURES 0 1,858 716 1,300 1,522 43,961 772 1,175 0 2,651 3,513 0 8,655 66,123
CASH FLOW BEFORE DEPREC/AMORT 33,403 14,675 (3,983) 40,601 (10,302) (225,439) 84,564 (8,533) 15,732 (3,526) 40,913 (10,867) 30,408 (35,757)
DEPRECIATION/AMORTIZATION
8000 - Depreciation - FF&E 8,144 9,396 9,341 9,342 9,316 8,583 8,570 8,551 8,551 9,261 8,323 8,322 8,282 105,839
8005 - Deprec Expense-Building 68,382 68,383 68,383 68,382 68,383 68,383 68,383 68,382 68,383 68,382 68,382 68,383 68,382 820,590
8006 - Amortization-Loan Fees 10,416 10,416 10,416 10,416 10,416 10,416 10,416 10,417 10,416 10,417 10,416 10,416 10,416 124,995
TOTAL DEPREC/AMORT 86,942 88,195 88,140 88,140 88,115 87,382 87,369 87,350 87,350 88,060 87,121 87,121 87,080 1,051,424
OTHER EXPENSES
8515 - Other Professional Fees 0 0 0 0 0 0 0 0 0 0 0 0 2,000 2,000
8516 - Legal and Professional Fee 0 0 0 0 0 0 0 0 0 0 0 4,020 0 4,019
8517 - Audit/Tax Return Fees 0 7,645 0 0 0 0 0 0 10,410 0 0 0 0 18,055
TOTAL OTHER EXPENSES 0 7,645 0 0 0 0 0 0 10,410 0 0 4,020 2,000 24,074
Page 33