Questions
The accompanying data table show the percentage of tax returns filed electronically in a city from...

The accompanying data table show the percentage of tax returns filed electronically in a city from 2000 to 2009. Complete parts a through e below.

Year   Percentage
2000   25
2001   33
2002   37
2003   38
2004   48
2005   50
2006   55
2007   59
2008   62
2009   64

a) Forecast the percentage of tax returns that will be electronically filed for 2010 using exponential smoothing with alpha= 0.1.

​b) Calculate the MAD for the forecast in part a.

c) Forecast the percentage of tax returns that will be electronically filed for 2010 using exponential smoothing with trend adjustment. Set alpha= 0.3 and beta= 0.4.

​d) Calculate the MAD for the forecast in part c.

In: Statistics and Probability

Year                Technology          Energy 2000:          -24.31    &n

Year

               Technology          Energy

2000:          -24.31            30.47

2001:          -38.55           -12.49

2002:          -36.89           -11.61

2003:           68.59            27.84

2004:         -9.98            35.94

2005:          17.81             70.70

2006:          3.79               -2.12

2007:          -3.13              29.30

2008:        -42.51           -48.25

2009:        79.03              40.13

2010:        45.03           34.25

2011:         -12.21          -8.76

what I have to find. There are 2 data FUNDS in the file: Technology and Energy.

1) For each fund, compute using Excel: the Average, Median, Mode, the first percentile, the third percentile.

2) Graph the Box-Plot for each fund (called Box and Whisker in Excel).

3) For each fund, compute using Excel: the Range, Mean Absolute Deviation, the variance, the standard deviation and the coefficient of variation.

4) Using Excel, compute the Sharpe-Ratio for each fund using the risk free return of 3%. 5) Using Excel, compute the correlation between both funds.

In: Statistics and Probability

Homework 7 VOLATILITY 1. Find the mean and standard deviation of returns for stock ABC. Year...

Homework 7

VOLATILITY

1. Find the mean and standard deviation of returns for stock ABC.
Year
% Return
(using logs)
2003
3.45
2004
7.81
2005
8.34
2006
6.21
2007
-8.81
2008
-5.30
2009
2.01
2. Find the expected return and standard deviation of a portfolio which holds $300 in asset A and $700 in asset B. There is a correlation of -0.6 between asset A and B.
Asset
Expected
Return
Expected
Standard Deviation
A
8.3%
12.1%
B
4.6%
7.3%

3. Find the expected return and standard deviation of a portfolio which holds $2,000 in General Electric and $3,500 in Walmart. There is a correlation of -0.4 between asset General Electric and Walmart. For General Electric the expected return is 2.5% and the standard deviation is 4.1%. For Walmart the expected return is 1.4% and the standard deviation is 1.3%.

4. Calculate the Sharpe Ratio for the individual assets and the portfolios in questions 2 and 3, assuming the risk-free rate is 1.2%.

In: Finance

Distinguish and explain the differences between business and financial risk and provide an example from a...

Distinguish and explain the differences between business and financial risk and provide an example from a publicly traded company. Use specific examples and citations to support your assertion for business or financial risk.

In: Finance

Are there any advantages or disadvantages for a heavily indebted company that accumulated that debt following...

Are there any advantages or disadvantages for a heavily indebted company that accumulated that debt following a leveraged buyout during a workout process, i.e., a company in financial distress, compared with a publicly-traded company with significantly greater value of equity than debt? Answer as completely as possible.

In: Finance

A registrar/transfer agent system relating to capital stock is most likely used by: Multiple Choice All...

A registrar/transfer agent system relating to capital stock is most likely used by:

Multiple Choice

  • All companies must use this type of system.

  • A large, publicly traded company.

  • No companies use this system anymore.

  • A small, nonpublic company.

In: Accounting

The goal of a publicly traded company should be?a.Maximize earnings per shareb.Maximize...

The goal of a publicly traded company should be?


a.

Maximize earnings per share


b.

Maximize the book value


c.

Minimize Risk


d.

Maximize the value of a share of stock


e.

None of the above

In: Finance

How does the status of a company (privately held versus publicly traded) affect the relevancy of...

How does the status of a company (privately held versus publicly traded) affect the relevancy of capital structure? Explain why and use either a hypothetical or real world example to support your answer.

In: Finance

The cash flow from operations and cash flow from investing are both positive. Which of the...

The cash flow from operations and cash flow from investing are both positive. Which of the following best describes the situation?

2004

2005

Net income

$189

$170

Adjustments to reconcile net income to net cash provided by operating activities

Depreciation and amortization

201

173

Deferred income taxes

14

(20)

Restructuring charges

80

90

Accounts receivable

30

20

Inventory

(30)

50

Current liabilities

10

30

Cash flow from operations

494

513

Sale of equipment

200

300

Purchase of equipment

(130)

(120)

Cash flow from investing

70

180

Dividends

(120)

(130)

Long-term debt

(440)

(440)

Cash flow from financing

(560)

(570

A. The cash flow statement would indicate there are no reasons for concern.
B. Repayment of long-term debt indicates the company is becoming more profitable.
C. The company appears to be liquidating assets of the company that may affect future profitability.
D. Increased operating and investing cash flows in 2005, relative to 2004, indicate increased profitability in 2005.

In: Accounting

In 2005, Keenan Company paid dividends totaling $ 3,600,000 over a net profit of $ 10.8...

In 2005, Keenan Company paid dividends totaling $ 3,600,000 over a net profit of $ 10.8 million. It was a normal year and in the last 10 years, profits grew at a constant rate of 10%. But in 2006 it is expected to reach $ 14.4 million and that there are profitable investment opportunities for $ 8.4 million. It is anticipated that Keenan will not be able to maintain that level of growth - attributed to a new line of exceptionally profitable products that it introduced - and that the previous 10% growth rate will resume. The optimal debt ratio is 40 percent.
to. Calculate the total dividends in 2006, if you observe the following policies:
1) The 2006 dividend payment is established to make them grow at the same rate as that of profits.
2) The payment reason for 2005 continues.
3) A pure residual policy is applied, with all distributions through dividends (40% of the $ 8.4 million invested are financed with debt).
4) A policy of regular dividends plus extras is applied, in which dividends are based on the long-term growth rate and the extras are set in accordance with the residual policy.
b. Which of the above policies would you recommend? Limit your options to those included here and substantiate your response.
c. Does a dividend of $ 9,000,000 in 2006 seem reasonable in view of the responses to parts a and b? If not, should the dividend be higher or lower?

In: Finance