ࡱ> 8:7  bjbj 4hh  81 =B".QQQQQ,,,!!!!!!!$p#&h!,,,,,!QQ!ttt,^QQ!t,!ttra T=!Qj !"0B" zz&@z&=!z&=!p,,t,,,,,!!4@,,,B",,,,z&,,,,,,,,, : FINANCIAL ANALYSIS ASSIGNMENT Each team (or individual) will perform a financial analysis of the assigned company. The analysis will consist of ratios, common size statements, and percentage change statements. Financial statements will include balance sheet, income/expense, and statement of cash flow. All calculations are to be done using Excel and the quantified information presented in spreadsheet format. Input the financial statements for the three years into a spreadsheet. Using the statement you have prepared, compute as many of the ratios as you can that are in your text on page 136. Based on these ratio values, perform a trend analysis. Prepare common size statements for the three most recent years. Prepare percentage change statements for the last two years by using the three year data for your balance sheet and income statement data. (Not required for Statement of Cash Flows). Written Report to Accompany Spreadsheet Output: Prepare a summary report that includes a basic profile of the company and identifies its chief competitors. Summarize your spreadsheet results, evaluating ratios for liquidity, asset management, debt, and profitability. Your summary should be in paragraph form using a word processor. Due date for this assignment is April 1st.      *-z{  2 h s  < ^ |  b - 8 < Q         hSSjhSSUhX?"hSh :hS-hF2whhbFh@h!4 hF2w5>* h!45>*/z      gdS-gdbFh^hgd!4h^hgd@ & Fgd!4 & FgdgdF2w$a$gdF2w      gdbFgdS-21h:p[/ =!"#$% ^ 2 0@P`p2( 0@P`p 0@P`p 0@P`p 0@P`p 0@P`p 0@P`p8XV~_HmH nH sH tH @`@ NormalCJ_HaJmH sH tH DA D Default Paragraph FontRiR  Table Normal4 l4a (k (No List HH H Balloon TextCJOJQJ^JaJ44 S-Header  H$66 S- Header CharCJaJ4 "4 S-Footer  H$616 S- Footer CharCJaJPK![Content_Types].xmlj0Eжr(΢Iw},-j4 wP-t#bΙ{UTU^hd}㨫)*1P' ^W0)T9<l#$yi};~@(Hu* Dנz/0ǰ $ X3aZ,D0j~3߶b~i>3\`?/[G\!-Rk.sԻ..a濭?PK!֧6 _rels/.relsj0 }Q%v/C/}(h"O = C?hv=Ʌ%[xp{۵_Pѣ<1H0ORBdJE4b$q_6LR7`0̞O,En7Lib/SeеPK!kytheme/theme/themeManager.xml M @}w7c(EbˮCAǠҟ7՛K Y, e.|,H,lxɴIsQ}#Ր ֵ+!,^$j=GW)E+& 8PK!Ptheme/theme/theme1.xmlYOo6w toc'vuر-MniP@I}úama[إ4:lЯGRX^6؊>$ !)O^rC$y@/yH*񄴽)޵߻UDb`}"qۋJחX^)I`nEp)liV[]1M<OP6r=zgbIguSebORD۫qu gZo~ٺlAplxpT0+[}`jzAV2Fi@qv֬5\|ʜ̭NleXdsjcs7f W+Ն7`g ȘJj|h(KD- dXiJ؇(x$( :;˹! I_TS 1?E??ZBΪmU/?~xY'y5g&΋/ɋ>GMGeD3Vq%'#q$8K)fw9:ĵ x}rxwr:\TZaG*y8IjbRc|XŻǿI u3KGnD1NIBs RuK>V.EL+M2#'fi ~V vl{u8zH *:(W☕ ~JTe\O*tHGHY}KNP*ݾ˦TѼ9/#A7qZ$*c?qUnwN%Oi4 =3ڗP 1Pm \\9Mؓ2aD];Yt\[x]}Wr|]g- eW )6-rCSj id DЇAΜIqbJ#x꺃 6k#ASh&ʌt(Q%p%m&]caSl=X\P1Mh9MVdDAaVB[݈fJíP|8 քAV^f Hn- "d>znNJ ة>b&2vKyϼD:,AGm\nziÙ.uχYC6OMf3or$5NHT[XF64T,ќM0E)`#5XY`פ;%1U٥m;R>QD DcpU'&LE/pm%]8firS4d 7y\`JnίI R3U~7+׸#m qBiDi*L69mY&iHE=(K&N!V.KeLDĕ{D vEꦚdeNƟe(MN9ߜR6&3(a/DUz<{ˊYȳV)9Z[4^n5!J?Q3eBoCM m<.vpIYfZY_p[=al-Y}Nc͙ŋ4vfavl'SA8|*u{-ߟ0%M07%<ҍPK! ѐ'theme/theme/_rels/themeManager.xml.relsM 0wooӺ&݈Э5 6?$Q ,.aic21h:qm@RN;d`o7gK(M&$R(.1r'JЊT8V"AȻHu}|$b{P8g/]QAsم(#L[PK-![Content_Types].xmlPK-!֧6 +_rels/.relsPK-!kytheme/theme/themeManager.xmlPK-!Ptheme/theme/theme1.xmlPK-! ѐ' theme/theme/_rels/themeManager.xml.relsPK]       8@0(  B S  ?  zc  3b-<Q  b-<Q  &%4m.?I4m.,B Jo4m.^`o(. ^`hH. pLp^p`LhH. @ @ ^@ `hH. ^`hH. L^`LhH. ^`hH. ^`hH. PLP^P`LhH.^`o(. ^`hH. pLp^p`LhH. @ @ ^@ `hH. ^`hH. L^`LhH. ^`hH. ^`hH. PLP^P`LhH.h ^`hH.h ^`hH.h pLp^p`LhH.h @ @ ^@ `hH.h ^`hH.h L^`LhH.h ^`hH.h ^`hH.h PLP^P`LhH.^`o(. ^`hH. pLp^p`LhH. @ @ ^@ `hH. ^`hH. L^`LhH. ^`hH. ^`hH. PLP^P`LhH.Jo?I,B&%?                            :Z~SX?"!4@bFPSS}X[F2w,DSS-Hw8]8 @AX@UnknownG*Ax Times New Roman5Symbol3. *Cx Arial5. *[`)TahomaA BCambria Math"1hfffL L 4  2QHX ?F2w2!xxRATIO ANALYSIS ASSIGNMENTjsuJSU    Oh+'0x  ( 4 @ LX`hpRATIO ANALYSIS ASSIGNMENTjsuNormalJSU4Microsoft Office Word@ @^@&"@ L՜.+,0 hp|  JSU   RATIO ANALYSIS ASSIGNMENT Title  !"#$%&()*+,-.01234569Root Entry Fp| ;Data  1Table&WordDocument4SummaryInformation('DocumentSummaryInformation8/CompObjy  F'Microsoft Office Word 97-2003 Document MSWordDocWord.Document.89q