Model

This is just a simple illustration of the model using alternative 2 data.

Financial Assumptions

These are all the financial assumptions and they are the same across alternatives.

Financial Assumptions
Rate Assumptions Value
Real Discount Rate 0.025
Real Construction Escalation Rate 0.000
Real Annual Rent Escalation Rate 0.005
Real O&M Cost Escalation Rate 0.005
Real Utilities Escalation Rate 0.010
Real Salary-Benefits Escalation Rate 0.015
Building Lifespan Years 55.000
Recapitalization Year 25.000
Land Value Increase 0.010

Among those assumptions, the following assumptions will increase across years at the rates indicated in the value column.

Financial Assumptions
Rate Assumptions Value X2017 X2018 X2019 X2020 X2021 X2022 X2023 X2024 X2025 X2026 X2027 X2028 X2029 X2030 X2031 X2032 X2033 X2034 X2035 X2036 X2037 X2038 X2039 X2040 X2041 X2042 X2043 X2044 X2045 X2046 X2047 X2048 X2049 X2050 X2051 X2052 X2053 X2054 X2055 X2056 X2057 X2058 X2059 X2060 X2061
Real Construction Escalation Rate 0.000 1.000 1.000000 1.000000 1.000000 1.000000 1.000000 1.000000 1.000000 1.000000 1.000000 1.000000 1.000000 1.000000 1.000000 1.000000 1.000000 1.000000 1.000000 1.000000 1.000000 1.000000 1.000000 1.000000 1.000000 1.000000 1.000000 1.000000 1.000000 1.000000 1.000000 1.000000 1.000000 1.000000 1.000000 1.000000 1.000000 1.000000 1.000000 1.000000 1.000000 1.000000 1.000000 1.000000 1.000000 1.000000
Real Annual Rent Escalation Rate 0.005 1.005 1.010025 1.015075 1.020150 1.025251 1.030377 1.035529 1.040707 1.045911 1.051140 1.056396 1.061678 1.066986 1.072321 1.077683 1.083071 1.088486 1.093929 1.099399 1.104896 1.110420 1.115972 1.121552 1.127160 1.132796 1.138460 1.144152 1.149873 1.155622 1.161400 1.167207 1.173043 1.178908 1.184803 1.190727 1.196681 1.202664 1.208677 1.214721 1.220794 1.226898 1.233033 1.239198 1.245394 1.251621
Real O&M Cost Escalation Rate 0.005 1.005 1.010025 1.015075 1.020150 1.025251 1.030377 1.035529 1.040707 1.045911 1.051140 1.056396 1.061678 1.066986 1.072321 1.077683 1.083071 1.088486 1.093929 1.099399 1.104896 1.110420 1.115972 1.121552 1.127160 1.132796 1.138460 1.144152 1.149873 1.155622 1.161400 1.167207 1.173043 1.178908 1.184803 1.190727 1.196681 1.202664 1.208677 1.214721 1.220794 1.226898 1.233033 1.239198 1.245394 1.251621
Real Utilities Escalation Rate 0.010 1.010 1.020100 1.030301 1.040604 1.051010 1.061520 1.072135 1.082857 1.093685 1.104622 1.115668 1.126825 1.138093 1.149474 1.160969 1.172579 1.184304 1.196147 1.208109 1.220190 1.232392 1.244716 1.257163 1.269735 1.282432 1.295256 1.308209 1.321291 1.334504 1.347849 1.361327 1.374941 1.388690 1.402577 1.416603 1.430769 1.445077 1.459527 1.474123 1.488864 1.503752 1.518790 1.533978 1.549318 1.564811
Real Salary-Benefits Escalation Rate 0.015 1.015 1.030225 1.045678 1.061364 1.077284 1.093443 1.109845 1.126493 1.143390 1.160541 1.177949 1.195618 1.213552 1.231756 1.250232 1.268986 1.288020 1.307341 1.326951 1.346855 1.367058 1.387564 1.408377 1.429503 1.450945 1.472709 1.494800 1.517222 1.539980 1.563080 1.586526 1.610324 1.634479 1.658996 1.683881 1.709140 1.734777 1.760798 1.787210 1.814018 1.841229 1.868847 1.896880 1.925333 1.954213
Land Value Increase 0.010 1.010 1.020100 1.030301 1.040604 1.051010 1.061520 1.072135 1.082857 1.093685 1.104622 1.115668 1.126825 1.138093 1.149474 1.160969 1.172579 1.184304 1.196147 1.208109 1.220190 1.232392 1.244716 1.257163 1.269735 1.282432 1.295256 1.308209 1.321291 1.334504 1.347849 1.361327 1.374941 1.388690 1.402577 1.416603 1.430769 1.445077 1.459527 1.474123 1.488864 1.503752 1.518790 1.533978 1.549318 1.564811

SF Assumptions

Those assumptions are imported from excel tabs named Phasing xx, for example Phasing_Buildings

Assumptions
Facility X2017 X2018 X2019 X2020 X2021 X2022 X2023 X2024 X2025 X2026 X2027 X2028 X2029 X2030 X2031 X2032 X2033 X2034 X2035 X2036 X2037 X2038 X2039 X2040 X2041 X2042 X2043 X2044 X2045 X2046 X2047 X2048 X2049 X2050 X2051 X2052 X2053 X2054 X2055 X2056 X2057 X2058 X2059 X2060 X2061
OCC Facility 86864 86864 86864 86864 86864.0 86864 86864.0 86864 86864 86864 86864 86864 86864 86864 86864 86864 86864 75589 75589 75589 75589 75589 75589 75589 75589 75589 75589 75589 75589 75589 75589 75589 75589 75589 75589 75589 75589 75589 75589 75589 75589 75589 75589 75589 75589
NOC Facility 10360 10360 10360 10360 13958.5 39486 65013.5 90541 90541 90541 90541 90541 90541 90541 90541 90541 90541 90541 90541 90541 90541 90541 90541 90541 90541 90541 90541 90541 90541 90541 90541 90541 90541 90541 90541 90541 90541 90541 90541 90541 90541 90541 90541 90541 90541
Haller Lake Facility 63459 63459 63459 63459 63459.0 63459 63459.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 0 0 0 0 0 0 0 0 0
Charles Street Facility 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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Airport Way Center (AWC) 4620 4620 4620 4620 4620.0 4620 4620.0 4620 4620 4620 4620 4620 4620 4620 4620 4620 4620 4620 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
North Transfer Facility 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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
South Transfer Facility 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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Old South Transfer Phase 2 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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Joint Training Facility 21155 21155 21155 21155 21155.0 21155 21155.0 21155 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 0 0 0 0 0 0 0
Seattle Municipal Tower 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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Halladay Dewatering 4520 4520 4520 4520 4520.0 4520 4520.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 0 0 0 0 0 0 0 0 0
West Seattle Dewatering 5200 5200 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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Mead Street (Earthwork Stockpiles) 9620 9620 9620 9620 9620.0 9620 9620.0 9620 9620 9620 9620 9620 9620 9620 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 0
Canal Boiler Bldg. Warehouse 2600 2600 2600 2600 2600.0 2600 2600.0 2600 2600 2600 2600 2600 2600 2600 2600 2600 2600 2600 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
Central Building 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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Beacon Hill Office Bldg. 6030 6030 6030 6030 6030.0 6030 6030.0 6030 6030 6030 6030 6030 6030 6030 6030 6030 6030 6030 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
Yankee Diner Restaurant 19000 19000 19000 19000 19000.0 19000 19000.0 19000 19000 19000 19000 19000 19000 19000 19000 19000 19000 19000 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
Horizon Coach (New DWW S.) 37881 37881 37881 37881 37881.0 37881 37881.0 37881 37881 37881 37881 37881 37881 37881 37881 37881 37881 12815 25630 25630 25630 25630 25630 25630 25630 25630 25630 25630 25630 25630 25630 25630 25630 25630 25630 25630 25630 25630 25630 25630 25630 25630 25630 25630 25630
Northeast DWW Satellite 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 0 16160 16160 16160 16160 16160 16160 16160 16160 16160 16160 16160 16160 16160 16160 16160 16160
Ballard/Interbay Satellite 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 28060 28060 28060 28060 28060 28060 28060 28060 28060 28060 28060 28060 28060 28060 28060 28060 28060 28060 28060 28060
Southeast Operations Center 0 0 0 0 0.0 0 0.0 0 0 0 0 0 0 0 31105 62210 93315 124420 124420 124420 124420 124420 124420 124420 124420 124420 124420 124420 124420 124420 124420 124420 124420 124420 124420 124420 124420 124420 124420 124420 124420 124420 124420 124420 124420
Southeast Satellite 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 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0

Other Assumptions

Other Assumptions
alternative building id Facility Current Building SF Land Purchase SF Property Purchase Cost / SF Land Value / SF Site Prep and Demo Current Campus SF Yard Development SF Yard Development Cost / SF Building Demolition SF Demolition Cost / SF Renovated Building SF Renovation Cost / SF New Building SF New Building Cost / SF Total Building SF Total Construction Costs Total Staff Staff Move Costs Average Annual Wage Lease Cost Lease Cost / SF Prevent. Maint. Costs Other WO Cost Total Maintenace Costs Maintenance Costs / SF Utility Costs Utility Costs / SF Recap Costs Detailed Replacement Value (DRV) Plant Replacement Value (PRV) Plant Replacement Value (PRV) / SF Deferred Maintenance (Deficiencies) Deferred Maintenance (Deficiencies) / SF Plant Residual Value 2061 Owned vs Leased
Alternative 2 1 Alternative 21 OCC Facility 0 0 89 62.3 5 40762.0 28122.94 61 11275 15 8329 164.7 0 0.0000 8329 1371786 28 11600 0 0.00 0.0000000 0 0 0 2.0000000 0 0.2000000 623539.2 34487549 0 0.00000 0 0.0000000 578190.9 1
Alternative 2 2 Alternative 22 NOC Facility 0 268998 61 42.7 5 268998.0 154613.00 61 21929 15 0 0.0 102110 348.5656 102110 35592030 270 91200 0 0.00 0.0000000 0 0 0 2.0000000 0 0.2000000 16178195.5 0 0 0.00000 0 0.0000000 12060109.3 1
Alternative 2 3 Alternative 23 Haller Lake Facility 63459 0 61 0.0 0 24300.0 0.00 61 0 15 0 0.0 0 0.0000 63459 0 46 0 0 43872.50 0.6913519 0 0 25903 0.4081848 0 0.0000000 3842804.0 4426597 2462933 69.75523 0 12.6079806 0.0 0
Alternative 2 4 Alternative 24 Charles Street Facility 0 0 0 0.0 0 0.0 0.00 0 0 0 0 0.0 0 0.0000 0 0 0 0 0 0.00 0.0000000 0 0 0 0.0000000 0 0.0000000 0.0 0 0 0.00000 0 0.0000000 0.0 0
Alternative 2 5 Alternative 25 Airport Way Center (AWC) 4620 0 0 0.0 0 0.0 0.00 61 0 15 0 0.0 0 0.0000 4620 0 34 0 0 40128.66 8.6858571 0 0 64759 14.0170996 0 0.0000000 5617163.0 2012791 1059200 435.66905 0 35.4619048 0.0 0
Alternative 2 6 Alternative 26 North Transfer Facility 0 0 0 0.0 0 0.0 0.00 61 0 15 0 0.0 0 0.0000 0 0 32 0 0 0.00 0.0000000 0 0 391011 0.0000000 4500 0.0000000 24022509.0 0 0 0.00000 0 0.0000000 0.0 1
Alternative 2 7 Alternative 27 South Transfer Facility 0 0 0 0.0 0 0.0 0.00 61 0 15 0 0.0 0 0.0000 0 0 28 0 0 0.00 0.0000000 0 0 253790 0.0000000 0 0.0000000 18697659.5 0 0 0.00000 0 0.0000000 0.0 1
Alternative 2 8 Alternative 28 Old South Transfer Phase 2 0 0 0 0.0 0 0.0 0.00 61 0 15 0 0.0 0 0.0000 0 0 4 0 0 0.00 0.0000000 0 0 0 0.0000000 0 0.0000000 18697659.0 0 0 0.00000 0 0.0000000 0.0 1
Alternative 2 9 Alternative 29 Joint Training Facility 21155 0 0 0.0 0 0.0 0.00 61 0 15 0 0.0 0 0.0000 21155 0 0 0 0 232152.00 10.9738596 0 0 29231 1.3817537 0 0.0000000 5953363.0 20449851 5244578 966.66750 7161 0.3385015 0.0 0
Alternative 2 10 Alternative 210 Seattle Municipal Tower 17138 0 0 0.0 0 0.0 0.00 61 0 15 0 0.0 0 0.0000 17138 0 886 0 0 6749133.00 30.4701264 0 0 0 0.0000000 0 0.0000000 0.0 0 0 0.00000 0 0.0000000 0.0 0
Alternative 2 11 Alternative 211 Halladay Dewatering 4520 0 0 0.0 0 0.0 0.00 61 0 15 0 0.0 0 0.0000 4520 0 0 0 0 10000.00 2.2123894 0 0 2609 0.5772124 0 0.0000000 363913.0 642186 314578 142.07655 0 0.0000000 0.0 0
Alternative 2 12 Alternative 212 West Seattle Dewatering 5200 0 0 0.0 0 0.0 0.00 61 0 15 0 0.0 0 0.0000 5200 0 0 0 0 4160.00 0.8000000 0 0 5196 0.9992308 0 0.0000000 707835.0 952202 209198 183.11577 0 0.0000000 0.0 0
Alternative 2 13 Alternative 213 Mead Street (Earthwork Stockpiles) 9620 0 0 0.0 0 0.0 0.00 61 0 15 0 0.0 0 0.0000 9620 0 0 0 0 146320.00 15.2099792 0 0 7087 0.7366944 0 0.0000000 1025546.0 1425082 669521 148.13742 225872 23.4794179 0.0 0
Alternative 2 14 Alternative 214 Canal Boiler Bldg. Warehouse 2600 0 0 0.0 0 0.0 0.00 61 0 15 0 0.0 0 0.0000 2600 0 0 0 0 23508.00 9.0415385 0 0 1798 0.6915385 0 0.0000000 265744.0 368145 180952 141.59423 0 0.0000000 0.0 0
Alternative 2 15 Alternative 215 Central Building 0 0 0 0.0 0 0.0 0.00 0 0 0 0 0.0 0 0.0000 0 0 0 0 0 0.00 0.0000000 0 0 0 0.0000000 0 0.0000000 0.0 0 0 0.00000 0 0.0000000 0.0 0
Alternative 2 16 Alternative 216 Beacon Hill Office Bldg. 6030 0 0 0.0 0 21780.0 0.00 61 0 15 0 0.0 0 0.0000 6030 0 5 0 0 0.00 0.0000000 0 0 10374 1.7203980 2976 0.4935323 1648047.0 1625013 1382462 269.48806 0 71.4893864 0.0 1
Alternative 2 17 Alternative 217 Yankee Diner Restaurant 19000 0 0 0.0 0 31363.2 0.00 61 0 15 0 0.0 0 0.0000 19000 0 57 0 0 0.00 0.0000000 0 0 36633 1.9280526 0 0.0000000 7108513.0 3927627 2167581 206.71721 0 0.0000000 0.0 1
Alternative 2 18 Alternative 218 Horizon Coach (New DWW S.) 0 0 73 51.1 5 94548.0 66073.00 61 37881 15 0 0.0 25630 267.3422 25630 6851980 52 13600 0 0.00 0.0000000 0 0 0 2.0000000 0 0.2000000 3114536.4 0 0 0.00000 0 0.0000000 2944652.6 1
Alternative 2 19 Alternative 219 Northeast DWW Satellite 0 65130 68 47.6 5 65130.0 45125.00 61 0 0 0 0.0 16160 272.8657 16160 4409510 13 6000 0 0.00 0.0000000 0 0 0 2.0000000 0 0.2000000 0.0 0 0 0.00000 0 0.0000000 3126743.5 1
Alternative 2 20 Alternative 220 Ballard/Interbay Satellite 0 93918 140 98.0 5 93918.0 63043.00 61 0 0 0 0.0 28060 257.1900 28060 7216750 30 12800 0 0.00 0.0000000 0 0 0 2.0000000 0 0.2000000 0.0 0 0 0.00000 0 0.0000000 4592477.3 1
Alternative 2 21 Alternative 221 Southeast Operations Center 0 276668 53 37.1 5 276668.0 160968.00 61 0 0 0 0.0 124420 353.0312 124420 43924140 245 95200 0 0.00 0.0000000 0 0 0 2.0000000 0 0.2000000 19965518.2 0 0 0.00000 0 0.0000000 18876489.9 1
Alternative 2 22 Alternative 222 Southeast Satellite 0 0 0 0.0 0 0.0 0.00 0 0 0 0 0.0 0 0.0000 0 0 0 0 0 0.00 0.0000000 0 0 0 0.0000000 0 0.0000000 0.0 0 0 0.00000 0 0.0000000 0.0 0

Calculation

The following equaitons are applied to each year for each building. Phasing xx refers to the same name tab in the excel. They have units in SF. For example, maintenance cost is equal to the multiplication of maintenance costs/SF, real O&M cost escalation rate, and phasing buildings.

  • \(Lease\ Cost = Lease/SF/yr *Real\ Annual\ Rent\ Escalation\ Rate*Phasing\ Leases\)
  • \(Utility\ Cost = Utility\ Costs/SF * Real\ Utilities\ Escalation\ Rate * Phasing\ Buildings\)
  • \(Recapitalization = 2017\ 30-year\ Recap\ Costs * Real\ Construction\ Escalation Rate * Phasing\ Recap\)
  • \(Deferred\ Maintenance = Real\ Construction\ Escalation\ Rate * Deferred\ Maintenance\ (Deficiencies)\)
  • \(Demolition = Demolition\ Real\ Construction\ Escalation\ Rate * Demolition\ Cost/SF * Phasing\ Demo\)
  • \(New\ Construction = New Building\ Cost/SF * Real\ Construction\ Escalation\ Rate * Phasing\ New\ Buildings\)
  • \(Renovation = Renovation\ Cost/SF* Real\ Construction\ Escalation\ Rate * Phasing\ Renovation\)
  • \(Yard\ Development = Yard\ Development\ Cost/SF * Real\ Construction\ Escalation\ Rate * Phasing\ Yards\)
  • \(Land\ Purchases = Property\ Purchase\ Cost/SF * Land\ Value\ Increase * Phasing\ Land\)
  • \(Site\ Prep\ and\ Demo = Site\ Prep\ and\ Demo * Real\ Construction\ Escalation\ Rate * Phasing\ Land\)
  • \(Plant\ Residual\ Value = Plant\ Residual\ Value\ 2061 * Phasing\ Building\ Disposition\)
  • \(Land\ Value = Land\ Value/SF * Land\ Value\ Increase * Phasing\ Land\ Disposition\)
Costs by Building
building lease_cost maintenance_costs utility_costs recap_costs def_maintenance demo_costs newcon_costs renovation_costs yard_costs land_costs siteprep_costs plant_resval land_value
1 0.000 4789394.60 527258.90 226561.1 0.000 111148.1 0 901531.2 1214106 0 0.0 190325.7 0
2 0.000 4465658.80 501225.10 7524718.4 0.000 297998.9 31084006 0.0 8651181 15932132 1280180.8 3969879.3 5916499
3 284051.062 167708.12 0.00 0.0 0.000 0.0 0 0.0 0 0 0.0 0.0 0
4 0.000 0.00 0.00 0.0 0.000 0.0 0 0.0 0 0 0.0 0.0 0
5 573990.939 971718.86 0.00 0.0 0.000 0.0 0 0.0 0 0 0.0 0.0 0
6 0.000 0.00 0.00 12641478.3 0.000 0.0 0 0.0 0 0 0.0 0.0 0
7 0.000 0.00 0.00 9839357.6 0.000 0.0 0 0.0 0 0 0.0 0.0 0
8 0.000 0.00 0.00 9839357.4 0.000 0.0 0 0.0 0 0 0.0 0.0 0
9 1503060.510 214223.01 0.00 0.0 6986.341 0.0 0 0.0 0 0 0.0 0.0 0
10 7469383.762 0.00 0.00 0.0 0.000 0.0 0 0.0 0 0 0.0 0.0 0
11 64744.672 16891.88 0.00 0.0 0.000 0.0 0 0.0 0 0 0.0 0.0 0
12 8078.072 10089.82 0.00 0.0 0.000 0.0 0 0.0 0 0 0.0 0.0 0
13 689872.612 85857.10 0.00 0.0 220362.927 0.0 0 0.0 0 0 0.0 0.0 0
14 336252.917 26979.27 0.00 0.0 0.000 0.0 0 0.0 0 0 0.0 0.0 0
15 0.000 0.00 0.00 0.0 0.000 0.0 0 0.0 0 0 0.0 0.0 0
16 0.000 155663.48 46703.70 0.0 0.000 0.0 0 0.0 0 0 0.0 0.0 0
17 0.000 549683.86 0.00 0.0 0.000 0.0 0 0.0 0 0 0.0 0.0 0
18 0.000 1847069.50 201972.38 1104055.9 0.000 373428.1 4448172 0.0 2648794 0 0.0 969304.3 0
19 0.000 248006.99 29819.50 0.0 0.000 0.0 2154757 0.0 1345101 2931030 163110.9 1029243.9 1596893
20 0.000 561235.99 66746.31 0.0 0.000 0.0 3892647 0.0 2074293 9367411 266115.4 0.0 4740922
21 0.000 4063678.11 470376.97 7077473.3 0.000 0.0 29967384 0.0 6949207 12106048 1003503.0 6213657.3 5287139
22 0.000 0.00 0.00 0.0 0.000 0.0 0 0.0 0 0 0.0 0.0 0

Narrow down

For this alternative, we dont want to include all the buildings, Therefore,

Costs by Building
building lease_cost maintenance_costs utility_costs recap_costs def_maintenance demo_costs newcon_costs renovation_costs yard_costs land_costs siteprep_costs plant_resval land_value
1 0.000 4789394.60 527258.90 226561.1 0.0 111148.1 0 901531.2 1214106 0 0.0 190325.7 0
2 0.000 4465658.80 501225.10 7524718.4 0.0 297998.9 31084006 0.0 8651181 15932132 1280180.8 3969879.3 5916499
3 284051.062 167708.12 0.00 0.0 0.0 0.0 0 0.0 0 0 0.0 0.0 0
5 573990.939 971718.86 0.00 0.0 0.0 0.0 0 0.0 0 0 0.0 0.0 0
10 7469383.762 0.00 0.00 0.0 0.0 0.0 0 0.0 0 0 0.0 0.0 0
11 64744.672 16891.88 0.00 0.0 0.0 0.0 0 0.0 0 0 0.0 0.0 0
12 8078.072 10089.82 0.00 0.0 0.0 0.0 0 0.0 0 0 0.0 0.0 0
13 689872.612 85857.10 0.00 0.0 220362.9 0.0 0 0.0 0 0 0.0 0.0 0
14 336252.917 26979.27 0.00 0.0 0.0 0.0 0 0.0 0 0 0.0 0.0 0
16 0.000 155663.48 46703.70 0.0 0.0 0.0 0 0.0 0 0 0.0 0.0 0
17 0.000 549683.86 0.00 0.0 0.0 0.0 0 0.0 0 0 0.0 0.0 0
18 0.000 1847069.50 201972.38 1104055.9 0.0 373428.1 4448172 0.0 2648794 0 0.0 969304.3 0
19 0.000 248006.99 29819.50 0.0 0.0 0.0 2154757 0.0 1345101 2931030 163110.9 1029243.9 1596893
20 0.000 561235.99 66746.31 0.0 0.0 0.0 3892647 0.0 2074293 9367411 266115.4 0.0 4740922
21 0.000 4063678.11 470376.97 7077473.3 0.0 0.0 29967384 0.0 6949207 12106048 1003503.0 6213657.3 5287139

The total summary by cost is

Costs by Building
lease_cost maintenance_costs utility_costs recap_costs def_maintenance demo_costs newcon_costs renovation_costs yard_costs land_costs siteprep_costs plant_resval land_value
9426374 17959636 1844103 15932809 220362.9 782575.1 71546966 901531.2 22882682 40336621 2712910 12372410 17541453