Excel Formula Appendix

([FHO)RUPXOD$SSHQGL[

RI

KWWSWOWLWVSVXHGXVXJJHVWLRQVJUDGHERRNDSSHQGL[KWPO

6HDUFK3HRSOH_'HSDUWPHQWV_3HQQ6WDWH



7/7+RPH7/76XJJHVWLRQV

0DQDJH\RXU*UDGHV(OHFWURQLFDOO\ZLWK([FHO

)RUPXOD$SSHQGL[

0DLQ0HQX +RPH3DJH

3ULYDF\3ROLFLHV ([FHO%DVLFV

+HUHLVFKDUWOLVWLQJIRUPXODVZKHQWRXVHWKHPDQGDOWHUQDWHV

7KLV3DJH  .H\

H/LRQ&ODVV/LVW

 &DOFXODWLQJ1XPHULF*UDGHV  &DOFXODWLQJ/HWWHU*UDGHV

(QWHU6FRUHV

 $QDO\]LQJ6WXGHQWDQG&RXUVH3HUIRUPDQFH

&DOFXODWH*UDGHV $1*(/ ,PSRUW([SRUW

 /LQNV

.H\

&RXUVH 7URXEOHVKRRWLQJ

$*,PHDQDQ\FHOO $PHDQVDFHOOLQDQ\FROXPQLQDIL[HGURZ $*PHDQVDQ\UDQJHLQHLWKHUDURZRUFROXPQ DUHDQ\WZRSHUFHQWDJHZHLJKWV

6DPSOH)LOHV $SSHQGL[ )RUPXODV

7RSRI3DJH

&DOFXODWH1XPHULF*UDGHV 7KHVHIRUPXODVDUHXVHGWRFDOFXODWHQXPHULFSRLQWVDQGSHUFHQWDJHV1RWHWKDWDUELWUDU\FHOOYDOXHVDUHXVHGLQWKH IRUPXODV ,VVXH

)RUPXOD6\QWD[



1RWHV

$GG6FRUHV

680$*

)LQG3HUFHQWDJH

$$$LVWRWDOSRLQWV 352'8&7$$

'URS/RZHVW

680$* 0,1$* 680$* 60$//$*

'URS/RZHVW

7KLVIRUPXODVXEWUDFWVWKHVHFRQG VPDOOHVWVFRUHDQGWKHILUVW VPDOOHVWVFRUHIURPWKHWRWDO7R 680$* 60$//$* 60$//$* VXEWUDFWPRUHVFRUHVXVHD 60$//IXQFWLRQVIRUHDFKVFRUH SODFHWRUHPRYH

)LQG+LJKHVW6FRUH

0$;$* /$5*($*

)LQG+LJKHVW

/$5*($* /$5*($*

$YHUDJHRI6FRUHV

$9(5$*($*

:HLJKWE\3HUFHQWDJH

 $ *

8VH3HUFHQWDJHQXPEHU IRUPDWWLQJWRFRQYHUWUDWLRWRD SHUFHQW 8VHWKHLQFHOOUHIHUHQFHVWR PDNHVXUHIRUPXODVUHIHUWRWKH VDPHIRUPXOD)RULQVWDQFH$ ZRXOGKROGWKHUHIHUHQFHWRURZ

7KLVIRUPXODDGGVWKHVHFRQG KLJKHVWDQGWKHIULVWKLJKHVWVFRUH 7RDGGPRUHVFRUHVDGGD/$5*( IXQFWLRQIRUHDFKUDQN 


 7RSRI3DJH

&DOFXODWLQJ/HWWHU*UDGHV 6HHWKH)RUPXODVSDJHIRUGHWDLOHGLQIRUPDWLRQRQKRZOHWWHUJUDGHIRUPXODVZRUN

3DVV)DLO)RUPXOD ,)$! 3$66)$,/ 1RWHWKDWWKHGHVLUHGJUDGHV3$66DQG)$,/DUHPDUNHGE\TXRWHVLQWKHIRUPXODWRLQGLFDWHWKDWWH[WVKRXOG

30

([FHO)RUPXOD$SSHQGL[

RI

KWWSWOWLWVSVXHGXVXJJHVWLRQVJUDGHERRNDSSHQGL[KWPO EHZULWWHQLQWRWKHFHOO

3RVVLEOH*OLWFKHV ,I\RXXVHLQVWHDGRIWKHSDVVLQJJUDGHZLOOEHFDOFXODWHGDV ,I\RXUQXPEHUVDUHQRWIRUPDWWHGDVSHUFHQWDJHVWKHQWKHIRUPXODVKRXOGEH ,),! 3$66)$,/  ,I\RXVHH7UXHRU)DOVHLQDFHOOWKHQ\RXUIRUPXODPD\EHPLVVLQJDFRQGLWLRQLQWKHV\QWD[ 7KHIRUPXODFRXOGEHUHZULWWHQDV ,)$)$,/3$66

6LPSOH/HWWHU*UDGHV ,),! $,),! %,),! &,),! ') 7LS$V\RXFRPHWRDQHVWHGIRUPXODDGGHGDVHWRIHPSW\SDUHQWKHVHVWKHQILOOLQWKHIRUPXOD

$GGLQJWKH3OXVDQG0LQXV  ,QVHUWWKHIROORZLQJIRUPXODLQWRFHOODIWHUWKHILQDOSHUFHQWDJH ,),! $,),! $,),! %,),! %,),! % 7KLVIRUPXODFDOFXODWHVJUDGHVGRZQWR%,IWKHVFRUHLVQRWD%WKHQWKHFHOOLVOHIWEODQN   ,QVHUWWKLVIRUPXODDIWHUWKHILUVWIRUPXOD ,)-!-,),! &,),! &,),! ') 7KLVIRUPXODVFKHFNVWRVHHLIWKHUHLVDVFRUHLQ&ROXPQ--! ,IWKHUHLVDVFRUHLWFRSLHVWKHYDOXHLQFHOO -RWKHUZLVHLWFDOFXODWHVJUDGHVIRU&) +HUHLVDFRS\RIWKHPRFNVSUHDGVKHHWVKRZLQJWKHUHVXOWVRIERWKIRUPXODV 0RFN6WXGHQW6SUHDGVKHHWZLWK/HWWHU*UDGH5HVXOWV 

$

 1DPH

+

,

-

.

7RWDOV 3HUFHQW ,QWHUPHGLDWH )LQDO/HWWHU*UDGH

 3LFDUG- 



 7URL'



 5LNHU:  

 =HOOLJ: 

$

 

$

% 

%

$

$

'

 7RSRI3DJH

$QDO\]LQJ6WXGHQWDQG&RXUVH3HUIRUPDQFH 7KHVHIRUPXODVKHOS\RXDQDO\]HVWXGHQWSHUIRUPDQFHEDVHGRQGLVWULEXWLRQRIJUDGHV

0HDQ$YHUDJH

,VVXH

$9(5$*($*

6WDQGDUG'HYLDWLRQ

)LQGQXPEHURILQVWDQFHVRIDOHWWHU JUDGH$LQDUDQJH 0HGLDQ

&RUUHODWH6FRUHVEHWZHHQ DVVLJQPHQWV $VFRUHRILVSHUIHFWFRUUHODWLRQ 6FRUHVRIRUEHWWHUPD\EH DFFHSWDEOH/RZHUVFRUHVPD\LQGLFDWH DSUREOHPLQWKHFRQVWUXFWLRQRIRQHRI WKHDVVLJQPHQWV

)RUPXOD6\QWD[

67'(9$*

&2817,)$*$ 0(',$1$*

&255(/$$%%

7RSRI3DJH

/LQNV 7KHVHSDJHVDOVRGLVFXVVXVLQJ([FHODVDJUDGHERRN 8QLYHUVLW\RI:LVFRQVLQ(DX&ODLUH 8QLYHUVLW\RI7H[DV 7RSRI3DJH

‹7KH3HQQV\OYDQLD6WDWH8QLYHUVLW\ &RQWDFWWKH:HEPDVWHUHMS#SVXHGX IRUTXHVWLRQVRUFRPPHQWV0DWHULDOEDVHGRQFRQWHQWSUHSDUHGE\ 5R[DQQH7RWRDQGRWKHUV /DVW8SGDWH0D\

30