Homework Answers
Let us first note the formulas :
| Times Interest Earned | Earning before Interest and taxes / Interest Expenes | ||||||||
| Fixed Charge Coverage | (Earning before Interest and taxes +Fixed charge before tax)/(Fixed charge before tax+Interest) | ||||||||
| Debt Ratio | Total Debt / Total Assets | ||||||||
| Debt to Equity Ratio | Total Debt/ Total Equity | ||||||||
| Debt to Tangible Networth | Total Liabilities / Tangible Networth (Total Assets-Total liabilities-Intangible Assets) | ||||||||
Let us calculate each different term used above and also identify excel cell reference number so that we can also identify excel formula as well :
| Particulars | 2015 | 2014 | ||
| Earning before interest and taxes | 6,204.00 | B70 | 4,249.00 | C70 |
| Interest Expenses | 1,588.00 | B75 | 1,037.00 | C75 |
| Fixed charge before tax | 34,786.00 | B69 | 38,401.00 | C69 |
| Total Debt | 18,330.00 | B34 | 16,043.00 | C34 |
| Total Assets | 48,415.00 | B23 | 43,225.00 | C23 |
| Total Equity | 5,635.00 | B46 | 2,021.00 | C46 |
| Total Liabilities | 42,780.00 | B32+B39 | 41,204.00 | C32+C39 |
| Intangible Assets | 6,340.00 | B18+B19 | 6,331.00 | C18+C19 |
| Ratio | 2015 | 2014 | ||
| Ratio | Excel Formula | Ratio | Excel Formula | |
| Times Interest Earned | 3.90680 | (B70/B75) | 4.09740 | (C70/C75) |
| Fixed Charge Coverage | 1.12690 | (B70+B69)/(B69+B75) | 1.08144 | (C70+C69)/(C69+C75) |
| Debt Ratio | 0.37860 | (B34/B23) | 0.37115 | (C34/C23) |
| Debt to Equity Ratio | 3.25288 | (B34/B46) | 7.93815 | (C34/C46) |
| Debt to Tangible Networth | (60.68085) | (B32+B39)/(B23-(B32+B39)-(B18+B19)) | (9.56009) | (C32+C39)/(C23-(C32+C39)-(C18+C19)) |
Add Answer to:
Dec 31, 2015 Dec 31, 2014 $ 390 5,864 695 1,425 863 748 9,985 $ 994...
083 Xx Dec 31, 2015 Dec 31, 2014 $ 390 5,864 695 1,425 863 748 9,985...
083 Xx Dec 31, 2015 Dec 31, 2014 $ 390 5,864 695 1,425 863 748 9,985 $ 994 6,309 774 1,771 1,004 898 11,750 28,213 Consolidated Balance Sheets - USD ($) $ in Millions 2 Current assets 3 Cash 4 Short-term investments 5 Restricted cash and short-term investments 6 Accounts receivable, net 7 Aircraft fuel, spare parts and supplies, net 8 Prepaid expenses and other 9 Total current assets 10 Operating property and equipment 11 Flight equipment 12 Ground property...
x x B . IF Dec 31, 2015 Dec 31, 2014 $ 1,972 1,465 2,020 $...
x x B . IF Dec 31, 2015 Dec 31, 2014 $ 1,972 1,465 2,020 $ 2,088 1,217 2,297 119 379 318 925 534 318 1,987 1,078 796 701 Consolidated Balance Sheets - USD ($) $ in Millions 2 Current Assets: 3 Cash and cash equivalents 4 Short-term investments Accounts receivable, net of an allowance for uncollectible accounts of $9 and $11 at December 31, 5 2015 and 2014, respectively 6 Hedge margin receivable 7 Fuel inventory Expendable parts and...
Dec 31, 2015 Dec. 31, 2014 $ 1,972 1,465 2,020 $ 2,088 1,217 2,297 119 925...
Dec 31, 2015 Dec. 31, 2014 $ 1,972 1,465 2,020 $ 2,088 1,217 2,297 119 925 379 534 318 318 1,987 1,078 796 701 Consolidated Balance Sheets - USD ($) $ in Millions 2 Current Assets: 3 Cash and cash equivalents 4 Short-term investments Accounts receivable, net of an allowance for uncollectible accounts of $9 and $11 at 5 December 31, 2015 and 2014, respectively 6 Hedge margin receivable 7 Fuel inventory Expendable parts and supplies inventories, net of an...
3M Company Common-size Income Statements Dec. 31, 2014 Dec. 31, 2013 Net sales 31,821 30,871 Operating...
3M Company Common-size Income Statements Dec. 31, 2014 Dec. 31, 2013 Net sales 31,821 30,871 Operating expenses Cost of sales Selling, general & admin. expenses Research &development expenses 16,447 6,469 1,770 7,135 16,106 6,384 1,715 6,666 Operating income Interest expense and income: 142 (33) 109 7,026 2,028 $4,998 145 (41) 104 6,562 1,841 $4,721 Interest expense Interest income Net interest Income before taxes &minority interest Provision for income taxes Net income IM Company and Subsidiaries Common-size Balance Sheets Dec. 31,...
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...
please do Waterloo Corporation Statement of Financial Position 31-Dec 2015 2014 2013 Assets Cash $32,000 $19,000...
please do
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...
Please fill in the grey spaces for the 2020 Balance Sheet. Dec. 31, 2019 Dec. 31,...
Please fill in the grey spaces
for the 2020 Balance Sheet.
Dec. 31, 2019 Dec. 31, 2018 Balance in TL enda Current assets. Cash and cash equivalents Accounts receivable, net Inventory Prepaid expenses and other current assets Income tax receivable Investments Total current assets Leasehold improvements, property and equipment, Restricted cash Operating lease assets Other assets Goodwill Total assets $ 480,626 80,545 26,096 57,076 27,705 400,156 1,072,204 1,458,690 27,855 2,505,466 18,450 21.939 5,104,604 $249,953 62,312 21,555 54,129 0 426,845 814,794...
Need formula for ratios. Dec. 31, 2017 Dec 31, 2016 $ 687,521 $ 759,984 5,519 329,986...
Need formula for ratios.
Dec. 31, 2017 Dec 31, 2016 $ 687,521 $ 759,984 5,519 329,986 2,105,662 538,202 47,518 175,853 3,884,742 4,859,424 967,781 19,816 55,947 109,073 75,889 9,972,672 285,106 2,076,261 499,917 52,574 174,491 3,853,852 4,759,197 981,593 53,391 167,729 74,478 9,890,240 Consolidated Balance Sheets - USD ($) $ in Thousands 2 Current assets: 3 Cash and cash equivalents 4 Marketable securities 5 Accounts receivable, net 6 Finance receivables, net 7 Inventories 8 Restricted cash 9 other current assets 10 Total current...
CONSOLIDATED BALANCE SHEETS FOR TEST CORPORATION Oct 31, 2015 Oct 31, 2014 ASSETS Current Assets Cash...
CONSOLIDATED BALANCE SHEETS FOR TEST CORPORATION Oct 31, 2015 Oct 31, 2014 ASSETS Current Assets Cash and Cash Equivalents Accounts Receivables Inventory Total Current Assets 700 150 200 100 700 1000 250 1100 600 600 Property, Plant, and Equipment Property, Plant and Equipment*** Less Cumulative Depreciation Total Property, Plant, and Equipment 200 250 350 400 Total Assets 1,450 1,400 LIABILITIES Current Liabilities Accounts Payable Other Current Liabilities Total Current Liabilities 100 200 100 200 300 500 Long-term Liabilities Loan Total...
Using data available in the case, calculate the annual growth rate from 2014 to 2015, and from 2015 to 2016 (in percenta...
Using data available in the case, calculate the annual growth
rate from 2014 to 2015, and from 2015 to 2016 (in percentages). All
calculations should be rounded to one decimal (e.g., 12.7%)
I need help filling in these percentages.
2014-2015 2015-2016 Revenue Cost of Goods Sold Gross Profit % Operating Income Total Operating Expenses Net Income % Working Capital Year Ended: Dec. 27, 2014 Dec. 31, 2016 Dec. 26, 2015 Income Statement Data: $968.99 $1,024.04 $966.48 Revenue 64.11 63.47 Less...
083 Xx Dec 31, 2015 Dec 31, 2014 $ 390 5,864 695 1,425 863 748 9,985 $ 994 6,309 774 1,771 1,004 898 11,750 28,213 Consolidated Balance Sheets - USD ($) $ in Millions 2 Current assets 3 Cash 4 Short-term investments 5 Restricted cash and short-term investments 6 Accounts receivable, net 7 Aircraft fuel, spare parts and supplies, net 8 Prepaid expenses and other 9 Total current assets 10 Operating property and equipment 11 Flight equipment 12 Ground property...
x x B . IF Dec 31, 2015 Dec 31, 2014 $ 1,972 1,465 2,020 $ 2,088 1,217 2,297 119 379 318 925 534 318 1,987 1,078 796 701 Consolidated Balance Sheets - USD ($) $ in Millions 2 Current Assets: 3 Cash and cash equivalents 4 Short-term investments Accounts receivable, net of an allowance for uncollectible accounts of $9 and $11 at December 31, 5 2015 and 2014, respectively 6 Hedge margin receivable 7 Fuel inventory Expendable parts and...
Dec 31, 2015 Dec. 31, 2014 $ 1,972 1,465 2,020 $ 2,088 1,217 2,297 119 925 379 534 318 318 1,987 1,078 796 701 Consolidated Balance Sheets - USD ($) $ in Millions 2 Current Assets: 3 Cash and cash equivalents 4 Short-term investments Accounts receivable, net of an allowance for uncollectible accounts of $9 and $11 at 5 December 31, 2015 and 2014, respectively 6 Hedge margin receivable 7 Fuel inventory Expendable parts and supplies inventories, net of an...
3M Company Common-size Income Statements Dec. 31, 2014 Dec. 31, 2013 Net sales 31,821 30,871 Operating expenses Cost of sales Selling, general & admin. expenses Research &development expenses 16,447 6,469 1,770 7,135 16,106 6,384 1,715 6,666 Operating income Interest expense and income: 142 (33) 109 7,026 2,028 $4,998 145 (41) 104 6,562 1,841 $4,721 Interest expense Interest income Net interest Income before taxes &minority interest Provision for income taxes Net income IM Company and Subsidiaries Common-size Balance Sheets Dec. 31,...
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...
please do
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...
Please fill in the grey spaces
for the 2020 Balance Sheet.
Dec. 31, 2019 Dec. 31, 2018 Balance in TL enda Current assets. Cash and cash equivalents Accounts receivable, net Inventory Prepaid expenses and other current assets Income tax receivable Investments Total current assets Leasehold improvements, property and equipment, Restricted cash Operating lease assets Other assets Goodwill Total assets $ 480,626 80,545 26,096 57,076 27,705 400,156 1,072,204 1,458,690 27,855 2,505,466 18,450 21.939 5,104,604 $249,953 62,312 21,555 54,129 0 426,845 814,794...
Need formula for ratios.
Dec. 31, 2017 Dec 31, 2016 $ 687,521 $ 759,984 5,519 329,986 2,105,662 538,202 47,518 175,853 3,884,742 4,859,424 967,781 19,816 55,947 109,073 75,889 9,972,672 285,106 2,076,261 499,917 52,574 174,491 3,853,852 4,759,197 981,593 53,391 167,729 74,478 9,890,240 Consolidated Balance Sheets - USD ($) $ in Thousands 2 Current assets: 3 Cash and cash equivalents 4 Marketable securities 5 Accounts receivable, net 6 Finance receivables, net 7 Inventories 8 Restricted cash 9 other current assets 10 Total current...
CONSOLIDATED BALANCE SHEETS FOR TEST CORPORATION Oct 31, 2015 Oct 31, 2014 ASSETS Current Assets Cash and Cash Equivalents Accounts Receivables Inventory Total Current Assets 700 150 200 100 700 1000 250 1100 600 600 Property, Plant, and Equipment Property, Plant and Equipment*** Less Cumulative Depreciation Total Property, Plant, and Equipment 200 250 350 400 Total Assets 1,450 1,400 LIABILITIES Current Liabilities Accounts Payable Other Current Liabilities Total Current Liabilities 100 200 100 200 300 500 Long-term Liabilities Loan Total...
Using data available in the case, calculate the annual growth
rate from 2014 to 2015, and from 2015 to 2016 (in percentages). All
calculations should be rounded to one decimal (e.g., 12.7%)
I need help filling in these percentages.
2014-2015 2015-2016 Revenue Cost of Goods Sold Gross Profit % Operating Income Total Operating Expenses Net Income % Working Capital Year Ended: Dec. 27, 2014 Dec. 31, 2016 Dec. 26, 2015 Income Statement Data: $968.99 $1,024.04 $966.48 Revenue 64.11 63.47 Less...
Most questions answered within 3 hours.
-
The following temperatures show the (fictional) daily low
measured at O'Hare airport every January 1st from...
asked 13 minutes ago -
Your friend is interested in the characteristics of fast tree
planters. He searched through the records...
asked 21 minutes ago -
. 0.67 g of Ag is deposited electrolytically from
AgNO3 after a certain period of time...
asked 22 minutes ago -
assuming that the boric acid, h3po3 present at the end of the
borax tritation has a...
asked 21 minutes ago -
When a carbonate solution is acidified, carbon dioxide is
produced.
2H+(aq) + CO32-(aq) → H2O(l) +...
asked 1 hour ago -
A reaction has the following rate law: Rate =
kr[A][B]2. In experiment 1, the
concentrations of...
asked 58 minutes ago -
king owns a large number of public pay phones. as rhe use of
payphones decline deamatically,...
asked 1 hour ago -
3.7 - A book is sitting on a table. The mass of the book
is 1...
asked 1 hour ago -
Which term describes the process by which a single strand of DNA
serves as a template...
asked 1 hour ago -
LAB FOOD DRING
ANSWER THE QUESTIONS:
Q1. What value is the moisture content versus time and...
asked 1 hour ago -
You are told that an object has zero acceleration. Two forces on
the object are: F_1...
asked 1 hour ago -
The usual starting point for preparing a master budget is
forecasting or estimating:
Multiple Choice
Sales....
asked 1 hour ago