Week 10 Assignment – Trend Analysis
In next week’s assignment, you will need to create tables and charts to show a trend analysis of financial factors for a selected program or agency.
ASSIGNMENT PREPARATION
In next week’s assignment, you will need to create tables and charts to show a trend analysis of financial factors for a selected program or agency. To prepare for this, you may want to brush up on your Excel skills.
Microsoft’s Excel Help Center offers a variety of tutorials and resources for beginning to advanced Excel users.
The Tables & Charts page has specific tutorials helping you to organize your data so that it is easily understood.
For your assignment, you will select 4–5 financial factors to analyze. Review Chapter 7 in The Basics of Public Budgeting and Financial Management to see a complete list of factors and select the ones you plan to focus on in your trend analysis.
Week 10 Assignment – Trend Analysis
In a 4–5 page paper, use the Financial Trend Monitoring System to identify financial factors affecting the financial solvency of a state, a local, or a nonprofit agency. You may choose a new agency to analyze or use one of the agencies you looked at in a previous assignment. (A federal agency or department should not be used for this assignment.) Using the financial factors from Table 7.1, pick 2–3 factors and conduct a trend analysis.
Evaluate selected financial factors by analyzing financial data over at least the last five years. Title this section Trend Analysis.
See Table 7.1 Factors Affecting Financial Condition for a list of financial factors.
Create a table or chart with each factor indicating the direction of the trend. Title this section Data Analysis. (Note: This section should only consist of at least two or three tables or charts.)
Justify your table or chart for each factor by writing a brief evaluation of the trend. Title this section Trend Evaluation.
Develop and explain a policy statement based on your findings to manage areas of concern. Title this section Policy Statement.
Your assignment must follow these formatting requirements:
Include an Introduction and Conclusion in the 4–5 page count. Your cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, the date, and the reference page are not included in the required assignment page length.
This course requires the use of Strayer Writing Standards. For assistance and information, please refer to the Strayer Writing Standards link in the left-hand menu of your course.
The specific course learning outcome associated with this assignment is:
Evaluate financial trends for a selected agency and propose fiscal recommendations.
Answer preview in next week’s assignment, you will need to create tables and charts to show a trend analysis of financial factors for a selected program or agency.
1220 words