Forecast the percentage of administrative expenses

Assignment Help Financial Management

Reference no: EM13804339

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: EM13804339

Questions Cloud

Compute amount of cash paid to merchandise suppliers fiscal : 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 the corporate : One drawback of switching from a partnership to the corporate form of organization is the following:

Net present value is generally considered to be best 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..

Selling corporation had earnings before interest and taxes : 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..

Forecast the percentage of administrative expenses : 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..

Compute three-week weighted moving average for time series : Using a weight of 1/2 for the most recent observation, 1/3 for the second most recent, and 1/6 for third most recent, compute a three-week weighted moving average for the time series. Compute the MSE for the weighted moving average in part (a). Do yo..

Describe cyclical variations and seasonal variations : We’ve already discussed seasonal variations and how they result from the predictable shopping habits of consumers. Describe cyclical variations. How do they compare to seasonal variations?

How much did he invest in each account : Paul invests $15,250 in two different accounts. One pays an interest rate of 8.5% while the other account pays 10%. If he gains a total of $1411.75 annually, how much did he invest in each account?

What is economic profit and accounting profit : What is economic profit and accounting profit with the information given?

User Account

All Pages