Data visualization dashboard | Accounting homework help

Homework Paper Help

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

Continue to order Get a quote

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Custom-written and plagiarism-free papers: Our authors create their work from scratch. Before presenting them to clients, we routinely verify them for signs of plagiarism. Our quality assurance group also double-checks and fixes any grammatical errors, assuring that all of our authors adhere to the same standards of writing.
The significance of timely delivery cannot be overstated, and we consistently strive to meet or exceed our clients' deadlines. Regardless of the short time frame, you can count on our writers to get the job done. We always have a team of writers ready to go, even if the deadline is only six hours away.
Customer Satisfaction: Our customer service representatives are the best in the business and have a wealth of knowledge in dealing with clients. All our customer service representatives are trained to listen and reply promptly until you are satisfied with their service. To ensure you're happy, our expert writers will strictly follow the criteria to generate a special report. Our customer service may be contacted by chat, email, or phone. In addition, we provide round-the-clock assistance to all of our clients.
Confidentiality: Our systems are safe, and your information is always protected. We're constantly looking for new facts when it comes to finishing your work. We use a safe and secure payment channel. Since our ordering process is completely anonymous, you don't have to provide any credit card information to place a purchase with us.
Highly Trained Authors: Our writers have received extensive training and are committed to delivering only the best papers. They are fluent in APA, MLA, HARVARD, IEEE, CHICAGO, and AMA referencing styles. To meet your expectations, our skilled writers always pay close attention to your instructions.
Lowered prices: We have set prices that are already discounted. Our prices are the best and affordable for all our esteemed customers.

Data visualization dashboard | Accounting homework help

Recent Posts

Recent Comments

Calculate the price of your order