Page 82 - Property Summary Guardian Place 1 12 2022 Reduced File - With Cover Pages
P. 82
GUARDIAN PLACE II LP
OPERATING CASH FLOW 2021
ACTUAL ACTUAL ACTUAL ACTUAL ACTUAL ACTUAL ACTUAL ACTUAL Actual ACTUAL FCST FCST YEAR TO
JANUARY FEBRUARY MARCH APRIL MAY JUNE JULY AUGUST SEPTEMBER OCTOBER NOVEMBER DECEMBER DATE
RENTAL INCOME 101,564.73 110,143.00 $ 107,481.61 $ 111,277.70 $ 107,982.00 109,895.84 109,404.70 108,046.88 109,721.00 109,665.44 107,020.00 106,756.00 1,298,958.90
MISCELLANEOUS INCOME 997.00 1,913.10 $ 1,547.75 $ 1,351.50 $ 1,735.15 1,484.08 1,574.00 1,423.00 1,749.35 1,630.35 1,770.00 2,170.00 19,345.28
OTHER INCOME (1) -
Loan proceeds from first mortgage
SECURITY DEPOSITS 400.00 693.00 (693.00) 383.00 (17.00) 766.00
INTEREST INCOME -
SECURITY DEPOSIT INTEREST EXP -
CLEARING 125000 0.26 514.87 515.13
MISCELLANEOUS EXPENSE/REIMBURSEMENTS -
TRANSFERS TO/FROM SEC DEP RESERVE -
TRANSFERS (TO) FROM THE RESERVE -
TOTAL CASH RECEIPTS 102,561.99 112,056.10 109,029.36 113,029.20 110,232.02 111,379.92 111,671.70 108,776.88 111,853.35 111,278.79 108,790.00 108,926.00 1,319,585.31
OPERATING DISBURSMENTS (46,604.16) (83,960.79) (40,759.71) (59,372.42) (44,556.34) (84,714.23) (32,782.56) (54,505.79) (36,873.89) (60,482.74) (44,833.00) (38,225.00) (627,670.63)
DEBT SERVICE - 1st MORTGAGE INTEREST (11,351.17) (11,318.94) (10,194.35) (11,250.31) (10,855.86) (11,183.76) (10,791.24) (11,116.75) (11,083.70) (10,694.07) (11,425.00) (11,425.00) (132,690.15)
DEBT SERVICE - 1ST MORTGAGE PRINCIPAL (9,126.13) (9,158.36) (10,282.95) (9,226.99) (9,621.44) (9,293.54) (9,686.06) (9,360.55) (9,393.60) (9,783.23) (9,052.30) (9,052.30) (113,037.45)
TAX OR ESCROW PAYMENTS -
INSURANCE OR ESCROW PAYMENTS (44,070.50) (40,111.00) (84,181.50)
REPLACEMENT RESERVE
WORKERS COMP ESCROW -
CASH FLOW FROM OPERATIONS 35,480.53 7,618.01 47,792.35 33,179.48 45,198.38 6,188.39 58,411.84 33,793.79 54,502.16 (13,751.75) 3,368.70 50,223.70 2,277,165.04
PLUS: PAID IN CAPITAL - UMFS -
PAID IN CAPITAL - LAND LEASE (45,600.00) (45,600.00)
OPERATING DEF LOAN -
FUNDING CONSTRUCTON LOAN -
ZERO OUT DRC TAX ESCROW -
REPLACEMENT RESERVE FUNDING
-
LESS: CAPITAL EXPENDITURES (1,399.51) (16,259.16) (7,283.46) (85,346.38) (85,971.63) (1,487.00) (3,656.38) (2,423.75) (10,888.98) (20,917.35) (3,331.00) (2,560.00) (241,524.60)
-
- - - - - - - - - - - - -
CASH FLOW 34,081.02 (8,641.15) (5,091.11) (52,166.90) (40,773.25) 4,701.39 54,755.46 31,370.04 43,613.18 (34,669.10) 37.70 47,663.70 74,880.98
BEGINNING CASH BALANCE 612,952.58 647,033.60 638,392.45 633,301.34 581,134.44 540,361.19 545,062.58 599,818.04 631,188.08 674,801.26 640,132.16 640,169.86 612,952.58
CASH FLOW 34,081.02 (8,641.15) (5,091.11) (52,166.90) (40,773.25) 4,701.39 54,755.46 31,370.04 43,613.18 (34,669.10) 37.70 47,663.70 74,880.98
ENDING CASH BALANCE 647,033.60 638,392.45 633,301.34 581,134.44 540,361.19 545,062.58 599,818.04 631,188.08 674,801.26 640,132.16 640,169.86 687,833.56 687,833.56
-
(1) OTHER INCOME INCLUDES LATE FEES, FURNITURE RENTAL, MISCELLANEOUS
INCOME, LAUNDRY INCOME, PET FEES, PREPARATION FEES, ETC.