{"text_format":"1","workbook":"xlsx","n_sheets":20,"sheets":["Overview","Initial Settings","Market Inputs","Owner-Operator Inputs","Private Sector Partner Inputs","Public Sector Partner Inputs","Owner-Operator DCF","Private Sector Partner DCF","Public Sector Partner DCF","Combined DCF","Debt Schedule","Terminal Value Model","Outputs Dashboard","Income Statement","Balance Sheet","SCF","Report","Sensitivity Tables","Lists_Hidden","Version"],"not_rendered":{"charts":28,"images":1,"macros":1,"external_links":0,"defined_names":8834,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Overview","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Initial Settings","index":1,"n_rows":26,"n_cols":9,"rows_kept":26,"cut":false,"hidden":false,"merged":[[5,2,5,4],[10,0,10,3],[12,0,12,3]]}
[{"$f":"C6","v":"Washington EV - Business Model 3 - Walla Walla"}]
[]
[]
["Initial Settings"]
[null,null,null,null,null,null,null," "]
["Scenario Name",null,"Washington EV - Business Model 3 - Walla Walla"]
["Initial Year",null,2015]
[]
[]
[]
["Load values from external file"]
[]
["Save all user inputs to an external file"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Terminal"]

{"sheet":"Market Inputs","index":2,"n_rows":44,"n_cols":15,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Initial Settings'!C6","v":"Washington EV - Business Model 3 - Walla Walla"}]
[]
[]
["Market Assumptions"]
[]
[null,null,null,null,null,{"$f":"+'Initial Settings'!$C$7+1","v":2016},{"$f":"F6+1","v":2017},{"$f":"G6+1","v":2018},2019,2020,2021,2022,2023,2024,2025]
[]
["Use traffic-derived values [1] or direct inputs [2]",null,null,null,"N"]
[]
["Traffic-derived Utilization Values"]
[]
["Annual average traffic volume of route in first year [# of cars]",null,null,null,1000000]
["Projected annual growth rate in traffic volume [%]",null,null,null,0]
["Annual average traffic volume of route [# of cars]",null,null,null,null,{"$f":"E12","v":1000000},{"$f":"ROUND(F14*(1+$E$13),0)","v":1000000},1000000,1000000,1000000,1000000,1000000,1000000,1000000,1000000]
["EVs as a percentage of total registered vehicles in first year [%]",null,null,null,6.4999999999999997E-3]
["Projected annual growth rate of EVs as a percentage of total registered vehicles [%]",null,null,null,{"$f":"100/12*0.012","v":0.1}]
["EVs as a percentage of total registered vehicles [%]",null,null,null,null,{"$f":"E15","v":6.4999999999999997E-3},{"$f":"F17*(1+$E$16)","v":7.1500000000000001E-3},7.8650000000000005E-3,8.6515000000000012E-3,9.5166500000000015E-3,1.0468315000000002E-2,1.1515146500000004E-2,1.2666661150000005E-2,1.3933327265000007E-2,1.5326659991500008E-2]
["Annual average EV traffic  [# of cars]",null,null,null,null,{"$f":"F14*F17","v":6500},7150,7865.0000000000009,8651.5000000000018,9516.6500000000015,10468.315000000002,11515.146500000004,12666.661150000005,13933.327265000007,15326.659991500008]
[]
[{"$f":"\"[Station Type 1] Expected number of \" & 'Owner-Operator Inputs'!E10 & \" sessions per car per trip\"","v":"[Station Type 1] Expected number of DC fast charging (highway) sessions per car per trip"},null,null,null,1]
[{"$f":"\"[Station Type 1] Total number of \" & 'Owner-Operator Inputs'!E10 & \" sessions\"","v":"[Station Type 1] Total number of DC fast charging (highway) sessions"},null,null,null,null,{"$f":"ROUND(F$18*$E20,)","v":6500},7150,7865,8652,9517,10468,11515,12667,13933,15327]
[{"$f":"\"[Station Type 2] Expected number of \" & 'Owner-Operator Inputs'!E73 & \" sessions per car per trip\"","v":"[Station Type 2] Expected number of Level 2 (local) sessions per car per trip"},null,null,null,0]
[{"$f":"\"[Station Type 2] Total number of \" & 'Owner-Operator Inputs'!E73 & \" sessions\"","v":"[Station Type 2] Total number of Level 2 (local) sessions"},null,null,null,null,{"$f":"ROUND(F$18*$E22,)","v":0},{"$f":"ROUND(G$18*$E22,)","v":0},{"$f":"ROUND(H$18*$E22,)","v":0},{"$f":"ROUND(I$18*$E22,)","v":0},{"$f":"ROUND(J$18*$E22,)","v":0},0,0,0,0,0]
[{"$f":"\"[Station Type 3] Expected number of \" & 'Owner-Operator Inputs'!E136 & \" sessions per car per trip\"","v":"[Station Type 3] Expected number of DC fast charging (local) sessions per car per trip"},null,null,null,0]
[{"$f":"\"[Station Type 3] Total number of \" & 'Owner-Operator Inputs'!E136 & \" sessions\"","v":"[Station Type 3] Total number of DC fast charging (local) sessions"},null,null,null,null,{"$f":"ROUND(F$18*$E24,)","v":0},{"$f":"ROUND(G$18*$E24,)","v":0},{"$f":"ROUND(H$18*$E24,)","v":0},{"$f":"ROUND(I$18*$E24,)","v":0},{"$f":"ROUND(J$18*$E24,)","v":0},0,0,0,0,0]
[]
["Direct Utilization Values"]
[]
[null,null,null,null,null,{"$f":"+'Initial Settings'!$C$7+1","v":2016},{"$f":"F29+1","v":2017},{"$f":"G29+1","v":2018},{"$f":"H29+1","v":2019},{"$f":"I29+1","v":2020},{"$f":"J29+1","v":2021},{"$f":"K29+1","v":2022},{"$f":"L29+1","v":2023},{"$f":"M29+1","v":2024},{"$f":"N29+1","v":2025}]
["Expected annual utilization growth rate [%]",null,{"$f":"'Sensitivity Tables'!$A$9","v":0.22},null,null,0.22,"*Sensitivity analysis variable"]
["[Station Type 1] Initial average utilization [# of charging sessions per station per year]",null,{"$f":"'Sensitivity Tables'!$A$26","v":1200},null,null,1200,"*Sensitivity analysis variable"]
[{"$f":"\"[Station Type 1] Total number of \" & 'Owner-Operator Inputs'!E10 & \" sessions\"","v":"[Station Type 1] Total number of DC fast charging (highway) sessions"},null,null,null,null,{"$f":"$C$31*'Owner-Operator Inputs'!$E$21","v":9600},{"$f":"ROUND(F32*(1+$C$30),0)","v":11712},14289,17433,21268,25947,31655,38619,47115,57480]
["[Station Type 2] Initial average utilization [# of charging sessions per station per year]",null,{"$f":"'Sensitivity Tables'!$A$43","v":400},null,null,400,"*Sensitivity analysis variable"]
[{"$f":"\"[Station Type 2] Total number of \" & 'Owner-Operator Inputs'!E73 & \" sessions\"","v":"[Station Type 2] Total number of Level 2 (local) sessions"},null,null,null,null,{"$f":"$C$33*'Owner-Operator Inputs'!$E$84","v":20000},{"$f":"ROUND(F34*(1+$C$30),0)","v":24400},29768,36317,44307,54055,65947,80455,98155,119749]
["[Station Type 3] Initial average utilization [# of charging sessions per station per year]",null,{"$f":"'Sensitivity Tables'!$A$60","v":1200},null,null,1200,"*Sensitivity analysis variable"]
[{"$f":"\"[Station Type 3] Total number of \" & 'Owner-Operator Inputs'!E136 & \" sessions\"","v":"[Station Type 3] Total number of DC fast charging (local) sessions"},null,null,null,null,{"$f":"$C$35*'Owner-Operator Inputs'!$E$147","v":2400},{"$f":"ROUND(F36*(1+$C$30),0)","v":2928},3572,4358,5317,6487,7914,9655,11779,14370]
[]
["Summary"]
[]
[null,null,null,null,null,{"$f":"+'Initial Settings'!$C$7+1","v":2016},{"$f":"F40+1","v":2017},{"$f":"G40+1","v":2018},{"$f":"H40+1","v":2019},{"$f":"I40+1","v":2020},{"$f":"J40+1","v":2021},{"$f":"K40+1","v":2022},{"$f":"L40+1","v":2023},{"$f":"M40+1","v":2024},{"$f":"N40+1","v":2025}]
[{"$f":"\"[Station Type 1] Total number of \" & 'Owner-Operator Inputs'!E10 & \" sessions\"","v":"[Station Type 1] Total number of DC fast charging (highway) sessions"},null,null,null,null,{"$f":"IF($E$8=\"Y\",F21,F32)","v":9600},11712,14289,17433,21268,25947,31655,38619,47115,57480]
[{"$f":"\"[Station Type 2] Total number of \" & 'Owner-Operator Inputs'!E73 & \" sessions\"","v":"[Station Type 2] Total number of Level 2 (local) sessions"},null,null,null,null,{"$f":"IF($E$8=\"Y\",F23,F34)","v":20000},24400,29768,36317,44307,54055,65947,80455,98155,119749]
[{"$f":"\"[Station Type 3] Total number of \" & 'Owner-Operator Inputs'!E136 & \" sessions\"","v":"[Station Type 3] Total number of DC fast charging (local) sessions"},null,null,null,null,{"$f":"IF($E$8=\"Y\",F25,F36)","v":2400},2928,3572,4358,5317,6487,7914,9655,11779,14370]
["Total expected charging session per year",null,null,null,null,{"$f":"SUM(F41:F43)","v":32000},39040,47629,58108,70892,86489,105516,128729,157049,191599]

{"sheet":"Owner-Operator Inputs","index":3,"n_rows":299,"n_cols":15,"rows_kept":299,"cut":false,"hidden":false,"merged":[[9,4,9,5],[72,4,72,5],[135,4,135,5]]}
[{"$f":"'Initial Settings'!$C$6","v":"Washington EV - Business Model 3 - Walla Walla"}]
[]
[]
["Charging Station Assumptions"]
[]
["Expected equipment lifespan [years] - All equipment types",null,null,null,10]
[]
["Charging Station Assumptions - Type 1"]
[]
["Charging station type",null,null,null,"DC fast charging (highway)"]
[]
["Charging Station Capital Cost"]
["Equipment costs"]
["Charging station equipment cost (per station) [$]",null,null,null,35000]
["Installation and siting costs"]
["Construction and equipment installation cost (per station) [$]",null,null,null,26000]
["Electric utility upgrades and grid interconnection cost (per site) [$]",null,null,null,20000]
["Lease and property transaction costs (per site – one-time fee) [$]",null,null,null,6000]
["Host site identification and screening (per site) [$]",null,null,null,5000]
[]
["Total number of stations [#]",null,null,null,8]
["Total number of sites [#]",null,null,null,8]
[]
["Total initial Type 1 station capital required [$]",null,null,null,{"$f":"((E14+E16)*E21)+((E17+E18+E19)*E22)","v":736000}]
[]
["Annual depreciation [$]",null,null,null,{"$f":"E24/$E$6","v":73600}]
[]
[null,null,null,null,null,{"$f":"+'Initial Settings'!$C$7+1","v":2016},{"$f":"F28+1","v":2017},{"$f":"G28+1","v":2018},2019,2020,2021,2022,2023,2024,2025]
["Charging Station Utilization"]
["Maximum number of charging sessions per station [sessions/year/station]",null,null,null,3650]
["Maximum number of charging sessions [sessions/year]",null,null,null,null,{"$f":"$E30*$E21","v":29200},29200,29200,29200,29200,29200,29200,29200,29200,29200]
["Projected number of charging sessions[sessions/year]",null,null,null,null,{"$f":"IF(COLUMN(F$6)-COLUMN($F$6)<$E$6,MIN(F31,'Market Inputs'!F41),0)","v":9600},{"$f":"IF(COLUMN(G$6)-COLUMN($F$6)<$E$6,MIN(G31,'Market Inputs'!G41),0)","v":11712},{"$f":"IF(COLUMN(H$6)-COLUMN($F$6)<$E$6,MIN(H31,'Market Inputs'!H41),0)","v":14289},{"$f":"IF(COLUMN(I$6)-COLUMN($F$6)<$E$6,MIN(I31,'Market Inputs'!I41),0)","v":17433},{"$f":"IF(COLUMN(J$6)-COLUMN($F$6)<$E$6,MIN(J31,'Market Inputs'!J41),0)","v":21268},{"$f":"IF(COLUMN(K$6)-COLUMN($F$6)<$E$6,MIN(K31,'Market Inputs'!K41),0)","v":25947},{"$f":"IF(COLUMN(L$6)-COLUMN($F$6)<$E$6,MIN(L31,'Market Inputs'!L41),0)","v":29200},{"$f":"IF(COLUMN(M$6)-COLUMN($F$6)<$E$6,MIN(M31,'Market Inputs'!M41),0)","v":29200},{"$f":"IF(COLUMN(N$6)-COLUMN($F$6)<$E$6,MIN(N31,'Market Inputs'!N41),0)","v":29200},{"$f":"IF(COLUMN(O$6)-COLUMN($F$6)<$E$6,MIN(O31,'Market Inputs'!O41),0)","v":29200}]
[]
["Energy Usage"]
["Average charging energy per session [kWh/session]",null,null,null,15]
["Energy used/sold [kWh/year]",null,null,null,null,{"$f":"IF(COLUMN(F$6)-COLUMN($F$6)<$E$6,F32*$E35,0)","v":144000},{"$f":"IF(COLUMN(G$6)-COLUMN($F$6)<$E$6,G32*$E35,0)","v":175680},214335,261495,319020,389205,438000,438000,438000,438000]
["Maximum power draw [kW/session]",null,null,null,50]
["Average time of charging session (minutes)",null,null,null,30]
[]
[null,null,null,null,null,{"$f":"+'Initial Settings'!$C$7+1","v":2016},{"$f":"F40+1","v":2017},{"$f":"G40+1","v":2018},{"$f":"H40+1","v":2019},{"$f":"I40+1","v":2020},{"$f":"J40+1","v":2021},{"$f":"K40+1","v":2022},{"$f":"L40+1","v":2023},{"$f":"M40+1","v":2024},{"$f":"N40+1","v":2025}]
["Charging Station Revenue [Operating Revenue - Direct]"]
[null,null,null,"Revenue Model Applies?"]
["Per-energy user fee [$/kWh]",null,null,"Y",0.5]
["Per-energy revenue",null,null,null,null,{"$f":"IF($D43=\"Y\",IF(COLUMN(F$6)-COLUMN($F$6)<$E$6,F36*$E43,0),0)","v":72000},{"$f":"IF($D43=\"Y\",IF(COLUMN(G$6)-COLUMN($F$6)<$E$6,G36*$E43,0),0)","v":87840},107167.5,130747.5,159510,194602.5,219000,219000,219000,219000]
["Per-charge event user fee [$/session]",null,null,"N",10]
["Per-charge event revenue",null,null,null,null,{"$f":"IF($D45=\"Y\",IF(COLUMN(F$6)-COLUMN($F$6)<$E$6,F32*$E45,0),0)","v":0},{"$f":"IF($D45=\"Y\",IF(COLUMN(G$6)-COLUMN($F$6)<$E$6,G32*$E45,0),0)","v":0},0,0,0,0,0,0,0,0]
[]
["Total charging station revenue",null,null,null,null,{"$f":"SUM(F44:F46)","v":72000},87840,107167.5,130747.5,159510,194602.5,219000,219000,219000,219000]
[]
[null,null,null,null,null,{"$f":"+'Initial Settings'!$C$7+1","v":2016},{"$f":"F50+1","v":2017},{"$f":"G50+1","v":2018},{"$f":"H50+1","v":2019},{"$f":"I50+1","v":2020},{"$f":"J50+1","v":2021},{"$f":"K50+1","v":2022},{"$f":"L50+1","v":2023},{"$f":"M50+1","v":2024},{"$f":"N50+1","v":2025}]
["Charging Station Operating Cost [Cost of Sales]"]
["Electricity"]
["Electricity retail price in first year [$/kWh]",null,null,null,7.6799999999999993E-2]
["Annual compounded growth rate in electricity price [%]",null,null,null,2.5000000000000001E-3]
["Electricity retail price [$/kWh]",null,null,null,null,{"$f":"E53","v":7.6799999999999993E-2},{"$f":"F55*(1+$E54)","v":7.6991999999999991E-2},7.7184479999999986E-2,7.737744119999998E-2,7.7570884802999979E-2,7.776481201500747E-2,7.7959224045044989E-2,7.8154122105157597E-2,7.8349507410420488E-2,7.8545381178946536E-2]
["Energy cost (based on kWh)",null,null,null,null,{"$f":"IF(COLUMN(F$6)-COLUMN($F$6)<$E$6,F36*F55,0)","v":11059.199999999999},{"$f":"IF(COLUMN(G$6)-COLUMN($F$6)<$E$6,G36*G55,0)","v":13525.954559999998},16543.335520799996,20233.813986593996,24746.663669853053,30266.453660300984,34146.140131729706,34231.50548205903,34317.08424576417,34402.876956378583]
["Demand charge [$/kW/month]",null,null,null,1.26]
["Power cost (based on kW)",null,null,null,null,{"$f":"IF(COLUMN(F$6)-COLUMN($F$6)<$E$6,$E21*$E37*12*$E57,0)","v":6048},{"$f":"IF(COLUMN(G$6)-COLUMN($F$6)<$E$6,$E21*$E37*12*$E57,0)","v":6048},6048,6048,6048,6048,6048,6048,6048,6048]
["Maintenance cost"]
["Annual maintenance cost as percentage of equipment value [%]",null,null,null,0.03]
["Maintenance cost (annual)",null,null,null,null,{"$f":"IF(COLUMN(F$6)-COLUMN($F$6)<$E$6,$E60*$E14*$E21,0)","v":8400},{"$f":"IF(COLUMN(G$6)-COLUMN($F$6)<$E$6,$E60*$E14*$E21,0)","v":8400},8400,8400,8400,8400,8400,8400,8400,8400]
["Host site lease or access cost"]
["Host site lease or access cost (average per site/year) [$]",null,null,null,1200]
["Host site lease or access cost (annual)",null,null,null,null,{"$f":"IF(COLUMN(F$6)-COLUMN($F$6)<$E$6,$E63*$E22,0)","v":9600},{"$f":"IF(COLUMN(G$6)-COLUMN($F$6)<$E$6,$E63*$E22,0)","v":9600},9600,9600,9600,9600,9600,9600,9600,9600]
[]
["Total charging operating cost",null,null,null,null,{"$f":"SUM(F56:F64)","v":35107.199999999997},37573.954559999998,40591.335520799999,44281.813986593996,48794.663669853049,54314.453660300984,58194.140131729706,58279.50548205903,58365.08424576417,58450.876956378583]
[]
[null,null,null,null,null,{"$f":"+'Initial Settings'!$C$7+1","v":2016},{"$f":"F68+1","v":2017},{"$f":"G68+1","v":2018},{"$f":"H68+1","v":2019},{"$f":"I68+1","v":2020},{"$f":"J68+1","v":2021},{"$f":"K68+1","v":2022},{"$f":"L68+1","v":2023},{"$f":"M68+1","v":2024},{"$f":"N68+1","v":2025}]
["Total charging station operating margin",null,null,null,null,{"$f":"F48-F66","v":36892.800000000003},50266.045440000002,66576.164479200001,86465.686013405997,110715.33633014695,140288.04633969901,160805.85986827029,160720.49451794097,160634.91575423582,160549.12304362142]
[]
["Charging Station Assumptions - Type 2"]
[]
["Charging station type",null,null,null,"Level 2 (local)"]
[]
["Charging Station Capital Cost"]
["Equipment costs"]
["Charging station equipment cost (per station) [$]",null,null,null,2500]
["Installation and siting costs"]
["Construction and equipment installation cost (per station) [$]",null,null,null,4000]
["Electric utility upgrades and grid interconnection cost (per site) [$]",null,null,null,0]
["Lease and property transaction costs (per site – one-time fee) [$]",null,null,null,6000]
["Host site identification and screening (per site) [$]",null,null,null,5000]
[]
["Total number of stations [#]",null,null,null,50]
["Total number of sites [#]",null,null,null,10]
[]
["Total initial Type 1 station capital required [$]",null,null,null,{"$f":"((E77+E79)*E84)+((E80+E81+E82)*E85)","v":435000}]
[]
["Annual depreciation [$]",null,null,null,{"$f":"E87/$E$6","v":43500}]
[]
[null,null,null,null,null,{"$f":"+'Initial Settings'!$C$7+1","v":2016},{"$f":"F91+1","v":2017},{"$f":"G91+1","v":2018},{"$f":"H91+1","v":2019},{"$f":"I91+1","v":2020},{"$f":"J91+1","v":2021},{"$f":"K91+1","v":2022},{"$f":"L91+1","v":2023},{"$f":"M91+1","v":2024},{"$f":"N91+1","v":2025}]
["Charging Station Utilization"]
["Maximum number of charging sessions per station [sessions/year/station]",null,null,null,1200]
["Maximum number of charging sessions [sessions/year]",null,null,null,null,{"$f":"$E93*$E84","v":60000},60000,60000,60000,60000,60000,60000,60000,60000,60000]
["Projected number of charging sessions[sessions/year]",null,null,null,null,{"$f":"IF(COLUMN(F$6)-COLUMN($F$6)<$E$6,MIN(F94,'Market Inputs'!F42),0)","v":20000},{"$f":"IF(COLUMN(G$6)-COLUMN($F$6)<$E$6,MIN(G94,'Market Inputs'!G42),0)","v":24400},{"$f":"IF(COLUMN(H$6)-COLUMN($F$6)<$E$6,MIN(H94,'Market Inputs'!H42),0)","v":29768},{"$f":"IF(COLUMN(I$6)-COLUMN($F$6)<$E$6,MIN(I94,'Market Inputs'!I42),0)","v":36317},{"$f":"IF(COLUMN(J$6)-COLUMN($F$6)<$E$6,MIN(J94,'Market Inputs'!J42),0)","v":44307},{"$f":"IF(COLUMN(K$6)-COLUMN($F$6)<$E$6,MIN(K94,'Market Inputs'!K42),0)","v":54055},{"$f":"IF(COLUMN(L$6)-COLUMN($F$6)<$E$6,MIN(L94,'Market Inputs'!L42),0)","v":60000},{"$f":"IF(COLUMN(M$6)-COLUMN($F$6)<$E$6,MIN(M94,'Market Inputs'!M42),0)","v":60000},{"$f":"IF(COLUMN(N$6)-COLUMN($F$6)<$E$6,MIN(N94,'Market Inputs'!N42),0)","v":60000},{"$f":"IF(COLUMN(O$6)-COLUMN($F$6)<$E$6,MIN(O94,'Market Inputs'!O42),0)","v":60000}]
[]
["Energy Usage"]
["Average charging energy per session [kWh/session]",null,null,null,10]
["Energy used/sold [kWh/year]",null,null,null,null,{"$f":"IF(COLUMN(F$6)-COLUMN($F$6)<$E$6,F95*$E98,0)","v":200000},244000,297680,363170,443070,540550,600000,600000,600000,600000]
["Maximum power draw [kW/session]",null,null,null,6.6]
["Average time of charging session (minutes)",null,null,null,90]
[]
[null,null,null,null,null,{"$f":"+'Initial Settings'!$C$7+1","v":2016},{"$f":"F103+1","v":2017},{"$f":"G103+1","v":2018},{"$f":"H103+1","v":2019},{"$f":"I103+1","v":2020},{"$f":"J103+1","v":2021},{"$f":"K103+1","v":2022},{"$f":"L103+1","v":2023},{"$f":"M103+1","v":2024},{"$f":"N103+1","v":2025}]
["Charging Station Revenue [Operating Revenue - Direct]"]
[null,null,null,"Revenue Model Applies?"]
["Per-energy user fee [$/kWh]",null,null,"Y",0.25]
["Per-energy revenue",null,null,null,null,{"$f":"IF($D106=\"Y\",IF(COLUMN(F$6)-COLUMN($F$6)<$E$6,F99*$E106,0),0)","v":50000},61000,74420,90792.5,110767.5,135137.5,150000,150000,150000,150000]
["Per-charge event user fee [$/session]",null,null,"N",2]
["Per-charge event revenue",null,null,null,null,{"$f":"IF($D108=\"Y\",IF(COLUMN(F$6)-COLUMN($F$6)<$E$6,F95*$E108,0),0)","v":0},0,0,0,0,0,0,0,0,0]
[]
["Total charging station revenue",null,null,null,null,{"$f":"SUM(F107:F109)","v":50000},{"$f":"SUM(G107:G109)","v":61000},74420,90792.5,110767.5,135137.5,150000,150000,150000,150000]
[]
[null,null,null,null,null,{"$f":"+'Initial Settings'!$C$7+1","v":2016},{"$f":"F113+1","v":2017},{"$f":"G113+1","v":2018},{"$f":"H113+1","v":2019},{"$f":"I113+1","v":2020},{"$f":"J113+1","v":2021},{"$f":"K113+1","v":2022},{"$f":"L113+1","v":2023},{"$f":"M113+1","v":2024},{"$f":"N113+1","v":2025}]
["Charging Station Operating Cost [Cost of Sales]"]
["Electricity"]
["Electricity retail price in first year [$/kWh]",null,null,null,7.6799999999999993E-2]
["Annual compounded growth rate in electricity price [%]",null,null,null,2.5000000000000001E-3]
["Electricity retail price [$/kWh]",null,null,null,null,{"$f":"E116","v":7.6799999999999993E-2},{"$f":"F118*(1+$E117)","v":7.6991999999999991E-2},7.7184479999999986E-2,7.737744119999998E-2,7.7570884802999979E-2,7.776481201500747E-2,7.7959224045044989E-2,7.8154122105157597E-2,7.8349507410420488E-2,7.8545381178946536E-2]
["Energy cost (based on kWh)",null,null,null,null,{"$f":"IF(COLUMN(F$6)-COLUMN($F$6)<$E$6,F99*F118,0)","v":15359.999999999998},18786.047999999999,22976.276006399996,28101.165320603992,34369.331929665197,42035.769134712289,46775.534427026992,46892.473263094558,47009.70444625229,47127.228707367918]
["Demand charge [$/kW/month]",null,null,null,1.26]
["Power cost (based on kW)",null,null,null,null,{"$f":"IF(COLUMN(F$6)-COLUMN($F$6)<$E$6,$E84*$E100*12*$E120,0)","v":4989.6000000000004},4989.6000000000004,4989.6000000000004,4989.6000000000004,4989.6000000000004,4989.6000000000004,4989.6000000000004,4989.6000000000004,4989.6000000000004,4989.6000000000004]
["Maintenance cost"]
["Annual maintenance cost as percentage of equipment value [%]",null,null,null,0.03]
["Maintenance cost (annual)",null,null,null,null,{"$f":"IF(COLUMN(F$6)-COLUMN($F$6)<$E$6,$E123*$E77*$E84,0)","v":3750},3750,3750,3750,3750,3750,3750,3750,3750,3750]
["Host site lease or access cost"]
["Host site lease or access cost (average per site/year) [$]",null,null,null,1200]
["Host site lease or access cost (annual)",null,null,null,null,{"$f":"IF(COLUMN(F$6)-COLUMN($F$6)<$E$6,$E126*$E85,0)","v":12000},12000,12000,12000,12000,12000,12000,12000,12000,12000]
[]
["Total charging operating cost",null,null,null,null,{"$f":"SUM(F119:F127)","v":36099.599999999999},{"$f":"SUM(G119:G127)","v":39525.648000000001},43715.876006399994,48840.76532060399,55108.931929665196,62775.369134712288,67515.134427026991,67632.073263094557,67749.304446252296,67866.828707367909]
[]
[null,null,null,null,null,{"$f":"+'Initial Settings'!$C$7+1","v":2016},{"$f":"F131+1","v":2017},{"$f":"G131+1","v":2018},{"$f":"H131+1","v":2019},{"$f":"I131+1","v":2020},{"$f":"J131+1","v":2021},{"$f":"K131+1","v":2022},{"$f":"L131+1","v":2023},{"$f":"M131+1","v":2024},{"$f":"N131+1","v":2025}]
["Total charging station operating margin",null,null,null,null,{"$f":"F111-F129","v":13900.400000000001},{"$f":"G111-G129","v":21474.351999999999},30704.123993600006,41951.73467939601,55658.568070334804,72362.130865287705,82484.865572973009,82367.926736905443,82250.695553747704,82133.171292632091]
[]
["Charging Station Assumptions - Type 3"]
[]
["Charging station type",null,null,null,"DC fast charging (local)"]
[]
["Charging Station Capital Cost"]
["Equipment costs"]
["Charging station equipment cost (per station) [$]",null,null,null,35000]
["Installation and siting costs"]
["Construction and equipment installation cost (per station) [$]",null,null,null,26000]
["Electric utility upgrades and grid interconnection cost (per site) [$]",null,null,null,20000]
["Lease and property transaction costs (per site – one-time fee) [$]",null,null,null,6000]
["Host site identification and screening (per site) [$]",null,null,null,5000]
[]
["Total number of stations [#]",null,null,null,2]
["Total number of sites [#]",null,null,null,2]
[]
["Total initial Type 1 station capital required [$]",null,null,null,{"$f":"((E140+E142)*E147)+((E143+E144+E145)*E148)","v":184000}]
[]
["Annual depreciation [$]",null,null,null,{"$f":"E150/$E$6","v":18400}]
[]
[null,null,null,null,null,{"$f":"+'Initial Settings'!$C$7+1","v":2016},{"$f":"F154+1","v":2017},{"$f":"G154+1","v":2018},{"$f":"H154+1","v":2019},{"$f":"I154+1","v":2020},{"$f":"J154+1","v":2021},{"$f":"K154+1","v":2022},{"$f":"L154+1","v":2023},{"$f":"M154+1","v":2024},{"$f":"N154+1","v":2025}]
["Charging Station Utilization"]
["Maximum number of charging sessions per station [sessions/year/station]",null,null,null,{"$f":"365*10","v":3650}]
["Maximum number of charging sessions [sessions/year]",null,null,null,null,{"$f":"$E156*$E147","v":7300},7300,7300,7300,7300,7300,7300,7300,7300,7300]
["Projected number of charging sessions[sessions/year]",null,null,null,null,{"$f":"IF(COLUMN(F$6)-COLUMN($F$6)<$E$6,MIN(F157,'Market Inputs'!F43),0)","v":2400},{"$f":"IF(COLUMN(G$6)-COLUMN($F$6)<$E$6,MIN(G157,'Market Inputs'!G43),0)","v":2928},{"$f":"IF(COLUMN(H$6)-COLUMN($F$6)<$E$6,MIN(H157,'Market Inputs'!H43),0)","v":3572},{"$f":"IF(COLUMN(I$6)-COLUMN($F$6)<$E$6,MIN(I157,'Market Inputs'!I43),0)","v":4358},{"$f":"IF(COLUMN(J$6)-COLUMN($F$6)<$E$6,MIN(J157,'Market Inputs'!J43),0)","v":5317},{"$f":"IF(COLUMN(K$6)-COLUMN($F$6)<$E$6,MIN(K157,'Market Inputs'!K43),0)","v":6487},{"$f":"IF(COLUMN(L$6)-COLUMN($F$6)<$E$6,MIN(L157,'Market Inputs'!L43),0)","v":7300},{"$f":"IF(COLUMN(M$6)-COLUMN($F$6)<$E$6,MIN(M157,'Market Inputs'!M43),0)","v":7300},{"$f":"IF(COLUMN(N$6)-COLUMN($F$6)<$E$6,MIN(N157,'Market Inputs'!N43),0)","v":7300},{"$f":"IF(COLUMN(O$6)-COLUMN($F$6)<$E$6,MIN(O157,'Market Inputs'!O43),0)","v":7300}]
[]
["Energy Usage"]
["Average charging energy per session [kWh/session]",null,null,null,15]
["Energy used/sold [kWh/year]",null,null,null,null,{"$f":"IF(COLUMN(F$6)-COLUMN($F$6)<$E$6,F158*$E161,0)","v":36000},43920,53580,65370,79755,97305,109500,109500,109500,109500]
["Maximum power draw [kW/session]",null,null,null,50]
["Average time of charging session (minutes)",null,null,null,30]
[]
[null,null,null,null,null,{"$f":"+'Initial Settings'!$C$7+1","v":2016},{"$f":"F166+1","v":2017},{"$f":"G166+1","v":2018},{"$f":"H166+1","v":2019},{"$f":"I166+1","v":2020},{"$f":"J166+1","v":2021},{"$f":"K166+1","v":2022},{"$f":"L166+1","v":2023},{"$f":"M166+1","v":2024},{"$f":"N166+1","v":2025}]
["Charging Station Revenue [Operating Revenue - Direct]"]
[null,null,null,"Revenue Model Applies?"]
["Per-energy user fee [$/kWh]",null,null,"Y",0.5]
["Per-energy revenue",null,null,null,null,{"$f":"IF($D169=\"Y\",IF(COLUMN(F$6)-COLUMN($F$6)<$E$6,F162*$E169,0),0)","v":18000},21960,26790,32685,39877.5,48652.5,54750,54750,54750,54750]
["Per-charge event user fee [$/session]",null,null,"N",10]
["Per-charge event revenue",null,null,null,null,{"$f":"IF($D171=\"Y\",IF(COLUMN(F$6)-COLUMN($F$6)<$E$6,F158*$E171,0),0)","v":0},0,0,0,0,0,0,0,0,0]
[]
["Total charging station revenue",null,null,null,null,{"$f":"SUM(F170:F172)","v":18000},{"$f":"SUM(G170:G172)","v":21960},26790,32685,39877.5,48652.5,54750,54750,54750,54750]
[]
[null,null,null,null,null,{"$f":"+'Initial Settings'!$C$7+1","v":2016},{"$f":"F176+1","v":2017},{"$f":"G176+1","v":2018},{"$f":"H176+1","v":2019},{"$f":"I176+1","v":2020},{"$f":"J176+1","v":2021},{"$f":"K176+1","v":2022},{"$f":"L176+1","v":2023},{"$f":"M176+1","v":2024},{"$f":"N176+1","v":2025}]
["Charging Station Operating Cost [Cost of Sales]"]
["Electricity"]
["Electricity retail price in first year [$/kWh]",null,null,null,7.6799999999999993E-2]
["Annual compounded growth rate in electricity price [%]",null,null,null,2.5000000000000001E-3]
["Electricity retail price [$/kWh]",null,null,null,null,{"$f":"E179","v":7.6799999999999993E-2},{"$f":"F181*(1+$E180)","v":7.6991999999999991E-2},7.7184479999999986E-2,7.737744119999998E-2,7.7570884802999979E-2,7.776481201500747E-2,7.7959224045044989E-2,7.8154122105157597E-2,7.8349507410420488E-2,7.8545381178946536E-2]
["Energy cost (based on kWh)",null,null,null,null,{"$f":"IF(COLUMN(F$6)-COLUMN($F$6)<$E$6,F162*F181,0)","v":2764.7999999999997},3381.4886399999996,4135.5444383999993,5058.163331243999,6186.6659174632632,7566.9050331203016,8536.5350329324265,8557.8763705147576,8579.2710614410425,8600.7192390946457]
["Demand charge [$/kW/month]",null,null,null,1.26]
["Power cost (based on kW)",null,null,null,null,{"$f":"IF(COLUMN(F$6)-COLUMN($F$6)<$E$6,$E147*$E163*12*$E183,0)","v":1512},1512,1512,1512,1512,1512,1512,1512,1512,1512]
["Maintenance cost"]
["Annual maintenance cost as percentage of equipment value [%]",null,null,null,0.03]
["Maintenance cost (annual)",null,null,null,null,{"$f":"IF(COLUMN(F$6)-COLUMN($F$6)<$E$6,$E186*$E140*$E147,0)","v":2100},2100,2100,2100,2100,2100,2100,2100,2100,2100]
["Host site lease or access cost"]
["Host site lease or access cost (average per site/year) [$]",null,null,null,1200]
["Host site lease or access cost (annual)",null,null,null,null,{"$f":"IF(COLUMN(F$6)-COLUMN($F$6)<$E$6,$E189*$E148,0)","v":2400},2400,2400,2400,2400,2400,2400,2400,2400,2400]
[]
["Total charging operating cost",null,null,null,null,{"$f":"SUM(F182:F190)","v":8776.7999999999993},{"$f":"SUM(G182:G190)","v":9393.4886399999996},10147.5444384,11070.163331243999,12198.665917463262,13578.905033120302,14548.535032932426,14569.876370514758,14591.271061441043,14612.719239094646]
[]
[null,null,null,null,null,{"$f":"+'Initial Settings'!$C$7+1","v":2016},{"$f":"F194+1","v":2017},{"$f":"G194+1","v":2018},{"$f":"H194+1","v":2019},{"$f":"I194+1","v":2020},{"$f":"J194+1","v":2021},{"$f":"K194+1","v":2022},{"$f":"L194+1","v":2023},{"$f":"M194+1","v":2024},{"$f":"N194+1","v":2025}]
["Total charging station operating margin",null,null,null,null,{"$f":"F174-F192","v":9223.2000000000007},{"$f":"G174-G192","v":12566.51136},16642.4555616,21614.836668756001,27678.834082536738,35073.594966879697,40201.464967067572,40180.123629485242,40158.728938558954,40137.280760905356]
[]
["Additional Revenue Assumptions"]
[]
["Additional Operating Revenue",null,null,null,null,{"$f":"+'Initial Settings'!$C$7+1","v":2016},{"$f":"F199+1","v":2017},{"$f":"G199+1","v":2018},{"$f":"H199+1","v":2019},{"$f":"I199+1","v":2020},{"$f":"J199+1","v":2021},{"$f":"K199+1","v":2022},{"$f":"L199+1","v":2023},{"$f":"M199+1","v":2024},{"$f":"N199+1","v":2025}]
["Direct revenues"]
["Number of subscribers in first year [subscribers/year]",null,null,null,0]
["Annual growth rate in number of subscribers [%]",null,null,null,0.1]
["Number of subscribers [subscribers/year]",null,null,null,null,{"$f":"E201","v":0},{"$f":"ROUND(F203*(1+$E202),0)","v":0},0,0,0,0,0,0,0,0]
["Subscription fee [$/subscriber/year]",null,null,null,5]
["Subscription revenue",null,null,null,null,{"$f":"IF(COLUMN(F$6)-COLUMN($F$6)<$E$6,F203*$E$204,0)","v":0},{"$f":"IF(COLUMN(G$6)-COLUMN($F$6)<$E$6,G203*$E$204,0)","v":0},0,0,0,0,0,0,0,0]
[]
["Indirect revenues"]
["Payments from private sector partners",null,null,null,null,{"$f":"SUM('Private Sector Partner Inputs'!F54:F59)","v":151000},{"$f":"SUM('Private Sector Partner Inputs'!G54:G59)","v":68320},{"$f":"SUM('Private Sector Partner Inputs'!H54:H59)","v":83350},{"$f":"SUM('Private Sector Partner Inputs'!I54:I59)","v":101687.5},{"$f":"SUM('Private Sector Partner Inputs'!J54:J59)","v":124060},{"$f":"SUM('Private Sector Partner Inputs'!K54:K59)","v":151355},{"$f":"SUM('Private Sector Partner Inputs'!L54:L59)","v":168250},{"$f":"SUM('Private Sector Partner Inputs'!M54:M59)","v":168250},{"$f":"SUM('Private Sector Partner Inputs'!N54:N59)","v":168250},{"$f":"SUM('Private Sector Partner Inputs'!O54:O59)","v":168250}]
["Annual advertising revenue (In-station advertising) [$]",null,null,null,0,{"$f":"IF(COLUMN(F$6)-COLUMN($F$6)<$E$6,E209,0)","v":0},{"$f":"IF(COLUMN(G$6)-COLUMN($F$6)<$E$6,F209,0)","v":0},0,0,0,0,0,0,0,0]
[]
["Other Revenue"]
["Annual grants and rebates [$]",null,null,null,null,{"$f":"'Public Sector Partner Inputs'!F20","v":0},{"$f":"'Public Sector Partner Inputs'!G20","v":0},{"$f":"'Public Sector Partner Inputs'!H20","v":0},{"$f":"'Public Sector Partner Inputs'!I20","v":0},{"$f":"'Public Sector Partner Inputs'!J20","v":0},{"$f":"'Public Sector Partner Inputs'!K20","v":0},{"$f":"'Public Sector Partner Inputs'!L20","v":0},{"$f":"'Public Sector Partner Inputs'!M20","v":0},{"$f":"'Public Sector Partner Inputs'!N20","v":0},{"$f":"'Public Sector Partner Inputs'!O20","v":0}]
[]
["Total Additional Revenue",null,null,null,null,{"$f":"SUM(F205:F212)","v":151000},68320,83350,101687.5,124060,151355,168250,168250,168250,168250]
["Total Operating Revenue (from stations above)",null,null,null,null,{"$f":"F48+F111+F174","v":140000},170800,208377.5,254225,310155,378392.5,423750,423750,423750,423750]
["Total Revenue",null,null,null,null,{"$f":"SUM(F214:F215)","v":291000},239120,291727.5,355912.5,434215,529747.5,592000,592000,592000,592000]
[]
["Additional Cost Assumptions"]
[]
[null,null,null,null,null,{"$f":"+'Initial Settings'!$C$7+1","v":2016},{"$f":"F220+1","v":2017},{"$f":"G220+1","v":2018},{"$f":"H220+1","v":2019},{"$f":"I220+1","v":2020},{"$f":"J220+1","v":2021},{"$f":"K220+1","v":2022},{"$f":"L220+1","v":2023},{"$f":"M220+1","v":2024},{"$f":"N220+1","v":2025}]
["Additional Operating Costs"]
["Sales, General, and Administrative [% of Revenue]",null,null,null,0.05]
["Total Sales, General, and Administrative Costs",null,null,null,null,{"$f":"F216*$E$222","v":14550},11956,14586.375,17795.625,21710.75,26487.375,29600,29600,29600,29600]
["Total Cost of Sales (from stations above)",null,null,null,null,{"$f":"F66+F129+F192","v":79983.599999999991},86493.091199999995,94454.755965599994,104192.74263844198,116102.26151698151,130668.72782813357,140257.80959168912,140481.45511566836,140705.6597534575,140930.42490284113]
["Total Operating Cost",null,null,null,null,{"$f":"SUM(F223:F224)","v":94533.599999999991},98449.091199999995,109041.13096559999,121988.36763844198,137813.01151698153,157156.10282813356,169857.80959168912,170081.45511566836,170305.6597534575,170530.42490284113]
[]
["Initial Capitalization Assumptions"]
[]
["Initial Property, Plant, and Equipment ",null,null,null,{"$f":"E24+E87+E150","v":1355000}]
["Initial Operating Capital [2x SG&A] ",null,null,null,{"$f":"F262*2","v":29100}]
["Total Initial Capital Required",null,null,null,{"$f":"E229+E230","v":1384100}]
[]
["Percent Equity Funded [%]",null,null,0.4,{"$f":"D233*E231","v":553640}]
["Public Sector Portion of Equity (See public sector inputs)",null,null,{"$f":"'Public Sector Partner Inputs'!$E$14/($E$233-'Public Sector Partner Inputs'!$E$17)","v":0},{"$f":"$E$233*D234","v":0}]
["Private Sector Portion of Equity",null,null,{"$f":"1-D234","v":1},{"$f":"$E$233*D235","v":553640}]
["Percent Debt Funded [%]",null,null,{"$f":"1-D233","v":0.6},{"$f":"D236*E231","v":830460}]
["Public Sector Portion of Debt (See public sector inputs)",null,null,{"$f":"'Public Sector Partner Inputs'!$E$10/'Owner-Operator Inputs'!E236","v":0.5},{"$f":"$E$236*D237","v":415230}]
["Private Sector Portion of Debt",null,null,{"$f":"1-D237","v":0.5},{"$f":"$E$236*D238","v":415230}]
["Total Funded",null,null,null,{"$f":"E233+E236","v":1384100}]
[]
["Assumed EBITDA exit multiple",null,null,null,0,"<-Applies to all partners"]
[]
["Owner Operator Cost of Equity"]
["Risk Free Rate",null,null,null,1.2500000000000001E-2]
["Beta",null,null,null,0.9]
["Market Risk Premium",null,null,null,0.1]
["Owner Operator Cost of Equity",null,null,null,{"$f":"E244+(E245*E246)","v":0.10250000000000001}]
[]
["Maximum Debt Term [years]",null,null,null,10]
["Owner Operator Cost of Debt (Long Term)",null,{"$f":"'Sensitivity Tables'!$A$77","v":0.08},null,0.08,"*Sensitivity analysis variable"]
[]
["Income Statement Assumptions",null,null,null,null,null,null,null,null," "," "," "," "," "," "]
[]
[null,null,null,null,null,{"$f":"+'Initial Settings'!$C$7+1","v":2016},{"$f":"F254+1","v":2017},{"$f":"G254+1","v":2018},{"$f":"H254+1","v":2019},{"$f":"I254+1","v":2020},{"$f":"J254+1","v":2021},{"$f":"K254+1","v":2022},{"$f":"L254+1","v":2023},{"$f":"M254+1","v":2024},{"$f":"N254+1","v":2025}]
["Revenues"]
["Operating Revenue",null,null,null,null,{"$f":"F215","v":140000},170800,208377.5,254225,310155,378392.5,423750,423750,423750,423750]
["Other Revenue",null,null,null,null,{"$f":"F214","v":151000},68320,83350,101687.5,124060,151355,168250,168250,168250,168250]
[]
["Expenses "]
["Cost of Sales",null,null,null,null,{"$f":"F224","v":79983.599999999991},86493.091199999995,94454.755965599994,104192.74263844198,116102.26151698151,130668.72782813357,140257.80959168912,140481.45511566836,140705.6597534575,140930.42490284113]
["Other Expenses"]
["SG&A",null,null,null,null,{"$f":"F223","v":14550},11956,14586.375,17795.625,21710.75,26487.375,29600,29600,29600,29600]
["Depreciation",null,null,null,null,{"$f":"IF(COLUMN(F$6)-COLUMN($F$6)<$E$6,$E$26+$E$89+$E$152,0)","v":135500},{"$f":"IF(COLUMN(G$6)-COLUMN($F$6)<$E$6,$E$26+$E$89+$E$152,0)","v":135500},135500,135500,135500,135500,135500,135500,135500,135500]
[]
["Interest Income [$]",null,null,null,null,0,0,0,0,0,0,0,0,0,0]
["Other Income, Net [$]",null,null,null,null,0,0,0,0,0,0,0,0,0,0]
["Other Special Charges [$]",null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[]
["Interest Expense Rate [%] (Long Term Debt)",null,null,null,null,"See debt schedule"]
["Interest Expense Rate [%] (Revolving Line of Credit)",null,null,null,null,4.2599999999999999E-2,4.2599999999999999E-2,4.2599999999999999E-2,4.2599999999999999E-2,4.2599999999999999E-2,4.2599999999999999E-2,4.2599999999999999E-2,4.2599999999999999E-2,4.2599999999999999E-2,4.2599999999999999E-2]
[]
["Income Tax Rate [%]",null,null,null,0.31600527163567099,{"$f":"$E$272","v":0.31600527163567099},0.31600527163567099,0.31600527163567099,0.31600527163567099,0.31600527163567099,0.31600527163567099,0.31600527163567099,0.31600527163567099,0.31600527163567099,0.31600527163567099]
[]
["Projected Shares Outstanding (Millions)",null,null,null,1,{"$f":"$E$274","v":1},1,1,1,1,1,1,1,1,1]
[]
["Balance Sheet Assumptions"]
[]
[null,null,null,null,null,{"$f":"+'Initial Settings'!$C$7+1","v":2016},{"$f":"F278+1","v":2017},{"$f":"G278+1","v":2018},{"$f":"H278+1","v":2019},{"$f":"I278+1","v":2020},{"$f":"J278+1","v":2021},{"$f":"K278+1","v":2022},{"$f":"L278+1","v":2023},{"$f":"M278+1","v":2024},{"$f":"N278+1","v":2025}]
["Assets"]
["Current assets"]
["Cash and Equivalents"]
["Accounts Receivable [% of Revenue]",null,null,null,null,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05,0.05]
["Other Receivable [% of Revenue]",null,null,null,null,0,0,0,0,0,0,0,0,0,0]
["Prepaid Expenses [% of Revenue]",null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[]
["Non-Current Assets"]
["Gross Fixed Assets (Plant, Prop. & Equip.)",null,null,null,{"$f":"$E$229","v":1355000},{"$f":"$E$229","v":1355000},1355000,1355000,1355000,1355000,1355000,1355000,1355000,1355000,1355000]
["Accumulated Depreciation & Depletion",null,null,null,null,{"$f":"-F263","v":-135500},{"$f":"F288-G263","v":-271000},-406500,-542000,-677500,-813000,-948500,-1084000,-1219500,-1355000]
["Intangibles (Goodwill)",null,null,null,null,0,0,0,0,0,0,0,0,0,0]
["Other Non-Current Assets",null,null,null,null,0,0,0,0,0,0,0,0,0,0]
[]
["Liabilities and stockholders' equity"]
["Current Liabilities"]
["Accounts Payable [% of Revenue]",null,null,null,null,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12,0.12]
["Revolving Line of Credit [% of Revenue]",null,null,null,null,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03,0.03]
["Current Portion of Long Term Debt",null,null,null,{"$f":"-'Debt Schedule'!D15","v":61064.406699253363},{"$f":"-'Debt Schedule'!E15","v":65107.125640396902},{"$f":"-'Debt Schedule'!F15","v":69427.770682712886},{"$f":"-'Debt Schedule'!G15","v":74046.119377932715},{"$f":"-'Debt Schedule'!H15","v":78983.398828962672},{"$f":"-'Debt Schedule'!I15","v":84262.394490717968},{"$f":"-'Debt Schedule'!J15","v":89907.567288207356},{"$f":"-'Debt Schedule'!K15","v":95945.179696360443},{"$f":"-'Debt Schedule'!L15","v":102403.43147652096},{"$f":"-'Debt Schedule'!M15","v":109312.60581893474},{"$f":"-'Debt Schedule'!N15","v":0}]
[]
["Non-Current Liabilities"]
["Long Term Debt, Net Current Portion",null,null,null,{"$f":"$E$236-E296","v":769395.59330074664},{"$f":"E299-F296","v":704288.46766034979},634860.69697763689,560814.57759970415,481831.17877074145,397568.78428002348,307661.21699181612,211716.0372954557,109312.60581893474,0,0]

{"sheet":"Private Sector Partner Inputs","index":4,"n_rows":62,"n_cols":15,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Initial Settings'!$C$6","v":"Washington EV - Business Model 3 - Walla Walla"}]
[]
[]
["Private Sector Partner(s) Inputs"]
[]
["Private Sector Weighted Average Cost of Capital (WACC)",null,null,null,0.1033]
["Private Sector Cost of Goods Sold [% of Revenue]",null,null,null,0.8]
["Private Sector Marginal Tax Rate",null,null,null,0.31600527163567099]
[]
["Revenues"]
[null,null,null,null,null,{"$f":"+'Initial Settings'!$C$7+1","v":2016},{"$f":"F11+1","v":2017},2018,2019,2020,2021,2022,2023,2024,2025]
["Site Leasing Revenue"]
["Private sector captures host site lease / access fees?",null,null,null,"N"]
["Revenue from leases / access fees ($)",null,null,null,null,{"$f":"IF($E$13=\"Y\",'Owner-Operator Inputs'!F127+'Owner-Operator Inputs'!F64+'Owner-Operator Inputs'!F190,0)","v":0},{"$f":"IF($E$13=\"Y\",'Owner-Operator Inputs'!G127+'Owner-Operator Inputs'!G64+'Owner-Operator Inputs'!G190,0)","v":0},{"$f":"IF($E$13=\"Y\",'Owner-Operator Inputs'!H127+'Owner-Operator Inputs'!H64+'Owner-Operator Inputs'!H190,0)","v":0},{"$f":"IF($E$13=\"Y\",'Owner-Operator Inputs'!I127+'Owner-Operator Inputs'!I64+'Owner-Operator Inputs'!I190,0)","v":0},{"$f":"IF($E$13=\"Y\",'Owner-Operator Inputs'!J127+'Owner-Operator Inputs'!J64+'Owner-Operator Inputs'!J190,0)","v":0},{"$f":"IF($E$13=\"Y\",'Owner-Operator Inputs'!K127+'Owner-Operator Inputs'!K64+'Owner-Operator Inputs'!K190,0)","v":0},{"$f":"IF($E$13=\"Y\",'Owner-Operator Inputs'!L127+'Owner-Operator Inputs'!L64+'Owner-Operator Inputs'!L190,0)","v":0},{"$f":"IF($E$13=\"Y\",'Owner-Operator Inputs'!M127+'Owner-Operator Inputs'!M64+'Owner-Operator Inputs'!M190,0)","v":0},{"$f":"IF($E$13=\"Y\",'Owner-Operator Inputs'!N127+'Owner-Operator Inputs'!N64+'Owner-Operator Inputs'!N190,0)","v":0},{"$f":"IF($E$13=\"Y\",'Owner-Operator Inputs'!O127+'Owner-Operator Inputs'!O64+'Owner-Operator Inputs'!O190,0)","v":0}]
[]
["Point of Sale Revenue (Increases in revenue due to increased customer traffic)"]
["Average expected revenue per customer per minute ($)",null,{"$f":"'Sensitivity Tables'!$A$162","v":1},null,1,"*Sensitivity analysis variable"]
[]
["Type 1 stations capture customer traffic revenue",null,null,null,"N"]
["Maximum retail revenue per customer per session for type 1 stations ($)",null,{"$f":"'Sensitivity Tables'!$A$179","v":20},null,20,"*Sensitivity analysis variable"]
["Number of additional visits per year for type 1 stations (visits)",null,null,null,null,{"$f":"'Owner-Operator Inputs'!F$32","v":9600},{"$f":"'Owner-Operator Inputs'!G$32","v":11712},{"$f":"'Owner-Operator Inputs'!H$32","v":14289},{"$f":"'Owner-Operator Inputs'!I$32","v":17433},{"$f":"'Owner-Operator Inputs'!J$32","v":21268},{"$f":"'Owner-Operator Inputs'!K$32","v":25947},{"$f":"'Owner-Operator Inputs'!L$32","v":29200},{"$f":"'Owner-Operator Inputs'!M$32","v":29200},{"$f":"'Owner-Operator Inputs'!N$32","v":29200},{"$f":"'Owner-Operator Inputs'!O$32","v":29200}]
["Average time spent per customer per visit for type 1 stations (minutes)",null,null,null,{"$f":"'Owner-Operator Inputs'!$E$38","v":30}]
["Expected annual revenue from increased traffic for type 1 stations",null,null,null,null,{"$f":"IF($E19=\"Y\",MIN(F21*$E22*$C$17,F21*$C20),)","v":0},0,0,0,0,0,0,0,0,0]
[]
["Type 2 stations capture customer traffic revenue",null,null,null,"Y"]
["Maximum retail revenue per customer per session for type 2 stations ($)",null,{"$f":"'Sensitivity Tables'!$A$196","v":25},null,25,"*Sensitivity analysis variable"]
["Number of additional visits per year for type 2 stations (visits)",null,null,null,null,{"$f":"'Owner-Operator Inputs'!F$95","v":20000},{"$f":"'Owner-Operator Inputs'!G$95","v":24400},{"$f":"'Owner-Operator Inputs'!H$95","v":29768},{"$f":"'Owner-Operator Inputs'!I$95","v":36317},{"$f":"'Owner-Operator Inputs'!J$95","v":44307},{"$f":"'Owner-Operator Inputs'!K$95","v":54055},{"$f":"'Owner-Operator Inputs'!L$95","v":60000},{"$f":"'Owner-Operator Inputs'!M$95","v":60000},{"$f":"'Owner-Operator Inputs'!N$95","v":60000},{"$f":"'Owner-Operator Inputs'!O$95","v":60000}]
["Average time spent per customer per visit for type 2 stations (minutes)",null,null,null,{"$f":"'Owner-Operator Inputs'!E101","v":90}]
["Expected annual revenue from increased traffic for type 2 stations",null,null,null,null,{"$f":"IF($E25=\"Y\",MIN(F27*$E28*$C$17,F27*$C26),)","v":500000},610000,744200,907925,1107675,1351375,1500000,1500000,1500000,1500000]
[]
["Type 3 stations capture customer traffic revenue",null,null,null,"Y"]
["Maximum retail revenue per customer per session for type 3 stations ($)",null,{"$f":"'Sensitivity Tables'!$A$213","v":25},null,25,"*Sensitivity analysis variable"]
["Number of additional visits per year for type 3 stations (visits)",null,null,null,null,{"$f":"'Owner-Operator Inputs'!F$158","v":2400},{"$f":"'Owner-Operator Inputs'!G$158","v":2928},{"$f":"'Owner-Operator Inputs'!H$158","v":3572},{"$f":"'Owner-Operator Inputs'!I$158","v":4358},{"$f":"'Owner-Operator Inputs'!J$158","v":5317},{"$f":"'Owner-Operator Inputs'!K$158","v":6487},{"$f":"'Owner-Operator Inputs'!L$158","v":7300},{"$f":"'Owner-Operator Inputs'!M$158","v":7300},{"$f":"'Owner-Operator Inputs'!N$158","v":7300},{"$f":"'Owner-Operator Inputs'!O$158","v":7300}]
["Average time spent per customer per visit for type 3 stations (minutes)",null,null,null,{"$f":"'Owner-Operator Inputs'!E164","v":30}]
["Expected annual revenue from increased traffic for type 3 stations",null,null,null,null,{"$f":"IF($E31=\"Y\",MIN(F33*$E34*$C$17,F33*$C32),)","v":60000},73200,89300,108950,132925,162175,182500,182500,182500,182500]
[]
["Indirect Revenue (Increases unrelated to customer time spent at station)"]
["Estimated NPV of lifetime after-tax profit per station - type 1 station [$]",null,{"$f":"'Sensitivity Tables'!$A$94","v":10694},null,10694,"*Sensitivity analysis variable"]
["Annual per station indirect revenue - type 1 stations [$]",null,null,null,{"$f":"((-PMT($E$6,10,(C38))/(1-$E$8))/(1-$E$7))*0.62","v":7999.9999866810131}]
["Total annual indirect revenue all type 1 stations",null,null,null,null,{"$f":"$E39*'Owner-Operator Inputs'!$E$21","v":63999.999893448105},{"$f":"$E39*'Owner-Operator Inputs'!$E$21","v":63999.999893448105},{"$f":"$E39*'Owner-Operator Inputs'!$E$21","v":63999.999893448105},{"$f":"$E39*'Owner-Operator Inputs'!$E$21","v":63999.999893448105},{"$f":"$E39*'Owner-Operator Inputs'!$E$21","v":63999.999893448105},{"$f":"$E39*'Owner-Operator Inputs'!$E$21","v":63999.999893448105},{"$f":"$E39*'Owner-Operator Inputs'!$E$21","v":63999.999893448105},{"$f":"$E39*'Owner-Operator Inputs'!$E$21","v":63999.999893448105},{"$f":"$E39*'Owner-Operator Inputs'!$E$21","v":63999.999893448105},{"$f":"$E39*'Owner-Operator Inputs'!$E$21","v":63999.999893448105}]
["Estimated NPV of lifetime after-tax profit per station - type 2 station [$]",null,{"$f":"'Sensitivity Tables'!$A$111","v":500},null,500,"*Sensitivity analysis variable"]
["Annual per station indirect revenue - type 2 stations [$]",null,null,null,{"$f":"((-PMT($E$6,10,(C41))/(1-$E$8))/(1-$E$7))*0.62","v":374.04151798583371}]
["Total annual indirect revenue all type 2 stations",null,null,null,null,{"$f":"$E42*'Owner-Operator Inputs'!$E$84","v":18702.075899291685},{"$f":"$E42*'Owner-Operator Inputs'!$E$84","v":18702.075899291685},{"$f":"$E42*'Owner-Operator Inputs'!$E$84","v":18702.075899291685},{"$f":"$E42*'Owner-Operator Inputs'!$E$84","v":18702.075899291685},{"$f":"$E42*'Owner-Operator Inputs'!$E$84","v":18702.075899291685},{"$f":"$E42*'Owner-Operator Inputs'!$E$84","v":18702.075899291685},{"$f":"$E42*'Owner-Operator Inputs'!$E$84","v":18702.075899291685},{"$f":"$E42*'Owner-Operator Inputs'!$E$84","v":18702.075899291685},{"$f":"$E42*'Owner-Operator Inputs'!$E$84","v":18702.075899291685},{"$f":"$E42*'Owner-Operator Inputs'!$E$84","v":18702.075899291685}]
["Estimated NPV of lifetime after-tax profit per station - type 3 station [$]",null,{"$f":"'Sensitivity Tables'!$A$128","v":10694},null,10694,"*Sensitivity analysis variable"]
["Annual per station indirect revenue - type 3 stations [$]",null,null,null,{"$f":"((-PMT($E$6,10,(C44))/(1-$E$8))/(1-$E$7))*0.62","v":7999.9999866810131}]
["Total annual indirect revenue all type 3 stations",null,null,null,null,{"$f":"$E45*'Owner-Operator Inputs'!$E$147","v":15999.999973362026},{"$f":"$E45*'Owner-Operator Inputs'!$E$147","v":15999.999973362026},{"$f":"$E45*'Owner-Operator Inputs'!$E$147","v":15999.999973362026},{"$f":"$E45*'Owner-Operator Inputs'!$E$147","v":15999.999973362026},{"$f":"$E45*'Owner-Operator Inputs'!$E$147","v":15999.999973362026},{"$f":"$E45*'Owner-Operator Inputs'!$E$147","v":15999.999973362026},{"$f":"$E45*'Owner-Operator Inputs'!$E$147","v":15999.999973362026},{"$f":"$E45*'Owner-Operator Inputs'!$E$147","v":15999.999973362026},{"$f":"$E45*'Owner-Operator Inputs'!$E$147","v":15999.999973362026},{"$f":"$E45*'Owner-Operator Inputs'!$E$147","v":15999.999973362026}]
["Total annual indirect revenue",null,null,null,null,{"$f":"SUM(F40:F46)","v":98702.075766101814},{"$f":"SUM(G40:G46)","v":98702.075766101814},98702.075766101814,98702.075766101814,98702.075766101814,98702.075766101814,98702.075766101814,98702.075766101814,98702.075766101814,98702.075766101814]
[]
["Total expected revenue",null,null,null,null,{"$f":"F14+F23+F29+F35+F47","v":658702.07576610183},781902.07576610183,932202.07576610183,1115577.0757661017,1339302.0757661017,1612252.0757661017,1781202.0757661017,1781202.0757661017,1781202.0757661017,1781202.0757661017]
[]
["Costs"]
[null,null,null,null,null,{"$f":"+'Initial Settings'!$C$7+1","v":2016},{"$f":"F52+1","v":2017},{"$f":"G52+1","v":2018},{"$f":"H52+1","v":2019},{"$f":"I52+1","v":2020},{"$f":"J52+1","v":2021},{"$f":"K52+1","v":2022},{"$f":"L52+1","v":2023},{"$f":"M52+1","v":2024},{"$f":"N52+1","v":2025}]
["Cost of Goods Sold",null,null,null,null,{"$f":"(F23+F29+F35+F47)*$E$7","v":526961.66061288153},625521.66061288153,745761.66061288153,892461.66061288142,1071441.6606128814,1289801.6606128814,1424961.6606128814,1424961.6606128814,1424961.6606128814,1424961.6606128814]
["Annual customer revenue sharing agreement (from sales) [% of revenue]",null,{"$f":"'Sensitivity Tables'!$A$145","v":0.1},null,0.1,"*Sensitivity analysis variable"]
["Annual customer revenue sharing costs (paid to owner operator) [$]",null,null,null,null,{"$f":"(F23+F29+F35)*$C$54","v":56000},{"$f":"(G23+G29+G35)*$C$54","v":68320},83350,101687.5,124060,151355,168250,168250,168250,168250]
["Per Station Subsidy - Type 1 Stations [$]",null,null,null,7000]
["Per Station Subsidy - Type 2 Stations [$]",null,null,null,500]
["Per Station Subsidy - Type 3 Stations [$]",null,null,null,7000]
["One-time initial charging equipment cost subsidy (paid to owner operator) [$]",null,null,null,null,{"$f":"'Owner-Operator Inputs'!$E$21*$E$56+'Owner-Operator Inputs'!$E$84*$E$57+'Owner-Operator Inputs'!$E$147*$E$58","v":95000}]
["Annual flat fee (paid to owner operator) [$]",null,null,null,0,{"$f":"$E$60","v":0},{"$f":"$E$60","v":0},0,0,0,0,0,0,0,0]
[]
["Total expected costs",null,null,null,null,{"$f":"SUM(F53:F60)","v":677961.66061288153},{"$f":"SUM(G53:G60)","v":693841.66061288153},829111.66061288153,994149.16061288142,1195501.6606128814,1441156.6606128814,1593211.6606128814,1593211.6606128814,1593211.6606128814,1593211.6606128814]

{"sheet":"Public Sector Partner Inputs","index":5,"n_rows":20,"n_cols":15,"rows_kept":20,"cut":false,"hidden":false,"merged":[[17,0,17,2]]}
[{"$f":"'Initial Settings'!$C$6","v":"Washington EV - Business Model 3 - Walla Walla"}]
[]
[]
["Public Sector Partner Inputs"]
[]
["Public Sector Cost of Capital [%]",null,null,null,5.3999999999999999E-2]
[]
["Support for Initial Capitalization of Charging Infrastructure"]
["Amount of debt needed",null,null,null,{"$f":"'Owner-Operator Inputs'!E236","v":830460}]
["Public sector funded portion of debt [% of debt needed]",null,null,0.5,{"$f":"E9*D10","v":415230}]
["Term [years]",null,null,null,10]
["Rate (APR) [%]",null,null,null,5.3999999999999999E-2]
["Amount of equity needed",null,null,null,{"$f":"'Owner-Operator Inputs'!E233","v":553640},null,{"$f":"('Owner-Operator Inputs'!E14*'Owner-Operator Inputs'!E21)+('Owner-Operator Inputs'!E77*'Owner-Operator Inputs'!E84)+('Owner-Operator Inputs'!E140*'Owner-Operator Inputs'!E147)","v":475000},"<-Total equipment cost"]
["Public sector funded portion of equity investment [% of equity needed]",null,null,0,{"$f":"E13*D14","v":0},null,{"$f":"E17/G13","v":0.49999999999999939},"<-Percent of equipment cost funded by grant"]
["Public sector equity has capped annual returns?",null,null,null,"N"]
["Annual equity return cap [%]",null,null,null,5.3999999999999999E-2]
["Non-shareholder contribution to capital (grants, etc.) [% of equity needed]",null,null,0.42897912000577942,{"$f":"E13*D17","v":237499.99999999971}]
["Equity amount + grant amount should not exceed 100%-->",null,null,{"$f":"D17+D14","v":0.42897912000577942}]
["Projected Additional Ongoing Support ",null,null,null,null,{"$f":"+'Initial Settings'!$C$7+1","v":2016},{"$f":"F19+1","v":2017},{"$f":"G19+1","v":2018},2019,2020,2021,2022,2023,2024,2025]
["Other annual non-revolving support (grants, etc.) [$]"]

{"sheet":"Owner-Operator DCF","index":6,"n_rows":28,"n_cols":13,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Initial Settings'!$C$6","v":"Washington EV - Business Model 3 - Walla Walla"}]
[]
[]
["Owner/Operator Discounted Cash Flow Model",null,{"$f":"'Initial Settings'!$C$7","v":2015},{"$f":"'Owner-Operator Inputs'!F254","v":2016},{"$f":"'Owner-Operator Inputs'!G254","v":2017},{"$f":"'Owner-Operator Inputs'!H254","v":2018},{"$f":"'Owner-Operator Inputs'!I254","v":2019},{"$f":"'Owner-Operator Inputs'!J254","v":2020},{"$f":"'Owner-Operator Inputs'!K254","v":2021},{"$f":"'Owner-Operator Inputs'!L254","v":2022},{"$f":"'Owner-Operator Inputs'!M254","v":2023},{"$f":"'Owner-Operator Inputs'!N254","v":2024},{"$f":"'Owner-Operator Inputs'!O254","v":2025}]
[]
["Revenue",null,null,{"$f":"'Owner-Operator Inputs'!F216","v":291000},{"$f":"'Owner-Operator Inputs'!G216","v":239120},{"$f":"'Owner-Operator Inputs'!H216","v":291727.5},{"$f":"'Owner-Operator Inputs'!I216","v":355912.5},{"$f":"'Owner-Operator Inputs'!J216","v":434215},{"$f":"'Owner-Operator Inputs'!K216","v":529747.5},{"$f":"'Owner-Operator Inputs'!L216","v":592000},{"$f":"'Owner-Operator Inputs'!M216","v":592000},{"$f":"'Owner-Operator Inputs'!N216","v":592000},{"$f":"'Owner-Operator Inputs'!O216","v":592000}]
["Operating Costs",null,null,{"$f":"-'Owner-Operator Inputs'!F225","v":-94533.599999999991},{"$f":"-'Owner-Operator Inputs'!G225","v":-98449.091199999995},{"$f":"-'Owner-Operator Inputs'!H225","v":-109041.13096559999},{"$f":"-'Owner-Operator Inputs'!I225","v":-121988.36763844198},{"$f":"-'Owner-Operator Inputs'!J225","v":-137813.01151698153},{"$f":"-'Owner-Operator Inputs'!K225","v":-157156.10282813356},{"$f":"-'Owner-Operator Inputs'!L225","v":-169857.80959168912},{"$f":"-'Owner-Operator Inputs'!M225","v":-170081.45511566836},{"$f":"-'Owner-Operator Inputs'!N225","v":-170305.6597534575},{"$f":"-'Owner-Operator Inputs'!O225","v":-170530.42490284113}]
["EBITDA",null,null,{"$f":"SUM(D6:D7)","v":196466.40000000002},140670.9088,182686.36903440001,233924.13236155803,296401.98848301847,372591.39717186644,422142.19040831085,421918.54488433164,421694.34024654247,421469.5750971589]
["Dep & Amortization",null,null,{"$f":"-'Owner-Operator Inputs'!F263","v":-135500},{"$f":"-'Owner-Operator Inputs'!G263","v":-135500},{"$f":"-'Owner-Operator Inputs'!H263","v":-135500},{"$f":"-'Owner-Operator Inputs'!I263","v":-135500},{"$f":"-'Owner-Operator Inputs'!J263","v":-135500},{"$f":"-'Owner-Operator Inputs'!K263","v":-135500},{"$f":"-'Owner-Operator Inputs'!L263","v":-135500},{"$f":"-'Owner-Operator Inputs'!M263","v":-135500},{"$f":"-'Owner-Operator Inputs'!N263","v":-135500},{"$f":"-'Owner-Operator Inputs'!O263","v":-135500}]
["Operating Income (EBIT)",null,null,{"$f":"SUM(D8:D9)","v":60966.400000000023},5170.9088000000047,47186.369034400006,98424.132361558033,160901.98848301847,237091.39717186644,286642.19040831085,286418.54488433164,286194.34024654247,285969.5750971589]
["Interest Expense",null,null,{"$f":"'Income Statement'!C30","v":-56012.718000000001},{"$f":"'Income Statement'!D30","v":-51903.696418856467},{"$f":"'Income Statement'!E30","v":-47650.283761540479},{"$f":"'Income Statement'!F30","v":-43113.963496320648},{"$f":"'Income Statement'!G30","v":-38276.754640290696},{"$f":"'Income Statement'!H30","v":-33119.849513535395},{"$f":"'Income Statement'!I30","v":-27554.235411046},{"$f":"'Income Statement'!J30","v":-21516.62300289292},{"$f":"'Income Statement'!K30","v":-15058.371222732407},{"$f":"'Income Statement'!L30","v":-8149.196880318631}]
["Income Before Taxes (EBT)",null,null,{"$f":"SUM(D10:D11)","v":4953.6820000000225},-46732.787618856462,-463.91472714047268,55310.168865237385,122625.23384272779,203971.54765833105,259087.95499726484,264901.9218814387,271135.96902381006,277820.37821684027]
["Taxes",null,null,{"$f":"-D12*'Owner-Operator Inputs'!F272","v":-1565.3896260067411},{"$f":"-E12*'Owner-Operator Inputs'!G272","v":14767.807245788859},{"$f":"-F12*'Owner-Operator Inputs'!H272","v":146.59949936581327},{"$f":"-G12*'Owner-Operator Inputs'!I272","v":-17478.304936474171},{"$f":"-H12*'Owner-Operator Inputs'!J272","v":-38750.220329858872},{"$f":"-I12*'Owner-Operator Inputs'!K272","v":-64456.084323719115},{"$f":"-J12*'Owner-Operator Inputs'!L272","v":-81873.159596441183},{"$f":"-K12*'Owner-Operator Inputs'!M272","v":-83710.403780955327},{"$f":"-L12*'Owner-Operator Inputs'!N272","v":-85680.395541569975},{"$f":"-M12*'Owner-Operator Inputs'!O272","v":-87792.704084337456}]
["Cash Flow from Operations",null,null,{"$f":"D8+D11+D13","v":138888.29237399329},103535.01962693239,135182.68477222533,173331.86392876322,219375.0135128689,275015.46333461197,312714.79540082364,316691.51810048334,320955.57348224008,325527.67413250281]
["Change in Non-cash Assets",null,null,{"$f":"-(SUM('Balance Sheet'!C8:C10)-SUM('Balance Sheet'!B8:B10)+('Balance Sheet'!C14-'Balance Sheet'!B14))","v":-14550},{"$f":"-(SUM('Balance Sheet'!D8:D10)-SUM('Balance Sheet'!C8:C10)+('Balance Sheet'!D14-'Balance Sheet'!C14))","v":2594},{"$f":"-(SUM('Balance Sheet'!E8:E10)-SUM('Balance Sheet'!D8:D10)+('Balance Sheet'!E14-'Balance Sheet'!D14))","v":-2630.375},{"$f":"-(SUM('Balance Sheet'!F8:F10)-SUM('Balance Sheet'!E8:E10)+('Balance Sheet'!F14-'Balance Sheet'!E14))","v":-3209.25},{"$f":"-(SUM('Balance Sheet'!G8:G10)-SUM('Balance Sheet'!F8:F10)+('Balance Sheet'!G14-'Balance Sheet'!F14))","v":-3915.125},{"$f":"-(SUM('Balance Sheet'!H8:H10)-SUM('Balance Sheet'!G8:G10)+('Balance Sheet'!H14-'Balance Sheet'!G14))","v":-4776.625},{"$f":"-(SUM('Balance Sheet'!I8:I10)-SUM('Balance Sheet'!H8:H10)+('Balance Sheet'!I14-'Balance Sheet'!H14))","v":-3112.625},{"$f":"-(SUM('Balance Sheet'!J8:J10)-SUM('Balance Sheet'!I8:I10)+('Balance Sheet'!J14-'Balance Sheet'!I14))","v":0},{"$f":"-(SUM('Balance Sheet'!K8:K10)-SUM('Balance Sheet'!J8:J10)+('Balance Sheet'!K14-'Balance Sheet'!J14))","v":0},{"$f":"-(SUM('Balance Sheet'!L8:L10)-SUM('Balance Sheet'!K8:K10)+('Balance Sheet'!L14-'Balance Sheet'!K14))","v":0}]
["Change in Liabilities",null,null,{"$f":"'Balance Sheet'!C33-'Balance Sheet'!B33","v":-17414.406699253246},{"$f":"'Balance Sheet'!D33-'Balance Sheet'!C33","v":-72889.12564039696},{"$f":"'Balance Sheet'!E33-'Balance Sheet'!D33","v":-61536.6456827129},{"$f":"'Balance Sheet'!F33-'Balance Sheet'!E33","v":-64418.369377932744},{"$f":"'Balance Sheet'!G33-'Balance Sheet'!F33","v":-67238.023828962701},{"$f":"'Balance Sheet'!H33-'Balance Sheet'!G33","v":-69932.519490717968},{"$f":"'Balance Sheet'!I33-'Balance Sheet'!H33","v":-80569.692288207356},{"$f":"'Balance Sheet'!J33-'Balance Sheet'!I33","v":-95945.179696360428},{"$f":"'Balance Sheet'!K33-'Balance Sheet'!J33","v":-102403.43147652096},{"$f":"'Balance Sheet'!L33-'Balance Sheet'!K33","v":-109312.60581893474}]
[]
["Free Cash Flow to Equity",null,null,{"$f":"SUM(D14:D16)","v":106923.88567474004},33239.893986535433,71015.664089512429,105704.24455083048,148221.8646839062,200306.318843894,229032.47811261629,220746.33840412291,218552.14200571913,216215.06831356807]
["Terminal Value",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Terminal Value Model'!M16","v":-88800}]
["Free Cash Flow to Public Equity Holders",null,null,{"$f":"IF('Public Sector Partner Inputs'!$E$15=\"Y\",MIN(SUM(D18:D19)*'Owner-Operator Inputs'!$D$234,'Balance Sheet'!C$36*'Owner-Operator Inputs'!$D$234*pusp_equity_return_cap),SUM(D18:D19)*'Owner-Operator Inputs'!$D$234)","v":0},{"$f":"IF('Public Sector Partner Inputs'!$E$15=\"Y\",MIN(SUM(E18:E19)*'Owner-Operator Inputs'!$D$234,'Balance Sheet'!D$36*'Owner-Operator Inputs'!$D$234*pusp_equity_return_cap),SUM(E18:E19)*'Owner-Operator Inputs'!$D$234)","v":0},{"$f":"IF('Public Sector Partner Inputs'!$E$15=\"Y\",MIN(SUM(F18:F19)*'Owner-Operator Inputs'!$D$234,'Balance Sheet'!E$36*'Owner-Operator Inputs'!$D$234*pusp_equity_return_cap),SUM(F18:F19)*'Owner-Operator Inputs'!$D$234)","v":0},{"$f":"IF('Public Sector Partner Inputs'!$E$15=\"Y\",MIN(SUM(G18:G19)*'Owner-Operator Inputs'!$D$234,'Balance Sheet'!F$36*'Owner-Operator Inputs'!$D$234*pusp_equity_return_cap),SUM(G18:G19)*'Owner-Operator Inputs'!$D$234)","v":0},{"$f":"IF('Public Sector Partner Inputs'!$E$15=\"Y\",MIN(SUM(H18:H19)*'Owner-Operator Inputs'!$D$234,'Balance Sheet'!G$36*'Owner-Operator Inputs'!$D$234*pusp_equity_return_cap),SUM(H18:H19)*'Owner-Operator Inputs'!$D$234)","v":0},{"$f":"IF('Public Sector Partner Inputs'!$E$15=\"Y\",MIN(SUM(I18:I19)*'Owner-Operator Inputs'!$D$234,'Balance Sheet'!H$36*'Owner-Operator Inputs'!$D$234*pusp_equity_return_cap),SUM(I18:I19)*'Owner-Operator Inputs'!$D$234)","v":0},{"$f":"IF('Public Sector Partner Inputs'!$E$15=\"Y\",MIN(SUM(J18:J19)*'Owner-Operator Inputs'!$D$234,'Balance Sheet'!I$36*'Owner-Operator Inputs'!$D$234*pusp_equity_return_cap),SUM(J18:J19)*'Owner-Operator Inputs'!$D$234)","v":0},{"$f":"IF('Public Sector Partner Inputs'!$E$15=\"Y\",MIN(SUM(K18:K19)*'Owner-Operator Inputs'!$D$234,'Balance Sheet'!J$36*'Owner-Operator Inputs'!$D$234*pusp_equity_return_cap),SUM(K18:K19)*'Owner-Operator Inputs'!$D$234)","v":0},{"$f":"IF('Public Sector Partner Inputs'!$E$15=\"Y\",MIN(SUM(L18:L19)*'Owner-Operator Inputs'!$D$234,'Balance Sheet'!K$36*'Owner-Operator Inputs'!$D$234*pusp_equity_return_cap),SUM(L18:L19)*'Owner-Operator Inputs'!$D$234)","v":0},{"$f":"IF('Public Sector Partner Inputs'!$E$15=\"Y\",MIN(SUM(M18:M19)*'Owner-Operator Inputs'!$D$234,'Balance Sheet'!L$36*'Owner-Operator Inputs'!$D$234*pusp_equity_return_cap),SUM(M18:M19)*'Owner-Operator Inputs'!$D$234)","v":0}]
["Total Free Cash Flow to Owner-Operator Equity Holders",null,{"$f":"-('Owner-Operator Inputs'!E233-'Public Sector Partner Inputs'!E14-'Public Sector Partner Inputs'!E17)","v":-316140.00000000029},{"$f":"SUM(D18:D19)-D20","v":106923.88567474004},33239.893986535433,71015.664089512429,105704.24455083048,148221.8646839062,200306.318843894,229032.47811261629,220746.33840412291,218552.14200571913,127415.06831356807]
["Discount Factor",{"$f":"'Owner-Operator Inputs'!$E$247","v":0.10250000000000001},{"$f":"(1/(1+$B$22))^(COLUMN(C22)-COLUMN($C$22))","v":1},{"$f":"(1/(1+$B$22))^(COLUMN(D22)-COLUMN($C$22))","v":0.90702947845804982},0.82270247479188185,0.7462153966366275,0.676839362028687,0.6139132535407591,0.55683741817755927,0.50506795299551854,0.45811152199140004,0.41552065486748302,0.37688948287300045]
["Discounted Cash Flows",null,{"$f":"C21*C22","v":-316140.00000000029},96983.116258267604,27346.543044542494,52992.981945969019,71544.793445508418,90995.367193974991,111538.05342968492,115676.96488983001,101126.44106034139,90812.929168907562,48021.399206928698]
["Cumulative Discounted Cash Flows",null,{"$f":"C23","v":-316140.00000000029},{"$f":"C24+D23","v":-219156.88374173269},{"$f":"D24+E23","v":-191810.3406971902},-138817.35875122118,-67272.565305712764,23722.801888262227,135260.85531794716,250937.82020777717,352064.26126811857,442877.19043702615,490898.58964395482]
[]
["Net Present Value for Owner-Operator Equity Holders",null,{"$f":"SUM(C23:M23)","v":490898.58964395482}]
["Internal Rate of Return for Owner-Operator Equity Holders",null,{"$f":"IFERROR(IRR(C23:M23,0.1),\"N/A\")","v":0.20337992206088717}]
["Discounted Payback",null,{"$f":"IFERROR(IF(MATCH(0,$D$24:$M$24,1)>=10,\"N/A\",MATCH(0,$D$24:$M$24,1)+1),1)","v":5}]

{"sheet":"Private Sector Partner DCF","index":7,"n_rows":27,"n_cols":13,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Initial Settings'!$C$6","v":"Washington EV - Business Model 3 - Walla Walla"}]
[]
[]
["Private Sector Discounted Cash Flow Model",null,{"$f":"'Initial Settings'!$C$7","v":2015},{"$f":"'Owner-Operator Inputs'!F254","v":2016},{"$f":"'Owner-Operator Inputs'!G254","v":2017},{"$f":"'Owner-Operator Inputs'!H254","v":2018},{"$f":"'Owner-Operator Inputs'!I254","v":2019},{"$f":"'Owner-Operator Inputs'!J254","v":2020},{"$f":"'Owner-Operator Inputs'!K254","v":2021},{"$f":"'Owner-Operator Inputs'!L254","v":2022},{"$f":"'Owner-Operator Inputs'!M254","v":2023},{"$f":"'Owner-Operator Inputs'!N254","v":2024},{"$f":"'Owner-Operator Inputs'!O254","v":2025}]
[]
["Revenue",null,null,{"$f":"'Private Sector Partner Inputs'!F49","v":658702.07576610183},{"$f":"'Private Sector Partner Inputs'!G49","v":781902.07576610183},{"$f":"'Private Sector Partner Inputs'!H49","v":932202.07576610183},{"$f":"'Private Sector Partner Inputs'!I49","v":1115577.0757661017},{"$f":"'Private Sector Partner Inputs'!J49","v":1339302.0757661017},{"$f":"'Private Sector Partner Inputs'!K49","v":1612252.0757661017},{"$f":"'Private Sector Partner Inputs'!L49","v":1781202.0757661017},{"$f":"'Private Sector Partner Inputs'!M49","v":1781202.0757661017},{"$f":"'Private Sector Partner Inputs'!N49","v":1781202.0757661017},{"$f":"'Private Sector Partner Inputs'!O49","v":1781202.0757661017}]
["Operating Costs",null,null,{"$f":"-'Private Sector Partner Inputs'!F62","v":-677961.66061288153},{"$f":"-'Private Sector Partner Inputs'!G62","v":-693841.66061288153},{"$f":"-'Private Sector Partner Inputs'!H62","v":-829111.66061288153},{"$f":"-'Private Sector Partner Inputs'!I62","v":-994149.16061288142},{"$f":"-'Private Sector Partner Inputs'!J62","v":-1195501.6606128814},{"$f":"-'Private Sector Partner Inputs'!K62","v":-1441156.6606128814},{"$f":"-'Private Sector Partner Inputs'!L62","v":-1593211.6606128814},{"$f":"-'Private Sector Partner Inputs'!M62","v":-1593211.6606128814},{"$f":"-'Private Sector Partner Inputs'!N62","v":-1593211.6606128814},{"$f":"-'Private Sector Partner Inputs'!O62","v":-1593211.6606128814}]
["EBITDA",null,null,{"$f":"SUM(D6:D7)","v":-19259.584846779704},88060.415153220296,103090.4151532203,121427.9151532203,143800.4151532203,171095.4151532203,187990.4151532203,187990.4151532203,187990.4151532203,187990.4151532203]
["Dep & Amortization"]
["Operating Income (EBIT)",null,null,{"$f":"SUM(D8:D9)","v":-19259.584846779704},88060.415153220296,103090.4151532203,121427.9151532203,143800.4151532203,171095.4151532203,187990.4151532203,187990.4151532203,187990.4151532203,187990.4151532203]
["Interest Expense"]
["Income Before Taxes (EBT)",null,null,{"$f":"SUM(D10:D11)","v":-19259.584846779704},88060.415153220296,103090.4151532203,121427.9151532203,143800.4151532203,171095.4151532203,187990.4151532203,187990.4151532203,187990.4151532203,187990.4151532203]
["Taxes",null,null,{"$f":"-D12*'Private Sector Partner Inputs'!$E$8","v":6086.1303410968731},{"$f":"-E12*'Private Sector Partner Inputs'!$E$8","v":-27827.555410843339},{"$f":"-F12*'Private Sector Partner Inputs'!$E$8","v":-32577.114643527471},{"$f":"-G12*'Private Sector Partner Inputs'!$E$8","v":-38371.86131214659},{"$f":"-H12*'Private Sector Partner Inputs'!$E$8","v":-45441.689251815638},{"$f":"-I12*'Private Sector Partner Inputs'!$E$8","v":-54067.053141111275},{"$f":"-J12*'Private Sector Partner Inputs'!$E$8","v":-59405.962205395939},{"$f":"-K12*'Private Sector Partner Inputs'!$E$8","v":-59405.962205395939},{"$f":"-L12*'Private Sector Partner Inputs'!$E$8","v":-59405.962205395939},{"$f":"-M12*'Private Sector Partner Inputs'!$E$8","v":-59405.962205395939}]
["Cash Flow from Operations",null,null,{"$f":"D8+D11+D13","v":-13173.454505682832},60232.859742376953,70513.300509692825,83056.053841073706,98358.725901404658,117028.36201210902,128584.45294782435,128584.45294782435,128584.45294782435,128584.45294782435]
["Change in Non-cash Assets"]
["Change in Liabilities"]
[]
["Free Cash Flow",null,null,{"$f":"SUM(D14:D16)","v":-13173.454505682832},60232.859742376953,70513.300509692825,83056.053841073706,98358.725901404658,117028.36201210902,128584.45294782435,128584.45294782435,128584.45294782435,128584.45294782435]
["Terminal Value",null,null,null,null,null,null,null,null,null,null,null,0]
["Total Free Cash Flow",null,0,{"$f":"D18+D19","v":-13173.454505682832},60232.859742376953,70513.300509692825,83056.053841073706,98358.725901404658,117028.36201210902,128584.45294782435,128584.45294782435,128584.45294782435,128584.45294782435]
["Discount Factor (WACC)",{"$f":"'Private Sector Partner Inputs'!$E$6","v":0.1033},{"$f":"(1/(1+$B$21))^(COLUMN(C21)-COLUMN($C$21))","v":1},{"$f":"(1/(1+$B$21))^(COLUMN(D21)-COLUMN($C$21))","v":0.90637179370977983},0.82150982843268372,0.74459333674674499,0.67487839821149742,0.61169074432293802,0.55441923712765162,0.50250995842259738,0.45546085237251649,0.41281686972946302,0.37416556669034989]
["Discounted Cash Flows",null,{"$f":"C20*C21","v":0},-11940.04758966993,49481.88627296999,52503.733711538138,56052.736578031712,60165.122257286057,64882.775189052125,64614.968104603642,58565.184541469818,53081.83136179627,48111.874704791328]
["Cumulative Discounted Cash Flows",null,{"$f":"C22","v":0},{"$f":"C23+D22","v":-11940.04758966993},{"$f":"D23+E22","v":37541.838683300062},90045.572394838207,146098.30897286991,206263.43123015598,271146.20641920809,335761.17452381173,394326.35906528158,447408.19042707782,495520.06513186917]
[]
["Net Present Value",null,{"$f":"SUM(C22:M22)","v":495520.06513186917}]
["Internal Rate of Return",null,{"$f":"IFERROR(IRR(C22:M22,0.1),\"N/A\")","v":4.2067064392608531}]
["Discounted Payback",null,{"$f":"IFERROR(IF(MATCH(0,$D$23:$M$23,1)>=10,\"N/A\",MATCH(0,$D$23:$M$23,1)+1),1)","v":2}]

{"sheet":"Public Sector Partner DCF","index":8,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Initial Settings'!$C$6","v":"Washington EV - Business Model 3 - Walla Walla"}]
[]
[]
["Public Sector Discounted Cash Flow Model",null,{"$f":"'Initial Settings'!$C$7","v":2015},{"$f":"'Owner-Operator Inputs'!F254","v":2016},{"$f":"'Owner-Operator Inputs'!G254","v":2017},{"$f":"'Owner-Operator Inputs'!H254","v":2018},{"$f":"'Owner-Operator Inputs'!I254","v":2019},{"$f":"'Owner-Operator Inputs'!J254","v":2020},{"$f":"'Owner-Operator Inputs'!K254","v":2021},{"$f":"'Owner-Operator Inputs'!L254","v":2022},{"$f":"'Owner-Operator Inputs'!M254","v":2023},{"$f":"'Owner-Operator Inputs'!N254","v":2024},{"$f":"'Owner-Operator Inputs'!O254","v":2025}]
[]
["Cash Outflows"]
["Loan disbursement",null,{"$f":"-'Public Sector Partner Inputs'!E10","v":-415230}]
["Equity investment",null,{"$f":"-'Public Sector Partner Inputs'!E14","v":0}]
["Non-shareholder contributions to capital (grants)",null,{"$f":"-'Public Sector Partner Inputs'!E17","v":-237499.99999999971},{"$f":"-'Public Sector Partner Inputs'!F20","v":0},{"$f":"'Public Sector Partner Inputs'!G20","v":0},{"$f":"'Public Sector Partner Inputs'!H20","v":0},{"$f":"'Public Sector Partner Inputs'!I20","v":0},{"$f":"'Public Sector Partner Inputs'!J20","v":0},{"$f":"'Public Sector Partner Inputs'!K20","v":0},{"$f":"'Public Sector Partner Inputs'!L20","v":0},{"$f":"'Public Sector Partner Inputs'!M20","v":0},{"$f":"'Public Sector Partner Inputs'!N20","v":0},{"$f":"'Public Sector Partner Inputs'!O20","v":0}]
["Cash Inflows"]
["Loan repayments",null,null,{"$f":"-('Debt Schedule'!D6+'Debt Schedule'!D7)","v":54823.712107566738},{"$f":"-('Debt Schedule'!E6+'Debt Schedule'!E7)","v":54823.712107566738},{"$f":"-('Debt Schedule'!F6+'Debt Schedule'!F7)","v":54823.712107566738},{"$f":"-('Debt Schedule'!G6+'Debt Schedule'!G7)","v":54823.712107566738},{"$f":"-('Debt Schedule'!H6+'Debt Schedule'!H7)","v":54823.712107566738},{"$f":"-('Debt Schedule'!I6+'Debt Schedule'!I7)","v":54823.712107566738},{"$f":"-('Debt Schedule'!J6+'Debt Schedule'!J7)","v":54823.712107566738},{"$f":"-('Debt Schedule'!K6+'Debt Schedule'!K7)","v":54823.712107566738},{"$f":"-('Debt Schedule'!L6+'Debt Schedule'!L7)","v":54823.712107566738},{"$f":"-('Debt Schedule'!M6+'Debt Schedule'!M7)","v":54823.712107566738}]
["Cash Flow from Equity (Public Sector Portion)",null,null,{"$f":"'Owner-Operator DCF'!D20","v":0},{"$f":"'Owner-Operator DCF'!E20","v":0},{"$f":"'Owner-Operator DCF'!F20","v":0},{"$f":"'Owner-Operator DCF'!G20","v":0},{"$f":"'Owner-Operator DCF'!H20","v":0},{"$f":"'Owner-Operator DCF'!I20","v":0},{"$f":"'Owner-Operator DCF'!J20","v":0},{"$f":"'Owner-Operator DCF'!K20","v":0},{"$f":"'Owner-Operator DCF'!L20","v":0},{"$f":"'Owner-Operator DCF'!M20","v":0}]
[]
["Free Cash Flow",null,{"$f":"SUM(C7:C12)","v":-652729.99999999977},54823.712107566738,54823.712107566738,54823.712107566738,54823.712107566738,54823.712107566738,54823.712107566738,54823.712107566738,54823.712107566738,54823.712107566738,54823.712107566738]
["Terminal Values"]
["Loan terminal value",null,null,null,null,null,null,null,null,null,null,null,{"$f":"-NPV($B$19,'Debt Schedule'!N8:$W$8)","v":0}]
["Equity sale terminal value",null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Owner-Operator DCF'!M19*'Owner-Operator Inputs'!$D$234","v":0}]
["Total Free Cash Flow",null,{"$f":"SUM(C14:C17)","v":-652729.99999999977},54823.712107566738,54823.712107566738,54823.712107566738,54823.712107566738,54823.712107566738,54823.712107566738,54823.712107566738,54823.712107566738,54823.712107566738,54823.712107566738]
["Discount Factor (WACC)",{"$f":"'Public Sector Partner Inputs'!$E$6","v":5.3999999999999999E-2},{"$f":"(1/(1+$B$19))^(COLUMN(C19)-COLUMN($C$19))","v":1},{"$f":"(1/(1+$B$19))^(COLUMN(D19)-COLUMN($C$19))","v":0.94876660341555974},0.90015806775669804,0.85403991248263567,0.81028454694747221,0.76877091740746883,0.72938417211334805,0.69201534356105121,0.65656104702187024,0.62292319451790346,0.59100872345152133]
["Discounted Cash Flows",null,{"$f":"C18*C19","v":-652729.99999999977},52014.907122928591,49350.006757996765,46821.638290319512,44422.806727058363,42146.875452617038,39987.547867758098,37938.849969409959,35995.113822969601,34150.961881375333,32401.292107566733]
["Cumulative Discounted Cash Flows",null,{"$f":"C20","v":-652729.99999999977},{"$f":"C21+D20","v":-600715.09287707112},{"$f":"D21+E20","v":-551365.08611907437},-504543.44782875484,-460120.64110169647,-417973.76564907946,-377986.21778132138,-340047.36781191139,-304052.25398894178,-269901.29210756643,-237499.99999999971]
[]
["Net Present Value",null,{"$f":"SUM(C20:M20)","v":-237499.99999999971}]
["Internal Rate of Return",null,{"$f":"IFERROR(IRR(C20:M20,0.05),\"N/A\")","v":-8.0193114061326232E-2}]
["Discounted Payback",null,{"$f":"IFERROR(IF(MATCH(0,$D$21:$M$21,1)>=10,\"N/A\",MATCH(0,$D$21:$M$21,1)+1),1)","v":"N/A"}]

{"sheet":"Combined DCF","index":9,"n_rows":17,"n_cols":13,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Initial Settings'!$C$6","v":"Washington EV - Business Model 3 - Walla Walla"}]
[]
[]
["Combined Discounted Cash Flow Model",null,{"$f":"'Initial Settings'!$C$7","v":2015},{"$f":"'Owner-Operator Inputs'!F254","v":2016},{"$f":"'Owner-Operator Inputs'!G254","v":2017},{"$f":"'Owner-Operator Inputs'!H254","v":2018},{"$f":"'Owner-Operator Inputs'!I254","v":2019},{"$f":"'Owner-Operator Inputs'!J254","v":2020},{"$f":"'Owner-Operator Inputs'!K254","v":2021},{"$f":"'Owner-Operator Inputs'!L254","v":2022},{"$f":"'Owner-Operator Inputs'!M254","v":2023},{"$f":"'Owner-Operator Inputs'!N254","v":2024},{"$f":"'Owner-Operator Inputs'!O254","v":2025}]
[]
["Cash flow from owner operator",null,{"$f":"'Owner-Operator DCF'!C21","v":-316140.00000000029},{"$f":"'Owner-Operator DCF'!D21","v":106923.88567474004},{"$f":"'Owner-Operator DCF'!E21","v":33239.893986535433},{"$f":"'Owner-Operator DCF'!F21","v":71015.664089512429},{"$f":"'Owner-Operator DCF'!G21","v":105704.24455083048},{"$f":"'Owner-Operator DCF'!H21","v":148221.8646839062},{"$f":"'Owner-Operator DCF'!I21","v":200306.318843894},{"$f":"'Owner-Operator DCF'!J21","v":229032.47811261629},{"$f":"'Owner-Operator DCF'!K21","v":220746.33840412291},{"$f":"'Owner-Operator DCF'!L21","v":218552.14200571913},{"$f":"'Owner-Operator DCF'!M21","v":127415.06831356807}]
["Cash flow from private sector partner",null,{"$f":"'Private Sector Partner DCF'!C20","v":0},{"$f":"'Private Sector Partner DCF'!D20","v":-13173.454505682832},{"$f":"'Private Sector Partner DCF'!E20","v":60232.859742376953},{"$f":"'Private Sector Partner DCF'!F20","v":70513.300509692825},{"$f":"'Private Sector Partner DCF'!G20","v":83056.053841073706},{"$f":"'Private Sector Partner DCF'!H20","v":98358.725901404658},{"$f":"'Private Sector Partner DCF'!I20","v":117028.36201210902},{"$f":"'Private Sector Partner DCF'!J20","v":128584.45294782435},{"$f":"'Private Sector Partner DCF'!K20","v":128584.45294782435},{"$f":"'Private Sector Partner DCF'!L20","v":128584.45294782435},{"$f":"'Private Sector Partner DCF'!M20","v":128584.45294782435}]
["Cash flow from public sector partner",null,{"$f":"'Public Sector Partner DCF'!C18","v":-652729.99999999977},{"$f":"'Public Sector Partner DCF'!D18","v":54823.712107566738},{"$f":"'Public Sector Partner DCF'!E18","v":54823.712107566738},{"$f":"'Public Sector Partner DCF'!F18","v":54823.712107566738},{"$f":"'Public Sector Partner DCF'!G18","v":54823.712107566738},{"$f":"'Public Sector Partner DCF'!H18","v":54823.712107566738},{"$f":"'Public Sector Partner DCF'!I18","v":54823.712107566738},{"$f":"'Public Sector Partner DCF'!J18","v":54823.712107566738},{"$f":"'Public Sector Partner DCF'!K18","v":54823.712107566738},{"$f":"'Public Sector Partner DCF'!L18","v":54823.712107566738},{"$f":"'Public Sector Partner DCF'!M18","v":54823.712107566738}]
[]
["Total Free Cash Flow",null,{"$f":"SUM(C6:C8)","v":-968870},148574.14327662394,148296.46583647912,196352.67670677198,243584.01049947093,301404.30269287759,372158.39296356973,412440.64316800737,404154.503459514,401960.30706111027,310823.23336895916]
["Discount Factor (WACC)",{"$f":"('Owner-Operator Inputs'!$E$247*'Owner-Operator Inputs'!$D$235*'Owner-Operator Inputs'!$D$233)+('Owner-Operator Inputs'!C250*'Owner-Operator Inputs'!$D$238*'Owner-Operator Inputs'!$D$236)+(('Owner-Operator Inputs'!$D$233*'Owner-Operator Inputs'!$D$234+'Owner-Operator Inputs'!D236*'Owner-Operator Inputs'!$D$237)*'Public Sector Partner Inputs'!$E$6)","v":8.1199999999999994E-2},{"$f":"(1/(1+$B$11))^(COLUMN(C11)-COLUMN($C$11))","v":1},{"$f":"(1/(1+$B$11))^(COLUMN(D11)-COLUMN($C$11))","v":0.92489826119126906},0.85543679355463298,0.79119200291771463,0.73177210776703172,0.67681475006199754,0.62598478548094494,0.57897223962351552,0.5354904177058043,0.49527415622068477,0.45807820590148429]
["Discounted Cash Flows",null,{"$f":"C10*C11","v":-968870},137415.96677453196,126858.25323064187,155352.66756188541,178247.98478154463,203994.8777946906,232965.4917842334,238791.68288674441,216420.8638752171,199080.55191389876,142381.34909415117]
["Cumulative Discounted Cash Flows",null,{"$f":"C12","v":-968870},{"$f":"C13+D12","v":-831454.03322546801},{"$f":"D13+E12","v":-704595.77999482618},-549243.11243294075,-370995.12765139609,-167000.24985670549,65965.24192752791,304756.92481427232,521177.78868948942,720258.34060338815,862639.68969753932]
[]
["Net Present Value",{"$f":"SUM(C12:M12)","v":862639.68969753932}]
["Internal Rate of Return",{"$f":"IFERROR(IRR(C12:M12,0.05),\"N/A\")","v":0.12590935041422924}]
["Discounted Payback",{"$f":"IFERROR(IF(MATCH(0,$D$13:$M$13,1)>=10,\"N/A\",MATCH(0,$D$13:$M$13,1)+1),1)","v":6}]

{"sheet":"Debt Schedule","index":10,"n_rows":17,"n_cols":23,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Initial Settings'!$C$6","v":"Washington EV - Business Model 3 - Walla Walla"}]
[]
[]
["Debt Schedule",null,"Year->",1,{"$f":"D4+1","v":2},3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20]
["Public Sector Debt",null,{"$f":"'Public Sector Partner Inputs'!$E$10","v":415230}]
["Annual Principal Payment",null,null,{"$f":"IF(D$4<='Public Sector Partner Inputs'!$E$11,PPMT('Public Sector Partner Inputs'!$E$12,D$4,'Public Sector Partner Inputs'!$E$11,'Public Sector Partner Inputs'!$E$10),0)","v":-32401.292107566733},{"$f":"IF(E$4<='Public Sector Partner Inputs'!$E$11,PPMT('Public Sector Partner Inputs'!$E$12,E$4,'Public Sector Partner Inputs'!$E$11,'Public Sector Partner Inputs'!$E$10),0)","v":-34150.96188137534},{"$f":"IF(F$4<='Public Sector Partner Inputs'!$E$11,PPMT('Public Sector Partner Inputs'!$E$12,F$4,'Public Sector Partner Inputs'!$E$11,'Public Sector Partner Inputs'!$E$10),0)","v":-35995.113822969608},{"$f":"IF(G$4<='Public Sector Partner Inputs'!$E$11,PPMT('Public Sector Partner Inputs'!$E$12,G$4,'Public Sector Partner Inputs'!$E$11,'Public Sector Partner Inputs'!$E$10),0)","v":-37938.849969409966},{"$f":"IF(H$4<='Public Sector Partner Inputs'!$E$11,PPMT('Public Sector Partner Inputs'!$E$12,H$4,'Public Sector Partner Inputs'!$E$11,'Public Sector Partner Inputs'!$E$10),0)","v":-39987.547867758098},{"$f":"IF(I$4<='Public Sector Partner Inputs'!$E$11,PPMT('Public Sector Partner Inputs'!$E$12,I$4,'Public Sector Partner Inputs'!$E$11,'Public Sector Partner Inputs'!$E$10),0)","v":-42146.875452617045},{"$f":"IF(J$4<='Public Sector Partner Inputs'!$E$11,PPMT('Public Sector Partner Inputs'!$E$12,J$4,'Public Sector Partner Inputs'!$E$11,'Public Sector Partner Inputs'!$E$10),0)","v":-44422.806727058363},{"$f":"IF(K$4<='Public Sector Partner Inputs'!$E$11,PPMT('Public Sector Partner Inputs'!$E$12,K$4,'Public Sector Partner Inputs'!$E$11,'Public Sector Partner Inputs'!$E$10),0)","v":-46821.638290319512},{"$f":"IF(L$4<='Public Sector Partner Inputs'!$E$11,PPMT('Public Sector Partner Inputs'!$E$12,L$4,'Public Sector Partner Inputs'!$E$11,'Public Sector Partner Inputs'!$E$10),0)","v":-49350.006757996765},{"$f":"IF(M$4<='Public Sector Partner Inputs'!$E$11,PPMT('Public Sector Partner Inputs'!$E$12,M$4,'Public Sector Partner Inputs'!$E$11,'Public Sector Partner Inputs'!$E$10),0)","v":-52014.907122928591},{"$f":"IF(N$4<='Public Sector Partner Inputs'!$E$11,PPMT('Public Sector Partner Inputs'!$E$12,N$4,'Public Sector Partner Inputs'!$E$11,'Public Sector Partner Inputs'!$E$10),0)","v":0},{"$f":"IF(O$4<='Public Sector Partner Inputs'!$E$11,PPMT('Public Sector Partner Inputs'!$E$12,O$4,'Public Sector Partner Inputs'!$E$11,'Public Sector Partner Inputs'!$E$10),0)","v":0},{"$f":"IF(P$4<='Public Sector Partner Inputs'!$E$11,PPMT('Public Sector Partner Inputs'!$E$12,P$4,'Public Sector Partner Inputs'!$E$11,'Public Sector Partner Inputs'!$E$10),0)","v":0},{"$f":"IF(Q$4<='Public Sector Partner Inputs'!$E$11,PPMT('Public Sector Partner Inputs'!$E$12,Q$4,'Public Sector Partner Inputs'!$E$11,'Public Sector Partner Inputs'!$E$10),0)","v":0},{"$f":"IF(R$4<='Public Sector Partner Inputs'!$E$11,PPMT('Public Sector Partner Inputs'!$E$12,R$4,'Public Sector Partner Inputs'!$E$11,'Public Sector Partner Inputs'!$E$10),0)","v":0},{"$f":"IF(S$4<='Public Sector Partner Inputs'!$E$11,PPMT('Public Sector Partner Inputs'!$E$12,S$4,'Public Sector Partner Inputs'!$E$11,'Public Sector Partner Inputs'!$E$10),0)","v":0},{"$f":"IF(T$4<='Public Sector Partner Inputs'!$E$11,PPMT('Public Sector Partner Inputs'!$E$12,T$4,'Public Sector Partner Inputs'!$E$11,'Public Sector Partner Inputs'!$E$10),0)","v":0},{"$f":"IF(U$4<='Public Sector Partner Inputs'!$E$11,PPMT('Public Sector Partner Inputs'!$E$12,U$4,'Public Sector Partner Inputs'!$E$11,'Public Sector Partner Inputs'!$E$10),0)","v":0},{"$f":"IF(V$4<='Public Sector Partner Inputs'!$E$11,PPMT('Public Sector Partner Inputs'!$E$12,V$4,'Public Sector Partner Inputs'!$E$11,'Public Sector Partner Inputs'!$E$10),0)","v":0},{"$f":"IF(W$4<='Public Sector Partner Inputs'!$E$11,PPMT('Public Sector Partner Inputs'!$E$12,W$4,'Public Sector Partner Inputs'!$E$11,'Public Sector Partner Inputs'!$E$10),0)","v":0}]
["Annual Interest Payment",null,null,{"$f":"IF(D$4<='Public Sector Partner Inputs'!$E$11,PMT('Public Sector Partner Inputs'!$E$12,'Public Sector Partner Inputs'!$E$11,'Public Sector Partner Inputs'!$E$10)-D6,0)","v":-22422.420000000006},{"$f":"IF(E$4<='Public Sector Partner Inputs'!$E$11,PMT('Public Sector Partner Inputs'!$E$12,'Public Sector Partner Inputs'!$E$11,'Public Sector Partner Inputs'!$E$10)-E6,0)","v":-20672.750226191398},{"$f":"IF(F$4<='Public Sector Partner Inputs'!$E$11,PMT('Public Sector Partner Inputs'!$E$12,'Public Sector Partner Inputs'!$E$11,'Public Sector Partner Inputs'!$E$10)-F6,0)","v":-18828.59828459713},{"$f":"IF(G$4<='Public Sector Partner Inputs'!$E$11,PMT('Public Sector Partner Inputs'!$E$12,'Public Sector Partner Inputs'!$E$11,'Public Sector Partner Inputs'!$E$10)-G6,0)","v":-16884.862138156772},{"$f":"IF(H$4<='Public Sector Partner Inputs'!$E$11,PMT('Public Sector Partner Inputs'!$E$12,'Public Sector Partner Inputs'!$E$11,'Public Sector Partner Inputs'!$E$10)-H6,0)","v":-14836.164239808641},{"$f":"IF(I$4<='Public Sector Partner Inputs'!$E$11,PMT('Public Sector Partner Inputs'!$E$12,'Public Sector Partner Inputs'!$E$11,'Public Sector Partner Inputs'!$E$10)-I6,0)","v":-12676.836654949693},{"$f":"IF(J$4<='Public Sector Partner Inputs'!$E$11,PMT('Public Sector Partner Inputs'!$E$12,'Public Sector Partner Inputs'!$E$11,'Public Sector Partner Inputs'!$E$10)-J6,0)","v":-10400.905380508375},{"$f":"IF(K$4<='Public Sector Partner Inputs'!$E$11,PMT('Public Sector Partner Inputs'!$E$12,'Public Sector Partner Inputs'!$E$11,'Public Sector Partner Inputs'!$E$10)-K6,0)","v":-8002.0738172472265},{"$f":"IF(L$4<='Public Sector Partner Inputs'!$E$11,PMT('Public Sector Partner Inputs'!$E$12,'Public Sector Partner Inputs'!$E$11,'Public Sector Partner Inputs'!$E$10)-L6,0)","v":-5473.7053495699729},{"$f":"IF(M$4<='Public Sector Partner Inputs'!$E$11,PMT('Public Sector Partner Inputs'!$E$12,'Public Sector Partner Inputs'!$E$11,'Public Sector Partner Inputs'!$E$10)-M6,0)","v":-2808.8049846381473},{"$f":"IF(N$4<='Public Sector Partner Inputs'!$E$11,PMT('Public Sector Partner Inputs'!$E$12,'Public Sector Partner Inputs'!$E$11,'Public Sector Partner Inputs'!$E$10)-N6,0)","v":0},{"$f":"IF(O$4<='Public Sector Partner Inputs'!$E$11,PMT('Public Sector Partner Inputs'!$E$12,'Public Sector Partner Inputs'!$E$11,'Public Sector Partner Inputs'!$E$10)-O6,0)","v":0},{"$f":"IF(P$4<='Public Sector Partner Inputs'!$E$11,PMT('Public Sector Partner Inputs'!$E$12,'Public Sector Partner Inputs'!$E$11,'Public Sector Partner Inputs'!$E$10)-P6,0)","v":0},{"$f":"IF(Q$4<='Public Sector Partner Inputs'!$E$11,PMT('Public Sector Partner Inputs'!$E$12,'Public Sector Partner Inputs'!$E$11,'Public Sector Partner Inputs'!$E$10)-Q6,0)","v":0},{"$f":"IF(R$4<='Public Sector Partner Inputs'!$E$11,PMT('Public Sector Partner Inputs'!$E$12,'Public Sector Partner Inputs'!$E$11,'Public Sector Partner Inputs'!$E$10)-R6,0)","v":0},{"$f":"IF(S$4<='Public Sector Partner Inputs'!$E$11,PMT('Public Sector Partner Inputs'!$E$12,'Public Sector Partner Inputs'!$E$11,'Public Sector Partner Inputs'!$E$10)-S6,0)","v":0},{"$f":"IF(T$4<='Public Sector Partner Inputs'!$E$11,PMT('Public Sector Partner Inputs'!$E$12,'Public Sector Partner Inputs'!$E$11,'Public Sector Partner Inputs'!$E$10)-T6,0)","v":0},{"$f":"IF(U$4<='Public Sector Partner Inputs'!$E$11,PMT('Public Sector Partner Inputs'!$E$12,'Public Sector Partner Inputs'!$E$11,'Public Sector Partner Inputs'!$E$10)-U6,0)","v":0},{"$f":"IF(V$4<='Public Sector Partner Inputs'!$E$11,PMT('Public Sector Partner Inputs'!$E$12,'Public Sector Partner Inputs'!$E$11,'Public Sector Partner Inputs'!$E$10)-V6,0)","v":0},{"$f":"IF(W$4<='Public Sector Partner Inputs'!$E$11,PMT('Public Sector Partner Inputs'!$E$12,'Public Sector Partner Inputs'!$E$11,'Public Sector Partner Inputs'!$E$10)-W6,0)","v":0}]
["Total Payment",null,null,{"$f":"SUM(D6:D7)","v":-54823.712107566738},{"$f":"SUM(E6:E7)","v":-54823.712107566738},-54823.712107566738,-54823.712107566738,-54823.712107566738,-54823.712107566738,-54823.712107566738,-54823.712107566738,-54823.712107566738,-54823.712107566738,{"$f":"SUM(N6:N7)","v":0},0,0,0,0,0,0,0,0,0]
[]
["Private Sector Debt",null,{"$f":"'Owner-Operator Inputs'!E236-'Public Sector Partner Inputs'!E10","v":415230}]
["Annual Principal Payment",null,null,{"$f":"IF(D$4<='Owner-Operator Inputs'!$E$249,PPMT('Owner-Operator Inputs'!$C$250,D$4,'Owner-Operator Inputs'!$E$249,$C$10),0)","v":-28663.11459168663},{"$f":"IF(E$4<='Owner-Operator Inputs'!$E$249,PPMT('Owner-Operator Inputs'!$C$250,E$4,'Owner-Operator Inputs'!$E$249,$C$10),0)","v":-30956.163759021558},{"$f":"IF(F$4<='Owner-Operator Inputs'!$E$249,PPMT('Owner-Operator Inputs'!$C$250,F$4,'Owner-Operator Inputs'!$E$249,$C$10),0)","v":-33432.656859743278},{"$f":"IF(G$4<='Owner-Operator Inputs'!$E$249,PPMT('Owner-Operator Inputs'!$C$250,G$4,'Owner-Operator Inputs'!$E$249,$C$10),0)","v":-36107.269408522749},{"$f":"IF(H$4<='Owner-Operator Inputs'!$E$249,PPMT('Owner-Operator Inputs'!$C$250,H$4,'Owner-Operator Inputs'!$E$249,$C$10),0)","v":-38995.850961204567},{"$f":"IF(I$4<='Owner-Operator Inputs'!$E$249,PPMT('Owner-Operator Inputs'!$C$250,I$4,'Owner-Operator Inputs'!$E$249,$C$10),0)","v":-42115.519038100923},{"$f":"IF(J$4<='Owner-Operator Inputs'!$E$249,PPMT('Owner-Operator Inputs'!$C$250,J$4,'Owner-Operator Inputs'!$E$249,$C$10),0)","v":-45484.760561149},{"$f":"IF(K$4<='Owner-Operator Inputs'!$E$249,PPMT('Owner-Operator Inputs'!$C$250,K$4,'Owner-Operator Inputs'!$E$249,$C$10),0)","v":-49123.541406040931},{"$f":"IF(L$4<='Owner-Operator Inputs'!$E$249,PPMT('Owner-Operator Inputs'!$C$250,L$4,'Owner-Operator Inputs'!$E$249,$C$10),0)","v":-53053.424718524191},{"$f":"IF(M$4<='Owner-Operator Inputs'!$E$249,PPMT('Owner-Operator Inputs'!$C$250,M$4,'Owner-Operator Inputs'!$E$249,$C$10),0)","v":-57297.69869600614},{"$f":"IF(N$4<='Owner-Operator Inputs'!$E$249,PPMT('Owner-Operator Inputs'!$C$250,N$4,'Owner-Operator Inputs'!$E$249,$C$10),0)","v":0},{"$f":"IF(O$4<='Owner-Operator Inputs'!$E$249,PPMT('Owner-Operator Inputs'!$C$250,O$4,'Owner-Operator Inputs'!$E$249,$C$10),0)","v":0},{"$f":"IF(P$4<='Owner-Operator Inputs'!$E$249,PPMT('Owner-Operator Inputs'!$C$250,P$4,'Owner-Operator Inputs'!$E$249,$C$10),0)","v":0},{"$f":"IF(Q$4<='Owner-Operator Inputs'!$E$249,PPMT('Owner-Operator Inputs'!$C$250,Q$4,'Owner-Operator Inputs'!$E$249,$C$10),0)","v":0},{"$f":"IF(R$4<='Owner-Operator Inputs'!$E$249,PPMT('Owner-Operator Inputs'!$C$250,R$4,'Owner-Operator Inputs'!$E$249,$C$10),0)","v":0},{"$f":"IF(S$4<='Owner-Operator Inputs'!$E$249,PPMT('Owner-Operator Inputs'!$C$250,S$4,'Owner-Operator Inputs'!$E$249,$C$10),0)","v":0},{"$f":"IF(T$4<='Owner-Operator Inputs'!$E$249,PPMT('Owner-Operator Inputs'!$C$250,T$4,'Owner-Operator Inputs'!$E$249,$C$10),0)","v":0},{"$f":"IF(U$4<='Owner-Operator Inputs'!$E$249,PPMT('Owner-Operator Inputs'!$C$250,U$4,'Owner-Operator Inputs'!$E$249,$C$10),0)","v":0},{"$f":"IF(V$4<='Owner-Operator Inputs'!$E$249,PPMT('Owner-Operator Inputs'!$C$250,V$4,'Owner-Operator Inputs'!$E$249,$C$10),0)","v":0},{"$f":"IF(W$4<='Owner-Operator Inputs'!$E$249,PPMT('Owner-Operator Inputs'!$C$250,W$4,'Owner-Operator Inputs'!$E$249,$C$10),0)","v":0}]
["Annual Interest Payment",null,null,{"$f":"IF(D$4<='Owner-Operator Inputs'!$E$249,PMT('Owner-Operator Inputs'!$C$250,'Owner-Operator Inputs'!$E$249,$C$10)-D11,0)","v":-33218.399999999994},{"$f":"IF(E$4<='Owner-Operator Inputs'!$E$249,PMT('Owner-Operator Inputs'!$C$250,'Owner-Operator Inputs'!$E$249,$C$10)-E11,0)","v":-30925.350832665066},{"$f":"IF(F$4<='Owner-Operator Inputs'!$E$249,PMT('Owner-Operator Inputs'!$C$250,'Owner-Operator Inputs'!$E$249,$C$10)-F11,0)","v":-28448.857731943346},{"$f":"IF(G$4<='Owner-Operator Inputs'!$E$249,PMT('Owner-Operator Inputs'!$C$250,'Owner-Operator Inputs'!$E$249,$C$10)-G11,0)","v":-25774.245183163875},{"$f":"IF(H$4<='Owner-Operator Inputs'!$E$249,PMT('Owner-Operator Inputs'!$C$250,'Owner-Operator Inputs'!$E$249,$C$10)-H11,0)","v":-22885.663630482057},{"$f":"IF(I$4<='Owner-Operator Inputs'!$E$249,PMT('Owner-Operator Inputs'!$C$250,'Owner-Operator Inputs'!$E$249,$C$10)-I11,0)","v":-19765.995553585701},{"$f":"IF(J$4<='Owner-Operator Inputs'!$E$249,PMT('Owner-Operator Inputs'!$C$250,'Owner-Operator Inputs'!$E$249,$C$10)-J11,0)","v":-16396.754030537624},{"$f":"IF(K$4<='Owner-Operator Inputs'!$E$249,PMT('Owner-Operator Inputs'!$C$250,'Owner-Operator Inputs'!$E$249,$C$10)-K11,0)","v":-12757.973185645693},{"$f":"IF(L$4<='Owner-Operator Inputs'!$E$249,PMT('Owner-Operator Inputs'!$C$250,'Owner-Operator Inputs'!$E$249,$C$10)-L11,0)","v":-8828.0898731624329},{"$f":"IF(M$4<='Owner-Operator Inputs'!$E$249,PMT('Owner-Operator Inputs'!$C$250,'Owner-Operator Inputs'!$E$249,$C$10)-M11,0)","v":-4583.8158956804837},{"$f":"IF(N$4<='Owner-Operator Inputs'!$E$249,PMT('Owner-Operator Inputs'!$C$250,'Owner-Operator Inputs'!$E$249,$C$10)-N11,0)","v":0},{"$f":"IF(O$4<='Owner-Operator Inputs'!$E$249,PMT('Owner-Operator Inputs'!$C$250,'Owner-Operator Inputs'!$E$249,$C$10)-O11,0)","v":0},{"$f":"IF(P$4<='Owner-Operator Inputs'!$E$249,PMT('Owner-Operator Inputs'!$C$250,'Owner-Operator Inputs'!$E$249,$C$10)-P11,0)","v":0},{"$f":"IF(Q$4<='Owner-Operator Inputs'!$E$249,PMT('Owner-Operator Inputs'!$C$250,'Owner-Operator Inputs'!$E$249,$C$10)-Q11,0)","v":0},{"$f":"IF(R$4<='Owner-Operator Inputs'!$E$249,PMT('Owner-Operator Inputs'!$C$250,'Owner-Operator Inputs'!$E$249,$C$10)-R11,0)","v":0},{"$f":"IF(S$4<='Owner-Operator Inputs'!$E$249,PMT('Owner-Operator Inputs'!$C$250,'Owner-Operator Inputs'!$E$249,$C$10)-S11,0)","v":0},{"$f":"IF(T$4<='Owner-Operator Inputs'!$E$249,PMT('Owner-Operator Inputs'!$C$250,'Owner-Operator Inputs'!$E$249,$C$10)-T11,0)","v":0},{"$f":"IF(U$4<='Owner-Operator Inputs'!$E$249,PMT('Owner-Operator Inputs'!$C$250,'Owner-Operator Inputs'!$E$249,$C$10)-U11,0)","v":0},{"$f":"IF(V$4<='Owner-Operator Inputs'!$E$249,PMT('Owner-Operator Inputs'!$C$250,'Owner-Operator Inputs'!$E$249,$C$10)-V11,0)","v":0},{"$f":"IF(W$4<='Owner-Operator Inputs'!$E$249,PMT('Owner-Operator Inputs'!$C$250,'Owner-Operator Inputs'!$E$249,$C$10)-W11,0)","v":0}]
["Total Payment",null,null,{"$f":"SUM(D11:D12)","v":-61881.514591686624},{"$f":"SUM(E11:E12)","v":-61881.514591686624},-61881.514591686624,-61881.514591686624,-61881.514591686624,-61881.514591686624,-61881.514591686624,-61881.514591686624,-61881.514591686624,-61881.514591686624,{"$f":"SUM(N11:N12)","v":0},0,0,0,0,0,0,0,0,0]
[]
["Total Annual Principal Payment",null,null,{"$f":"D6+D11","v":-61064.406699253363},{"$f":"E6+E11","v":-65107.125640396902},-69427.770682712886,-74046.119377932715,-78983.398828962672,-84262.394490717968,-89907.567288207356,-95945.179696360443,-102403.43147652096,-109312.60581893474,0,0,0,0,0,0,0,0,0,0]
["Total Annual Interest Payment",null,null,{"$f":"D7+D12","v":-55640.82},{"$f":"E7+E12","v":-51598.101058856468},-47277.456016540476,-42659.107321320647,-37721.827870290697,-32442.832208535394,-26797.659411045999,-20760.047002892919,-14301.795222732406,-7392.620880318631,0,0,0,0,0,0,0,0,0,0]
["Total Payment",null,null,{"$f":"SUM(D15:D16)","v":-116705.22669925337},{"$f":"SUM(E15:E16)","v":-116705.22669925337},-116705.22669925337,-116705.22669925337,-116705.22669925337,-116705.22669925337,-116705.22669925336,-116705.22669925337,-116705.22669925337,-116705.22669925337,0,0,0,0,0,0,0,0,0,0]

{"sheet":"Terminal Value Model","index":11,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[11,0,11,1]]}
[{"$f":"'Initial Settings'!$C$6","v":"Washington EV - Business Model 3 - Walla Walla"}]
[]
[]
["Based on Assumed EBITDA Exit Multiple",null,{"$f":"'Initial Settings'!$C$7","v":2015},{"$f":"'Owner-Operator Inputs'!F254","v":2016},{"$f":"'Owner-Operator Inputs'!G254","v":2017},{"$f":"'Owner-Operator Inputs'!H254","v":2018},{"$f":"'Owner-Operator Inputs'!I254","v":2019},{"$f":"'Owner-Operator Inputs'!J254","v":2020},{"$f":"'Owner-Operator Inputs'!K254","v":2021},{"$f":"'Owner-Operator Inputs'!L254","v":2022},{"$f":"'Owner-Operator Inputs'!M254","v":2023},{"$f":"'Owner-Operator Inputs'!N254","v":2024},{"$f":"'Owner-Operator Inputs'!O254","v":2025}]
[]
["EBITDA",null,{"$f":"'Income Statement'!B23+'Income Statement'!B18","v":0},{"$f":"'Income Statement'!C23+'Income Statement'!C18","v":196466.40000000002},{"$f":"'Income Statement'!D23+'Income Statement'!D18","v":140670.9088},{"$f":"'Income Statement'!E23+'Income Statement'!E18","v":182686.36903440001},{"$f":"'Income Statement'!F23+'Income Statement'!F18","v":233924.13236155803},{"$f":"'Income Statement'!G23+'Income Statement'!G18","v":296401.98848301847},{"$f":"'Income Statement'!H23+'Income Statement'!H18","v":372591.39717186644},{"$f":"'Income Statement'!I23+'Income Statement'!I18","v":422142.19040831085},{"$f":"'Income Statement'!J23+'Income Statement'!J18","v":421918.54488433164},{"$f":"'Income Statement'!K23+'Income Statement'!K18","v":421694.34024654247},{"$f":"'Income Statement'!L23+'Income Statement'!L18","v":421469.5750971589}]
["Exit Multiple",null,{"$f":"'Owner-Operator Inputs'!$E$241","v":0},{"$f":"'Owner-Operator Inputs'!$E$241","v":0},{"$f":"'Owner-Operator Inputs'!$E$241","v":0},{"$f":"'Owner-Operator Inputs'!$E$241","v":0},{"$f":"'Owner-Operator Inputs'!$E$241","v":0},{"$f":"'Owner-Operator Inputs'!$E$241","v":0},{"$f":"'Owner-Operator Inputs'!$E$241","v":0},{"$f":"'Owner-Operator Inputs'!$E$241","v":0},{"$f":"'Owner-Operator Inputs'!$E$241","v":0},{"$f":"'Owner-Operator Inputs'!$E$241","v":0},{"$f":"'Owner-Operator Inputs'!$E$241","v":0}]
["Total Enterprise Value",null,{"$f":"C7*C6","v":0},0,0,0,0,0,0,0,0,0,0]
["Less: Net Debt",null,{"$f":"'Balance Sheet'!B33","v":830460},{"$f":"'Balance Sheet'!C33","v":813045.59330074675},{"$f":"'Balance Sheet'!D33","v":740156.46766034979},{"$f":"'Balance Sheet'!E33","v":678619.82197763689},{"$f":"'Balance Sheet'!F33","v":614201.45259970415},{"$f":"'Balance Sheet'!G33","v":546963.42877074145},{"$f":"'Balance Sheet'!H33","v":477030.90928002348},{"$f":"'Balance Sheet'!I33","v":396461.21699181612},{"$f":"'Balance Sheet'!J33","v":300516.0372954557},{"$f":"'Balance Sheet'!K33","v":198112.60581893474},{"$f":"'Balance Sheet'!L33","v":88800}]
["Equity Value",null,{"$f":"C8-C9","v":-830460},-813045.59330074675,-740156.46766034979,-678619.82197763689,-614201.45259970415,-546963.42877074145,-477030.90928002348,-396461.21699181612,-300516.0372954557,-198112.60581893474,-88800]
[]
["Terminal Value Model - Based on Remaining Property, Plant, and Equipment Value",null,{"$f":"'Initial Settings'!$C$7","v":2015},{"$f":"'Owner-Operator Inputs'!F254","v":2016},{"$f":"'Owner-Operator Inputs'!G254","v":2017},{"$f":"'Owner-Operator Inputs'!H254","v":2018},{"$f":"'Owner-Operator Inputs'!I254","v":2019},{"$f":"'Owner-Operator Inputs'!J254","v":2020},{"$f":"'Owner-Operator Inputs'!K254","v":2021},{"$f":"'Owner-Operator Inputs'!L254","v":2022},{"$f":"'Owner-Operator Inputs'!M254","v":2023},{"$f":"'Owner-Operator Inputs'!N254","v":2024},{"$f":"'Owner-Operator Inputs'!O254","v":2025}]
[]
["Property, Plant, and Equipment Value",null,{"$f":"'Balance Sheet'!B18","v":1355000},{"$f":"'Balance Sheet'!C18","v":1219500},{"$f":"'Balance Sheet'!D18","v":1084000},{"$f":"'Balance Sheet'!E18","v":948500},{"$f":"'Balance Sheet'!F18","v":813000},{"$f":"'Balance Sheet'!G18","v":677500},{"$f":"'Balance Sheet'!H18","v":542000},{"$f":"'Balance Sheet'!I18","v":406500},{"$f":"'Balance Sheet'!J18","v":271000},{"$f":"'Balance Sheet'!K18","v":135500},{"$f":"'Balance Sheet'!L18","v":0}]
["Less: Net Debt",null,{"$f":"'Balance Sheet'!B33","v":830460},{"$f":"'Balance Sheet'!C33","v":813045.59330074675},{"$f":"'Balance Sheet'!D33","v":740156.46766034979},{"$f":"'Balance Sheet'!E33","v":678619.82197763689},{"$f":"'Balance Sheet'!F33","v":614201.45259970415},{"$f":"'Balance Sheet'!G33","v":546963.42877074145},{"$f":"'Balance Sheet'!H33","v":477030.90928002348},{"$f":"'Balance Sheet'!I33","v":396461.21699181612},{"$f":"'Balance Sheet'!J33","v":300516.0372954557},{"$f":"'Balance Sheet'!K33","v":198112.60581893474},{"$f":"'Balance Sheet'!L33","v":88800}]
["Terminal Value ",null,{"$f":"C14-C15","v":524540},{"$f":"D14-D15","v":406454.40669925325},343843.53233965021,269880.17802236311,198798.54740029585,130536.57122925855,64969.090719976521,10038.783008183877,-29516.037295455695,-62612.605818934739,{"$f":"M14-M15","v":-88800}]

{"sheet":"Outputs Dashboard","index":12,"n_rows":275,"n_cols":10,"rows_kept":275,"cut":false,"hidden":false,"merged":[[2,4,2,5],[2,1,2,2]]}
[{"$f":"'Initial Settings'!$C$6","v":"Washington EV - Business Model 3 - Walla Walla"}]
[]
[null,"Financial Performance Statistics",null,null,"Charging Infrastructure Statistics"]
[null,"Project",null,null,"Total New Sites"]
[null,"Total Capital Investment",{"$f":"'Owner-Operator Inputs'!E231","v":1384100},null,{"$f":"'Owner-Operator Inputs'!E22+'Owner-Operator Inputs'!E85+'Owner-Operator Inputs'!E148","v":20}]
[null,"Total Net Present Value",{"$f":"'Combined DCF'!B15","v":862639.68969753932},null,"Total New Stations"]
[null,"Total Internal Rate of Return (IRR)",{"$f":"'Combined DCF'!B16","v":0.12590935041422924},null,{"$f":"'Owner-Operator Inputs'!E21+'Owner-Operator Inputs'!E84+'Owner-Operator Inputs'!E147","v":60}]
[null,"Discounted Payback (Years)",{"$f":"'Combined DCF'!B17","v":6},null,"Number of Charging Sessions Provided"]
[null,null,null,null,{"$f":"SUM('Owner-Operator Inputs'!F32:J32)+SUM('Owner-Operator Inputs'!F95:J95)+SUM('Owner-Operator Inputs'!F158:J158)","v":247669}]
[null,"Owner-Operator",null,null,"kWh of Charging Provided"]
[null,"Total Capital Investment (Equity)",{"$f":"'Public Sector Partner Inputs'!E13-'Public Sector Partner Inputs'!E14-'Public Sector Partner Inputs'!E17","v":316140.00000000029},null,{"$f":"SUM('Owner-Operator Inputs'!F36:J36)+SUM('Owner-Operator Inputs'!F99:J99)+SUM('Owner-Operator Inputs'!F162:J162)","v":2941075}]
[null,"Total Net Present Value",{"$f":"'Owner-Operator DCF'!C26","v":490898.58964395482}]
[null,"Total Internal Rate of Return (IRR)",{"$f":"'Owner-Operator DCF'!C27","v":0.20337992206088717}]
[null,"Discounted Payback (Years)",{"$f":"'Owner-Operator DCF'!C28","v":5},null,null,null,null,null,{"$f":"B10","v":"Owner-Operator"},{"$f":"C11","v":316140.00000000029}]
[null,null,null,null,null,null,null,null,{"$f":"B16","v":"Private Sector Partner(s)"},{"$f":"C17","v":0}]
[null,"Private Sector Partner(s)",null,null,null,null,null,null,{"$f":"B23","v":"Public Sector Partner"},{"$f":"C24","v":652729.99999999977}]
[null,"Total Capital Investment",{"$f":"'Private Sector Partner DCF'!C20","v":0},null,null,null,null,null,{"$f":"B30","v":"Other Non-Partner Private Sector"},{"$f":"C31","v":415229.99999999994}]
[null,"Total Other Contributions",{"$f":"SUM('Private Sector Partner Inputs'!$F$55:$O$60)","v":1352772.5}]
[null,"Total Net Present Value",{"$f":"'Private Sector Partner DCF'!C25","v":495520.06513186917}]
[null,"Total Internal Rate of Return (IRR)",{"$f":"'Private Sector Partner DCF'!C26","v":4.2067064392608531}]
[null,"Discounted Payback (Years)",{"$f":"'Private Sector Partner DCF'!C27","v":2}]
[]
[null,"Public Sector Partner"]
[null,"Total Capital Investment",{"$f":"'Public Sector Partner Inputs'!E10+'Public Sector Partner Inputs'!E14+'Public Sector Partner Inputs'!E17","v":652729.99999999977}]
[null,"Total Other Contributions",{"$f":"SUM('Public Sector Partner Inputs'!F20:O20)","v":0}]
[null,"Total Net Present Value",{"$f":"'Public Sector Partner DCF'!C23","v":-237499.99999999971}]
[null,"Total Internal Rate of Return (IRR)",{"$f":"'Public Sector Partner DCF'!C24","v":-8.0193114061326232E-2}]
[null,"Discounted Payback (Years)",{"$f":"'Public Sector Partner DCF'!C25","v":"N/A"}]
[]
[null,"Other Non-Partner Private Sector"]
[null,"Total Capital Investment (Loans)",{"$f":"C5-C24-C17-C11","v":415229.99999999994}]
[]
[]
["Market Inputs - Sensitivity Analysis"]
[]
[null,{"$f":"'Sensitivity Tables'!B7:I7","v":"Expected annual utilization growth rate [%]"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"'Sensitivity Tables'!B24:I24","v":"[Station Type 1] Initial average utilization [# of charging sessions per station per year]"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"'Sensitivity Tables'!B41:I41","v":"[Station Type 2] Initial average utilization [# of charging sessions per station per year]"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"'Sensitivity Tables'!B58:I58","v":"[Station Type 3] Initial average utilization [# of charging sessions per station per year]"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Owner-Operator Inputs - Sensitivity Analysis"]
[]
[null,{"$f":"'Sensitivity Tables'!B75:I75","v":"Owner Operator Cost of Debt (Long Term)"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Private Sector Partner Inputs - Sensitivity Analysis"]
[]
[null,{"$f":"'Sensitivity Tables'!B92:I92","v":"Estimated NPV of lifetime after-tax profit per station - type 1 station [$]"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"'Sensitivity Tables'!B109:I109","v":"Estimated NPV of lifetime after-tax profit per station - type 2 station [$]"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"'Sensitivity Tables'!B126:I126","v":"Estimated NPV of lifetime after-tax profit per station - type 3 station [$]"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"'Sensitivity Tables'!B143:I143","v":"Annual customer revenue sharing agreement (from sales) [% of revenue]"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"'Sensitivity Tables'!B160:I160","v":"Average expected revenue per customer per minute ($)"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"'Sensitivity Tables'!B177:I177","v":"Maximum retail revenue per customer per session for type 1 stations ($)"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"'Sensitivity Tables'!B194:I194","v":"Maximum retail revenue per customer per session for type 2 stations ($)"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"'Sensitivity Tables'!B211:I211","v":"Maximum retail revenue per customer per session for type 3 stations ($)"}]

{"sheet":"Income Statement","index":13,"n_rows":34,"n_cols":12,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Initial Settings'!$C$6","v":"Washington EV - Business Model 3 - Walla Walla"}]
[]
["Consolidated Statements of Income [$]"]
[]
[null,{"$f":"'Initial Settings'!C7","v":2015},{"$f":"'Owner-Operator Inputs'!F254","v":2016},{"$f":"'Owner-Operator Inputs'!G254","v":2017},{"$f":"'Owner-Operator Inputs'!H254","v":2018},{"$f":"'Owner-Operator Inputs'!I254","v":2019},{"$f":"'Owner-Operator Inputs'!J254","v":2020},{"$f":"'Owner-Operator Inputs'!K254","v":2021},{"$f":"'Owner-Operator Inputs'!L254","v":2022},{"$f":"'Owner-Operator Inputs'!M254","v":2023},{"$f":"'Owner-Operator Inputs'!N254","v":2024},{"$f":"'Owner-Operator Inputs'!O254","v":2025}]
["Revenues"]
["Operating Revenue",0,{"$f":"'Owner-Operator Inputs'!F256","v":140000},{"$f":"'Owner-Operator Inputs'!G256","v":170800},{"$f":"'Owner-Operator Inputs'!H256","v":208377.5},{"$f":"'Owner-Operator Inputs'!I256","v":254225},{"$f":"'Owner-Operator Inputs'!J256","v":310155},{"$f":"'Owner-Operator Inputs'!K256","v":378392.5},{"$f":"'Owner-Operator Inputs'!L256","v":423750},{"$f":"'Owner-Operator Inputs'!M256","v":423750},{"$f":"'Owner-Operator Inputs'!N256","v":423750},{"$f":"'Owner-Operator Inputs'!O256","v":423750}]
["Other Revenue",0,{"$f":"'Owner-Operator Inputs'!F257","v":151000},{"$f":"'Owner-Operator Inputs'!G257","v":68320},{"$f":"'Owner-Operator Inputs'!H257","v":83350},{"$f":"'Owner-Operator Inputs'!I257","v":101687.5},{"$f":"'Owner-Operator Inputs'!J257","v":124060},{"$f":"'Owner-Operator Inputs'!K257","v":151355},{"$f":"'Owner-Operator Inputs'!L257","v":168250},{"$f":"'Owner-Operator Inputs'!M257","v":168250},{"$f":"'Owner-Operator Inputs'!N257","v":168250},{"$f":"'Owner-Operator Inputs'!O257","v":168250}]
["Total Revenues",{"$f":"SUM(B7:B8)","v":0},291000,239120,291727.5,355912.5,434215,529747.5,592000,592000,592000,592000]
[]
["Expenses"]
["Operating Expenses"]
["Cost of Sales",0,{"$f":"'Owner-Operator Inputs'!F260","v":79983.599999999991},{"$f":"'Owner-Operator Inputs'!G260","v":86493.091199999995},{"$f":"'Owner-Operator Inputs'!H260","v":94454.755965599994},{"$f":"'Owner-Operator Inputs'!I260","v":104192.74263844198},{"$f":"'Owner-Operator Inputs'!J260","v":116102.26151698151},{"$f":"'Owner-Operator Inputs'!K260","v":130668.72782813357},{"$f":"'Owner-Operator Inputs'!L260","v":140257.80959168912},{"$f":"'Owner-Operator Inputs'!M260","v":140481.45511566836},{"$f":"'Owner-Operator Inputs'!N260","v":140705.6597534575},{"$f":"'Owner-Operator Inputs'!O260","v":140930.42490284113}]
["Total Operating Expenses",{"$f":"SUM(B13:B13)","v":0},79983.599999999991,86493.091199999995,94454.755965599994,104192.74263844198,116102.26151698151,{"$f":"SUM(H13:H13)","v":130668.72782813357},{"$f":"SUM(I13:I13)","v":140257.80959168912},{"$f":"SUM(J13:J13)","v":140481.45511566836},{"$f":"SUM(K13:K13)","v":140705.6597534575},{"$f":"SUM(L13:L13)","v":140930.42490284113}]
[]
["Other Expenses"]
["SG&A (Overhead)",0,{"$f":"'Owner-Operator Inputs'!F262","v":14550},{"$f":"'Owner-Operator Inputs'!G262","v":11956},{"$f":"'Owner-Operator Inputs'!H262","v":14586.375},{"$f":"'Owner-Operator Inputs'!I262","v":17795.625},{"$f":"'Owner-Operator Inputs'!J262","v":21710.75},{"$f":"'Owner-Operator Inputs'!K262","v":26487.375},{"$f":"'Owner-Operator Inputs'!L262","v":29600},{"$f":"'Owner-Operator Inputs'!M262","v":29600},{"$f":"'Owner-Operator Inputs'!N262","v":29600},{"$f":"'Owner-Operator Inputs'!O262","v":29600}]
["Depreciation",0,{"$f":"'Owner-Operator Inputs'!F263","v":135500},{"$f":"'Owner-Operator Inputs'!G263","v":135500},{"$f":"'Owner-Operator Inputs'!H263","v":135500},{"$f":"'Owner-Operator Inputs'!I263","v":135500},{"$f":"'Owner-Operator Inputs'!J263","v":135500},{"$f":"'Owner-Operator Inputs'!K263","v":135500},{"$f":"'Owner-Operator Inputs'!L263","v":135500},{"$f":"'Owner-Operator Inputs'!M263","v":135500},{"$f":"'Owner-Operator Inputs'!N263","v":135500},{"$f":"'Owner-Operator Inputs'!O263","v":135500}]
["Total Other Expenses",{"$f":"SUM(B17:B18)","v":0},150050,147456,150086.375,153295.625,157210.75,{"$f":"SUM(H17:H18)","v":161987.375},{"$f":"SUM(I17:I18)","v":165100},{"$f":"SUM(J17:J18)","v":165100},{"$f":"SUM(K17:K18)","v":165100},{"$f":"SUM(L17:L18)","v":165100}]
[]
["Total Expenses",{"$f":"B19+B14","v":0},230033.59999999998,233949.0912,244541.13096559999,257488.36763844197,273313.01151698153,{"$f":"H19+H14","v":292656.10282813356},{"$f":"I19+I14","v":305357.80959168915},{"$f":"J19+J14","v":305581.45511566836},{"$f":"K19+K14","v":305805.65975345753},{"$f":"L19+L14","v":306030.4249028411}]
[]
["Operating Income (EBIT)",{"$f":"B9-B21","v":0},60966.400000000023,5170.9088000000047,47186.369034400006,98424.132361558033,160901.98848301847,{"$f":"H9-H21","v":237091.39717186644},{"$f":"I9-I21","v":286642.19040831085},{"$f":"J9-J21","v":286418.54488433164},{"$f":"K9-K21","v":286194.34024654247},{"$f":"L9-L21","v":285969.5750971589}]
[]
["Interest Income",0,{"$f":"'Owner-Operator Inputs'!F265","v":0},{"$f":"'Owner-Operator Inputs'!G265","v":0},{"$f":"'Owner-Operator Inputs'!H265","v":0},{"$f":"'Owner-Operator Inputs'!I265","v":0},{"$f":"'Owner-Operator Inputs'!J265","v":0},{"$f":"'Owner-Operator Inputs'!K265","v":0},{"$f":"'Owner-Operator Inputs'!L265","v":0},{"$f":"'Owner-Operator Inputs'!M265","v":0},{"$f":"'Owner-Operator Inputs'!N265","v":0},{"$f":"'Owner-Operator Inputs'!O265","v":0}]
["Other Income, Net",0,{"$f":"C$9*'Owner-Operator Inputs'!F266","v":0},{"$f":"D$9*'Owner-Operator Inputs'!G266","v":0},{"$f":"E$9*'Owner-Operator Inputs'!H266","v":0},{"$f":"F$9*'Owner-Operator Inputs'!I266","v":0},{"$f":"G$9*'Owner-Operator Inputs'!J266","v":0},{"$f":"H$9*'Owner-Operator Inputs'!K266","v":0},{"$f":"I$9*'Owner-Operator Inputs'!L266","v":0},{"$f":"J$9*'Owner-Operator Inputs'!M266","v":0},{"$f":"K$9*'Owner-Operator Inputs'!N266","v":0},{"$f":"L$9*'Owner-Operator Inputs'!O266","v":0}]
["Other Special Charges",0,{"$f":"'Owner-Operator Inputs'!F267","v":0},{"$f":"'Owner-Operator Inputs'!G267","v":0},{"$f":"'Owner-Operator Inputs'!H267","v":0},{"$f":"'Owner-Operator Inputs'!I267","v":0},{"$f":"'Owner-Operator Inputs'!J267","v":0},{"$f":"'Owner-Operator Inputs'!K267","v":0},{"$f":"'Owner-Operator Inputs'!L267","v":0},{"$f":"'Owner-Operator Inputs'!M267","v":0},{"$f":"'Owner-Operator Inputs'!N267","v":0},{"$f":"'Owner-Operator Inputs'!O267","v":0}]
["Adjusted Operating Income (EBIT)",{"$f":"SUM(B23:B27)","v":0},60966.400000000023,5170.9088000000047,47186.369034400006,98424.132361558033,160901.98848301847,{"$f":"SUM(H23:H27)","v":237091.39717186644},{"$f":"SUM(I23:I27)","v":286642.19040831085},{"$f":"SUM(J23:J27)","v":286418.54488433164},{"$f":"SUM(K23:K27)","v":286194.34024654247},{"$f":"SUM(L23:L27)","v":285969.5750971589}]
[]
["Interest Expense",0,{"$f":"'Debt Schedule'!D16+(-'Owner-Operator Inputs'!F270*('Balance Sheet'!C25))","v":-56012.718000000001},{"$f":"'Debt Schedule'!E16+(-'Owner-Operator Inputs'!G270*('Balance Sheet'!D25))","v":-51903.696418856467},{"$f":"'Debt Schedule'!F16+(-'Owner-Operator Inputs'!H270*('Balance Sheet'!E25))","v":-47650.283761540479},{"$f":"'Debt Schedule'!G16+(-'Owner-Operator Inputs'!I270*('Balance Sheet'!F25))","v":-43113.963496320648},{"$f":"'Debt Schedule'!H16+(-'Owner-Operator Inputs'!J270*('Balance Sheet'!G25))","v":-38276.754640290696},{"$f":"'Debt Schedule'!I16+(-'Owner-Operator Inputs'!K270*('Balance Sheet'!H25))","v":-33119.849513535395},{"$f":"'Debt Schedule'!J16+(-'Owner-Operator Inputs'!L270*('Balance Sheet'!I25))","v":-27554.235411046},{"$f":"'Debt Schedule'!K16+(-'Owner-Operator Inputs'!M270*('Balance Sheet'!J25))","v":-21516.62300289292},{"$f":"'Debt Schedule'!L16+(-'Owner-Operator Inputs'!N270*('Balance Sheet'!K25))","v":-15058.371222732407},{"$f":"'Debt Schedule'!M16+(-'Owner-Operator Inputs'!O270*('Balance Sheet'!L25))","v":-8149.196880318631}]
["Income Before Taxes (EBT)",{"$f":"SUM(B28:B30)","v":0},4953.6820000000225,-46732.787618856462,-463.91472714047268,55310.168865237385,122625.23384272779,{"$f":"SUM(H28:H30)","v":203971.54765833105},{"$f":"SUM(I28:I30)","v":259087.95499726484},{"$f":"SUM(J28:J30)","v":264901.9218814387},{"$f":"SUM(K28:K30)","v":271135.96902381006},{"$f":"SUM(L28:L30)","v":277820.37821684027}]
[]
["Income Taxes",0,{"$f":"-C31*'Owner-Operator Inputs'!F272","v":-1565.3896260067411},{"$f":"-D31*'Owner-Operator Inputs'!G272","v":14767.807245788859},{"$f":"-E31*'Owner-Operator Inputs'!H272","v":146.59949936581327},{"$f":"-F31*'Owner-Operator Inputs'!I272","v":-17478.304936474171},{"$f":"-G31*'Owner-Operator Inputs'!J272","v":-38750.220329858872},{"$f":"-H31*'Owner-Operator Inputs'!K272","v":-64456.084323719115},{"$f":"-I31*'Owner-Operator Inputs'!L272","v":-81873.159596441183},{"$f":"-J31*'Owner-Operator Inputs'!M272","v":-83710.403780955327},{"$f":"-K31*'Owner-Operator Inputs'!N272","v":-85680.395541569975},{"$f":"-L31*'Owner-Operator Inputs'!O272","v":-87792.704084337456}]
["Net Income",{"$f":"SUM(B31:B33)","v":0},3388.2923739932812,-31964.980373067603,-317.31522777465943,37831.86392876321,83875.013512868914,{"$f":"SUM(H31:H33)","v":139515.46333461194},{"$f":"SUM(I31:I33)","v":177214.79540082364},{"$f":"SUM(J31:J33)","v":181191.51810048337},{"$f":"SUM(K31:K33)","v":185455.57348224008},{"$f":"SUM(L31:L33)","v":190027.67413250281}]

{"sheet":"Balance Sheet","index":14,"n_rows":39,"n_cols":12,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Initial Settings'!C6","v":"Washington EV - Business Model 3 - Walla Walla"}]
[]
["Consolidated Balance Sheet [$]"]
[]
["Assets",{"$f":"+'Initial Settings'!$C$7","v":2015},{"$f":"+'Owner-Operator Inputs'!F254","v":2016},{"$f":"+'Owner-Operator Inputs'!G254","v":2017},{"$f":"+'Owner-Operator Inputs'!H254","v":2018},{"$f":"+'Owner-Operator Inputs'!I254","v":2019},{"$f":"+'Owner-Operator Inputs'!J254","v":2020},{"$f":"+'Owner-Operator Inputs'!K254","v":2021},{"$f":"+'Owner-Operator Inputs'!L254","v":2022},{"$f":"+'Owner-Operator Inputs'!M254","v":2023},{"$f":"+'Owner-Operator Inputs'!N254","v":2024},{"$f":"+'Owner-Operator Inputs'!O254","v":2025}]
["Current assets"]
["Cash and Equivalents",{"$f":"'Owner-Operator Inputs'!E230","v":29100},{"$f":"SCF!F28","v":136023.88567473998},{"$f":"SCF!G28","v":169263.77966127545},{"$f":"SCF!H28","v":240279.44375078788},{"$f":"SCF!I28","v":345983.68830161833},{"$f":"SCF!J28","v":494205.55298552453},{"$f":"SCF!K28","v":694511.87182941858},{"$f":"SCF!L28","v":923544.34994203481},{"$f":"SCF!M28","v":1144290.6883461578},{"$f":"SCF!N28","v":1362842.830351877},{"$f":"SCF!O28","v":1579057.8986654452}]
["Accounts Receivable",null,{"$f":"'Owner-Operator Inputs'!F282*'Income Statement'!C$9","v":14550},{"$f":"'Owner-Operator Inputs'!G282*'Income Statement'!D$9","v":11956},{"$f":"'Owner-Operator Inputs'!H282*'Income Statement'!E$9","v":14586.375},{"$f":"'Owner-Operator Inputs'!I282*'Income Statement'!F$9","v":17795.625},{"$f":"'Owner-Operator Inputs'!J282*'Income Statement'!G$9","v":21710.75},{"$f":"'Owner-Operator Inputs'!K282*'Income Statement'!H$9","v":26487.375},{"$f":"'Owner-Operator Inputs'!L282*'Income Statement'!I$9","v":29600},{"$f":"'Owner-Operator Inputs'!M282*'Income Statement'!J$9","v":29600},{"$f":"'Owner-Operator Inputs'!N282*'Income Statement'!K$9","v":29600},{"$f":"'Owner-Operator Inputs'!O282*'Income Statement'!L$9","v":29600}]
["Other Receivable",null,{"$f":"'Owner-Operator Inputs'!F283*'Income Statement'!C$9","v":0},{"$f":"'Owner-Operator Inputs'!G283*'Income Statement'!D$9","v":0},{"$f":"'Owner-Operator Inputs'!H283*'Income Statement'!E$9","v":0},{"$f":"'Owner-Operator Inputs'!I283*'Income Statement'!F$9","v":0},{"$f":"'Owner-Operator Inputs'!J283*'Income Statement'!G$9","v":0},{"$f":"'Owner-Operator Inputs'!K283*'Income Statement'!H$9","v":0},{"$f":"'Owner-Operator Inputs'!L283*'Income Statement'!I$9","v":0},{"$f":"'Owner-Operator Inputs'!M283*'Income Statement'!J$9","v":0},{"$f":"'Owner-Operator Inputs'!N283*'Income Statement'!K$9","v":0},{"$f":"'Owner-Operator Inputs'!O283*'Income Statement'!L$9","v":0}]
["Prepaid Expenses",null,{"$f":"'Owner-Operator Inputs'!F284*'Income Statement'!C$9","v":0},{"$f":"'Owner-Operator Inputs'!G284*'Income Statement'!D$9","v":0},{"$f":"'Owner-Operator Inputs'!H284*'Income Statement'!E$9","v":0},{"$f":"'Owner-Operator Inputs'!I284*'Income Statement'!F$9","v":0},{"$f":"'Owner-Operator Inputs'!J284*'Income Statement'!G$9","v":0},{"$f":"'Owner-Operator Inputs'!K284*'Income Statement'!H$9","v":0},{"$f":"'Owner-Operator Inputs'!L284*'Income Statement'!I$9","v":0},{"$f":"'Owner-Operator Inputs'!M284*'Income Statement'!J$9","v":0},{"$f":"'Owner-Operator Inputs'!N284*'Income Statement'!K$9","v":0},{"$f":"'Owner-Operator Inputs'!O284*'Income Statement'!L$9","v":0}]
["Total current assets",{"$f":"SUM(B7:B10)","v":29100},150573.88567473998,181219.77966127545,254865.81875078788,363779.31330161833,515916.30298552453,{"$f":"SUM(H7:H10)","v":720999.24682941858},{"$f":"SUM(I7:I10)","v":953144.34994203481},{"$f":"SUM(J7:J10)","v":1173890.6883461578},{"$f":"SUM(K7:K10)","v":1392442.830351877},{"$f":"SUM(L7:L10)","v":1608657.8986654452}]
[]
["Non-Current Assets"]
["Gross Fixed Assets (Plant, Prop. & Equip.)",{"$f":"'Owner-Operator Inputs'!E287","v":1355000},{"$f":"'Owner-Operator Inputs'!F287","v":1355000},{"$f":"'Owner-Operator Inputs'!G287","v":1355000},{"$f":"'Owner-Operator Inputs'!H287","v":1355000},{"$f":"'Owner-Operator Inputs'!I287","v":1355000},{"$f":"'Owner-Operator Inputs'!J287","v":1355000},{"$f":"'Owner-Operator Inputs'!K287","v":1355000},{"$f":"'Owner-Operator Inputs'!L287","v":1355000},{"$f":"'Owner-Operator Inputs'!M287","v":1355000},{"$f":"'Owner-Operator Inputs'!N287","v":1355000},{"$f":"'Owner-Operator Inputs'!O287","v":1355000}]
["Accumulated Depreciation & Depletion",null,{"$f":"'Owner-Operator Inputs'!F288","v":-135500},{"$f":"'Owner-Operator Inputs'!G288","v":-271000},{"$f":"'Owner-Operator Inputs'!H288","v":-406500},{"$f":"'Owner-Operator Inputs'!I288","v":-542000},{"$f":"'Owner-Operator Inputs'!J288","v":-677500},{"$f":"'Owner-Operator Inputs'!K288","v":-813000},{"$f":"'Owner-Operator Inputs'!L288","v":-948500},{"$f":"'Owner-Operator Inputs'!M288","v":-1084000},{"$f":"'Owner-Operator Inputs'!N288","v":-1219500},{"$f":"'Owner-Operator Inputs'!O288","v":-1355000}]
["Intangibles (Goodwill)",null,{"$f":"'Owner-Operator Inputs'!F289*'Income Statement'!C$9","v":0},{"$f":"'Owner-Operator Inputs'!G289*'Income Statement'!D$9","v":0},{"$f":"'Owner-Operator Inputs'!H289*'Income Statement'!E$9","v":0},{"$f":"'Owner-Operator Inputs'!I289*'Income Statement'!F$9","v":0},{"$f":"'Owner-Operator Inputs'!J289*'Income Statement'!G$9","v":0},{"$f":"'Owner-Operator Inputs'!K289*'Income Statement'!H$9","v":0},{"$f":"'Owner-Operator Inputs'!L289*'Income Statement'!I$9","v":0},{"$f":"'Owner-Operator Inputs'!M289*'Income Statement'!J$9","v":0},{"$f":"'Owner-Operator Inputs'!N289*'Income Statement'!K$9","v":0},{"$f":"'Owner-Operator Inputs'!O289*'Income Statement'!L$9","v":0}]
["Other Non-Current Assets",null,{"$f":"'Owner-Operator Inputs'!F290*'Income Statement'!C$9","v":0},{"$f":"'Owner-Operator Inputs'!G290*'Income Statement'!D$9","v":0},{"$f":"'Owner-Operator Inputs'!H290*'Income Statement'!E$9","v":0},{"$f":"'Owner-Operator Inputs'!I290*'Income Statement'!F$9","v":0},{"$f":"'Owner-Operator Inputs'!J290*'Income Statement'!G$9","v":0},{"$f":"'Owner-Operator Inputs'!K290*'Income Statement'!H$9","v":0},{"$f":"'Owner-Operator Inputs'!L290*'Income Statement'!I$9","v":0},{"$f":"'Owner-Operator Inputs'!M290*'Income Statement'!J$9","v":0},{"$f":"'Owner-Operator Inputs'!N290*'Income Statement'!K$9","v":0},{"$f":"'Owner-Operator Inputs'!O290*'Income Statement'!L$9","v":0}]
["Total Non-Current Assets",{"$f":"SUM(B14:B17)","v":1355000},1219500,1084000,948500,813000,677500,{"$f":"SUM(H14:H17)","v":542000},{"$f":"SUM(I14:I17)","v":406500},{"$f":"SUM(J14:J17)","v":271000},{"$f":"SUM(K14:K17)","v":135500},{"$f":"SUM(L14:L17)","v":0}]
[]
["Total assets",{"$f":"B11+B18","v":1384100},1370073.88567474,1265219.7796612754,1203365.818750788,1176779.3133016182,1193416.3029855245,{"$f":"H11+H18","v":1262999.2468294185},{"$f":"I11+I18","v":1359644.3499420348},{"$f":"J11+J18","v":1444890.6883461578},{"$f":"K11+K18","v":1527942.830351877},{"$f":"L11+L18","v":1608657.8986654452}]
[]
["Liabilities and stockholders' equity"]
["Current liabilities:"]
["Accounts Payable",null,{"$f":"'Owner-Operator Inputs'!F294*'Income Statement'!C$9","v":34920},{"$f":"'Owner-Operator Inputs'!G294*'Income Statement'!D$9","v":28694.399999999998},{"$f":"'Owner-Operator Inputs'!H294*'Income Statement'!E$9","v":35007.299999999996},{"$f":"'Owner-Operator Inputs'!I294*'Income Statement'!F$9","v":42709.5},{"$f":"'Owner-Operator Inputs'!J294*'Income Statement'!G$9","v":52105.799999999996},{"$f":"'Owner-Operator Inputs'!K294*'Income Statement'!H$9","v":63569.7},{"$f":"'Owner-Operator Inputs'!L294*'Income Statement'!I$9","v":71040},{"$f":"'Owner-Operator Inputs'!M294*'Income Statement'!J$9","v":71040},{"$f":"'Owner-Operator Inputs'!N294*'Income Statement'!K$9","v":71040},{"$f":"'Owner-Operator Inputs'!O294*'Income Statement'!L$9","v":71040}]
["Revolving Line of Credit",null,{"$f":"'Owner-Operator Inputs'!F295*'Income Statement'!C$9","v":8730},{"$f":"'Owner-Operator Inputs'!G295*'Income Statement'!D$9","v":7173.5999999999995},{"$f":"'Owner-Operator Inputs'!H295*'Income Statement'!E$9","v":8751.8249999999989},{"$f":"'Owner-Operator Inputs'!I295*'Income Statement'!F$9","v":10677.375},{"$f":"'Owner-Operator Inputs'!J295*'Income Statement'!G$9","v":13026.449999999999},{"$f":"'Owner-Operator Inputs'!K295*'Income Statement'!H$9","v":15892.424999999999},{"$f":"'Owner-Operator Inputs'!L295*'Income Statement'!I$9","v":17760},{"$f":"'Owner-Operator Inputs'!M295*'Income Statement'!J$9","v":17760},{"$f":"'Owner-Operator Inputs'!N295*'Income Statement'!K$9","v":17760},{"$f":"'Owner-Operator Inputs'!O295*'Income Statement'!L$9","v":17760}]
["Current Portion of Long Term Debt",{"$f":"'Owner-Operator Inputs'!E296","v":61064.406699253363},{"$f":"'Owner-Operator Inputs'!F296","v":65107.125640396902},{"$f":"'Owner-Operator Inputs'!G296","v":69427.770682712886},{"$f":"'Owner-Operator Inputs'!H296","v":74046.119377932715},{"$f":"'Owner-Operator Inputs'!I296","v":78983.398828962672},{"$f":"'Owner-Operator Inputs'!J296","v":84262.394490717968},{"$f":"'Owner-Operator Inputs'!K296","v":89907.567288207356},{"$f":"'Owner-Operator Inputs'!L296","v":95945.179696360443},{"$f":"'Owner-Operator Inputs'!M296","v":102403.43147652096},{"$f":"'Owner-Operator Inputs'!N296","v":109312.60581893474},{"$f":"'Owner-Operator Inputs'!O296","v":0}]
["Total current liabilities",{"$f":"SUM(B24:B26)","v":61064.406699253363},108757.1256403969,105295.77068271289,117805.24437793271,132370.27382896267,149394.64449071797,{"$f":"SUM(H24:H26)","v":169369.69228820736},{"$f":"SUM(I24:I26)","v":184745.17969636043},{"$f":"SUM(J24:J26)","v":191203.43147652096},{"$f":"SUM(K24:K26)","v":198112.60581893474},{"$f":"SUM(L24:L26)","v":88800}]
[]
["Non-Current Liabilities"]
["Long Term Debt, Net Current Portion",{"$f":"'Owner-Operator Inputs'!E299","v":769395.59330074664},{"$f":"'Owner-Operator Inputs'!F299","v":704288.46766034979},{"$f":"'Owner-Operator Inputs'!G299","v":634860.69697763689},{"$f":"'Owner-Operator Inputs'!H299","v":560814.57759970415},{"$f":"'Owner-Operator Inputs'!I299","v":481831.17877074145},{"$f":"'Owner-Operator Inputs'!J299","v":397568.78428002348},{"$f":"'Owner-Operator Inputs'!K299","v":307661.21699181612},{"$f":"'Owner-Operator Inputs'!L299","v":211716.0372954557},{"$f":"'Owner-Operator Inputs'!M299","v":109312.60581893474},{"$f":"'Owner-Operator Inputs'!N299","v":0},{"$f":"'Owner-Operator Inputs'!O299","v":0}]
["Total Non-Current Liabilities",{"$f":"SUM(B30:B30)","v":769395.59330074664},704288.46766034979,634860.69697763689,560814.57759970415,481831.17877074145,397568.78428002348,{"$f":"SUM(H30:H30)","v":307661.21699181612},{"$f":"SUM(I30:I30)","v":211716.0372954557},{"$f":"SUM(J30:J30)","v":109312.60581893474},{"$f":"SUM(K30:K30)","v":0},{"$f":"SUM(L30:L30)","v":0}]
[]
["Total Liabilities",{"$f":"B31+B27","v":830460},813045.59330074675,740156.46766034979,678619.82197763689,614201.45259970415,546963.42877074145,{"$f":"H31+H27","v":477030.90928002348},{"$f":"I31+I27","v":396461.21699181612},{"$f":"J31+J27","v":300516.0372954557},{"$f":"K31+K27","v":198112.60581893474},{"$f":"L31+L27","v":88800}]
[]
[]
["Total stockholders' equity",{"$f":"'Owner-Operator Inputs'!E233","v":553640},{"$f":"B36+SCF!F7","v":557028.29237399332},{"$f":"C36+SCF!G7","v":525063.31200092577},{"$f":"D36+SCF!H7","v":524745.9967731511},{"$f":"E36+SCF!I7","v":562577.86070191429},{"$f":"F36+SCF!J7","v":646452.87421478319},{"$f":"G36+SCF!K7","v":785968.33754939516},{"$f":"H36+SCF!L7","v":963183.13295021886},{"$f":"I36+SCF!M7","v":1144374.6510507022},{"$f":"J36+SCF!N7","v":1329830.2245329423},{"$f":"K36+SCF!O7","v":1519857.8986654452}]
[]
["Total liabilities and stockholders' equity",{"$f":"B33+B36","v":1384100},1370073.8856747402,1265219.7796612754,1203365.818750788,1176779.3133016184,1193416.3029855248,{"$f":"H33+H36","v":1262999.2468294187},{"$f":"I33+I36","v":1359644.349942035},{"$f":"J33+J36","v":1444890.6883461578},{"$f":"K33+K36","v":1527942.830351877},{"$f":"L33+L36","v":1608657.8986654452}]
["Unreconciled Difference",{"$f":"B20-B38","v":0},0,0,0,0,0,{"$f":"H20-H38","v":0},{"$f":"I20-I38","v":0},{"$f":"J20-J38","v":0},{"$f":"K20-K38","v":0},{"$f":"L20-L38","v":0}]

{"sheet":"SCF","index":15,"n_rows":30,"n_cols":15,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[{"$f":"'Initial Settings'!$C$6","v":"Washington EV - Business Model 3 - Walla Walla"}]
[]
["Consolidated Statement of Cash Flows [$]"]
[]
[null,null,null,null,null,{"$f":"'Owner-Operator Inputs'!F254","v":2016},{"$f":"'Owner-Operator Inputs'!G254","v":2017},{"$f":"'Owner-Operator Inputs'!H254","v":2018},{"$f":"'Owner-Operator Inputs'!I254","v":2019},{"$f":"'Owner-Operator Inputs'!J254","v":2020},{"$f":"'Owner-Operator Inputs'!K254","v":2021},{"$f":"'Owner-Operator Inputs'!L254","v":2022},{"$f":"'Owner-Operator Inputs'!M254","v":2023},{"$f":"'Owner-Operator Inputs'!N254","v":2024},{"$f":"'Owner-Operator Inputs'!O254","v":2025}]
["Cash Flow from Operations"]
["Net Income (Loss)",null,null,null,null,{"$f":"'Income Statement'!C34","v":3388.2923739932812},{"$f":"'Income Statement'!D34","v":-31964.980373067603},{"$f":"'Income Statement'!E34","v":-317.31522777465943},{"$f":"'Income Statement'!F34","v":37831.86392876321},{"$f":"'Income Statement'!G34","v":83875.013512868914},{"$f":"'Income Statement'!H34","v":139515.46333461194},{"$f":"'Income Statement'!I34","v":177214.79540082364},{"$f":"'Income Statement'!J34","v":181191.51810048337},{"$f":"'Income Statement'!K34","v":185455.57348224008},{"$f":"'Income Statement'!L34","v":190027.67413250281}]
["Depreciation",null,null,null,null,{"$f":"'Income Statement'!C18","v":135500},{"$f":"'Income Statement'!D18","v":135500},{"$f":"'Income Statement'!E18","v":135500},{"$f":"'Income Statement'!F18","v":135500},{"$f":"'Income Statement'!G18","v":135500},{"$f":"'Income Statement'!H18","v":135500},{"$f":"'Income Statement'!I18","v":135500},{"$f":"'Income Statement'!J18","v":135500},{"$f":"'Income Statement'!K18","v":135500},{"$f":"'Income Statement'!L18","v":135500}]
["(Increase) Decrease in Accounts Receivable",null,null,null,null,{"$f":"'Balance Sheet'!B8-'Balance Sheet'!C8","v":-14550},{"$f":"'Balance Sheet'!C8-'Balance Sheet'!D8","v":2594},{"$f":"'Balance Sheet'!D8-'Balance Sheet'!E8","v":-2630.375},{"$f":"'Balance Sheet'!E8-'Balance Sheet'!F8","v":-3209.25},{"$f":"'Balance Sheet'!F8-'Balance Sheet'!G8","v":-3915.125},{"$f":"'Balance Sheet'!G8-'Balance Sheet'!H8","v":-4776.625},{"$f":"'Balance Sheet'!H8-'Balance Sheet'!I8","v":-3112.625},{"$f":"'Balance Sheet'!I8-'Balance Sheet'!J8","v":0},{"$f":"'Balance Sheet'!J8-'Balance Sheet'!K8","v":0},{"$f":"'Balance Sheet'!K8-'Balance Sheet'!L8","v":0}]
["(Increase) Decrease in Other Receivable",null,null,null,null,{"$f":"'Balance Sheet'!B9-'Balance Sheet'!C9","v":0},{"$f":"'Balance Sheet'!C9-'Balance Sheet'!D9","v":0},{"$f":"'Balance Sheet'!D9-'Balance Sheet'!E9","v":0},{"$f":"'Balance Sheet'!E9-'Balance Sheet'!F9","v":0},{"$f":"'Balance Sheet'!F9-'Balance Sheet'!G9","v":0},{"$f":"'Balance Sheet'!G9-'Balance Sheet'!H9","v":0},{"$f":"'Balance Sheet'!H9-'Balance Sheet'!I9","v":0},{"$f":"'Balance Sheet'!I9-'Balance Sheet'!J9","v":0},{"$f":"'Balance Sheet'!J9-'Balance Sheet'!K9","v":0},{"$f":"'Balance Sheet'!K9-'Balance Sheet'!L9","v":0}]
["(Increase) Decrease in Prepaid Expenses",null,null,null,null,{"$f":"'Balance Sheet'!B10-'Balance Sheet'!C10","v":0},{"$f":"'Balance Sheet'!C10-'Balance Sheet'!D10","v":0},{"$f":"'Balance Sheet'!D10-'Balance Sheet'!E10","v":0},{"$f":"'Balance Sheet'!E10-'Balance Sheet'!F10","v":0},{"$f":"'Balance Sheet'!F10-'Balance Sheet'!G10","v":0},{"$f":"'Balance Sheet'!G10-'Balance Sheet'!H10","v":0},{"$f":"'Balance Sheet'!H10-'Balance Sheet'!I10","v":0},{"$f":"'Balance Sheet'!I10-'Balance Sheet'!J10","v":0},{"$f":"'Balance Sheet'!J10-'Balance Sheet'!K10","v":0},{"$f":"'Balance Sheet'!K10-'Balance Sheet'!L10","v":0}]
["(Increase) Decrease in Intangibles",null,null,null,null,{"$f":"'Balance Sheet'!B16-'Balance Sheet'!C16","v":0},{"$f":"'Balance Sheet'!C16-'Balance Sheet'!D16","v":0},{"$f":"'Balance Sheet'!D16-'Balance Sheet'!E16","v":0},{"$f":"'Balance Sheet'!E16-'Balance Sheet'!F16","v":0},{"$f":"'Balance Sheet'!F16-'Balance Sheet'!G16","v":0},{"$f":"'Balance Sheet'!G16-'Balance Sheet'!H16","v":0},{"$f":"'Balance Sheet'!H16-'Balance Sheet'!I16","v":0},{"$f":"'Balance Sheet'!I16-'Balance Sheet'!J16","v":0},{"$f":"'Balance Sheet'!J16-'Balance Sheet'!K16","v":0},{"$f":"'Balance Sheet'!K16-'Balance Sheet'!L16","v":0}]
["(Increase) Decrease in Other Non-Current Assets",null,null,null,null,{"$f":"'Balance Sheet'!B17-'Balance Sheet'!C17","v":0},{"$f":"'Balance Sheet'!C17-'Balance Sheet'!D17","v":0},{"$f":"'Balance Sheet'!D17-'Balance Sheet'!E17","v":0},{"$f":"'Balance Sheet'!E17-'Balance Sheet'!F17","v":0},{"$f":"'Balance Sheet'!F17-'Balance Sheet'!G17","v":0},{"$f":"'Balance Sheet'!G17-'Balance Sheet'!H17","v":0},{"$f":"'Balance Sheet'!H17-'Balance Sheet'!I17","v":0},{"$f":"'Balance Sheet'!I17-'Balance Sheet'!J17","v":0},{"$f":"'Balance Sheet'!J17-'Balance Sheet'!K17","v":0},{"$f":"'Balance Sheet'!K17-'Balance Sheet'!L17","v":0}]
["(Decrease) Increase in Accounts Payable",null,null,null,null,{"$f":"'Balance Sheet'!C24-'Balance Sheet'!B24","v":34920},{"$f":"'Balance Sheet'!D24-'Balance Sheet'!C24","v":-6225.6000000000022},{"$f":"'Balance Sheet'!E24-'Balance Sheet'!D24","v":6312.8999999999978},{"$f":"'Balance Sheet'!F24-'Balance Sheet'!E24","v":7702.2000000000044},{"$f":"'Balance Sheet'!G24-'Balance Sheet'!F24","v":9396.2999999999956},{"$f":"'Balance Sheet'!H24-'Balance Sheet'!G24","v":11463.900000000001},{"$f":"'Balance Sheet'!I24-'Balance Sheet'!H24","v":7470.3000000000029},{"$f":"'Balance Sheet'!J24-'Balance Sheet'!I24","v":0},{"$f":"'Balance Sheet'!K24-'Balance Sheet'!J24","v":0},{"$f":"'Balance Sheet'!L24-'Balance Sheet'!K24","v":0}]
["Total",null,null,null,null,{"$f":"SUM(F7:F14)","v":159258.29237399329},99903.419626932387,138865.20977222532,177824.81392876321,224856.18851286889,281702.73833461199,317072.47040082363,316691.51810048334,320955.57348224008,325527.67413250281]
[]
["Cash Flow from Investing"]
["CAPEX",null,null,null,null,{"$f":"-((SUM('Balance Sheet'!C14:C15)-SUM('Balance Sheet'!B14:B15))+'Income Statement'!C18)","v":0},{"$f":"-((SUM('Balance Sheet'!D14:D15)-SUM('Balance Sheet'!C14:C15))+'Income Statement'!D18)","v":0},{"$f":"-((SUM('Balance Sheet'!E14:E15)-SUM('Balance Sheet'!D14:D15))+'Income Statement'!E18)","v":0},{"$f":"-((SUM('Balance Sheet'!F14:F15)-SUM('Balance Sheet'!E14:E15))+'Income Statement'!F18)","v":0},{"$f":"-((SUM('Balance Sheet'!G14:G15)-SUM('Balance Sheet'!F14:F15))+'Income Statement'!G18)","v":0},{"$f":"-((SUM('Balance Sheet'!H14:H15)-SUM('Balance Sheet'!G14:G15))+'Income Statement'!H18)","v":0},{"$f":"-((SUM('Balance Sheet'!I14:I15)-SUM('Balance Sheet'!H14:H15))+'Income Statement'!I18)","v":0},{"$f":"-((SUM('Balance Sheet'!J14:J15)-SUM('Balance Sheet'!I14:I15))+'Income Statement'!J18)","v":0},{"$f":"-((SUM('Balance Sheet'!K14:K15)-SUM('Balance Sheet'!J14:J15))+'Income Statement'!K18)","v":0},{"$f":"-((SUM('Balance Sheet'!L14:L15)-SUM('Balance Sheet'!K14:K15))+'Income Statement'!L18)","v":0}]
["Total",null,null,null,null,{"$f":"SUM(F18:F18)","v":0},0,0,0,0,0,0,0,0,0]
[]
["Cash Flow from Financing"]
["Revolving Line of Credit",null,null,null,null,{"$f":"'Balance Sheet'!C25-'Balance Sheet'!B25","v":8730},{"$f":"'Balance Sheet'!D25-'Balance Sheet'!C25","v":-1556.4000000000005},{"$f":"'Balance Sheet'!E25-'Balance Sheet'!D25","v":1578.2249999999995},{"$f":"'Balance Sheet'!F25-'Balance Sheet'!E25","v":1925.5500000000011},{"$f":"'Balance Sheet'!G25-'Balance Sheet'!F25","v":2349.0749999999989},{"$f":"'Balance Sheet'!H25-'Balance Sheet'!G25","v":2865.9750000000004},{"$f":"'Balance Sheet'!I25-'Balance Sheet'!H25","v":1867.5750000000007},{"$f":"'Balance Sheet'!J25-'Balance Sheet'!I25","v":0},{"$f":"'Balance Sheet'!K25-'Balance Sheet'!J25","v":0},{"$f":"'Balance Sheet'!L25-'Balance Sheet'!K25","v":0}]
["Long Term Debt ",null,null,null,null,{"$f":"('Balance Sheet'!C30-'Balance Sheet'!B30)+('Balance Sheet'!C26-'Balance Sheet'!B26)","v":-61064.406699253304},{"$f":"('Balance Sheet'!D30-'Balance Sheet'!C30)+('Balance Sheet'!D26-'Balance Sheet'!C26)","v":-65107.125640396916},{"$f":"('Balance Sheet'!E30-'Balance Sheet'!D30)+('Balance Sheet'!E26-'Balance Sheet'!D26)","v":-69427.770682712915},{"$f":"('Balance Sheet'!F30-'Balance Sheet'!E30)+('Balance Sheet'!F26-'Balance Sheet'!E26)","v":-74046.119377932744},{"$f":"('Balance Sheet'!G30-'Balance Sheet'!F30)+('Balance Sheet'!G26-'Balance Sheet'!F26)","v":-78983.398828962672},{"$f":"('Balance Sheet'!H30-'Balance Sheet'!G30)+('Balance Sheet'!H26-'Balance Sheet'!G26)","v":-84262.394490717968},{"$f":"('Balance Sheet'!I30-'Balance Sheet'!H30)+('Balance Sheet'!I26-'Balance Sheet'!H26)","v":-89907.567288207341},{"$f":"('Balance Sheet'!J30-'Balance Sheet'!I30)+('Balance Sheet'!J26-'Balance Sheet'!I26)","v":-95945.179696360443},{"$f":"('Balance Sheet'!K30-'Balance Sheet'!J30)+('Balance Sheet'!K26-'Balance Sheet'!J26)","v":-102403.43147652096},{"$f":"('Balance Sheet'!L30-'Balance Sheet'!K30)+('Balance Sheet'!L26-'Balance Sheet'!K26)","v":-109312.60581893474}]
["Total",null,null,null,null,{"$f":"SUM(F22:F23)","v":-52334.406699253304},-66663.525640396911,-67849.545682712909,-72120.569377932741,-76634.323828962675,-81396.419490717963,-88039.992288207344,-95945.179696360443,-102403.43147652096,-109312.60581893474]
[]
["Net Change in Cash",null,null,null,null,{"$f":"F15+F19+F24","v":106923.88567473998},33239.893986535477,71015.664089512415,105704.24455083047,148221.8646839062,200306.31884389403,229032.47811261629,220746.33840412291,218552.14200571913,216215.06831356807]
["Cash at Beginning of Year",null,null,null,null,{"$f":"'Balance Sheet'!B7","v":29100},{"$f":"'Balance Sheet'!C7","v":136023.88567473998},{"$f":"'Balance Sheet'!D7","v":169263.77966127545},{"$f":"'Balance Sheet'!E7","v":240279.44375078788},{"$f":"'Balance Sheet'!F7","v":345983.68830161833},{"$f":"'Balance Sheet'!G7","v":494205.55298552453},{"$f":"'Balance Sheet'!H7","v":694511.87182941858},{"$f":"'Balance Sheet'!I7","v":923544.34994203481},{"$f":"'Balance Sheet'!J7","v":1144290.6883461578},{"$f":"'Balance Sheet'!K7","v":1362842.830351877}]
["Cash at End of Year",null,null,null,null,{"$f":"F26+F27","v":136023.88567473998},169263.77966127545,240279.44375078788,345983.68830161833,494205.55298552453,694511.87182941858,923544.34994203481,1144290.6883461578,1362842.830351877,1579057.8986654452]
["Cash Per Balance Sheet",null,null,null,null,{"$f":"'Balance Sheet'!C7","v":136023.88567473998},{"$f":"'Balance Sheet'!D7","v":169263.77966127545},{"$f":"'Balance Sheet'!E7","v":240279.44375078788},{"$f":"'Balance Sheet'!F7","v":345983.68830161833},{"$f":"'Balance Sheet'!G7","v":494205.55298552453},{"$f":"'Balance Sheet'!H7","v":694511.87182941858},{"$f":"'Balance Sheet'!I7","v":923544.34994203481},{"$f":"'Balance Sheet'!J7","v":1144290.6883461578},{"$f":"'Balance Sheet'!K7","v":1362842.830351877},{"$f":"'Balance Sheet'!L7","v":1579057.8986654452}]
["Unreconciled Difference",null,null,null,null,{"$f":"F29-F28","v":0},0,0,0,0,0,0,0,0,0]

{"sheet":"Report","index":16,"n_rows":31,"n_cols":3,"rows_kept":31,"cut":false,"hidden":true,"merged":[[13,0,13,1],[20,0,20,1],[14,0,14,1],[15,0,15,1],[16,0,16,2],[17,0,17,1],[18,0,18,1],[19,0,19,1],[12,0,12,1],[0,0,0,1],[1,0,1,2],[2,0,2,1],[3,0,3,1],[4,0,4,1],[5,0,5,2],[6,0,6,1],[7,0,8,0],[9,0,9,1],[10,0,10,1],[11,0,11,2]]}
["Financial Metric",null,"Result"]
["Total project level perspective"]
["Total capital investment (spent on charging station deployment)",null,{"$f":"'Outputs Dashboard'!C5","v":1384100}]
["NPV",null,{"$f":"IF('Outputs Dashboard'!C6>0, \"+\" & TEXT('Outputs Dashboard'!C6, \"$#,##0\"), TEXT('Outputs Dashboard'!C6, \"$#,##0\"))","v":"+$862,640"}]
["Payback period",null,{"$f":"IF('Outputs Dashboard'!C8=\"N/A\", \"No payback\", 'Outputs Dashboard'!C8 & \" years\")","v":"6 years"}]
["Owner operator perspective"]
["Funds spent on stations (equity)",null,{"$f":"'Outputs Dashboard'!C11","v":316140.00000000029}]
["Funds spent on stations (debt)","Private loans",{"$f":"'Owner-Operator Inputs'!E238","v":415230}]
[null,"Public subsidized loans",{"$f":"'Owner-Operator Inputs'!E237","v":415230}]
["NPV",null,{"$f":"IF('Outputs Dashboard'!C12>0, \"+\" & TEXT('Outputs Dashboard'!C12, \"$#,##0\"), TEXT('Outputs Dashboard'!C12, \"$#,##0\"))","v":"+$490,899"}]
["Payback period",null,{"$f":"IF('Outputs Dashboard'!C14=\"N/A\", \"No payback\", 'Outputs Dashboard'!C14 & \" years\")","v":"5 years"}]
["Funding partner perspective"]
["Amount of funds transferred to owner operator initially",null,{"$f":"'Private Sector Partner Inputs'!F59","v":95000}]
["Amount of funds transferred to owner operator annually",null,{"$f":"IF('Private Sector Partner Inputs'!F55>0, TEXT('Private Sector Partner Inputs'!F55, \"$#,##0\") & \" - \" & TEXT('Private Sector Partner Inputs'!O55, \"$#,##0\"), \"$0\")","v":"$56,000 - $168,250"}]
["NPV",null,{"$f":"IF('Outputs Dashboard'!C19>0, \"+\" & TEXT('Outputs Dashboard'!C19, \"$#,##0\"), TEXT('Outputs Dashboard'!C19, \"$#,##0\"))","v":"+$495,520"}]
["Payback period",null,{"$f":"IF('Outputs Dashboard'!C21=\"N/A\", \"No payback\", 'Outputs Dashboard'!C21 & \" years\")","v":"2 years"}]
["Public sector perspective"]
["Loan to owner-operator",null,{"$f":"'Public Sector Partner Inputs'!E10","v":415230}]
["Grants to owner-operator",null,{"$f":"'Public Sector Partner Inputs'!E17","v":237499.99999999971}]
["NPV",null,{"$f":"IF('Outputs Dashboard'!C26>0, \"+\" & TEXT('Outputs Dashboard'!C26, \"$#,##0\"), TEXT('Outputs Dashboard'!C26, \"$#,##0\"))","v":"-$237,500"}]
["Payback period",null,{"$f":"IF('Outputs Dashboard'!C28=\"N/A\", \"No payback\", 'Outputs Dashboard'!C28 & \" years\")","v":"No payback"}]
[]
["Financial Metric","Result"]
["Project NPV & Payback",{"$f":"TEXT('Outputs Dashboard'!C6, \"$#,##0\")  & IF('Outputs Dashboard'!C8<>\"N/A\", \" (\" & 'Outputs Dashboard'!C8 & \")\", \"\")","v":"$862,640 (6)"}]
["Owner Operator NPV & Payback",{"$f":"TEXT('Outputs Dashboard'!C12, \"$#,##0\")  & IF('Outputs Dashboard'!C14<>\"N/A\", \" (\" & 'Outputs Dashboard'!C14 & \")\", \"\")","v":"$490,899 (5)"}]
["Private Sector Partner NPV & Payback",{"$f":"TEXT('Outputs Dashboard'!C19, \"$#,##0\")  & IF('Outputs Dashboard'!C21<>\"N/A\", \" (\" & 'Outputs Dashboard'!C21 & \")\", \"\")","v":"$495,520 (2)"}]
["Public Sector Partner NPV & Payback",{"$f":"TEXT('Outputs Dashboard'!C26, \"$#,##0\")  & IF('Outputs Dashboard'!C28<>\"N/A\", \" (\" & 'Outputs Dashboard'!C28 & \")\", \"\")","v":"-$237,500"}]
[]
["Initial Utilization Scale Factor",1]
["Max Charging Sessions Per Year Scale Factor",1]
["Installation Cost Scale Factor",1]

{"sheet":"Sensitivity Tables","index":17,"n_rows":224,"n_cols":9,"rows_kept":224,"cut":false,"hidden":false,"merged":[[74,1,74,8],[75,1,75,4],[160,1,160,4],[160,5,160,8],[143,5,143,8],[143,1,143,4],[142,1,142,8],[159,1,159,8],[109,1,109,4],[109,5,109,8],[125,1,125,8],[126,1,126,4],[126,5,126,8],[75,5,75,8],[91,1,91,8],[92,1,92,4],[40,1,40,8],[41,1,41,4],[41,5,41,8],[57,1,57,8],[58,1,58,4],[58,5,58,8],[24,1,24,4],[24,5,24,8],[2,0,2,6],[6,1,6,8],[23,1,23,8],[7,1,7,4],[7,5,7,8],[92,5,92,8],[108,1,108,8],[210,1,210,8],[211,1,211,4],[211,5,211,8],[176,1,176,8],[177,1,177,4],[177,5,177,8],[193,1,193,8],[194,1,194,4],[194,5,194,8]]}
[{"$f":"'Initial Settings'!C6","v":"Washington EV - Business Model 3 - Walla Walla"}]
[]
["Sensitivity Tables"]
[]
["Sensitivity Analysis #1"]
[]
[null,{"$f":"'Market Inputs'!$A$30","v":"Expected annual utilization growth rate [%]"}]
[null,"NPV",null,null,null,"Payback"]
[{"$f":"'Market Inputs'!$F$30","v":0.22},{"$f":"'Outputs Dashboard'!$B$4","v":"Project"},{"$f":"'Outputs Dashboard'!$B$10","v":"Owner-Operator"},{"$f":"'Outputs Dashboard'!$B$16","v":"Private Sector Partner(s)"},{"$f":"'Outputs Dashboard'!$B$23","v":"Public Sector Partner"},{"$f":"'Outputs Dashboard'!$B$4","v":"Project"},{"$f":"'Outputs Dashboard'!$B$10","v":"Owner-Operator"},{"$f":"'Outputs Dashboard'!$B$16","v":"Private Sector Partner(s)"},{"$f":"'Outputs Dashboard'!$B$23","v":"Public Sector Partner"}]
[null,{"$f":"'Outputs Dashboard'!$C$6","v":862639.68969753932},{"$f":"'Outputs Dashboard'!$C$12","v":490898.58964395482},{"$f":"'Outputs Dashboard'!$C$19","v":495520.06513186917},{"$f":"'Outputs Dashboard'!$C$26","v":-237499.99999999971},{"$f":"IF('Outputs Dashboard'!$C$8=\"N/A\",#N/A,'Outputs Dashboard'!$C$8)","v":6},{"$f":"IF('Outputs Dashboard'!$C$14=\"N/A\",#N/A,'Outputs Dashboard'!$C$14)","v":5},{"$f":"IF('Outputs Dashboard'!$C$21=\"N/A\",#N/A,'Outputs Dashboard'!$C$21)","v":2},{"$f":"IF('Outputs Dashboard'!$C$28=\"N/A\",#N/A,'Outputs Dashboard'!$C$28)","v":{"$error":"#N/A"}}]
[0,-187568.84133025975,-189704.23870995993,254967.01514696708,-237499.99999999971,{"$error":"#N/A"},{"$error":"#N/A"},2,{"$error":"#N/A"}]
[{"$f":"A13-($A$20-$A$11)/9","v":5.0000000000000072E-2},24058.250005499904,-53470.819702069231,303559.71991208202,-237499.99999999971,10,{"$error":"#N/A"},2,{"$error":"#N/A"}]
[0.10000000000000007,294364.88578931813,119595.12244367314,365435.67046061909,-237499.99999999971,8,8,2,{"$error":"#N/A"}]
[0.15000000000000008,605303.98395431717,319535.26790468715,436039.7156509622,-237499.99999999971,7,6,2,{"$error":"#N/A"}]
[0.20000000000000007,808676.20180905017,454318.32004307059,483004.50974121131,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[0.25000000000000006,941046.48613438173,544089.72958878137,513832.28718630667,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[0.30000000000000004,1029550.6679834751,604617.96597219771,535060.4381056492,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[0.35000000000000003,1095463.0268796927,650276.78488658101,550697.36971008126,-237499.99999999971,5,4,2,{"$error":"#N/A"}]
[0.4,1148206.4655369734,686842.32083852252,563523.87987706601,-237499.99999999971,5,4,2,{"$error":"#N/A"}]
[0.45,1200319.9125728388,723293.11757761519,575894.05024734547,-237499.99999999971,5,4,2,{"$error":"#N/A"}]
[]
["Sensitivity Analysis #2A"]
[]
[null,{"$f":"'Market Inputs'!$A$31","v":"[Station Type 1] Initial average utilization [# of charging sessions per station per year]"}]
[null,"NPV",null,null,null,"Payback"]
[{"$f":"'Market Inputs'!$F$31","v":1200},{"$f":"'Outputs Dashboard'!$B$4","v":"Project"},{"$f":"'Outputs Dashboard'!$B$10","v":"Owner-Operator"},{"$f":"'Outputs Dashboard'!$B$16","v":"Private Sector Partner(s)"},{"$f":"'Outputs Dashboard'!$B$23","v":"Public Sector Partner"},{"$f":"'Outputs Dashboard'!$B$4","v":"Project"},{"$f":"'Outputs Dashboard'!$B$10","v":"Owner-Operator"},{"$f":"'Outputs Dashboard'!$B$16","v":"Private Sector Partner(s)"},{"$f":"'Outputs Dashboard'!$B$23","v":"Public Sector Partner"}]
[null,{"$f":"'Outputs Dashboard'!$C$6","v":862639.68969753932},{"$f":"'Outputs Dashboard'!$C$12","v":490898.58964395482},{"$f":"'Outputs Dashboard'!$C$19","v":495520.06513186917},{"$f":"'Outputs Dashboard'!$C$26","v":-237499.99999999971},{"$f":"IF('Outputs Dashboard'!$C$8=\"N/A\",#N/A,'Outputs Dashboard'!$C$8)","v":6},{"$f":"IF('Outputs Dashboard'!$C$14=\"N/A\",#N/A,'Outputs Dashboard'!$C$14)","v":5},{"$f":"IF('Outputs Dashboard'!$C$21=\"N/A\",#N/A,'Outputs Dashboard'!$C$21)","v":2},{"$f":"IF('Outputs Dashboard'!$C$28=\"N/A\",#N/A,'Outputs Dashboard'!$C$28)","v":{"$error":"#N/A"}}]
[0,322460.81562997866,5808.3923388513758,495520.06513186917,-236264.54013438322,8,10,2,{"$error":"#N/A"}]
[{"$f":"A30-($A$37-$A$28)/9","v":300},485243.5962132953,150337.14739458432,495520.06513186917,-236573.40510078732,7,8,2,{"$error":"#N/A"}]
[600,648017.15987856954,294857.89702890563,495520.06513186917,-236882.27006719139,7,7,2,{"$error":"#N/A"}]
[900,774784.24657894205,409516.5871705364,495520.06513186917,-237191.13503359561,7,6,2,{"$error":"#N/A"}]
[1200,862639.68969753932,490898.58964395482,495520.06513186917,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[1500,928568.28372403502,552954.5508796213,495520.06513186917,-237808.86496640384,6,5,2,{"$error":"#N/A"}]
[1800,978556.94752455514,600652.78729482216,495520.06513186917,-238117.729932808,6,4,2,{"$error":"#N/A"}]
[2100,1017291.5292403393,638038.97923162114,495520.06513186917,-238426.59489921221,6,4,2,{"$error":"#N/A"}]
[2400,1046803.7592810338,666867.44011879829,495520.06513186917,-238735.45986561634,5,4,2,{"$error":"#N/A"}]
[2700,1066676.6753374124,686575.05823750515,495520.06513186917,-239044.3248320205,5,3,2,{"$error":"#N/A"}]
[]
["Sensitivity Analysis #2B"]
[]
[null,{"$f":"'Market Inputs'!$A$33","v":"[Station Type 2] Initial average utilization [# of charging sessions per station per year]"}]
[null,"NPV",null,null,null,"Payback"]
[{"$f":"'Market Inputs'!$F$33","v":400},{"$f":"'Outputs Dashboard'!$B$4","v":"Project"},{"$f":"'Outputs Dashboard'!$B$10","v":"Owner-Operator"},{"$f":"'Outputs Dashboard'!$B$16","v":"Private Sector Partner(s)"},{"$f":"'Outputs Dashboard'!$B$23","v":"Public Sector Partner"},{"$f":"'Outputs Dashboard'!$B$4","v":"Project"},{"$f":"'Outputs Dashboard'!$B$10","v":"Owner-Operator"},{"$f":"'Outputs Dashboard'!$B$16","v":"Private Sector Partner(s)"},{"$f":"'Outputs Dashboard'!$B$23","v":"Public Sector Partner"}]
[null,{"$f":"'Outputs Dashboard'!$C$6","v":862639.68969753932},{"$f":"'Outputs Dashboard'!$C$12","v":490898.58964395482},{"$f":"'Outputs Dashboard'!$C$19","v":495520.06513186917},{"$f":"'Outputs Dashboard'!$C$26","v":-237499.99999999971},{"$f":"IF('Outputs Dashboard'!$C$8=\"N/A\",#N/A,'Outputs Dashboard'!$C$8)","v":6},{"$f":"IF('Outputs Dashboard'!$C$14=\"N/A\",#N/A,'Outputs Dashboard'!$C$14)","v":5},{"$f":"IF('Outputs Dashboard'!$C$21=\"N/A\",#N/A,'Outputs Dashboard'!$C$21)","v":2},{"$f":"IF('Outputs Dashboard'!$C$28=\"N/A\",#N/A,'Outputs Dashboard'!$C$28)","v":{"$error":"#N/A"}}]
[0,-357312.98712963908,-178889.89426101357,73810.985695237003,-235784.08351997653,{"$error":"#N/A"},{"$error":"#N/A"},4,{"$error":"#N/A"}]
[{"$f":"A47-($A$54-$A$45)/9","v":300},666709.96665543178,379670.19207394571,425793.4229282923,-237071.02087999383,7,6,2,{"$error":"#N/A"}]
[600,1121704.8625202482,640651.19395417918,590113.78681320639,-238357.95824001136,5,4,1,{"$error":"#N/A"}]
[900,1318769.6002167016,756711.83413242572,664987.14740143844,-239644.89560002857,4,3,1,{"$error":"#N/A"}]
[1200,1393157.3105990819,800777.14120801038,695399.73673010361,-240931.83296004587,4,3,1,{"$error":"#N/A"}]
[1500,1393157.3105990819,800777.14120801038,695399.73673010361,-240931.83296004587,4,3,1,{"$error":"#N/A"}]
[1800,1393157.3105990819,800777.14120801038,695399.73673010361,-240931.83296004587,4,3,1,{"$error":"#N/A"}]
[2100,1393157.3105990819,800777.14120801038,695399.73673010361,-240931.83296004587,4,3,1,{"$error":"#N/A"}]
[{"$f":"A54-($A$54-$A$45)/9","v":2400},1393157.3105990819,800777.14120801038,695399.73673010361,-240931.83296004587,4,3,1,{"$error":"#N/A"}]
[2700,1393157.3105990819,800777.14120801038,695399.73673010361,-240931.83296004587,4,3,1,{"$error":"#N/A"}]
[]
["Sensitivity Analysis #2C"]
[]
[null,{"$f":"'Market Inputs'!$A$35","v":"[Station Type 3] Initial average utilization [# of charging sessions per station per year]"}]
[null,"NPV",null,null,null,"Payback"]
[{"$f":"'Market Inputs'!$F$35","v":1200},{"$f":"'Outputs Dashboard'!$B$4","v":"Project"},{"$f":"'Outputs Dashboard'!$B$10","v":"Owner-Operator"},{"$f":"'Outputs Dashboard'!$B$16","v":"Private Sector Partner(s)"},{"$f":"'Outputs Dashboard'!$B$23","v":"Public Sector Partner"},{"$f":"'Outputs Dashboard'!$B$4","v":"Project"},{"$f":"'Outputs Dashboard'!$B$10","v":"Owner-Operator"},{"$f":"'Outputs Dashboard'!$B$16","v":"Private Sector Partner(s)"},{"$f":"'Outputs Dashboard'!$B$23","v":"Public Sector Partner"}]
[null,{"$f":"'Outputs Dashboard'!$C$6","v":862639.68969753932},{"$f":"'Outputs Dashboard'!$C$12","v":490898.58964395482},{"$f":"'Outputs Dashboard'!$C$19","v":495520.06513186917},{"$f":"'Outputs Dashboard'!$C$26","v":-237499.99999999971},{"$f":"IF('Outputs Dashboard'!$C$8=\"N/A\",#N/A,'Outputs Dashboard'!$C$8)","v":6},{"$f":"IF('Outputs Dashboard'!$C$14=\"N/A\",#N/A,'Outputs Dashboard'!$C$14)","v":5},{"$f":"IF('Outputs Dashboard'!$C$21=\"N/A\",#N/A,'Outputs Dashboard'!$C$21)","v":2},{"$f":"IF('Outputs Dashboard'!$C$28=\"N/A\",#N/A,'Outputs Dashboard'!$C$28)","v":{"$error":"#N/A"}}]
[0,616400.9238579669,321257.48132907425,444616.29419724923,-237088.18004479428,7,6,2,{"$error":"#N/A"}]
[{"$f":"A64-($A$71-$A$62)/9","v":300},690687.87410915457,371805.01754814031,459850.58489891619,-237191.13503359561,7,6,2,{"$error":"#N/A"}]
[600,764981.82076913095,422357.73889026319,475086.33786515059,-237294.09002239697,7,6,2,{"$error":"#N/A"}]
[900,822627.55579312611,462438.35398481303,487015.804088893,-237397.04501119847,6,5,2,{"$error":"#N/A"}]
[1200,862639.68969753932,490898.58964395482,495520.06513186917,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[1500,892689.87331050588,512587.96691574715,502031.86738823843,-237602.95498880115,6,5,2,{"$error":"#N/A"}]
[1800,915534.18534972286,529271.95818133524,507070.1127282409,-237705.90997760239,6,5,2,{"$error":"#N/A"}]
[2100,933273.22547374538,542348.09642536112,511045.87028486701,-237808.86496640384,6,5,2,{"$error":"#N/A"}]
[{"$f":"A71-($A$71-$A$62)/9","v":2400},946835.63729904068,552434.99581143376,514141.10053533223,-237911.81995520543,6,5,2,{"$error":"#N/A"}]
[2700,956035.00365612144,559337.47270141053,516297.94937352242,-238014.77494400658,6,5,2,{"$error":"#N/A"}]
[]
["Sensitivity Analysis #7"]
[]
[null,{"$f":"'Owner-Operator Inputs'!$A$250","v":"Owner Operator Cost of Debt (Long Term)"}]
[null,"NPV",null,null,null,"Payback"]
[{"$f":"'Owner-Operator Inputs'!$E$250","v":0.08},{"$f":"'Outputs Dashboard'!$B$4","v":"Project"},{"$f":"'Outputs Dashboard'!$B$10","v":"Owner-Operator"},{"$f":"'Outputs Dashboard'!$B$16","v":"Private Sector Partner(s)"},{"$f":"'Outputs Dashboard'!$B$23","v":"Public Sector Partner"},{"$f":"'Outputs Dashboard'!$B$4","v":"Project"},{"$f":"'Outputs Dashboard'!$B$10","v":"Owner-Operator"},{"$f":"'Outputs Dashboard'!$B$16","v":"Private Sector Partner(s)"},{"$f":"'Outputs Dashboard'!$B$23","v":"Public Sector Partner"}]
[null,{"$f":"'Outputs Dashboard'!$C$6","v":862639.68969753932},{"$f":"'Outputs Dashboard'!$C$12","v":490898.58964395482},{"$f":"'Outputs Dashboard'!$C$19","v":495520.06513186917},{"$f":"'Outputs Dashboard'!$C$26","v":-237499.99999999971},{"$f":"IF('Outputs Dashboard'!$C$8=\"N/A\",#N/A,'Outputs Dashboard'!$C$8)","v":6},{"$f":"IF('Outputs Dashboard'!$C$14=\"N/A\",#N/A,'Outputs Dashboard'!$C$14)","v":5},{"$f":"IF('Outputs Dashboard'!$C$21=\"N/A\",#N/A,'Outputs Dashboard'!$C$21)","v":2},{"$f":"IF('Outputs Dashboard'!$C$28=\"N/A\",#N/A,'Outputs Dashboard'!$C$28)","v":{"$error":"#N/A"}}]
[0,1221060.2841959125,570791.28512973071,495520.06513186917,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[{"$f":"A81-($A$88-$A$79)/9","v":1.9999999999999993E-2},1126602.2332448259,552482.35532900796,495520.06513186917,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[3.9999999999999994E-2,1035456.4936801295,533035.70518284384,495520.06513186917,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[0.06,947505.26892500208,512492.3180322703,495520.06513186917,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[0.08,862639.68969753932,490898.58964395482,495520.06513186917,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[0.1,780758.02076416591,468305.04199040629,495520.06513186917,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[0.12000000000000001,701764.1494764915,444765.09683423262,495520.06513186917,-237499.99999999971,7,6,2,{"$error":"#N/A"}]
[0.14000000000000001,625566.34660742269,420333.94392816449,495520.06513186917,-237499.99999999971,7,6,2,{"$error":"#N/A"}]
[{"$f":"A88-($A$88-$A$79)/9","v":0.16},552076.28065114724,395067.52783395816,495520.06513186917,-237499.99999999971,7,6,2,{"$error":"#N/A"}]
[0.18,481208.26027798408,369021.66737430257,495520.06513186917,-237499.99999999971,7,6,2,{"$error":"#N/A"}]
[]
["Sensitivity Analysis #8A"]
[]
[null,{"$f":"'Private Sector Partner Inputs'!$A$38","v":"Estimated NPV of lifetime after-tax profit per station - type 1 station [$]"}]
[null,"NPV",null,null,null,"Payback"]
[{"$f":"'Private Sector Partner Inputs'!$E$38","v":10694},{"$f":"'Outputs Dashboard'!$B$4","v":"Project"},{"$f":"'Outputs Dashboard'!$B$10","v":"Owner-Operator"},{"$f":"'Outputs Dashboard'!$B$16","v":"Private Sector Partner(s)"},{"$f":"'Outputs Dashboard'!$B$23","v":"Public Sector Partner"},{"$f":"'Outputs Dashboard'!$B$4","v":"Project"},{"$f":"'Outputs Dashboard'!$B$10","v":"Owner-Operator"},{"$f":"'Outputs Dashboard'!$B$16","v":"Private Sector Partner(s)"},{"$f":"'Outputs Dashboard'!$B$23","v":"Public Sector Partner"}]
[null,{"$f":"'Outputs Dashboard'!$C$6","v":862639.68969753932},{"$f":"'Outputs Dashboard'!$C$12","v":490898.58964395482},{"$f":"'Outputs Dashboard'!$C$19","v":495520.06513186917},{"$f":"'Outputs Dashboard'!$C$26","v":-237499.99999999971},{"$f":"IF('Outputs Dashboard'!$C$8=\"N/A\",#N/A,'Outputs Dashboard'!$C$8)","v":6},{"$f":"IF('Outputs Dashboard'!$C$14=\"N/A\",#N/A,'Outputs Dashboard'!$C$14)","v":5},{"$f":"IF('Outputs Dashboard'!$C$21=\"N/A\",#N/A,'Outputs Dashboard'!$C$21)","v":2},{"$f":"IF('Outputs Dashboard'!$C$28=\"N/A\",#N/A,'Outputs Dashboard'!$C$28)","v":{"$error":"#N/A"}}]
[0,804208.69072500686,490898.58964395482,442477.82513186906,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[{"$f":"A98-($A$105-$A$96)/9","v":2000},815136.50051975786,490898.58964395482,452397.82513186941,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[4000,826064.3103145085,490898.58964395482,462317.82513186923,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[6000,836992.12010925927,490898.58964395482,472237.82513186912,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[8000,847919.9299040098,490898.58964395482,482157.82513186894,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[10000,858847.73969876114,490898.58964395482,492077.82513186935,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[12000,869775.54949351167,490898.58964395482,501997.82513186929,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[14000,880703.3592882622,490898.58964395482,511917.82513186918,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[{"$f":"A105-($A$105-$A$96)/9","v":16000},891631.16908301308,490898.58964395482,521837.82513186906,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[18000,902558.97887776443,490898.58964395482,531757.82513186953,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[]
["Sensitivity Analysis #8B"]
[]
[null,{"$f":"'Private Sector Partner Inputs'!$A$41","v":"Estimated NPV of lifetime after-tax profit per station - type 2 station [$]"}]
[null,"NPV",null,null,null,"Payback"]
[{"$f":"'Private Sector Partner Inputs'!$E$41","v":500},{"$f":"'Outputs Dashboard'!$B$4","v":"Project"},{"$f":"'Outputs Dashboard'!$B$10","v":"Owner-Operator"},{"$f":"'Outputs Dashboard'!$B$16","v":"Private Sector Partner(s)"},{"$f":"'Outputs Dashboard'!$B$23","v":"Public Sector Partner"},{"$f":"'Outputs Dashboard'!$B$4","v":"Project"},{"$f":"'Outputs Dashboard'!$B$10","v":"Owner-Operator"},{"$f":"'Outputs Dashboard'!$B$16","v":"Private Sector Partner(s)"},{"$f":"'Outputs Dashboard'!$B$23","v":"Public Sector Partner"}]
[null,{"$f":"'Outputs Dashboard'!$C$6","v":862639.68969753932},{"$f":"'Outputs Dashboard'!$C$12","v":490898.58964395482},{"$f":"'Outputs Dashboard'!$C$19","v":495520.06513186917},{"$f":"'Outputs Dashboard'!$C$26","v":-237499.99999999971},{"$f":"IF('Outputs Dashboard'!$C$8=\"N/A\",#N/A,'Outputs Dashboard'!$C$8)","v":6},{"$f":"IF('Outputs Dashboard'!$C$14=\"N/A\",#N/A,'Outputs Dashboard'!$C$14)","v":5},{"$f":"IF('Outputs Dashboard'!$C$21=\"N/A\",#N/A,'Outputs Dashboard'!$C$21)","v":2},{"$f":"IF('Outputs Dashboard'!$C$28=\"N/A\",#N/A,'Outputs Dashboard'!$C$28)","v":{"$error":"#N/A"}}]
[0,845564.98689324129,490898.58964395482,480020.06513186911,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[{"$f":"A115-($A$122-$A$113)/9","v":222.22222222222251},853153.74369515153,490898.58964395482,486908.95402075798,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[444.44444444444474,860742.50049706188,490898.58964395482,493797.84290964709,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[666.66666666666697,868331.25729897199,490898.58964395482,500686.73179853574,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[888.88888888888914,875920.01410088246,490898.58964395482,507575.62068742479,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[1111.1111111111113,883508.77090279269,490898.58964395482,514464.50957631372,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[1333.3333333333335,891097.52770470269,490898.58964395482,521353.39846520236,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[1555.5555555555557,898686.28450661339,490898.58964395482,528242.28735409153,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[{"$f":"A122-($A$122-$A$113)/9","v":1777.7777777777778},906275.04130852339,490898.58964395482,535131.17624298041,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[2000,913863.79811043327,490898.58964395482,542020.06513186905,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[]
["Sensitivity Analysis #8C"]
[]
[null,{"$f":"'Private Sector Partner Inputs'!$A$44","v":"Estimated NPV of lifetime after-tax profit per station - type 3 station [$]"}]
[null,"NPV",null,null,null,"Payback"]
[{"$f":"'Private Sector Partner Inputs'!$E$44","v":10694},{"$f":"'Outputs Dashboard'!$B$4","v":"Project"},{"$f":"'Outputs Dashboard'!$B$10","v":"Owner-Operator"},{"$f":"'Outputs Dashboard'!$B$16","v":"Private Sector Partner(s)"},{"$f":"'Outputs Dashboard'!$B$23","v":"Public Sector Partner"},{"$f":"'Outputs Dashboard'!$B$4","v":"Project"},{"$f":"'Outputs Dashboard'!$B$10","v":"Owner-Operator"},{"$f":"'Outputs Dashboard'!$B$16","v":"Private Sector Partner(s)"},{"$f":"'Outputs Dashboard'!$B$23","v":"Public Sector Partner"}]
[null,{"$f":"'Outputs Dashboard'!$C$6","v":862639.68969753932},{"$f":"'Outputs Dashboard'!$C$12","v":490898.58964395482},{"$f":"'Outputs Dashboard'!$C$19","v":495520.06513186917},{"$f":"'Outputs Dashboard'!$C$26","v":-237499.99999999971},{"$f":"IF('Outputs Dashboard'!$C$8=\"N/A\",#N/A,'Outputs Dashboard'!$C$8)","v":6},{"$f":"IF('Outputs Dashboard'!$C$14=\"N/A\",#N/A,'Outputs Dashboard'!$C$14)","v":5},{"$f":"IF('Outputs Dashboard'!$C$21=\"N/A\",#N/A,'Outputs Dashboard'!$C$21)","v":2},{"$f":"IF('Outputs Dashboard'!$C$28=\"N/A\",#N/A,'Outputs Dashboard'!$C$28)","v":{"$error":"#N/A"}}]
[0,848031.93995440635,490898.58964395482,482259.50513186929,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[{"$f":"A132-($A$139-$A$130)/9","v":2000},850763.89240309398,490898.58964395482,484739.50513186911,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[4000,853495.84485178173,490898.58964395482,487219.50513186929,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[6000,856227.79730046913,490898.58964395482,489699.50513186911,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[8000,858959.74974915711,490898.58964395482,492179.50513186911,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[10000,861691.70219784509,490898.58964395482,494659.5051318694,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[12000,864423.65464653238,490898.58964395482,497139.50513186923,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[14000,867155.60709522036,490898.58964395482,499619.5051318694,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[{"$f":"A139-($A$139-$A$130)/9","v":16000},869887.55954390788,490898.58964395482,502099.50513186911,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[18000,872619.51199259551,490898.58964395482,504579.50513186929,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[]
["Sensitivity Analysis #4"]
[]
[null,{"$f":"'Private Sector Partner Inputs'!$A$54","v":"Annual customer revenue sharing agreement (from sales) [% of revenue]"}]
[null,"NPV",null,null,null,"Payback"]
[{"$f":"'Private Sector Partner Inputs'!$E$54","v":0.1},{"$f":"'Outputs Dashboard'!$B$4","v":"Project"},{"$f":"'Outputs Dashboard'!$B$10","v":"Owner-Operator"},{"$f":"'Outputs Dashboard'!$B$16","v":"Private Sector Partner(s)"},{"$f":"'Outputs Dashboard'!$B$23","v":"Public Sector Partner"},{"$f":"'Outputs Dashboard'!$B$4","v":"Project"},{"$f":"'Outputs Dashboard'!$B$10","v":"Owner-Operator"},{"$f":"'Outputs Dashboard'!$B$16","v":"Private Sector Partner(s)"},{"$f":"'Outputs Dashboard'!$B$23","v":"Public Sector Partner"}]
[null,{"$f":"'Outputs Dashboard'!$C$6","v":862639.68969753932},{"$f":"'Outputs Dashboard'!$C$12","v":490898.58964395482},{"$f":"'Outputs Dashboard'!$C$19","v":495520.06513186917},{"$f":"'Outputs Dashboard'!$C$26","v":-237499.99999999971},{"$f":"IF('Outputs Dashboard'!$C$8=\"N/A\",#N/A,'Outputs Dashboard'!$C$8)","v":6},{"$f":"IF('Outputs Dashboard'!$C$14=\"N/A\",#N/A,'Outputs Dashboard'!$C$14)","v":5},{"$f":"IF('Outputs Dashboard'!$C$21=\"N/A\",#N/A,'Outputs Dashboard'!$C$21)","v":2},{"$f":"IF('Outputs Dashboard'!$C$28=\"N/A\",#N/A,'Outputs Dashboard'!$C$28)","v":{"$error":"#N/A"}}]
[0,893770.0144708642,41813.57520782794,968132.91550312156,-236539.0867711867,6,9,1,{"$error":"#N/A"}]
[{"$f":"A149-($A$156-$A$147)/9","v":5.0000000000000072E-2},878204.85208420176,266356.08242589171,731826.49031749484,-237019.54338559322,6,6,1,{"$error":"#N/A"}]
[0.10000000000000007,862639.68969753897,490898.58964395517,495520.06513186864,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[0.15000000000000008,847074.52731087664,715441.09686201881,259213.63994624245,-237980.45661440617,6,4,2,{"$error":"#N/A"}]
[0.20000000000000007,831509.3649242142,939983.60408008192,22907.214760616273,-238460.91322881263,6,4,7,{"$error":"#N/A"}]
[0.25000000000000006,815944.20253755176,1164526.1112981455,-213399.21042500978,-238941.36984321923,6,3,{"$error":"#N/A"},{"$error":"#N/A"}]
[0.30000000000000004,800379.04015088943,1389068.6185162084,-449705.63561063563,-239421.82645762558,6,3,{"$error":"#N/A"},{"$error":"#N/A"}]
[0.35000000000000003,784813.87776422687,1613611.1257342724,-686012.06079626188,-239902.28307203198,6,3,{"$error":"#N/A"},{"$error":"#N/A"}]
[0.4,769248.71537756431,1838153.6329523351,-922318.4859818879,-240382.73968643855,6,2,{"$error":"#N/A"},{"$error":"#N/A"}]
[0.45,753683.55299090198,2062696.1401703986,-1158624.911167514,-240863.19630084495,6,2,{"$error":"#N/A"},{"$error":"#N/A"}]
[]
["Sensitivity Analysis #5"]
[]
[null,{"$f":"'Private Sector Partner Inputs'!$A$17","v":"Average expected revenue per customer per minute ($)"}]
[null,"NPV",null,null,null,"Payback"]
[{"$f":"'Private Sector Partner Inputs'!$E$17","v":1},{"$f":"'Outputs Dashboard'!$B$4","v":"Project"},{"$f":"'Outputs Dashboard'!$B$10","v":"Owner-Operator"},{"$f":"'Outputs Dashboard'!$B$16","v":"Private Sector Partner(s)"},{"$f":"'Outputs Dashboard'!$B$23","v":"Public Sector Partner"},{"$f":"'Outputs Dashboard'!$B$4","v":"Project"},{"$f":"'Outputs Dashboard'!$B$10","v":"Owner-Operator"},{"$f":"'Outputs Dashboard'!$B$16","v":"Private Sector Partner(s)"},{"$f":"'Outputs Dashboard'!$B$23","v":"Public Sector Partner"}]
[null,{"$f":"'Outputs Dashboard'!$C$6","v":862639.68969753932},{"$f":"'Outputs Dashboard'!$C$12","v":490898.58964395482},{"$f":"'Outputs Dashboard'!$C$19","v":495520.06513186917},{"$f":"'Outputs Dashboard'!$C$26","v":-237499.99999999971},{"$f":"IF('Outputs Dashboard'!$C$8=\"N/A\",#N/A,'Outputs Dashboard'!$C$8)","v":6},{"$f":"IF('Outputs Dashboard'!$C$14=\"N/A\",#N/A,'Outputs Dashboard'!$C$14)","v":5},{"$f":"IF('Outputs Dashboard'!$C$21=\"N/A\",#N/A,'Outputs Dashboard'!$C$21)","v":2},{"$f":"IF('Outputs Dashboard'!$C$28=\"N/A\",#N/A,'Outputs Dashboard'!$C$28)","v":{"$error":"#N/A"}}]
[0,-169454.80599222,41813.57520782794,22907.214760616997,-236539.0867711867,{"$error":"#N/A"},9,7,{"$error":"#N/A"}]
[{"$f":"A166-($A$173-$A$164)/9","v":0.22222222222222188},596916.80425515876,375284.54300141754,373848.81722582085,-237252.90802687634,7,6,2,{"$error":"#N/A"}]
[0.44444444444444409,810748.70168116549,468326.17635805754,471764.97202904662,-237451.9543385591,6,5,2,{"$error":"#N/A"}]
[0.6666666666666663,840400.69483337912,481224.69823571306,485339.3109449452,-237479.40900223952,6,5,2,{"$error":"#N/A"}]
[0.88888888888888851,862639.68969753932,490898.58964395482,495520.06513186917,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[1.1111111111111107,862639.68969753932,490898.58964395482,495520.06513186917,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[1.333333333333333,862639.68969753932,490898.58964395482,495520.06513186917,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[1.5555555555555554,862639.68969753932,490898.58964395482,495520.06513186917,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[1.7777777777777777,862639.68969753932,490898.58964395482,495520.06513186917,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[2,862639.68969753932,490898.58964395482,495520.06513186917,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[]
["Sensitivity Analysis #6A"]
[]
[null,{"$f":"'Private Sector Partner Inputs'!$A$20","v":"Maximum retail revenue per customer per session for type 1 stations ($)"}]
[null,"NPV",null,null,null,"Payback"]
[{"$f":"'Private Sector Partner Inputs'!$E$20","v":20},{"$f":"'Outputs Dashboard'!$B$4","v":"Project"},{"$f":"'Outputs Dashboard'!$B$10","v":"Owner-Operator"},{"$f":"'Outputs Dashboard'!$B$16","v":"Private Sector Partner(s)"},{"$f":"'Outputs Dashboard'!$B$23","v":"Public Sector Partner"},{"$f":"'Outputs Dashboard'!$B$4","v":"Project"},{"$f":"'Outputs Dashboard'!$B$10","v":"Owner-Operator"},{"$f":"'Outputs Dashboard'!$B$16","v":"Private Sector Partner(s)"},{"$f":"'Outputs Dashboard'!$B$23","v":"Public Sector Partner"}]
[null,{"$f":"'Outputs Dashboard'!$C$6","v":862639.68969753932},{"$f":"'Outputs Dashboard'!$C$12","v":490898.58964395482},{"$f":"'Outputs Dashboard'!$C$19","v":495520.06513186917},{"$f":"'Outputs Dashboard'!$C$26","v":-237499.99999999971},{"$f":"IF('Outputs Dashboard'!$C$8=\"N/A\",#N/A,'Outputs Dashboard'!$C$8)","v":6},{"$f":"IF('Outputs Dashboard'!$C$14=\"N/A\",#N/A,'Outputs Dashboard'!$C$14)","v":5},{"$f":"IF('Outputs Dashboard'!$C$21=\"N/A\",#N/A,'Outputs Dashboard'!$C$21)","v":2},{"$f":"IF('Outputs Dashboard'!$C$28=\"N/A\",#N/A,'Outputs Dashboard'!$C$28)","v":{"$error":"#N/A"}}]
[0,862639.68969753932,490898.58964395482,495520.06513186917,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[{"$f":"A183-($A$190-$A$181)/9","v":11.111111111111093},862639.68969753932,490898.58964395482,495520.06513186917,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[22.222222222222204,862639.68969753932,490898.58964395482,495520.06513186917,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[33.333333333333314,862639.68969753932,490898.58964395482,495520.06513186917,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[44.444444444444429,862639.68969753932,490898.58964395482,495520.06513186917,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[55.555555555555543,862639.68969753932,490898.58964395482,495520.06513186917,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[66.666666666666657,862639.68969753932,490898.58964395482,495520.06513186917,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[77.777777777777771,862639.68969753932,490898.58964395482,495520.06513186917,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[{"$f":"A190-($A$190-$A$181)/9","v":88.888888888888886},862639.68969753932,490898.58964395482,495520.06513186917,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[100,862639.68969753932,490898.58964395482,495520.06513186917,-237499.99999999971,6,5,2,{"$error":"#N/A"}]
[]
["Sensitivity Analysis #6B"]
[]
[null,{"$f":"'Private Sector Partner Inputs'!$A$26","v":"Maximum retail revenue per customer per session for type 2 stations ($)"}]
[null,"NPV",null,null,null,"Payback"]
[{"$f":"'Private Sector Partner Inputs'!$E$26","v":25},{"$f":"'Outputs Dashboard'!$B$4","v":"Project"},{"$f":"'Outputs Dashboard'!$B$10","v":"Owner-Operator"},{"$f":"'Outputs Dashboard'!$B$16","v":"Private Sector Partner(s)"},{"$f":"'Outputs Dashboard'!$B$23","v":"Public Sector Partner"},{"$f":"'Outputs Dashboard'!$B$4","v":"Project"},{"$f":"'Outputs Dashboard'!$B$10","v":"Owner-Operator"},{"$f":"'Outputs Dashboard'!$B$16","v":"Private Sector Partner(s)"},{"$f":"'Outputs Dashboard'!$B$23","v":"Public Sector Partner"}]
[null,{"$f":"'Outputs Dashboard'!$C$6","v":862639.68969753932},{"$f":"'Outputs Dashboard'!$C$12","v":490898.58964395482},{"$f":"'Outputs Dashboard'!$C$19","v":495520.06513186917},{"$f":"'Outputs Dashboard'!$C$26","v":-237499.99999999971},{"$f":"IF('Outputs Dashboard'!$C$8=\"N/A\",#N/A,'Outputs Dashboard'!$C$8)","v":6},{"$f":"IF('Outputs Dashboard'!$C$14=\"N/A\",#N/A,'Outputs Dashboard'!$C$14)","v":5},{"$f":"IF('Outputs Dashboard'!$C$21=\"N/A\",#N/A,'Outputs Dashboard'!$C$21)","v":2},{"$f":"IF('Outputs Dashboard'!$C$28=\"N/A\",#N/A,'Outputs Dashboard'!$C$28)","v":{"$error":"#N/A"}}]
[0,-58259.831671418149,90183.032249036827,73810.985695237003,-236642.04175998823,{"$error":"#N/A"},8,4,{"$error":"#N/A"}]
[{"$f":"A200-($A$207-$A$198)/9","v":11.111111111111093},351028.84449256241,268278.83553566667,261237.24322262889,-237023.35653332659,8,6,2,{"$error":"#N/A"}]
[22.222222222222204,760317.52065654355,446374.63882229698,448663.5007500209,-237404.67130666511,6,5,2,{"$error":"#N/A"}]
[33.333333333333314,1169606.1968205245,624470.44210892718,636089.75827741309,-237785.98608000367,6,5,2,{"$error":"#N/A"}]
[44.444444444444429,1578894.8729845053,802566.24539555726,823516.01580480475,-238167.30085334225,5,4,1,{"$error":"#N/A"}]
[55.555555555555543,1988183.5491484874,980662.04868218792,1010942.2733321971,-238548.61562668061,5,4,1,{"$error":"#N/A"}]
[66.666666666666657,2397472.2253124686,1158757.8519688183,1198368.5308595896,-238929.93040001887,4,3,1,{"$error":"#N/A"}]
[77.777777777777771,2806760.9014764493,1336853.6552554485,1385794.788386981,-239311.2451733574,4,3,1,{"$error":"#N/A"}]
[{"$f":"A207-($A$207-$A$198)/9","v":88.888888888888886},3216049.5776404315,1514949.458542079,1573221.0459143738,-239692.55994669587,4,3,1,{"$error":"#N/A"}]
[100,3256978.4452568302,1532759.0388707414,1591963.6716671134,-239730.69142402982,3,3,1,{"$error":"#N/A"}]
[]
["Sensitivity Analysis #6C"]
[]
[null,{"$f":"'Private Sector Partner Inputs'!$A$32","v":"Maximum retail revenue per customer per session for type 3 stations ($)"}]
[null,"NPV",null,null,null,"Payback"]
[{"$f":"'Private Sector Partner Inputs'!$E$32","v":25},{"$f":"'Outputs Dashboard'!$B$4","v":"Project"},{"$f":"'Outputs Dashboard'!$B$10","v":"Owner-Operator"},{"$f":"'Outputs Dashboard'!$B$16","v":"Private Sector Partner(s)"},{"$f":"'Outputs Dashboard'!$B$23","v":"Public Sector Partner"},{"$f":"'Outputs Dashboard'!$B$4","v":"Project"},{"$f":"'Outputs Dashboard'!$B$10","v":"Owner-Operator"},{"$f":"'Outputs Dashboard'!$B$16","v":"Private Sector Partner(s)"},{"$f":"'Outputs Dashboard'!$B$23","v":"Public Sector Partner"}]
[null,{"$f":"'Outputs Dashboard'!$C$6","v":862639.68969753932},{"$f":"'Outputs Dashboard'!$C$12","v":490898.58964395482},{"$f":"'Outputs Dashboard'!$C$19","v":495520.06513186917},{"$f":"'Outputs Dashboard'!$C$26","v":-237499.99999999971},{"$f":"IF('Outputs Dashboard'!$C$8=\"N/A\",#N/A,'Outputs Dashboard'!$C$8)","v":6},{"$f":"IF('Outputs Dashboard'!$C$14=\"N/A\",#N/A,'Outputs Dashboard'!$C$14)","v":5},{"$f":"IF('Outputs Dashboard'!$C$21=\"N/A\",#N/A,'Outputs Dashboard'!$C$21)","v":2},{"$f":"IF('Outputs Dashboard'!$C$28=\"N/A\",#N/A,'Outputs Dashboard'!$C$28)","v":{"$error":"#N/A"}}]
[0,751444.71537673776,442529.13260274613,444616.29419724923,-237397.04501119847,6,5,2,{"$error":"#N/A"}]
[{"$f":"A217-($A$224-$A$215)/9","v":11.111111111111093},800864.70396376075,464026.66906550532,467240.19239041378,-237442.8027839991,6,5,2,{"$error":"#N/A"}]
[22.222222222222204,850284.69255078351,485524.20552826487,489864.09058357787,-237488.56055679958,6,5,2,{"$error":"#N/A"}]
[33.333333333333314,884878.68456169963,500572.48105219647,505700.81931879313,-237520.59099775995,6,5,2,{"$error":"#N/A"}]
[44.444444444444429,884878.68456169963,500572.48105219647,505700.81931879313,-237520.59099775995,6,5,2,{"$error":"#N/A"}]
[55.555555555555543,884878.68456169963,500572.48105219647,505700.81931879313,-237520.59099775995,6,5,2,{"$error":"#N/A"}]
[66.666666666666657,884878.68456169963,500572.48105219647,505700.81931879313,-237520.59099775995,6,5,2,{"$error":"#N/A"}]
[77.777777777777771,884878.68456169963,500572.48105219647,505700.81931879313,-237520.59099775995,6,5,2,{"$error":"#N/A"}]
[{"$f":"A224-($A$224-$A$215)/9","v":88.888888888888886},884878.68456169963,500572.48105219647,505700.81931879313,-237520.59099775995,6,5,2,{"$error":"#N/A"}]
[100,884878.68456169963,500572.48105219647,505700.81931879313,-237520.59099775995,6,5,2,{"$error":"#N/A"}]

{"sheet":"Lists_Hidden","index":18,"n_rows":7,"n_cols":1,"rows_kept":7,"cut":false,"hidden":true,"merged":[[2,0,2,6]]}
[{"$f":"'Initial Settings'!C6","v":"Washington EV - Business Model 3 - Walla Walla"}]
[]
["Lists"]
[]
["Yes/No List"]
["Y"]
["N"]

{"sheet":"Version","index":19,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Version","Revisions"]
["1.0","First launch"]
["1.1","Added cumulative NPV and new discounted payback calculations (removed old average payback based on IRR)\nFixed #N/As on sensitivity charts\nAdded other contributions to outputs tab"]
["1.5","• Streamlined the sensitivity analysis. Put the tables on a separate tab. Redid table formats\n• Rewired the sensitivity analysis so that it pulls inputs from the input tabs, not the other way around.\n• Major overhaul to more accurately reflect equipment lives other than 10 years. Examples:\no Owner operator income streams now stop if equipment depreciates faster than 10 years\no Terminal value function has been redone to consider equipment value if there is remaining equipment life at the end of the 10-year DCF\n• Consolidated some variables like equipment life, revenue per hour, etc. so that one variable feeds into all three station types. This removes some granularity of control, but makes sensitivity analysis easier.\n• Reversed the flow of the equation on the “Private Sector” tabs to derive revenue from NPV value instead of an NPV value from revenue (as requested by C2ES) \n• Moved sensitivity charts off output tab. Added additional charts.\n"]
["1.6","Revised revenue sharing formulas"]
[null,"Add capped (semi-subordinated) public equity option (functions like a loan that is repaid only if funds are available)\nAdd blended discount rate for the project"]
[1.7,"Add ability to import/export all user inputs. Named each user input cell.\nChange private sector partner summary for charging equipment (allow for individual subsidies by station type).\nAdded \"Report\" tab"]
[1.8,"Added final formatting, spell check, consistent title, label, and unit formats \nDigitally signed macros\nFixed public sector equity cap equation"]
[]
["Future:"]
["Lock non-input cells + add data validation"]
["Consider modeling private sector partner initial subsidy as time \"0\" non-shareholder capital investment, as opposed to year 1 revenue for the owner-operator"]