XLS vtpi.org

By Todd Litman, Victoria Transport Policy Institute ()16 January 2012These three spreadsheets calculate parking facility costs, cost recovery pricing, and revenue generation. Users can adjust inputs to represent various conditions and assumptions. The three spreadsheets are described below.Costs: This spreadsheet calculates the total costs of constructing and operating a parking facility. Default values are in 2002 U.S. dollars.Pricing: This spreadsheet calculates the prices that need to be charged to recover parking facility costs and provide basic profits.Revenue: This spreadsheet calculates revenues and profits from various parking facility costs and prices.Use the tabs at the bottom to select the spreadsheet you want to use. Change the input values to reflect the specific situation you want to evaluate. The spreadsheet will automatically calculate results. These spreadsheets are linked, so data from some cells in one spreadsheet are used to calculate results in another spreadsheet.Note: Highlighted text indicates input values. These are the cells that you should change when performing analysis. Do not change other cells unless you want to make structural changes to the model.If you have questions or comments about this spreadsheet please contact:

Todd Litman, Director

Victoria Transport Policy Institute

1250 Rudlin Street

Victoria, BC, V8V 3R7, Canada

Phone & Fax: 250-360-1560

Email: litman@

Website: ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download