Question: Use these statements to support your analysis Johnson & Johnson As Reported Quarterly Balance Sheet Mergent Online Report Date 10/01/2023 07/02/2023 04/02/2023 10/02/2022 07/03/2022 04/03/2022
Use these statements to support your analysis
Johnson & Johnson As Reported Quarterly Balance Sheet Mergent Online
| Report Date | 10/01/2023 | 07/02/2023 | 04/02/2023 | 10/02/2022 | 07/03/2022 | 04/03/2022 | 10/03/2021 | 07/04/2021 | 04/04/2021 | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3rd Quarter | 2nd Quarter | 1st Quarter | 3rd Quarter | 2nd Quarter | 1st Quarter | 3rd Quarter | 2nd Quarter | 1st Quarter | ||||||||||
| Currency | USD | USD | USD | USD | USD | USD | USD | USD | USD | |||||||||
| Audit Status | Unaudited | Unaudited | Unaudited | Unaudited | Unaudited | Unaudited | Unaudited | Unaudited | Unaudited | |||||||||
| Consolidated | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||||||||
| Scale | Thousands | Thousands | Thousands | Thousands | Thousands | Thousands | Thousands | Thousands | Thousands | |||||||||
| Cash | 3,214,000 | - | - | - | - | - | - | - | - | |||||||||
| Money market funds | 3,503,000 | - | - | - | - | - | - | - | - | |||||||||
| Cash & cash equivalents | 19,728,000 | 21,183,000 | 19,170,000 | 11,355,000 | 10,983,000 | 10,463,000 | 17,604,000 | 14,332,000 | 12,671,000 | |||||||||
| Restricted cash | - | - | 7,695,000 | - | - | - | - | - | - | |||||||||
| Marketable securities | 3,783,000 | 7,322,000 | 5,443,000 | 22,724,000 | 21,585,000 | 19,925,000 | 13,397,000 | 10,974,000 | 11,948,000 | |||||||||
| Accounts receivable, trade, gross | 14,958,000 | 16,982,000 | 16,557,000 | 16,091,000 | 16,362,000 | 15,828,000 | 15,134,000 | 15,105,000 | 15,208,000 | |||||||||
| Less: allowances | 160,000 | 205,000 | 207,000 | 201,000 | 223,000 | 234,000 | 223,000 | 234,000 | 270,000 | |||||||||
| Accounts receivable, trade | 14,798,000 | 16,777,000 | 16,350,000 | 15,890,000 | 16,139,000 | 15,594,000 | 14,911,000 | 14,871,000 | 14,938,000 | |||||||||
| Raw materials & supplies | 2,233,000 | 2,419,000 | 2,267,000 | 1,730,000 | 1,696,000 | 1,679,000 | 1,587,000 | 1,576,000 | 1,557,000 | |||||||||
| Goods in process | 1,961,000 | 1,944,000 | 1,866,000 | 2,106,000 | 2,324,000 | 2,629,000 | 2,164,000 | 2,307,000 | 2,034,000 | |||||||||
| Finished goods | 7,004,000 | 8,525,000 | 8,676,000 | 7,839,000 | 7,417,000 | 6,682,000 | 6,636,000 | 6,217,000 | 6,361,000 | |||||||||
| Inventories | 11,198,000 | 12,888,000 | 12,809,000 | 11,675,000 | 11,437,000 | 10,990,000 | 10,387,000 | 10,100,000 | 9,952,000 | |||||||||
| Prepaid expenses & other receivables | 4,196,000 | - | - | - | - | - | - | - | - | |||||||||
| Prepaid expenses & other current assets | - | 2,397,000 | 2,921,000 | 3,592,000 | 3,703,000 | 3,452,000 | 3,590,000 | 3,492,000 | 3,024,000 | |||||||||
| Government securities and obligations | 4,728,000 | - | - | - | - | - | - | - | - | |||||||||
| Corporate debt securities | 44,000 | - | - | - | - | - | - | - | - | |||||||||
| Reverse repurchase agreements | 7,261,000 | - | - | - | - | - | - | - | - | |||||||||
| Time deposits | 748,000 | - | - | - | - | - | - | - | - | |||||||||
| Other Sovereign Securities | 2,000 | - | - | - | - | - | - | - | - | |||||||||
| Corporate debt securities | 78,000 | - | - | - | - | - | - | - | - | |||||||||
| Non-U.S. sovereign securities | 150,000 | - | - | - | - | - | - | - | - | |||||||||
| Total current assets | 53,703,000 | 60,567,000 | 64,388,000 | 65,236,000 | 63,847,000 | 60,424,000 | 59,889,000 | 53,769,000 | 52,533,000 | |||||||||
| Property, plant & equipment at cost | 45,626,000 | 51,218,000 | 50,367,000 | 46,681,000 | 47,144,000 | 47,702,000 | 47,347,000 | 47,201,000 | 46,430,000 | |||||||||
| Less: accumulated depreciation | 26,805,000 | 30,642,000 | 30,193,000 | 28,529,000 | 28,790,000 | 29,001,000 | 28,869,000 | 28,569,000 | 28,063,000 | |||||||||
| Property, plant & equipment, net | 18,821,000 | 20,576,000 | 20,174,000 | 18,152,000 | 18,354,000 | 18,701,000 | 18,478,000 | 18,632,000 | 18,367,000 | |||||||||
| Intangible assets, net | 35,021,000 | 46,246,000 | 47,448,000 | 40,336,000 | 42,408,000 | 44,420,000 | 47,776,000 | 50,244,000 | 51,110,000 | |||||||||
| Goodwill | 36,124,000 | 45,440,000 | 45,575,000 | 33,383,000 | 34,166,000 | 34,935,000 | 35,569,000 | 35,819,000 | 35,688,000 | |||||||||
| Deferred taxes on income | 9,259,000 | 8,779,000 | 8,817,000 | 9,392,000 | 9,514,000 | 9,936,000 | 10,646,000 | 10,804,000 | 8,321,000 | |||||||||
| Other assets | 13,133,000 | 10,078,000 | 9,567,000 | 8,625,000 | 9,435,000 | 9,939,000 | 6,870,000 | 7,172,000 | 6,538,000 | |||||||||
| Other Assets - Balancing value | 9,110,000 | - | - | - | - | - | - | - | - | |||||||||
| Equity investments | 4,023,000 | - | - | - | - | - | - | - | - | |||||||||
| Total assets | 166,061,000 | 191,686,000 | 195,969,000 | 175,124,000 | 177,724,000 | 178,355,000 | 179,228,000 | 176,440,000 | 172,557,000 | |||||||||
| Loans & notes payable | 2,000,000 | 11,701,000 | 17,979,000 | 4,424,000 | 4,305,000 | 4,297,000 | 3,798,000 | 3,173,000 | 3,350,000 | |||||||||
| Accounts payable | 8,355,000 | 10,443,000 | 9,909,000 | 10,153,000 | 9,765,000 | 9,309,000 | 8,961,000 | 8,704,000 | 8,503,000 | |||||||||
| Accrued liabilities | 10,101,000 | 10,605,000 | 11,204,000 | 11,953,000 | 12,607,000 | 13,006,000 | 13,812,000 | 10,485,000 | 13,223,000 | |||||||||
| Accrued rebates, returns & promotions | 15,808,000 | 15,672,000 | 14,784,000 | 14,021,000 | 13,447,000 | 12,972,000 | 12,683,000 | 12,450,000 | 11,919,000 | |||||||||
| Accrued compensation & employee related obligations | 3,337,000 | 3,062,000 | 2,231,000 | 3,006,000 | 2,717,000 | 2,098,000 | 3,146,000 | 2,709,000 | 2,060,000 | |||||||||
| Accrued taxes on income | - | 2,687,000 | 4,266,000 | 1,986,000 | 1,980,000 | 1,708,000 | 2,161,000 | 1,200,000 | 1,877,000 | |||||||||
| Taxes on income | 2,899,000 | - | - | - | - | - | - | - | - | |||||||||
| Loans and Notes Payable Current portion | 1,870,000 | - | - | - | - | - | - | - | - | |||||||||
| Loans and Notes Payable | 3,870,000 | - | - | - | - | - | - | - | - | |||||||||
| Total current liabilities | 44,370,000 | 54,170,000 | 60,373,000 | 45,543,000 | 44,821,000 | 43,390,000 | 44,561,000 | 38,721,000 | 40,932,000 | |||||||||
| Notes | - | 24,423,000 | 25,461,000 | 25,610,000 | 26,297,000 | 26,859,000 | 28,141,000 | 28,319,000 | 28,273,000 | |||||||||
| Debentures | - | 9,412,000 | 9,410,000 | 1,985,000 | 1,985,000 | 1,985,000 | 1,984,000 | 1,984,000 | 1,983,000 | |||||||||
| Other long-term debt | - | 66,000 | 57,000 | 8,000 | 10,000 | 7,000 | 5,000 | 7,000 | 7,000 | |||||||||
| Long-term debt | 26,051,000 | 33,901,000 | 34,928,000 | 27,603,000 | 28,292,000 | 28,851,000 | 30,130,000 | 30,310,000 | 30,263,000 | |||||||||
| Deferred taxes on income | 2,623,000 | 3,627,000 | 4,417,000 | 4,946,000 | 5,015,000 | 6,424,000 | 7,147,000 | 9,016,000 | 6,507,000 | |||||||||
| Employee related obligations | 5,687,000 | 6,461,000 | 6,665,000 | 8,353,000 | 8,553,000 | 8,739,000 | 10,171,000 | 10,367,000 | 10,512,000 | |||||||||
| Long-term taxes payable | 2,540,000 | 2,536,000 | 4,296,000 | 4,162,000 | 4,162,000 | 5,745,000 | 5,770,000 | 5,722,000 | 6,568,000 | |||||||||
| Other liabilities | 13,562,000 | 14,582,000 | 14,421,000 | 9,918,000 | 10,524,000 | 10,497,000 | 11,177,000 | 12,724,000 | 11,941,000 | |||||||||
| Total liabilities | 94,833,000 | 115,277,000 | 125,100,000 | 100,525,000 | 101,367,000 | 103,646,000 | 108,956,000 | 106,860,000 | 106,723,000 | |||||||||
| Common stock | 3,120,000 | 3,120,000 | 3,120,000 | 3,120,000 | 3,120,000 | 3,120,000 | 3,120,000 | 3,120,000 | 3,120,000 | |||||||||
| Foreign currency translation | (7,376,000) | (12,161,000) | (11,994,000) | (11,974,000) | (10,722,000) | (10,571,000) | (9,179,000) | (8,797,000) | (8,662,000) | |||||||||
| Gain (loss) on securities | (2,000) | (6,000) | (10,000) | (38,000) | (36,000) | (16,000) | - | - | 1,000 | |||||||||
| Employee benefit plans | - | (1,035,000) | (965,000) | (2,358,000) | (2,472,000) | (2,538,000) | (6,257,000) | (6,490,000) | (6,724,000) | |||||||||
| Gain (loss) on derivatives & hedges | (626,000) | 67,000 | 343,000 | (922,000) | (613,000) | (632,000) | 21,000 | 187,000 | 57,000 | |||||||||
| Pension liability adjustment | (776,000) | - | - | - | - | - | - | - | - | |||||||||
| Accumulated other comprehensive income (loss) | (8,780,000) | (13,135,000) | (12,626,000) | (15,292,000) | (13,843,000) | (13,757,000) | (15,415,000) | (15,100,000) | (15,328,000) | |||||||||
| Retained earnings & additional paid-in capital | - | 129,381,000 | 124,558,000 | - | - | - | - | - | - | |||||||||
| Retained earnings (accumulated deficit) | 152,536,000 | - | - | 127,917,000 | 126,216,000 | 124,380,000 | 121,092,000 | 120,154,000 | 116,508,000 | |||||||||
| Less: common stock held in treasury, at cost | 75,648,000 | 44,217,000 | 44,183,000 | 41,146,000 | 39,136,000 | 39,034,000 | 38,525,000 | 38,594,000 | 38,466,000 | |||||||||
| Total Johnson & Johnson shareholders? equity | 71,228,000 | 75,149,000 | 70,869,000 | 74,599,000 | 76,357,000 | 74,709,000 | 70,272,000 | 69,580,000 | 65,834,000 | |||||||||
| Total equity | 71,228,000 | 76,409,000 | - | - | - | - | - | - | - | |||||||||
| Equity attributable to non-controlling interest | - | 1,260,000 | - | - | - | - | - | - | - |
As Reported Quarterly Income Statement
| Report Date | 10/01/2023 | 07/02/2023 | 04/02/2023 | 10/02/2022 | 07/03/2022 | 04/03/2022 | 10/03/2021 | 07/04/2021 | 04/04/2021 | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3rd Quarter | 2nd Quarter | 1st Quarter | 3rd Quarter | 2nd Quarter | 1st Quarter | 3rd Quarter | 2nd Quarter | 1st Quarter | ||||||||||
| Currency | USD | USD | USD | USD | USD | USD | USD | USD | USD | |||||||||
| Audit Status | Unaudited | Unaudited | Unaudited | Unaudited | Unaudited | Unaudited | Unaudited | Unaudited | Unaudited | |||||||||
| Consolidated | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||||||||
| Scale | Thousands | Thousands | Thousands | Thousands | Thousands | Thousands | Thousands | Thousands | Thousands | |||||||||
| Sales to customers | 21,351,000 | 25,530,000 | 24,746,000 | 23,791,000 | 24,020,000 | 23,426,000 | 23,338,000 | 23,312,000 | 22,321,000 | |||||||||
| Cost of products sold | 6,606,000 | 8,212,000 | 8,395,000 | 7,807,000 | 7,919,000 | 7,598,000 | 7,250,000 | 7,587,000 | 7,063,000 | |||||||||
| Gross profit (loss) | 14,745,000 | 17,318,000 | 16,351,000 | 15,984,000 | 16,101,000 | 15,828,000 | 16,088,000 | 15,725,000 | 15,258,000 | |||||||||
| Selling, marketing & administrative expenses | 5,400,000 | 6,665,000 | 6,138,000 | 6,089,000 | 6,226,000 | 5,938,000 | 6,000,000 | 6,073,000 | 5,432,000 | |||||||||
| Research & development expense | 3,447,000 | 3,829,000 | 3,563,000 | 3,597,000 | 3,703,000 | 3,462,000 | 3,422,000 | 3,394,000 | 3,178,000 | |||||||||
| In-process research & development expenses | 206,000 | - | 49,000 | - | - | 610,000 | 900,000 | - | - | |||||||||
| Interest income | - | 369,000 | 235,000 | 150,000 | 64,000 | 22,000 | 13,000 | 12,000 | 15,000 | |||||||||
| Interest expense, net of portion capitalized | 192,000 | 346,000 | 215,000 | 51,000 | 38,000 | 10,000 | 20,000 | 40,000 | 63,000 | |||||||||
| Other income (expense), net | (499,000) | 60,000 | (7,228,000) | (493,000) | (273,000) | 102,000 | (1,850,000) | 488,000 | 882,000 | |||||||||
| Restructuring expenses | 158,000 | 145,000 | 130,000 | 82,000 | 85,000 | 70,000 | 60,000 | 56,000 | 53,000 | |||||||||
| Interest income | 374,000 | - | - | - | - | - | - | - | - | |||||||||
| Earnings (loss) before provision for taxes on income | 5,217,000 | 6,762,000 | (737,000) | 5,822,000 | 5,840,000 | 5,862,000 | 3,849,000 | 6,662,000 | 7,429,000 | |||||||||
| Provision for (benefit from) taxes on income | 908,000 | 1,618,000 | (669,000) | 1,364,000 | 1,026,000 | 713,000 | 182,000 | 384,000 | 1,232,000 | |||||||||
| Net earnings (loss) | 26,028,000 | 5,144,000 | (68,000) | 4,458,000 | 4,814,000 | 5,149,000 | 3,667,000 | 6,278,000 | 6,197,000 | |||||||||
| Weighted average shares outstanding - basic | 2,522,900 | 2,598,400 | 2,605,500 | 2,627,900 | 2,629,600 | 2,629,200 | 2,632,600 | 2,632,500 | 2,631,600 | |||||||||
| Weighted average shares outstanding - diluted | 2,549,700 | 2,625,700 | 2,605,500 | 2,661,300 | 2,667,900 | 2,666,500 | 2,674,900 | 2,671,600 | 2,672,700 | |||||||||
| Year end shares outstanding | 2,407,178 | 2,598,143 | 2,598,324 | 2,616,882 | 2,629,032 | 2,629,384 | 2,632,485 | 2,631,989 | 2,632,702 | |||||||||
| 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 | 1.98 | (0.03) | 1.7 | 1.83 | 1.96 | 1.39 | 2.38 | 2.35 | |||||||||
| 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 | 1.96 | (0.03) | 1.68 | 1.8 | 1.93 | 1.37 | 2.35 | 2.32 | |||||||||
| Cash dividends per share | 1.19 | 1.19 | 1.13 | 1.13 | 1.13 | 1.06 | 1.06 | 1.06 | 1.01 | |||||||||
| Total revenues | 21,351,000 | - | - | - | - | - | - | - | - | |||||||||
| Net earnings from Discontinued Operations, net of tax | 21,719,000 | - | - | - | - | - | - | - | - | |||||||||
| Sale of Discontinued Operations before Tax - Gain/Loss | 21,202,000 | - | - | - | - | - | - | - | - | |||||||||
| Discontinued Operations - Tax Impacts - Gain/Loss on Sale | 517,000 | - | - | - | - | - | - | - | - |
As Reported Quarterly Retained Earnings
| Report Date | 07/02/2023 | 04/02/2023 | 10/02/2022 | 07/03/2022 | 04/03/2022 | 10/03/2021 | 07/04/2021 | 04/04/2021 | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2nd Quarter | 1st Quarter | 3rd Quarter | 2nd Quarter | 1st Quarter | 3rd Quarter | 2nd Quarter | 1st Quarter | |||||||||
| Currency | USD | USD | USD | USD | USD | USD | USD | USD | ||||||||
| Audit Status | Unaudited | Unaudited | Unaudited | Unaudited | Unaudited | Unaudited | Unaudited | Unaudited | ||||||||
| Consolidated | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | ||||||||
| Scale | Thousands | Thousands | Thousands | Thousands | Thousands | Thousands | Thousands | Thousands | ||||||||
| Previous retained earnings (accumulated deficit) | 124,558,000 | 128,345,000 | 126,216,000 | 124,380,000 | 123,060,000 | 120,154,000 | 116,508,000 | 113,890,000 | ||||||||
| Cash dividends paid | 3,092,000 | 2,942,000 | 2,970,000 | 2,971,000 | 2,787,000 | 2,791,000 | 2,791,000 | 2,659,000 | ||||||||
| Employee compensation & stock option plans | (301,000) | 777,000 | (213,000) | 7,000 | 1,042,000 | (62,000) | (159,000) | 920,000 | ||||||||
| Kenvue IPO | 2,470,000 | - | - | - | - | - | - | - | ||||||||
| Retained earnings (accumulated deficit) | 129,381,000 | 124,558,000 | 127,917,000 | 126,216,000 | 124,380,000 | 121,092,000 | 120,154,000 | 116,508,000 |
As Reported Quarterly Cash Flow
| Report Date | 10/01/2023 | 07/02/2023 | 04/02/2023 | 10/02/2022 | 07/03/2022 | 04/03/2022 | 10/03/2021 | 07/04/2021 | 04/04/2021 | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3rd Quarter | 2nd Quarter | 1st Quarter | 3rd Quarter | 2nd Quarter | 1st Quarter | 3rd Quarter | 2nd Quarter | 1st Quarter | ||||||||||
| Currency | USD | USD | USD | USD | USD | USD | USD | USD | USD | |||||||||
| Audit Status | Unaudited | Unaudited | Unaudited | Unaudited | Unaudited | Unaudited | Unaudited | Unaudited | Unaudited | |||||||||
| Consolidated | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | |||||||||
| Scale | Thousands | Thousands | Thousands | Thousands | Thousands | Thousands | Thousands | Thousands | Thousands | |||||||||
| Net earnings (loss) | 31,104,000 | 5,076,000 | (68,000) | 14,421,000 | 9,963,000 | 5,149,000 | 16,142,000 | 12,475,000 | 6,197,000 | |||||||||
| Depreciation & amortization of property & intangibles | 5,643,000 | 3,814,000 | 1,880,000 | 5,198,000 | 3,513,000 | 1,769,000 | 5,547,000 | 3,733,000 | 1,894,000 | |||||||||
| Stock based compensation | 984,000 | 688,000 | 306,000 | 925,000 | 644,000 | 278,000 | 920,000 | 661,000 | 307,000 | |||||||||
| Asset write-downs | - | 388,000 | 426,000 | 787,000 | 747,000 | 610,000 | 964,000 | 26,000 | 14,000 | |||||||||
| Net loss (gain) on sale of assets or businesses | (117,000) | (47,000) | (8,000) | (213,000) | (213,000) | (168,000) | (601,000) | (601,000) | (580,000) | |||||||||
| Deferred tax provision (benefit) | (1,782,000) | (2,342,000) | (1,543,000) | (2,488,000) | (2,349,000) | (926,000) | (2,564,000) | (685,000) | (730,000) | |||||||||
| Credit losses & accounts receivable allowances | - | - | 1,000 | (14,000) | (3,000) | 6,000 | (60,000) | (52,000) | (13,000) | |||||||||
| Accounts receivable | (851,000) | (599,000) | (54,000) | (1,591,000) | (1,386,000) | (427,000) | (1,818,000) | (1,566,000) | (1,604,000) | |||||||||
| Inventories | (1,447,000) | (741,000) | (524,000) | (1,877,000) | (1,257,000) | (600,000) | (1,178,000) | (818,000) | (695,000) | |||||||||
| Accounts payable & accrued liabilities | 664,000 | (1,061,000) | (2,572,000) | 141,000 | (1,170,000) | (2,817,000) | 182,000 | (4,050,000) | (2,336,000) | |||||||||
| Other current & non-current assets | (1,366,000) | (1,144,000) | (915,000) | 4,563,000 | 3,527,000 | 995,000 | 2,082,000 | 1,415,000 | 2,522,000 | |||||||||
| Other current & non-current liabilities | 2,260,000 | 3,407,000 | 6,328,000 | (4,008,000) | (2,456,000) | 110,000 | (1,938,000) | (1,150,000) | (902,000) | |||||||||
| Asset write | 820,000 | - | - | - | - | - | - | - | - | |||||||||
| Gain on Kenvue separation | (20,984,000) | - | - | - | - | - | - | - | - | |||||||||
| Net cash flows from operating activities | 14,928,000 | 7,439,000 | 3,257,000 | 15,844,000 | 9,560,000 | 3,979,000 | 17,678,000 | 9,388,000 | 4,074,000 | |||||||||
| Additions to property, plant & equipment | (2,954,000) | (1,987,000) | (863,000) | (2,422,000) | (1,470,000) | (607,000) | (2,237,000) | (1,490,000) | (677,000) | |||||||||
| Proceeds from the disposal of assets or businesses, net | 237,000 | 116,000 | 40,000 | 322,000 | 314,000 | 248,000 | 666,000 | 654,000 | 603,000 | |||||||||
| Acquisitions, net of cash acquired | - | - | - | (522,000) | (523,000) | (252,000) | - | - | - | |||||||||
| Purchases of investments | (9,981,000) | (9,688,000) | (3,774,000) | (31,163,000) | (22,048,000) | (9,018,000) | (18,843,000) | (12,264,000) | (5,994,000) | |||||||||
| Sales of investments | 15,787,000 | 11,877,000 | 7,766,000 | 26,324,000 | 17,634,000 | 6,303,000 | 16,809,000 | 12,453,000 | 5,233,000 | |||||||||
| Credit support agreements activity, net | - | (798,000) | 158,000 | (305,000) | (10,000) | (249,000) | 696,000 | 441,000 | 751,000 | |||||||||
| Other investing activities | (92,000) | - | - | - | - | - | - | - | - | |||||||||
| Other investing activities (primarily licenses & milestones) | - | 19,000 | (12,000) | (208,000) | (170,000) | (59,000) | (414,000) | (398,000) | (101,000) | |||||||||
| Proceeds from credit support agreements | (917,000) | - | - | - | - | - | - | - | - | |||||||||
| Net cash flows from investing activites | 2,080,000 | (461,000) | 3,315,000 | (7,974,000) | (6,273,000) | (3,634,000) | (3,323,000) | (604,000) | (185,000) | |||||||||
| Dividends to shareholders | (8,905,000) | (6,034,000) | (2,942,000) | (8,728,000) | (5,758,000) | (2,787,000) | (8,241,000) | (5,450,000) | (2,659,000) | |||||||||
| Repurchase of common stock | (4,838,000) | (3,918,000) | (3,537,000) | (4,715,000) | (2,550,000) | (1,577,000) | (2,460,000) | (2,069,000) | (1,438,000) | |||||||||
| Proceeds from short-term debt | 12,462,000 | 12,221,000 | 11,094,000 | 7,099,000 | 4,371,000 | 3,019,000 | 1,283,000 | 498,000 | 23,000 | |||||||||
| Repayment of short-term debt | (21,645,000) | (13,611,000) | (5,388,000) | (4,808,000) | (2,201,000) | (856,000) | (821,000) | (689,000) | (475,000) | |||||||||
| Proceeds from long-term debt, net of issuance costs | 8,047,000 | 7,674,000 | 7,674,000 | 1,000 | 2,000 | - | 3,000 | 1,000 | 1,000 | |||||||||
| Repayment of long-term debt | (502,000) | (501,000) | (500,000) | (2,133,000) | (2,132,000) | (2,132,000) | (1,452,000) | (1,451,000) | (1,001,000) | |||||||||
| Proceeds from the exercise of stock options | 907,000 | - | - | - | - | - | - | - | - | |||||||||
| Proceeds from the exercise of stock options or employee withholding tax on stock awards, net | - | 254,000 | (11,000) | 907,000 | 820,000 | 321,000 | 808,000 | 543,000 | 236,000 | |||||||||
| Credit support agreements activity, net | 62,000 | (126,000) | (13,000) | 1,678,000 | 813,000 | (235,000) | 168,000 | 130,000 | 212,000 | |||||||||
| Proceeds from Kenvue, Inc. initial public offering | 4,241,000 | 4,241,000 | - | - | - | - | - | - | - | |||||||||
| Other financing activities | 115,000 | (53,000) | (239,000) | 128,000 | (11,000) | (138,000) | 101,000 | 83,000 | (24,000) | |||||||||
| Cash transferred to Kenvue at separation | (1,114,000) | - | - | - | - | - | - | - | - | |||||||||
| Net cash flows from financing activities | (11,170,000) | 147,000 | 6,138,000 | (10,571,000) | (6,646,000) | (4,385,000) | (10,611,000) | (8,404,000) | (5,125,000) | |||||||||
| Effect of exchange rate changes on cash & cash equivalents | (237,000) | (69,000) | 28,000 | (431,000) | (145,000) | 16,000 | (125,000) | (33,000) | (78,000) | |||||||||
| Increase (decrease) in cash & cash equivalents | 5,601,000 | 7,056,000 | - | (3,132,000) | (3,504,000) | (4,024,000) | 3,619,000 | 347,000 | (1,314,000) | |||||||||
| Increase (decrease) in cash, cash equivalents & restricted cash | - | - | 12,738,000 | - | - | - | - | - | - | |||||||||
| Cash & cash equivalents beginning of period | 14,127,000 | 14,127,000 | 14,127,000 | 14,487,000 | 14,487,000 | 14,487,000 | 13,985,000 | 13,985,000 | 13,985,000 | |||||||||
| Cash & cash equivalents, end of period | - | 21,183,000 | - | 11,355,000 | 10,983,000 | 10,463,000 | 17,604,000 | 14,332,000 | 12,671,000 | |||||||||
| Cash, cash equivalents & restricted cash, end of period | 19,728,000 | - | 26,865,000 | - | - | - | - | - | - |
Part 1. Financial Analysis: Johnson and Johnson
- Financial Calculations: Accurately calculate financial formulas to figure out the business's current financial health. You must calculate the following:
- Working capital
- Current ratio
- Debt ratio
- Earnings per share
- Price/earnings ratio
- Total asset turnover ratio
- Financial leverage
- Net profit margin
- Return on assets.
- Return on equity.
- Working Capital Management: Explain the impact of working capital management on the business's operations. Provide examples to support claims.
- Financing: Explain how a business finances its operations and expansion.
- Short-Term Financing: Explain how potential short-term financing sources could help the business raise funds for improving its financial health. Base response on the business's current financial information.
- Bond Investment: Discuss the risks and benefits of the business investing in a corporate bond. Include the necessary ethical factors, appropriate calculations, and examples to support your analysis. Use the Project Two Financial Assumptions document and the Bonds section of the Net Present Value (NPV) worksheet in Financial Formulas workbook.
- Capital Equipment: Discuss the risks and benefits of the business investing in capital equipment. Include the necessary ethical factors, appropriate calculations, and examples to support your analysis. Use the Assumptions document and the Equipment section of the Net Present Value (NPV) worksheet in the Financial Formulas workbook.
- Building: Discuss the risks and benefits of the business investing in a building. Include the necessary ethical factors, appropriate calculations, and examples to support your analysis. Use the Assumptions document and the Building section of the NPV worksheet
Ratios Most Recent Fiscal Qtr.
| CURRENT RATIO (Current Assets / Current Liabilities) | |||||
| Current Assets | $ | ||||
| Current Liabilities | $ | ||||
| $ | |||||
| WORKING CAPITAL (Current Assets - Current Liabilities) | |||||
| Current Assets | $ | ||||
| Current Liabilities | $ | ||||
| $ | |||||
| DEBT RATIO (Total Liabilities / Total Assets) | |||||
| Total Liabilities | $ | ||||
| Total Assets | $ | ||||
| $ | |||||
| EARNINGS PER SHARE (Net Income / Weighted Average Common Shares Outstanding) | |||||
| Net Income | $ | ||||
| Shares Outstanding | $ | ||||
| $ | |||||
| PRICE EARNINGS RATIO (Share Price (end of quarter / EPS) | |||||
| Stock Price | $ | ||||
| EPS | $ | ||||
| $ |
| TOTAL ASSET TURNOVER RATIO (Total Revenue / Total Assets) | |||||
| Total Revenue | $ | ||||
| Total Assets | $ | ||||
| $ | |||||
| FINANCIAL LEVERAGE (Total Assets / Shareholder's Equity) | |||||
| Total Assets | |||||
| Shareholder's Equity | #DIV/0! | ||||
| NET PROFIT MARGIN (Net Income / Total Revenue) | |||||
| Net Income | $ | ||||
| Total Revenue | $ | ||||
| $ | |||||
| RETURN ON ASSETS (Net Income / Total Assets) | |||||
| Net Income | $ | ||||
| Total Assets | $ | ||||
| $ | |||||
| RETURN ON EQUITY (Net Income - Preferred Dividends / Shareholder's Equity) | |||||
| NI - Pref. Div. | $ | ||||
| Shareholder's Equity | $ | ||||
| $ |
Ratios Same fiscal Qtr 1 Yr Ago
| CURRENT RATIO (Current Assets / Current Liabilities) | |||||
| Current Assets | $ | ||||
| Current Liabilities | $ | $ | |||
| WORKING CAPITAL (Current Assets - Current Liabilities) | |||||
| Current Assets | $ | ||||
| Current Liabilities | $ | $ | |||
| DEBT RATIO (Total Liabilities / Total Assets) | |||||
| Total Liabilities | $ | ||||
| Total Assets | $ | $ | |||
| EARNINGS PER SHARE (Net Income / Weighted Average Common Shares Outstanding) | |||||
| Net Income | $ | ||||
| Shares Outstanding | $ | $ | |||
| PRICE EARNINGS RATIO (Share Price (end of quarter / EPS) | |||||
| Stock Price | $ | ||||
| EPS | $ | $ | |||
| TOTAL ASSET TURNOVER RATIO (Total Revenue / Total Assets) | |||||
| Total Revenue | $ | ||||
| Total Assets | $ | $ | |||
| FINANCIAL LEVERAGE (Total Assets / Shareholder's Equity) | |||||
| Total Assets | $ | ||||
| Shareholder's Equity | $ | $ | |||
| NET PROFIT MARGIN (Net Income / Total Revenue) | |||||
| Net Income | $ | ||||
| Total Revenue | $ | $ | |||
| RETURN ON ASSETS (Net Income / Total Assets) | |||||
| Net Income | $ | ||||
| Total Assets | $ | $ | |||
| RETURN ON EQUITY (Net Income - Preferred Dividends / Shareholder's Equity) | |||||
| NI - Pref. Div. | $ | ||||
| Shareholder's Equity | $ | $ | |||
| Net Present Value (NPV) Calculator | |||||||||||||||||
| Building | |||||||||||||||||
| Initial Investment | Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ||||||
| Annual Cash Inflows | Cash Flows | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||||
| Discount Rate | NPV = | $0 | Year | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | ||||
| Number of Years | Cash Flows | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||||
| Salvage Value | |||||||||||||||||
| Equipment | |||||||||||||||||
| Initial Investment | Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ||||||
| Annual Cash Inflows | Cash Flows | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||||
| Discount Rate | NPV = | $0 | Year | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | ||||
| Number of Years | Cash Flows | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||||
| Salvage Value | |||||||||||||||||
| Bonds | |||||||||||||||||
| Initial Investment | |||||||||||||||||
| Annual Cash Inflows | |||||||||||||||||
| Discount Rate | NPV = | $0 | Year | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ||||
| Number of Years | Cash Flows | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | ||||||
| Principal Returned | |||||||||||||||||
Part 2. Financial Evaluation: In this section of the report, you will determine which of the three available investments are good financing options and describe the business's likely future financial performance.
- Bond Investment: Determine if the bond investment is a good financing option for the business's financial health. Use your financial analy
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
