Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hi I need help with the assets/liabilities using the data chart below As Reported Quarterly Balance Sheet Report Date 10/01/2023 3rd Quarter Currency USD Audit
Hi
I need help with the assets/liabilities using the data chart below
As Reported Quarterly Balance Sheet | |
Report Date | 10/01/2023 |
3rd Quarter | |
Currency | USD |
Audit Status | Unaudited |
Consolidated | Yes |
Scale | Thousands |
Cash | $3,214,000.00 |
Money market funds | $3,503,000.00 |
Cash & cash equivalents | $19,728,000.00 |
Restricted cash | - |
Marketable securities | $3,783,000.00 |
Accounts receivable, trade, gross | $14,958,000.00 |
Less: allowances | $160,000.00 |
Accounts receivable, trade | $14,798,000.00 |
Raw materials & supplies | $2,233,000.00 |
Goods in process | $1,961,000.00 |
Finished goods | $7,004,000.00 |
Inventories | $11,198,000.00 |
Prepaid expenses & other receivables | $4,196,000.00 |
Prepaid expenses & other current assets | - |
Government securities and obligations | $4,728,000.00 |
Corporate debt securities | $44,000.00 |
Reverse repurchase agreements | $7,261,000.00 |
Time deposits | $748,000.00 |
Other Sovereign Securities | $2,000.00 |
Corporate debt securities | $78,000.00 |
Non-U.S. sovereign securities | $150,000.00 |
Total current assets | $53,703,000.00 |
Property, plant & equipment at cost | $45,626,000.00 |
Less: accumulated depreciation | $26,805,000.00 |
Property, plant & equipment, net | $18,821,000.00 |
Intangible assets, net | $35,021,000.00 |
Goodwill | $36,124,000.00 |
Deferred taxes on income | $9,259,000.00 |
Other assets | $13,133,000.00 |
Other Assets - Balancing value | $9,110,000.00 |
Equity investments | $4,023,000.00 |
Total assets | $166,061,000.00 |
Loans & notes payable | $2,000,000.00 |
Accounts payable | $8,355,000.00 |
Accrued liabilities | $10,101,000.00 |
Accrued rebates, returns & promotions | $15,808,000.00 |
Accrued compensation & employee related obligations | $3,337,000.00 |
Accrued taxes on income | - |
Taxes on income | $2,899,000.00 |
Loans and Notes Payable Current portion | $1,870,000.00 |
Loans and Notes Payable | $3,870,000.00 |
Total current liabilities | $44,370,000.00 |
Notes | - |
Debentures | - |
Other long-term debt | - |
Long-term debt | $26,051,000.00 |
Deferred taxes on income | $2,623,000.00 |
Employee related obligations | $5,687,000.00 |
Long-term taxes payable | $2,540,000.00 |
Other liabilities | $13,562,000.00 |
Total liabilities | $94,833,000.00 |
Common stock | $3,120,000.00 |
Foreign currency translation | -$7,376,000.00 |
Gain (loss) on securities | -$2,000.00 |
Employee benefit plans | - |
Gain (loss) on derivatives & hedges | -$626,000.00 |
Pension liability adjustment | -$776,000.00 |
Accumulated other comprehensive income (loss) | -$8,780,000.00 |
Retained earnings & additional paid-in capital | - |
Retained earnings (accumulated deficit) | $152,536,000.00 |
Less: common stock held in treasury, at cost | $75,648,000.00 |
Total Johnson & Johnson shareholders? equity | $71,228,000.00 |
Total equity | $71,228,000.00 |
Equity attributable to non-controlling interest | - |
As Reported Quarterly Income Statement | |
Report Date | 10/01/2023 |
3rd Quarter | |
Currency | USD |
Audit Status | Unaudited |
Consolidated | Yes |
Scale | Thousands |
Sales to customers | $21,351,000.00 |
Cost of products sold | $6,606,000.00 |
Gross profit (loss) | $14,745,000.00 |
Selling, marketing & administrative expenses | $5,400,000.00 |
Research & development expense | $3,447,000.00 |
In-process research & development expenses | $206,000.00 |
Interest income | - |
Interest expense, net of portion capitalized | $192,000.00 |
Other income (expense), net | -$499,000.00 |
Restructuring expenses | $158,000.00 |
Interest income | $374,000.00 |
Earnings (loss) before provision for taxes on income | $5,217,000.00 |
Provision for (benefit from) taxes on income | $908,000.00 |
Net earnings (loss) | $26,028,000.00 |
Weighted average shares outstanding - basic | $2,522,900.00 |
Weighted average shares outstanding - diluted | $2,549,700.00 |
Year end shares outstanding | $2,407,178.00 |
Net earnings (loss) per share from continuing operations - basic | $1.71 |
Net earnings (loss) per share from discontinued operations - basic | $8.61 |
Net earnings (loss) per share - basic | $10.32 |
Net earnings (loss) per share from continuing operations - diluted | $1.69 |
Net earnings (loss) per share from discontinued operations - diluted | $8.52 |
Net earnings (loss) per share - diluted | $10.21 |
Cash dividends per share | $1.19 |
Total revenues | $21,351,000.00 |
Net earnings from Discontinued Operations, net of tax | $21,719,000.00 |
Sale of Discontinued Operations before Tax - Gain/Loss | $21,202,000.00 |
Discontinued Operations - Tax Impacts - Gain/Loss on Sale | $517,000.00 |
As Reported Quarterly Cash Flow | |
Report Date | 10/01/2023 |
3rd Quarter | |
Currency | USD |
Audit Status | Unaudited |
Consolidated | Yes |
Scale | Thousands |
Net earnings (loss) | $31,104,000.00 |
Depreciation & amortization of property & intangibles | $5,643,000.00 |
Stock based compensation | $984,000.00 |
Asset write-downs | - |
Net loss (gain) on sale of assets or businesses | -$117,000.00 |
Deferred tax provision (benefit) | -$1,782,000.00 |
Credit losses & accounts receivable allowances | - |
Accounts receivable | -$851,000.00 |
Inventories | -$1,447,000.00 |
Accounts payable & accrued liabilities | $664,000.00 |
Other current & non-current assets | -$1,366,000.00 |
Other current & non-current liabilities | $2,260,000.00 |
Asset write | $820,000.00 |
Gain on Kenvue separation | -$20,984,000.00 |
Net cash flows from operating activities | $14,928,000.00 |
Additions to property, plant & equipment | -$2,954,000.00 |
Proceeds from the disposal of assets or businesses, net | $237,000.00 |
Acquisitions, net of cash acquired | - |
Purchases of investments | -$9,981,000.00 |
Sales of investments | $15,787,000.00 |
Credit support agreements activity, net | - |
Other investing activities | -$92,000.00 |
Other investing activities (primarily licenses & milestones) | - |
Proceeds from credit support agreements | -$917,000.00 |
Net cash flows from investing activites | $2,080,000.00 |
Dividends to shareholders | -$8,905,000.00 |
Repurchase of common stock | -$4,838,000.00 |
Proceeds from short-term debt | $12,462,000.00 |
Repayment of short-term debt | -$21,645,000.00 |
Proceeds from long-term debt, net of issuance costs | $8,047,000.00 |
Repayment of long-term debt | -$502,000.00 |
Proceeds from the exercise of stock options | $907,000.00 |
Proceeds from the exercise of stock options or employee withholding tax on stock awards, net | - |
Credit support agreements activity, net | $62,000.00 |
Proceeds from Kenvue, Inc. initial public offering | $4,241,000.00 |
Other financing activities | $115,000.00 |
Cash transferred to Kenvue at separation | -$1,114,000.00 |
Net cash flows from financing activities | -$11,170,000.00 |
Effect of exchange rate changes on cash & cash equivalents | -$237,000.00 |
Increase (decrease) in cash & cash equivalents | $5,601,000.00 |
Increase (decrease) in cash, cash equivalents & restricted cash | - |
Cash & cash equivalents beginning of period | $14,127,000.00 |
Cash & cash equivalents, end of period | - |
Cash, cash equivalents & restricted cash, end of period | $19,728,000.00 |
DEBT RATIO (Total Liabilities / Total Assets) | NET PROFIT MARGIN (Net Income / Total Revenue) | ||||||||||||
Total Liabilities | Net Income | ||||||||||||
Total Assets | Total Revenue | ||||||||||||
EARNINGS PER SHARE (Net Income / Weighted Average Common Shares Outstanding) | RETURN ON ASSETS (Net Income / Total Assets) | ||||||||||||
Net Income | Net Income | ||||||||||||
Shares Outstanding | Total Assets | ||||||||||||
PRICE EARNINGS RATIO (Share Price (end of quarter / EPS) | RETURN ON EQUITY (Net Income - Preferred Dividends / Shareholder's Equity) | ||||||||||||
Stock Price | NI - Pref. Div. | ||||||||||||
EPS | Shareholder's Equity | ||||||||||||
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