Questions
Century-Fox Corporation's employees are eligible for postretirement health care benefits after both being employed at the...

Century-Fox Corporation's employees are eligible for postretirement health care benefits after both being employed at the end of the year in which age 60 is attained and having worked 20 years. Jason Snyder was hired at the end of 1998 by Century-Fox at age 33 and is expected to retire at the end of 2026 (age 61). His retirement is expected to span five years (unrealistically short in order to simplify calculations). The company's actuary has estimated the net cost of retiree benefits in each retirement year as shown below. The discount rate is 5%. The plan is not prefunded. Assume costs are incurred at the end of each year. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) (Use appropriate factor(s) from the tables provided.) Year Expected Age Net Cost 2027 62 $ 4,100 2028 63 4,500 2029 64 2,400 2030 65 2,600 2031 66 2,900

Required:

2. Calculate the present value of the net benefits as of the expected retirement date.

3. With respect to Snyder, what is the company's expected postretirement benefit obligation at the end of 2021?

4. With respect to Snyder, what is the company's accumulated postretirement benefit obligation at the end of 2021?

5. With respect to Snyder, what is the company's accumulated postretirement benefit obligation at the end of 2022?

6. What is the service cost to be included in 2022 postretirement benefit expense?

7. What is the interest cost to be included in 2022 postretirement benefit expense?

8. Show how the APBO changed during 2022 by reconciling the beginning and ending balances.

In: Accounting

(20 pts) Use the “Distance.sav” (SPSS) data set (located below) to perform a linear regression analysis....

  1. (20 pts) Use the “Distance.sav” (SPSS) data set (located below) to perform a linear regression analysis. This dataset shows how far on average a person in Illinois drives each year. Write your findings using the format presented in the class slides. (2 pts) How much of the variation in the dependent variable is explained by the variation in the independent variable? What statistic did you use? (2 pts) Is the linear model significantly different than zero? Why or why not? What statistic did you use? (4 pts) Do the model assumptions hold? Why or why not? Provide a thorough response. (Hint: Create both a Histogram and a Normal probability plot using the standardized residuals. Also create a scatterplot of Regression Standardized Residuals and the Regression Standardized Predicted Value of the dependent variable. Attach a copy of each below.)
Year Distance
1960 1472.08
1961 1564.80
1962 1603.03
1963 1670.65
1964 1840.97
1965 1936.46
1966 2031.93
1967 2093.46
1968 2163.59
1969 2205.16
1970 2281.37
1971 2398.31
1972 2503.06
1973 2623.12
1974 2575.82
1975 2604.13
1976 2740.65
1977 2791.32
1978 2886.16
1979 2870.89
1980 3049.89
1981 3107.49
1982 3202.19
1983 3240.61
1984 3400.64
1985 3461.57
1986 3617.96
1987 3887.96
1988 4148.67
1989 4476.36
1990 4506.32
1991 4499.51
1992 4487.92
1993 4470.72
1994 4559.77
1995 4636.48
1996 4745.51
1997 4831.20
1998 4897.49
1999 4978.39
2000 4958.52
2001 5024.30
2002 5131.16
2003 5152.03

In: Statistics and Probability

Mortgage interest rates and home prices 30-year mortgage rates year interest rate (%) Median home price...

Mortgage interest rates and home prices

30-year mortgage rates

year

interest rate (%)

Median home price

1988

10.30

183,800

1989

10.30

183,200

1990

10.10

176,900

1991

9.30

173,500

1992

8.40

172,900

1993

7.30

173,200

1994

8.40

173,200

1995

7.90

169,700

1996

7.60

174,500

1997

7.60

177,900

1998

6.90

188,100

1999

7.40

203,200

2000

8.10

230,200

2001

7.00

258,200

2002

6.50

309,800

2003

5.50

329,800

1.    Generate two separate scatter plots, following the requirements below, with the data provide.
a.    year and interest rate
b.    year and median home price

2. Use your graphs and calculations to answer the questions on blackboard. If you are lost, please review the excel word document.

Assessment:

Now that you have reviewed how to create a graph in excel. Open the attached excel document and generate the required graphs. You will utilize the graphs to answer the post lab questions below. Provide all your answer with two decimal places.

1. For the year and interest rate graph, what is the slope and the y intercept?

2. For the year and median home price, what is the slope and the y intercept?

3. Does the linear equation provided from the Year vs. Median Home graph, provide a highly recommended estimate for future home values? Explain your answer.

4. What is the expected median home price in 2019, based on the data from 1996 to 2003?

5. In what year will the interest rate reach 3.50%? (Round to the nearest year.)

In: Statistics and Probability

1) Using the excel data file “US violent crime” which shows the violent crime rate in...

1) Using the excel data file “US violent crime” which shows the violent crime rate in the US from 1960 to 2012:

(20 pts) Make a time series plot of the data

(5 pts each 25 pts total) Determine the following: Mean, Median, Standard deviation, Q1 and Q3. (25 pts)

Make a histogram of the data. Hint the year is not used, you need to determine how many years fall into each of the classes.

(7) What are your thoughts on the time series plot, i.e. trends etc.?

(8) Thoughts on the histogram i.e. shape of distribution etc.?

[Excel sheet]

Year Violent Crime rate
1960 160.9
1961 158.1
1962 162.3
1963 168.2
1964 190.6
1965 200.2
1966 220.0
1967 253.2
1968 298.4
1969 328.7
1970 363.5
1971 396.0
1972 401.0
1973 417.4
1974 461.1
1975 487.8
1976 467.8
1977 475.9
1978 497.8
1979 548.9
1980 596.6
1981 593.5
1982 570.8
1983 538.1
1984 539.9
1985 558.1
1986 620.1
1987 612.5
1988 640.6
1989 666.9
1990 729.6
1991 758.2
1992 757.7
1993 747.1
1994 713.6
1995 684.5
1996 636.6
1997 611.0
1998 567.6
1999 523.0
2000 506.5
2001 504.5
2002 494.4
2003 475.8
2004 463.2
2005 469.0
2006 479.3
2007 471.8
2008 458.6
2009 431.9
2010 404.5
2011 387.1
2012 386.9

In: Statistics and Probability

Average Oil Prices Year Price per Barrel 1949 $2.54 1950 $2.51 1951 $2.53 1952 $2.53 1953...

Average Oil Prices
Year Price per Barrel
1949 $2.54
1950 $2.51
1951 $2.53
1952 $2.53
1953 $2.68
1954 $2.78
1955 $2.77
1956 $2.79
1957 $3.09
1958 $3.01
1959 $2.90
1960 $2.88
1961 $2.89
1962 $2.90
1963 $2.89
1964 $2.88
1965 $2.86
1966 $2.88
1967 $2.92
1968 $2.94
1969 $3.09
1970 $3.18
1971 $3.39
1972 $3.39
1973 $3.89
1974 $6.87
1975 $7.67
1976 $8.19
1977 $8.57
1978 $9.00
1979 $12.64
1980 $21.59
1981 $31.77
1982 $28.52
1983 $26.19
1984 $25.88
1985 $24.09
1986 $12.51
1987 $15.40
1988 $12.58
1989 $15.86
1990 $20.03
1991 $16.54
1992 $15.99
1993 $14.25
1994 $13.19
1995 $14.62
1996 $18.46
1997 $17.23
1998 $10.87
1999 $15.56
2000 $26.72
2001 $21.84
2002 $22.51
2003 $27.54
2004 $38.93
2005 $46.47
2006 $58.30
2007 $64.67
2008 $91.48
2009 $53.48
2010 $71.21
2011 $87.04
2012 $93.02
2013 $97.91
2014 $93.26
2015 $48.69
2016 $43.14
2017 $50.88

a) Using the 1949 oil price and the 1969 oil price, compute the annual growth rate in oil prices during the 20 yr period. b) Compute the growth rate between 1969 & 1989 and between 1989 & 2017. c) given the price in 2017 and your growth rate between 1989 and 2017 compute the future price of oil in 2020 & 2025.

In: Finance

Year Population in Millions GDP in Trillions of US$ 2014 318.86 16.29 2011 311.72 15.19 2010...

Year Population in Millions GDP in Trillions of US$
2014 318.86 16.29
2011 311.72 15.19
2010 309.35 14.94
2009 306.77 14.54
2008 304.09 14.58
2006 298.38 14.72
2004 292.81 13.95
2003 290.11 13.53
2002 287.63 12.96
2001 284.97 12.71
2000
1999 279.04 12.32
1998 275.85 11.77
1990 249.62 8.91
1989 246.82 8.85
1987 242.29 8.29
1986 240.13 7.94
1985 237.92 7.71
1984 235.82 7.4
1982 231.66 6.49
1981 229.47 6.59
1980 6.5
1979 225.06 6.5
1977 220.24 6.02
1976 218.04 5.73
1975 215.97 5.49
1973 211.91 5.46
1972 209.9 5.25
1964 191.89 3.78
1963 189.24 3.6
1962 186.54 3.42
1961 183.69 3.28
1959 177.83 3.06
1958 174.88 2.92
1957 171.98 2.85
1956 168.9 2.84
1954 163.03 2.61
1953 160.18 2.54
1952 157.55 2.53
1951 154.88 2.4
1950 152.27 2.27
1949 149.19 2
1948 146.63 2.04
1947 144.13 1.96

Answer the following question using R:

(a) Use linear regression to estimate the GDP of the missing years 1955 and 1960. Use the Population estimate for the missing years found using M1.

(b) Create a new data frame showing Population and GDP from 1947 to 1964 including the values for 1955 and 1960 predicted by regression models M1 and M2.

(c) Use this data frame (b) to plot the GDP and Population in a scatter plot for the years 1947 -1964, clearly marking the missing years in the original data

In: Economics

1. Which of the following would cause the real exchange rate of the Canadian dollar to...

1. Which of the following would cause the real exchange rate of the Canadian dollar to depreciate?

  1. an increase in the Canadian government budget deficit
  2. capital flight from Canada
  3. the imposition of Canadian government import quotas
  4. a decrease in the world interest rate

2. The 1998 default by the Russian government had results that were predictable using the textbook model.

Which of the following best describes what happened?

  1. The event increased Russian interest rates and net exports.
  2. The event reduced Russian interest rates and net exports.
  3. The event increased Russian interest rates and reduced Russian net exports.
  4. The event reduced Russian interest rates and increased Russian net exports.

3. Suppose that Canada imposes an import quota on automobiles. Which of the following describes the most likely effects of this quota?

  1. The quota would cause the real exchange rate of Canadian dollars to appreciate, but it would not change the real interest rate in Canada.
  2. The quota would cause the real exchange rate of Canadian dollars to appreciate and the real interest rate in Canada to increase.
  3. The quota would cause the real exchange rate of Canadian dollars to depreciate and the real interest rate in Canada to decrease.
  4. The quota would cause the real exchange rate of Canadian dollars to depreciate, but it would not change the real interest rate in Canada.

4. Which of the following equations is the GDP identity in an open economy?

  1. Y = C + I + G + NCO
  2. NX = -NCO
  3. NCO = S - I+NX
  4. Y = C + I + G - NX

5. What does the market for loanable funds coordinate?

  1. supply and demand for dollars in the foreign exchange market
  2. people who want to import or export goods
  3. sellers and buyers
  4. lenders and borrowers

In: Economics

The following table provides the project annual budget, total number of projects, and total number of...

The following table provides the project annual budget, total number of projects, and total number of people working on the projects for City of Killingcovid annually:

Year

Annual Budget

(in millions)

Number of Projects

Number of People Working on the Projects

1997

9.93

2

6

1998

7.34

8

47

1999

6.82

4

134

2000

7

2

291

2001

7.31

7

279

2002

7.86

6

82

2003

8.44

4

65

2004

7.61

5

34

2005

7.8

1

14

2006

8.6

4

249

2007

8.25

2

174

2008

8.7

3

346

2009

10.89

2

3

2010

10.53

1

8

2011

11.77

2

13

2012

11.44

4

24

2013

10.95

6

534

2014

11.12

2

6

2015

10.73

2

28

2016

11.39

1

18

2017

11.3

3

25

2018

11.27

2

54

For A to F, use the data between Yr 2006 and Yr 2015 to calculate the following:

A. The mean of the Number of People Working on the Project.
B. The median of the Budget.
C. The range of Budget.
D. The variance (3 significant figures) of Number of Projects.
E. The standard deviation (nearest integer) of Number of People Working on the Project.
F. The 20% trimmed mean of Number of Projects.

G. Draw a dot plot comparing the Number of People Working on the Project from Yr 1997 to Yr 2006 and those from Yr 2009 to Yr 2018.

H. Using the data for Annual Budget from Yr 2001 to Yr 2017, draw a double stem leaf plot, then calculate the relative frequency.

In: Economics

CARDWARE Inc. plans to take over First Class Purses & Accessories (FCPA) in an effort to...

CARDWARE Inc. plans to take over First Class Purses & Accessories (FCPA) in an effort to coordinate elegant CARDWARE professional attire with items from FCPA that will complement CARDWARE's fashion designs. Darla, owner of Darla's Dummies, a mannequin manufacturer whom CARDWARE had used on numerous occasions happened to be delivering mannequins to CARDWARE's principal place of business in Silkadonia. As she was bringing the last of the dummies down the hall to the room where the dummies are dressed, she paused to listen to a conversation coming from one of the open doors of the hallway she was using. Realizing that a profit could be made from FCPA's stock, Darla called her broker and indicated that she wanted to purchase 50 % of the outstanding stock that was available for FCPA. Darla bought 2,000 shares of stock at $30 a share.

CARDWARE offered $50 a share and ultimately ended up paying $65 per share for FCPA stock. Darla was no dummy, as she made a $70,000 profit on her stock purchase.

The Securities and Exchange Commission (SEC) filed a suit in a federal district court against Darla and others for alleged violations of, among other things, SEC Rule 10b-5. [SEC v. Falbo 14 F.Supp.2d 508 (S.D.N.Y. 1998)]

Discuss the following, justifying your response using information from your Reading

1. Under what theory might Darla be liable?

2. Do the circumstances of this case meet all of the requirements for liability under that theory? Explain.

3. Examine the SEC Rule 10b-5.

4. Discuss whether or not Darla was liable under the misappropriation theory.

In: Operations Management

You have been hired as an analyst for Mellon Bank and your team is working on...

You have been hired as an analyst for Mellon Bank and your team is working on an independent assessment of Daffy Duck Food Inc. (DDF Inc.) DDF Inc. is a firm that specializes in the production of freshly imported farm products from France. Your assistant has provided you with the following data for Flipper Inc and their industry.

Ratio

1999

1998

1997

1999-

Industry Average

Long-term debt

0.45

0.40

0.35

0.35

Inventory Turnover

62.65

42.42

32.25

53.25

Depreciation/Total Assets

0.25

0.014

0.018

0.015

Days’ sales in receivables

113

98

94

130.25

Debt to Equity

0.75

0.85

0.90

0.88

Profit Margin

0.082

0.07

0.06

0.075

Total Asset Turnover

0.54

0.65

0.70

0.40

Quick Ratio

1.028

1.03

1.029

1.031

Current Ratio

1.33

1.21

1.15

1.25

Times Interest Earned

0.9

4.375

4.45

4.65

Equity Multiplier

1.75

1.85

1.90

1.88

  1. In the annual report to the shareholders, the CEO of Flipper Inc wrote, “1997 was a good year for the firm with respect to our ability to meet our short-term obligations. We had higher liquidity largely due to an increase in highly liquid current assets (cash, account receivables and short-term marketable securities).” Is the CEO correct? Explain and use only relevant information in your analysis.
  1. What can you say about the firm's asset management? Be as complete as possible given the above information, but do not use any irrelevant information.
  1. You are asked to provide the shareholders with an assessment of the firm's solvency and leverage. Be as complete as possible given the above information, but do not use any irrelevant information.

In: Finance