Page 45 - Oxford West Investor Quarterly Report Academic Year 2021-2022 Quarter 2

Oxford West Properties I, LLLP

Financial Analysis Report
Managed by RISE Residential
As of December 31, 2021

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 Budget Budget Budget Budget Budget Budget Budget Act/Bud Budget Variance

OTHER FINANCE RELATED
6899 - Other Financial Expense 0 0 5 0 5 0 0 0 0 0 0 0 10 0 10
TOTAL OTHER FINANCE RELATED 0 0 5 0 5 0 0 0 0 0 0 0 10 0 10

TOTAL NON-CONTROLLABLE EX- 0 0 5 0 5 0 0 0 0 0 0 0 10 0 10
PENSES
CASH FLOW BEFORE DEBT SERVICE (51,839) 120,859 140,104 126,372 142,283 136,131 142,598 154,823 114,712 124,234 141,611 119,885 1,411,774 1,400,491 11,283

DEBT SERVICE
6820 - Interest Expense 120,556 120,556 116,667 120,555 116,666 116,666 116,666 116,666 116,666 116,666 116,666 116,666 1,411,662 1,399,992 11,670
TOTAL DEBT SERVICE 120,556 120,556 116,667 120,555 116,666 116,666 116,666 116,666 116,666 116,666 116,666 116,666 1,411,662 1,399,992 11,670
CASH FLOW AFTER DEBT SERVICE (172,395) 303 23,437 5,817 25,617 19,465 25,932 38,157 (1,954) 7,568 24,945 3,219 112 499 (387)

RESERVES
1320 - Replacement Reserve Fund 9,083 9,083 (18,464) 9,084 9,084 9,084 9,083 9,084 9,083 9,083 9,083 9,083 81,452 109,000 (27,547)
TOTAL RESERVES 9,083 9,083 (18,464) 9,084 9,084 9,084 9,083 9,084 9,083 9,083 9,083 9,083 81,452 109,000 (27,547)

CAPITAL EXPENDITURES
1523 - Capital HVAC 771 0 0 0 0 0 0 0 0 0 0 0 772 1,000 (229)
1526 - Carpet/Vinyl Replacement 37,990 0 0 0 0 0 0 0 0 0 0 0 37,989 38,000 (10)
1533 - Appliances 1,048 1,522 0 716 1,858 0 0 0 0 0 0 0 5,145 1,000 4,144
1575 - Plumbing 4,152 0 0 0 0 0 0 0 0 0 0 0 4,152 4,100 53
1585 - Roof & Gutters 0 0 1,300 0 0 0 0 0 0 0 0 0 1,300 0 1,300
TOTAL CAPITAL EXPENDITURES 43,961 1,522 1,300 716 1,858 0 0 0 0 0 0 0 49,358 44,100 5,258

CASH FLOW BEFORE DEPREC/ (225,439) (10,302) 40,601 (3,983) 14,675 10,381 16,849 29,073 (11,037) (1,515) 15,862 (5,864) (130,699) (152,601) 21,903
AMORT

DEPRECIATION/AMORTIZATION
8000 - Depreciation - FF&E 8,583 9,316 9,342 9,341 9,396 7,935 7,936 7,935 7,936 7,936 7,936 7,936 101,529 95,228 6,301
8005 - Deprec Expense-Building 68,383 68,383 68,382 68,383 68,383 68,383 68,382 68,383 68,382 68,382 68,382 68,382 820,589 820,589 0
8006 - Amortization-Loan Fees 10,416 10,416 10,416 10,416 10,416 10,416 10,416 10,416 10,417 10,416 10,416 10,416 124,995 124,995 0
TOTAL DEPREC/AMORT 87,382 88,115 88,140 88,140 88,195 86,734 86,734 86,734 86,735 86,734 86,734 86,734 1,047,113 1,040,812 6,301
OTHER EXPENSES
8517 - Audit/Tax Return Fees 0 0 0 0 7,645 0 0 0 0 0 0 0 7,645 7,645 0
TOTAL OTHER EXPENSES 0 0 0 0 7,645 0 0 0 0 0 0 0 7,645 7,645 0
CASH FLOW AFTER DEPREC/AMORT (312,821) (98,417) (47,539) (92,123) (81,165) (76,353) (69,885) (57,661) (97,772) (88,249) (70,872) (92,598) (1,185,457) (1,201,058) 15,601

Page 22