Please complete with how to perform calculations in Excel. Not time sensitive. This is all the information given for this question.
After graduating from college in December 2014, Elizabeth Arce started her career 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 2000, after they had worked together in management at Wal-Mart. Although Arce had an offer from Sam's Club, she became excited about the opportunity with W&T. Winston and Tabor, as CEO and VP-marketing, respectively, assured her that she would be given every opportunity to take a leadership role in the business as quickly as she was prepared for the role. In addition to receiving a competitive salary, Arce will immediately be entitled to a bonus based on how well the company does financially. The bonus is determined by the amount of Economic Value Added (EVA) that is generated in a year. To begin, she will receive 1 percent of the firm's EVA each year, to be paid half in stock and half in cash. In any year that the EVA is negative, she will not receive a bonus. Also, the firm's stock is traded publicly on the NYSE MKT, a stock exchange for small-cap companies. The year of 2014 turned out to be a good year financially for the business. But in the ensuing year, 2015, the company experienced a 5.3 percent sales reduction, where sales declined from $5.7 million to $5.4 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 $36 per share at the end of 2014 to $18 per share at the conclusion of 2015! Financial information for W&T for both years is shown on the next page, where all the numbers, except for per share data, are shown in $ thousands. a. Using what you have learned in this chapter and Chapter 3, prepare a financial analysis of W&T, comparing the firm's financial performance between the 2? years. In addition to the financial information provided on the next page the company's chief financial officer, Mike Stegemoller, has estimated the company's average cost of capital for all its financing to be 10.5 percent. b. What conclusions can you make from your analysis? c. How much will Arce's bonus be in 2014 and 2015, in the form of both cash and stock? How many shares of the stock will Arce receive? d. What recommendations would you make to W&T Corporation Income Statement (in thousands) 2014 5700 2,000 (8200 0,1600 840 S 640 2015 Sales Cost of goods sold Gross profits Operating a pene Salling and GLA axpenses 5,400 1,800 (780) (1,280 otal sperating apenses Operating profts Interest pense Earmings before taxes (taxable incone) Income as 520 245 Additional information 120 120 Dividends paid to stockholdors Market price per share W&T Corporation Balance Sheet 2014 2015 495 700 780 Other cument assets otal cument assets Gross fand ats Accumulatad dopreciation Net faed asset lotal assets 4,650 400 Short-borm notos payable otal cument lablities Long -term dobt 650 Common equity 1,100 poy otal conmon eqait otal labilities and oquity 2,835
