Question

In: Finance

Sand Technologies: Income Statements for Year Ending December 31            (in thousands)          ...

Sand Technologies: Income Statements for Year Ending December 31           
(in thousands)           2019   2018  
Sales               $945,000   $880,000  
Expenses excluding depreciation and amortization   822,150   730,400  
EBITDA               $122,850   $149,600  
Depreciation and amortization       32,400   31,500  
EBIT               $90,450   $118,100  
Interest Expense           10,470   8,600  
EBT               $79,980   $109,500  
Taxes (40%)               31,992   43,800  
Net income           $47,988   $65,700  
                      
Common dividends           $38,050   $55,390  
Addition to retained earnings       $9,938   $10,310  
                      
Sand Technologies: December 31 Balance Sheets          
(in thousands)                  
Assets               2019   2018  
Cash and cash equivalents       $53,400   $44,685  
Short-term investments           8,500   12,450  
Accounts Receivable           283,500   275,880  
Inventories               141,750   135,000  
Total current assets           $487,150   $468,015  
Net fixed assets           425,600   401,400  
Total assets               $912,750   $869,415  
                      
Liabilities and equity                  
Accounts payable           $94,500   $90,000  
Accruals               46,850   42,750  
Notes payable           32,362   54,565  
Total current liabilities           $173,712   $187,315  
Long-term debt           194,500   147,500  
Total liabilities           $368,212   $334,815  
Common Stock           444,600   444,600  
Retained Earnings           99,938   90,000  
Total common equity           $544,538   $534,600  
Total liabilities and equity           $912,750   $869,415  
                      
Key Input Data                  
Tax rate               40%      
                      
NAME:      SECTION:   FALL 2020  
                      
Net operating working capital -- NOWC              
2019   NOWC =    Operating current assets   -   Operating current liabilities      
2019   NOWC =       -         
2019   NOWC =                  
                      
2018   NOWC =    Operating current assets   -   Operating current liabilities      
2018   NOWC =       -         
2018   NOWC =                  
                      
Total net operating capital -- OC              
2019   OC =    NOWC   +   Net Fixed assets      
2019   OC =       +         
2019   OC =                  
                      
2018   OC =    NOWC   +   Net Fixed assets      
2018   OC =       +         
2018   OC =                  
                      
                      
Net operating profit after taxes              
2019   NOPAT =    EBIT   x   ( 1 - Tax rate )      
2019   NOPAT =       x         
2019   NOPAT =                  
                      
Operating Cash Flow (OCF)               
2019   OCF=   NOPAT   +   Depreciation      
2019   OCF=      +         
2019   OCF=                 
                      
Free cash flow                  
2019   FCF =    NOPAT   -   Net investment in operating capital  
2019   FCF =       -         
2019   FCF =                  
                      
Return on invested capital                  
2019   ROIC =    NOPAT   /   Total net operating capital -- 2019 OC  
2019   ROIC =       /         
2019   ROIC =                  
                      
Assume that there were 15 million shares outstanding at the end of the year, the year-end closing stock price was $48.50 per share, and the after-tax cost of capital was 6%. Calculate EVA and MVA for the most recent year.

                      
Additional Input Data                  
Stock price per share   $48.50              
# of shares (in thousands)   15,000              
After-tax cost of capital   6.0%              
                      
Market Value Added                  
MVA =    Stock Price   x   # of shares   -   2019 Total common equity
      x             
              -     
MVA =                      
                      
Economic Value Added                  
EVA =    NOPAT   -   (Operating Capital -- 2019 OC   x   After-tax cost of capital -- WACC)
       -      x     
      -             
EVA =                      

Solutions

Expert Solution


Related Solutions

Lan & Chen Technologies: Income Statements for Year Ending December 31 (Thousands of Dollars) 2010 2009...
Lan & Chen Technologies: Income Statements for Year Ending December 31 (Thousands of Dollars) 2010 2009 Sales $945,000 $900,000 Expenses excluding depreciation and amortization 812,700 774,000 EBITDA $132,300 $126,000 Depreciation and amortization 33,100 31,500 EBIT $99,200 $94,500 Interest Expense 10,470 8,600 EBT $88,730 $85,900 Taxes (40%) 35,492 34,360 Net income $53,238 $51,540 Common dividends $43,300 $41,230 Addition to retained earnings $9,938 $10,310 Lan & Chen Technologies: December 31 Balance Sheets (Thousands of Dollars) Assets 2010 2009 Cash and cash equivalents...
Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars)
Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars)   2018   2017 Sales $7,800.0   $6,000.0 Operating costs excluding depreciation 5,850.0   5,100.0 Depreciation and amortization 216.0   180.0     Earnings before interest and taxes $1,734.0   $720.0 Less Interest 168.0   129.0     Pre-tax income $1,566.0   $591.0 Taxes (40%) 626.4   236.4 Net income available to common stockholders $939.6   $354.6 Common dividends $846.0   $284.0 Rhodes Corporation: Balance Sheets as of December 31 (Millions of Dollars)   2018   2017 Assets Cash $90.0   $72.0 Short-term investments 39.0   30.0...
Rhodes Corporation’s financial statements are shown below. Rhodes Corporation: Income Statements for Year Ending December 31...
Rhodes Corporation’s financial statements are shown below. Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2020 2019 Sales $ 12,000 $ 11,000 Operating costs excluding depreciation 10,570 9,716 Depreciation and amortization 390 360     Earnings before interest and taxes $ 1,040 $ 924 Less interest 240 200     Pre-tax income $ 800 $ 724 Taxes (25%) 200 181 Net income available to common stockholders $ 600 $ 543 Common dividends $ 201 $ 200 Rhodes Corporation: Balance Sheets...
Xerbert Co Budgeted and Actual Income Statements For the year Ending December 31 (000s omitted) Budgeted...
Xerbert Co Budgeted and Actual Income Statements For the year Ending December 31 (000s omitted) Budgeted Actual Xenox Xeon Total Xenox Xeon Total Units sales 150 100 250 130 130 260 Net Peso sales P900 P1,000 P1,900 P780 P1,235 P2,015 Variable expenses 450 750 1,200 390 975 1,365 P450 P   250 P   700 P390 P    260 P 650 Fixed expenses P   200 P   190    Manufacturing 153 140    Marketing 95 90        Total fixed experience P   448 P 420...
VALIUM’S MEDICAL SUPPLY CORPORATION Income Statement for Years Ending December 31, 2015 and 2014 (in thousands...
VALIUM’S MEDICAL SUPPLY CORPORATION Income Statement for Years Ending December 31, 2015 and 2014 (in thousands of dollars) 2015 2014 Net sales $ 926 $ 836 Less: Cost of goods sold 406 369 Gross profits $ 520 $ 467 Less: Other operating expenses 64 58 Earnings before interest, taxes, depreciation, and amortization (EBITDA) $ 456 $ 409 Less: Depreciation 50 48 Earnings before interest and taxes (EBIT) $ 406 $ 361 Less: Interest 65 59 Earnings before taxes (EBT) $...
Rhodes Corporation’s financial statements are shown below. Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars)
Rhodes Corporation’s financial statements are shown below.Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2020 2019Sales$11,000 $10,000Operating costs excluding depreciation 9,608  8,700Depreciation and amortization 400  360Earnings before interest and taxes$992 $940Less interest 260  200Pre-tax income$732 $740Taxes (25%) 183  185Net income available to common stockholders$549 $555Common dividends$203 $200Rhodes Corporation: Balance Sheets as of December 31 (Millions of Dollars) 2020 2019AssetsCash$650 $600Short-term investments 210  200Accounts receivable 2,750  2,500Inventories 1,650  1,400Total current assets$5,260 $4,700Net plant and equipment 3,750  3,500Total...
Powell Panther Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2018 2017 Sales...
Powell Panther Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2018 2017 Sales $ 3,250.0 $ 2,600.0 Operating costs excluding depreciation and amortization 2,763.0 2,210.0 EBITDA $ 487.0 $ 390.0 Depreciation and amortization 90.0 78.0 Earnings before interest and taxes (EBIT) $ 397.0 $ 312.0   Interest 72.0 57.0 Earnings before taxes (EBT) $ 325.0 $ 255.0   Taxes (40%) 130.0 102.0 Net income $ 195.0 $ 153.0 Common dividends $ 176.0 $ 122.0 Powell Panther Corporation: Balance Sheets...
Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2015 2014 Sales $10,200.0...
Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2015 2014 Sales $10,200.0 $8,500.0 Operating costs excluding depreciation 7,905.0 7,225.0 Depreciation and amortization 253.0 230.0 Earnings before interest and taxes $2,042.0 $1,045.0   Less: Interest 219.0 183.0 Pre-tax income $1,823.0 $862.0   Taxes (40%) 729.2 344.8 Net income available to common stockholders $1,093.8 $517.2 Common dividends $984.0 $414.0 Rhodes Corporation: Balance Sheets as of December 31 (Millions of Dollars) 2015 2014 Assets Cash $154.0 $128.0 Short-term investments 52.0 43.0...
Powell Panther Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2019 2018 Sales...
Powell Panther Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2019 2018 Sales $ 1,820.0 $ 1,400.0 Operating costs excluding depreciation and amortization 1,547.0 1,190.0 EBITDA $ 273.0 $ 210.0 Depreciation and amortization 46.0 36.0 Earnings before interest and taxes (EBIT) $ 227.0 $ 174.0   Interest 40.0 30.8 Earnings before taxes (EBT) $ 187.0 $ 143.2   Taxes (25%) 74.8 57.3 Net income $ 112.2 $ 85.9 Common dividends $ 101.0 $ 68.7 Powell Panther Corporation: Balance Sheets...
Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2015 2014 Sales $10,400.0...
Rhodes Corporation: Income Statements for Year Ending December 31 (Millions of Dollars) 2015 2014 Sales $10,400.0 $8,000.0 Operating costs excluding depreciation 7,800.0 6,800.0 Depreciation and amortization 230.0 200.0 Earnings before interest and taxes $2,370.0 $1,000.0 Less: Interest 224.0 172.0 Pre-tax income $2,146.0 $828.0 Taxes (40%) 858.4 331.2 Net income available to common stockholders $1,287.6 $496.8 Common dividends $1,159.0 $397.0 Rhodes Corporation: Balance Sheets as of December 31 (Millions of Dollars) 2015 2014 Assets Cash $132.0 $120.0 Short-term investments 52.0 40.0...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT