Kindly fill in the table completely and show the complete formula used to get the values. G167
Fantastic news! We've Found the answer you've been seeking!
Question:
Kindly fill in the table completely and show the complete formula used to get the values.
Transcribed Image Text:
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 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
Expert Answer:
Related Book For
Elementary Surveying An Introduction to Geomatics
ISBN: 978-0273751441
13th Edition
Authors: Charles D. Ghilani, Paul R. Wolf
Posted Date:
Students also viewed these accounting questions
-
You and a business partner opened a fitness gym three years ago. Your partner oversees managing the operations of the gym, ensuring the right equipment is on hand, maintenance is conducted, and the...
-
clipboard font 19 x fx b d abu bakar enterprise income statement for the financial year ended 2018 notes rm rm contract calibri be copy ste b iu format painter aee clipboard f font align 5 x fic a b...
-
Suppose losses cause industry X to contract and, as a result, the prices of relevant inputs decline. Industry X is? A. a constant-cost industry. B. an increasing-cost industry. C. a decreasing-cost...
-
The following matrix is row-equivalent to the augmented matrix of a linear system. Describe the solution set of that system. 1 0 1 5 0000 0013 0000 Find all possible values of a for which the...
-
A leveraged buyout is a financial strategy in which a group of investors gain voting control of a firm and then liquidate its assets in order to repay the loans used to purchase the firms shares. How...
-
Determine the convergence or divergence of the sequence with the given nth term. If the sequence converges, find its limit. a n || (4n)! (4n 1)!
-
\(\frac{5}{b^{6}}\) Rewrite the expression without a denominator.
-
Presented below are selected transactions at Ridge Company for 2015. Jan. 1 Retired a piece of machinery that was purchased on January 1, 2005. The machine cost $62,000 on that date. It had a useful...
-
When gaining an understanding of the client at the industry level, the auditor would be least concerned about: 1.the level of demand for the goods and services provided by competitors 2.current in...
-
Kitchen World Inc. is a Canadian controlled private corporation (CCPC) that operates a retail business selling cooking utensils, knives and small appliances for both professional chefs and home...
-
Describe direct and indirect measurement as well as levels of measurement. Grove & Gray Ch. 10
-
At the time of writing, Husky Energy Inc. had a bond outstanding with approximately 9 years to maturity (18 semiannual coupons) and a coupon rate of 3.60%. The bond was currently selling for $99.45....
-
It may seem obvious that the amount of data in the world keeps getting larger and larger, but what is really meant by Big Data? Physical size of the storage device? Number of records? How do we...
-
Suggest two brain areas most likely to be engaged by the shocking image on the cigarette pack and draw on neuromarketing theories of attention, learning and emotion to discuss how engagement of these...
-
There are three levels of efficiency under the efficient market hypothesis (EMH), namely weak form, semi-strong form and strong form. a) Describe a market anomaly that refutes the weak form of the...
-
Stress Management, Healthy Sleep, and Brain Health After reviewing readings and media on Stress and Stress Management, take some time to reflect upon the importance of stress management for yourself...
-
1. Start Excel open the student data file Excel02_Expenditures, and then compare your screen with Figure 1. When columns in a worksheet are not wide enough, the labels in the cells will be truncated...
-
Ball bearings are widely used in industrial applications. You work for an industrial food machinery manufacturer and your role is to design the driveshaft assembly on a new type of equipment that...
-
Repeat Problem 16.12 using distances for weighting. Assume the following lengths for the problem? a) Most probable values for the elevations of A and B? b) Standard deviations of the adjusted...
-
Discuss how a laser is used in pipeline layout.
-
Convert the bearings in following Problems to azimuths from north and compute the angle, smaller than 180, between successive bearings. N27o50' 05'' E, S38o 12'' 44'' E, S23o 16' 22'' W, and N73o 14'...
-
Each contributed \($50,000\) cash to start the business and received 4,000 shares of capital. The store completed its first year of operations on December 31, 2011. On that date, the following...
-
On January 1, 2013, three individuals organized West Company as a corporation. Each individual invested \(\$ 10,000\) cash in the business. On December 31, 2013, they prepared a list of resources...
-
Plaza Hotels acquired a 90 percent interest in Stardust Casinos on January 1, 2017 for \($51,100,000.\) The fair value of the 10 percent noncontrolling interest at the date of acquisition was...
Study smarter with the SolutionInn App