ࡱ>  _\prjensen BSheet13Atlanta_Spot_Prices:/Futures_Pricing:, Instructions:\) OCI_Table:(=xic$'8X@"1Arial1Arial1Arial1Arial1Arial"$"#,##0_);\("$"#,##0\)"$"#,##0_);[Red]\("$"#,##0\) "$"#,##0.00_);\("$"#,##0.00\)%""$"#,##0.00_);[Red]\("$"#,##0.00\)5*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_),))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)=,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)4+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)2/_(* #,##0.0_);_(* \(#,##0.0\);_(* "-"??_);_(@_).+_(* #,##0_);_(* \(#,##0\);_(* "-"??_);_(@_) mm/dd/yymmmm\ d\,\ yyyy 0.000% 0.0000% 0.00000% 0.000000%                + ) , *   !  !  !0     $   "  @  $ @  $ @  $ @ & !  &0 &0 &0 "0   #4 @  !   8 ``i̜̙3f3333f3ffff333ff333f33f33BBB Sheet1 _ <o '.8HT\f.oxwʤ  dMbP?_*+%+_'\&Q?MHP LaserJet IIISi s-0  DLwERL,,j d`"a,,??U} } }  }  } m }  } I}  } S o     "Periodic interest rate (a)$*ce>a?m daily rateWP 285 MarginWHEWUnits in contract (b)~ @ Contracts (c)~ $@Total quantity (d)j@& DD'@@'@(@@Future Contract Price`@@`@Original Spot Price@@@ Days to Expiration (e) V@f@`n@ ~ )@   Future price p@@x@  Spot price @@@  days from 12/17/99 (f),@,@,@ FVd(fut) (g)D0@.D@D DDD @DAD0@.D@D DDD @DAD`@.D@D DDD @DA FVd(spot) (h)D@o@4 .D@D DDD @DAD o@7 .D@D DDD @DAD o@; .D@D DDD @DADr/(Cr) FVd(fut-spot) (i) o@ DDh@ DD0@ DD dFVd(fut) (j)0@D0@D`@D!@ %oq(FC Asset/liab effect) dFVd(spot) (j)@oL o o!` %oq (OCI effect) dFVd(fut-spot) (j) oh0!d %oq(Net Income effect)July 31 Future price@h@ Spot price@@ Months from Jun30?? FVd(fut)D @.D@DDDD @DAD@.D@DDDD @DA FVd(spot)D"@8 .D@DDDD @DAD@< .D@DDDD @DADr/(Cr) FVd(fut-spot)M DDj* DD dFVd(fut) (k)`\@ DD,@ DD!`@ %oq(FC Asset/liab effect) dFVd(spot) (k)! DD! DD!0 %oq (OCI effect) dFVd(fut-spot) (k)!:@ DD!@ DD!@ %oq(Net Income effect)Dln '91K=;> 64@ 0.5a !"#$%&'()* +,-./0123456789:;<=>? ! August 31!" Future price~ "Є@# Spot price~ #؄@$ Months from Jun30~ $@% FVd(fut)D%c@'.D@D"DDD @D$A& FVd(spot)D&c@= .D@D#DDD @D$A&Dr/(Cr)' FVd(fut-spot)'c D%D&( dFVd(fut)(~( D%D!(~ %((oq((FC Asset/liab effect)) dFVd(spot)!)@ D&D!)@( %))oq) (OCI effect)* dFVd(fut-spot) *!* @9) D'D!*@9) %**oq*(Net Income effect)+ Soybean Oil+,Units in contract~ ,L@,- Contracts7-W@.!`ffffff?A-.Total quantity.ЃUAZ D,D-./August/ September/October0Future Contract Price03?0?0gj+?1Original Spot Price1:M ?1:M ?1:M ? 2Month to Exp at 6/30 (e)2?@@34June 3045 Future price5jt?5:#J{/?5jMS?6 Spot price6Bfj?6Bfj?6Bfj?7 Months from Jun30 (f)78 FVd(fut) (l)B80jA:,D0@D5D.DD2@D7AB8`A:,D0@D5D.DD2@D7AB8HAI ,D0@D5D.DD2@D7A9 FVd(spot) (m)B9pA@ ,D1@D6D.DD2@D7AB9`AD ,D1@D6D.DD2@D7AB9HA:,D1@D6D.DD2@D7A9Dr/(Cr): FVd(fut-spot) (n):H D8D9:H D8D9:H D8D9; dFVd(fut);0jA;D8;`A;D8;HA;D8!;lBA* %;;oq;(FC Asset/liab effect)< dFVd(spot)<p%<<=L<`=<<H=<!< T; %<<oq< (OCI effect)= dFVd(fut-spot)=@<<=<<=<<!=@< %==oq=(Net Income effect)>?July 31?D l (&-^r>z!5ZG:WU@ PN? @ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^ _@ Future price@S㥛?@!u?@0*?A Spot priceA%C?A%C?A%C?B Months from Jun30B???C FVd(fut)BC@AE,D0@D@D.DD2@DBABC`@E,D0@D@D.DD2@DBABC@E,D0@D@D.DD2@DBAD FVd(spot)BD@A ,D1@DAD.DD2@DBABD@E ,D1@DAD.DD2@DBABD@J ,D1@DAD.DD2@DBADDr/(Cr)E FVd(fut-spot)EV@8 DCDDE@S DCDDE@S DCDDF dFVd(fut)FF DCD8FF DCD8FF DCD8!F4= %FFoqF(FC Asset/liab effect)G dFVd(spot)G;@=GGH LLG;@CGG;@8G!G,AF %GGoqG (OCI effect)H dFVd(fut-spot)HpGGHGGHGG!HKG %HHoqH(Net Income effect)IJ August 31JK Future priceK!rh?K46<5a ",&-\p>z`abcdefghijklmnopqrstuvwxyz{|}~`Units in contract~ `Y@`a Contracts3a_@b dffffff?AabTotal quantityb8@ D`DabcAugustc SeptembercOctoberdFuture Contract PricedPq@p@l@eOriginal Spot Pricee@@@ fMonth to Exp at 6/30 (e)f?@@ghJune 30hi Future pricei@"@@j Spot pricej@@@k Months from Jun30 (f)kl FVd(fut) (l)BlAn,Dd@DiDbDDf@DkABlLAn,Dd@DiDbDDf@DkABlPAn,Dd@DiDbDDf@DkAm FVd(spot) (m)Bm,AO ,De@DjDbDDf@DkABmAS ,De@DjDbDDf@DkABmAX ,De@DjDbDDf@DkAmDr/(Cr)n FVd(fut-spot) (n)nA| DlDmnhA| DlDmnE| DlDmo dFVd(fut)oAoDloLAoDloPAoDl!o3A^ %oooqo(FC Asset/liab effect)p dFVd(spot)p,YppqLpqppqp!p;0o %ppoqp (OCI effect)q dFVd(fut-spot)qppqhppqE@pp!q p %qqoqq(Net Income effect)rsJuly 31st Future pricet<@@k@u Spot priceup@p@p@v Months from Jun30v???w FVd(fut)Bw' Ay,Dd@DtDbDDf@DvABw0Ay,Dd@DtDbDDf@DvABw7@y,Dd@DtDbDDf@DvAx FVd(spot)Bxn AP ,De@DuDbDDf@DvABxm AT ,De@DuDbDDf@DvABxm AY ,De@DuDbDDf@DvAxDr/(Cr)y FVd(fut-spot)y@l DwDxyX@ DwDxyУ DwDxz dFVd(fut)zz DwDlz8V z DwDlzz DwDl!z.D%q %zzoqz(FC Asset/liab effect){ dFVd(spot){XAq{{| LL{HAw{{8Al{!{lAz %{{oq{ (OCI effect)| dFVd(fut-spot)|pAA{{|@{{|@{{!|{A{ %||oq|(Net Income effect)}~ August 31~ Future priceo@@Dl5VG:=;@ 64? 64;  Spot priceH@H@ Months from Jun30@@ FVd(fut)B8@,Dd@DDbDDf@DABp@,Dd@DDbDDf@DA FVd(spot)B@ AU ,De@DDbDDf@DAB0 AZ ,De@DDbDDf@DADr/(Cr) FVd(fut-spot)Hw DD DD dFVd(fut)Pl DDwh@ DDw!X| %oq(FC Asset/liab effect) dFVd(spot)!@l DDx!@ DDx!@ %oq (OCI effect) dFVd(fut-spot)!t A DDy!) DDy!A %oq(Net Income effect) September 30 Future price~ @ Spot price~ @ Months from Jun30~ @ FVd(fut)B`=A,Dd@DDbDDf@DA FVd(spot)B`)A[ ,De@DDbDDf@DADr/(Cr) FVd(fut-spot)b  DD dFVd(fut)8A DD!8A %oq(FC Asset/liab effect) dFVd(spot)!>$w DD!>$ %oq (OCI effect) dFVd(fut-spot)!aA DD!aA %oq(Net Income effect)8!0PV of Expected Cash Flows on Hedged Transactions!!!!SoybeansUnits in contract~ @ Contracts<Y@&<ffffff?ATotal quantitynA DD JulyAugust SeptemberOriginal Spot Price@@@Month to Exp at 6/30?@June 30@ D.5a "(&-\p>zN5_G7;<                 Spot price @ @ @ Months from Jun30 FVd(spot)C*@4 -D@DDDD @DAC"@7 -D@DDDD @DAC@; -D@DDDD @DA dFVd(spot)*@D"@D@D "July 31 Spot price@@ Months from Jun30?? FVd(spot)C@8 -D@DDDD @DAC@< -D@DDDD @DA dFVd(spot) |@ DD x@ DD "  August 31 Spot price~ @ Months from Jun30~ @ FVd(spot)C`@= -D@DDDD @DA  dFVd(spot) @\@ DD "  Soybean OilDl 4;  .5 n  &-h J           Units in contract~ L@ Contracts7W@!`ffffff?ATotal quantityЃUA DDAugust SeptemberOctoberOriginal Spot Price8@8@8@Month to Exp at 6/30?@@June 30 Spot price$C?$C?$C? Months from Jun30 FVd(spot)D@ .D@DD.DD2@DADD .D@DD.DD2@DADI .D@DD.DD2@DA dFVd(spot)DDD "July 31 Spot price6@6@6@ Months from Jun30??? FVd(spot)DA .D@DD.DD2@DADE .D@DD.DD2@DADЉJ .D@DD.DD2@DA dFVd(spot) F@ DD F@ DD F@ DD " August 31Df l5ZG:;<  N;  4;             Spot price"~j?"~j? Months from Jun30@@ FVd(spot)DF .D@DD.DD2@DADK .D@DD.DD2@DA dFVd(spot) @ DD @ DD "  September 30 Spot pricev/? Months from Jun30~ @ FVd(spot)DL .D@DD.DD2@DA  dFVd(spot) @ DD "  Soybean MealUnits in contract~ Y@ Contracts3_@ dffffff?ATotal quantity8@ DDAugust SeptemberOctoberOriginal Spot Price q@ q@ q@Month to Exp at 6/30?@@June 30 Spot pricen@n@n@ Months from Jun30DMl<5 n " *-i J"5VG:;<  4                     FVd(spot)DlO .D@DDbDDf@DADXS .D@DDbDDf@DADDX .D@DDbDDf@DA dFVd(spot)lDXDDD "July 31  Spot price o@o@o@  Months from Jun30 ???    FVd(spot)D @ P .D@D DbDDf@D AD ( T .D@D DbDDf@D AD  Y .D@D DbDDf@D A   dFVd(spot) 0@ D D @ D D @ D D " August 31 Spot price@@ Months from Jun30@@ FVd(spot)D@ U .D@DDbDDf@DAD( Z .D@DDbDDf@DA dFVd(spot) @@ DD  @ DD  "  September 30 Spot price~ @DC l  4;   .5 n "  ! "# $ %&(*+,-. /012 345@6789@:;<=>@?  Months from Jun30~ @!!" FVd(spot)D"@+[ .D@DDbDDf@D A"#$ $% dFVd(spot) %$ D"D %"& & (!Calculation of OCI Entry( !!!!!!* !Present Value of* !+ !Expected Future+ !, ! Cash Flows on, !- %FV of Derivative- %- %Hedged Transaction- %. #Increase (Decrease). $. $Increase (Decrease). $.  Lesser of /  / the Two/0 Change0 0 Change 0 0  Cumulative0Entry to1 During 1  Cumulative1 During1  Cumulative1 Changes 1OCI2Contract and Period End2 &Period2 &Change2 &Period2 &Change2 & (AOCI Bal.)2&Dr (Cr)3 July Soybeans4 June 304 @o@%D4 4 @o@D4 *@4 D4 4 *@4 DT4 @o4>D4  D4 AD4 ABD4 AD4 ABB4@o[ D4 5 6August Soybeans6 7 June 307  o@4 D7 7  o@D7 "@7 D7 7 "@7 DT7  o8>D7  D7 AD7 ABD7 AD7 ABB7 oD7 8 July 318 @X D8 D7 8 "@D8 |@8 D8 D7 8 @8 DT8 >D8  D8 AD8 ABD8 AD8 ABB8X D8 D7 9 :September Soybeans: ; June 30;  o@7 D; ;  o@D; @; D; ; @; DT;  o<>D;  D; AD; ABD; AD; ABB; o7D; < July 31< @8 D< D; < @D< x@= D< D; < @< DT< =>D<  D< AD< ABD< AD< ABB< D< D; = August 31= < D= D< = c@D&= @\@< D= D< = `@= DT= c>D=  D= AD= ABD= AD= ABB=9 D= D< > ?August Soy Oil? @ D-i J:&%#Nh/cs14@AB@CDEFG@HIJKLM@NOPQ@RSTUV@WXYZ[\]^_@ June 30@ pA; D@ @ pAD9@ @ D@ @ @ DT@ A>D@  D@ AD@ ABD@ AD@ ABB@;D@ A July 31A ;= DA D@ A @DDA F@A DA D@ A A DTA 9>DA  DA ADA ABDA ADA ABBA`@ DA D@ B CSeptember Soy OilC D June 30D `A@ DD D `AD9D D DD D D DTD E>DD  DD ADD ABDD ADD ABBD@DD E July 31E ;A DE DD E @DDE F@F DE DD E E DTE F>DE  DE ADE ABDE ADE ABBE`@D DE DD F August 31F E DF DE F {@DOF @E DF DE F F DTF {D>DF  DF ADF ABDF ADF ABBF@9 DF DE G HOctober Soy OilH I June 30I HAD DI I HAD8I I DI I I DTI J>DI  DI ADI ABDI ADI ABBIDDI J July 31J ;F DJ DI J @DDJ F@L DJ DI J ЉJ DTJ K>DJ  DJ ADJ ABDJ ADJ ABBJ`@O DJ DI K August 31K J DK DJ K z@DOK @J DK DJ K K DTK zL>DK  DK ADK ABDK ADK ABBK@8 DK DJ L September 30L K DL DK L @DZL @K DL DK L L DTL O>DL  DL ADL ABDL ADL ABBL@D DL DK M NAugust Soy MealN O June 30O ,AI DO O ,ADmO lO DO O lO DTO ,P>DO  DO ADO ABDO ADO ABBO,IDO P July 31P XL DP DO P n A DxP 0@P DP DO P @ P D TP n m>DP  DP ADP ABDP ADP ABBPXA- DP DO Q RSeptember Soy MealR S June 30S AO DS S ADmS XS DS S XS DTS T>DS  DS ADS ABDS ADS ABBSODS T July 31T HP DT DS T m A DxT @U DT DS T ( T D TT m U>DT  DT ADT ABDT ADT ABBTHAx DT DS U August 31U T DU DT U @ ADU @@T DU DT U @ U DTU @ x>DU  DU ADU ABDU ADU ABBU@m DU DT V WOctober Soy MealW X June 30X AS DX X ADmX DX DX X DX DTX Y>DX  DX ADX ABDX ADX ABBXSDX Y July 31Y 8U DY DX Y m A DxY @[ DY DX Y  Y D TY m Z>DY  DY ADY ABDY ADY ABBY8A DY DX Z August 31Z Y DZ DY Z 0 ADZ @Y DZ DY Z ( Z DTZ 0 [>DZ  DZ ADZ ABDZ ADZ ABBZ@m DZ DY [ September 30[ >$AZ D[ DZ [ `)A"D[ $Z D[ DZ [ @+[ D"T[ `)>D[  D[ AD[ ABD[ AD[ ABB[>$x D[ DZ e\]This spreadsheet accompanies "Introductory Cases on Accounting for Derivative Instruments andd]\Hedging Activities " by Walter Teets and Robert Uhl. It provides futures values and changese^]in values needed for journal entries in the case "C.L. Smith and Sons: Accounting for Futures__WHedging Commodity Purchases and Sales." For an explanation of particular items in thisDl31142ihi`bcefhijklmn3`+spreadsheet, please refer to the case text.VbNNamed areas of the spreadsheet (accessible through F5 key) are "Instructions,"Bc:"Futures_Pricing," "Atlanta_Spot_Prices," and "OCI_Table."ce[Pricing of futures involves many factors not included in this spreadsheet. Therefore, this^fVspreadsheet should not be used as a substitute for consulting with a valuation expert._hWBoth Walter Teets and Robert Uhl were associated with the U.S. Securities and Exchange_iWCommission during the time the project "Introductory Cases on Accounting for DerivativeWjOInstruments and Hedging Activities" was developed. The Securities and Exchange_kWCommission, as a matter of policy, disclaims responsibility for any private publicationZlRor statement by any of its employees. The views expressed herein are those of the]mUauthors and do not necessarily reflect the views of the Commission or of the authors'4n,colleagues upon the staff of the Commission. 7ZFgbcc[c^a=xic$'8X> " Oh+'0$X@HXh U.S.rjensenMicrosoft Excel@$_GW9  + &" WMFCAx =dr9 EMF= X@    !" !" !  " !  s'%    &% 6% Ld!??% "6"% Ld"""!??% 363% Ld333!??% D6D% LdDDD!??% U6U% LdUUU!??% f6f% Ldfff!??% w6w% Ldwww!??% 6% Ld!??% 6% Ld!??% 6% Ld!??% 6% Ld!??% 6% Ld!??% 6s% Ldrr!??% 6% Ld!??% 6% Ld!??% &6&% Ld&&&!??% r6r% Ldrrr!??'%  Ld!??'%  ( &% 6% Ld!??% 6% Ld!??%  ( &% 6% Ld!??% 6% Ld!??% % RLArialArial# Yw \lPr$0 \l|pd!w0%    TT ! B B LP1   ( &% 6% Ld!??   TT #2 B B #LP2   % #6#% Ld###!??   TT 4C B B 4LP3   % 464% Ld444!??   TT ET B B ELP4   % E6E% LdEEE!??   TT Ve B B VLP5   % V6V% LdVVV!??   TT gv B B gLP6   % g6g% Ldggg!??   TT x B B xLP7   % x6x% Ldxxx!??   TT  B B LP8   % 6% Ld!??   TT  B B LP9   % 6% Ld!??   TX B BLP10   % 6% Ld!??   TX B BLP11   % 6% Ld!??   TT_g B B_LPA    % 6% Ld!??   TT&WMFC= B BLPB    % 6% Ld!??   TT B BLPC    % 6% Ld!??   TTHP B BHLPD    % '6'% Ld'''!??% % " !% %   s   T! B BLPeriodic interest rate (a) T|#! B BL\0.00137% T)]! B B) L`daily rateT4C B B4LpWP 285 MarginWHEW   TET B BELxUnits in contract (b) TdET B BELT2500TVge B BV LhContracts (c) TXVe B BVLP10Tg}v B BgLpTotal quantity (d)Tlgv B BgLX25000T|x# B BxL\03/17/00T|>xo B B>xL\06/17/00T B BLxFuture Contract Price  Td # B B LT5.88TdWo B BWLT6.05T B BLtOriginal Spot Price   Td # B B LT5.75TdWo B BWLT5.75T B BLxDays to Expiration (e)  TX# B BLP91T`[o B B[LT182% % " !% %   s% '%     ( &% 6r% LdqX!??% "6r"% Ld"q""X!??% 36r3% Ld3q33X!??% D6rD% LdDqDDX!??% U6rU% LdUqUUX!??% f6rf% LdfqffX!??% w6rw% LdwqwwX!??% 6r% LdqX!??% 6r% LdqX!??% 6r% LdqX!??% 6r% LdqX!??% 6r% LdqX!??% 6% Ld!??% 6% Ld!??% 6% Ld!??% &6&% Ld&&&!??% r6r% Ldrrr!??% % " !%   s% " !%   s'%     ( &% 6s% Ldrs!??% 6% Ld!??% "   s  '' ' ,s-  -- @ !-""- @ !"-33- @ !3-DD- @ !D-UU- @ !U-ff- @ !f-ww- @ !w-- @ !-- @ !-- @ !-- @ !-- @ !-s- @ !r-- @ !-- @ !-&&- @ !&-rr- @ !r-  @ !- -- @ !-- @ !- -- @ !-- @ !--Arial-  2  1 -- @ !  2 # 2 -##- @ !#  2 4 3 -44- @ !4  2 E 4 -EE- @ !E  2 V 5 -VV- @ !V  2 g 6 -gg- @ !g  2 x 7 -xx- @ !x  2 8 -- @ !  2 9 -- @ !  2 10 -- @ !  2 11 -- @ !  2 _A  -- @ !  2 B  -- @ !  2 C  -- @ !  2 HD  -''- @ !'-"System-'-- ,s  .2 Periodic interest rate (a) 2 0.00137% 2 ) daily rate!2 4WP 285 MarginWHEW   '2 EUnits in contract (b)  2 E25002 V Contracts (c)  2 V10"2 gTotal quantity (d)2 g2500032 x03/17/002 x>06/17/00'2 Future Contract Price   2 5.88 2 W6.05$2 Original Spot Pricec    2 5.75 2 W5.75(2 Days to Expiration (e)   2 91 2 [182--'-- ,s--   -r- @ !X-""r- @ !X"-33r- @ !X3-DDr- @ !XD-UUr- @ !XU-ffr- @ !Xf-wwr- @ !Xw-r- @ !X-r- @ !X-r- @ !X-r- @ !X-r- @ !X-- @ !-- @ !-- @ !-&&- @ !&-rr- @ !r--'- ,s-'- ,s-   -s- @ !s-- @ !-'՜.+,00 8@ H [ Sheet1  Worksheets  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~Root EntryFBook KSummaryInformation(STXDocumentSummaryInformation8