Use the following information about XYZ Plumbing (FY=12/31), a public company with the most recent closing stock price of $5.00, to answer the following three problems: PROBLEM SOLVING Problem 1 Problem 2 Analysis Admin Statement of Cash Flows 2015 Admin 2015 Key Pts Key Pts Current Ratio 1 Net Income 1 Accounts Receivable turnover 1 Inventory turnover 1 Adjustments Revenue to Cash 1 Depreciation and amortization 1 Return on Assets 1 Cash Provided by Operating Assets and Liabilities Return on Equity 1 Total 6 Accounts Receivable 2 Inventories 2 Problem 3 Projections Admin Pre-paid expenses 2 2016E Key Pts Accounts payable 2 Revenue (Increase of 25% from 2015) 1 Accrued liabilities 2 CGS 1 Net Cash provided (used) by operating activities 2 Gross Profit (Gross Margin increases by 1% from 2015) 1 Cash Provided from Investing Activities SG&A (Improves by 2% from 2015) 1 Additions to property, plant and equipment 2 R&D (Increases by 10% in total dollars) 1 Net Cash provided (used) by investing activities 2 Deprec & Amort (no change) 1 Total Op. Expense 1 Cash Provided from Financing Activities Additions to long term borrowing 2 Operating Profit 1 Addition to short term borrowing 2 Net Cash provided (used) by financing activities2Interest cost (given)$ 800,000 Interest income (given)$ 250,000 Net Cash Flow 2 Pre-Tax 1 Tax (35% rate) 1 Net Income 1 Total 26 Instructions: EPS - Basic 1 EPS - Diluted 6 1. All answers go in the YELLOWshaded boxes. Total 18 2. Make sure your name is written in the first YELLOW shaded box in the "2" row GRAND TOTAL 50 3. Do not resize, reshape or change any of the boxes on this page.

PK##########!#x##### ######[Content_Types].xml #(########################################################################### ################################################################################ ################################################################################ ################################################################################ ################################################################################ ############################################################################TN 0###q#!##Z>5U_t#:C#zuK#esO>#####PK##########! #U0####L######_rels/.rels #(########################################################################### ################################################################################ ################################################################################ ################################################################################ ################################################################################ #############################################################N0 HCnH#LH!T#$#$@#Jc? [iT##b/N(A3b{jxV#b"gi###aWl_xb##b4#O##r0Qah#e =# P-~gw x KR#/#W+x=#w'=ui %_r]X1[H:#hRKR9,_#Kr ? gfg#ui#_m?pg {[ykgwzzF#Zz;{{t# vC#D E! # #ZIh o#uN p8#l-g8m##+o####3G?#="]yk# }bx2#~yUo#iCcU###eO##o_ `a46R^#:iNs;tEO#`=#IMgN*#6g#####nBU9D dj#L d USR*e@%Y<: _c k b m7>3l>>5*#"#|~6l8? ##mo 5e#N#8wM#y;#o= c{; oe#>eq#r/a#`hwsO# _D _v##8z!76Ga,(#}t6#R'/# UJ#q#}ol/}| 6SV@/#p!j6#t###n@\\OW##9B#f%#,I#@;%KB1eC: #yIN9F.YUhBW #D:J+##,##A#X#xd##C#:m#*D#Igq#f"p\\#G#$YZ#b##v %MZstQw]r nIpQR4Y[m:-##e#a"W@##L#W@ I#DG# %(ri#'#(#bD#dk"6IsWRejW}Pe#@WT ##Ji /SMtTeGEG# /4 ;I #e?#*E#:E#{-#1UhT^Zn#3 #:gH3#y#2#%^)EJb/-##1( ##L7Q"W'##_ij#}~_U? ##u J #[].'##+w#y%wN%&F^#P S{7##ee##rng33[#/j)pS6*%JJ#2]P R5NsZ}y2#RKv#r#'';##M[##SQ#R*{UZeJ/##4Ioo#} #!###;GAJ "MN$Z?rmCd(Z!OwmF#H-##Q#+#OKNIX ?T8#=#; #r%"Ky@K,# 3!M 4s#x#xF####P{x##B5#:#q *r#*#@1 h)T##@##jfd#`#f#J #+g F#~P'Z#m#[uTVy;6G#M,#/AF#8l#7ur=pJ2*H# ? WuT#%1 #`( p _## s>g$soxk#z|#! p2y'#PCDY~#tV+,E6J####>BRz#?%`^B#q#{ #0yNBNJ=NdC'gYOd##3SS`/./S#bAX{7?\\? kg##Q^E,zhaC# ### ,zpy6#gY| jOu2^ &c.oq #]#o##fO#G]@#Q4V#[## `ct~b##OY#$'z:0YN#I=p` #~uvQ##$x[b 1#####PK##########! ##,####B#######xl/worksheets/_rels/sheet2.xml.relsj0#D{$;P%_J! E^Jh%Bc0]Y#c"#n@!4D,|>XIy0#jm_#/N,}W:=RY}#H9EbAwk}##m ####PK##########!#"###?######xl/worksheets/sheet2.xml[[s"#~?U? PT# sR6yX !3m#`%uKjI##oj}j0Wz#u;Dn{r? :6/e]}#n#hx9^#Oq{{>o#y#7'Kn#EYy{i +Gt##vwI)9l6'{='W;N,u>\\?%uNiz;m! #X##R#*AvoOv$###Lt3+d4~=#O[}y #X#lv|`#gDBQ#$\\| #O#&I##}#Y#pE\\EZD#M## G\\QxFv`5###IR=W,Ls!6Ge6 ?N#'8x.## P3/#34t#6 HeQM1# :jZ# # E# ## #$M 62#n0####TQeT[% fH#XO!|-IZ+#8tas #s gUA#0$}5# Z#gQt25p#h?C!&$9'.GYzGY#^#LO,G BeALhV#> I#I#P"M(#]##`#v#@#|("0#"0# H#B\\#D[#re#zu##5#1*]@#3DMX#2DWr#HHCoh%@1#**LDH3=LSwF####3Am7SN#xP %,=*5f#FJ %nn#9 |Uo4##q#YM[;Q-TpL#o0ft(a# }1GR? CJ#(#B#t\\1#jT hUVklRn{#KS##g#A#b"D#A:RfY4#b(N1>V YYbdQXd#dA_[k#Z#fz]C#'#yGa\\B>VkK^n##@r. I jM###|5GAT##TI#O#1I39=o#}7e %YTPcFxe\\>S_# #| y#`###qYT#H##9t#+@N4#Y#BEPu##JN\\#-2-w#H##'5C*##J#HU#ZPZ#p4K#P##Ho)###&p? g###,6tz#(H.@? ZdncUVk#Af95J#vx#i? Vl#Otg##YVby@#OA1#}ZM##9#%` `uO#8h{wK## cxLH]*$#A>J%a#ACM#J#&M##;4Be tY#>c~4$## &^ L#1bma]ut#(gZ[Wvr#2u{#`#M,EF,2nQ# %[NJeD>#f}{#7vt#d%|JYw##2#O~J=L8-o#|#( %mGEFD[###t3q %'#q##Sg##v #9fe#qwW@(#^wd#bh #a#8g#.JpC*Xx8rbV#`|XcY#U3#J 8b3#+#(#QuK>Q#E#LKM2#'#vi#~ vlw#u8+z#HH#J##:)###~#L\\E\\O*t@#G1lm##~#C*u#G.R(:y#s^Di7QR#8,b?S#Q*q7C;#+}#4;#pDZ# K(NhwQ6##? [SYJ(kpg>X_xwu{\\>k]#Xy}?M26PsFnJ'K,}##?$;@`# >*#8#i"LI##%\\ x=#6###u=#r2f 3c (:jZ3s#Ls*#U ]M8kp6L#x"]$C#'eb.# vJ|yX#8]7R##/=,.&'Qk5##q&p(#Ka#Sd L17 jpSaS##!#3#5'+Z#zQ H)7 #5)#kdB|UtvaD##p| Fl_*3#n'LE/pm&]#8fIrS4d#7y` n#I#R#3U~##c##nr#F:_##*P}###-p###Tpl#r 4LZO## #!PLB]$K *+#+##65v##eNf(MN1 &6## 3(adE,Uz?Og_6o?[g/#u:#/#OM;? pF#^7by^w#{{^#o.ojEx^o_Z^=R##HlPU#\\ew(A-#! M#a}m6z6kg\\hwwNdJnr$##_$#/ E# # # j#r^Jwc7K86?###Q0##k#2QG2i(aEu6^#wqu## w"#_i+###v;l#ALR3#@N##t(d$7#j#;##w#/ Ew#NjQfE9P#K #PA#D_> XBX#bNP:Au} 4#x%Uc#Eb E#F #(#,#|# g48 u#-#HQ#5Tu`v#E pb# ~^F#I#RF"1#E#F#)z#e# Es##--Z##u-#lS{![h[#)PK202%# ()# U T@d#0di##sO#vU#h#YZY4f$=h D#]#LI#"7!sC#,A 8{1}#+*{#^##=5O=#5#wF,$IJ,#[4(gT$Xb?wMQ#ZY4hH"3Y#C 2T(#:#E##Z~z0LVA#EH$p8F#KIH#M,#+5 s-s; `dQjQH#]&V*g8GB]k}L#3F L-#c?q#TGZ - bP~u#1N@JJM#iAh#- !#C4 k_#z\\{ $ #c#[E %#[#q; )uM-#Ir#M,#Q_(Y:9]#8j#unZ'2>AJJ##| zUq:5Tjsm#oM#I=F}O##X#\\#Bha>Qq#^zlQ#$UB# #zn#{kUuIEk#N%\\#'!%N##g(#UU >1dHw#(2#^@i+bpM? Zc9#:#_Sr\\#,O{{#YGza{OOy #sx(#?^6/#,r#_ 6 i@ai??{#mw#8=%y##hysz{' QH#%Om:"jM d[r8:[?m?=Sr. #KtNN7no##qJm[Dv##T#YR#3-#%#;^ El|zV("ei*V*TJs#n+B0##-js'#^:~ p_IQ9#=#V}N#1[`jLH9yvs& ##t&)xqwsq9Kg### n5b# xbN3'+NK+JY 7J#SptZ\\k#@;NC#S#s# #h##?##]##/##zB#2A9C#G_* lUN+M_S? #u#G0X##Q: W# l %W -#W5#z|`=@~#X c']iI0p##j.3>.#7#?#,YO\\###p dR+D p LcOc|M (7#=\\~l[}H^bKfhRp#? S#K{u+7##8fJ?+e~rp? Z.#C)]r#["N XFM\\##17N#_1#Fd? X#q"4Z) #f|7 mzXw4N#OQ@`x#Q#y[AG=[OC #'#cu#}T:? H#(%)#$y#X}#'tOR %#I~vx{##'CEv#|").N3:!Z!#G=XZ3A~E##eZN;M #g#R.tEY=3&4CEB{#4e?}J*#|!#KI5Lz# +r [W2^X# #+f_^O\\:T-]###"pZg##Y##?Uv#$bn#;dlM##TD|p'_hYF#*/#uHm.Hp 1(#kVq;` nQMHl}XFXD# - =M#n# #Ch{sy43 #zExEiN #]yu=S#'C###\\)eY#lY$i5}Fl#iabvO #mNWaJ&`oi.8K7:o#6#H4 *# # i Z 03*p*Am`F:J)4T&!mCwB# p! #=#3G#Pi#-[9/#Bp_0mr#*T# ?#">AcSVc eduB ) {_+ga#mdj17##lvv;ea0#|XO#RWw'4e uA`A[Nx#e]=^=#'>#}#V:ho## #A]k\\]tvp#D H2#b|LL\\#?]#P>8%>yF ?#ET[NDpB-Z:2r#{\\d C##1;Ez!{r#- DzWZ( I^J{#-[1E#49co3#,##TTfwvD#);$t,v?##BkFzU$#ps K2##v:s 6|L #CP@W#@# ######B#!#@# ######B#!##P#####PK##########! #*#######'###xl/printerSettings/printerSettings1.biniPI#;#QK#3##Q#9#\\B ##Ap a! IX.9 P###e#P#F#+####fW`a!dsb#}8SVej?? ~##` Q#|x ##.####`#v#'m #2#>6P##X=##z(# L`k#a)@r#>##*Spy/2#@S=#+#YL.SEp#`&A F#2 |(d*F#*cG#v0#; %#_##;@"D##42#0c8#L(N#4n#)N#+S|P@##U Xy#G5~h##_.sTvP###}#&a##y}#,#x8##2Yx^0##w#>^ #? #}u#`,# #i3 u1 w$Ru g*K01&)1[##Z,hL#j#-+# #t=mF! y0mI+###x ?V/_c)#:f7#rhD{@}.R # dw|4+gIG#V#NfuZ#P##wM#Cgu5#kd t5Q j l\\K#]^q#hlC/x;#h#wr#kAe %d#@# ######B#!#@# ######B#!##P'#####PK##########! #;##########xl/calcChain.xmllT]O0#}7? +cs=6mLF####B # ## si#:Z#z#@=W ?7q%ss| kK# ]sW#c#R) mQ&U#|]]B{t~}S,6a##d+.!|"A#F)&APe_i[Og5>z! >2#D;fA1vS#\\fA#$G!###P}a:## q j'[E#l#]n~8X#`_\\`*R# ##y #SqGN#6#G1):A;97(v$DFz8 ZF##sqR-Jd'A^*#`R3 S 3,#3.#8Sd@#1m#O8b? #####PK##########!#Ej##########docProps/core.xml ##(########################################################################### ################################################################################ ################################################################################ #######################|QK0##C{&es#``E-$w[IC#uk7Q| sI>TM#.#IR##@O"y%oZ# C"##E##@[-(A\\Vq#v#o| ##+\ ##H)FyM##C# w$##r#S~gBcs##qtz4v]tY##'eWk#TR0a +#$Z L 5/]il8Z##o}#Y@#Y#YLhLi#^1s)#2B#vh?(]@'#(etY S:#1D2Yflr(=###O#####PK##########! ####Q#######docProps/app.xml ##(########################################################################### ################################################################################ ################################################################################ #######################k0####a#dt@Y,#Mli##? $usl|AB#C!# Xp(L(# q##7#MD#0?hkh .X#T15#2Vp#s#2? K8##5P7e`m5 8" G#^n#99:\\Q`]#? C#PV#X)C#o#3@P#)_1=a@$#P}##AXD;? I/a#q#_ e#sN-? w]P5x &A#sC&C6 #('{