Examine Cisco?s consolidated statement of cash flows (see in Excel Spreadsheet) and transform this into a free cash flow.

MSF 503 Assignment #2 1. Examine Cisco's consolidated statement of cash flows (see in Excel Spreadsheet) and transform this into a free cash flow. 2. Below are some year-end numbers for Cisco's equity. Restate the enterprise value in market terms. 3. ABC Corp. has a stock price P0= 50. The firm has just paid a dividend of $3 per share, and intelligent shareholders think that this dividend will grow by a rate of 5% per year. Use the Gordon dividend model to calculate the cost of equity of ABC. 4. It is 1 January 1997. Normal America, Inc. (NA) has paid a year-end dividend in each of the last 10 years, as shown by the table below: a. Calculate NA's with respect to the S&P 500. b. Suppose that the Treasury bill rate is 5.5% and that the expected return on the market is E (r M ) = 13%. If the corporate tax rate TC = 35%, calculate NA's cost of equity using both the classic CAPM and taxadjusted model. c. Assume that NA ' s cost of debt is 8%. If the company is financed by 1/3 equity and 2/3 debt, what is its weighted average cost of capital using each of the two CAPM models? 5. The template for Problem #4 gives the 10-year history of Intel's quarterly dividends. Compute Intel's cost of equity rE using the Gordon dividend model. Compare the cost of equity computed on the basis of 10 years of growth with that computed on the last 5 years of growth. MSF 503 Assignment #2 6. Dismal.Com is a producer of depressing Internet products. The company is currently not paying dividends, but its chief financial officer thinks that starting in 3 years it can pay a dividend of $15 per share, and that this dividend will grow by 20% per year. Assuming that the cost of equity of Dismal.Com is 35%, value a share based on the discounted dividends. 7. The \"Model for Reference\" in the Excel file includes costs of goods sold but not selling, general, and administrative (SG&A) expenses. Suppose that the firm has $200 of these expenses each year, irrespective of the level of sales. a. Change the model to accommodate this new assumption. Show the resulting profit and loss statements, balance sheets, the free cash flows, and the valuation. b. Do a data table in which you show the sensitivity of the equity value to the level of SG&A. Let SG&A vary from $0 per year to $600 per year. 8. Back to the basic model in the given Excel sheet (\"Model for Reference\"). Suppose that the fixed assets at cost follow the following step function: Fixed Assets at Cost= { 100 Sales if Sales 1200 1,200+ 90 ( Sales1,200 ) 12001400 Incorporate this function into the model. 9. (a) In the valuation exercise given in the excel spreadsheet (\"Model for Problem 9\"), the terminal value is calculated using a Gordon dividend model on the cash flows. Replace this terminal value by the year 5 book value of debt+ equity. This means that you are essentially assuming that the book value correctly predicts the market value. (b) Repeat the above exercise, but this time replace the terminal value by an EBITDA (earnings before interest, taxes, depreciation, and amortization) ratio times year-5 anticipated EBITDA. Show a graph of the equity value of the firm as a function of the assumed year 5 EBITDA ratio, varying this ratio from 6- 14. PK##########!#2:##########[Content_Types].xml ##(########################################################################### ################################################################################ ################################################################################ ################################################################################ ################################################################################ ################################################################################ #######################################XMs0#wk#N4`rHc# #V%U##} #!#T#l,j%#ZZ&sNhUEK#PLs&e{#I#Tj#e## ##\\iFc# 5NlJ'@zk| #F:1I/ JQ4[}.PC}xNVzUAQS#s_x,#pf5@#|-sc#j=Z ik#rlJ##z!awV_VpH#?in$ONGZO Ze` fyM$##j#SSHs)|I#FI#|Ht|DHt|Du$:D#_#Qb##KGbiE,=_Ma#Hzh`Z~]kWm##=# '#nw#v9 G3G]# Yr#G>#"}Y#eC=l#._l`# # 315mJvWaX9mp[#`#y{#5,D}###*# #U[8}r#3@`y#nBH##n0#####PK##########! #U0####L#######_rels/.rels ##(########################################################################### ################################################################################ ################################################################################ ################################################################################ ################################################################################ ################################################################################ #######################################MO0 H#BKwAH!T~I#$#'##T##G~'8#MY#*GM#}=#cly,}qhe ~ #kim1//#y?n|FmkCYe#;XWeyU?x#Oq#+`nb3? #w?#bWM#d[My4nnk[lG##SM# 5Wady}-##x##A r#.^Y&{5yn?>=70?oB}#ss-hy#kea# YNB(#3K v@#M#k&'a|Q@!##u6.#YfM7##[#3#dF#p#x? } 5_#A|3}#-01OdIV&3R#Y]+iJA#(###a#@ CGd@#g#1Lg#CC##d##$/#A|##_#Z##(6###W!? #Bbg+0#Sub#?Ik")sz[v]I##nS\\i&YuKN 6^:`_r4| d*#QV#E.Z"s_^#s#I;#e~zS "um##Vh@#b_#0_*#[[ $KMj%##A.#EAa#KqHL #@0%`: kyO!=*c=#R###S`;Ax&hj##W#+aO#G##vh# 3\\p>#wd##!#:(px&= # Z%#7#=qOT#^XO^km4N`n#FJp.0p$',/ ##wM#Ljw;9#^?#e#UH}#m#( J 9 #C!# G%#|6Ys~R#MM8#H{##A-U6##.#cL#[}#K=#Z|? e}#B,#$ x#| EqA`##{v>Py#yc p#\\^-'#qa@cS (#W#)l##8#CC_rr1!#v#99\\S#s7Q#B tF#wUUI##Yv5##X ###N#[8}5^ O[VeNg+BWS,5K{57##5XIn##^.{b3oI$#e #qc? #W+#wLC#cL#x#c0Fu z#"Pk##7\\c#LH#CF#OJp##;#eH#k##> i#CHp#qU# mb+?1 +#p0c#j#O##)5#@{0#! y5#Zv#Z%.d>tqQC#)h [#=#X0gFgfzGL|O">##}#"vw ##iofqsi{#|#>-@'7| p##> =GH#|LL ! l >kZ #####PK##########!#t#k#e### #######xl/worksheets/sheet2.xmlY 6#~L#N:76Hk;4#t}0#.+a`##FO~+i`j#,t#j^#lY t? W#k-I5##zH#}#Abh$##z#ny1##B' g1 +h{LE#?#-_EC+K061##t]84jl#;s#/ 0V+#@#G:Yl!SNI?l##DbAAgT T,###X:Iz#9E3##7\\##0UF4bB9#$cR-}TZ #j ##/l! u)fA1 #zl$#4##WDfCWp###pot#X"gptIE#0b-#%o7#j2Hi##SSj/2##Z# (Ot#K%dC4 Wd#5##A7#% QUB]Z D~:##\\CPt5##QCVHrSCaLm#OR(Qi#p#4 ? J### #'g{uLo52####5#g#WJV]g7[ ##{Q#ahC#4r^#0#5P#5#? zhEi#S#(Fth~9#+ge#F^8!c&J=B %UGLYK#f^#/N@bA#F#F#\\>&7#{PpX8H8 Pz`#fth/}#Eo#hB98#[y##_`##.#MLN!MF6}~x ]?NeE|VuMG#&7lZ!*v##{G|B ? s#Iq#6]BCg# #!###'ll0X`IH#\\5#w##YBY$;VR? 3NtM&8(#GLmWx&R~."!Yq\\9 #K ~ ? wXV,^3% '#NOv/'$O#L'@: X###z@P#l#?#-#`+#### F4#@# #7##v`#[@#@k#x#8##]-]7#E####N`####| # ##>###@####@#F! ####&{#####p/p##hL!> ##fg$ ># @L##oX$# o]:##s#K@#?#S=)i0 /# $1Lb#j(%1|1nw#X#zdHKv#\\@+$RaR^~k 9{#'i#p#f2#=#R#I T#)#q#].#_.Zw9.[J qKev9? yeHCS ){3## Eh ##oL#%lu}1mam8#bF+T?=#Er#m|2B ZG=SDt$? #:#]5##\\\\jKg#2^1~=Sm#S# S#SK#{Z! E#z`Ij###6n:3#$#aA!._\\# |GlRy1K#m(#E:####v^~dI.-q#MH? aw` 8L#0O#u}u]9?0L}#+ e#\\m\\GU>Dfq5S*u#J* %o/#lWRF]N4kFIN#BdT cDd##s[b#I4/On#Y#F#i4$xAI = KJx#x_##)#3Dmf~###D/G49|;#d7T.euog4a#SwVv#T # #q6##Z988 B+~#0]6#DN}+c*3a OtT)!7g# ,vxTtf? uk#e###enI6Y#R#6jq3G}#u~#CP##y m#)##&I#HQK\\ # MDT #R#XX M(#m"x#7#)}BX# &{:#R#MzHW*zUQ9Z.#q 8R#XQty e3#P#[#?a3t#]? W>E9FfSE4+D=b(F#hfrf&l#n##S#l8#N(##pL# S:PAmT`#? tN*pHR#F##]L5tc#,M##$#j/?#k#X##V',k}'#6gneq{#hL`SF#2~A#P Fl#N(#w aV\\%D##N#>M#am#7X#:Z#WQ7 xja# u#n'yl# tUZYe###O#_G| $jsZoAt7#smj#942qg#y#~YCfk2iZ'@) #5###q3z#9 s >qb#ZNq:%_#(5_#,5#x####F#oA###cl`>_ #jF#qM=#$~##BOaN#yA96~ 9Ag+hT9sywaE#0[>b #X= x#o /Z'#qw#0Fy~##j#7VC#8!+V#vukw7x#X#rYb## #(aKH YKu_z>/Y%be#\\ u # #W86*lc##: ,=Q8##?# ##Mg 9?x#nvUr#'B{)(%)#Y#? mex!GK!CV#]-#uW@!8? #gbE2#ngsfTX"##.#;!3#+U\\##yF\\vwlo#rL*#| #y#;ej&Z!I#I aSn?,[#wv5Uw#.YlkV/R\\#WZ#{ #1L#JfEsv vaPN##*:#t##^d7 %O%Y?s#>#wI7%otv&d? $;##+0+[7'#? c8,(###|#m!4;# GG##M8#x##LB^A%T*#f o)T `5Bn^,#u^@#L .$#| z /$Q:###eJZGq0x-F#{(#z z S#h;kE8#H}clC! 0 f S2##'/xd_:3](#.Te ;8##f#,'51 HO931#A5gs)W Y#L@;z`#*F! $cJ#G#`bV;##c}rI8_#g#@O/-'`af 9Y%P ?%;xfN]#\\y#E N#e#8c\\En>"I*./\\#n#m ? Kw#{t! \\`n#,###o@s.nQ}#3jmqO# %#3#9n9###N'#ey*AY\\#dqbQZ#iU#3### %NPgEV##bY#k(Yi##k#f#!w#:###%j=\\!! #H#"&UCCF#rT#/^!7#^X####v&!!#o#ih\\?#O#l#| J#[V F7luS8'P#Y>#u|`##;s*A##l % cS'#7_0~I#T-l#'#$C%=FV4ArHc#J#&hw`S[##+ % )% b ?-#Mvv#6*./gsJs[#5## %P##g$*38\\###7!_##RYmN>UC/#p#ulo b\\By8]]a #Mp#Wj,AIOk#+/PRN#z#xXHv##A;#~A#1ACiN?#gv#U? #o#Iw];J##(l# o7y4 Cs##Cv}#m|#y#~#I##VEQ$#9#*JC4E4#l{s 2y[ [#~9ZS#9###f_ p {~#Go+ 2 ee\\qQ[b],l#84:: 3#9Bd C?^QzJgTe=c0\\w######P K## #######!#LI#G"##G"######xl/media/image1.pngPNG # ###IHDR######x#########sRGB######gAMA###a#### pHYs#######+####IDATx^STG? )( ,jjR W .y##&wj$#I#4o##&,| #|NraYp3LV\\###Mx##? d9a`##F9_OzZ#n#t#B##}4#Z#Aw#D## {p IF~#)Z#P~}V!-#JfZ$PhJ#rItzz#_4(%#|~| #KPF/##UT#E}D#?8#?Hr#$|T#lqqV .#jFk>k|K#miL#.s4#vsD)| r,ZG#e##u}A8# U|*NVE08%qBl6 ?&b6ox#tbRTp#q4TuF,#G#\\#}:mxX#Nt#=BQaK<5>&&Qt5&&&O&&m&&
&&y&R6G<_zd3>&H&mL7v&NXLshS&_Tbj&

&svjx&&Y&t&&h&P&&

<_>&&&&M&&&VwFt&&&&&&&j7&jEu&&&<_mj>&&&&&j&&&&&&V&&E&K&&Qm7&rj&&&&zQj2&&T&&&&Q2&&j&&&&g28&R&d&&A&&z2k&&C9&z&o&E&LJd&zt&p&&w&k&&X&l2&E&NZhTDi&p&y&&E&zWc&o&&L&&&&O&P&&&:

&&oudP9k&pzX&h&&&LPb&r&QR4<_8 s v h em zkb n ul u>&&&U&&tkg0O&&&WoN&z2&&QZ&&

&X&<. x rkni g i a9 hw2 cw wai miu yiy r7 e7w>&&&i&&W&Z&&&&v&&z&f&&:c&g&jfP