Lab 8.2 Data

.xlsx
Business Unit Year Net Sales Operating income Total Assets Revenue Required R Safety & Industrial Products 2024 $ 11,767.00 $ 3,054.00 $ 17,309.75 $ 11,767.00 0.14 Transportion & Electronics 2024 $ 8,827.00 $ 1,927.00 $ 12,782.88 $ 8,827.00 0.14 Health Care 2024 $ 8,345.00 $ 1,828.00 $ 9,075 $ 8,345.00 0.14 Consumer 2024 $ 5,336.00 $ 1,249.00 $ 7,934.22 $ 5,336.00 0.14 Safety & Industrial Products 2023 $ 11,514.00 $ 2,510.00 $ 12,984.55 $ 11,514.00 0.14 Transportion & Electronics 2023 $ 9,591.00 $ 2,221.00 $ 11,718.16 $ 9,591.00 0.14 Health Care 2023 $ 7,431.00 $ 1,858.00 $ 9,038.62 $ 7,431.00 0.14 Consumer 2023 $ 5,151.00 $ 1,124.00 $ 7,145.44 $ 5,151.00 0.14
Tax Rate Debt Equity Interest RaCost of CapCurrent Liabilities 0.3 500000 500000 0.1 0.15 2265.18 0.3 500000 500000 0.1 0.15 1828.04 0.3 500000 500000 0.1 0.15 1510.12 0.3 500000 500000 0.1 0.15 2225.44 0.3 500000 500000 0.1 0.15 2397.72 0.3 500000 500000 0.1 0.15 2213.28 0.3 500000 500000 0.1 0.15 2858.82 0.3 500000 500000 0.1 0.15 1752.18
The new structure will be comprised of four business segments: Safety & Industrial, Transportation & Electronics, Health Care, and Consumer. Safety & Industrial: This segment includes businesses that serve the global industrial, electrical and safety markets. This business segment will consist of personal safety, adhesives and tapes, abrasives, closure and masking systems, electrical markets, automotive aftermarket, and roofing granules. This segment will have estimated annual revenue of $12 billion. Transportation & Electronics: This segment includes businesses that serve global transportation and electronic original equipment manufacturer (OEM) customers. This business segment will consist of electronics (display materials and systems, electronic materials solutions), automotive and aerospace, commercial solutions, advanced materials, and transportation safety. This segment will have estimated annual revenue of $10 billion. Health Care: This business segment serves the global healthcare industry and will include medical solutions, oral care, separation and purification sciences, health information systems, drug delivery systems, and food safety. This segment will have estimated annual revenue of $7 billion. Consumer: This business serves global consumers and consists of home improvement, stationery and office supplies, home care, and consumer health care. Home improvement will also include the retail auto care business that was previously a part of the company's automotive aftermarket business. This segment will have estimated annual revenue of $5 billion.
Uploaded by seanedwards229 on coursehero.com