15.11 Using Exhibit 13.1, prepare common size ratios for Smith City for governmental activities, and answer and explain with theory the following: (maximum 3 pages, minimum 500 words) 1. Are government activities financially viable and sustainable? Explain. 2. Which is the largest asset? Explain 3. Which is the largest liability? Explain 15.12 Using Exhibit 13.1, calculate the current ratios for Smith City for governmental activities, business type activities, total and component units, and answer and explain with theory the following: (maximum 2 pages, minimum 500 words) 1. Compare the results of calculated current ratios for the three operating centers and order them from largest liquidity to smallest liquidity, then associate the type of activity of each operating center with its corresponding liquidity. Does each liquidity and center make logic? Explain. 15.13 Using Exhibit 13.1, calculate the solvency ratio of long-term debt to total net position for the governmental activities, and answer and explain with theory the following: (maximum 2 pages, minimum 500 words) 1. The historic data of long-term debt to total net position for government activities for the following years is as follows: Fiscal Year 2010 2011 2012 Long term debt to total net position value 0.40 0.45 0.50 0.55 0.48 0.45 0.52 0.58 ? 2013 2014 2015 2016 2017 2018 Please analyze and explain the trending values of government activities as related to an ascending or descending pattern when the missing value of 2018 is known. Smith City Statement of Net Position As of June 30, 2018 Primary Government Governmental Business-Type Activities Activities Total Component Units $ 81 98 990 $ 7381,774 45,203 2.520,731 219.638) 88,672 $ 15,580,754 11,633,841 11,509.923 $ 212.755 5.200.266 2.829.603 11,585 438 6,963,192 219.038 225.504 $ 29,215,753 56,588 314,178 $ 39,018, 494 $ 9,802,741 $ 8,301,212 $ $6.806.765 $ $ 8,680.765 1.612.279 1,612,279 Assets Current assets Cash and cash equivalents Investments Receivables, net Internal balances Inventores Total current assets Noncurrent seats Restricted cash and cash equivalents Equity interest in joint venture Capital assets Land and construction-in-progress Buldings, equipment, and Infrastructura, net of depreciation Total noncurrent assets Total Assets A Deferred Outflows of Resources B Labilities Current liabilities Accounts payable Current portion of long-term liabilities Total current liabilities 19,904,516 4,485,705 24,390,223 525,667 99,111,415 101.456.421 200 597635 $129.514.976 $156,730, 729 $ $105,972, 120 $115,774,807 $ 4235.487.102 $274,505,598 $ 25,896,483 $20.421,350 $34,722,562 $ 5 $ 5.276.980 6.485,200 $ 11,742,150 550.789 3,098,400 $ 5,827.770 9,503,800 $ 15,391,370 $ 1.262,332 096,647 $2,260,980 $ 3,649,190 Noncurrent liabilities Noncurrent portion of long-term liabilities Total Liabilles C 58,311,665 $ 70,053,845 52.137.591 $ 55,786,781 110.449.256 $ 125.640.625 16,974,306 $ 21,235,285 Deferred Inflows of Resources Prepaid property taxes Total Deferred Infics of Resources D $ $1.004.919 $ 1,004,919 $ 1,004,919 27.238 27,298 $ $ 1,004,919 $ $ 72,597,970 $ 51,162,002 $ 123,759,972 $ 11,134,474 7,459,016 Net Position Net investment in captal assets Restricted for: Transportation and new city hall project Debt service Low income housing and industrial redevelopment Other purposes Unrestricted deficit Total Net Position A-B-C-D 7,459,016 2.153,780 1,016,397 3.170.178 4.791,940 1,038,371 (369,112 $ 87,671,986 4.791.940 1.038.371 7.440.575 7.809,687 344,712 1.980,653 $ 13.480.039 $ 59.998,088 $ 147,680,052 15.11 Using Exhibit 13.1, prepare common size ratios for Smith City for governmental activities, and answer and explain with theory the following: (maximum 3 pages, minimum 500 words) 1. Are government activities financially viable and sustainable? Explain. 2. Which is the largest asset? Explain 3. Which is the largest liability? Explain 15.12 Using Exhibit 13.1, calculate the current ratios for Smith City for governmental activities, business type activities, total and component units, and answer and explain with theory the following: (maximum 2 pages, minimum 500 words) 1. Compare the results of calculated current ratios for the three operating centers and order them from largest liquidity to smallest liquidity, then associate the type of activity of each operating center with its corresponding liquidity. Does each liquidity and center make logic? Explain. 15.13 Using Exhibit 13.1, calculate the solvency ratio of long-term debt to total net position for the governmental activities, and answer and explain with theory the following: (maximum 2 pages, minimum 500 words) 1. The historic data of long-term debt to total net position for government activities for the following years is as follows: Fiscal Year 2010 2011 2012 Long term debt to total net position value 0.40 0.45 0.50 0.55 0.48 0.45 0.52 0.58 ? 2013 2014 2015 2016 2017 2018 Please analyze and explain the trending values of government activities as related to an ascending or descending pattern when the missing value of 2018 is known. Smith City Statement of Net Position As of June 30, 2018 Primary Government Governmental Business-Type Activities Activities Total Component Units $ 81 98 990 $ 7381,774 45,203 2.520,731 219.638) 88,672 $ 15,580,754 11,633,841 11,509.923 $ 212.755 5.200.266 2.829.603 11,585 438 6,963,192 219.038 225.504 $ 29,215,753 56,588 314,178 $ 39,018, 494 $ 9,802,741 $ 8,301,212 $ $6.806.765 $ $ 8,680.765 1.612.279 1,612,279 Assets Current assets Cash and cash equivalents Investments Receivables, net Internal balances Inventores Total current assets Noncurrent seats Restricted cash and cash equivalents Equity interest in joint venture Capital assets Land and construction-in-progress Buldings, equipment, and Infrastructura, net of depreciation Total noncurrent assets Total Assets A Deferred Outflows of Resources B Labilities Current liabilities Accounts payable Current portion of long-term liabilities Total current liabilities 19,904,516 4,485,705 24,390,223 525,667 99,111,415 101.456.421 200 597635 $129.514.976 $156,730, 729 $ $105,972, 120 $115,774,807 $ 4235.487.102 $274,505,598 $ 25,896,483 $20.421,350 $34,722,562 $ 5 $ 5.276.980 6.485,200 $ 11,742,150 550.789 3,098,400 $ 5,827.770 9,503,800 $ 15,391,370 $ 1.262,332 096,647 $2,260,980 $ 3,649,190 Noncurrent liabilities Noncurrent portion of long-term liabilities Total Liabilles C 58,311,665 $ 70,053,845 52.137.591 $ 55,786,781 110.449.256 $ 125.640.625 16,974,306 $ 21,235,285 Deferred Inflows of Resources Prepaid property taxes Total Deferred Infics of Resources D $ $1.004.919 $ 1,004,919 $ 1,004,919 27.238 27,298 $ $ 1,004,919 $ $ 72,597,970 $ 51,162,002 $ 123,759,972 $ 11,134,474 7,459,016 Net Position Net investment in captal assets Restricted for: Transportation and new city hall project Debt service Low income housing and industrial redevelopment Other purposes Unrestricted deficit Total Net Position A-B-C-D 7,459,016 2.153,780 1,016,397 3.170.178 4.791,940 1,038,371 (369,112 $ 87,671,986 4.791.940 1.038.371 7.440.575 7.809,687 344,712 1.980,653 $ 13.480.039 $ 59.998,088 $ 147,680,052