Spreadsheet: danny_mccarty__4661__XTRANSCO - Economics
Sheet: Revenue

 |  | @ | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
Market Size
LT carriers in the US @ industry consolidation effect | Number | 0.05 | 500000 |  |  |  |  |  |  |  |  |  |  | Industry Report (more than) / Consolidation assumption
Class 7 & 8 trucks in the US @ GDP Growth | Units | 0.03 | 4200000 |  |  |  |  |  |  |  |  |  |  | Argonne National Laboratories
Class 8 trucks in the US @ % of class 7 & 8 | Units |  | 2315342 |  |  |  |  |  |  |  |  |  |  | Industry Report
Class 8 trucks w/sleepers in the US @ % of class 8 | Units |  | 1300000 |  |  |  |  |  |  |  |  |  |  | Industry Report
Targeted Market Share of Trucks in the US |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Depreciation Choice |  | Less:  Depreciation (200% DDB)
Class 8 trucks w/sleepers in the US | Units |  | 0.001 | 0.01 | 0.02 | 0.04 | 0.08 | 0.12 |  |  |  |  |  | Team target
Class 8 trucks in the US | Units |  |  |  |  |  |  |  |  |  |  |  |  | Team target
Class 7 & 8 trucks in the US | Units |  |  |  |  |  |  |  |  |  |  |  |  | Team target
Expected Truck & Companies under Contract EOY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Depreciation Choice |  | Less:  Depreciation (200% DDB)
Average class 8 trucks w/sleepers in the US | Units
Growth in number of trucks | Percentage
Average size of carrier @ size depreciation | Units | 0.2 | 5000 |  |  |  |  |  |  |  |  |  |  | Team assumption
New carriers @ EOY | Number |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | Less:  Depreciation (Straight Line)
Cumulative carriers | Number |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | Less:  Depreciation (200% DDB)
Growth in number of carriers | Percentage
Class 8 trucks w/sleepers and reefers @ Mkt share | Units |  |  |  |  |  |  |  |  |  |  |  |  | Team Analysis & DOT
Traffic & Volume
Average working days of TL | Days / Year |  |  |  |  |  |  |  |  |  |  |  |  | Team basic calculations - Argonne National Laboratories 305 days
Mandatory idling per day | Hours / Day |  |  |  |  |  |  |  |  |  |  |  |  | DOT Hours of Service Legislation
Weather factor (anti-idling factor) | Percentage |  |  |  |  |  |  |  |  |  |  |  |  | Team Assumption - Argonne National Laboratories
Idling time per truck | Hours / Year
Idling time per reefer | Hours / Year |  |  |  |  |  |  |  |  |  |  |  |  | No weather effect
Average idling @ Market share | Hours
Anti-idling parking places reserved | Percentage |  | 1e-25 | 0.04
Anti-idling parking places spot | Percentage
Value o Fuel Savings
Fuel cost (diesel) | $ / Gallon |  |  |  |  |  |  |  |  |  |  |  |  | Long-run average @ Team assumption
Heating Oil Index on average current price | Index |  | 1 | 0.956220362471039 | 0.8953511032197995 | 0.8577127947513153 | 0.8379950414654742 | 0.8204074009917072 | 0.8379950414654742 | 0.8130156118052096 | 0.8146855985968863 | 0.8209054197431956 | 0.8310400596956257 | ENE
Truck fuel consumption while idling | Gallons / Hour |  |  |  |  |  |  |  |  |  |  |  |  | Truck manufacturers 1.0 - Argonne National Laboratories 1.2
Reefer fuel consumption while idling | Gallons / Hour |  |  |  |  |  |  |  |  |  |  |  |  | Team Analysis - Equipment manufacturers
Truck Idling cost | $ / Hour
Truck Idling opportunity cost | $ / Year |  |  |  |  |  |  |  |  |  |  |  |  | Considering net hours of idling per year
[NAME] cost | $ / Hour
[NAME] opportunity cost | $ / Year |  |  |  |  |  |  |  |  |  |  |  |  | Considering net hours of idling per year
Weigthed average anti-idling unit opportunity cost | $ / Hour |  |  |  |  |  |  |  |  |  |  |  |  | Considering truck : reefer relationship
Pricing
Reserved price discount (take-or-pay) over spot | Percentage |  | 0.1 |  |  |  |  |  |  |  |  |  |  | Team Analysis
Hourly reserved price | $ / Hour
Hourly spot price | $ / Hour
Other Services Volume & Price
Cable TV | $ / Hour |  | 1 |  |  |  |  |  |  |  |  |  |  | Team assumption
Cable TV take rate | Percentage |  | 0.5 |  |  |  |  |  |  |  |  |  |  | Team assumption
Usage while idling | Hours |  | 2 |  |  |  |  |  |  |  |  |  |  | Team assumption
Cable TV revenues | $
Local telephone services | $ / Access |  | 1 |  |  |  |  |  |  |  |  |  |  | Team assumption
Local telephone service take rate | Percentage |  | 0.4 |  |  |  |  |  |  |  |  |  |  | Team assumption
Local telephone service revenues | $
Long-distance telephone services | $ / Minutes |  | 0.15 |  |  |  |  |  |  |  |  |  |  | Team assumption
Long-distance telephone services take-rate | $ / Minutes |  | 0.4 |  |  |  |  |  |  |  |  |  |  | Team assumption
Usage while idling | Minutes / Event |  | 5 |  |  |  |  |  |  |  |  |  |  | Team assumption
Long distance revenues | $
Internet services | $ / Hour |  | 1 |  |  |  |  |  |  |  |  |  |  | Team assumption
Internet services take rate | % |  | 0.25 |  |  |  |  |  |  |  |  |  |  | Team assumption
Usage while idling | Hours |  | 1 |  |  |  |  |  |  |  |  |  |  | Team assumption
Internet services revenues | $
Revenues
Anti-Idling reserved slots | $
Anti-Idling spot slot | $
Cable TV, telephone & internet access | $
Total revenues | $