Question
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) | 20x6 | 20x5 | 20x4 | ||
Net Sales | 13234 | 13994 | 14089 | ||
Cost of goods sold | 8670 | 7375 | 8086 | ||
gross profit | 4564 | 5619 | 6003 | ||
selling, general, and administrative expenses | 2781 | 2665 | 2846 | ||
Research and development costs | 779 | 784 | 817 | ||
Restructuiring costs (credits) and other | 659 | -44 | 350 | ||
earnings from operations | 345 | 2214 | 1990 | ||
Interest expense | 219 | 178 | 142 | ||
other income (charges) | -18 | 96 | 261 | ||
Earnings before income taxes | 108 | 2132 | 2109 | ||
provision for income taxes | 32 | 725 | 717 | ||
net earnings | 76 | 1407 | 1392 |
Here was my forecast for the income statement for 20x7:
20x7 | ||
Net sales | 12515.27 | |
cost of goods sold | 8199.14 | |
gross profit | 4316.13 | |
selling, general, and administrative expenses | 1906.45 | |
Research and development costs | 779.00 | |
Depreciation | 765.94 | |
Restructuiring costs (credits) and other | 0.00 | |
earnings from operations | 864.75 | |
Interest expense | 312.87 | |
other income (charges) | -18.00 | |
Earnings before income taxes | 533.88 | |
provision for income taxes | 158.19 | |
net earnings | 375.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) | 20x6 | 20x5 | step | 20x7 | |||
Current Assets | |||||||
cash and cash equivalents | 448 | 246 | |||||
receivables, net | 2337 | 2653 | 1 | 2211.18 | 12515.27/5.66 | ||
Inventories, Net | 1137 | 1718 | 2 | 1074.59 | 8199.14/7.63 | ||
Deferred income taxes | 521 | 575 | 12 | 521.00 | no change | ||
other current assets | 240 | 299 | 3 | 240.00 | no change | ||
total current assets | 4683 | 5491 | 4046.77 | ||||
property plant and equipment, net | 5659 | 5919 | 4 | 5881.77 | 5659+(12515.27*0.079) - (12982*0.059) | ||
goodwill, net | 948 | 947 | 4 | 948.00 | no change | ||
other long-term asets | 2072 | 1855 | 7 | 2072.00 | no change | ||
total assets | 13362 | 14212 | 12948.54 | ||||
Liabilities and Shareholder's equity | |||||||
current liabilities | |||||||
accounts payable and current liabilities | 3276 | 3403 | 8 | 3094.00 | 8199.14/2.65 | ||
short-term borrowings | 1378 | 2058 | 1378.00 | no change | |||
current portion of long-term debt | 156 | 148 | 9 | 13.00 | per assumption | ||
accrued income taxes | 544 | 606 | 544.00 | no change | |||
total current liabilities | 5354 | 6215 | 5029.00 | ||||
Long-term debt, net of current portion | 1666 | 1166 | 13 | 1653.00 | |||
post-employment liabilities | 2728 | 2722 | 2728.00 | no change | |||
other long-term liabilities | 720 | 681 | 720.00 | no change | |||
total liabilities | 10468 | 10784 | 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 20x5 | 978 | 978 | 978.00 | no change | |||
Additional paid in capital | 849 | 871 | 849.00 | no change | |||
retained earnings | 7431 | 7869 | 7293.39 | 7431+375.69-(1.77*290) | |||
accumulated other comprehensive loss | -597 | -482 | -597.00 | no change | |||
8661 | 9236 | 8523.39 | |||||
Treasury stock, at cost; 100363059 shares in 20x6 and 100808494 shares in 20x5 | -5767 | -5808 | -5767.00 | no change | |||
total shareholders' equity | 2894 | 3428 | 2756.39 | ||||
total liabilities and shareholders' equity | 13362 | 14212 | 12886.39 |
Also here are the ratios I have calculated:
Growth rate - | -0.054309 | (13234+13994)/13994 |
Gross profit margin | 34.49% | (13234-8670)/13234*100 |
SGA Percentage | 0.15233 | (2781-765)/13234 |
Depreciation expense / gross prior year PPE | 0.059 | 765/12963 |
Interest expense / prior- year long term debt | 0.1878 | 219/1166 |
income tax expense / pretax income | 0.2963 | 32/108 |
Accounts receivable turnover rate | 5.66 | 13234/2337 | |
inventory turn over rate | 7.63 | 7.63 | |
accounts payable turnover rate | 2.65 | 8670/3276 | |
acrued expenses turnover rate | |||
taxes payable / tax expense | 1.044 | 544/521 | |
dividends per share | 1.77 | 514000000/290929701 | |
capital expenditures (CAPEX) in millions | 988.71 | 12515.27*0.079 | |
CAPEX/Sales | 0.079 | 0.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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started