Business and Finance Homework

Need Finance Homework Help? Ask an Expert

Get an Answer ASAP!

Business and Finance Homework

# Accessing Financial Condition of CentervilleUse the five-year-trend

Customer Question
Accessing Financial Condition of Centerville Use...
Accessing Financial Condition of Centerville
Use the five-year-trend data in the table to evaluate whether Centerville's (C) revenue and expenditures are balanced. In summarizing Centerville's financial situation over a five-year period, the table includes five factors: amount of revenue that the city is gaining per household, the percentage of total revenue contributed by sales tax, how much the city is spending per household, and the percentage of the city's households that are exempt from paying sales tax.
Note that the city is gaining less per year from each household; however, with the exception of Year 5, it is spending more per year for services per household. Look at sales tax in the city, which is a main source of revenue. (Note: Convert the decimals in the “Sales tax as a percentage of total revenue” row. Remember that you multiply the decimal figure by 100 to derive the percentage. Multiplying .928 by 100 equals 92.8%, .926 by 100 equals 92.6%, .925 by 100 equals 92.5%, .923 by 100 equals 92.5%.)
What is happening to sales tax as a percentage of revenue? Look at the percentage of the city's households that are exempt from paying sales tax row. What is happening to the percentage of sales-tax-exempt households over the five-year period?
FACTOR YEAR
1 2 3 4 5
Revenue per household \$321 \$318 \$329 \$329 \$328
Sales tax as a percent of total revenue .938 .936 .935 .935 .933
Expenditures per household \$321 \$321 \$333 \$334 \$334
Low-income, sales-tax-exempt households as a percent of population .139 .139 .142 .155 .156
The city is spending more per household and deriving less revenue per household. The Centerville tax base is shrinking because more of its citizens are exempt from paying sales tax. What are possible reasons for an increase in the number of citizens who are exempt from paying sales tax? Is the city losing jobs? Is the city's population increasingly older and retired?
Analyzing a revenue structure will help identify the following types of problems.
The Assignment:
Create an expenditure profile that can reveal the following:
• Deterioration of revenue base
• Internal procedures or legislative/board policies that may adversely affect revenue yields
• Over-dependence on obsolete or external revenue sources
• User fees that do not cover the cost of services
• Changes in tax burden
• Lack of cost controls and poor revenue estimating practices
• Inefficiency in the collection and administration of revenues
Submitted: 2 years ago.Category: Business and Finance Homework
Show More
Show Less
Answered in 28 minutes by:
7/19/2015
Business Tutor: F. Naz, Bachelor's Degree replied 2 years ago
F. Naz, Bachelor's Degree
Category: Business and Finance Homework
Satisfied Customers: 5,361
Experience: Have completed B.COM and CA Finalist
Verified
Customer reply replied 2 years ago
It is due today at 12 midnight. Please let me know if this is going to be feasible.
Thanks!
Business Tutor: F. Naz, Bachelor's Degree replied 2 years ago
Please provide information or data to create profile expenditure for the following facts.
• Deterioration of revenue base
• Internal procedures or legislative/board policies that may adversely affect revenue yields
• Over-dependence on obsolete or external revenue sources
• User fees that do not cover the cost of services
• Changes in tax burden
• Lack of cost controls and poor revenue estimating practices
• Inefficiency in the collection and administration of revenues
Customer reply replied 2 years ago
That should be contained in the assignment i sent initially! I will send again
Customer reply replied 2 years ago
FACTOR YEAR
1 2 3 4 5
Revenue per household \$321 \$318 \$329 \$329 \$328
Sales tax as a percent of total revenue .938 .936 .935 .935 .933
Expenditures per household \$321 \$321 \$333 \$334 \$334
Low-income, sales-tax-exempt households as a percent of population .139 .139 .142 .155 .156
Customer reply replied 2 years ago
FACTOR YEAR
1 2 3 4 5
Revenue per household \$321 \$318 \$329 \$329 \$328
Sales tax as a percent of total revenue .938 .936 .935 .935 .933
Expenditures per household \$321 \$321 \$333 \$334 \$334
Low-income, sales-tax-exempt households as a percent of population .139 .139 .142 .155 .156
Business Tutor: F. Naz, Bachelor's Degree replied 2 years ago
The data is the same I am asking for
• Deterioration of revenue base
• Internal procedures or legislative/board policies that may adversely affect revenue yields
• Over-dependence on obsolete or external revenue sources
• User fees that do not cover the cost of services
• Changes in tax burden
• Lack of cost controls and poor revenue estimating practices
• Inefficiency in the collection and administration of revenues
Customer reply replied 2 years ago
I have attached the complete assignment! You will have to determine the Deterioration of revenue base, Internal procedures or legislative/board policies that may adversely".Assignment:
The regular evaluation of an organization's finances goes a long way toward establishing trust with stakeholders, such as tax payers, board members, clients, patrons, and funding agencies. Just as financial planning and budgeting are integral parts of an organization’s success, financial audits and evaluations are vital parts of the functioning of an organization. Evaluating the financial condition of an organization involves determining whether it has the revenue from taxes, fees, and other sources to meet its needs as well as if its assets exceed its liabilities.
In this Assignment, you evaluate the financial condition of a hypothetical town by considering trends and what they could mean. Review this week’s Learning Resources. Think about how public organizations can use data from audits and assessments to increase their effectiveness.
Consider the following:
Centerville is a hypothetical town that provides the context for this Assignment. What follows is a table that presents five years of data.
Use the five-year-trend data in the table to evaluate whether Centerville's (C) revenue and expenditures are balanced. In summarizing Centerville's financial situation over a five-year period, the table includes five factors: amount of revenue that the city is gaining per household, the percentage of total revenue contributed by sales tax, how much the city is spending per household, and the percentage of the city's households that are exempt from paying sales tax.
Note that the city is gaining less per year from each household; however, with the exception of Year 5, it is spending more per year for services per household. Look at sales tax in the city, which is a main source of revenue. (Note: Convert the decimals in the “Sales tax as a percentage of total revenue” row. Remember that you multiply the decimal figure by 100 to derive the percentage. Multiplying .928 by 100 equals 92.8%, .926 by 100 equals 92.6%, .925 by 100 equals 92.5%, .923 by 100 equals 92.5%.)
What is happening to sales tax as a percentage of revenue? Look at the percentage of the city's households that are exempt from paying sales tax row. What is happening to the percentage of sales-tax-exempt households over the five-year period?
FACTOR YEAR
1 2 3 4 5
Revenue per household \$321 \$318 \$329 \$329 \$328
Sales tax as a percent of total revenue .938 .936 .935 .935 .933
Expenditures per household \$321 \$321 \$333 \$334 \$334
Low-income, sales-tax-exempt households as a percent of population .139 .139 .142 .155 .156
The city is spending more per household and deriving less revenue per household. The Centerville tax base is shrinking because more of its citizens are exempt from paying sales tax. What are possible reasons for an increase in the number of citizens who are exempt from paying sales tax? Is the city losing jobs? Is the city's population increasingly older and retired?
Analyzing a revenue structure will help identify the following types of problems.
The Assignment:
Create an expenditure profile that can reveal the following:
• Deterioration of revenue base
• Internal procedures or legislative/board policies that may adversely affect revenue yields
• Over-dependence on obsolete or external revenue sources
• User fees that do not cover the cost of services
• Changes in tax burden
• Lack of cost controls and poor revenue estimating practices
• Inefficiency in the collection and administration of revenues
Analyzing an expenditure profile can reveal the following:
• Excessive growth of overall expenditures as compared to revenue growth or growth in wealth (personal and business income)
• Undesirable increases in fixed costs
• Ineffective budgetary controls
• A decline in personnel productivity
• Excessive growth in programs, which creates future expenditures
Community needs and resources encompass economic and demographic characteristics, including population, employment, personal income property value, and business activity. An examination of demographic and economic characteristics can identify the following:
• A decline in the tax or revenue base
• A need to shift public or customer service priorities
• A need to shift policies because of a loss of competitive position
Customer reply replied 2 years ago
I have attached the complete assignment! You will have to determine the Deterioration of revenue base, Internal procedures or legislative/board policies that may adversely" based on the data!
Business Tutor: F. Naz, Bachelor's Degree replied 2 years ago
I could not understand and I do not want to give wrong answer, therefore opting out so other experts may help you, thanks.
Customer reply replied 2 years ago
Thanks!
linda_us, Master's Degree
Category: Business and Finance Homework
Satisfied Customers: 852
852 Satisfied Customers
Experience: A tutor for Business, Finance, Accounts and other related topics.

linda_us is online now

A new question is answered every 9 seconds

• Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
• Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
• 100% Satisfaction GuaranteeRate the answer you receive.

## JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

## What Customers are Saying:

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

He answered my question promptly and gave me accurate, detailed information. If all of your experts are half as good, you have a great thing going here.

DianeDallas, TX

< Previous | Next >

## Meet the Experts:

linda_us

Master's Degree

852 satisfied customers

A tutor for Business, Finance, Accounts and other related topics.

F. Naz

Bachelor's Degree

5,361 satisfied customers

Have completed B.COM and CA Finalist

Bizhelp

Accountant

260 satisfied customers

BA degree and Certified Public Accountant

213 satisfied customers

dasdasd

Mr. Gregory White

Master's Degree

211 satisfied customers

M.A., M.S. Education / Educational Administration

Brittany

Professional

30 satisfied customers

Dimitry K., Esq.

Doctoral Degree

19 satisfied customers

< Previous | Next >

Related Business and Finance Homework Questions
What is the answer Marshall, Inc., produces three products
what is the answer Marshall, Inc., produces three products but weekly demand for the three products exceed the available amount of machine time. Following is information about each product: Product A … read more
Carter McBride
LLM
92 satisfied customers
It is an accounting questio (usa taX) need help with this
it is an accounting questio (usa taX) need help with this due by tomorrow . pls write answer question in separate document… read more
Expert
213 satisfied customers
Assignment 1. Plot in Excel the risky asset opportunity set
Assignment 1. Plot in Excel the risky asset opportunity set for Portfolios A & B. Hint: create the following table in excel assuming weights of portfolio A & B in 10 percentage point increments. Then … read more
F. Naz
Bachelor's Degree
5,361 satisfied customers
Manal, I see that you have previously helped someone answer
Hi Manal,I see that you have previously helped someone answer a tax return problem that is very similar to the one I am having trouble with. It is so similar that actually all of the same numbers, the… read more
Expert
213 satisfied customers
Cassius Clay operates a bituminous coal home heating and
Cassius Clay operates a bituminous coal home heating and delivery service in Dauphin and Centre counties. He must have a supply of bituminous coal on hand so customers may get the coal they need to he… read more
F. Naz
Bachelor's Degree
5,361 satisfied customers
Tax Return Problem 5 -Individual Tax Instructions: Please
Tax Return Problem 5 -Individual Tax Instructions: Please complete the 2016 federal income tax return for Joseph and Diana Cohen. You may complete the tax return using Tax Act or paper forms. The link… read more
PDtax
Owner
Master\u0027s Degree
1 satisfied customers
I'm enrolled at Portland Community College and for my
I'm enrolled at Portland Community College and for my Entrepreneurship class we are developing a workplace harassment app that would possible partner with BOLI and EEOC. What kind of information would… read more
Dr. Donna Kakonge
Doctor of Education
201 satisfied customers
Read the entire problem for America Los Rios on page 8-53
Please read the entire problem for America Los Rios on page 8-53 before entering any information in your tax software. If your software will not accept America's Social Security number as it is given … read more
PDtax
Owner
Master\u0027s Degree
1 satisfied customers
No need help with my accounting project. Need with with my
no need help with my accounting project JA: The Accountant will know how to help. Please tell me more, so we can help you best. Customer: need with with my budgent charts JA: Is there anything else th… read more
PDtax
Owner
Master\u0027s Degree
1 satisfied customers
This assignment is due on Tuesday 11/28 at 6 pm. This
This assignment is due on Tuesday 11/28 at 6 pm. This assignment is for a healthcare finance class. I have attached the needed documents below in order to complete the assignment. If you have trouble … read more
F. Naz
Bachelor's Degree
5,361 satisfied customers
Rosie has owned a successful luncheonette for several years.
Rosie has owned a successful luncheonette for several years. Tired of the long hours and eager to try another way of life, she decides to buy a fishing boat and start a charter service near Key West. … read more
F. Naz
Bachelor's Degree
5,361 satisfied customers
IPX Packaging) is located on page 445 in your textbook. Read
IPX Packaging) is located on page 445 in your textbook. Read the case and utilize the data included in the case to answer the following questions. 1. Calculate the overhead rate set at the beginning o… read more
F. Naz
Bachelor's Degree
5,361 satisfied customers
Read the entire problem for and Darlene Jasper starting on
Please read the entire problem for David and Darlene Jasper starting on pages 6-69 before entering any information in your tax software. The Jaspers' received a 1099-INT for their interest income. The… read more
taxmanrog
Master\u0027s Degree
722 satisfied customers
Monica is planning to start her own accounting, tax, and
Monica is planning to start her own accounting, tax, and financial planning business. Her uncle Gus has given her file cabinets, a desk, computer equipment, and bookcases that were in his den until he… read more
PDtax
Owner
Master\u0027s Degree
1 satisfied customers
Financial Ratio Analysis on the Kroger Corporation. Obtain
Financial Ratio Analysis on the Kroger Corporation. Obtain the most current SEC Form 10-K (annual financial report) from the company's web site (Do not use the Annual Report that is sent to shareholde… read more
F. Naz
Bachelor's Degree
5,361 satisfied customers
Kyle, a single taxpayer in the 39.6% tax bracket engaged in
Kyle, a single taxpayer in the 39.6% tax bracket engaged in the following disposition transactions during this tax year. You may assume the dispositions were made to unrelated parties unless told othe… read more
Dr. Donna Kakonge
Doctor of Education
201 satisfied customers
Assistance with multiple choice and True / False questions
Assistance with multiple choice and True / False questions concerning Six Sigma Yellow Belt level. 70 questions total… read more
GLENN
Master of Mathematics
336 satisfied customers
Using only.gov Websites report the current GDP, the current
Using only.gov Websites report the current GDP, the current Federal deficit, the current Federal debt, and the bot***** *****ne of the current (last) budget approved by Congress (surplus or shortage).… read more
F. Naz
Bachelor's Degree
5,361 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less