After graduating from college in May 2018, Ryan Crews started his career in finance at the...
Fantastic news! We've Found the answer you've been seeking!
Question:
![student submitted image, transcription available below](https://dsd5zvtm8ll6.cloudfront.net/questions/2024/01/65b9dabb20828_1706678969957.jpg)
![student submitted image, transcription available below](https://dsd5zvtm8ll6.cloudfront.net/questions/2024/01/65b9dabb83a6b_1706678970632.jpg)
![student submitted image, transcription available below](https://dsd5zvtm8ll6.cloudfront.net/questions/2024/01/65b9dabb79e77_1706678970173.jpg)
![student submitted image, transcription available below](https://dsd5zvtm8ll6.cloudfront.net/questions/2024/01/65b9dabb7df37_1706678970410.jpg)
Transcribed Image Text:
After graduating from college in May 2018, Ryan Crews started his career in finance at the W&T Corporation, a small- to medium-sized warehouse distributor in Nashville, Tennessee. The company was founded by David Winston and Colin Tabor in 2005, after they have worked together in management at Walmart. Although Crews had an offer from Sam's Club, he became excited about the opportunity with W&T For W&T, 2017 tumed out to be a good financial year. But in 2018, the company experienced a 5.3 percent sales reduction, where sales declined from $5.8 million to $5.5 million. The downturn then led to other financial problems, including a 50 percent reduction in the company's stock price. The share price went from $38 per share at the end of 2017 to $19 per share at the end of 2018! David Winston and Colin Tabor want to understand what may have happened. Financial information for W&T for both years is shown in the popup window, for per-share data, are shown in thousands. 4 where all the numbers, except W and T Corporation Income Statement ($ thousands) for the Years Ended 12/31/2017 and 12/31/2018 2017 Sales Cost of goods sold Gross profits Operating expenses Selling, general, and administrative expenses Depreciation expenses Total operating expenses Operating profits Interest expense Earnings before taxes (taxble income) Income taxes Net income Additional information: Number of common shares outstanding Dividends paid to stockholders Market price per share $ $ $ $ $ 5,800 $ (3.600) 2,200 $ (800) (330) (1.130) 1,070 (190) 880 (185) 695 150 $94 $38 2018 5,500 (3,500) 2,000 (750) (500) $ (1,250) $ 750 (275) 475 (100) 375 150 $94 $19 18 W and T Corporation Balance Sheet($ thousands) for 12/31/2017 and 12/31/2018 ASSETS Cash Accounts receivable Inventories Other current assets Total current assets Gross fixed assets Accumulated depreciation Net fixed assets Total assets LIABILITIES (DEBT) AND EQUITY Accounts payable Short-term notes payable Total current liabilities Long-term debt Total liabilities Common equity Common stock Retained earnings Total common equity Total liabilities and equity Print MA SAM $ $ S GA $ $ Done 1,735 2,350 4,550 4,950 (1,600) (2,300) 2,950 2,650 $ 4,685 $ 5,000 $ $ 2017 300 700 600 135 500 350 850 1,250 2,100 $ $ $ S 2018 485 925 780 160 740 400 1,140 1,325 2,465 1,000 1,585 2,585 $ 2,535 4,685 $ 5,000 1,000 1,535 Days in inventories Operating return on assets Operating profit margin Total asset turnover Fixed asset turnover Debt ratio Times interest earned 2017 60.83 days Sales Cost of goods sold Gross profits 2017 22.8% 2017 18.45 % 2017 1.24 X 2017 1.97 X 2017 44.8% 2017 5.63 X 2017 26.9 % Operating expenses Selling, general, and administrative expenses Depreciation expenses Total operating expenses Operating profits Interest expense Earnings before taxes (taxable income) Income taxes Net income S $ 2018 81.34 days $ 2018 15% $ 2018 13.6% 2018 1.10 X 2018 2.08 X 2018 49.3 % 2018 2.73 X 2018 14.8 % (800) (330) S (1,130) $ 1,070 (190) 880 (185) 695 Return on equity (Round to one decimal place.) (2) Complete a common-sized income statement for 2017 and 2018. (Round to one decimal place.) Common-Sized Income Statement ($ thousands) for the Years Ended 12/31/2014 and 12/31/2015 2017 2017 2018 5,800 (3,600) 2,200 (Round to two decimal places.) (Round to one decimal place.) (Round to one decimal place.) (Round to two decimal places.) (Round to two decimal places.) (Round to one decimal place.) (Round to two decimal places) $ 5,500 % (3,500) % $ 2,000 % %. se je a je % % % % % 4 % (750) (500) $ (1,250) $ 750 (275) 475 (100) 375 $ 2018 je je je % % % % % % After graduating from college in May 2018, Ryan Crews started his career in finance at the W&T Corporation, a small- to medium-sized warehouse distributor in Nashville, Tennessee. The company was founded by David Winston and Colin Tabor in 2005, after they have worked together in management at Walmart. Although Crews had an offer from Sam's Club, he became excited about the opportunity with W&T For W&T, 2017 tumed out to be a good financial year. But in 2018, the company experienced a 5.3 percent sales reduction, where sales declined from $5.8 million to $5.5 million. The downturn then led to other financial problems, including a 50 percent reduction in the company's stock price. The share price went from $38 per share at the end of 2017 to $19 per share at the end of 2018! David Winston and Colin Tabor want to understand what may have happened. Financial information for W&T for both years is shown in the popup window, for per-share data, are shown in thousands. 4 where all the numbers, except W and T Corporation Income Statement ($ thousands) for the Years Ended 12/31/2017 and 12/31/2018 2017 Sales Cost of goods sold Gross profits Operating expenses Selling, general, and administrative expenses Depreciation expenses Total operating expenses Operating profits Interest expense Earnings before taxes (taxble income) Income taxes Net income Additional information: Number of common shares outstanding Dividends paid to stockholders Market price per share $ $ $ $ $ 5,800 $ (3.600) 2,200 $ (800) (330) (1.130) 1,070 (190) 880 (185) 695 150 $94 $38 2018 5,500 (3,500) 2,000 (750) (500) $ (1,250) $ 750 (275) 475 (100) 375 150 $94 $19 18 W and T Corporation Balance Sheet($ thousands) for 12/31/2017 and 12/31/2018 ASSETS Cash Accounts receivable Inventories Other current assets Total current assets Gross fixed assets Accumulated depreciation Net fixed assets Total assets LIABILITIES (DEBT) AND EQUITY Accounts payable Short-term notes payable Total current liabilities Long-term debt Total liabilities Common equity Common stock Retained earnings Total common equity Total liabilities and equity Print MA SAM $ $ S GA $ $ Done 1,735 2,350 4,550 4,950 (1,600) (2,300) 2,950 2,650 $ 4,685 $ 5,000 $ $ 2017 300 700 600 135 500 350 850 1,250 2,100 $ $ $ S 2018 485 925 780 160 740 400 1,140 1,325 2,465 1,000 1,585 2,585 $ 2,535 4,685 $ 5,000 1,000 1,535 Days in inventories Operating return on assets Operating profit margin Total asset turnover Fixed asset turnover Debt ratio Times interest earned 2017 60.83 days Sales Cost of goods sold Gross profits 2017 22.8% 2017 18.45 % 2017 1.24 X 2017 1.97 X 2017 44.8% 2017 5.63 X 2017 26.9 % Operating expenses Selling, general, and administrative expenses Depreciation expenses Total operating expenses Operating profits Interest expense Earnings before taxes (taxable income) Income taxes Net income S $ 2018 81.34 days $ 2018 15% $ 2018 13.6% 2018 1.10 X 2018 2.08 X 2018 49.3 % 2018 2.73 X 2018 14.8 % (800) (330) S (1,130) $ 1,070 (190) 880 (185) 695 Return on equity (Round to one decimal place.) (2) Complete a common-sized income statement for 2017 and 2018. (Round to one decimal place.) Common-Sized Income Statement ($ thousands) for the Years Ended 12/31/2014 and 12/31/2015 2017 2017 2018 5,800 (3,600) 2,200 (Round to two decimal places.) (Round to one decimal place.) (Round to one decimal place.) (Round to two decimal places.) (Round to two decimal places.) (Round to one decimal place.) (Round to two decimal places) $ 5,500 % (3,500) % $ 2,000 % %. se je a je % % % % % 4 % (750) (500) $ (1,250) $ 750 (275) 475 (100) 375 $ 2018 je je je % % % % % %
Expert Answer:
Answer rating: 100% (QA)
To complete the commonsized income statement for 2017 and 2018 we must express each li... View the full answer
Related Book For
Foundations of Finance The Logic and Practice of Financial Management
ISBN: 978-0132994873
8th edition
Authors: Arthur J. Keown, John D. Martin, J. William Petty
Posted Date:
Students also viewed these finance questions
-
???????Pleaseshow a work.Thank you! A couple wants to save \( \$ 50,000 \) for their new born baby's college education 18 years from now. Assume the parents make an initial investment of \( \$ 10,000...
-
BOTH PARTS PLEASE You believe a stock is poised for a decline and wish to short it. You sell short 630 shares at a price of \( 36.87 \) while having cash equity in your account of 10000 The stock you...
-
Calculate the GPA of a student with the following grades: B (11hours), D (4 hours), F (9hours). Note that an A is equivalent to 4.0, a B is equivalent to a 3.0, a C is equivalent to a 2.0, a D is...
-
Research serves as a guide by which to study, describe, and quantify an array of social and physical phenomenon. Theory, which is best described as a set of propositions or hypotheses that specify...
-
A binomial probability experiment is conducted with the given parameters. Compute the probability of x successes in the n independent trials of the experiment. n = 10, p = 0.4, x = 3
-
Seville pic is a rapidly expanding trading and manufacturing company. It is currently seeking to extend its product range in new markets. To achieve this growth it needs to raise ¬800 000. The...
-
Seven experimental treatments, A, B, C, D, E, F and G, are to be compared in a replicated experiment. However, the experimental units form natural groups of six, so one treatment must be omitted from...
-
Define the supply chains for the following products from the first source of raw materials to the final customer: a. Big Mac b. Gasoline c. Automobile repair d. A textbook
-
Consider the following data for three divisions of a company, X, Y, and Z: Divisional: X Y Z Sales $ 1,494,000 $ 827,000 $ 4,912,000 Operating Income 180,200 49,500 247,600 Investment in assets...
-
Usonic, Inc., has collected the following information on its cost of electricity: Required a. Prepare a scattergraph of Usonic's electricity costs for the year. Plot the total electricity cost on the...
-
BYP10-5. Help me please. BYP10-5 Pinson Company and Estes Company are two proprietorships that are similar in many respects. One difference is that Pinson Company uses the straight-line method and...
-
1 . Journalize the following transactions: ( a ) Issued 1 , 0 0 0 shares of $ 1 0 par common stock at $ 5 9 for cash. ( b ) Issued 1 , 4 0 0 shares of $ 1 0 par common stock in exchange for equipment...
-
Using alpha .05, determine if moving to a larger enclosure decreased tiger anxiety levels. You should first calculate the difference (After - Before) Tiger Before Anthony 45 45 Banthony 56 After 38...
-
Cyclohexane (C 6 H 12 ) is produced by mixing Benzene and hydrogen. A process including a reactor, separator, and recycle stream is used to produce Cyclohexane. The fresh feed contains 260L/min C 6 H...
-
Suppose the city is undergoing severe ination. Specifically, both goods prices have risen by 10%. What percentage of a raise in the wage rate should Alex request from her boss, for her to maintain...
-
1. An iron cube of mass 0.55 kg is raised to a temperature of 100C by being placed in boiling water for 5 minutes. It is then removed and transferred immediately to an aluminium calorimeter filled...
-
Nike has spent $2.5 million (today) to develop and promote a limited edition Justin Herbert sneaker. This shoe is expected to generate incremental free cash flows of $10.0 million in 1 year and $8.0...
-
C- Consider the following scenario:- A supermarket needs to develop the following software to encourage regular customers. For this, the customer needs to supply his/her residence address, telephone...
-
The preferred stock of Armlo pays a $ 2.75 dividend. What is the value of the stock if your required return is 9 percent?
-
Discuss the shortcomings of the percent of sales method of financial forecasting.
-
If depreciation is not a cash- flow expense, does it affect the level of cash flows from a project in any way? Why?
-
Endofperiod adjustments LO5 A physical count of inventories at 31 December 2020 revealed that Katoomba Pty Ltd had inventories on hand at that date with a cost of $441 000. Katoomba Pty Ltd uses...
-
Assignment of cost (periodic and perpetual methods) LO4, 5, 6 Darwin Ltds inventories transactions for April 2021 are shown below. Purchases Cost of sales Balance Date No. units Unit cost Total...
-
Recording inventories transactions LO3, 4 William Ltd began business on 1 March 2021. William Ltd balances the books at monthend and uses the periodic method. William Ltds transactions for March...
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App