Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

begin{tabular}{|c|c|c|} hline hline multirow{2}{*}{AsReportedQuarterlyBalanceSheetReportDate} & 07/02/2023 & 07/03/2022 hline & 2nd Quarter & 2nd Quarter hline Currency & USD & USD

image text in transcribed

image text in transcribedimage text in transcribed

image text in transcribedimage text in transcribed

\begin{tabular}{|c|c|c|} \hline \\ \hline \multirow{2}{*}{AsReportedQuarterlyBalanceSheetReportDate} & 07/02/2023 & 07/03/2022 \\ \hline & 2nd Quarter & 2nd Quarter \\ \hline Currency & USD & USD \\ \hline Audit Status & Unaudited & Unaudited \\ \hline Consolidated & Yes & Yes \\ \hline Scale & Thousands & Thousands \\ \hline Cash \& cash equivalents & 21183000 & 10983000 \\ \hline Restricted cash & - & \\ \hline Marketable securities & 7322000 & 21585000 \\ \hline Accounts receivable, trade, gross & 16982000 & 16362000 \\ \hline Less: allowances & 205000 & 223000 \\ \hline Accounts receivable, trade & 16777000 & 16139000 \\ \hline Raw materials \& supplies & 2419000 & 1696000 \\ \hline Goods in process & 1944000 & 2324000 \\ \hline Finished goods & 8525000 & 7417000 \\ \hline Inventories & 12888000 & 11437000 \\ \hline Prepaid expenses \& other current assets & 2397000 & 3703000 \\ \hline Assets held for sale & - & - \\ \hline Total current assets & 60567000 & 63847000 \\ \hline Property, plant \& equipment at cost & 51218000 & 47144000 \\ \hline Less: accumulated depreciation & 30642000 & 28790000 \\ \hline Property, plant \& equipment, net & 20576000 & 18354000 \\ \hline Intangible assets, net & 46246000 & 42408000 \\ \hline Goodwill & 45440000 & 34166000 \\ \hline Deferred taxes on income & 8779000 & 9514000 \\ \hline Other assets & 10078000 & 9435000 \\ \hline Total assets & 191686000 & 177724000 \\ \hline Loans \& notes payable & 11701000 & 4305000 \\ \hline Accounts payable & 10443000 & 9765000 \\ \hline Accrued liabilities & 10605000 & 12607000 \\ \hline Accrued rebates, returns \& promotions & 15672000 & 13447000 \\ \hline Accrued compensation \& employee related obligations & 3062000 & 2717000 \\ \hline Accrued taxes on income & 2687000 & 1980000 \\ \hline Total current liabilities & 54170000 & 44821000 \\ \hline Notes & 24423000 & 26297000 \\ \hline Debentures & 9412000 & 1985000 \\ \hline Zero coupon convertible subordinated debentures & - & - \\ \hline Other long-term debt & 66000 & 10000 \\ \hline Long-term debt & 33901000 & 28292000 \\ \hline Deferred taxes on income & 3627000 & 5015000 \\ \hline Employee related obligations & 6461000 & 8553000 \\ \hline Long-term taxes payable & 2536000 & 4162000 \\ \hline Other liabilities & 14582000 & 10524000 \\ \hline Total liabilities & 115277000 & 101367000 \\ \hline Common stock & 3120000 & 3120000 \\ \hline Foreign currency translation & -12161000 & -10722000 \\ \hline Gain (loss) on securities & -6000 & -36000 \\ \hline Employee benefit plans & -1035000 & -2472000 \\ \hline Gain (loss) on derivatives \& hedges & 67000 & -613000 \\ \hline Accumulated other comprehensive income (loss) & -13135000 & -13843000 \\ \hline Retained earnings \& additional paid-in capital & 129381000 & - \\ \hline Retained earnings (accumulated deficit) & - & 126216000 \\ \hline Less: common stock held in treasury, at cost & 44217000 & 39136000 \\ \hline Total Johnson \& Johnson shareholders? equity & 75149000 & 76357000 \\ \hline Total equity & 76409000 & - \\ \hline Equity attributable to non-controlling interest & 1260000 & - \\ \hline \end{tabular} \begin{tabular}{l|r|r|} \hline As Reported Quarterly Income Statement & & \\ Report Date & 2nd Quarter & O7/03/2022 \\ \hline Currency & USD & 2nd Quarter \\ \hline Audit Status & Unaudited & USD \\ \hline Consolidated & Yes & Unaudited \\ \hline Scale & Thousands & Yes \\ \hline Sales to customers & 25530000 & Thousands \\ \hline Cost of products sold & 8212000 & 24020000 \\ \hline Gross profit (loss) & 17318000 & 7919000 \\ \hline Selling, marketing \& administrative expenses & 6665000 & 16101000 \\ \hline Research \& development expense & 3829000 & 6226000 \\ \hline In-process research \& development expenses & - & 3703000 \\ \hline Interest income & 369000 & - \\ \hline Interest expense, net of portion capitalized & 346000 & 64000 \\ \hline Other income (expense), net & 60000 & 38000 \\ \hline Restructuring expenses & 145000 & -273000 \\ \hline Earnings (loss) before provision for taxes on income & 6762000 & 85000 \\ \hline Provision for (benefit from) taxes on income & 1618000 & 5840000 \\ \hline Net earnings (loss) & 5144000 & 1026000 \\ \hline Weighted average shares outstanding - basic & 2598400 & 4814000 \\ \hline Weighted average shares outstanding - diluted & 2625700 & 2629600 \\ \hline Year end shares outstanding & 2598143 & 2667900 \\ \hline Net earnings (loss) per share - basic & 1.98 & 2629032 \\ \hline Net earnings (loss) per share - diluted & 1.96 & 1.83 \\ \hline Cash dividends per share & 1.19 & 1.8 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline \multirow{2}{*}{\multicolumn{3}{|c|}{ As Reported Quarterly Cash Flow }} \\ \hline & & \\ \hline \multirow{2}{*}{ Report Date } & 07/02/2023 & 07/03/2022 \\ \hline & 2nd Quarter & 2nd Quarter \\ \hline Currency & USD & USD \\ \hline Audit Status & Unaudited & Unaudited \\ \hline Consolidated & Yes & Yes \\ \hline Scale & Thousands & Thousands \\ \hline Net earnings (loss) & 5076000 & 9963000 \\ \hline Depreciation \& amortization of property \& intangibles & 3814000 & 3513000 \\ \hline Stock based compensation & 688000 & 644000 \\ \hline Asset write-downs & 388000 & 747000 \\ \hline Contingent consideration reversal & - & - \\ \hline Net loss (gain) on sale of assets & - & \\ \hline Net loss (gain) on sale of assets or businesses & -47000 & -213000 \\ \hline Deferred tax provision (benefit) & -2342000 & -2349000 \\ \hline Credit losses \& accounts receivable allowances & & -3000 \\ \hline Accounts receivable & -599000 & -1386000 \\ \hline Inventories & -741000 & -1257000 \\ \hline Accounts payable \& accrued liabilities & -1061000 & -1170000 \\ \hline Other current \& non-current assets & -1144000 & 3527000 \\ \hline Other current \& non-current liabilities & 3407000 & -2456000 \\ \hline Net cash flows from operating activities & 7439000 & 9560000 \\ \hline Additions to property, plant \& equipment & -1987000 & -1470000 \\ \hline Proceeds from the disposal of assets or businesses, net & 116000 & 314000 \\ \hline Acquisitions, net of cash acquired & - & -523000 \\ \hline Purchases of investments & -9688000 & -22048000 \\ \hline Sales of investments & 11877000 & 17634000 \\ \hline Credit support agreements activity, net & -798000 & -10000 \\ \hline \multicolumn{3}{|l|}{ Other investing activities } \\ \hline Other investing activities (primarily licenses \& milestones) & 19000 & -170000 \\ \hline Net cash flows from investing activites & -461000 & -6273000 \\ \hline Dividends to shareholders & -6034000 & -5758000 \\ \hline Repurchase of common stock & -3918000 & -2550000 \\ \hline Proceeds from short-term debt & 12221000 & 4371000 \\ \hline Repayment of short-term debt & -13611000 & -2201000 \\ \hline Proceeds from long-term debt, net of issuance costs & 7674000 & 2000 \\ \hline Repayment of long-term debt & -501000 & -2132000 \\ \hline Proceeds from the exercise of stock options or employee wi & 254000 & 820000 \\ \hline Credit support agreements activity, net & -126000 & 813000 \\ \hline Proceeds from Kenvue, Inc. initial public offering & 4241000 & \\ \hline Other financing activities & -53000 & -11000 \\ \hline Net cash flows from financing activities & 147000 & -6646000 \\ \hline Effect of exchange rate changes on cash \& cash equivalents & -69000 & -145000 \\ \hline Increase (decrease) in cash \& cash equivalents & 7056000 & -3504000 \\ \hline \multicolumn{3}{|l|}{ Increase (decrease) in cash, cash equivalents \& restricted c } \\ \hline Cash \& cash equivalents beginning of period & 14127000 & 14487000 \\ \hline Cash \& cash equivalents, end of period & 21183000 & 10983000 \\ \hline Cash, cash equivalents \& restricted cash, end of period & - & - \\ \hline \end{tabular} ACCOUNTING \& FINANCIAL RATIOS Financial Calculations. Calculate accurate financial formulas to assess the business's current inancial health. Specifically, calculate the following formulas using the Ratios Most Recent Fiscal Qtr and the Ratios Same Fiscal Qtr 1 Year Ago worksheets in the Project Two Financial Eormulas workbook: A. Working capital B. Current ratio C. Debt ratio D. Earnings per share E. Price/earnings ratio F. Total asset turnover ratio G. Financial leverage H. Net profit margin I. Return on assets J. Return on equity \begin{tabular}{|c|c|c|} \hline \\ \hline \multirow{2}{*}{AsReportedQuarterlyBalanceSheetReportDate} & 07/02/2023 & 07/03/2022 \\ \hline & 2nd Quarter & 2nd Quarter \\ \hline Currency & USD & USD \\ \hline Audit Status & Unaudited & Unaudited \\ \hline Consolidated & Yes & Yes \\ \hline Scale & Thousands & Thousands \\ \hline Cash \& cash equivalents & 21183000 & 10983000 \\ \hline Restricted cash & - & \\ \hline Marketable securities & 7322000 & 21585000 \\ \hline Accounts receivable, trade, gross & 16982000 & 16362000 \\ \hline Less: allowances & 205000 & 223000 \\ \hline Accounts receivable, trade & 16777000 & 16139000 \\ \hline Raw materials \& supplies & 2419000 & 1696000 \\ \hline Goods in process & 1944000 & 2324000 \\ \hline Finished goods & 8525000 & 7417000 \\ \hline Inventories & 12888000 & 11437000 \\ \hline Prepaid expenses \& other current assets & 2397000 & 3703000 \\ \hline Assets held for sale & - & - \\ \hline Total current assets & 60567000 & 63847000 \\ \hline Property, plant \& equipment at cost & 51218000 & 47144000 \\ \hline Less: accumulated depreciation & 30642000 & 28790000 \\ \hline Property, plant \& equipment, net & 20576000 & 18354000 \\ \hline Intangible assets, net & 46246000 & 42408000 \\ \hline Goodwill & 45440000 & 34166000 \\ \hline Deferred taxes on income & 8779000 & 9514000 \\ \hline Other assets & 10078000 & 9435000 \\ \hline Total assets & 191686000 & 177724000 \\ \hline Loans \& notes payable & 11701000 & 4305000 \\ \hline Accounts payable & 10443000 & 9765000 \\ \hline Accrued liabilities & 10605000 & 12607000 \\ \hline Accrued rebates, returns \& promotions & 15672000 & 13447000 \\ \hline Accrued compensation \& employee related obligations & 3062000 & 2717000 \\ \hline Accrued taxes on income & 2687000 & 1980000 \\ \hline Total current liabilities & 54170000 & 44821000 \\ \hline Notes & 24423000 & 26297000 \\ \hline Debentures & 9412000 & 1985000 \\ \hline Zero coupon convertible subordinated debentures & - & - \\ \hline Other long-term debt & 66000 & 10000 \\ \hline Long-term debt & 33901000 & 28292000 \\ \hline Deferred taxes on income & 3627000 & 5015000 \\ \hline Employee related obligations & 6461000 & 8553000 \\ \hline Long-term taxes payable & 2536000 & 4162000 \\ \hline Other liabilities & 14582000 & 10524000 \\ \hline Total liabilities & 115277000 & 101367000 \\ \hline Common stock & 3120000 & 3120000 \\ \hline Foreign currency translation & -12161000 & -10722000 \\ \hline Gain (loss) on securities & -6000 & -36000 \\ \hline Employee benefit plans & -1035000 & -2472000 \\ \hline Gain (loss) on derivatives \& hedges & 67000 & -613000 \\ \hline Accumulated other comprehensive income (loss) & -13135000 & -13843000 \\ \hline Retained earnings \& additional paid-in capital & 129381000 & - \\ \hline Retained earnings (accumulated deficit) & - & 126216000 \\ \hline Less: common stock held in treasury, at cost & 44217000 & 39136000 \\ \hline Total Johnson \& Johnson shareholders? equity & 75149000 & 76357000 \\ \hline Total equity & 76409000 & - \\ \hline Equity attributable to non-controlling interest & 1260000 & - \\ \hline \end{tabular} \begin{tabular}{l|r|r|} \hline As Reported Quarterly Income Statement & & \\ Report Date & 2nd Quarter & O7/03/2022 \\ \hline Currency & USD & 2nd Quarter \\ \hline Audit Status & Unaudited & USD \\ \hline Consolidated & Yes & Unaudited \\ \hline Scale & Thousands & Yes \\ \hline Sales to customers & 25530000 & Thousands \\ \hline Cost of products sold & 8212000 & 24020000 \\ \hline Gross profit (loss) & 17318000 & 7919000 \\ \hline Selling, marketing \& administrative expenses & 6665000 & 16101000 \\ \hline Research \& development expense & 3829000 & 6226000 \\ \hline In-process research \& development expenses & - & 3703000 \\ \hline Interest income & 369000 & - \\ \hline Interest expense, net of portion capitalized & 346000 & 64000 \\ \hline Other income (expense), net & 60000 & 38000 \\ \hline Restructuring expenses & 145000 & -273000 \\ \hline Earnings (loss) before provision for taxes on income & 6762000 & 85000 \\ \hline Provision for (benefit from) taxes on income & 1618000 & 5840000 \\ \hline Net earnings (loss) & 5144000 & 1026000 \\ \hline Weighted average shares outstanding - basic & 2598400 & 4814000 \\ \hline Weighted average shares outstanding - diluted & 2625700 & 2629600 \\ \hline Year end shares outstanding & 2598143 & 2667900 \\ \hline Net earnings (loss) per share - basic & 1.98 & 2629032 \\ \hline Net earnings (loss) per share - diluted & 1.96 & 1.83 \\ \hline Cash dividends per share & 1.19 & 1.8 \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline \multirow{2}{*}{\multicolumn{3}{|c|}{ As Reported Quarterly Cash Flow }} \\ \hline & & \\ \hline \multirow{2}{*}{ Report Date } & 07/02/2023 & 07/03/2022 \\ \hline & 2nd Quarter & 2nd Quarter \\ \hline Currency & USD & USD \\ \hline Audit Status & Unaudited & Unaudited \\ \hline Consolidated & Yes & Yes \\ \hline Scale & Thousands & Thousands \\ \hline Net earnings (loss) & 5076000 & 9963000 \\ \hline Depreciation \& amortization of property \& intangibles & 3814000 & 3513000 \\ \hline Stock based compensation & 688000 & 644000 \\ \hline Asset write-downs & 388000 & 747000 \\ \hline Contingent consideration reversal & - & - \\ \hline Net loss (gain) on sale of assets & - & \\ \hline Net loss (gain) on sale of assets or businesses & -47000 & -213000 \\ \hline Deferred tax provision (benefit) & -2342000 & -2349000 \\ \hline Credit losses \& accounts receivable allowances & & -3000 \\ \hline Accounts receivable & -599000 & -1386000 \\ \hline Inventories & -741000 & -1257000 \\ \hline Accounts payable \& accrued liabilities & -1061000 & -1170000 \\ \hline Other current \& non-current assets & -1144000 & 3527000 \\ \hline Other current \& non-current liabilities & 3407000 & -2456000 \\ \hline Net cash flows from operating activities & 7439000 & 9560000 \\ \hline Additions to property, plant \& equipment & -1987000 & -1470000 \\ \hline Proceeds from the disposal of assets or businesses, net & 116000 & 314000 \\ \hline Acquisitions, net of cash acquired & - & -523000 \\ \hline Purchases of investments & -9688000 & -22048000 \\ \hline Sales of investments & 11877000 & 17634000 \\ \hline Credit support agreements activity, net & -798000 & -10000 \\ \hline \multicolumn{3}{|l|}{ Other investing activities } \\ \hline Other investing activities (primarily licenses \& milestones) & 19000 & -170000 \\ \hline Net cash flows from investing activites & -461000 & -6273000 \\ \hline Dividends to shareholders & -6034000 & -5758000 \\ \hline Repurchase of common stock & -3918000 & -2550000 \\ \hline Proceeds from short-term debt & 12221000 & 4371000 \\ \hline Repayment of short-term debt & -13611000 & -2201000 \\ \hline Proceeds from long-term debt, net of issuance costs & 7674000 & 2000 \\ \hline Repayment of long-term debt & -501000 & -2132000 \\ \hline Proceeds from the exercise of stock options or employee wi & 254000 & 820000 \\ \hline Credit support agreements activity, net & -126000 & 813000 \\ \hline Proceeds from Kenvue, Inc. initial public offering & 4241000 & \\ \hline Other financing activities & -53000 & -11000 \\ \hline Net cash flows from financing activities & 147000 & -6646000 \\ \hline Effect of exchange rate changes on cash \& cash equivalents & -69000 & -145000 \\ \hline Increase (decrease) in cash \& cash equivalents & 7056000 & -3504000 \\ \hline \multicolumn{3}{|l|}{ Increase (decrease) in cash, cash equivalents \& restricted c } \\ \hline Cash \& cash equivalents beginning of period & 14127000 & 14487000 \\ \hline Cash \& cash equivalents, end of period & 21183000 & 10983000 \\ \hline Cash, cash equivalents \& restricted cash, end of period & - & - \\ \hline \end{tabular} ACCOUNTING \& FINANCIAL RATIOS Financial Calculations. Calculate accurate financial formulas to assess the business's current inancial health. Specifically, calculate the following formulas using the Ratios Most Recent Fiscal Qtr and the Ratios Same Fiscal Qtr 1 Year Ago worksheets in the Project Two Financial Eormulas workbook: A. Working capital B. Current ratio C. Debt ratio D. Earnings per share E. Price/earnings ratio F. Total asset turnover ratio G. Financial leverage H. Net profit margin I. Return on assets J. Return on equity

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

More Books

Students also viewed these Finance questions