Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Pricelo Balance Sheet Dollars (000s Omitted) Vertical Analysis Horizontal Analysis 12/31/X6 12/31/X7 12/31/X8 12/31/X6 12/31/X7 12/31/X8 (X7-X6/X6 (X8X7)/X7 (Audited) (Audited) (Unaudited) (Audited)(Audited) (Unaudited) (Audited) (Unaudited)

image text in transcribedimage text in transcribedimage text in transcribed

Pricelo Balance Sheet Dollars (000s Omitted) Vertical Analysis Horizontal Analysis 12/31/X6 12/31/X7 12/31/X8 12/31/X6 12/31/X7 12/31/X8 (X7-X6/X6 (X8X7)/X7 (Audited) (Audited) (Unaudited) (Audited)(Audited) (Unaudited) (Audited) (Unaudited) 885 63 14,402 2,682 491 6,589 9,762 708 24,935 18,267 43,202 514 27,801 9,182 638 9,757 19,577 1,449 49,341 15,900 65,241 51,076 18,049 4,151 16,935 39,153 3,015 94,111 24,029 118,140 0% 33% 6% 1% 15% 23% 2% 58% 42% 100% 1% 43% 14% 1% 15% 30% 2% 76% 24% 100% 1% 43% 15% 4% 14% 33% 3% 80% 20% 100% 716% 93% 242% 30% 48% 101% 105% 98% (13%) 51% 72% 84% 97% 551% 74% 100% 108% 91% 51% 81% Assets Cash Accounts receivable InventoriesRM InventoriesWIP InventoriesFG Total inventories Other current assets Total current assets Fixed assets (net) Total assets Liability and Equity Accounts payable Accrued liabilities Current portion L/T debt Income taxes payable Total current liabilities Bank debt Deferred income taxes Total liabilities Common stock Retained earnings Total liabilities and equity 7,344 15,072 17% 11% 3,127 5,46 7% 4% (12%) (14%) 39% 44% 6% 4% (4%) 2,707 1,554 14,732 14,800 685 30,217 7,775 5,210 43,202 900 2,619 24,059 19,841 1,254 45,154 7,775 12,312 65,241 13,288 4,710 1,250 3,782 23,030 62,057 1,881 86,968 7,903 23,269 118,140 34% 34% 2% 70% 18% 12% 100% 23% 8% 1% 4% 37% 30% 2% 69% 12% 19% 100% 1% 3% 19% 53% 2% 74% 7% 20% 100% 105% 75% (67%) 69% 63% 34% 83% 49% 0% 136% 51% 213% 50% 93% 2% 89% 81% Pricelo Income Statement Dollars (000s Omitted) Vertical Analysis Horizontal Analysis 12/31/X6 12/31/X7 12/31/X8 12/31/X6 12/31/X7 12/31/X8 (X7-X6/X6 (X8X7)/X7 (Audited) (Audited) (Unaudited)(Audited)(Audited) (Unaudited) (Audited) (Unaudited) 78,428 133,504 183,767 103% 104% 101% 70% 38% 2,284 5,270 2,644 3% 4% 1% 131% (50%) 76,144 128,234 181,123 100% 100% 100% 68% 41% 46,213 70,756 94,934 61% 55% 52% 53% 34% 29,931 57,478 86,189 39% 45% 48% 92% 50% 20,105 42,600 64,285 26% 33% 35% 112% 51% 9,826 14,878 21,904 13% 12% 12% 51% 47% 1,930 1,584 3,189 3% 1% (18% 101% 7,896 13,294 18,715 10% 10% 68% 41% 3,807 6,189 7,761 5% 63% 25% 4,089 7,105 10,954 6% 74% 54% 0.46 1.21 2% Gross sales Less: Returns and allowances Net sales Cost of goods sold Gross margin Sell, advertising, R&D expenses Income from operations Interest expense Income before taxes Income taxes Net income EPS Ratios Current Quick Receivable turnover Days' sales in ending receivables Inventory turnover Days' sales in ending inventory 10% 5% 4% 5% 6% 0.78 4.1 2.1 1.2 1.7 1.0 5.3 68.1 2.3 6.3 57.1 4.7 76.6 3.2 112.5 4.7 4.8 76.0 75.0 Interest expense/Debt 0.11 0.08 0.05

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions

Question

Write short notes on Interviews.

Answered: 1 week ago