Determine if the data on petroleum imports provided in Assignment 1 follows a normal distribution.
| Year | Petroleum Imports (thousands of barrels per day) |
| 1973 | 6256 |
| 1974 | 6112 |
| 1975 | 6055 |
| 1976 | 7313 |
| 1977 | 8807 |
| 1978 | 8363 |
| 1979 | 8456 |
| 1980 | 6909 |
| 1981 | 5996 |
| 1982 | 5113 |
| 1983 | 5051 |
| 1984 | 5437 |
| 1985 | 5067 |
| 1986 | 6224 |
| 1987 | 6678 |
| 1988 | 7402 |
| 1989 | 8061 |
| 1990 | 8018 |
| 1991 | 7627 |
| 1992 | 7888 |
| 1993 | 8620 |
| 1994 | 8996 |
| 1995 | 8835 |
| 1996 | 9478 |
| 1997 | 10162 |
| 1998 | 10708 |
| 1999 | 10852 |
| 2000 | 11459 |
| 2001 | 11871 |
| 2002 | 11530 |
| 2003 | 12264 |
| 2004 | 13145 |
| 2005 | 13714 |
| 2006 | 13707 |
| 2007 | 13468 |
| 2008 | 12915 |
In: Statistics and Probability
2. The accompanying data table show the percentage of tax returns filed electronically in a city from 2000 to 2009. Complete the parts below.
Year Percentage
2000 27
2001 29
2002 35
2003 42
2004 45
2005 49
2006 55
2007 59
2008 61
2009 67
|
a) |
Forecast the percentage of tax returns that will be electronically filed for 2010 using exponential smoothing with a=0.2 (Round to the nearest integer as needed.) |
b) Calculate the MAD for the forecast in part a. (Round to two decimal places as needed.)
|
c) |
The percentage of tax returns that will be electronically filed for 2010 using exponential smoothing with trend adjustment using a=0.3 and b=0.6 is? (Round to the nearest integer as needed.) |
d) Calculate the MAD for the forecast in part c (Round to two decimal places as needed.)
In: Statistics and Probability
Please show all steps using data set below and excel.
Total Houses Sold
| Year | Northeast | |
| 1996 | 74.00 | |
| 1997 | 78.00 | |
| 1998 | 81.00 | |
| 1999 | 76.00 | |
| 2000 | 71.00 | |
| 2001 | 66.00 | |
| 2002 | 65.00 | |
| 2003 | 79.00 | |
| 2004 | 83.00 | |
| 2005 | 81.00 | |
| 2006 | 63.00 | |
| 2007 | 65.00 | |
| 2008 | 35.00 | |
| 2009 | 31.00 | |
| 2010 | 31.00 | |
| 2011 | 21.00 | |
| 2012 | 29.00 | |
| 2013 | 31.00 | |
| 2014 | 28.00 | |
| 2015 | 24.00 | |
| 2016 | 32.00 |
In: Statistics and Probability
Despite the growth in digital entertainment, the nation’s 400 amusement parks have managed to hold on to visitors. A manager collects data on the number of visitors (in millions) to amusement parks in the United States. A portion of the data is shown in the accompanying table.
| Year | Visitors |
| 2000 | 329 |
| 2001 | 319 |
| ⋮ | ⋮ |
| 2007 | 333 |
SOURCE: International Association of Amusement Parks and
Attractions.
Click here for the Excel Data File
| Year | Visitors |
| 2000 | 329 |
| 2001 | 319 |
| 2002 | 308 |
| 2003 | 302 |
| 2004 | 308 |
| 2005 | 319 |
| 2006 | 357 |
| 2007 | 333 |
a. Estimate the linear trend model to make forecasts for 2008. (Round your answers to 2 decimal places.)
yˆ =
b. Estimate the exponential trend model to make
forecasts for 2008. (Round your answers to 2 decimal
places.)
yˆ =
In: Statistics and Probability
Consider the following realized annual returns:
|
Year End |
Market Realized Return |
Stock B Realized Return |
|
2000 |
21.2% |
88.3% |
|
2001 |
30.3% |
56.4% |
|
2002 |
22.3% |
114.6% |
|
2003 |
25.3% |
68.4% |
|
2004 |
-11.0% |
-62.8% |
|
2005 |
-11.3% |
52.7% |
|
2006 |
-20.8% |
-22.0% |
|
2007 |
33.1% |
6.9% |
|
2008 |
13.0% |
9.2% |
|
2009 |
7.3% |
-0.9% |
Q1 : Suppose that you want to use the 10 year historical average return on the Market to forecast the expected future return on the Market. Calculate the 95% confidence interval for your estimate of the expect return. Q2 : Using the data provided in the table, calculate the average annual return, the variance of the annual returns, and the standard deviation of the average returns for Stock B from 2000 to 2009.
In: Finance
I don't really understand how to estimate revenue. I have been given revenues from previous years and I am being asked to estimate the revenue for FY2020 and explain my rationale. Please help thank you! Please show all relevant work so I can understand how you got to the answer. Thank you!
PS: if possible please use regression including a graph.
| Year | Revenue Collections |
| 2002 | $ 329,687 |
| 2003 | $ 384,829 |
| 2004 | $ 378,109 |
| 2005 | $ 447,858 |
| 2006 | $ 523,845 |
| 2007 | $ 621,253 |
| 2008 | $ 824,460 |
| 2009 | $ 739,140 |
| 2010 | $ 821,729 |
| 2011 | $ 1,035,700 |
| 2012 | $ 901,902 |
| 2013 | $ 867,344 |
| 2014 | $ 857,415 |
| 2015 | $ 885,966 |
| 2016 | $ 963,744 |
| 2017 | $ 1,141,337 |
| 2018 | $ 1,201,877 |
| 2019 | $ 1,116,045 |
| 2020 |
In: Finance
A program at SF State is concerned about their graduation rates. Every year they enroll 400 junior-level students, and they’ve been tracking the percent who manage to finish (graduate from) the program in a timely manner. Below are the data for the past 8 years. Express all calculations to 3 significant figures: ie. 12.3% or 0.123 (also 3-decimal spaces).
|
year |
2000 |
2001 |
2002 |
2003 |
2004 |
2005 |
2006 |
2007 |
|
ontime grads |
230 |
215 |
250 |
225 |
245 |
220 |
235 |
205 |
Are we in control, give the control
In: Operations Management
George and June are active volunteers in their local church. George serves as an usher one Sunday morning a month. June sings in the church choir every Sunday morning and attends choir practice each Wednesday evening. Based on the distance from their home to church, June drives 500 miles a year to attend choir practice and sing on Sunday. George leaves home by himself to arrive at church early on the mornings he serves as an usher and put 120 miles on his car this year on these trips. June paid $1,000 for singing lessons to improve her voice so that she might be chosen to sing a solo at church. Are any of these expenses related to serving as an usher or singing in the church choir deductible by George or June?
In: Accounting
please asnwer all parts of question 5
| Date | Yearmonth | SP500 | WMT | MSFT | MGM | CERN | XOM |
| 12/3/2012 | 201212 | 1426.19 | 65.33 | 25.39 | 11.64 | 38.76 | 82.52 |
| 11/1/2012 | 201211 | 1416.18 | 68.58 | 25.31 | 10.15 | 38.61 | 84.03 |
| 10/1/2012 | 201210 | 1412.16 | 71.43 | 26.91 | 10.31 | 38.1 | 86.38 |
| 9/4/2012 | 201209 | 1440.67 | 70.27 | 28.06 | 10.75 | 38.69 | 86.65 |
| 8/1/2012 | 201208 | 1406.58 | 69.13 | 29.06 | 9.86 | 36.57 | 82.72 |
| 7/2/2012 | 201207 | 1379.32 | 70.49 | 27.61 | 9.52 | 36.96 | 81.76 |
| 6/1/2012 | 201206 | 1362.16 | 66.03 | 28.66 | 11.16 | 41.33 | 80.55 |
| 5/1/2012 | 201205 | 1310.33 | 62.34 | 27.34 | 10.83 | 38.98 | 74.02 |
| 4/2/2012 | 201204 | 1397.91 | 55.42 | 29.8 | 13.42 | 40.56 | 80.72 |
| 3/1/2012 | 201203 | 1408.47 | 57.57 | 30.02 | 13.62 | 38.08 | 81.09 |
| 2/1/2012 | 201202 | 1365.68 | 55.21 | 29.54 | 13.77 | 36.92 | 80.87 |
| 1/3/2012 | 201201 | 1312.41 | 57.34 | 27.3 | 13.05 | 30.44 | 77.86 |
| 12/1/2011 | 201112 | 1257.6 | 55.84 | 24 | 10.43 | 30.62 | 78.81 |
| 11/1/2011 | 201111 | 1246.96 | 54.7 | 23.65 | 10.29 | 30.49 | 74.8 |
| 10/3/2011 | 201110 | 1253.3 | 52.67 | 24.44 | 11.52 | 31.72 | 72.18 |
| 9/1/2011 | 201109 | 1131.42 | 48.2 | 22.84 | 9.29 | 34.26 | 67.13 |
| 8/1/2011 | 201108 | 1218.89 | 49.39 | 24.41 | 11.07 | 32.98 | 68.42 |
| 7/1/2011 | 201107 | 1292.28 | 48.6 | 24.99 | 15.11 | 33.24 | 73.27 |
| 6/1/2011 | 201106 | 1320.64 | 48.99 | 23.71 | 13.21 | 30.56 | 74.73 |
| 5/2/2011 | 201105 | 1345.2 | 50.91 | 22.81 | 15.07 | 30.02 | 76.65 |
| 4/1/2011 | 201104 | 1363.61 | 50.36 | 23.48 | 12.66 | 30.05 | 80.33 |
| 3/1/2011 | 201103 | 1325.83 | 47.67 | 23 | 13.15 | 27.8 | 76.82 |
| 2/1/2011 | 201102 | 1327.22 | 47.28 | 24.08 | 13.94 | 25.11 | 78.1 |
| 1/3/2011 | 201101 | 1286.12 | 51 | 24.97 | 14.83 | 24.71 | 73.28 |
| 12/1/2010 | 201012 | 1257.64 | 49.05 | 25.14 | 14.85 | 23.68 | 66.42 |
| 11/1/2010 | 201011 | 1180.55 | 48.93 | 22.75 | 12.22 | 21.97 | 63.18 |
| 10/1/2010 | 201010 | 1183.26 | 49 | 23.87 | 10.93 | 21.96 | 60.02 |
| 9/1/2010 | 201009 | 1141.2 | 48.41 | 21.92 | 11.28 | 21 | 55.77 |
| 8/2/2010 | 201008 | 1049.33 | 45.35 | 21.01 | 9.01 | 18.21 | 53.35 |
| 7/1/2010 | 201007 | 1101.6 | 46.03 | 22.98 | 10.86 | 19.36 | 53.49 |
| 6/1/2010 | 201006 | 1030.71 | 43.23 | 20.49 | 9.64 | 18.97 | 51.15 |
| 5/3/2010 | 201005 | 1089.41 | 45.47 | 22.97 | 12.46 | 20.93 | 54.18 |
| 4/1/2010 | 201004 | 1186.69 | 47.96 | 27.07 | 15.89 | 21.19 | 60.33 |
| 3/1/2010 | 201003 | 1169.43 | 49.71 | 25.96 | 12 | 21.23 | 59.62 |
| 2/1/2010 | 201002 | 1104.49 | 48.07 | 25.41 | 10.54 | 20.74 | 57.86 |
| 1/4/2010 | 201001 | 1073.87 | 47.5 | 24.86 | 11.06 | 18.92 | 56.98 |
| 12/1/2009 | 200912 | 1115.1 | 47.52 | 26.89 | 9.12 | 20.61 | 60.31 |
| 11/2/2009 | 200911 | 1095.63 | 48.26 | 25.95 | 10.57 | 18.82 | 66.39 |
| 10/1/2009 | 200910 | 1036.19 | 43.95 | 24.36 | 9.27 | 19.01 | 63.02 |
| 9/1/2009 | 200909 | 1057.08 | 43.43 | 22.59 | 12.04 | 18.7 | 60.33 |
| 8/3/2009 | 200908 | 1020.62 | 45 | 21.65 | 8.47 | 15.43 | 60.8 |
| 7/1/2009 | 200907 | 987.48 | 43.88 | 20.54 | 7.23 | 16.27 | 61.52 |
| 6/1/2009 | 200906 | 919.32 | 42.62 | 20.76 | 6.39 | 15.57 | 61.1 |
| 5/1/2009 | 200905 | 919.14 | 43.76 | 18.25 | 7.46 | 14.57 | 60.61 |
| 4/1/2009 | 200904 | 872.81 | 44.1 | 17.58 | 8.38 | 13.45 | 57.92 |
| 3/2/2009 | 200903 | 797.87 | 45.59 | 15.94 | 2.33 | 10.99 | 59.16 |
| 2/2/2009 | 200902 | 735.09 | 42.85 | 14.02 | 3.5 | 9.15 | 58.99 |
| 1/2/2009 | 200901 | 825.88 | 41 | 14.74 | 8 | 8.43 | 66.11 |
| 12/1/2008 | 200812 | 903.25 | 48.78 | 16.76 | 13.76 | 9.61 | 69 |
| 11/3/2008 | 200811 | 896.24 | 48.42 | 17.43 | 11.98 | 8.99 | 69.28 |
| 10/1/2008 | 200810 | 968.75 | 48.35 | 19.12 | 16.46 | 9.31 | 63.7 |
| 9/2/2008 | 200809 | 1166.36 | 51.89 | 22.85 | 28.5 | 11.16 | 66.75 |
| 8/1/2008 | 200808 | 1282.83 | 51.18 | 23.37 | 35.19 | 11.51 | 68.77 |
| 7/1/2008 | 200807 | 1267.38 | 50.59 | 21.94 | 29.02 | 11.16 | 68.77 |
| 6/2/2008 | 200806 | 1280 | 48.5 | 23.46 | 33.89 | 11.3 | 75.36 |
| 5/1/2008 | 200805 | 1400.38 | 49.83 | 24.15 | 49.21 | 11.34 | 75.9 |
| 4/1/2008 | 200804 | 1385.59 | 49.82 | 24.23 | 51.15 | 11.57 | 79.23 |
| 3/3/2008 | 200803 | 1322.7 | 45.27 | 24.12 | 58.77 | 9.32 | 72 |
| 2/1/2008 | 200802 | 1330.63 | 42.41 | 23.11 | 61.59 | 10.86 | 74.07 |
| 1/2/2008 | 200801 | 1378.55 | 43.4 | 27.59 | 72.72 | 13.1 | 72.64 |
| 12/3/2007 | 200712 | 1468.36 | 40.65 | 30.13 | 84.02 | 14.1 | 79.41 |
| 11/1/2007 | 200711 | 1481.14 | 40.78 | 28.44 | 86.5 | 14.94 | 75.57 |
| 10/1/2007 | 200710 | 1549.38 | 38.49 | 31.05 | 91.61 | 14.89 | 77.67 |
| 9/4/2007 | 200709 | 1526.75 | 37.16 | 24.85 | 89.44 | 14.95 | 78.15 |
| 8/1/2007 | 200708 | 1473.99 | 37.15 | 24.24 | 83.97 | 14.26 | 72.39 |
| 7/2/2007 | 200707 | 1455.27 | 38.93 | 24.37 | 73.11 | 13.22 | 71.59 |
| 6/1/2007 | 200706 | 1503.35 | 40.76 | 24.78 | 82.48 | 13.87 | 70.54 |
| 5/1/2007 | 200705 | 1530.62 | 40.32 | 25.8 | 79.53 | 14.2 | 69.94 |
| 4/2/2007 | 200704 | 1482.37 | 40.41 | 25.09 | 67.25 | 13.31 | 66.47 |
| 3/1/2007 | 200703 | 1420.86 | 39.59 | 23.35 | 69.52 | 13.61 | 63.18 |
| 2/1/2007 | 200702 | 1406.82 | 40.54 | 23.61 | 71.06 | 13.03 | 60.02 |
| 1/3/2007 | 200701 | 1438.24 | 40.02 | 25.77 | 69.97 | 11.23 | 61.79 |
| 12/1/2006 | 200612 | 1418.3 | 38.75 | 24.94 | 57.35 | 11.38 | 63.9 |
| 11/1/2006 | 200611 | 1400.63 | 38.54 | 24.52 | 53.77 | 12.01 | 64.05 |
| 10/2/2006 | 200610 | 1377.94 | 41.2 | 23.89 | 43.02 | 12.08 | 59.29 |
| 9/1/2006 | 200609 | 1335.85 | 41.24 | 22.76 | 39.49 | 11.35 | 55.71 |
| 8/1/2006 | 200608 | 1303.82 | 37.39 | 21.39 | 35.68 | 11.52 | 56.18 |
| 7/3/2006 | 200607 | 1276.66 | 37.07 | 19.95 | 35.54 | 10.12 | 55.98 |
| 6/1/2006 | 200606 | 1270.2 | 40.12 | 19.32 | 40.8 | 9.28 | 50.7 |
| 5/1/2006 | 200605 | 1270.09 | 40.36 | 18.78 | 41.46 | 9.49 | 50.33 |
| 4/3/2006 | 200604 | 1310.61 | 37.38 | 19.95 | 44.9 | 9.91 | 51.87 |
| 3/1/2006 | 200603 | 1294.87 | 39.21 | 22.47 | 43.09 | 11.86 | 50.04 |
| 2/1/2006 | 200602 | 1280.66 | 37.51 | 22.19 | 36.97 | 10.41 | 48.82 |
| 1/3/2006 | 200601 | 1280.08 | 38.13 | 23.17 | 37.06 | 11.25 | 51.32 |
| 12/1/2005 | 200512 | 1248.29 | 38.7 | 21.53 | 36.67 | 11.36 | 45.94 |
| 11/1/2005 | 200511 | 1249.48 | 40.04 | 22.79 | 38.11 | 12.05 | 47.46 |
| 10/3/2005 | 200510 | 1207.01 | 39.01 | 21.09 | 37.37 | 10.56 | 45.68 |
| 9/1/2005 | 200509 | 1228.81 | 36.13 | 21.12 | 43.77 | 10.87 | 51.71 |
| 8/1/2005 | 200508 | 1220.33 | 37.07 | 22.47 | 42.26 | 9.85 | 48.74 |
| 7/1/2005 | 200507 | 1234.18 | 40.56 | 20.96 | 45.45 | 9.43 | 47.57 |
| 6/1/2005 | 200506 | 1191.33 | 39.61 | 20.33 | 39.58 | 8.5 | 46.54 |
| 5/2/2005 | 200505 | 1191.5 | 38.82 | 21.11 | 38.09 | 8.17 | 45.51 |
| 4/1/2005 | 200504 | 1156.85 | 38.62 | 20.64 | 34.9 | 7.26 | 45.95 |
| 3/1/2005 | 200503 | 1180.59 | 41.05 | 19.72 | 35.41 | 6.56 | 48.02 |
| 2/1/2005 | 200502 | 1203.6 | 42.16 | 20.52 | 37.08 | 6.51 | 51.01 |
| 1/3/2005 | 200501 | 1181.27 | 42.8 | 21.37 | 35.9 | 6.22 | 41.37 |
| 12/1/2004 | 200412 | 1211.92 | 43.15 | 21.73 | 36.37 | 6.65 | 41.1 |
| 11/1/2004 | 200411 | 1173.82 | 42.42 | 21.8 | 29.15 | 6.59 | 41.09 |
| 10/1/2004 | 200410 | 1130.2 | 43.94 | 20.41 | 26.9 | 5.64 | 39.25 |
| 9/1/2004 | 200409 | 1114.58 | 43.35 | 20.18 | 24.83 | 5.41 | 38.54 |
| 8/2/2004 | 200408 | 1104.24 | 42.92 | 19.92 | 20.67 | 5.48 | 36.76 |
| 7/1/2004 | 200407 | 1101.72 | 43.09 | 20.73 | 22.08 | 5.62 | 36.7 |
| 6/1/2004 | 200406 | 1140.84 | 42.68 | 20.78 | 23.47 | 5.57 | 35.2 |
| 5/3/2004 | 200405 | 1120.68 | 45.31 | 19.08 | 22.2 | 5.35 | 34.28 |
| 4/1/2004 | 200404 | 1107.3 | 46.23 | 19.01 | 22.91 | 5.35 | 33.51 |
| 3/1/2004 | 200403 | 1126.21 | 48.41 | 18.14 | 22.67 | 5.64 | 32.76 |
| 2/2/2004 | 200402 | 1144.94 | 48.2 | 19.3 | 21.77 | 5.59 | 33.21 |
| 1/2/2004 | 200401 | 1131.13 | 43.58 | 20.12 | 20.2 | 4.9 | 31.93 |
| 12/1/2003 | 200312 | 1111.92 | 42.93 | 19.91 | 18.81 | 4.73 | 32.09 |
| 11/3/2003 | 200311 | 1058.2 | 44.95 | 18.7 | 18.74 | 5.58 | 28.33 |
| 10/1/2003 | 200310 | 1050.71 | 47.62 | 19.02 | 17.75 | 5.3 | 28.43 |
| 9/2/2003 | 200309 | 995.97 | 45.04 | 20.11 | 18.27 | 3.86 | 28.45 |
| 8/1/2003 | 200308 | 1008.01 | 47.72 | 19.19 | 18.13 | 4.41 | 29.3 |
| 7/1/2003 | 200307 | 990.31 | 45.09 | 19.11 | 17.15 | 3.96 | 27.47 |
| 6/2/2003 | 200306 | 974.5 | 43.29 | 18.55 | 17.09 | 2.85 | 27.72 |
| 5/1/2003 | 200305 | 963.59 | 42.36 | 17.8 | 14.12 | 2.64 | 28.1 |
| 4/1/2003 | 200304 | 916.92 | 45.35 | 18.5 | 14.21 | 2.5 | 26.98 |
| 3/3/2003 | 200303 | 848.18 | 41.89 | 17.52 | 14.62 | 4.05 | 26.79 |
| 2/3/2003 | 200302 | 841.15 | 38.63 | 17.15 | 12.81 | 4.15 | 26.08 |
| 1/2/2003 | 200301 | 855.7 | 38.42 | 17.11 | 13.1 | 4.61 | 26 |
| 12/2/2002 | 200212 | 879.82 | 40.6 | 18.64 | 16.49 | 3.91 | 26.6 |
| 11/1/2002 | 200211 | 936.31 | 43.26 | 20.8 | 16.91 | 4.11 | 26.49 |
| 10/1/2002 | 200210 | 885.76 | 42.98 | 19.28 | 15.55 | 4.45 | 25.46 |
| 9/3/2002 | 200209 | 815.28 | 39.52 | 15.77 | 18.65 | 4.4 | 24.13 |
| 8/1/2002 | 200208 | 916.07 | 42.87 | 17.7 | 17.75 | 4.67 | 26.81 |
| 7/1/2002 | 200207 | 911.62 | 39.42 | 17.3 | 17.5 | 5.43 | 27.63 |
| 6/3/2002 | 200206 | 989.82 | 44.09 | 19.72 | 16.88 | 5.98 | 30.75 |
| 5/1/2002 | 200205 | 1067.14 | 43.31 | 18.36 | 18.84 | 6.8 | 30.01 |
| 4/1/2002 | 200204 | 1076.92 | 44.72 | 18.84 | 20.08 | 6.64 | 30.01 |
| 3/1/2002 | 200203 | 1147.39 | 49.07 | 21.75 | 18.11 | 5.96 | 32.75 |
| 2/1/2002 | 200202 | 1106.73 | 49.58 | 21.04 | 17.2 | 5.43 | 30.86 |
| 1/2/2002 | 200201 | 1130.2 | 47.96 | 22.97 | 16.28 | 6.05 | 29.01 |
| 12/3/2001 | 200112 | 1148.08 | 46.01 | 23.89 | 14.44 | 6.24 | 29.19 |
| 11/1/2001 | 200111 | 1139.45 | 44.04 | 23.15 | 13.18 | 6.61 | 27.78 |
| 10/1/2001 | 200110 | 1059.78 | 41.04 | 20.97 | 11.15 | 6.72 | 29.13 |
| 9/4/2001 | 200109 | 1040.94 | 39.53 | 18.45 | 11.24 | 6.19 | 29.09 |
| 8/1/2001 | 200108 | 1133.58 | 38.31 | 20.57 | 14.57 | 6.06 | 29.65 |
| 7/2/2001 | 200107 | 1211.23 | 44.57 | 23.87 | 15.45 | 7.04 | 30.67 |
| 6/1/2001 | 200106 | 1224.38 | 38.91 | 26.32 | 14.98 | 5.25 | 32.07 |
| 5/1/2001 | 200105 | 1255.82 | 41.2 | 24.94 | 15.72 | 5.24 | 32.58 |
| 4/2/2001 | 200104 | 1249.46 | 41.19 | 24.43 | 15.03 | 5.63 | 32.36 |
| 3/1/2001 | 200103 | 1160.33 | 40.21 | 19.72 | 12.55 | 4.28 | 29.59 |
| 2/1/2001 | 200102 | 1239.94 | 39.82 | 21.27 | 13.44 | 6.4 | 29.61 |
| 1/2/2001 | 200101 | 1366.01 | 45.16 | 22.02 | 14.53 | 6.04 | 30.58 |
Question 5: Use Data5 Sheet
This sheet reports monthly value of SP500 index and prices of 5 stocks.
REMEMBER to check the timeline order.
Based on the whole data, create a table reporting the average monthly Return and Total Risk for each of the following stocks:
Put both Risk and Return in percentage format (say 12.56%)
|
WMT |
MSFT |
MGM |
CERN |
XOM |
(For Total Risk, you use the Standard Deviation based on a Sample – STDEV.S)
Return=Price(t)/Price(t-1)-1
5a. Report ticker of the stock with the highest average monthly return
5b. Report ticker of the stock with the highest total risk
5c. If you can only invest in 01 stock for only 1 month, which stock and which yearmonth will you choose to maximize your return.
Put in the answer sheet that the ticker (in Cap) and year month continuously, say MGM200103.
In: Finance
James, a resident of UK has sold and gifted the following assets during the tax year 2019/20: a) Sale of Main Residence: James purchased a house (main Residence) on 1 January 2002 for £40,000 and sold it on 31 December 2019 to his brother for £100,000, after completing the ownership of 216 months. The market value of the residence on the date of sale was £300,000. James purchased the house on 1/1/2002 and stayed in it till 31/12/2003 (24 months) and went abroad for employment purposes for another 60 months till 31/12/2008. While coming back to UK, he went to his Aunty’s house and stayed there for 12 months till 31/12/2009. Then he came back to house and stayed for 36 months till 31/12/2012. Then he left his house for employment purposes within UK for 84 months till 31/12/2019 and sold his house without visiting his house before the sale. b) Sale of Painting: James sold a painting which he purchased in 2016 for £8,000. He sold the same on 2 January 2020 for £3000 and at the time of sale he incurred selling expense of 10%. c) James sold his jewellery on 10 January 2020 for £8,000, the cost of it was £5,000 in 2015. d) Sale of Factory: James has been doing business from so many years, on 15 February 2020, he sold his factory for £120,000, which he used 75% for business purposes. The cost of the factory was £50,000. Immediately, he reinvested £140,000 in new factory, which he will use fully for business purposes. e) Gift of Shares: on 1 July 2019, James sold 1000 shares of Angle Ltd, an unquoted company to his brother for £25,000. The market value on the date of gift was £50,000. James has purchased the shares on 23 April 2013 for £19,000. f) The brought forward capital loss is £10,000, which is still to be adjusted.
You are required to: (i) Calculate Capital Gain for each of the above sale. Show the working and notes clearly. (ii) Calculate the Taxable Gain and Capital Gain Tax of James for the tax year 2019/20, after claiming available Relief wherever applicable. State the due date for payment of Capital Gain Tax for the tax year 2019/20. Assume that James has taxable income of 40,000 for the tax year 2019/20. Show all workings clearly. (Total 20 Marks)
In: Accounting