Time series plot-what type of pattern exists in the data

Assignment Help Financial Management

Reference no: EM13805495

The Seneca Children’s Fund (SCF) is a local charity that runs a summer camp for disadvantaged children. The fund’s board of directors has been working very hard over recent years to decrease the amount of overhead expenses, a major factor in how charities are rated by independent agencies. The following data show the percentage of the money SCF has raised that were spent on administrative and fund-raising expenses for 2003 to 2009.

Year Period (t) Expense (%)

2003 1 13.9

2004 2 12.2

2005 3 10.5

2006 4 10.4

2007 5 11.5

2008 6 10.0

2009 7 8.5

a. Construct a time series plot. What type of pattern exists in the data?

b. Use simple linear regression analysis to find the parameters for the line that minimizes MSE for this time series.

c. Forecast the percentage of administrative expenses for 2010.

d. If SCF can maintain its current trend in reducing administrative expenses, how long will it take SCF to achieve a level of 5% or less?

Reference no: EM13805495

Questions Cloud

Compute the amount of cash paid to merchandise suppliers : Lowes companies, a retailer of home improvement products, reported cost of goods sold of $31,729 million for the fiscal year ended January 30, 2009. Its ported merchandise inventories of $7,611 million at the beginning of fiscal 2009 and 8,209 millio..

Drawback of switching from a partnership to corporate form : One drawback of switching from a partnership to the corporate form of organization is the following:

Net present value is generally considered to be method : Given that the net present value (NPV) is generally considered to be the best method of analysis, why could you still use the other methods? You need to use other methods because the net present value method is unreliable when a project has unconvent..

Calculate the selling corporations tax bill : Last year the selling corporation had earnings before interest and taxes (operating income) equal to $1 million. it paid $200,000 in dividends to its stockholders and $100,000 in interest to its creditors. During the year, the company also repaid a b..

Time series plot-what type of pattern exists in the data : The Seneca Children’s Fund (SCF) is a local charity that runs a summer camp for disadvantaged children. The fund’s board of directors has been working very hard over recent years to decrease the amount of overhead expenses, a major factor in how char..

Cost of capital for the valuation of the collinsville plant : The average unlevered beta of publicly traded Sodium Chlorate businesses is 0.94. Assume zero debt betas. The target capital structure that is appropriate for Collinsville plant is 35% debt and 65% equity. What is the appropriate cost of capital for ..

Under the payback method-cash flows for two alternatives : Assume a $6,500 investment and the following cash flows for two alternatives. Under the payback method, which of the following would be concluded?

Statements about the payback method : Which of the following statements about the "payback method" is true?

As the cost of capital increases : Company a charges $40.00 per day company b charges $60.00 plus $20.00 per day for what number of days is the cost the same? As the cost of capital increases,

User Account

All Pages