Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Kindly fill in the table completely and show the complete formula used to get the values. G167 B D E G H J K 1

Kindly fill in the table completely and show the complete formula used to get the values.
G Н. Jк Dec. 31, 2005 $% of TA Industry Average % of TA 1,097 15,919 12,570 6% 20% 31% 5% 6.840 9080 G167 X ✓ fx Bс DE FC19 : x fc BС DE FG HJ K8% 5% 1,205 1,008 3,570 84 1,995 7,862 2,940 3,243 1,460 5,958 336 3,360 14,357 6,100 6.323 2.24C66 1 X ✓ fix mK C2003 $ % of Sales 50,400 35,431 14,969 EF 2004 $ % of Sales 65,100 45,872 19,228 H2005 Average % of SalEvaluation Time Cross- series sectional 2003-05 2005 Industry Average 2003 2004 2005 1.61 0.8 9.4 3.8 6.4 1.81 58 59 60 61 62Evaluation Trend Industry. Analysis Analysis 2003-05 2005 Industry Average 2003 2004 2005 66.7% 3.4 5.4% 4.4% 8.0% 17.1% 72 7B СD EF 2004 2005 C116 1 X ✓ fx А88 89 Cash Flow Statement 90 Cash, beginning of year 91 92 Operating activities 93 Net in

C103 BС DE FG A103 Investment activities 104 Fixed asset acquisitions 105 Change in intangible assets 106 Change in all o


G167 B D E G H J K 1 Financial Performance Spreadsheet 2 Company Name: Plush Carpet Mill, Inc. Industry Average % of TA Dec. 31, 2005 Dec. 31, 2003 % of TA Dec. 31, 2004 % of TA 5 Balance Sheet ($000) 6 Assets Current Assets Cash & marketable securities $ % of TA 1,512 6,237 1,176 10,271 7.838 5.140 24,425 9 080 2 958 6 122 588 1,790 32,925 1,097 15.919 12 570 6% 20% 31% 5% Accounts receivable 10 Inventories 4,536 3,780 16,065 6.300 2 050 4,250 567 1.323 22,205 Prepaid expenses 12 13 Gross fixed assets Less: Accumulated depreciation 6,840 36,426 12 918 4. 250 11 Total current assets 62% 14 15 Net Fixed assets 8,668 28% 16 Intangible assets 17 All other noncurrent assets Total assets 605 1,985 47,684 4% 6% 18 100% 19 20 Liabilities and Stockholders' Equity 21 Current Notes :Liabilities 1,205 1,008 3,570 84 3,243 1,460 5.958 336 3,360 14,357 C 400 6,323 2,246 9.955 336 5,016 23,876 22 payable Current maturities--L.T.D Accounts payable Income taxes payable 8% 5% 16% 0% 8% 36% 23 24 25 26 Accruals and other current liabilities 1,995 7,862 27 Total current liabilities

Step by Step Solution

3.44 Rating (160 Votes )

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

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

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

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

Get Started

Recommended Textbook for

Elementary Surveying An Introduction to Geomatics

Authors: Charles D. Ghilani, Paul R. Wolf

13th Edition

978-0132554343, 132554348, 978-0273751441

More Books

Students also viewed these Accounting questions

Question

Brief the importance of span of control and its concepts.

Answered: 1 week ago

Question

What is meant by decentralisation?

Answered: 1 week ago

Question

Write down the Limitation of Beer - Lamberts law?

Answered: 1 week ago

Question

Discuss the Hawthorne experiments in detail

Answered: 1 week ago

Question

Discuss how a laser is used in pipeline layout.

Answered: 1 week ago

Question

Which company is competitively strongerDell or Hewlett-Packard?

Answered: 1 week ago