> KMJ7 bjbjUU ">77Bl6
6
6
8n

("ACCCCCC$ "hggXAANGN
0;Z{&6
p0%6#l6#Chapter 10 Update
Last Name:First Name:Team Number:Instructions: Do not delete any of the problems or instructions. Fill your answers in where you see boxes that are shaded yellow. Please keep all fonts at Times New Roman 12 point and do not increase the size of any equations produced by the equation editor. Dont forget to sign the last page before you submit this.
LISTNUM \l 1 Download your teams historical stock data. When you are done, report the stocks five most recent (by date) adjusted closing values.
Adjusted Close #1$Adjusted Close #2$Adjusted Close #3$Adjusted Close #4$Adjusted Close #5$
LISTNUM What is the average adjusted close for ALL weeks of your stocks data?
Average:$
LISTNUM For the ten (10) most recent (by date) pairs of successive adjusted closes, compute the percent change from one week to the next to two (2) decimal places (for example, 2.35%). Only report your results below. Not your calculations.
WeeksPercent ChangeWeeks 1 and 20.00%Weeks 2 and 30.00%Weeks 3 and 40.00%Weeks 4 and 50.00%Weeks 5 and 60.00%Weeks 6 and 70.00%Weeks 7 and 80.00%Weeks 8 and 90.00%Weeks 9 and 100.00%Weeks 10 and 110.00%*Week 1 is the most recent adjust close. Week 2 is the adjusted close the week before that.
LISTNUM Using the Equation Editor, clearly show all steps for the calculation of the Percent Change that you reported above for Weeks 1 and 2.
Calculations:
LISTNUM Draw a graph of the all of your adjusted closing. Use the Chart Wizard and choose the XY (Scatter) option and then the graph that connects data points with no markers (last option). Your x axis should be dates, in ascending order, and the y axis should be the adjusted close of the stock price. Label and title the graph appropriately. (You may need to sort your data by date.) The background of the graph should be all white. Paste your graph in the space below and resize it so it fits, is readable, and looks good.
Graph:
LISTNUM Add a column to your data spreadsheet and assign each adjusting closing price a week number, starting at 1. Hence, the first (oldest) adjusted close price is assigned 1, the second (oldest) price is assigned 2, etc. Then run a linear trendline in Excel using the week number as the x variable and the adjusted close price as the y variable. Report the equation below with the equation editor:
Trendline Equation:
LISTNUM Use your trendline to predict the price of the stock (not the option) at the end of your team's option period. (You will have to be careful about what you let x be equal todiscuss this with your team first.) Show all calculations using the equation editor in the space provided.
Prediction:Calculations:* Note: this kind of prediction is dangerous (why?). We're doing it here just to get us into the mode of trying to predict the price of our stock at the end of the option period.
LISTNUM Use your prediction in the previous problem to compute the value of the stock option (not the stock) at the end of the option period. Show all calculations using the equation editor in the space provided.
Value:Calculations:
LISTNUM In no more than three (3) sentences, clearly explain if you believe the trendline prediction you got previously in (# REF _Ref150066245 \r \h 7) is valid and why you believe the way you do.
Explanation:
Honor Code: With my signature below, I affirm that while I may have worked with other team members on this assignment, the final product is my own work. This means (a) I typed the work in this assignment myself and did not copy or allow another person to copy this file and (b) the work reflects my own understanding of the material. Violations of this code are subject to disciplinary action with the Vice President of Student Affairs. This assignment must be signed in order to be grades.
Signature_________________________________________________________Date___________
Page PAGE 2 of NUMPAGES \* MERGEFORMAT 2
+:<I{&);>PSehz~ $ %
1
2
q
34~W^`nqr{>*6 jU55B*ph5CJaJ[+,:;<zl8l<lj$$Ifl0 % 0
t0644
lal$If$@&a$z{&();=>PR_T_T$$Ifl0H$h
t0644
laL $$Ifa$$If ^`
RSeghz}~xTrixTrixg]r ^` $$Ifa$$If$$Ifl0H$h
t0644
laL
omc]$If ^` $$Ifl0H$h
t0644
laL $$Ifa$Tx $$Ifa$$Ifw$$Ifl0H$h
t0644
laL &'5;<JPxTrixTrixTrixTri $$Ifa$$If$$Ifl0H$h
t0644
laLPQ_eftz{xTrixTrixTrixXri $$Ifa$$If$$Ifl0H$h
t0644
laL x\rixcaTK $$$If$$ ^` ^ $$Ifa$$If$$Ifl0H$h
t0644
laL lj]T $$$If$$ ^` $$Ifl0 $)
t0644
laL$$$$Ifa$q
xnaXL$$$$Ifa$ $$$If$$ ^` ^` $$Ifl0%;
t0644
laL
xnaXL$$$$Ifa$ $$$If$$ ^` ^` $$Ifl0G%g W
t0#644
laL}~W^x@ocxVLVo ^` $$ ^` $$$$Ifa$ $$$If$$Ifl0 %S
t0644
laL^_`nopq@Ml@clYLc$$ ^` ^` $$$If$$Ifl0 %S
t0644
laL$$$$Ifa$
@MQ[0JmHnHu0JCJaJmHnHu0JCJaJj0JCJUaJCJaJ5\5jU jU#MNOPQ<obb3.$$$d%d&d'dNOPQ]^$$ ^` $$Ifl0%
t0644
laL $$$If<=$a$ ^` .$$$d%d&d'dNOPQ]^ 1h/ =!"#$%}DyK_Ref150066245
i8@8NormalCJ_HaJmH sH tH RR Heading 1$<@&5CJ KH OJQJ\^JaJ <A@<Default Paragraph Font4>4Title$@&a$5CJaJ,,Header
!, @,Footer
!&)@!&Page NumberRY2RDocument MapD M
CJOJQJ^JaJ>+,:;<z{&();=>PRSeghz}~ &'5;<JPQ_eftz{%q
}~W^_`nopq@
M
N
O
P
Q
<=000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000@0@0@00@0@0@0@0@0@0
0 AAAD
zRP
^M<{~$ ~q{
ZZZZZZZZZ <>D!8@0(
B
S ?
_Ref150066245 33<>~@$Fw< = e
?VW`pq
@
O
Lawrence MX:\SCCC\116\Ch10Update.doc
Lawrence MhC:\Documents and Settings\Lawrence M\Application Data\Microsoft\Word\AutoRecovery save of Ch10Update.asd
Lawrence M"X:\SCCC\116\Updates\Ch10Update.doc
Lawrence M"X:\SCCC\116\Updates\Ch10Update.doc
Lawrence M"X:\SCCC\116\Updates\Ch10Update.docR~t
hh^h`hH)
^`hH)
88^8`hH)
^`hH()
^`hH()
pp^p`hH()
^ `hH.
@@^@`hH.
^`hH.R~t`ܽ R~t R~t ܽ`)ܽy)ݽ)Tݽb()ݽd()ݽ0()ݽy.4.l(.`.(߽y.`߽.߽b)߽d()@=0()x=y()t()(()`.y..l...b....<d
.....0 ......Wy
.......Xf
........<(
.........+,:;<&();=>PRSeghz} &'5;<JPQ_eftz{= q e
W^_`nop@
M
N
O
@w\(@UnknownGz Times New Roman5Symbol3&z Arial5&z!Tahoma"1h2&9;F
@
!x0d@
2qHX
Chapter 10IT Services
Lawrence MOh+'0
<HT
`ltChapter 10hapIT ServicesT ST SNormal.dotLawrence M10rMicrosoft Word 9.0@N*@vD@G1@?@ACDEFGHILRoot Entry F[{&NData
1Table(6#WordDocument">SummaryInformation(:DocumentSummaryInformation8BCompObjjObjectPool[{&[{&
FMicrosoft Word Document
MSWordDocWord.Document.89q