User Account

All Pages

Calculate the per capita county funding

Assignment Help Finance Basics
Reference no: EM131019661

1. Education Spending

a. Calculate the Per Student dollar amount for CMS Operating funding (Row 8).

b. For FY15, the average daily enrollment numbers are not yet available. You will need to forecast what that figure will be. Explain here how you arrived at your projection:

c. Using the CPI figures in Row 12, calculate the inflation-adjusted per student operating spending in each year from FY2002 to FY2015.

d. For FY15, you will need to either look up the CPI (for July 2014) or make a forecast. Explain here how you arrived at your projection:

e. Insert a column chart displaying the adjusted per capita operating expense for the years FY02 through FY15. Be sure to make the graph visually appealing. Describe the trend (or pattern) that you observe.

f. What is the percent change from FY02 to FY15? Be sure to use the inflation adjusted values.

2. Spending on County services

a. Row 14 shows the spending for County services for the same years. The population (or estimates) of the County is shown in Row 16. Use the existing data to estimate the population for FY14 and FY15 (N16 and O16). Explain here how you arrived at your projection:

b. Calculate the Per Capita County Funding (Row 18).

c. Adjust the Per Capita County Spending for inflation (Row 20).

d. Insert a column chart displaying the adjusted per capita County spending for the years FY02 through FY15. Be sure to make the graph visually appealing. Describe the trend (or pattern) that you observe.

e. What is the percent change from FY02 to FY15? Be sure to use the inflation adjusted values.

3. Analysis: Compare and contrast the spending patterns for education and County services. Be sure to compare the adjusted expenditures themselves, as well as any trends you observe. Take note of any outside forces that could have influenced spending during the years observed.

4. Evaluation: What are the most important things you have learned in this class? Is there anything you were hoping to learn or do that we did not cover?

5. Extra Credit: According to Dennis Covington, Executive Director of Budget Development for Charlotte Mecklenburg Schools, charter school funding (which comes directly out of the CMS instructional budget) was approximately $2 million in 1998. It is projected to be about $39 million this year (2014-2015 school year). What would that $2 million be today (adjusted for inflation)? What is the percent change after adjusting for CPI? What are the primary implications of charter school funding?

Reference no: EM131019661

Questions Cloud

What is fama''s of debt-equity ratio : Fama's has a WACC of 9.8%. The company's cost of equity is 13%, and its cost of debt is 6.5%. The tax-rate is 35%. What is Fama's of debt-equityratio?
Why does starbucks coffee consider internal leadership : 1. Why does Starbucks Coffee consider internal leadership development such an important part of its core business process?
Distinguish between discretionary fiscal policy : Distinguish between Discretionary Fiscal Policy and Automatic Fiscal Policy and give an example of each.
Multimodal and intermodal transportation : What is the difference between multimodal and intermodal transportation?
Calculate the per capita county funding : Insert a column chart displaying the adjusted per capita County spending for the years FY02 through FY15. Be sure to make the graph visually appealing. Describe the trend (or pattern) that you observe.
What leadership instrument available to the president : What leadership instrument available to the president and most governors is particularly useful as a source of budgetary influence?
Write the electron configuration for a u atom : The two most common isotopes of uranium are 235U and 238U . Compare the number of protons, the number of electrons, and the number of neutrons in atoms of these two isotopes.
Determine the nature of the solutions of the given equation : Determine the nature of the solutions of the equation. Find and label the vertex and the line of symmetry. Graph the function F(x) = -(1/3)x2.
How is the budget used for performance evaluation : How is the budget used for performance evaluation - Describe a comprehensive master budget and explain the difference between a flexible budget and master budget.

Reviews

Write a Review

Finance Basics Questions & Answers

  You just bought a house and have a 150000 mortgage the

you just bought a house and have a 150000 mortgage. the mortgage is for 30 years and has a nominal rate of 8 percent

  Explain the primary roles of the u.s. federal reserve

Briefly explain the primary roles of the U.S. Federal Reserve, the Federal Reserve Chairman, and the Federal Reserve Board. Indicate each party's effectiveness in today's economic environment. Provide support for your explanation.

  How much more would you be willing to pay today

How much more would you be willing to pay today for an investment offering $10,000 in four years rather than the normally advertised five-year period? Your discount rate is 8%.

  What is the expected rate of return for stock c

The expected return for stock A is 18.7 percent, and for stock B it is 11.2 percent. What is the expected rate of return for stock C?

  Determine how long will the money last per year

Your great aunt left you $20 000 when she died. You can invest the money to earn 12% per year. If you spend $3540 per year out of this inheritance, how long will the money last

  Bonds-carrying value and interest expense

A company issues $5,000,000, 7.8%, 20-year bonds to yeild 8% on January 1, 2007. Using effective-interest amortization, what will the carrying value of bonds be on December 31, 2007 balance sheet?

  How large of a rebate should the company offer to a buyer

A manufacture has been selling 1700 television sets a week at 420dollars each. A market survey indicates that for each 21 -dollarrebate offered to a buyer, the number of sets sold will increase by210 per week.

  Find the value of each of the bonds when required interest

pacific homecare has three bond issues outstanding. all three bonds pay 100 in annual interest plus 1000 at maturity.

  What is the npv of this project

The manager of the new project has found that the average return on equity is 20%, and the average debt-to-equity ratio is 1.00, in the wine industry. All the debt in this industry is viewed as default free by the market. The risk free rate is 4%, th..

  Financial performance of the organization

As the CFO, suggest one (1) key strategy that you might use in order to improve the financial performance of the organization. Recommend an approach to implement the suggested strategy. Provide support for your recommendation.

  Finding sustainable growth rate

Storico Cleaning, Corporation, had additions to retained earnings for the year just ended of $510,000. The company paid out $130,000 in cash dividends, and it has ending total equity of $6.8 million.

  Virginia hams has total sales of 86000 and an accounts

virginia hams has total sales of 86000 and an accounts receivables balance of 14400. how long on average does it take

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd