28 Jun You serve as the Deputy Chief Financial Officer of your city government. Recent discussions in upper-level management meetings highlight concerns about the
You serve as the Deputy Chief Financial Officer of your city government. Recent
discussions in upper-level management meetings highlight concerns about the
government’s financial performance. Juliet Sweeting, the city’s Chief Financial
Officer (CFO) asked you to help benchmark your city’s financial performance against
another city of similar size. You have been tasked to create a Dashboard in Excel
that can use to compare your city to any other city. The comparison will be done with
ratios commonly used to evaluate the financial health of city governments.
Your goal is to choose another city similar to yours and compute the ratios for each
city. Create a dashboard whereby Ms. Sweeting, CFO can easily read and
understand the results in 30 seconds or less.
1. Find the Comprehensive Annual Financial Reports for two cities.
2. Type in the financial statements of the two cities in side-by-side fashion on Tab 3
of your Excel file (Do not copy and paste a picture. You need these numbers for
your computations). If data not shown on the financial statements is necessary
for your ratio computations, create an “Other Information” area to post this data
for the two cities.
3. Use Tab 2 of your Excel file to show the computation of the ratios by category; see the Appendix below. The information used to compute the ratios should flow
from the data in Tab 3. Make sure it is clear to your CFO that you know how to
compute and interpret these ratios.
4. Use Tab 1 to create a dashboard showing the results of the ratios, comparing
the two cities. The dashboard should be composed ONLY of clearly-marked
graphs that convey the data in a way that makes it easy to read and understand
quickly.
5. When Ms. Juliet Sweeting, CFO changes numbers on the financial statements
on Tab 3, the dashboard graphs should automatically change.
The ratios required fall into three categories, as shown in the Appendix
Use the most recent annual financial statements.
• Present 2 decimal points for all figures in your deliverable
• Remember all reports and dashboards should be clear and easy to read
• Use a large enough font that anyone can easily read your dashboard
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Wridemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.