$10$

$!$

Required Information

Alternate Lab $4\mathrm{.}4($LO $4\mathrm{.}3)$ Excel $-$ On Your Own: Calculation of Return on Net Operating Assets $($RNOA$)$

$[$The following information applies to the questions displayed below.$]$

Use the same steps as for Lab $4\mathrm{.}4,$ but now use Alt Lab $4-4$ Data for Johnson & Johnson.

Requlred:

Compute net operating profits after tax and Return on Net Operating Assets $($RNOA$)$ for Johnson & Johnson for the most recent two years in the dataset. Assume that the restructuring charge is an operating item and that the other expense is also an operating item.

Master the Data: Open Excel Flle Alt Lab $4\mathrm{.}4$ Data.XISX.

Perform the Analysls: Alternate Labs $-$ On Your Own don't have step$-$by$-$step Instruction. Apply your experience from the original lab. If needed, reference the text for instructions and steps from the original lab.

Alternate Lab $4\mathrm{.}4$ Excel: Assessment Questions

Answer the following questions based on the detalls provided.