Description: In this assignment, you will assume the role of staff auditor. Your client is the Parks and Recreation Department in Boston, Massachusetts. Your task is to perform substantive and analytic procedures on the cash disbursements for fiscal year $($FY$)23.$ You will write up a formal report, which includes the results of substantive procedures that will ultimately be included in the audit working papers.

Objective: To evaluate and analyze cash disbursements made by the Parks and Recreation Department during fiscal year $23$ through substantive and analytic procedures. This assignment is designed to give students experience using real world data and performing typical analytic and data organization tasks.

Important Client Note: The fiscal year for the client runs from July $1$ to June $30.$ You will need to adjust your tests$/$analysis accordingly. You have access to the cash disbursements for FY $21,22,23,24.$ All are contained within a single CSV file that can be read in Excel or another software of your choice.

Audit Tasks $($x$5)$

Substantive Procedure $1$: Create a graph showing the trend in total cash disbursements by month between the start of FY$21$ to FY $24.$ Discuss what you find. Points to consider in your discussion may include but are not limited to:

What are the trends you discover?

Are there any patterns?

Can you make any inferences from these trends or patterns?

What additional information might you require from the client?