Evaluate the current situation at Premier Furniture using ratio analysis for Designers and Walcott. Calculate the ratios
Fantastic news! We've Found the answer you've been seeking!
Question:
Evaluate the current situation at Premier Furniture using ratio analysis for Designers and Walcott. Calculate the ratios and briefly discuss your findings. Specifically, we need to do a ratio analysis for Designers and Walcott using their balance sheets and income statements. For Designers, assume a 42% tax rate. For Walcott, you do not need a tax rate.Report your ratios in two exhibits. See the following page for sample exhibits. Hints: Excel file explains how to calculate ratios.
Transcribed Image Text:
exhibit 1 designers Assets Cash Accounts receivable, net Inventory Total current assets Land Buildings, fixtures and equipment less: reserve for depreciation Net buildings, fixtures and equipment Investments Due from stockholders Deferred charges Total assets Liabilities and Net Worth Accounts payable Notes payable-employees Estimated federal income tax Current maturities on long-term debts Miscellaneous accruals Total current liabilities Notes payable-bank Mortgage loan Capital stock/Equity Earned surplus /Retained earnings Total liabilities and net worth exhibit 2 desingers income statement Sales less returns and allowances Net sales Cost of goods sold Gross profit less operating expenses Operating profit Other income Net after other income Other deductions Net profit (loss) before tax Net income (after tax Net profit) = Dividends paid 31 Jan. 1982 85 1385 1825 3295 355 1355 190 1165 65 0 40 4920 865 70 65 155 220 1375 545 2260 550 190 4920 31 Jan. 1983 65 1565 1820 3450 355 1370 290 1080 65 215 20 5185 870 80 360 205 1515 900 2250 550 -30 5185 31 Jan. 1982 31 Jan. 1983 11,670 1050 10620 6460 4160 3570 590 400 990 240 750 435 210 9,500 1115 8385 5125 3260 3090 175 65 235 245 -10 -5.8 210 31 Jan. 1984 50 1610 1825 3485 355 1575 395 1180 65 290 20 5395 925 80 220 65 1290 875 2630 665 -65 5395 31 Jan. 1984 9010 730 8280 5155 3125 2990 135 85 220 255 -35 -20.3 Designer's Ratio Analysis Ratios Liquidity Ratios Current Ratio Quick Ratio Asset management / Activity ratios Total assets tumover ratio Fixed assets turnover ratio Days sales outstanding (DSO) Inventory turnover Average sales per day Debt management / Leverage ratios Debt to assets ratio. Liabilities to assets ratio Debt to equity ratio Times-interest-earned (TIE) ratio Average purchase per day Days payable Profitability ratios Profit margin Operating profit Basic earning power (BEP) ROA ROE Current Assets / Current Liabilities (Current Assets -Inventory Current Liabilities Net Sales/totat assets. Net sales / net fixed assets Receivables /(annual net sales/365) (COGS)/Inventories Annual Net Sales / 365 Total debt / Total assets Total liabilities/total assets Total debt/Total common equity EBIT/ Interest expense (not reported) COGS/365 Accounts payable / (COGS/365) Net income / Net sales EBIT/ Net Sales EBIT/ Total assets Net income / total assets Net income /common equity 31 Jan.1982 31 Jan. 1983 31 Jan. 1984 2.396363636 2.277227723 2.701550388 1.069090909 1.075907591 1.286821705 2.158536585 1.617164899 1.534754402 6.535384615 4.832853026 4.335078534 47.60122411 68.12462731 70.97222222 4.664259928 3.274760383 3.201863354 29.09589041 22.97260274 22.68493151 0.8495934959 0.899710704 0.8887859129 0.8495934959 0.899710704 0.8887859129 5.648648649 8.971153846 7.991666667 17.69863014 14.04109589 14.12328767 48.87383901 61.96097561 65.49466537 0.04096045198 -0.00069171138 -0.00245169082 0.07062146893 -0.00119260584-0.00422705314 0.1524390244 -0.00192864030 -0.00648748841 0.08841463415 -0.00111861137 -0.00376274328 exhibit 1 designers Assets Cash Accounts receivable, net Inventory Total current assets Land Buildings, fixtures and equipment less: reserve for depreciation Net buildings, fixtures and equipment Investments Due from stockholders Deferred charges Total assets Liabilities and Net Worth Accounts payable Notes payable-employees Estimated federal income tax Current maturities on long-term debts Miscellaneous accruals Total current liabilities Notes payable-bank Mortgage loan Capital stock/Equity Earned surplus /Retained earnings Total liabilities and net worth exhibit 2 desingers income statement Sales less returns and allowances Net sales Cost of goods sold Gross profit less operating expenses Operating profit Other income Net after other income Other deductions Net profit (loss) before tax Net income (after tax Net profit) = Dividends paid 31 Jan. 1982 85 1385 1825 3295 355 1355 190 1165 65 0 40 4920 865 70 65 155 220 1375 545 2260 550 190 4920 31 Jan. 1983 65 1565 1820 3450 355 1370 290 1080 65 215 20 5185 870 80 360 205 1515 900 2250 550 -30 5185 31 Jan. 1982 31 Jan. 1983 11,670 1050 10620 6460 4160 3570 590 400 990 240 750 435 210 9,500 1115 8385 5125 3260 3090 175 65 235 245 -10 -5.8 210 31 Jan. 1984 50 1610 1825 3485 355 1575 395 1180 65 290 20 5395 925 80 220 65 1290 875 2630 665 -65 5395 31 Jan. 1984 9010 730 8280 5155 3125 2990 135 85 220 255 -35 -20.3 Designer's Ratio Analysis Ratios Liquidity Ratios Current Ratio Quick Ratio Asset management / Activity ratios Total assets tumover ratio Fixed assets turnover ratio Days sales outstanding (DSO) Inventory turnover Average sales per day Debt management / Leverage ratios Debt to assets ratio. Liabilities to assets ratio Debt to equity ratio Times-interest-earned (TIE) ratio Average purchase per day Days payable Profitability ratios Profit margin Operating profit Basic earning power (BEP) ROA ROE Current Assets / Current Liabilities (Current Assets -Inventory Current Liabilities Net Sales/totat assets. Net sales / net fixed assets Receivables /(annual net sales/365) (COGS)/Inventories Annual Net Sales / 365 Total debt / Total assets Total liabilities/total assets Total debt/Total common equity EBIT/ Interest expense (not reported) COGS/365 Accounts payable / (COGS/365) Net income / Net sales EBIT/ Net Sales EBIT/ Total assets Net income / total assets Net income /common equity 31 Jan.1982 31 Jan. 1983 31 Jan. 1984 2.396363636 2.277227723 2.701550388 1.069090909 1.075907591 1.286821705 2.158536585 1.617164899 1.534754402 6.535384615 4.832853026 4.335078534 47.60122411 68.12462731 70.97222222 4.664259928 3.274760383 3.201863354 29.09589041 22.97260274 22.68493151 0.8495934959 0.899710704 0.8887859129 0.8495934959 0.899710704 0.8887859129 5.648648649 8.971153846 7.991666667 17.69863014 14.04109589 14.12328767 48.87383901 61.96097561 65.49466537 0.04096045198 -0.00069171138 -0.00245169082 0.07062146893 -0.00119260584-0.00422705314 0.1524390244 -0.00192864030 -0.00648748841 0.08841463415 -0.00111861137 -0.00376274328
Expert Answer:
Answer rating: 100% (QA)
Based on the data provided here are the calculated ratios and findings for both Designers and Walcott Exhibit 1 Designers 1 Liquidity Ratios Current R... View the full answer
Related Book For
Management Accounting Information for Decision-Making and Strategy Execution
ISBN: 978-0137024971
6th Edition
Authors: Anthony A. Atkinson, Robert S. Kaplan, Ella Mae Matsumura, S. Mark Young
Posted Date:
Students also viewed these mathematics questions
-
Briefly summarize the current situation at CMC identifying its key challenges and the effect of the challenge on the performance of the facility. How should CMC: a. Address its growth of outpatient...
-
The comparative balance sheets and income statements for Gypsy Company follow: Income Statement For the Year Ended December 31, 2014 Sales revenue ......... $61,200 Cost of goods sold ...... (24,500)...
-
The comparative balance sheets and income statements for Gypsy Company follow: Income Statement For the Year Ended December 31, 2017 Sales revenue.................................... $ 61,200 Cost of...
-
Limits from graph In this problem we evaluate limits from the graph. Consider the graph of f given in [Figure 1]. Evaluate each of the following limits (or explain why if the limit does not exist)....
-
What could the team have done to avoid the situation described?
-
As we drill down into the rocks of Earth's crust, the temperature typically increases by 3.0 C for every 100 m of depth. Oil wells can be drilled to depths of 1790 m. If water is pumped into the...
-
Consider Problem 8.38. A more realistic solution would account for the resistance to heat transfer due to free convection in the paraffin during melting. Assuming the tube surface to have a uniform...
-
Two alternative programs to save 50 more lives per year entail providing more cardiac intensive care facilities and redesigning dangerous highway interchanges. The price of a new cardiac intensive...
-
What is the net electric force on charge B in (Figure 1)? Suppose that a = 2.5 cm and b = 1.2 cm. Express your answer to two significant figures and include the appropriate units. Enter negative...
-
m 30C Haze n 4. Question 4 An online store wants to analyze various aspects of using coupons, including the distribution of discounts and savings. The company is developing a report that displays the...
-
The Light Company manufactures a single type of desk-lamp which has a selling price of 49 per un Annual sales volume is 8,000 units. The company is considering changing its production methods ar...
-
Bond X is a 4-year 5% bond priced at 93. Bond Y is a 5-year 7% bond priced at 105. Bond Z is a 3-year ZCB priced at 80. What is the yield of a portfolio with 50% in Bond X, 30% in Bond Y, and 20% in...
-
Calculate Financial Statement Ratios Using the chart below (which replicates portions of the: "10 Point Test" Ratios for Overland Park, KS in FY2015 on page 88 in Kyoko and Marlowe). In the Ten Point...
-
In September 2023, suppose FedEx had the following characteristics: Stock price = $250/share Shares outstanding = 256 million Net Debt (debt - cash) = $13.7 billion Equity beta = 1.40 i. Using this...
-
. ABC Co., makes and markets cars and toothpaste. It is considering a new factory to manufacture televisions. The details of this 5-year project (i.e. initial investment followed by 5 years of...
-
A car takes a turn in the road on a banked curve that is at an angle of 10 . The path of the car is the shape of a circle of radius r. Find the speed a car of mass m can have in order to make the...
-
Imagine that you are in your 40s and a CEO of your own business. What is your business like? (2) Suppose the Fed raises the federal funds rate 0.5% in May 3-4 FOMC meeting, how do you think your...
-
An environmentalist wants to determine if the median amount of potassium (mg/L) in rainwater in Lincoln County, Nebraska, is different from that in the rainwater in Clarendon County, South Carolina....
-
What are operations management processes within the Balanced Scorecards process perspective, and what are some typical objectives for operations management processes?
-
Boston Box Company has two service departments, maintenance and grounds, and two production departments, fabricating and assembly. Management has decided to allocate maintenance costs on the basis of...
-
Airport Coach Service Company operates scheduled coach service from Boston's Logan Airport to downtown Boston and to Cambridge. A common scheduling service center at the airport is responsible for...
-
At the instant shown in Figure 32. 40 , the potential difference across the capacitor is half its maximum value and the charge on the plates is increasing. Draw the direction of the current and...
-
Construct a phasor diagram representing the current and potential difference in Figure 32. 10 at \(t=T / 4, T / 2\), and \(3 T / 4\). Data from Figure 32.10 Ve maximum, current zero Ve minimum,...
-
The research laboratory you work in is less than a block away from the transmitting antenna of a radio station that broadcasts at \(1100 \mathrm{kHz}\). You notice that every piece of equipment in...
Study smarter with the SolutionInn App