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

  Provide your boss with a summary spreadsheet that shows the

as an assistant vice president at a regional bank your boss has tasked you and the other avps to work in a group to

  Npv and the profitability index if we define the npv index

npv and the profitability index if we define the npv index as the ratio of npv to cost what is the relationship between

  Bank evaluation process

Assume that you are nearing graduation and have applied for a job with a local bank. The bank's evaluation process requires you to take an examination that covers several financial analysis techniques. The first section of the test asks you to add..

  What will be the firm quick ratio

How much can a company's short-term debt(notes payable) increase without pushing its current ratio below 2.0? What will be the firm's quick ratio after Nelson has raise the maximum amount of short-term funds?

  Determine the market return for an investment

Determine the market return for an investment with a required rate of return of 15%, a Beta of 1.10 and the risk free rate is 4 percent?

  A rate of 175 percent for a seven-year period the loan

present value of an annuity due grant productions has borrowed a large sum from the california finance company at a

  Recruitment begins by specifying

Recruitment begins by specifying

  Limitations of financial ratios

Referencing this week's readings and lecture, what are the limitations of financial ratios? Classify your answer into at least the following categories: liquidity ratios, activity ratios, leverage ratios, and profitability ratios.

  Price corp is considering selling to a group of new

price corp. is considering selling to a group of new customers and creating new annual sales of 320000. 3 will be

  How much is each end of the year payment

A woman borrows sixty-five thousand dollars and will repay the loan in equal annual payments over the next 10 years. The interest rate on the loan is 9%. How much is each end of the year payment?

  Brkin incorporated is proposing a rights offering

rights offerings borkin incorporated is proposing a rights offering. currently there are 560000 shares outstanding at

  What is the cost of writing a covered call what will be

the following information is given about options on the stock of a certain companys0 20 x 20 r 5 c.c. t 0.5 years

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