|
Sheet (Millions) |
Income Statement (Millions) |
|||||
|
Assets |
||||||
|
Cash |
1,290 |
Net Sales |
51,600 |
|||
|
Receivables |
9,890 |
Operating Costs |
48,246 |
|||
|
Inventory |
13,760 |
Depreciation |
903 |
|||
|
PP&E |
18,060 |
EBIT |
2,451 |
|||
|
Total Assets |
43,000 |
Interest |
927 |
|||
|
EBT |
1,524 |
|||||
|
Liabilities and OE |
Taxes |
534 |
||||
|
Accounts Payable |
8,170 |
Net Income |
990 |
|||
|
Notes Payable |
6,677 |
|||||
|
Wages Payable |
4,073 |
Other Data |
||||
|
Long Term Bonds |
8,815 |
Shares Outstanding (millions) |
750 |
|||
|
Total Equity |
15,265 |
Common Dividends (millions) |
$346.67 |
|||
|
Total Liabilities and OE |
43,000 |
Current Interest Rate |
6.25% |
|||
|
Tax rate |
35%
|
|||||
| Calculate P/E Ratio. Show all work |
Solution:
P/E Ratio = Market price per share ÷ Earnings per share
Given, Market price per share = $35
Earnings per share = Earnings available to common shareholders ÷ shares outstanding
Earnings per share = $990millions ÷ 750millions
Earnings per share = 1.32
P/E Ratio = $35 ÷ 1.32 = 26.52
P/E Ratio = 26.52
Sheet (Millions) Income Statement (Millions) Assets Cash 1,290 Net Sales 51,600 Receivables 9,890 Operating Costs 48,246...
Balance Sheet (Millions) Income Statement (Millions) Assets Cash 1,290 Net Sales 51,600 Receivables 9,890 Operating Costs 48,246 Inventory 13,760 Depreciation 903 PP&E 18,060 EBIT 2,451 Total Assets 43,000 Interest 927 EBT 1,524 Liabilities and OE Taxes 534 Accounts Payable 8,170 Net Income 990 Notes Payable 6,677 Wages Payable 4,073 Other Data Long Term Bonds 8,815 Shares Outstanding (millions) 750 Total Equity 15,265 Dividends (millions) $346.67 Calculate the TIE ratio. Show work for credit.
EXHIBIT 1 The balance sheet and income statement shown below are for Muller Industries. Note that the firm has no amortization charges, it does not lease any assets, none of its debt must be retired during the next 5 years, and the notes payable will be rolled over. Balance Sheet (Millions of $) Assets Cash and Securities Accounts Receivable Inventories Total Current Assets Net Plant and Equipment Total Assets 2018 $2,290 10,890 12,760 $25,940 $20,060 $46,000 $7,170 8,020 Liabilities and...
Balance Sheet (Millions of $) Assets 2016 Cash and securities $ 1,554.0 Accounts receivable 9,660.0 Inventories 13,440.0 Total current assets $24,654.0 Net plant and equipment 17,346.0 $42,000.0 Total assets Liabilities and Equity Accounts payable Notes payable $7,980.0 5,880.0 Accruals 4,620.0 Total current liabilities $18,480.0 Long-term bonds 10,920.0 $29,400.0 Total liabilities Common stock 3,360.0 Retained earnings 9,240.0 $12,600.0 Total common equity Total liabilities and equity $42,000.0 Income Statement (Millions of $) 2016 Net sales $58,800.0 Operating costs except depreciation $54,978.0 $1,029.0...
Complete a vertical and horizontal analysis on the tabs labeled
"Balance Sheet" and "Income Statement," use total assets on the
balance sheet and net sales on the income statement for your
vertical analysis.
Consolidated Balance Sheets (USD $) In Millions, unless o Feb. 01,2015 Vertical AnalysisFeb. 01,2014Vertical AnalysisHorizontal Analysis therwises fied Current Assets: Cash and Cash Equivalents Receivables, net Merchandise Inventories Other Current Assets Total Current Assets $1.723 1484 11079 1016 15302 38.513 $1929 1.398 11,057 895 15,279 39,064 at...
Income Statement Year Ended December 31 (In millions) 2005 2004 2003 Net sales Products $ 31,518 $ 30,202 $ 27,290 Service 5,695 5,324 4,534 37,213 35,526 31,824 Cost of sales Products 27,932 27,637 25,306 Service 5,073 4,765 4,099 Unallocated coporate costs 803 914 443 33,808 33,316 29,848 3,405 2,210 1,976 Other income (expenses), net (449) (121) 43 Operating profit 2,956 2,089 2,019 Interest expense 370 425 487 Earnings before taxes 2,586 1,664 1,532 Income tax expense 761 368 479 Net...
Complete the excel.
INCOME STATEMENT 1 Sales 2 COGS 3 Depreciation expense 4 Total operating costs 5 EBIT 6 Less interest 7 Earnings before taxes (EBT) 8 Taxes (40%) 11 Net Income 12 Shares of common equity 13 Dividends per share 14 Dividends to common 15 Additions to retained earnings Actual 2016 $ 7,500.00 $ 5,625.00 375.00 6,000.00 1,500.00 63.00 1,437.00 574.80 862.20 62.50 $ 2.50 $ 156.25 $ 705.95 Actual 2016 30.00 543.75 787.50 1,361.25 1,350.00 2,711.25 BALANCE SHEET...