|BCA||Benefit Cost Analysis|
|CFADS||Cash Flows Available to Debt Service|
|DSCR||Debt Service Coverage Ratio|
|DSRA||Debt Service Reserve Account|
|GPL||General Purpose Lanes|
|IRI||International Roughness Index|
|IRR||Internal Rate of Return|
|ML/TL||Managed Lanes or Tolled Lanes|
|MMRA||Major Maintenance Reserve Account|
|O&M||Operations and Maintenance|
|PDBCA||Project Delivery Benefit-Cost Analysis|
|PL||Profit & Loss|
|PSC||Public Sector Comparator or Conventional Delivery|
|VDF||Volume Delay Function|
|WACC||Weighted Average Cost of Capital|
The purpose of the Quick Start Guide is to provide the user with a brief overview of the P3-VALUE 2.0 tool. The Quick Start Guide describes a series of basic step-by-step instructions used to navigate the inputs and outputs of the tool. For more detailed instructions and the methodology behind the tool, please see the Guide to P3-VALUE 2.0 (currently under development).
If "Model Navigator" is selected, the following user form will appear. The Model Navigator enables the user to navigate the P3-VALUE 2.0 tool. If the user wishes to switch to the Training Navigator, one may do so by clicking the "Go to Training Navigator" button on the top right. The user can exit the Navigator at any point by clicking on the exit "X" at the top right corner of the Navigator. To access the Navigator again, simply click on the "Navigator" button on the toolbar (see below).
The Model Navigator has two different view options: a high level and a detailed level view. Users can choose between the high level view and detailed level view using the radio buttons at the top left of the Navigator.
In the high level view, the user has access only to the inputs, landing sheets (see below) and outputs. Detailed calculation sheets are hidden to provide the user with overall understanding of the model flow and logic. By clicking on any of the buttons in the high level view, the Model Navigator will either list the relevant input sheets (for the "Inputs" button), output sheets (for the "Risks", "VfM Outputs" and "PDBCA Outputs" buttons) or take the user to the relevant landing sheet (for all other buttons). For the listed input and output sheets, the user can click on them to directly access these input and output sheets.
In the detailed level view, all sheets are visible and accessible to the user. By clicking on any of the buttons in the detailed level view, the Model Navigator will list all relevant worksheets. The screenshot to the right shows what the user will see if he or she clicks on the P3 button (in the Value-for-Money section).
The user can click on any of the listed worksheets to navigate to a particular worksheet. While the high level view enables the user to navigate the model through landing sheets, the detailed level view enables the user to navigate to each individual sheet in the model.
The landing sheets provide an overview of each module's components (elements used as inputs to the calculations in the module, calculations carried out within the module, and a list of outputs and modules that are affected by this module's calculations) in a flow chart format. As an example, the screenshot below shows the landing sheet for the Revenues module.
The landing sheet can also be used to navigate the model. To access the landing sheet, click on any button in the high level view. By double clicking on any of the sheet names listed on the landing sheet, the user will be taken to the selected sheet. This functionality works both in the high level and detailed level view (in the high level view, the selected sheet will in fact be unhidden to be visible to the user).
The model also contains a toolbar that is visible in all worksheets (except on the Home worksheet). The toolbar contains the following three buttons.
The user can use the toolbar to navigate or optimize the model:
Once inputs have been entered and reviewed, click the Model Optimizer button, which calculates the required subsidy/availability payment required to make the project financially feasible while simultaneously optimizing the project's financing.
Use the Model Navigator to navigate to the various modules and worksheets to review the detailed calculations used for VfM and PDBCA. To be able to access the calculation sheets, the user should switch to the detailed level view. The user may want to review some or all of the following calculation modules:
Click on the various output sheets under each of the output modules - Risks, VfM Outputs and PDBCA Outputs in the Model Navigator to review the results of the risk analysis, VfM analysis, and Project Delivery BCA.