Calculate Financial Statement Ratios Using the chart below (which replicates portions of the: 10 Point Test Ratios
Question:
Calculate Financial Statement Ratios
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 the three highlighted ratios using financial data for the Town of Chili. 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).
Show the calculations used to find the ratio and explain the test score.
The Town is in the southwest quadrant of Monroe County with a population of 29,123 in 2020
http://www.townofchili.org/wp-content/uploads/2020/04/2019C-Financial-Statements.pdf
answer the following questions:
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill