Calculation of adjusted net income

Reference no: EM1315977

Calculation of adjusted net income using ratio analysis.

All questions relate to the Kimberly-Clark Corp. Annual Report (Form 10-K) for the year ending December 31, 2007. Kimberly-Clark (the "Company") "is a global health and hygiene company with manufacturing facilities in 36 countries and its products are sold in more than 150 countries." The Company's "products are sold under such well-known brands as Kleenex, Scott, Huggies, Pull-Ups, Kotex and Depend."

The Company operates in the Paper Mills industry. Median data relating to the Paper Mills industry are:

ROE	10.35%
Beta	0.97
Market-to-book	1.97
Net profit margin (Return on sales)	5.86%
Total asset turnover	1.12
Financial leverage	1.56
Gross profit margin	22.93%
Receivable days (Average collection period/Days to collect)	48.06
Inventory days (Days inventory held)	62.42
Payable days (Days to pay)	32.29
Current ratio	1.59
Interest coverage (Times interest earned)	1.81

Note: Although an individual company's ROE is the product of net profit margin, total asset turnover, and financial leverage, this relationship will not hold when using the three median variables as shown above because medians distort the relationships among individual company ratios.

Please read the instructions and each question carefully.

Some aspects of Kimberly-Clark's (hereafter, the "Company") 2007 financial statements are noteworthy.

1. Two "above-the-line" special, non-recurring items were reported. The first item was a $107.2 million net charge ($61.4 million after tax (given in annual report)) for a strategic cost reduction plan allocated as follows on a pre-tax basis: $89.4 million charge included in Cost of products sold; $31.8 million charge included in Marketing, research and general expenses; and $14 million gain on dispositions of facilities included in Other (income) and expense, net (See MD&A, pp. 24-25, Note 2, pp. 49-52). The second item was an $16.4 million gain for a settlement of litigation that was included in Other (income) and expense, net (See MD&A, p.25). The after-tax amount for the first item is given; however, consider the second item a taxable gain.

2. Treat Redeemable preferred securities of subsidiary, included in the balance sheet, as interest bearing debt in problem 8(d). Do not treat this item the same way as the preferred stock adjustment that was discussed in Module 5, p.23. Assume that the preferred dividends are already included in the interest expense reported in the 2007 income statement.

Show the adjustments for each problem individually and not a cumulative adjustment unless the question directs you to do so.

(a) Note 15 (pp. 71-75) describes the Company's income taxes. Unwind the effects of income tax accounting such that Provision for income taxes (income tax expense) reported in the Consolidated Income Statement in 2007 reflects income taxes currently payable. As a result of unwinding the Company's income taxes, what would be the amount of the adjustments made to net income, assets, liabilities, and stockholders' equity for 2007? NOTE: Non-current deferred tax assets of $272.8 million are included in "Other assets," and current deferred tax liabilities of $20.6 million are included in at least three current liabilities accounts.

Adjustment to net income ____________________

Adjustment to assets ____________________

Adjustment to liabilities ____________________

Adjustment to equities ____________________

(b) Using the deferred tax liability of $934.9 million for Accumulated depreciation (depreciation related to property, plant, and equipment) (p. 72), calculate the 2007 tax basis of property, plant, and equipment.
Formula _____________________________________________________________

2007 Tax basis property, plant & equipment ____________________

(c) Estimate the amount of 2007 income taxes the Company saved (or paid) as a result of using the LIFO inventory valuation method (see Note 18, Summary of inventories, p. 79). Be sure to label your answer as either a savings or a payment.

2007 LIFO tax effect ____________________

Savings or Payment ____________________

Dollar amount of adjustment _____________

Reference no: EM1315977

Questions Cloud

Change to the objective function or a raise in the value : Either no change to the Objective function or a raise in the value of the objective function depends on the constraint.

Null and alternate hypotheses : By using the fact that Martha believes the treatment will decrease the amount of time to fall asleep, describe the null and alternate hypotheses.

Regression model returns to scale and parameters : Your analyst tells you that he has estimated the following linear regression model of your company's long run technology:

Problems on time and distance : Problems on time and distance.

Calculation of adjusted net income : Calculation of adjusted net income using ratio analysis and evaluate the amount of 2007 income taxes the Company saved (or paid) as a result of using the LIFO inventory valuation method

Computation of dividend based on dividend growth model : Computation of dividend based on dividend growth model and what is the expected dividend per share for each of the next 5 years

Find out the optimum solution using the given data : Find out the Optimum solution using the given data. Consider the following linear programming problem. Illustrate what is the optimum solution to this problem?

Outflow of cash for both investing and financing activities : Deriving cash collected and cash paid using financial ratios - Briefly describe why this outflow of cash for both investing and financing activities actually is a positive sign for the Company and its stockholders.

How to do forecasting eps if sales drop : How to do Forecasting EPS if sales drop where Fixed operating costs are $2.5 million and the variable cost ratio is 65%

User Account

All Pages