11-Financial Statement Calculation.xlsx

This is a Financial Statement Calculation worksheet for Solicitation No. 696-BF-26-O033 issued by the Texas Department of Criminal Justice for a Photo and ID Card solution. The worksheet is designed to collect financial data from respondents to evaluate their financial stability and capability to perform under the contract. Respondents are required to input financial data into designated green fields within the spreadsheet to complete two key financial ratios: the Debt Ratio (calculated as Total Liabilities divided by Total Assets) and the Current Ratio (calculated as Current Assets divided by Current Liabilities). All data entered into this worksheet must be corroborated by supporting documentation submitted in response to Section K.3.8 of the solicitation.

The worksheet functions as Exhibit J.2 within the solicitation package and serves as a standardized format for financial evaluation. Respondents must complete all required green fields accurately, as incomplete submissions or unsupported financial data may result in proposal rejection. The financial ratios calculated through this worksheet will be used to assess each respondent's financial health, liquidity position, and ability to meet contractual obligations. Supporting documentation, such as audited financial statements, balance sheets, and income statements, must accompany the completed calculation worksheet to validate the figures entered.