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

Oxford West Properties I, LLLP
Managed by RISE Residential
Budget Comparison Report

Current
Current Month 12/31/2021 Prior Yr Current Mo. 12/31/2020 Year to Date 12/31/2021 Prior Year YTD 12/31/2020 Fiscal Yr.
Actual Budget Variance Actual Variance Actual Budget Variance Actual Variance Budget
DEBT SERVICE 116,666 116,666 0 116,666 0 595,000 583,330 (11,670) 598,889 3,889 1,399,992

CASH FLOW AFTER DEBT SERVICE 25,617 22,770 2,847 42,487 16,870 (117,221) (116,834) (387) (60,912) 56,308 499
RESERVES 9,084 9,083 0 9,084 0 17,869 45,417 27,547 45,417 27,547 109,000
CAPITAL EXPENDITURES 1,858 0 (1,858) 0 (1,858) 49,358 44,100 (5,257) 97,008 47,650 44,100
CASH FLOW BEFORE DEPREC/AMORT 14,675 13,687 989 33,403 18,728 (184,448) (206,351) 21,903 (203,337) (18,889) (152,601)

DEPRECIATION/AMORTIZATION 88,195 86,735 (1,461) 86,942 (1,253) 439,973 433,671 (6,302) 428,649 (11,324) 1,040,812
OTHER EXPENSES 7,645 7,645 0 0 (7,645) 7,645 7,645 0 0 (7,645) 7,645
CASH FLOW AFTER DEPREC/AMORT AND OTHER (81,165) (80,693) (472) (53,539) 27,626 (632,066) (647,667) 15,601 (631,986) 80 (1,201,058)
EXP.

RECONCILIATION TO GAAP NET INCOME (LOSS)
CAPITAL EXPENDITURES (1,858) 0 (1,858) 0 1,858 (49,358) (44,100) (5,258) (97,008) (47,650) (44,100)
RESERVES (9,083) (9,083) 0 (9,083) 0 (17,869) (45,417) 27,548 (45,417) (27,548) (109,000)

GAAP NET INCOME (LOSS) (70,224) (71,609) 1,385 (44,456) 25,768 (564,839) (558,151) (6,688) (489,562) 75,277 (1,047,958)

DEBT COVERAGE RATIO 1.22 1.20 0.02 1.36 0.14 0.80 0.80 0.00 0.90 0.10 1.00