Financial Models


 

Hello

Please wait while we finish the calculations.




System Optimization


Please provide the model information. Click each of the step headings and fill out the data forms. Click on Run Model once you have entered all the data. By selecting Run Model, you agree to our Terms and Conditions.


1. Model Info

You have no existing model data saved. Pick the model parameters and you can save the model after the results screen.

Input parameters

To increase the number of stations and the maximum length of line, please upgrade to Premium plan.
Number of Stations incl. End Terminals
Number of Support Facilities
Number of Additional Cost Categories
Number of Options to Evaluate
Base Year (i.e., revenues and costs are in US$ of ..)
Operations Start Year
Forecast Horizon years after start of operations
Reserved  

 

Stations Information


Provide the details of the stations including start and end stations.
MM: Millions.

Station Station Name Distance from Start Construction Start Year Construction Time Capex - Civil (MM of 2017 US$) Capex - Infrastructure (MM of 2017 US$) Capex - ROW (MM of 2017 US$) Capex - Systems (MM of 2017 US$) O&M (MM of 2017 US$/year) Renewal Cost (MM of 2017 US$/year) Renewal Frequency (every .. years)
Station 1 KM years years
Station 2 KM years years
Station 3 KM years years
Station 4 KM years years

Station Notes:


Support Facility Information


Provide the details of all the Support Facilities. Include maintenance yards, stabling yards, electrical substations, or any non-station type facility.
MM: Millions.

Facility Facility Name Distance from Start Construction Start Year Construction Time Capex - Civil (Millions of 2017 US$) Capex - Infrastructure (Millions of 2017 US$) Capex - ROW (MM of 2017 US$) Capex - Systems (MM of 2017 US$) O&M (MM of 2017 US$/year) Renewal Cost (MM of 2017 US$/year) Renewal Frequency (every .. years)
Facility 1 KM years years
Facility 2 KM years years

Support Facility Notes:


Line, Opex and Train Costs


Provide the details of the line capex and operating costs, and the costs of the train sets.
MM: Millions.

Line - Capex - Start Year
Line - Capex - Construction Time years
Line - Capex - Civil MM per km (2017 US$)
Line - Capex - ROW MM per km (2017 US$)
Line - Capex - Systems MM per km (2017 US$)
Line - Opex & Maintenance (excl. power) MM per km (2017 US$)
Line - Renewal Cost MM per km (2017 US$)
Line - Renewal Frequency (every .. years) years
   
Train - Capex - Start Year
Train - Capex - Procurement Time years
Capex - A Car train MM (2017 US$)/train set
Capex - B Car train MM (2017 US$)/train set
Capex - C Car train MM (2017 US$)/train set
Capex - D Car train MM (2017 US$)/train set
Capex - E Car train MM (2017 US$)/train set
O&M - A Car train MM (2017 US$)/train set/year
O&M - B Car train MM (2017 US$)/train set/year
O&M - C Car train MM (2017 US$)/train set/year
O&M - D Car train MM (2017 US$)/train set/year
O&M - E Car train MM (2017 US$)/train set/year
Renewal Costs - A Car train MM (2017 US$)/train set/year
Renewal Costs - B Car train MM (2017 US$)/train set/year
Renewal Costs - C Car train MM (2017 US$)/train set/year
Renewal Costs - D Car train MM (2017 US$)/train set/year
Renewal Costs - E Car train MM (2017 US$)/train set/year
Renewal Frequency - A Car train years
Renewal Frequency - B Car train years
Renewal Frequency - C Car train years
Renewal Frequency - D Car train years
Renewal Frequency - E Car train years

Line, Opex and Train Cost Notes:


Power Details


Provide the details of the power consumption.
MM: Millions.

Power Needed by Each A Car train MW
Power Needed by Each B Car train MW
Power Needed by Each C Car train MW
Power Needed by Each D Car train MW
Power Needed by Each E Car train MW
Power Needed by Each Station MW/station
Power Needed by Each Facility MW/facility
Power - Peak Hours/day hours/day
Power - Off Peak Hours/day hours/day
Power - Non Operating Hours/day hours/day
Power - Peak Days days/year
Power - Factor for Off Peak Needs %
Power - Factor for Non Operating Hours %
Power Cost $ per MWh (2017 US$)

Power Usage Notes:

Other Miscellaneous Costs - Not Included Above

Use the table below to specify the different costs for each period that are not included in the recurring costs indicated above.

  • Total costs will be calculated as the sum of cost items (for example, Total Cost = Cost 1 + Cost 2 + Cost 3 + Cost 4 + ... + Cost n.)
  • The table will not self populate. You have put in data for each period otherwise the default values will be used.
  • To change the number of cost items, you can increase or decrease the Categories - Costs in the model parameters above.

Period 2017 2018 2019 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 2031 2032 2033 2034 2035 2036 2037 2038 2039 2040 2041 2042 2043 2044 2045 2046 Inflation

Financial Parameters


Provide the details of the financial parameters.

CPI for Costs % per year
CPI for Revenues % per year
Discount Rate % per year

Traffic and Revenue Details


Provide the details for each of the traffic and revenues.

Year 1 Revenues MM per year (2017 US$)
Revenue Growth % per year
Revenue based on trains/hour/peak direction
Frequency Elasticity

Traffic & Revenue Notes:


Option Details


Provide the details for each of the system options to be evaluated.

Option Stations Served Facilities Included Train Size Peak Frequency Fleet size
trains/hour/peak direction train sets
trains/hour/peak direction train sets
trains/hour/peak direction train sets

Option Notes:


 
  By clicking RUN MODEL, you agree to our Terms and Conditions.

MyFinModel.com - another solution from Rock Creek Analytics.

© 2016-2021 MyFinModel.com