Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I cannot get my balance sheet to balance. I am forecasting for period 20x7. The Income Statement provided is this: Income statement

 

I cannot get my balance sheet to balance.  I am forecasting for period 20x7. The Income Statement provided is this:

 

Income statement     
For year ended December 31 (in millions)20x620x520x4
Net Sales  132341399414089
Cost of goods sold  867073758086
 gross profit 456456196003
selling, general, and administrative expenses278126652846
Research and development costs779784817
Restructuiring costs (credits) and other659-44350
 earnings from operations34522141990
Interest expense  219178142
other income (charges) -1896261
Earnings before income taxes 10821322109
provision for income taxes 32725717
 net earnings7614071392

Here was my forecast for the income statement for 20x7:
 

  20x7
Net sales 12515.27
cost of goods sold8199.14
gross profit 4316.13
selling, general, and administrative expenses1906.45
Research and development costs779.00
Depreciation765.94
Restructuiring costs (credits) and other0.00
 earnings from operations864.75
Interest expense312.87
other income (charges)-18.00
Earnings before income taxes533.88
provision for income taxes158.19
 net earnings375.69

So now I am trying to forecast the balance sheet for 20x7 and here is the previous balance sheet and my forecast:
 

Balance Sheet      
At December 31 (in millions excpet share and per share data)20x620x5step20x7 
Current Assets      
 cash and cash equivalents448246   
 receivables, net2337265312211.1812515.27/5.66
 Inventories, Net1137171821074.598199.14/7.63
 Deferred income taxes52157512521.00no change
 other current assets2402993240.00no change
  total current assets46835491 4046.77 
 property plant and equipment, net5659591945881.775659+(12515.27*0.079) - (12982*0.059)
 goodwill, net9489474948.00no change
 other long-term asets2072185572072.00no change
  total assets1336214212 12948.54 
        
Liabilities and Shareholder's equity     
current liabilities      
 accounts payable and current liabilities3276340383094.008199.14/2.65
 short-term borrowings13782058 1378.00no change
 current portion of long-term debt156148913.00per assumption
 accrued income taxes544606 544.00no change
  total current liabilities53546215 5029.00 
 Long-term debt, net of current portion16661166131653.00 
 post-employment liabilities27282722 2728.00no change
 other long-term liabilities720681 720.00no change
  total liabilities1046810784 10130.00 
Shareholders' equity      
 common stock, $2.50 par value    
  950,000,000 shares authorized: issued 391,292,760 shares in 20x6 and 20x5
  290,929,701 and 290,484,266 shares outstanding in 20x6 and 20x5978978 978.00no change
 Additional paid in capital849871 849.00no change
 retained earnings74317869 7293.397431+375.69-(1.77*290)
 accumulated other comprehensive loss-597-482 -597.00no change
   86619236 8523.39 
 Treasury stock, at cost; 100363059 shares in 20x6 and 100808494 shares in 20x5-5767-5808 -5767.00no change
  total shareholders' equity28943428 2756.39 
  total liabilities and shareholders' equity1336214212 12886.39 

Also here are the ratios I have calculated:
 

Growth rate - -0.054309(13234+13994)/13994
Gross profit margin34.49%(13234-8670)/13234*100
SGA Percentage0.15233(2781-765)/13234
Depreciation expense / gross prior year PPE0.059765/12963
Interest expense / prior- year long term debt0.1878219/1166
income tax expense / pretax income0.296332/108
Accounts receivable turnover rate5.6613234/2337
inventory turn over rate 7.637.63
accounts payable turnover rate2.658670/3276
acrued expenses turnover rate  
taxes payable / tax expense1.044544/521
dividends per share 1.77514000000/290929701
capital expenditures (CAPEX) in millions988.7112515.27*0.079
CAPEX/Sales 0.0790.0791144
depreciation estimate  45.135

and finally here are the assumptions:
a.  All financial ratios remain at 20x6 levels.

b.  Kodak will not record restructuring costs for 20x7.

c.  Taxes payable are at the 20x6 level of $544 million.

d.  Depreciation expense charged to SG&A is $765 million and $738 million for 20x6 and 20x5, respectively.

e.  Gross PPE is $12,982 million and $12,963 million for 20x6 and 20x5, respectively.

f.  Projected current maturities of long-term debt are $13 million for 20x7.

g.  Capital expenditures for 20x6 and 20x5 are $1,047 and $783, respectively

the balance sheet is way off and the assets are larger than the liabilities and I haven't even calculated teh cash.  Where have I gone wrong?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Statement Analysis

Authors: K. R. Subramanyam, John Wild

11th edition

78110963, 978-0078110962

More Books

Students also viewed these Accounting questions

Question

Discuss whether money can buy happiness.

Answered: 1 week ago

Question

14. What are the functions of the prefrontal cortex?

Answered: 1 week ago