Loading...
HomeMy WebLinkAboutTown Hall purchase vs leasing analysisLawrence Financial Consulting LLC 8/11/2014 TOWN OF WESTLAKE, TEXAS TOWN HALL ANALYSIS 3.00% 2.00% 20,000 sq. ft.$ 11.3M Solana (Current)12,000 sq. ft 24.88$ sf Note:FY 2020 add 8,000 additional square feet to rental cost to compare w/ TH Net Savings Ownership (Cost) of FYE 9/30 Debt Service Operations Total Rental Cost Ownership 2014 -$ -$ -$ 250,000$ NA 2015 - - - 257,500 NA 2016 - - - 265,225 NA 2017 - - - 273,182 NA 2018 - - - 281,377 NA 2019 - - - 289,819 NA 2020 498,150 80,000 578,150 512,528 (65,622) 2021 494,850 81,600 576,450 527,904 (48,546) 2022 496,100 83,232 579,332 543,741 (35,591) 2023 497,250 84,897 582,147 560,053 (22,093) 2024 498,300 86,595 584,895 576,855 (8,040) 2025 499,250 88,326 587,576 594,160 6,584 2026 499,050 90,093 589,143 611,985 22,842 2027 497,675 91,895 589,570 630,345 40,775 2028 496,150 93,733 589,883 649,255 59,372 2029 499,400 95,607 595,007 668,733 73,725 2030 497,425 97,520 594,945 688,795 93,850 2031 495,300 99,470 594,770 709,459 114,689 2032 497,325 101,459 598,784 730,742 131,958 2033 498,400 103,489 601,889 752,665 150,776 2034 499,125 105,558 604,683 775,245 170,561 2035 498,800 107,669 606,469 798,502 192,032 2036 497,400 109,823 607,223 822,457 215,234 2037 495,600 112,019 607,619 847,131 239,511 2038 498,300 114,260 612,560 872,545 259,985 2039 495,500 116,545 612,045 898,721 286,676 2040 497,200 118,876 616,076 925,683 309,607 2041 498,300 121,253 619,553 953,453 333,900 2042 498,800 123,678 622,478 982,057 359,578 2043 498,700 126,152 624,852 1,011,518 386,666 2044 498,000 128,675 626,675 1,041,864 415,189 2045 496,700 131,248 627,948 1,073,120 445,171 2046 494,800 133,873 628,673 1,105,313 476,640 2047 497,200 136,551 633,751 1,138,473 504,722 2048 498,800 139,282 638,082 1,172,627 534,545 2049 494,700 142,068 636,768 1,207,806 571,038 14,922,550 3,245,446 18,167,996 26,000,835 6,215,736 Proposed Town Hall (TH) Projected Annual Increase in Rental Exp: Projected Annual Increase in Operating Exp: Lawrence Financial Consulting LLC 8/11/2014 20,000 12,000 Current sq. ft. 8,000 Add'. Sq ft. 42.711 497600