Question

In: Finance

use the Incomes Statement and EOY Balance Sheet line items in the table below for questions...

use the Incomes Statement and EOY Balance Sheet line items in the table below for questions 1-6:

(in USD millions) December-16 December-17
Sales 8000 10000
Operating Income 1600 2000
Net Income 600 800
Cash 1100 1300
Marketable Securities 100 300
Accounts Payable 600 800
Accounts Receivable 800 900
Current portion of LT Debt 300 100
Inventory 500 600
Gross PPE 3000 3300
Net PPE 2500 2700
Long Term Debt 2100 2400
Interest Expense 800 900
Dividends 150 250
Shares Issued (Repurchased) (50) (50)

1. Use End of Year (EOY) balances to compare fiscal year 2017 to fiscal year 2016.According to Dupont’s ROE, which of the following statements is most likely FALSE?

a. The company’s capital structure had more debt in 2017 as compared to 2016

b. The company had more sales per dollar of total assets in 2017 as compared to 2016

c. The company had the same operating margin in 2017 as compared to 2016

d. The company had a better tax burden ratio in 2017 as compared to 2016

e. The company had a worse interest burden ratio in 2017 as compared to 2016

Solutions

Expert Solution

a. Total debt in 2016 = 2100 + 300 = 2400. Total debt in 2017 = 2400+100 = 2600. So, capital structure had more debt in 2017 when compared to 2016 (TRUE STATEMENT)

b. Total Assets in 2016 = Cash + Merketable securities + Accounts rec. + Inventory + Net PPE = 1100+100+800+500+2500 = 5000. Sales per dollar of assets in 2016 = 8000/5000 = 1.6

Total Assets in 2017 = 1300+300+900+600+2700 =5800. Sales per dollar of assets in 2017 = 10000/5800 = 1.72

So, there was more sales per dollar assets in 2017 than in 2016 (TRUE STATEMENT)

c. Operating margin in 2016 = 1600/8000 = 0.2. Operating margin in 2017 = 2000/10000 = 0.2. So company had the same operating margin in 2017 and 2016 (TRUE STATEMENT)

2016 2017
EBIT 1600 2000
Interest expense 800 900
EBT 800 1100
Taxes 200 300
Net Income 600 800
Tax burden (Net Income/EBT) 0.75 0.727273
Interest Burden (EBT/EBIT) 0.5 0.55

d. Tax burden was lower in 2017. Hence the company had a better tax burden ratio in 2017 (TRUE STATEMENT)

e. The company had a higher interest burden ratio in 2017 which indicates that it was not the worse . The lower the interest burdent ratio, the worse it is.(FALSE STATEMENT)


Related Solutions

create a proforma balance sheet and incomes statement; and use them to estimate external funds needed....
create a proforma balance sheet and incomes statement; and use them to estimate external funds needed. Can please put it in excel if possible Sales     5,000,000 Cost of Goods Sold     2,000,000 Gross Profit     3,000,000 Operating Expenses     1,000,000 Depreciation         500,000 EBIT     1,500,000 Interest Expense         100,000 EBT     1,400,000 Taxes         420,000 Net Income         980,000 Dividends         588,000 Additional Retained         392,000 Current Assets    Cash         500,000    Account Receivable         600,000   ...
Use the balance sheet and income statement below : CLANCY’S DOG BISCUIT CORPORATION Balance Sheet as...
Use the balance sheet and income statement below : CLANCY’S DOG BISCUIT CORPORATION Balance Sheet as of December 31, 2015 and 2014 (in millions of dollars) Assets 2015 2014 Liabilities and Equity 2015 2014 Current assets: Current liabilities: Cash and marketable securities $ 7 $ 7 Accrued wages and taxes $ 10 $ 9 Accounts receivable 25 20 Accounts payable 18 17 Inventory 32 25 Notes payable 16 15 Total $ 64 $ 52 Total $ 44 $ 41 Fixed...
Use the balance sheet and income statement below : CLANCY’S DOG BISCUIT CORPORATION Balance Sheet as...
Use the balance sheet and income statement below : CLANCY’S DOG BISCUIT CORPORATION Balance Sheet as of December 31, 2015 and 2014 (in millions of dollars)   Assets 2015 2014   Liabilities and Equity 2015 2014   Current assets:   Current liabilities:       Cash and marketable securities $ 8 $ 8       Accrued wages and taxes $ 13 $ 7       Accounts receivable 38 30       Accounts payable 27 25       Inventory 41 35       Notes payable 25 23           Total $ 87 $ 73           Total $ 65 $ 55   Fixed...
The table below contains data on Fincorp Inc. The balance sheet items correspond to values at...
The table below contains data on Fincorp Inc. The balance sheet items correspond to values at year-end 2015 and 2016, while the income statement items correspond to revenues or expenses during the year ending in either 2015 or 2016. All values are in thousands of dollars. 2015 2016 Revenue $ 4,000 $ 4,100 Cost of goods sold 1,600 1,700 Depreciation 500 520 Inventories 300 350 Administrative expenses 500 550 Interest expense 150 150 Federal and state taxes* 400 420 Accounts...
Use the balance sheet and income statement below to prepare a statement of cash flows for...
Use the balance sheet and income statement below to prepare a statement of cash flows for Valium’s Medical Supply Corporation. (Enter your answers in thousands. Amounts to be deducted should be indicated with a minus sign.) VALIUM’S MEDICAL SUPPLY CORPORATION Balance Sheet as of December 31, 2018 and 2017 (in thousands of dollars) Assets 2018 2017 Liabilities and Equity 2018 2017 Current assets: Current liabilities: Cash and marketable securities $ 79 $ 78 Accrued wages and taxes $ 60 $...
Place the items listed below into either the Balance Sheet or the Income Statement. Cash $10,300...
Place the items listed below into either the Balance Sheet or the Income Statement. Cash $10,300 Accounts Receivable $9,500 Supplies $2,000 Inventory $7,200 Building $78,000 Notes Receivable $20,000 Accounts Payable $7,700 Salaries Payable $5,300 Common Stock $79,000 Retained Earnings $19,700 Revenue $42,200 Cost of Goods Sold $24,500 Rent Expense $1,900 Utilities Expense $500 Module 7 Assignment #1 Introductory Accounting does not require complex math or complicated procedures. It is important to assign cost figures to their correct place in the...
The balance sheet accounts listed below are the only items on the company's balance sheet for...
The balance sheet accounts listed below are the only items on the company's balance sheet for each year and the income statement accounts are the only items on the company's income statement for each year. Item 2017 2018 Accounts payable 550 230 Accounts receivable 510 ? Accruals 1,000 1,100 Cash 300 550 Common Stock 2,000 2,250 Cost of goods sold 4,000 4,600 Depreciation expense 200 350 Interest expense 170 190 Inventory 3,000 3,250 Long term debt 1,500 1,650 Net fixed...
Use the information in the table below to construct an income statement for 2015 and balance...
Use the information in the table below to construct an income statement for 2015 and balance sheets for 2014 and 2015.  Then, find Operating Cash Flow, change in Net Working Capital, Net Capital Spending, Cash Flow to Creditors, Cash Flow to Shareholders, and Free Cash Flow.  The tax rate is 34% and the plowback ratio is 60%. 2014 2015 Sales 1700 Costs of Goods Sold 650 Depreciation Expense 200 Interest Expense 75 Total Fixed Assets 2200 3300 Accumulated Depreciation 400 Can be...
Use the information in the table below to construct an income statement for 2015 and balance...
Use the information in the table below to construct an income statement for 2015 and balance sheets for 2014 and 2015.  Then, find Operating Cash Flow, change in Net Working Capital, Net Capital Spending, Cash Flow to Creditors, Cash Flow to Shareholders, and Free Cash Flow.  The tax rate is 34% and the plowback ratio is 60%. 2014 2015 Sales 1700 Costs of Goods Sold 650 Depreciation Expense 200 Interest Expense 75 Total Fixed Assets 2200 3300 Accumulated Depreciation 400 Can be...
2. Use the information below to prepare an Income Statement and Balance Sheet for 2011 &...
2. Use the information below to prepare an Income Statement and Balance Sheet for 2011 & 2012. Also include a 40% tax rate expense on your pretax income. 2011 2012 Sales $4,203 $4,507 Cost of Goods Sold 2,422 2,633 Depreciation 785 952 Interest 180 196 Dividends 225 250 Current Assets 2,205 2,429 Net fixed Assets 7,344 7,650 Current Liabilities 1,003 1,255 Long-Term debt 3,106 2,085
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT