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
| 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 |
|
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 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 | $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 | 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 depreciate?
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?
3. Suppose that Canada imposes an import quota on automobiles. Which of the following describes the most likely effects of this quota?
4. Which of the following equations is the GDP identity in an open economy?
5. What does the market for loanable funds coordinate?
In: Economics
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 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 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 |
In: Finance