Sales COGS Gross margin Operating expenses Operating income Interest expense Income before taxes Income taxes (40%)...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Sales COGS Gross margin Operating expenses Operating income Interest expense Income before taxes Income taxes (40%) Net income Assets Cash A/R (net) Inventory Prepaid expenses Total current assets Capital assets (net) Total assets Patel's Fabrics Ltd. Comparative Income Statements 2016 $ 2016% 599, 100 291,000 308,100 106,200 201,900 11,200 190,700 76,280 114,420 2017 $ 538,900 259,200 279,700 104,600 175,100 10,500 164,600 65,840 98,760 Patel's Fabrics Ltd. Comparative Balance Sheets 32,000 126,860 60,000 11,000 229,860 668,900 898,760 2016 $ 2016% 2017 $ 25,800 127,000 80,700 10,000 243,500 576,000 819,500 2017% 2017% 2018 $ 508,100 234,300 273,800 104,100 169,700 11,900 157,800 63,120 94,680 2018 $ 20,500 94,300 56,000 4,600 175,400 540,300 715,700 2018% 2018% Liabilities & Shareholders' Equity Accounts payable Accrued expenses Total current liabilities Long-term debt Total liabilities Common stock ($0.50 par value) Additional paid in capital Retained earnings 53,120 11,000 64,120 170,000 234,120 6,000 99,000 559,640 664,640 898,760 81,200 12,240 93,440 160,000 253,440 $ 38.00 6,000 99,000 461,060 566,060 819,500 Total equity Total liabilities & equity Closing Stock Price Required: 1. Prepare a horizontal analysis for all 3 years. Use %, not dollars. What significant changes do you see? $ 35.00 79,100 41,700 120,800 150,000 270,800 5,000 62,000 377,900 444,900 715,700 $ 30.00 2. Prepare common-size financial statements for all 3 years. What significant changes do you see? 3.Assess Patel's liquidity by using liquidity ratios. Is the company's position improving or deteriorating? Explain your answer. 4. Assess Pippin's profitability by using profitability ratios. For ratios that require average balances calculate them for 2017 & 2018 only. Assess's Patel's profitability using these ratios. 5. How does the stock market view Pippin's performance over thses three years? Explain the basis for your answer. 6. After you have completed the above analysis, identify what you consider to be the three most significant weaknesses in Patel's performance. Sales COGS Gross margin Operating expenses Operating income Interest expense Income before taxes Income taxes (40%) Net income Assets Cash A/R (net) Inventory Prepaid expenses Total current assets Capital assets (net) Total assets Patel's Fabrics Ltd. Comparative Income Statements 2016 $ 2016% 599, 100 291,000 308,100 106,200 201,900 11,200 190,700 76,280 114,420 2017 $ 538,900 259,200 279,700 104,600 175,100 10,500 164,600 65,840 98,760 Patel's Fabrics Ltd. Comparative Balance Sheets 32,000 126,860 60,000 11,000 229,860 668,900 898,760 2016 $ 2016% 2017 $ 25,800 127,000 80,700 10,000 243,500 576,000 819,500 2017% 2017% 2018 $ 508,100 234,300 273,800 104,100 169,700 11,900 157,800 63,120 94,680 2018 $ 20,500 94,300 56,000 4,600 175,400 540,300 715,700 2018% 2018% Liabilities & Shareholders' Equity Accounts payable Accrued expenses Total current liabilities Long-term debt Total liabilities Common stock ($0.50 par value) Additional paid in capital Retained earnings 53,120 11,000 64,120 170,000 234,120 6,000 99,000 559,640 664,640 898,760 81,200 12,240 93,440 160,000 253,440 $ 38.00 6,000 99,000 461,060 566,060 819,500 Total equity Total liabilities & equity Closing Stock Price Required: 1. Prepare a horizontal analysis for all 3 years. Use %, not dollars. What significant changes do you see? $ 35.00 79,100 41,700 120,800 150,000 270,800 5,000 62,000 377,900 444,900 715,700 $ 30.00 2. Prepare common-size financial statements for all 3 years. What significant changes do you see? 3.Assess Patel's liquidity by using liquidity ratios. Is the company's position improving or deteriorating? Explain your answer. 4. Assess Pippin's profitability by using profitability ratios. For ratios that require average balances calculate them for 2017 & 2018 only. Assess's Patel's profitability using these ratios. 5. How does the stock market view Pippin's performance over thses three years? Explain the basis for your answer. 6. After you have completed the above analysis, identify what you consider to be the three most significant weaknesses in Patel's performance.
Expert Answer:
Answer rating: 100% (QA)
1 2 3 4 Sales 5 COGS 6 Gross margin 7 Operating expenses 8 Operating income 9 Interest expense 10 In... View the full answer
Related Book For
Posted Date:
Students also viewed these economics questions
-
Jen and Berry's sells ice-creams from its factory-shop in Petone. There is a managing director (Maynard Dibble), a marketing manager (Mary Salman) and a production manager (Peter Pritchard). Maynard...
-
On January 1, 2019, Par Inc. purchased 90% of the voting shares of Sub Inc. for $810,000. On that date, Sub's common stock and retained earnings were valued at S350,000 and S250,000 respectively. On...
-
A comparative balance sheet for Lomax Company containing data for the last two years is as follows: The following additional information is available about the companys activities during this year:...
-
Hewlett-Packard announced in early 1999 the spin-off of its Agilent Technologies unit to focus on its main business of computers and printers. HP retained a controlling interest until mid-2000, when...
-
In a small group, discuss whether the following statement from Burton Snowboards North America, manufacturers and marketers of a leading snowboard brand, meets the five criteria of a good mission...
-
A data firm records a large amount of data. Historically, .9% of the pages of data recorded by the firm contain errors. If 200 pages of data are randomly selected, a. What is the probability that six...
-
Interest rate parity Consider Figure 3.29, which indicates (approximately) the difference between interest rates in the United States and the UK, Rus Ruk on a one-year T-bill (i.e. a two-year bill...
-
Rodgers Corporation produces and sells football equipment. On July 1, 2014, Rodgers Corporation issued $65,000,000 of 10-year, 12% bonds at a market (effective) interest rate of 10%, receiving cash...
-
1. Read the articles assigned by your instructor to gain an understanding about how Big Data, data analytics, and new technologies are transforming external audits. After reading these articles,...
-
Peru Furniture City, Inc., sold $88,000 of furniture in May to customers who used their American Express Credit Cards. Such sales are subject to a 5% discount by American Express (a nonbank credit...
-
2-90. Determine the magnitude and coordinate direction angles of the resultant force. 2 m A 500 N 600 N 4 m B 8 m Prob. 2-90. C y 4 m
-
Question 2 Find the arc length of the curve r = -3 cos (0) - 3 over the interval 0 0 Enter an exact answer. 3 Provide your answer below: L =
-
(a) Explain how flooding protocol works? (b) name two methods that are used to reduce the number of redundant packets generated by the flooding routing algorithm and explain how those methods help...
-
Citadel Co. will receive $400,000 Canadian dollars in 6 months. Assume the annual interest rate of borrowing or lending Canadian dollar is 3% and the interest rate of borrowing or lending U.S. dollar...
-
4. How would straight-line depreciation or 100% first year depreciation affect your total cost estimates?
-
1. The contract size of one futures contract on the S&P 500 is $250 times the S&P 500 futures price - an increase by 1 index point means a transfer of $250 from the short to the long position....
-
Jeffery Ltd uses a process costing system. Its Spackling Department had no beginning Work in Process inventory. The department added direct materials of $200,000 and conversion costs of $321,300 durin
-
The Home Depot is the leading retailer in the home improvement industry and one of the 10largest retailers in the United States. The company included the following on its January 29, 2012, balance...
-
Mississippi Retailers expects to make inventory purchases in the next quarter as follows: April ....... $60,000 May ....... 70,000 June ....... 95,000 Prior experience has shown that 30 percent of a...
-
Smith Die Company manufactures cutting dies for the shoe industry. Each set of dies is custom designed to a customers templates. During the first week of May, six orders were received from customers....
-
Mega Chemical Company produces ZylexA and a related product called ZylexB. ZylexB, which sells for $15.00 per gallon, is made from a base of ZylexA plus additional ingredients. It takes 25 minutes to...
-
Generate a regression dataset by sampling a function from a GP prior and then adding some noise. Use ABC to sample from the posterior. Each sample should be generated by first sampling from the GP...
-
For the mixture model where each component is a one-dimensional Gaussian with variance 1 , show that the conditional distribution for the mean of the \(k\) th mixture component is that given by...
-
Implement the Gibbs sampler for the mixture model. Compute \(\hat{R}\) and the autocorrelation of the component means \(\mu_{k}\). How many samples are required for convergence? How much should the...
Study smarter with the SolutionInn App