Question: 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
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
