OUTDOOR RESORT-PALM SPRINGS OWNERS ASSOCIATION SCT Reserve Consultants, Inc. Job No. 2006-013-16 L2
Page 34 of 67
Cash Flow and Percent Funded Projections
Revenue Fiscal Year: July 01, 2021 - June 30, 2022
Expenditures
End of Year
Special Assessment, Bank & Litigation
Cash Flow (Balance w/Funding Plan)
Percent Funded (EOY)
Cash Flow (Balance without Funding Plan)
Contribution Annual
Contribution Unit/Month
Contribution % Change
Deferred & Non‐Recurring
100% Funded
Interest
Components
Taxes
Year
2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 2047 2048 2049 2050 2051
$6,179,955 $6,315,245 $6,219,586 $6,730,948 $6,763,284 $6,927,206 $7,199,832 $7,418,262 $7,647,806 $7,974,344 $8,039,757 $7,633,512 $7,506,213 $8,250,787 $7,621,419 $7,935,868 $7,661,962 $6,101,665 $6,909,692 $7,474,947 $7,782,971 $8,061,272 $8,087,121 $8,851,970 $9,043,857 $9,458,228 $9,782,803 $9,998,304 $10,864,116 $11,417,788 $11,823,678
$4,077,000 65.97%
$4,157,332 65.83% $4,157,332 $3,996,565 64.26% $3,953,576 $4,487,529 66.67% $4,356,401 $4,471,080 66.11% $4,204,412 $4,601,017 66.42% $4,149,061 $4,859,770 67.50% $4,170,332 $5,064,956 68.28% $4,083,294 $5,282,743 69.08% $3,951,456 $5,653,219 70.89% $3,912,137 $5,703,170 70.94% $3,489,241 $5,100,827 66.82% $2,347,991 $4,882,919 65.05% $1,521,982 $5,802,099 70.32% $1,760,605
$1,056,329 $1,099,110 $1,143,624 $1,189,941 $1,238,134 $1,288,278 $1,340,453 $1,394,742 $1,451,229 $1,510,003 $1,571,159 $1,634,790 $1,700,999 $1,769,890 $1,841,571 $1,916,154 $1,993,758 $2,074,506 $2,158,523 $2,245,943 $2,336,904 $2,431,549 $2,530,026 $2,632,492 $2,739,108 $2,850,042 $2,965,469 $3,085,570 $3,210,536 $3,340,563
$72.57 $75.51 $78.57 $81.75 $85.06 $88.50 $92.09 $95.82 $99.70 $103.74 $107.94 $112.31 $116.86 $121.59 $126.52 $131.64 $136.97 $142.52 $148.29 $154.30 $160.55 $167.05 $173.81 $180.85 $188.18 $195.80 $203.73 $211.98 $220.56 $229.50
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$36,519 $34,824 $39,236 $39,072 $40,084 $42,377 $44,203 $46,117 $49,483 $49,845 $43,842 $41,223 $49,595 $40,265 $43,594 $39,271 $13,736 $21,709 $29,283 $33,507 $37,281 $38,202 $47,425 $51,887 $57,590 $63,023 $67,881 $80,858 $92,558 $102,650
$1,011,421 $1,293,656
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
$1,096 $1,045 $1,177 $1,172 $1,203 $1,271 $1,326 $1,384 $1,484 $1,495 $1,315 $1,237 $1,488 $1,208 $1,308 $1,178
4.05% 4.05% 4.05% 4.05% 4.05% 4.05% 4.05% 4.05% 4.05% 4.05% 4.05% 4.05% 4.05% 4.05% 4.05% 4.05% 4.05% 4.05% 4.05% 4.05% 4.05% 4.05% 4.05% 4.05% 4.05% 4.05% 4.05% 4.05% 4.05%
$690,719
$1,244,290 $1,147,078 $1,070,631 $1,178,143 $1,221,688 $1,128,752 $1,508,402 $2,216,029 $1,892,685
$829,926
$4,816,568 63.20%
$22,784
$2,794,479 $1,457,353 $2,390,480 $4,628,511 $1,106,284 $1,395,648 $1,828,266 $1,953,424 $2,344,979 $1,567,168 $2,209,867 $2,166,535 $2,315,752 $2,492,695 $1,769,216 $2,074,523 $2,373,144
$5,243,071 66.07% ($378,240) $4,806,838 62.74% ($1,712,391) $2,185,409 35.82% ($5,284,573) $3,174,689 45.95% ($5,334,528) $3,965,969 53.06% ($5,673,847) $4,416,148 56.74% ($6,445,784) $4,835,790 59.99% ($7,342,879) $4,959,416 61.32% ($8,631,529) $5,968,276 67.42% ($9,142,368) $6,441,231 71.22% ($10,295,906) $7,069,667 74.75% ($11,406,112) $7,665,090 78.35% ($12,665,535) $8,203,708 82.05% ($14,101,901) $9,598,494 88.35% ($14,814,788) $10,824,288 94.80% ($15,832,982) $11,891,276 100.57% ($17,149,797)
$412 $651 $879
$1,005 $1,118 $1,146 $1,423 $1,557 $1,728 $1,891 $2,036 $2,426 $2,777 $3,079
Totals:
$59,741,396
$0 $1,417,139 $53,301,744
$0
$42,514
Report Date 3/23/21 Version 1
Made with FlippingBook Learn more on our blog