Question

After graduating from college in December 2014, Elizabeth Arce started her career at the W&T Corporation, a small- to medium-2015 $ 5,400 (3.600 $ 1,800 W&T Corporation Income Statement (in thousands) 2014 Sales $ 5700 Cost of goods sold 3,700 GrossW&T Corporation Balance Sheet 2014 2015 $ 495 915 780 160 $2,350 600 125 $1,725 $4,650 (1.700 $2.950 $4.675 $4,950 12.200 $2,

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Let us first analyse P&L Account through vertical analysis and horizontal analysis

Vertical Analysis Horizontal Analysis
Particulars 2014 2015 2014 2015 2015
Sales        5,700        5,400 100.00% 100.00% -5%
Cost of Goods Sold        3,700        3,600 64.91% 66.67% -3%
Gross Profit        2,000        1,800 35.09% 33.33% -10%
Operating Expenses
Selling & General Expenses            820            780 14.39% 14.44% -5%
Depreciation            340            500 5.96% 9.26% 47%
Total Operating Expense        1,160        1,280 20.35% 23.70% 10%
Operating Profit            840            520 14.74% 9.63% -38%
Interest Expenses            200            275 3.51% 5.09% 38%
Earning before taxes            640            245 11.23% 4.54% -62%
Taxes            230              65 4.04% 1.20% -72%
Net Income            410            180 7.19% 3.33% -56%

Following are the main reason for bad performance of the company in 2015 :

a. There is decline in sales by 5% in 2015

b. The COGS is increased by 1.75% which is major hit to profitability. In number terms it reduced profit by 94.74K

c. The increase in depreciation needs inquiry. The amount invested in capital is 300K and corresponding rise in depreciation compared to 2014 is higher by 160K which is more than 50% of new investment. There could be couple of reason either the amount invested is subject to high depreciation rate or in 2014 there was significant investment which was added at last period hence the depreciation was not significant in last year

d. Another item is rising interest cost. It seems that to fund increased current asset and capital investment short term and long term funding have been utilised which is resulting into interest cost

Calculation of EVA :

EVA = Net Operating Profit After Taxes (NOPAT) - Invested Capital at beginning of period * Weighted Average Cost of Capital (WACC)

Invested Capital at beginning of period = Total Assets - Current liabilities - Current year Profit / Loss

Particualrs 2014 2015
Net operating profit after tax      410.00      180.00
Invested Capital at beginning of period(Total Assets - Current Liabilities) 3,615.00 3,980.00
WACC          0.11          0.11
EVA        30.43    (237.90)
1% of Firms Eva is eligibility for bonus      304.25               -  
50% in Shares      152.13
Price per Share        18.00
Number of Shares          8.45

Recommendation :

The firm need to focus on improvement of sales as a first thing and also investigate the reason for increase in Cost of Sales. Sometime Cost of sales is out of control in such case a pricing decision needs to be considered provided it has no adverse effect on total volume of sales. Need to check the reason for incremental depreciation cost and adjust if required to reflect appropriate profitability.

Add a comment
Know the answer?
Add Answer to:
After graduating from college in December 2014, Elizabeth Arce started her career at the W&T Corporation,...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • After graduating from college in May 2018, Ryan Crews started his career in finance at the...

    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 turned out to be a good financial year. But in 2018, the company...

  • Birtle Corporation reports the following statement of financial position information for 2014 and 2015 Birtle CORPORATION...

    Birtle Corporation reports the following statement of financial position information for 2014 and 2015 Birtle CORPORATION 2014 and 2015 Statement of Financial Position Assets Liabilities and Owners' Equity 2014 2015 2014 2015 Current assets Current liabilities $ 41,060 Cash Accounts receivable Inventory $ 9,279 23,683 42,636 $11,173 25,760 46,915 Accounts payable Notes payable $43,805 16,843 16,157 57217 $ 40,000 50,000 Total $ 75,598 $ 83,848 Total $ 60,648 $ 35,000 $ 50,000 Long-term debt Owners' equity Common stock and paid-in...

  • The December 31, 2015, partial financial statements taken from the annual report for AT&T Inc. (T...

    The December 31, 2015, partial financial statements taken from the annual report for AT&T Inc. (T ) follow. Consolidated Statements of Income Dollars in millions except per share amounts 2015 2014 Operating revenues Service $ 131,677 $ 118,437 Equipment 15,124 14,010 Total operating revenues 146,801 132,447 Operating expenses Equipment 19,268 18,946 Broadcast, programming and operations 11,996 4,075 Other cost of services (exclusive of depreciation and amortization show separately below) 35,782 37,124 Selling, general and administrative 32,954 39,697 Abandonment of network...

  • Just Dew It Corporation reports the following balance sheet information for 2014 and 2015.    JUST...

    Just Dew It Corporation reports the following balance sheet information for 2014 and 2015.    JUST DEW IT CORPORATION 2014 and 2015 Balance Sheets Assets Liabilities and Owners’ Equity 2014 2015 2014 2015   Current assets   Current liabilities       Cash $ 4,000 $ 11,280       Accounts payable $ 39,040 $ 48,720       Accounts receivable 14,880 20,400       Notes payable 12,960 17,280       Inventory 61,920 90,480         Total $ 80,800 $ 122,160         Total $ 52,000 $ 66,000   Long-term debt $ 48,000 $ 36,000   Owners’ equity       Common stock and...

  • Just Dew It Corporation reports the following balance sheet information for 2014 and 2015.    JUST...

    Just Dew It Corporation reports the following balance sheet information for 2014 and 2015.    JUST DEW IT CORPORATION 2014 and 2015 Balance Sheets Assets Liabilities and Owners’ Equity 2014 2015 2014 2015   Current assets   Current liabilities       Cash $ 11,000 $ 14,250       Accounts payable $ 54,000 $ 63,750       Accounts receivable 27,000 36,750       Notes payable 14,800 20,500       Inventory 75,000 96,250         Total $ 113,000 $ 147,250         Total $ 68,800 $ 84,250   Long-term debt $ 50,000 $ 40,000   Owners’ equity       Common stock and...

  • Just Dew It Corporation reports the following balance sheet information for 2014 and 2015. Prepare the...

    Just Dew It Corporation reports the following balance sheet information for 2014 and 2015. Prepare the 2015 combined common-size, common–base year balance sheet for Just Dew It. (Do not round intermediate calculations. Round your answers to 4 decimal places, e.g., 32.1616.) Any help is appreciated :) JUST DEW IT CORPORATION 2014 and 2015 Balance Sheets Assets Liabilities and Owners' Equity 2014 2015 2014 2015 Current assets Current liabilities Cash Accounts receivable Inventory $ 6,560 16,160 61,280 $ 8,600 22,600 74,600...

  • Assets 2014 SMOLIRA GOLF CORP. 2014 and 2015 Balance Sheets Liabilities and Owners' Equity 2015 2014...

    Assets 2014 SMOLIRA GOLF CORP. 2014 and 2015 Balance Sheets Liabilities and Owners' Equity 2015 2014 Current liabilities $ 24,600 Accounts payable $ 23,684 15,700 Notes payable 14,000 27,600 Other 12,071 2015 Current assets Cash Accounts receivable Inventory $ 24,096 12,948 26,242 $ 27,600 11,300 18,100 Total $ 63,286 $ 67,900 Total $ 49,755 $ 57,000 $ 74,000 $ 82,000 Long-term debt Owners' equity Common stock and paid-in surplus Accumulated retained earnings $ 48,000 221,226 $ 48,000 242,000 Fixed assets...

  • Spreadsheet Problems 2-18 Start with the partial model in the file Ch 02 Build a Model.xlsx...

    Spreadsheet Problems 2-18 Start with the partial model in the file Ch 02 Build a Model.xlsx at the textbook's website. Build a Model: Cumberland Industries' most recent balance sheets (in thousands of dollars) are shown Financial Statements, below and in the partial model in the file: EVA, and MVA 2015 2014 Cash Short-term investments Accounts receivable Inventories Total current assets Net fixed assets Total assets Accounts payable Accruals Notes payable Total current liabilities Long-term debt Total liabilities Common steck $...

  • please help Waterloo Corporation Statement of Financial Position 31-Dec 2015 2014 2013 Assets Cash $32,000 $19,000...

    please help Waterloo Corporation Statement of Financial Position 31-Dec 2015 2014 2013 Assets Cash $32,000 $19,000 $10,000 Accounts Receivable (net) 95,000 70,000 53,000 Inventory 81,000 71,000 53,000 Other current assets 65,000 49,000 61,000 Long-term investments 120,000 76,000 50,000 Property, Plant & Equipment (net) 598,000 345,000 315.000 Total Assets $991,000 $630,000 $542,000 $71,500 245.000 316,500 $56,000 75.000 131,000 $65,000 78,000 143,000 Liabilities & Shareholders' Equity Liabilities Current Liabilities Non-current liabilities Total Liabilities Shareholders' Equity Common Shares Retained Earnings Total Shareholders' Equity...

  • Comparative financial statements for Bent Stew Enterprises are shown below: December 31 2014 2013 Assets Current...

    Comparative financial statements for Bent Stew Enterprises are shown below: December 31 2014 2013 Assets Current assets: Cash $ 3,000 $ 800 Accounts receivable 8,500 6,000 Inventory 12,000 8,200 Prepaid expenses 1,400 900 Total current assets 24,900 15,900 Property, plant, and equipment, net 103,600 123,300 Intangible assets, net 64,000 47,000 Total assets $192,500 $186,200 Liabilities and Stockholders’ Equity Current liabilities: Accounts payable $ 11,000 $ 12,000 Other current liabilities 11,800 3,200 Total current liabilities 22,800 15,200 Long-term debt 120,000 128,000...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT