Complete the following ratios in Excel regarding the primary government activities:
current, working capital, quick, debt-to-assets, debt-to-equity, return on assets, return on net assets, operating, own-source, net assets per capita, debt per capita, total revenues per capita, taxes per capita, and total expenditure per capita.
You should focus your attention on the statements found pp. 37-38 (the CAFR’s page numbering, not the PDF page). For each, write a sentence reporting the results and briefly describing what it means.
Note the following assumptions:
All assets are current except the restricted and capital assets
All liabilities are current except those listed under non-current liabilities
Marketable securities are found in the line entitled, “Securities Lending Collateral”.
“Receivables (net)” are considered accounts receivable.
The City of Orlando population is 285,713
Write a paper that explains the financial condition of the City of Orlando in FY 2019, including any “red flags” that you identify.
