Financial Management (see assignment attached)

Financial Management Case:  Financial Statement Analysis. (200 points)
In Weeks 8-9 we introduced financial statements and financial statement analysis. In this assignment you will review the Town of Chili, New York Basic Financial Statements for Fiscal Year Ended December 31, 2019 a copy is included below.  The Town is in the southwest quadrant of Monroe County with a population of 28,625 in 2010. 
Submit your response for the written part of assignment as a Word document to Part A of the assignment on the course Blackboard site.   Make sure that you submit your response using the numbered sections in the assignment with the same bolded or italicized subtitles or headers.  Please cover the points that you want to make, but be concise.  You are welcome to make references to the course texts or other resources – that are valuable to help make or emphasize a point you want to make.
Read Through – Review of Financial Statements (120 points)
Read the following sections of the Chili financial report:
Independent Auditors Report (2-3)
Managements Discussion and Analysis (4-18)
Basic Financial Statements (pages 19-25)
Notes to Basic Financial Statements (pages 26-56)

Management Discussion and Statements. Review Chilis Management Discussion and (1) Statement of Net Position (balance sheet), (2) Statement of Activities (income statement), and (3) Statement of Revenues, Expenditures and Changes in Fund Balances Governmental Funds.
In short paragraphs (up to 2 paragraphs per item)  indicate your initial assessment of each of the following for Chili (you will calculate ratios later for comparison):

Liquidity availability of liquid assets to cover short term liabilities, etc.

Profitability the degree to which revenues exceed expenses and change from year to year, etc.

Solvency the ability of the Town of Chili generate enough resources to cover near term and long term liabilities?  For example does long term debt seem high?

Items of Concern – Note if there are any particular items in the basic financial statements that raise a question or concern.

Notes to Financial Statements.   List items from the notes to financial statements that raise a question or provide clarity and understanding to the basic financial statements.  Describe why you are listing them.  Include 3- 5 items in your list.

Calculate Financial Statement Ratios (80 points)
Using the chart below (which replicates portions of the:  10 Point Test Ratios for Overland Park, KS in FY2015 on page 88 in Kyoko and Marlowe).   In the Ten Point Test EXCEL file (below) calculate as many of the ten ratios for which data is available for the Town of Chili.  The Town of Chili has no enterprise funds so the Coverage 2 ratio cannot be calculated.  After calculating the ratios use the table at the bottom (also in the EXCEL spreadsheet) to assign 10 Point Test values to each calculated ratio as indicated in Kioko and Marlowe on pages  88-92.   Use the Score column in the Excel spreadsheet to record the assigned value (based on the quartile of the calculated ratio).   On the spreadsheet briefly discuss how you would interpret the “Total” if all the data were available.  Submit your Excel file to the drop box for Part B.

Ratio

  Computation

Liquidity

 

Short-Run Financial Position

(Unassigned General Fund Balance)/(General Fund Revenues)

Liquidity

(General Fund Cash + General Fund Investments )/(General Fund Liabilities)

 

 

Profitability

 

Net Asset Growth

Change in Governmental Activities Net Position /Beginning Governmental Activities Net Position

Operating Margin

(Net (Expense) Revenue for Governmental Activities/Total Governmental Activities Expenses) * -1

Own-Source Revenues

Primary Government Operating Grants / (Total Primary Government Revenues)

 

 

Solvency

 

Near-Term Solvency

(Primary Government Liabilities)/(Total Primary Government Revenues)

Debt Burden

(Primary Government Non-Current Liabilities)/Population

Coverage 1

(Governmental Funds Principal and Interest on Long-Term Debt/General Fund Expenditures)

Coverage 2

Enterprise Funds Operating Revenue/Enterprise Funds Interest Expense

Capital Asset Condition

(Ending Net Value of Primary Government Capital Assets Beginning Net Value) / (Beginning Net Value

Place your order
(550 words)

Approximate price: $22

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

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.

Read more

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.

Read more

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.

Read more

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.

Read more

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.

Read more