Balance Sheet assumption inputs
NOTE: All inputs should be incremental, for example, if you want days in AR to change from 64 to 56, the input is 8 not 56.
Asset Inputs (All inputs should be in whole dollars)
| Cash and cash equivalents | Computed through days of operating cash | |
| Short-term cash investments | Input Schedule | |
|
Current assets limited as to use |
Input Schedule | |
| Patient Accounts Receivable | Computed from Gross A/R Days in gross patient receivables | Configurable sections are netted from the total calculation on the first row. |
| Physician Accounts Receivable | Input Schedule | |
| Allowance for Uncollectibles | Calculated from Net A/R Days less Gross receivables | Configurable sections are netted from the total calculation on the first row |
| Third Party Settlements | Computed from 3rd Party days in Net Patient Receivables | Configurable sections are netted from the total calculation on the first row. |
| Current Receivables | Input Schedule | |
| Supply Inventories, at cost | Computed from Days in Supply inventories |
Configurable sections are netted from the total calculation on the first row. Driven by total supplies expense from the income statement |
| Prepaid Expenses | Computed from Days in Prepaid Expenses |
Configurable sections are netted from the total calculation on the first row. Driven by total other expenses from the income statement |
| Other Current Assets | Input Schedule | |
| Assets Limited as to use – Trusted Assets | Input Schedule | |
| Assets Limited as to use – Board Designated Investments | Input Schedule |
|
| Assets Limited as to use – Other Assets Balance | Computed | |
| PPE – Land | Input Schedule |
Net Capital Acquisitions Revaluation amount |
| PPE – Property and Equipment | Input Schedule |
Net Capital Acquisitions +\- Revaluation amount |
| PPE – Accumulated Depreciation | Input Schedule |
Depreciation Expense – Automatic flow from Income Statement +\- Disposals |
| PPE – Construction in Progress | Net Capital Acquisitions | +\- Revaluation amount |
| Unamortized Financing Fees | Input Schedule | |
| Amortization of existing fees | Input Schedule | |
| Investment in subsidiaries | Input Schedule | |
| Notes Receivable | Input Schedule | |
| Other Long-Term Assets | Input Schedule | Liability Inputs (All inputs should be in whole dollars) |
| Line of credit | Calculated | |
| Current maturity of long-term debt | Input Schedule |
Estimates current portion of long-term debt Adjustment of current portion of long-term debt |
| Accounts Payable | Computed from A\P days in other expenses |
Configurable sections are netted from the total calculation on the first row. Driven by total other expenses from the income statement |
| Accrued Payroll | Computed from Accrued Payroll days in salary expenses |
Configurable sections are netted from the total calculation on the first row. Driven by total other expenses from the income statement |
| Accrued Expenses | Computed from Accrued Expense days in other expenses |
Configurable sections are netted from the total calculation on the first row. Driven by total other expenses from the income statement |
| Third Party Settlements | Computed from 3rd party days in other expenses |
Configurable sections are netted from the total calculation on the first row. Driven by total other expenses from the income statement |
| Other Accrued Liabilities | Input Schedule | |
| Other Long Term Liabilities 1 | Input Schedule | |
| Other Long Term Liabilities 2 | Input Schedule | |
| Long-Term Debt | Input Schedule |
Net new loans Regular principal payments |
Equity Inputs (All inputs should be in thousands)
| Fund Balance | Input Schedule |
Net Income – Computed and included in projection if Instructions tab says Yes to include in Fund Balance. Net Income is automatically added to fund balance for budget. |
| Temporarily restricted net assets | Input Schedule | |
|
Permanently restricted net assets |
Input Schedule |
