B Carty Financal Analysis Project Q Search Sheet Insert Page Layout Formulas Dat
ID: 2530251 • Letter: B
Question
B Carty Financal Analysis Project Q Search Sheet Insert Page Layout Formulas Data Review View insert ? Calibri (Body) , | 10 A- A- -- -?. Wrap Text BIU ?? .. Merge & Center, $, 96 , .00 +0 Conditional Format Cell 004% conditional asrable Styles . Format ' e' ener Sort & Filter 4 Lope: Clubgear Corp. 5 Balance Sheets: Horizontal Analysis 6 December 31, 2017, 2016, and 2015 December 11, 2017, 2015, and 2015 %of %of 2017 ItalAes 2016 Amau 13 Cash and Cath Equivalents 14 Aeceunts Receivable, set Preperty, Plant and Equipment, net 19 Property, Mant and Equipment, net 20 Total Intargibles and Othar Aaiets Total Intangibles and Other Assets %of 201 otal Assers % of 2016 Tatal Asse 2016 SAmau 28Current Portion of Long-Teem Deat Current Fortion of Long-Term Dett Curent Liabilities Cemmon Stock, $020 par value 3 Aoumulated Other Comprehensive Income Accumulated Other Comprehensive Iincome Total Liabilikies and Stackholders Equity Cover Page BS Averages Profitability Liquidity Leverage + ReadyExplanation / Answer
a) Lopez Clubgear Corp.
Balance Sheets: Horizontal Analysis
December 31, 2017, 2016, and 2015 (Amounts in million $)
b) Lopez Clubgear Corp.
Balance Sheets: Vertical Analysis
December 31, 2017, 2016, and 2015 (Amounts in million $)
FY 2017 vs FY 2016 FY 2016 vs FY 2015 Particulars 2017 $ Amounts % 2016 $ Amounts % 2015 Current Assets Cash and Cash Equivalents 727 352 93.87% 375 360 2400% 15 Accounts Receivable, net 651 -18 -2.69% 669 9 1.36% 660 Inventories 472 16 3.51% 456 18 4.11% 438 Other Current Assets 23 -2 -8% 25 4 19.05% 21 Total Current Assets 1,873 348 22.82% 1,525 391 34.48% 1,134 Long-Term Investments 153 22 16.79% 131 15 12.93% 116 Property, Plant and Equipment, net 2,242 -65 -2.82% 2,307 -110 -4.55% 2,417 Total Intangibles and Other Assets 867 -18 -2.03% 885 -34 -3.70% 919 Total Assets 5,135 287 5.92% 4,848 262 5.71% 4,586 Current Liabilities Short-Term Notes Payable 58 -9 -13.43% 67 27 67.50% 40 Current Portion of Long Term Debt 32 2 6.67% 30 4 15.38% 26 Accounts Payable 338 9 2.74% 329 -8 -2.37% 337 Accrued Expenses 206 2 0.98% 204 -12 -5.56% 216 Total Current Liabilities 634 4 0.63% 630 11 1.78% 619 Long-Term Debt 3,164 7 0.22% 3,157 -9 -0.28% 3,166 Total Liabilities 3,798 11 0.29% 3,787 2 0.05% 3,785 Stockholder's Equity Common Stock, $0.20 par value 40 0 0% 40 0 0% 40 Additional Paid-in Capital 210 0 0% 210 0 0% 210 Retained Earnings 1,029 254 32.77% 775 245 46.23% 530 Accumulated Other Comprehensive Income 58 22 61.11% 36 15 71.43% 21 Total Stockholder's Equity 1,337 276 26.01% 1,061 260 32.46% 801 Total Liabilities and Stockholder's Equity 5,135 287 5.92% 4,848 262 5.71% 4,586Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.