Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Do a trend and peer comparison analysis of the companys solvency, stored liquidity, cash flow liquidity and performance trends for the current year compared to
Do a trend and peer comparison analysis of the companys solvency, stored liquidity, cash flow liquidity and performance trends for the current year compared to the previous year by looking at:
the trends and peer comparison analysis for cash flow looking at days inventory, days accounts receivable, days accounts payable, and cash to cash days.
Current Year Previous Year 7,270,965 6,543,868 5.088.078 4.580.708 2,182,887 1,963,160 1.648,000 1,483,200 534,887 479,960 4.012 4.500 530,875 475,460 200.484 179.557 330,391 295,903 64,359 57,641 266,032 238,262 Use Susie'sEmporium Financial Data (in thousands) Financial Statements: Current & Previous Year Income Statement in thous.) Total Revenue Cost of Goods Sold Gross Profit Selling & Administrative Costs Earnings Before Interest & Taxes 1 Interest Expense 2 Earnings Before Taxes Income Tax Expense Net Income 5 Dividend Paid 5 Addition to Ret. Erngs 3 Balance Sheet (in thous.) Assets: Cash 1 Accounts Receivable 2 Inventory 2 3 Other Current Assets 4 Total Current Assets 5 Net PP&E 5 Other Long-term Assets 7 Total Assets B Liabilities & Equity: e Accts. Payable Accrued Liabilities Notes Payable 2 Total Curr. Liabs. 3 Long-term Debt 4 Total Debt 5 Common Stock 5 Retained Earnings 7 Total Equity 3 Total Debt & Equity Source 102,743 27758 Curr. Yr. 118,936 66,827 1,527,187 99.740 1,812,690 1,657,919 88.727 3,559,336 Prev. Yr. 221,679 94,585 1,390,767 91.767 1,798,798 1,514,138 78.768 3,391,704 136,420 7,973 143781 9959 60,663 12,127 52 137828 1,006,700 184,386 589 1,191,675 578.474 1,770,149 51,973 1.737.214 1.789.187 3,559,336 946,037 172,259 537 1,118,833 440.646 1,559,479 361,043 1.471.182 1.832.225 3,391,704 Total S&U 309070 266,032 607,203 607,203 330,391 83,000 Financial Ratios ROE ROA NPM AU GPM OPM Fixed Asset Util. Current Year 18.47% 9.28% 4.54% 2.04 30.02% 7.36% 3.07 Prev. Year 16.15% 8.72% 4.52% 1.93 30.00% 7.33% 3.03 27,758 -136,420 -7,973 60,663 12.127 369,546 Indirect Cash Flow Statement for Curr. Year Cash Flow from Operations: 2 Net Income 3 Depreciation Expense Adjustments for Cash Not Received or Paid 5 Plus Decline in Accounts Receivables 5 Less Rise in Inventory Less Rise in Other Current Assets 8 Plus Rise in Accounts Payable Plus Rise in Accrued Liabilities Net Cash Flow from Operations 1 Cash Used for Investments: 2. Change in Gross Fixed Assets B (calculated as Change NPPE+Depr. Expense) 4 Net Cash Used for Investments 5 Cash from Financing 5 Less Dividends Paid 7 Rise in Notes Payable (i.e. new notes payable) 3 Rise in Long-term Debt Falll in Common Stock (i.e. stock buy-back) Net Cash from Financing 1 Change in Cash: CFO Less CFI + CFF 2 Check: Curr. Cash Bal Less Previous Cash Bal. 3 Change in Cash Balance 4 236,740 Days Inventory Days Acct.Rec. Days Acct Pay. CashtoCashDays Current Ratio Quick Ratio Debt to Assets TIE LTDebttoAssets EM 236,740 Peer Ave 20.64% 7.00% 5.20% 1.34 35.00% 7.50% 3.00 Peer Ave 135 days 6 days 72.00 69.00 days 1.39 0.37 64.0096 4.39 20.00% 2.77 109.55 3.35 72.22 40.69 1.52 0.24 49.73% 133.32 16.25% 1.99 110.82 5.28 75.38 40.71 1.61 0.36 45.98% 106.66 12.99% 1.85 -64,359 52 137,828 -309,070 -235,549 -102,743 -102,743Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started