Please fill out the following spreadsheet based on the City of Providence 2011-2015 financial statements which can be found at:

https://www.providenceri.com/finance/financial-reports

Strategic Accounting Week 7 City of Providence Requirement 2 Unrestricted Net Assets Net Assets Total Assets Total Liabilities Total Revenue Total Expenditures Changes in Net Assets 2011 2012 2011 2012 Current Ratio Debt ratio Requriement 3 Discuss The Trends ... How is Providence doing in 2013, 2014 and 2015 relative to 2011-2012 How is your Municipality doing? Compare your municipality with Providence 7 a. Is the City in Distress? Explain - where appropriate, calculate the cumulative operating deficit 2011 2012 2011 2012 7b. Risk factors for 2011-2015 for the City of Providence and 2014-2015 for your municipality Taxes to Revenue Inter-Governmental Revenues Administrative Cost Ratio Debt Level Debt to Revenue Level Size Revenue Growth Is the municipality in distress during the year - support your answer with your calculations (if you prefer, you may answer in a separate word document) Requirement 5 2011 Pensions - see what you can find for your municipality Net Pension Cost (2011-2013) Page 50 of 2013 footnotes Net Pension Liability - Page 53 of 2015 2012 What is the investment rate of return for the pension for 2015? Does that seem sustainable What happens? Other post employment benefits Annual OPEB Costs Contributions made Net obligations 2011 2012 counting Issues City of Providence 2013 2014 2015 2013 2014 2015 2013 2014 2015 2013 2014 2015 2013 2014 2015 2013 2014 2015