Layout of the Spreadsheet

The spreadsheet model includes five tables:

Table 1: Basic data including the name and location of the project, lease and lease/purchase information, and relevant interest rates and time periods.

Table 2: Purchase alternative information, including ancillary costs, that may include imputed costs, as directed by OMB Circular A-94.

Table 3: Construction costs and interest, including yearly expenditures during construction, for the construction alternative. The interest cost is included to reflect the opportunity cost associated with the use of Federal funds.

Table 4: Annual payments, which may include imputed costs, as directed by OMB Circular A-94.

Table 5: Annual cash flows for the life of the analysis (used to determine net present values in the summary figures) and a summary, indicating the best alternative based on the analysis.

Each table is organized into titles, data, and equations necessary to complete the analysis. Model users are required to provide the appropriate data in accordance with OMB Circular A-94. The shaded portions of the spreadsheet indicate where the user is required to enter a number.

back forward  index


User's Guide To The Facility Lease, Purchase, Or Construction Spreadsheet
7100 Engineering
January 1999
9971-2819-MTDC


This page last modified October 1, 1999

Visitor since October 1, 1999